| oracle 8i undo table space [message #501117] |
Fri, 25 March 2011 23:14  |
ibanpaf
Messages: 11
Registered: September 2008
Location: peshawar pakistan
|
Junior Member |
|
|
hi to all i am using oracle 8i and my undo table space size is 3.5 gb and its take too much time when i am taking its backup.
so what can i do now.
|
|
|
|
|
|
| Re: oracle 8i undo table space [message #501133 is a reply to message #501117] |
Sat, 26 March 2011 02:57  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
With 8i, you don't have an undo tablespace: you have a tablespace in which you have created rollback segments. They will have grown to whatever size was needed. DBA_ROLLBACK_SEGS and V$ROLLSTAT will tell you how many you have, where they are, and information about how big they are and how often they have been expanded and shrunk.
You can try
ALTER ROLLBACK SEGMENT....SHRINK
to free up space, and you can set a lower OPTIMAL size so that they will shrink automatically.
|
|
|
|
| Re: oracle 8i undo table space [message #501138 is a reply to message #501126] |
Sat, 26 March 2011 03:46 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Paules wrote on Sat, 26 March 2011 07:47Hai,
Create a New Undo tablespace and make it as default. After that, if u restart the database, u can find the old undo tablespace free. So that u can get back the speed.
Regards,
paules.
Please read OraFAQ Forum Guide and DO NOT use IM/SMS speak.
In addition, read very carefully the question INCLUDING the version number. If you don't know Oracle in this version then do not answer, it is better than to give an irrelevant answer.
Regards
Michel
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
