What is dictionary cache ?
Answers were Sorted based on User's Feedback
Answer / vivek
it is a part of shared pool which contains most recently
used dictionary data like priviledges, objects,
users,packages....
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ravi dutta.
it is a component of SGA. this is used to check the syntax
and the semantics of the query.
| Is This Answer Correct ? | 1 Yes | 3 No |
How does Space allocation table place within a block ?
What is a Rollback segment entry ?
What is the function of Lock (LCKn) Process?
What are the functions of SMON?
what is the role of archiever
1.Explain the three levels with the help og a diagram.
What is the function of checkpoint(CKPT)?
How will you swap objects into a different table space for an existing database?
How will you create multiple rollback segments in a database ?
How the space utilisation takes place within rollback segments?
What is meant by redo log buffer ?
What is a Control file ?