Oracle的共享服务
1.备份$ ps -ef | grep oracle | wc -l
75
2.
$ sqlplus system/Oracle2013@orcl1
SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 28 19:08:11 2014
Copyright (c) 1982, 2013, Oracle.All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
3.
SQL> select username,server from v$session where username='SYSTEM';
USERNAME SERVER
------------------------------------------------------------ ------------------
SYSTEM DEDICATED
4.
$ ps -ef | grep oracle | wc -l
80
5.
SQL> show parameter shared_servers
NAME TYPE VALUE
------------------------------------ ---------------------- -----------------------------
max_shared_servers integer
shared_servers integer 1
SQL> show parameter dispatchers
NAME TYPE VALUE
------------------------------------ ---------------------- -----------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=orcl1XDB)
max_dispatchers integer
$ cd /u01/app/oracle/product/11.2.0/db_1/dbs/
$ ls
hc_orcl1.dathc_orcl.datinit.orainitorcl1.oralkORCL1orapworcl1spfileorcl1.ora
$ vim initorcl1.ora
###########################################
# File Configuration
###########################################
control_files=("/u01/app/oracle/oradata/orcl/control01.ctl", "/u01/app/oracle/fast_recovery_area/orcl/control02.ctl")
db_recovery_file_dest="/u01/app/oracle/fast_recovery_area"
db_recovery_file_dest_size=4385144832
###########################################
# Miscellaneous
###########################################
compatible=11.2.0.4.0
diagnostic_dest=/u01/app/oracle
memory_target=843055104
###########################################
# Processes and Sessions
###########################################
processes=150
###########################################
# Security and Auditing
###########################################
audit_file_dest="/u01/app/oracle/admin/orcl/adump"
audit_trail=db
remote_login_passwordfile=EXCLUSIVE
###########################################
# Shared Server
###########################################
shared_servers = 2
dispatchers="(PROTOCOL=TCP) (DISPATHERS=2)"
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_tablespace=UNDOTBS1
页:
[1]