Library lock issue
From: Lok P <loknath.73_at_gmail.com>
Date: Wed, 12 May 2021 23:12:51 +0530
Message-ID: <CAKna9VafhTQj1K+pUViUiKXvvyc29bHwP=YVTU++kp-xtXjRNA_at_mail.gmail.com>
This is version 19.9.0.0.0 Oracle version and it's an Exadata machine. We are seeing high wait events of "library cache load locks" on this database during a high activity period. Below attached is the ASH report from the specific period. Want to understand if this version has any bugs around this ?
Date: Wed, 12 May 2021 23:12:51 +0530
Message-ID: <CAKna9VafhTQj1K+pUViUiKXvvyc29bHwP=YVTU++kp-xtXjRNA_at_mail.gmail.com>
This is version 19.9.0.0.0 Oracle version and it's an Exadata machine. We are seeing high wait events of "library cache load locks" on this database during a high activity period. Below attached is the ASH report from the specific period. Want to understand if this version has any bugs around this ?
I see one bug as below related to "library cache load lock" but I am not seeing such parallel maintenance operations in our case though we have many DMLs involved with partition tables during this window. So it does not fully match our symptoms.
High Library Cache Lock and Library Cache Load Lock Waits During Concurrent Heavy Mixed PMOPs and DML on Several Partitioned Tables (Doc ID 2181034.1)
Regards
Lok
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 12 2021 - 19:42:51 CEST
- application/vnd.openxmlformats-officedocument.spreadsheetml.sheet attachment: ash.xlsx