Re: [Q] Meaning of v$db_object_cache

You are correct this is a Library Cache view. I suspect the executions column output can be unrelaible, why not use V$SQLAREA -> EXECUTIONS, that's what I use.

Regards
David Russell

Jeroen van Sluisdam wrote in message <35FA6F2E.9EFEDAED_at_vrijuit.nl>...
>Hi,
>
>I have posted earlier questions about the db buffer. Not getting any
>answers
>I tried to look into the doc's one more time to look for maybe something
>I
>didn't see. Yes I found it v$db_obect_cache
>
>- Is this really an interpretation of the db buffer cache because the
>man. says
> library cache ?
>- the column executions is not used says the man. But when i execute a
>query on a table
> I sometimes see executions incremented (not all the times) Can i trust
>it and what does
> it really mean ?
>- any comment on column loads ?
>
>Thanks,
>
>Jeroen
>
Received on Sat Sep 12 1998 - 09:04:14 CDT