Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> statspack report shows low execute to parse%

statspack report shows low execute to parse%

From: clement rajappa <clement.rajappa_at_gmail.com>
Date: 2 Sep 2005 10:44:36 -0700
Message-ID: <1125683076.248986.37400@g47g2000cwa.googlegroups.com>


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%):



Execute to Parse % : 35.84
Parse CPU to Parse Elapsed % : 1.48

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US