library cache: bucket mutex X"
From: kyle Hailey <kylelf_at_gmail.com>
Date: Wed, 23 Jun 2021 12:48:33 -0700
Message-ID: <CADsdiQi7wCNnLLrw3vUX83XkOUWZ7dMuaOJFFCUEX5bLCEXSMw_at_mail.gmail.com>
Anyone seen issues "library cache: bucket mutex X"? Running Oracle 19c with 128 CPUs 3.9TB memory . Database running ok, but queries on v$sqlarea, v$sqstats wait on "library cache: bucket mutex X", for example
FROM v$sqlarea sqla, v$session sess
WHERE sess.sql_hash_value = sqla.hash_value AND sess.sql_address = sqla.address;
Date: Wed, 23 Jun 2021 12:48:33 -0700
Message-ID: <CADsdiQi7wCNnLLrw3vUX83XkOUWZ7dMuaOJFFCUEX5bLCEXSMw_at_mail.gmail.com>
Anyone seen issues "library cache: bucket mutex X"? Running Oracle 19c with 128 CPUs 3.9TB memory . Database running ok, but queries on v$sqlarea, v$sqstats wait on "library cache: bucket mutex X", for example
SELECT sess.sid, sess.username, sqla.optimizer_mode, sqla.hash_value, sqla.address, sqla.cpu_time, sqla.elapsed_time, sqla.sql_text
FROM v$sqlarea sqla, v$session sess
WHERE sess.sql_hash_value = sqla.hash_value AND sess.sql_address = sqla.address;
No other queries run into this wait, only queries on v$sqlarea and
v$sqlstat (haven't tried v$sql but would expect the issue as well).
I don't have access to the database so can't really poke around, thus
wondering if anyone else has experiences with "library cache: bucket mutex
X".
CPU and memory look fine on the host ( of course with 128 CPUs 3.8TB
memory) . Also wondering if the large memory could be involved. Don't have
the shared pool size. Do know DB is using memory_target at about 3TB.
Kyle
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 23 2021 - 21:48:33 CEST