Re: v$session_longops

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_at_go-faster.co.uk>:
> 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
>
>
>

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