RE: FULL SQL Query Code in Statspack report

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Mon, 24 May 2004 10:52:15 -0700 (PDT)
Message-ID: <20040524175215.66801.qmail@web20419.mail.yahoo.com>

• "Bobak, Mark" <Mark.Bobak_at_il.proquest.com> 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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon May 24 2004 - 12:49:13 CDT