Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> v$db_object_cache ????

v$db_object_cache ????

From: Ed Lufker <elufker_at_shimi.swcp.com>
Date: 13 Dec 2001 20:43:45 GMT
Message-ID: <9vb3u1$44c$1@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

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. Received on Thu Dec 13 2001 - 14:43:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US