What are the factors causing the reparsing of SQL statements
in SGA?
Answers were Sorted based on User's Feedback
Answer / sawant
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nishi
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
can any one help me with import/export options in oracle............
Is the After report trigger fired if the report execution fails ?
What is trigger associated with the timer ?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
Difference between join and a subquery?
8 Answers Base Automation, NMDC,
How to create an initialization parameter file?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
interview questions with answer for cts
how to find the second highest salary in a given table????
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
What is sequence?