|
配置参数:
SQL> show parameter shared;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
max_shared_servers integer 4
shared_memory_address integer 0
shared_pool_reserved_size big integer 17616076
shared_pool_size big integer 0
shared_server_sessions integer 200
shared_servers integer 1
SQL> show parameter dispatch ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=tcp)(DISPATCHERS=4)(POOL=on)(TICK=3)(CONNECTIONS=500)
(SESSIONS=1000)
max_dispatchers integer 4
用pl/sql developer 连接:
SQL> connect test/test@BANK_shs ;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
Connected as test
SQL> select distinct sid from v$mystat;
SID
----------
158
可以看到为SHARED模式。
SQL> select sid,server,machine from v$session where sid=158;
SID SERVER MACHINE
---------- --------- ----------------------------------------------------------------
158 SHARED BANK
SQL>
但是用同样的服务名连接,启动一个测试程序:
SQL> select sid,machine ,server ,program from v$session where PROGRAM='test.exe';
SID MACHINE SERVER PROGRAM
---------- ------------------------- --------- ------------------------------
146 BANK NONE test.exe
为什么连接后的 SERVER为NONE 而不是SHARED ? |
|