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?

Thanks In advance.