• From: "David Kurtz" <info@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 2 Oct 2007 22:10:18 +0100

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?  

David Kurtz


Other related posts: