Greetings,
I am running an Oracle 8.1.7 instance, and now I want to tune its
performance. But I get two confusions:
- From Oracle's report.txt statistic, I can see latch "library cache" has
relative low hit ratio 85% while other latches' hit ratio are all above 99%.
Then I am considering to enlarge SHARED_POOL_SIZE. But by "SELECT * FROM
V$SGASTAT", I find "shared pool free memory" is 60M bytes, that means shared
pool is not full.
- By "select sql_text, parse_calls, executions from v$sqlarea", I find many
of frequently-executed statements has close "parse_calls" and "executions".
For example, a statement's "parse_calls" is 436505031 and "executions" is
- I writes all statement with bind mode, so the statements are text
identical. But why Oracle always reparse those statements? As mentioned in
question 1, shared pool has free space, why Oracle don't put parsed
statements in shared pool for reusing? How to solve this problem?
Thnaks in advance,
Evan
Received on Tue Nov 01 2005 - 18:54:48 CST
