SQL> select count(*) from v$shared_server; COUNT(*) ---------- 1SQL> alter system set mts_servers=3 scope=both;系统已更改。SQL> desc v$shared_server; 名称 是否为空? 类型 ----------------------------------------- -------- ------------------------- NAME VARCHAR2(4) PADDR RAW(4) STATUS VARCHAR2(16) MESSAGES NUMBER BYTES NUMBER BREAKS NUMBER CIRCUIT RAW(4) IDLE NUMBER BUSY NUMBER REQUESTS NUMBERSQL> select count(*) from v$shared_server; COUNT(*) ---------- 3 还有: v$dispatcher
----------
1SQL> alter system set mts_servers=3 scope=both;系统已更改。SQL> desc v$shared_server;
名称 是否为空? 类型
----------------------------------------- -------- ------------------------- NAME VARCHAR2(4)
PADDR RAW(4)
STATUS VARCHAR2(16)
MESSAGES NUMBER
BYTES NUMBER
BREAKS NUMBER
CIRCUIT RAW(4)
IDLE NUMBER
BUSY NUMBER
REQUESTS NUMBERSQL> select count(*) from v$shared_server; COUNT(*)
----------
3
还有: v$dispatcher
http://www.cnoug.org/viewthread.php?tid=50890
SQL> select username,server from v$session;USERNAME SERVER
------------------------------ ---------
DEDICATED
DEDICATED
DEDICATED
DEDICATED
DEDICATED
DEDICATED
SYS DEDICATED或者用
select * from v$dispatcher;或
select * from v$shared_server;有记录则表示使用了MTS模式。或者在企业管理器的例程里查看也是可以的
要修改模式用以下方法:
主要流程:
1.修改初始化参数
2.shutdown oracle
3.restart oracle参数主要有2个:
如果你用的是SPFILE,你可以用ALTER SYSTEM命令修改系统的DISPATCHERS和SHARED_SERVERS参数,如果你用的是PFILE,则需要手工修改DISPATCHERS和SHARED_SERVERS参数。