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
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: statspack snap level 7 as execution plan rep
- From: John Kanagaraj
- References:
- statspack snap level 7 as execution plan rep
- From: amonte
Other related posts:
- » statspack snap level 7 as execution plan rep
- » Re: statspack snap level 7 as execution plan rep
- » Re: statspack snap level 7 as execution plan rep
- » Re: statspack snap level 7 as execution plan rep
- » Re: statspack snap level 7 as execution plan rep
- » Re: statspack snap level 7 as execution plan rep
- » Re: statspack snap level 7 as execution plan rep
- » Re: statspack snap level 7 as execution plan rep
- » Re: statspack snap level 7 as execution plan rep
- » Re: statspack snap level 7 as execution plan rep
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
- Re: statspack snap level 7 as execution plan rep
- From: John Kanagaraj
- statspack snap level 7 as execution plan rep
- From: amonte