Answer Detail: RE: What are the factors causing the reparsing of SQL ...

GeekInterview.com > Interview Questions > Oracle > Memory Management

Print |

Question: What are the factors causing the reparsing of SQL statements in SGA

October 10, 2005 16:02:47	#4
sandeep vig	Member Since: Visitor Total Comments: N/A
RE: What are the factors causing the reparsing of SQL ...
there are main two causes for reparsing 1)the objects which the query is refrencing has been modified 2) or the parsed version of sql text has been aged out of the library cache.