Database Administration (MOSC)

MOSC Banner

Temp space filling up and not releasing

edited May 4, 2011 1:57AM in Database Administration (MOSC) 2 commentsAnswered

 Hi ,        We are getting the following exception on our preproduction database server :

java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-06512: at "SYS.DBMS_XMLGEN", line 176
ORA-06512: at line 1

And we felt that we are hitting thr  Bug 5723140: TEMP SPACE NOT RELEASED AFTER COMMIT ON TABLE WITH XMLTYPE AND XSD

and the workaround would be

1) bounce the session to release the space.(it is not acceptable work around everytime)
or
2) alter session set event '60025 trace name context forever';

And the note stated that  ( How to Release the Temp LOB Space and Avoid Hitting ORA-1652 (

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