From: fbortel@home.nl   
      
   buky wrote:   
   > How can I find and set an idle time when oracle database releases some   
   > objects (tables, etc.) or opened sessions?   
   >   
      
   Why would one want to SET an idle time? It's "improve my performance"   
   all over the place, and you want idle time?   
      
   Does Oracle release tables? Were they caught then? In what?   
      
   In short - it's absolutely unclear what you want, so don't   
   expect answers. Tkprof/exaplain plan does have some info   
   on recursive sql (the "internals" stuff), if that's what   
   you want to explore.   
   --   
   Regards, Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)