Database Administration (MOSC)

MOSC Banner

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center