What are the factors causing the reparsing of SQL
statements in SGA?
Answer Posted / guest
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
What are the four objectives of the selection of a data type?
What is computer end?
What is the function of DML Compiler?
Is dynamodb a document database?
What do you mean by checkpoints in dbms?
Which database is best for large data?
Which is the best free database software?
In which format image is stored in database?
What integrity rules exist in the dbms?
What are the disadvantages of a query?
Is sql a database?
What is a checkpoint and When does it occur in database?
How to debug stored procedures?
How do you create a report in a database?
Explain ddl interpreter?