Home » RDBMS Server » Server Administration » Process associated with Database
Process associated with Database [message #250819] Wed, 11 July 2007 07:39 Go to next message
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
Re: Process associated with Database [message #250823 is a reply to message #250819] Wed, 11 July 2007 08:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Process associated with Database [message #250847 is a reply to message #250823] Wed, 11 July 2007 10:05 Go to previous message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi Michel,

Thank you for your answer it helped me a lot.

Regards,
Naveen
Previous Topic: users
Next Topic: Resizing of Redologs
Goto Forum:
  


Current Time: Mon Dec 05 19:14:55 CST 2016

Total time taken to generate the page: 0.08874 seconds