v$session_waits

From: Holman, Rodney <rodney.holman_at_lodgenet.com>
Date: Mon, 06 Aug 2001 15:52:47 -0700
Message-ID: <F001.0036236A.20010806155027@fatcity.com>

Is there a document somewhere that describes what the p1..., p2..., p3... fields are and what the different values mean? Some of the values are obvious, but some are rather cryptic. I am struggling with tuning a Clarify 8.5 SR2.9 instance and need to fix some issues. I just finished rebuilding the indexes into a separate tablespace from the data (the default when you run their index scripts is to leave them together). Now users are complaining that performance is actually worse!!? Yes, I did reanalyze everything. I have bumped up the DB_BLOCK_LRU_LATCHES TO 12*cpu count which was recommended in Gaja's white paper. I'm open to suggestions. I have users ready to take up arms over the performance issues.

TIA Rodd Holman
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Holman, Rodney
  INET: rodney.holman_at_lodgenet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Aug 06 2001 - 17:52:47 CDT