Re: statspack report shows low execute to parse%

From: comp.databases.oracle.tools <clement.rajappa_at_gmail.com>
Date: 7 Sep 2005 02:47:28 -0700
Message-ID: <1126086448.775294.266540@g44g2000cwa.googlegroups.com>

Hi guys
Thks for your support. I guess the full picture of instance efficiency results from statspack will
help in analyzing better:
Instance Efficiency Percentages (Target 100%)

            Buffer Nowait %:  100.00       Redo NoWait %:  100.00
            Buffer  Hit   %:   97.19    In-memory Sort %:   99.16
            Library Hit   %:   99.90        Soft Parse %:   99.58
         Execute to Parse %:   35.84         Latch Hit %:   99.99
Parse CPU to Parse Elapsd %:    1.48     % Non-Parse CPU:  100.00

So as u see the issues raised are all in the 99% level. Also i am not working in web environment.
It is a client server env at the branches and connected to the remote server(Compaq TRU64 RAC) at main office(MO) working on distributed database concept. Branch transactions are transferred to MO on an hourly basis.
SGA breakdown difference for DB: ORCSAW Instance: orcsaw Snaps: 2 -3:

Pool        Name                        Begin value      End value
Difference


----------- ------------------------            --------------

--------------   -----------

shared pool free memory             40,492,116     40,456,720


-35,396

shared pool library cache            11,763,564      11,778,732
15,168
shared pool dictionary cache         3,136,892       3,136,892

0
Also the queries we are using seems to be fine(with proper bind variables).

rgds
clement Received on Wed Sep 07 2005 - 04:47:28 CDT