What is meant by recursive hints ?

Question Posted / guest

1 Answers
4573 Views
I also Faced
E-Mail Answers

What is meant by recursive hints ?..

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
Dictionary Cache.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Architecture Interview Questions

How can you find the size of a database?

5 Answers Baidu, HCL,

What are the two types of Server Configurations?

3 Answers

How the log writer writes the data into database

4 Answers Baidu, Satyam,

What is a Rollback segment entry ?

3 Answers TCS,

What is User Process?

1 Answers

What Does DBWR do?

2 Answers Honeywell,

What are the consideration at tehe migration of Oracle 9i to 10G.

0 Answers Baidu,

What is the function of checkpoint(CKPT)?

4 Answers

How the space utilisation takes place within rollback segments?

2 Answers

What is an Oracle Data Segment?

0 Answers

How will you monitor the space allocation ?

3 Answers

Diference between Oracle 9i and 10G.

2 Answers Baidu,

For more Oracle Architecture Interview Questions Click Here