Jonathan Lewis has written an answer here about the maximum number of entries: http://www.mcse.ms/message1574958.html He said "The number of slots in v$session_longops for 9.2.0.6 seems to be the lower of 500 and 2 x the sessions parameter." Of course you can quite easily test whether it is relevant also for 10g for example. However I cannot say anything about the precise algorithm of reuse of entries. Gints Plivna http://www.gplivna.eu 2007/10/3, David Kurtz <info@xxxxxxxxxxxxxxx>: > 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 > > > -- //www.freelists.org/webpage/oracle-l