What are the factors causing the reparsing of SQL statements
in SGA?
Answer Posted / 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 |
Post New Answer View All Answers
When do you get a .pll extension in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
How can windows applications connect to oracle servers?
How to create a single index for multiple columns?
What are the tools for Oracle ?
When do we use group by clause in a sql query?
What do you mean by a deadlock?
Explain coalesce function?
Why cursor variables are easier to use than cursors?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to define a procedure inside another procedure?
Are truncate and delete commands same? If so why?
How different is ms access and oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is a sub query? Describe its types?