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