【Oracle】共享服务器模式详解及配置 - 数据库编程

------------- ----------- ------------------------------

circuits integer

SYS@ORCL>alter system set circuits=5000;

System altered.

SYS@ORCL>show parameter large_pool

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

large_pool_size big integer 0

SYS@ORCL>alter system set large_pool_size=200M;

System altered.

配置完毕，现在来查看调度进程

SYS@ORCL>select name from v$dispatcher;

NAME

----

D000

D001

可以看到已经启动两个调度进程。

共享服务器模式下必须要配置tns才能进行连接。

[oracle@jp ~]$ cd /u01/app/oracle/product/10.2.0/db_1/network/admin/

[oracle@jp admin]$ ls

listener.ora samples shrept.lst tnsnames.ora

[oracle@jp admin]$ vi tnsnames.ora

link_test =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = jp)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = ORCL)

)

orcl_s=

(description =

(address = (protocol = tcp)(host = jp)(port = 1521))

(connect_data =

(server = shared)

(service_name = ORCL)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

TNS配置完成，下面通过共享服务器模式进行连接

[oracle@jp admin]$ sqlplus sys/oracle@orcl_s as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 3 06:57:03 2014

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SYS@orcl_s>select server from v$session;

SERVER

---------

DEDICATED

SHARED

DEDICATED

SERVER

---------

DEDICATED

22 rows selected.

存在shared，共享服务器模式配置成功。

找到本session对应的spid

SYS@orcl_s>select p.spid from v$session s,v$process p where s.sid=userenv('sid') and s.paddr=p.addr;

SPID

------------

16929

根据上面查出的结果可以看到对应的共享服务器进程

[root@jp ~]# ps -ef |grep 16929

oracle 16929 1 0 06:42 00:00:00 ora_s001_ORCL

root 17750 16529 0 07:01 pts/2 00:00:00 grep 16929

【Oracle】共享服务器模式详解及配置(二)