Re: oracle server mode

"peter" <hhh.database_at_gmail.com> a écrit dans le message de news: 1163223803.146367.64500_at_m73g2000cwd.googlegroups.com...
| hi all,
| Please tell me how to identified which is oracle database mode. Through
| command prompt.
| Means "Dedicated" or "Shared"
|
| Thanks
|

Database is not in one mode or other.
Sessions can be connected in one mode or other:

SQL> select sid, username, server from v$session where type='USER' order by 1;

       SID USERNAME                       SERVER
---------- ------------------------------ ---------
       131 MICHEL                         SHARED
       139 SYSTEM                         DEDICATED
       159                                DEDICATED

You can check if shared mode is activated querying dispatchers and server parameters, for instance:

SQL> select name, value from v$parameter where name in ('max_dispatchers','max_shared_servers');

NAME                 VALUE
-------------------- ----------
max_shared_servers   3
max_dispatchers      1

Regards
Michel Cadot Received on Sat Nov 11 2006 - 00:25:00 CST