I have executed one procedure which is updating partition tables's field with sequence. But i am commiting after each and every update of table. Table contains records at the most 5 lacs but still Undo tablespace is drastically down. My database has 15 GB undo tablespace and its undo_retention period is 3 hrs. Undo_tablespace is showing me that it has 30MB free. Undo tablespace is down 500 mb per minute. Please guide me for how to get back undo space.
One troubleshooting steps is that we had restarted our server. but after restart it is showing only 2 GB out of 15 GB. How do i find remaining 13 GB undo tablespace status?
Can anyone suggest troubleshooting steps. Is there some parameter should I have to take care? It will be greatfull if some one is provide suggestions on urgent basis.
Thanks in advance.