You can investigate parameter settings using show parameter <some relevant
substring> in sqlplus when logged in with a dba account. so for example to
show dump directories you might use show parameter dest. In the case of
shared servers the parameters you need are for Multi-Threaded Server or MTS.
show parameter mts will show you what the relevant parameters are set to at
the database level. if there are no dispatchers you will be using a
dedicated server process. If however you do have some shared servers running
its a little more complex since it is actually the client that requests
shared or dedicated connections and if all the clients request dedicated
connections....
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Ray" <rwestphal_at_erac.com> wrote in message
news:f6336c9e.0403260907.45115ea_at_posting.google.com...
> Hello.
> I'm really new to Oracle DB administration so please be patient. I'm
> trying to duplicate an existing database on another server. I'd like
> to know how to determine which server mode my current database is
> running.
>
> The DBCA Database Connection Options Help screen does a good job of
> explaining the reasoning for dedicated or shared server modes.
> However, it does not explain how to determine current settings. (Of
> course - it is trying to create a new DB so why should it care?) I
> looked at the spfile via OEM, I checked the "ora" files and I have
> read through the Installation Guide and lots of Google threads.
>
> Thanks in advance.
>
> Ray W.
Received on Fri Mar 26 2004 - 14:46:28 CST
