Table Row Locked By Non-Existent Session

  • From: David Barbour <david.barbour1@xxxxxxxxx>
  • To: oracle-l mailing list <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 3 Mar 2021 10:53:03 -0600

Good Morning,
Oracle 12.2 RAC
Linux 7.6

We have a procedure that is supposed to download the results of a query to
a .csv file.  It fails with a *kdsgrp1 error.*

Ran DBMS_REPAIR.CHECK_OBJECT and it shows:

* kdbchk: row locked by non-existent transaction*

Any way to unlock this puppy, or should I just go ahead
with DBMS_REPAIR.FIX_CORRUPT_BLOCKS?

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2021