What is meant by recursive hints ?

Login | Sign Up


	To Refer this Site to Your Friends Click Here

Categories >> Software >> Databases >> Oracle >> Architecture

I also faced this Question!!		Rank	Answer Posted By
Question	What is meant by recursive hints ?
Question Submitted By :: Guest

	Re: What is meant by recursive hints ?
Answer # 1	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.	0	Orawhiz

Question	Asked @	Answers
Other Architecture Interview Questions


How the space utilisation takes place within rollback segments?		1
What do Redo Log Buffers contain?		1
How will you swap objects into a different table space for an existing database?		1
What is the significance of having storage clause ?		1
Which parameter in Storage clause will reduce no. of rows per block?		1
What is Dedicated Server Configuration?		1
How free extents are managed in Ver 6.0 and Ver 7.0 ?		1
What is Server Process?		1
What is a Rollback segment entry ?	TCS	3
What is the functionality of SYSTEM table space ?		2
What are the two types of Server Configurations?		1
How will you monitor the space allocation ?		2
How does Space allocation table place within a block ?		1
What are disadvanteges of having raw devices ?		1
Why query fails sometimes ?		1
What are functions of PMON?		2
What Does DBWR do?		2
what is ORACLE MEMORY STRUCTURES		1
What are the components of SGA?		1
What is dictionary cache ?		2

For more Architecture Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com