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. Regards, Dinesh manojadinesh.blogspot.com
