| Rollback Segments [message #64369] |
Wed, 19 January 2005 21:42  |
Roshan
Messages: 10
Registered: March 2000
|
Junior Member |
|
|
Hello,
What will be the Impact if I delete or drop Rollback Segment File. Eg. RBS01
How to reduce the Size of the SYSTEM1.DBF since it is occypying the Huge Physical Space in my Storage...
Hope to hear from you soon.
Thank you.
Best Regards,
Roshan
|
|
|
|
| Re: Rollback Segments [message #64370 is a reply to message #64369] |
Wed, 19 January 2005 23:31  |
Deepa
Messages: 269
Registered: November 2000
|
Senior Member |
|
|
To minimize system tablespace usage...
check whether any user's objects other than sys or system is present in the System tablespace
select distinct owner from all_tables where tablespace_name='SYSTEM' and owner not in ('SYS','SYSTEM');
and if present try to move it to different tablespace.
The impact of deleting a rollback segment (provided there are somemore also other than this) depends on the OLTP load of ur database.
|
|
|
|
| Re: Rollback Segments: There are Some USERS: [message #64376 is a reply to message #64370] |
Thu, 20 January 2005 01:34 |
Roshan
Messages: 10
Registered: March 2000
|
Junior Member |
|
|
Thank you so much for ur reply...
Well, I have some owners here like AURORA$JIS$UTILITY$
CAADMIN, MDSYS, MTSSYS, ORDSYS, OSE$HTTP$ADMIN, OUTLN. But my working User that I have been using for OLTP is CAADMIN.
Now, I want to reduce the size of the file SYSTEM1.DBF since it is occupying huge space.
Let me get help to reduce the file size...
And regarding the RBS, how to manage unnecessary spaces that is being occupied by this file in my physical storage...?
Thanks,
Best Regards,
Roshan Maharjan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
