 | | | v$session_longops | v$session_longops 2007-10-03 - By Gints Plivna
Back
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@(protected)>:
> 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
|
|
|