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

Which environment variables are absolutely critical in order to run the OUI?

1876


How to write date and time interval literals in oracle?

746


what is Single Byte Overhead...?

2262


How to pass a cursor variable to a procedure?

765


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1914


List the parts of a database trigger.

767


Explain do view contain data?

758


What is enter substitution variable in oracle?

766


How to commit the current transaction in oracle?

772


What is a tns file?

709


What is rowid and rownum in oracle?

757


What are the types of partitions in oracle?

751


What are named parameters?

778


How to insert multiple rows with one insert statement in oracle?

769


What is a user account in oracle?

839