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