v$session_longops

I've been looking at v$session_longops and I have a couple of questions, and
I am hoping somebody can give me a hint.

There appears to be a maximum number of entries retrieved by the view.  What
determines this number?

Entries stay in the view long after sessions terminate, until the slots are
needed for reuse.  It appears that they are not reused in the same order in
which they were created.  It is not the oldest entry that is purged.  What
determines which slots are reused?  


regards
_________________________
David Kurtz

--
http://www.freelists.org/webpage/oracle-l


Other related posts: