oracle9i dedicated server->mts模式？

Question

oracle9i dedicated server->share server模式，init文件和listener文件修改后，还要做什么其它配置？数据库重启后从哪里看得出来？

Answer 1

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

Answer 2

还有这里：
http://www.cnoug.org/viewthread.php?tid=50890

Answer 3

用select username,server from v$session;查看是共享还是专用模式
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参数。