Hi,
I am facing a problem as stated in the Subject.
I have a query like:
SELECT coln FROM tab1
WHERE col1 = 'xxx'
and ROWNUM =1
FOR UPDATE SKIP LOCKED;
The coln data needs to be extracted into a PL/SQL variable & thereafter the record needs to be deleted from the table, tab1
There are great no of candidate records in the table but still have issues:
1) it takes considerable time &
2) until the current transaction is committed, another run of the same query returns no record
My Create table script has set PCTFREE, INITRANS to 0 & 16 respectively. Is it a concern?
Kindly help to understand the issues.
Regards,
Priya Ranjan Sahay