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 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...
Post your comment

Related Content

Follow us

▲