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 -- //www.freelists.org/webpage/oracle-l