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