What are the factors causing the reparsing of SQL statements
in SGA?
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 ? | 0 Yes | 0 No |
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
who is the father of oracle and send chodd rules
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
how to find find & delete duplicate rows from two different tables?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
What is ADDM Advisor in Oracle?
How to select the name of employee who is getting maximum sal with out using subquery
What is background process in Oracle?
How to delete a column in an existing table in oracle?
Differentiate between TRUNCATE and DELETE?
what is view?
What is hot backup and logical backup?