Re: dedicated/shared server mode
- From: Li-Shan Cheng <exriscer@xxxxxxxxx>
- To: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
- Date: Tue, 17 Jan 2006 12:23:28 +0100
The problem is a database can have both DEDICATED and SHARED mode as you
already know, it´s not like ARCHIVE or NOARCHIVE mode which it must be one
or another.
You can also query v$dispatcher, if there are dispatchers then you must have
shared server set up!
On 1/17/06, Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx> wrote:
>
> 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 :
>
> 1) archive /no archive log mode -- quite easy to check and i have
> *2) dedicated/shared --- confused for how to check this one*
>
> 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@xxxxxxxxx> 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@xxxxxxxxx > 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@xxxxxxxxxxxx > 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@xxxxxxxxx
> > > onkarnath.tiwary@xxxxxxxxx
> > >
> >
> >
>
>
> --
> Thanks & Regards,
> T. Onkar Nath
> OneAPPS Enterprise Technology Pvt. Ltd.
> to_onkar@xxxxxxxxx
> onkarnath.tiwary@xxxxxxxxx
>
Other related posts:
