Hi Team,
Would like to propose a new DIAGNOSTICS attribute, which returns the no.of rows got skipped during the FOR UPDATE SKIP LOCKED;
Using this attribute, we can have more control on parallel operations like,
IF SKIPPED_ROW_COUNT =0 THEN
<<Treat me as, a complete transaction, and do below stuff>>
ELSE
<<Got only few tuples than required, and do below stuff>>
END IF;
Kindly let me know your inputs/suggestions on this.