ORA00054: resource busy and acquire with NOWAIT specified or timeout expired

数据运维 2024-04-08 泡泡 手机阅读

创建索引脚本：
cat /home/oracle/idx.sql

set timing on alter session set parallel_force_local = true; alter session set workarea_size_policy=manual; alter session set sort_area_size=1073741820; alter session set sort_area_retained_size=1073741820; alter session set db_file_multiblock_read_count=128; create index JT_USER.idx_DELETE_STATE on "JT_USER"."RME_OPTIC_TERM"(DELETE_STATE,SUPER_RES_TYPE,OPER_STATUS) parallel 8 nologging; alter index JT_USER.idx_DELETE_STATE noparallel; alter index JT_USER.idx_DELETE_STATE logging;