Oracle Performance

Under Oracle 6, we could set the values for the various dictionary cache parameters. Under Oracle 7, they have all been grouped under SHARED_POOL_SIZE. 1 - What is the algorithm used in determining the variuos DC_* values? 2 - Is there any way to influence this determination? In general, and for specific parms?

In doing some monitoring, looking at V$ROWCACHE, and have seen certain parms with a greater than 40% miss ratio. Maybe this is not bad -- comments are welcome. But it would seem that it would be and that we would be allowed to influnce it.

An example:(hope this table comes out looking ok)

    Parm COUNT USAGE GETS GETMISSES MissRatio

dc_tablespace_quotas	19	18	3336	2193		65.737%
dc_constraints		20	19	1900	1003		52.789%
dc_used_extents		199	151	14722	5868		39.859%
dc_constraint_defs	117	40	1027	195		18.987%

These particular parms stay with this high miss ratio consistently. I would think that three of these may not matter due to the small numbers. But what about dc_used_extents? Or am I missing something. We do have another database that the dc_constraints gets and getmisses are in the 10's of thousands.

Help?

-- 
Robert Hatcher (Database Support) 	rhatcher_at_freenet.scri.fsu.edu
Southern Company Services		"I'm growing older but not up!"
Atlanta (404)668-3329