Statspack question - Execute to Parse %

From: Louis Avrami <avramil_at_concentric.net>
Date: Tue, 14 Aug 2001 11:40:50 -0700
Message-ID: <F001.0036A502.20010814115421@fatcity.com>

Hello all,

I recently created some Level 5 Statspack snapshots for an Oracle 8.1.7.0 database. Here's a portion of a snapshot report:

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:  100.00       Redo NoWait %:  100.00
Buffer  Hit   %:   99.94    In-memory Sort %:   99.46
Library Hit   %:   99.37        Soft Parse %:   99.53
Execute to Parse %:    1.59      Latch Hit %:   97.47

The particular stat that I am unsure about is "Execute to Parse %". Can anyone share with me what exactly this maps back to, and what might be tuned to improve this number?

Thanks,
Lou Avrami ( avramil_at_concentric.net )

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Louis Avrami
INET: avramil_at_concentric.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 14 2001 - 13:40:50 CDT