What are the factors causing the reparsing of SQL statements
in SGA?
Answer Posted / 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 |
Post New Answer View All Answers
In the oracle version 9.3.0.5.0, what does each number shows?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Can we store images in oracle database?
How much memory your 10g xe server is using?
Give syntax for SQL and ORACLE joins.
Explain alias?
How to run queries on external tables?
What is a snapshot log?
How to connect to oracle using service name instead of sid?
Can group functions be used in the order by clause in oracle?
Why does oracle 9i treat an empty string as null?
List out the components of logical database structure of oracle database.
What are transaction isolation levels supported by oracle?
What is null value in oracle?
How do I uninstall oracle client from windows?