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
What are the various oracle database objects?
What is materialized view in Oracle?
When do we use group by clause in a sql query?
What is object data modeling?
What happens if you lost a data file?
How to upsert (update or insert into a table)?
What is a schema in oracle?
What privilege is needed for a user to delete rows from tables in another schema?
Can a formula column referred to columns in higher group ?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How to generate query output in html format?
How to export several tables together?
What privilege is needed for a user to insert rows to tables in another schema?
 What are the oracle DML commands possible through an update strategy?
How to write a query with a left outer join in oracle?