v$session_longops

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?  


regards
_________________________
David Kurtz

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

Follow-Ups:

Re: v$session_longops
From: Gints Plivna

CPU service, FETCH calls wait event
From: Jay.Miller

References:
- Re: Setup of Multiple Listeners on RAC ?
  - From: Greg Rahn

v$session_longops

Other related posts: