Re: Table Row Locked By Non-Existent Session
From: Powell, Mark <mark.powell2_at_dxc.com>
Date: Mon, 8 Mar 2021 21:05:54 +0000
Message-ID: <BN6PR01MB254761F82F88C989757989B6CE939_at_BN6PR01MB2547.prod.exchangelabs.com>
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of David Barbour <david.barbour1_at_gmail.com> Sent: Wednesday, March 3, 2021 11:53 AM
To: oracle-l mailing list <oracle-l_at_freelists.org> Subject: Table Row Locked By Non-Existent Session
Date: Mon, 8 Mar 2021 21:05:54 +0000
Message-ID: <BN6PR01MB254761F82F88C989757989B6CE939_at_BN6PR01MB2547.prod.exchangelabs.com>
If you have access to Oracle support the following document might be helpful: [https://support.oracle.com/epmos/adf/images/t.gif] DBMS_REPAIR example (Doc ID 68013.1) and has text on extracting reachable data from corrupt block
Mark Powell
Database Administration
(313) 592-5148
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of David Barbour <david.barbour1_at_gmail.com> Sent: Wednesday, March 3, 2021 11:53 AM
To: oracle-l mailing list <oracle-l_at_freelists.org> Subject: Table Row Locked By Non-Existent Session
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?
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 08 2021 - 22:05:54 CET