|
-
Undo tablespace
Hi,
could you please explain further the various status of the Undo
MB STATUS
---------- ---------
64 ACTIVE
4858.32031 EXPIRED
23716.0781 UNEXPIRED
In the case of delete, which is okay for deletion.
I have a challenge, my UNDOTBS usage suddenly went high and had about 1% space left which consistently has been of 95% free. I have tried to really track the very process utilising the entire space but none. When it was 1%, I had my RMAN backup running but when it was concluded, I could only see a difference of 5%.
What do you think could have gone wrong as there was no change in the application nor process
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|