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
types of indexes and the rationale behind choosing a particular index for a situation.
What is snapshot is too old? Give and example for better understand.
What is a parameter file in oracle?
How to Truncate Table in Oracle
Explain what are the type of synonyms?
How many categories of data types?
Describe an oracle table?
How to drop an existing table in oracle?
What are temporal data types in oracle?
What is a proxy object?
How to write a query with an inner join in oracle?
How to call a stored function with parameters?
What are the different types of record groups in oracle? Explain each of them
what is meant by magic query
Can you create a synonym without having a table?
