Re: v$db_object_cache ????

Ed Lufker <elufker_at_shimi.swcp.com> wrote in message news:<9vb3u1$44c$1_at_sloth.swcp.com>...
> Hi All:
>
> I am doing the following select on v$db_object_cache. Please look at the
> last line there is no owner, but 17093 for count, blank ownwer. Does
> anyone know what the 17093 represents?????????? There is no owner, does it
> mean there are object in the cache that have no owner?????????
>
> Thanks in advance form any help here.
> Eddie Lufker
>

The owner Null Rows are Cursors....

They can be seen by issuing this query...

select owner,type, count(*) from v$db_object_cache group by owner, type;

There is something there called NotLoaded which i am not sure what it is and there is no mention of it in the Docs.

Hope Somebody throws light on that.

>
> SVRMGR> select owner , count(*) from v$db_object_cache group by owner;
> OWNER COUNT(*)
>
> ANAKIE
> 1
> ANANTHT6
> 1
> BAAN
> 2291
> BOBBRA
> 1
> BSP
> 1
> CARSPR99
> 1
> CHRALA
> 1
> HARPAR
> 1
> KAMDES
> 1
> KOTKAK
> 1
> NAGTIW
> 1
> NARKOR
> 1
> PADRADD6
> 1
> PGUPTE
> 1
> PHUTRIT5
> 1
> PSAMANTA
> 1
> PUBLIC
> 26
> RAIKOH
> 1
> RAJMEN
> 1
> RAJSAL
> 1
> RAMMAN
> 1
> RAMMAND6
> 1
> RAVPUL
> 1
> SPOT
> 31
> SRISAN
> 1
> SYS
> 200
> SYSTEM
> 5
> TAPCHA
> 1
> VINRAI
> 1
>
> 17093
> 30 rows selected.

Regards,
Ganesh R Received on Fri Dec 14 2001 - 23:56:05 CST