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 |
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
What is difference between SUBSTR and INSTR?
How to apply filtering criteria at group level in oracle?
What is a data lock in oracle?
What is the function of Optimizer ?
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is oracle thin client?
What is the sql query to concatenate column values from multiple rows in oracle?
how to truncate date and get only time part 9:20:00
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to see free space of each tablespace?