Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> statspack report shows low execute to parse%
Hi
I am working on oracle 8i under win2k dell server. Recently i ran
Statspack to observe the performance and found the following under
the heading
Instance Efficiency Percentage (Target 100%):
These 2 are way below the 100% target. All other readings are between
97 to 100%.
What could be the problem that is causing such low value. As
i am new to DB ADMIN i request group's help.
My SGA Config is:
shared pool size: 85mb
db_block_size :8192 db_block_buffers :14000
log buffer:524288
RAM size:512MB. ONE PENTIUM III Processor.
thks
clement
Received on Fri Sep 02 2005 - 12:44:36 CDT