How many memory layers are in the shared pool?

Answer Posted / md mubeen

Shared pool buffers cache consists of two layer
1)Library cache (LC) 2) Data dictionary cache (DDC)
in the Library cache the parsed information data will be
stored 2)DDC contains the dictionary tables which stores
the meta data information .

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I know if oracle is installed on windows?

495


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1476


Explain the use of Merge statement in oracle 11g

602


What is the difference between a hot backup and a cold backup in oracle?

583


How to convert dates to characters in oracle?

587






Can we protect our pl/sql source code?

584


Explain the use of record length option in exp command.

566


Name the three major set of files on disk that compose a database in Oracle?

639


How to invoke the data pump import utility?

657


How to create a new table by selecting rows from another table?

561


What is a tns file?

508


What is a sub query and what are the different types of subqueries?

634


Why do we need integrity constraints in a database?

596


What is the difference between 10g OEM and 11g OEM?

567


How to compare dates in oracle sql?

667