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
Attachment:
ash.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
