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
Received on Tue Jan 17 2006 - 04:45:20 CST
