Home » RDBMS Server » Server Administration » How to check whether database is dedicated or shared (Oracle,10g,RHEL5)
How to check whether database is dedicated or shared [message #541905] Fri, 03 February 2012 02:19 Go to next message
kailas
Messages: 21
Registered: September 2011
Location: pune
Junior Member
How to check whether database is dedicated or shared ?
Re: How to check whether database is dedicated or shared [message #541906 is a reply to message #541905] Fri, 03 February 2012 02:28 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A database is not shared or dedicated.
A session use a shared or dedicated server.
In a database, sessions can use any available connection modes (dedicated is always there, the other ones are optional).
You can session which kind of server a session used query v$session.SERVER.

Regards
Michel
Previous Topic: how to copy rac database
Next Topic: Tablespace fragmentation
Goto Forum:
  


Current Time: Thu Apr 18 18:50:37 CDT 2024