Re: statspack snap level 7 as execution plan rep

  • From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
  • To: ax.mount@xxxxxxxxx
  • Date: Wed, 22 Nov 2006 00:18:47 -0500

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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: