What is dictionary cache ?
Answers were Sorted based on User's Feedback
Answer / cinnaraja
Once the database server has accessed the table from the
datafile , it places that information in the data-dictionary
cache in shared memory.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sawant
Dictionary cache is information about the databse objects
stored in a data dictionary table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why cursor variables are easier to use than cursors?
What happens to the current transaction if the session is ended?
What is a Shared SQL pool ?
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
select * from emp what happened internally when we write this query in the sql prompt?
query to find the maximum no persons with same age(age colomn) from emp table
How to load data through external tables?
pls explain connect by prior with example and its real time use
What is a View ?
what is dynamic SGA and static SGA
Why do we need integrity constraints in a database?
How to call a stored function with parameters?