Hi,
I have a table in Prod. which is having HW contention. There are live sessions currently that are inserting data into it.
SQL> select * from gv$lock where block=1;
INST_ID ADDR KADDR SID TY ID1 ID2
---------- ---------------- ---------------- ---------- -- ---------- ----------
LMODE REQUEST CTIME BLOCK
---------- ---------- ---------- ----------
1 00000001F73C1BA0 00000001G73B1MC0 5056 HW 7 29360283
6 0 0 1
Now the table is not allowing to be altered manually to allocate any extent to it:
SQL>alter table EMP MOVE tablespace index1 ;
alter table EMP MOVE tablespace index1
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
SQL>alter table emp allocate extent;
alter table emp allocate extent
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
In this scenario, what are the options available? How can we remove the HW lock and allocate required space to the table?
The table has 2 clob columns
Thanks,