exchange partition waiting for library cache lock
From: Ls Cheng <exriscer_at_gmail.com>
Date: Mon, 11 Sep 2023 20:13:10 +0200
Message-ID: <CAJ2-Qb8U26-LAgPj+EEmAPXyxuYqW0Wjn1uDY0tQoKb=tzx3QA_at_mail.gmail.com>
Hi
Date: Mon, 11 Sep 2023 20:13:10 +0200
Message-ID: <CAJ2-Qb8U26-LAgPj+EEmAPXyxuYqW0Wjn1uDY0tQoKb=tzx3QA_at_mail.gmail.com>
Hi
Running 19.15.
I have some batch processes which run exchange partition commands then run
some ETL, sometimes the exchange partition takes minutes instead of seconds
and the ALTER is waiting for the library cache lock. From ASH we can see
that the blocking sessions are running queries against the partition. I
tried to reproduce the issue but in my tests the exchange partition runs
successfully and there is no library cache lock while the table is being
queried.
So I wonder what is exactly causing library cache lock to the ALTER TABLE
exchange partition?
Thanks
libt.tld_type is 1, lib_t.tld_source_file is '/usr/local/lib/aarch64-linux-gnu/perl/5.30.0/auto/share/dist/Mail-DMARC-opendmarc/effective_tld_names.dat'
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 11 2023 - 20:13:10 CEST