Answer / orawhiz
Number of times processes repeatedly query the dictionary
table is called recursive hints. It is due to the data
dictionary cache is too small. By increasing the
SHARED_POOL_SIZE parameter we can optimize the size of Data
|Is This Answer Correct ?||0 Yes||0 No|
What is a Multi-threaded Server Configuration?
What is the functionality of SYSTEM table space ?
What is the function of checkpoint(CKPT)?
When Does DBWR write to the database?
What are disadvanteges of having raw devices ?
What is PGA?
What are functions of PMON?
What is meant by redo log buffer ?
Teradata: How can we know the indexed column in a table?
What do Redo Log Buffers contain?
What is an oracle database schema?
What is an Oracle Data Block?