How many memory layers are in the oracle shared pool?
How many memory layers are in the oracle shared pool? Explain them.Oracles shared pool consists of two layers namely, Library cache and Data dictionary cache.
Library cache: This layer has information about SQL statements that were parsed, information about cursors and any plan data.
Data Dictionary cache: this Layer has information about the accounts of the users, their privileges and segments information.
|
What is the cache hit ratio?Cache hit ratio - 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...
Concept of the DUAL tableDUAL table - On installing Oracle database, DUAL table Is present by default. It is a special table with just one row.....