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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
