Re: dedicated/shared server mode

look

v$mts
v$circuit
v$shared_server

but anyway if you see v$session.server and there are sessions which says SHARED then obviously your database supports Shared Server

On 1/17/06, Onkar N Tiwary <onkarnath.tiwary_at_gmail.com> wrote:
>
> Thanx a lot johan for the quick reply. This is sure will give us the
> database mode but it could be confusing in a situation where database is
> running in shared server mode but certain users have been given dedicated
> connections. Am I right or wrong??????
>
> On 1/17/06, johan Eriksson <johan.eriksson_at_bossmedia.se> wrote:
> >
> > Could be better views to look for this, but v$session reports what each
> > session has.
> >
> > select username, server, status from v$session
> >
> > /Johan
> >
> > On Tue, 2006-01-17 at 12:41 +0530, Onkar N Tiwary wrote:
> > > Hi,
> > >
> > > I just wanted to know the mode of the database if its a dedicated or
> > > shared server mode. which data dictionary shall i use?????
> >
> >
>
>
> --
> Thanks & Regards,
> T. Onkar Nath
> OneAPPS Enterprise Technology Pvt. Ltd.
> to_onkar_at_yahoo.com
> onkarnath.tiwary_at_gmail.com
>

--
http://www.freelists.org/webpage/oracle-l