Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: dedicated/shared server mode
than cheng. You are right i can check if the system supports shared server
or not but my main question is to find the mode(shared/dedicated) for the
database. Say DB1 is up and running and i just have to decide the mode of
the database is the db is in :
This was the output when i checked V$SHARED_SERVER view
SQL> select * from v$shared_server
2 ;
NAME PADDR STATUS MESSAGES BYTES BREAKS CIRCUIT
---- -------- ---------------- ---------- ---------- ---------- -------- IDLE BUSY REQUESTS ---------- ---------- ---------- S000 1620F4BC WAIT(COMMON) 0 0 0 00 711597 0 0
However other two did not returned any rows.
On 1/17/06, Li-Shan Cheng <exriscer_at_gmail.com> wrote:
> 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
> >
>
>
-- 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-lReceived on Tue Jan 17 2006 - 05:18:28 CST
![]() |
![]() |