What are the factors causing the reparsing of SQL statements in SGA? - Due to insufficient Shared SQL pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio is greater than 1 then increase the SHARED_POOL_SIZE. LOGICAL & PHYSICAL ARCHITECTURE OF DATABASE. - Memory Management Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

MEMORY MANAGEMENT

DETAILS

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

Answer: Due to insufficient Shared SQL pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio is greater than 1 then increase the SHARED_POOL_SIZE.
LOGICAL & PHYSICAL ARCHITECTURE OF DATABASE.

Category	Memory Management Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 8648 users
Added on	10/27/2009
Views	73544
Rate it!

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

Answer:

Due to insufficient Shared SQL pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio is greater than 1 then increase the SHARED_POOL_SIZE.
LOGICAL & PHYSICAL ARCHITECTURE OF DATABASE. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What is Database Buffers ?	View Answer
	What is dictionary cache ?	View Answer
	What is meant by recursive hints ?	View Answer
	What is meant by redo log buffer ?	View Answer
	How will you swap objects into a different table space for an existing database ?	View Answer
	List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?	View Answer
	How will you force database to use particular rollback segment ?	View Answer
	What is meant by free extent ?	View Answer
	How free extents are managed in Ver 6.0 and Ver 7.0 ?	View Answer
	Which parameter in Storage clause will reduce no. of rows per block?	View Answer
	What is the significance of having storage clause ?	View Answer
	How does Space allocation table place within a block ?	View Answer
	What is the role of PCTFREE parameter is Storage clause ?	View Answer
	What is the OPTIMAL parameter?	View Answer
	What is the functionality of SYSTEM table space ?	View Answer
	How will you create multiple rollback segments in a database ?	View Answer
	How the space utilization takes place within rollback segments ?	View Answer
	Why query fails sometimes ?	View Answer
	How will you monitor the space allocation ?	View Answer
	How will you monitor rollback segment status ?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Memory Management Interview Questions & Answers - Exam Mode / Learning Mode