Re: exchange partition waiting for library cache lock

Forgot to mention that the queries are all parallel queries

On Mon, Sep 11, 2023 at 8:13 PM Ls Cheng <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'

--
http://www.freelists.org/webpage/oracle-l