racle 19c导入备份文件时，一直卡在导入视图阶段

[early__xz]

oracle 19c导入备份文件时，一直卡在导入视图阶段，如下：

 

Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW

 

卡了一晚上，大概10几个小时，随后中止了导入进程，使用单独导入视图，并跳过已存在视图，导入sql格式如下：

nohup impdp system/[e-mail]:1521/YLxxxDB DUMPFILE=xxxxx_240523-02.dmp DIRECTORY=dump_dir LOGFILE=xxxxView_EXP-$(date +%Y%m%d%H%M).log REMAP_SCHEMA=xxxxn:xxxxx PARALLEL=4 TABLE_EXISTS_ACTION=SKIP INCLUDE=V
IEW > xxxx_nohup_$(date +'%Y-%m-%d_%H-%M-%S').log 2>&1 &

发现一直卡（一晚上大概8小时左右）在其中一个视图这，如下：

ORA-31684: Object type VIEW:"YLYXUS"."xx_SA_xxxx_V" already exists

ORA-31684: Object type VIEW:"YLYXUS"."xx_SA_xxxx_ALL_V" already exists

ORA-31684: Object type VIEW:"YLYXUS"."xxxx_SA_xxxx_CONFIRM_V" already exists

ORA-31684: Object type VIEW:"YLYXUS"."xxxx_SA_xxxx_DTL_ALL_V" already exists

查看该schema下的VIEW一直未增加，请问老师这个该怎么解决。

[姚远Oracle ACE]

@early__xz 还要继续查是涉及哪个SQL或者OBJECT

[early__xz]

@姚远Oracle ACE SQL> SELECT s.inst_id, s.sid, s.serial#, s.username, s.machine, s.program, s.event, s.wait_class, s.seconds_in_wait 2 FROM gv$session s 3 WHERE s.event = 'library cache lock' 4 ORDER BY s.inst_id, s.sid; INST_ID SID SERIAL# USERNAME MACHINE PROGRAM EVENT ---------- ---------- ---------- ---------- ------------ ------------------------------------------------ --------------------------------- WAIT_CLASS SECONDS_IN_WAIT ---------------------------------------------------------------- --------------- 1 20 39550 SYSTEM gtcq-meheco- oracle@gtcq-meheco-inca-test-data (DW1P) library cache lock inca-test-da ta Concurrency 530 1 140 10547 SYSTEM gtcq-meheco- oracle@gtcq-meheco-inca-test-data (DW1M) library cache lock inca-test-da ta Concurrency 583 INST_ID SID SERIAL# USERNAME MACHINE PROGRAM EVENT ---------- ---------- ---------- ---------- ------------ ------------------------------------------------ --------------------------------- WAIT_CLASS SECONDS_IN_WAIT ---------------------------------------------------------------- --------------- 1 141 21058 SYSTEM gtcq-meheco- oracle@gtcq-meheco-inca-test-data (DW1N) library cache lock inca-test-da ta Concurrency 561 1 261 720 SYSTEM gtcq-meheco- oracle@gtcq-meheco-inca-test-data (DW1S) library cache lock inca-test-da ta INST_ID SID SERIAL# USERNAME MACHINE PROGRAM EVENT ---------- ---------- ---------- ---------- ------------ ------------------------------------------------ --------------------------------- WAIT_CLASS SECONDS_IN_WAIT ---------------------------------------------------------------- --------------- Concurrency 235 1 628 15345 SYSTEM gtcq-meheco- oracle@gtcq-meheco-inca-test-data (DW1O) library cache lock inca-test-da ta Concurrency 591 1 874 53485 SYSTEM gtcq-meheco- oracle@gtcq-meheco-inca-test-data (DW1Q) library cache lock inca-test-da INST_ID SID SERIAL# USERNAME MACHINE PROGRAM EVENT ---------- ---------- ---------- ---------- ------------ ------------------------------------------------ --------------------------------- WAIT_CLASS SECONDS_IN_WAIT ---------------------------------------------------------------- --------------- ta Concurrency 372 1 1363 62865 SYSTEM gtcq-meheco- oracle@gtcq-meheco-inca-test-data (DW1R) library cache lock inca-test-da ta Concurrency 587 7 rows selected. 确实有 有多个会话处于 library cache lock 状态，但是为啥导入视图会出现这个，现在有没有办法让他继续运行

[姚远Oracle ACE]

现在要知道正在执行的sql语句，可能是锁住了，这里有脚本https://mp.weixin.qq.com/s?__biz=Mzg2MzkxMjg4Ng==&mid=2247486619&idx=1&sn=11f87a3098b9729edc6e95469769b57f&chksm=ce701a42f9079354ba641eb03fa98dae2529d91eba47579c1190b75fd9008eb64d898c24df47&token=332284177&lang=zh_CN#rd
进行检查。另外在v$session中看看等待事件和sql语句。