RE: how do I interpret this in bstat/estat

From: <nelson.petersen_at_homehardware.ca>
Date: Wed, 21 Jan 2004 05:24:34 -0800
Message-ID: <F001.005DDC18.20040121052434@fatcity.com>

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: gurelei_at_yahoo.com

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: 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).
--

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

Author:
INET: nelson.petersen_at_homehardware.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------