How would you go about increasing the buffer cache hit ratio?
Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary then I would use the alter system set db_cache_size command.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Explain what are componentbuffer and databuffer? 17.11.08
Component Buffer: Component Buffer contains all the Data of active component Data Buffer: Data Buffer contains Data other then the Data in the Component Buf...Explain what are componentbuffer and databuffer? 17.11.08
Component Buffer: Component Buffer contains all the Data of active component Data Buffer: Data Buffer contains Data other then the Data in the Component Buf...What is Cache Coherency? 10.11.08
Cache coherence refers to the integrity of data stored in local caches of a shared resource . Cache coherence is a special case of memory coherence. When clien...Whats the difference between L1 and L2 cache? 10.11.08
Level 1 cache is internal to the chip, L2 is external. L1 (level 1) cache - L1 cache stores information for use by the processor. L1 cache is extremely quick b...What is Cache Coherency? 03.11.08
Cache coherence refers to the integrity of data stored in local caches of a shared resource. Cache coherence is a special case of memory coherence. When clients...What is Cache Coherency? 06.10.08
Cache coherence refers to the integrity of data stored in local caches of a shared resource. Cache coherence is a special case of memory coherence. When clients...What is meant by recursive hints? 08.05.08
Number of times processes repeatedly query the dictionary table is called recursive hints. It is due to the data dictionary cache is too small. By increasing th...Explain an ORA-01555. 06.08.06
You get this error when you get a snapshot too old within rollback. It can usually be solved by increasing the undo retention or increasing the size of rollback...What’s the difference between L1 and L2 cache? 19.07.06
Level 1 cache is internal to the chip, L2 is external. L1 Cache is of Higher speed than that of L2 Cache....What is global assembly cache? 14.03.06
Each computer where the common language runtime is installed has a machine-wide code cache called the global assembly cache. The global assembly cache stores as...