|
-
SQL> show parameter server
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_server string
max_shared_servers integer 20
mts_max_servers integer 20
mts_servers integer 0
parallel_max_servers integer 5
parallel_min_servers integer 0
parallel_server boolean FALSE
parallel_server_instances integer 1
rdbms_server_dn string
shared_server_sessions integer 0
shared_servers integer 0
SQL> select * from v$mts;
MAXIMUM_CONNECTIONS MAXIMUM_SESSIONS SERVERS_STARTED SERVERS_TERMINATED SERVERS_HIGHWATER
------------------- ---------------- --------------- ------------------ -----------------
0 0 0 0 0
SQL> select server, count(*) from v$session group by server;
SERVER COUNT(*)
--------- ----------
DEDICATED 54
Is this enough to determine that it is not MTS?
And what is connection pooling? Is it done at the OS level or DB level.
Thanks, ST2003
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|