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 |
how to join query for one source type is oracle another source type is sql server ?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
what is difference between sql plus and sql*plus? (not sql and sql plus).
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is the difference between oracle enterprise edition and oracle express edition?
How to view existing locks on the database?
What are the types of partitions in oracle?
Briefly explain what is literal? Give an example where it can be used?
what are actual and formal parameters?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
How to update a table row with a record?
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.