What is the cache hit ratio?

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

When the cache client like a CPU, web browser etc finds a successful entry in the cache memory, it is called as a cache hit. The percentage of these successful cache hits is called as cache hit ratio. Higher the cache hit ratio better will be the performance because data read from the cache is faster than the memory.
Concept of the DUAL table
DUAL table - On installing Oracle database, DUAL table Is present by default. It is a special table with just one row.....
What are the ways tablespaces can be managed and how do they differ?
What are the ways tablespaces can be managed? - Objects can be assigned to a table space. The related objects can be then grouped together...
Explain what are Oracle Catalog and Oracle Archive log
Explain what are Oracle Catalog and Oracle Archive log - Oracle catalog contains tables and views to get information about the database...
Post your comment