Gene,
I strongly recommend implementing Statspack.
It is very straight-forward.
Just do it when you have exclusive use of the database, or comment
out the following two lines in ora_rdbms_admin:SPCUSR.SQL if you have
these packages already installed.
(We're running 8.1.7 on VMS. The filenames might be different on your
platform,
but the documentation gives lots of detail.)
--@@dbmspool
--@@dbmsjob
The docs neglected to mention that it was going to recreate DBMSPOOL and
DBMSJOB, even
thought they were already installed.
This invalidated everything that depends on those two packages!
Yet another way to hang your production instance!
Nelson
-----Original Message-----
Sent: Tuesday, January 20, 2004 5:04 PM
To: Multiple recipients of list ORACLE-L
Hi.
I am looking at the bstat/estat report and see a high
number of enqueue timeouts in the statistics section
of the report. How do I tackle that? In the Niemec's
book he receoomends increasing the enqueue_resources
parameter. Metalink says that these may be related to
DISTRIBUTED_LOCK_TIMEOUT being exceeded in a
distributed transaction. Comments about changing
ENQUEUE_RESOURCES are ill-founded. But it doesn't make
any recommendations.
So my question is whether anyone has any practical
suggestions what I can do to address this issue. I am
running Oracle 9203 (yes, I should be usuns the
statspack, but I haven't switched to it yet).
TIA
Gene
__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gurelei
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
