RE: FULL SQL Query Code in Statspack report
- From: Paul Drake <discgolfdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 24 May 2004 10:52:15 -0700 (PDT)
--- "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx> wrote:
> Hmm....no Oracle version. No matter, my psychic
> ability tells
> me you're on 9.2.0.4 on Solaris 8, what a
> coincidence, so am I!
>
> See $ORACLE_HOME/rdbms/admin/sprepins.sql
> look for 'num_rows_per_hash=3D5', adjust
> accordingly.
>
> -Mark
I'd like to add:
snapshots at level 6 is supposed to also log explain
plans.
Tim Gorman has an excellent paper up on his site:
http://www.evdbt.com/papers.htm
which corresponds to the presentation he delivered at
RMOUG 2004.
Paul
__________________________________
Do you Yahoo!?
Yahoo! Domains ? Claim yours for only $14.70/year
http://smallbusiness.promotions.yahoo.com/offer
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
