tablespace usage [message #426646] |
Sat, 17 October 2009 19:10  |
Richard2009
Messages: 21 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.
|
|
|
Re: tablespace usage [message #426647 is a reply to message #426646] |
Sat, 17 October 2009 21:34  |
 |
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
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)
|
|
|