Answer Posted / sawant
The data dictionary cache is stored in an area in SGA called
the Shared SQL Pool. This will allow sharing of parsed
SQL statements among concurrent users.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain the use of log option in exp command.
why dont we assign not null constraint as table level constraint.
How to change user password in oracle?
what is the difference between substr and instr function in oracle?
What is a table in oracle?
Can we commit inside a function in oracle?
State and explain the different types of data models?
What are the attributes of cursor?
What is tns entry?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What is ASM (Automatic Storage Management) in Oracle?
How to filter out duplications in the returning rows using oracle?
Why is oracle database so popular?
what is IDE,DMV in sql server?
How to delete a column in an existing table in oracle?