large number of
waits on the cache
buffers chains latch.
I know the child latch# is 242 (details below).
We are on Oracle 8.1.5.1.1 on NT4.
The problems seem to have started appearing after
starting large scale use
of Global Temporary tables (GTT).
Our temp tablespace was of type temporary
)
[EMAIL PROTECTED] wrote:
Hi,
Our database is experiencing a very large number
of
waits on the cache
buffers chains latch.
I know the child latch# is 242 (details below).
We are on Oracle 8.1.5.1.1 on NT4.
The problems seem to have started appearing after
starting large scale
PROTECTED]
06/21/01 01:15 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Waits on cache buffers chains latch
Hi,
Our database is experiencing a very large number of waits on the cache
buffers chains latch.
I know
at percentages
once
and conclude that you have a problem. I am
assuming
that the latch free wait event for the cache
buffers
chains latch occurs frequently and shows up in
V$SESSION_WAIT.
Contention or waits for the cache buffers chains
latch usually indicates that there is too
and shows up in
V$SESSION_WAIT.
Contention or waits for the cache buffers chains
latch usually indicates that there is too much
logical I/O that is being performed in your
environment. Contrary to common knowledge, logical I/O
is not 3 orders of magnitude faster than physical I/O
in an Oracle
Hi,
Our database is experiencing a very large number of waits on the cache
buffers chains latch.
I know the child latch# is 242 (details below).
We are on Oracle 8.1.5.1.1 on NT4.
The problems seem to have started appearing after starting large scale use
of Global Temporary tables (GTT).
Our