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
Explain the use of online redo log files in oracle.
What is an oracle wallet?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
Explain the use of record length option in exp command.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to execute a stored program unit?
Can we write insert statement in function in oracle?
How to use existing values in update statements using oracle?
What are the tools for Oracle ?
What is a relational database management system?
how the indexes are stored in the Oracle Database?
How to create a table index in oracle?
State the difference between a primary key and foreign key?
How to build data dictionary view an new database?