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
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
Gene,
This is the problem with high-level aggregate reports like
BSTAT/ESTAT and STATSPACK. A possible problem is
highlighted, but there is no detail on the possible cause.
One way to get more info is monitor V$SESSION_EVENT view
searching for sessions with lots of waits on enqueue
wait-event:
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
Tim,
Thanks a lot. This does help. The data that I have are
a result from a test run, so I can't do anything right
now, but this does give me something to look at if I
see the enqueue timeouts increasing in the database in
the future.
thank you
Gene
--- Tim Gorman [EMAIL PROTECTED] wrote:
