Database Memory & 4030/4031 (MOSC)

MOSC Banner

Question on ora-63999

edited Dec 22, 2014 11:32PM in Database Memory & 4030/4031 (MOSC) 5 commentsAnswered


New to this Community...

If question is not for this space, please point me to the right direction

We encountered a production database crash with ORA-63999 error;

When reproduced the problem in the testing env, the observation we have on an user session which running a particular process, monitor v$tempseg_usage, there is LOB_DATA type keep growing to say 3GB, the tempfile, with current size say only 10M (sparse file, newly created for the test) sitting on a filesystem with only, say 2GB; The tempfile didnot grow, until we did "alter system flush buffer_cahe"; the tempfile start to grow, until it consumed all the remaining 2GB of the filesystem and then DBWR crashed which in turn bring down the database instance.

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