How many memory layers are in the shared pool?
Answer / 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 |
How to define and use table alias names in oracle?
Will you be able to store pictures in the database?
what are archived logs?
What are the attributes that are found in a cursor?
What is ADDM Advisor in Oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Is it possible to enter only time value into a column of a table in sql?
What are the components of Physical database structure of Oracle Database?
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
Explain the use of grant option in exp command.
What are a query and state the different types of queries and their uses?
what is load balancing and what u have used to do this?(sql loader)