ORA-1652: unable to extend temp segment by 38400 in tablespace
ORA-1652: unable to extend temp segment by 38400 in tablespace MST.
How to resolve the above error. This error populating very frequently in alert.log. The mentioned tablespace is categorized as permanent tablespace. How to find out which segment is causing the problem. MST tablespace is enough free space.
Originally posted by hacketta1 It might be helpful to put the following in init.ora and restart the database:
EVENT="1652 TRACE NAME ERRORSTACK LEVEL 3"
This will generate a trace file each time ORA-01652 occurs. The trace file should contain the offending SQL.
I can not restart the database 24/7. I have used
alter system set events '1652 trace name errorstack level 3'. But no trace files have been generated. What could be the problem. Do I need to use dbms_system.set_ev?