UNDO TABLESPACE GOING GROWTH Unexpectedly
Dear all,
My database version is 11.2.0.4 . MY undo tablespace is almost 99% used.
because, UNEXPIRED BLOCK is too a lot.
and the one query is not to close cursor which is the select query to use by DB LINKS.
so I asked to Developer how to solve the problem.. but they don't know.
this query is from API Call and batch process.
they can't stop because it takes almost 5days to finish the batch job.
but this query is called to save the batch data. so frequently to retry fetch to Database.
do you know how to handle in Database side?