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
Is there an example how to configure externalfileaccess setting in firebird.conf?
What is db flush?
Give us a non-computer example of preemptive and non-preemptive scheduling?
What is db driver?
What are the types of rdbms?
What is normalisation and its type?
Can I use google sheets as a database?
Why is group-clause used?
What is system r? How many of its two major subsystems?
What is second normal form?
What do you understand by ‘atomicity’ and ‘aggregation’?
What is normal form in dbms?
Explain the advantages and disadvantages of a hierarchical database?
Which is fastest database?
How to repair a corrupt firebird database?