dictionary cache

From: utkanbir <hopehope_123_at_yahoo.com>
Date: 31 May 2004 03:32:59 -0700
Message-ID: <f6c90ebe.0405310232.2cd4b11b@posting.google.com>

Hi everbody ,

if i look at the sums ratio in v$rowcache , i have a very good disctionary cache get ratio:
SELECT 1 - (SUM(getmisses)/SUM(gets))
"Data Dictionary Hit Ratio"
FROM v$rowcache;

result is :0.99

but if i look at individual entries , i see low values for some objects such as dc_sequences:

select *
from v$rowcache where parameter='dc_sequences' order by getmisses desc :

CACHE#	TYPE	SUBORDINATE#	PARAMETER	COUNT	USAGE	FIXED	GETS	GETMISSES	SCANS	SCANMISSES	SCANCOMPLETES	MODIFICATIONS	FLUSHES	DLM_REQUESTS	DLM_CONFLICTS	DLM_RELEASES
13	PARENT		dc_sequences	28	28	0	752908	70790	0	0	0	752908	752908	1195103	70714	49

Is this a problem? According to the manual , individual misses should be less than <%2 , here it is %10???

Any help will be appreciated,
Kind Regards,
hope Received on Mon May 31 2004 - 05:32:59 CDT