Re: exchange partition waiting for library cache lock
Date: Mon, 11 Sep 2023 18:57:02 +0000
Message-ID: <DBAPR02MB6470E6EFE1C21FE8F4BEA1FCA1F2A_at_DBAPR02MB6470.eurprd02.prod.outlook.com>
Are these blocking queries just executing or parsing? See the various IN% flags in ASH output.
Sent from my iPhone
On 11 Sep 2023, at 19:22, Ls Cheng <exriscer_at_gmail.com> wrote:
On Mon, Sep 11, 2023 at 8:13 PM Ls Cheng <exriscer_at_gmail.com<mailto:exriscer_at_gmail.com>> wrote:
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'
Forgot to mention that the queries are all parallel queries
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 11 2023 - 20:57:02 CEST