OraFAQ Forum: Server Administration » Process associated with Database

Home » RDBMS Server » Server Administration » Process associated with Database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Process associated with Database [message #250819]

Wed, 11 July 2007 07:39

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi,

Can any one tell is there any view so that we can know whether Database is running in Dedicated Server environment or Shared Server environment?

Regards
Naveen

Report message to a moderator

Re: Process associated with Database [message #250823 is a reply to message #250819]

Wed, 11 July 2007 08:08

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is not database, it is session, see v$session.server.

SQL> select distinct server from v$session;
SERVER
---------
DEDICATED

1 row selected.

Regards
Michel

Report message to a moderator

Re: Process associated with Database [message #250847 is a reply to message #250823]

Wed, 11 July 2007 10:05

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi Michel,

Thank you for your answer it helped me a lot.

Regards,
Naveen

Report message to a moderator

Previous Topic:	users
Next Topic:	Resizing of Redologs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 06:30:10 CST 2024