John,
Thanks for this advice. I will try to get this data tonight on the updated
version.
We do not have the old version around anymore to try this out.
Cherie
John Kanagaraj
<john.kanagara To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
[EMAIL PROTECTED]> cc:
Sent by: Subject: RE: Analyze running twice as
long after upgrade to 8.1.7.2
[EMAIL PROTECTED]
om
06/10/02 07:43
PM
Please respond
to ORACLE-L
Cherie,
> Any other ideas? I'd like to be able to give our
> application owners some
> explanation.
If you have access to the ANALYZE scripts, could you modify it to obtain
_what_ this session is waiting for and how much (from V$SESSION_EVENT) as
well as look at V$MYSTAT to determine the volume of work. It would be a
good
idea if you can back-test (is there such an equivalent for back-port?!) on
the older environment. This may give us some clues.... I am not aware of
ANALYZE changing, although the CBO decisions between the two versions
(given
the same stats/values) may differ.
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
The manuals for Oracle are here: http://tahiti.oracle.com
The manual for Life is here: http://www.gospelcom.net
** The opinions and statements above are entirely my own and not those of
my
employer or clients **
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Kanagaraj
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
