oracle 8i undo table space [message #501117] |
Fri, 25 March 2011 23:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ibanpaf
Messages: 11 Registered: September 2008 Location: peshawar pakistan
|
Junior Member |
![ibanpaf%40yahoo.com](/forum/theme/orafaq/images/yahoo.png)
|
|
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
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
|
|
|
|