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 ?

Report message to a moderator

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: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 16 22:34:02 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.