Re: DBCA Connection Options - How to determine an existing server mode?

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:40649699$0$24211$cc9e4d1f_at_news.dial.pipex.com...
> 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.

Well, they would do if Oracle 9 still referred to it as MTS, but since it doesn't, it won't!!

In 9i, it's just DISPATCHERS (not mts_dispatchers) and SHARED_SERVERS (not mts_shared_servers).

So unfortunately, you have to know the parameters in 9i before you can check on them.

Regards
HJR
> 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 - 15:23:30 CST