Members   Search   Help    Register    Login   Home
Home » Server Options » RAC & Failsafe » tablespace usage (Oracle 11g)
tablespace usage [message #426646] Sat, 17 October 2009 19:10 Go to next message
Richard2009
Messages: 5
Registered: October 2009
Location: London
Junior Member
Hi ,

How would you calculate the tablespace usage in a RAC environment? Let's say two instances are there for a database then the
total space usage = tablespace usage on instance 1 + tablespace usage on instance 2

Please advice.
Report message to a moderator
Re: tablespace usage [message #426647 is a reply to message #426646] Sat, 17 October 2009 21:34 Go to previous message
Mahesh Rajendran
Messages: 9793
Registered: March 2002
Location: oracleDocoVille
Senior Member
tablespace is logical. Datafiles are physical and they are stored across both instances. The database storage is shared across all instances.
So,
total space usage = tablespace usage (on any instance)
Report message to a moderator
Previous Topic:Identify IP address of AIX server on Oracle RAC
Next Topic:CRS not starting up
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 30 19:42:48 CST 2009

Total time taken to generate the page: 0.22835 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.