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 ( [EMAIL PROTECTED] ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis Avrami INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
