v$session_longops

From: David Kurtz <info_at_go-faster.co.uk>
Date: Tue, 2 Oct 2007 22:10:18 +0100
Message-ID: <00fb01c80538$a3d98c30$0a0a0a0a@GOFASTER4>

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

Received on Tue Oct 02 2007 - 16:10:18 CDT