From: f.hinlopenat@home.nl   
      
   Paul,   
      
   This is a golden oldie in Oracle - just do a Google search. As I understand   
   it as a developer, it is not unusual for TEMP to be running at 99% usage,   
   since the space is usually reclaimed on demand or through a process that   
   wakes up every hour or so.   
      
   Given the circumstance that it only happens in one app, I expect it to be a   
   suboptimal query that is doing a superfluous join/sort whatever. It happened   
   to me once too:   
   Me: "My program sometimes crashes with ORA-01652 ".   
   DBA: "There's something wrong with your program".   
   Me (arrogantly): "Writing optimal and correct Oracle SQL queries has become   
   second nature to me".   
   DBA: "There's still something wrong with your program".   
   Me (after some research, shamefaced): "I found a non-optimal query in my   
   program that caused a Cartesian join".   
      
   Just use a tool like PL/SQL Developer or TOAD or one of the others to easily   
   explain plan your queries.   
      
   Regards,   
   Frans   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)