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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: statspack snap level 7 as execution plan rep

Re: statspack snap level 7 as execution plan rep

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Wed, 22 Nov 2006 00:18:47 -0500
Message-ID: <c2213f680611212118l52feaa7bpa4d0c4fed4442899@mail.gmail.com>


You might want to change default thresholds that statspack uses to identify statements to include. Still you won't get guarantee that all statements are captured. You might not need it though... depends on your targets.

On 11/20/06, amonte <ax.mount_at_gmail.com> wrote:
> Hi
>
> I wonder if any of you use statspack to store a execution plan repository?
> When run in level 7. Is it worthy? Oracle 9.2.0.8 in HP-UX.
>
> TIA
>
> Alex
>

-- 
Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA

http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 21 2006 - 23:18:47 CST

Original text of this message

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