| rbs space [message #54671] |
Tue, 26 November 2002 19:52  |
shareef
Messages: 72
Registered: November 2002
|
Member |
|
|
dear dba gurus
can help me to know the rbs space.
thanking u
|
|
|
|
| Re: rbs space [message #54676 is a reply to message #54671] |
Wed, 27 November 2002 03:57  |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
can U explain ???
U can use dba_rollback_segs, v$rollname, v$rollstat to see all information on rbs ...
|
|
|
|
| Re: rbs space [message #54688 is a reply to message #54671] |
Wed, 27 November 2002 14:17 |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Run this query to get RBS size:
SQL> SELECT a.name, b.extents, b.rssize
2 FROM v$rollname a, v$rollstat b
3 WHERE a.usn = b.usn;
NAME EXTENTS RSSIZE
------------------------------ ---------- ----------
SYSTEM 9 745472
RBS0 4 4186112
RBS1 10 10477568
RBS2 200 209707008
RBS3 10 10477568
RBS4 10 10477568
RBS5 4 4186112
RBS6 8 33546240
RBS7 8 33546240
RBS8 8 33546240
RBS9 8 33546240
If you need some other rollback segment scripts, you might want to check Here or Here .
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
