Hi Experts- we are recieving intermittent job failure with ora-18103 object no longer exist.
with the help of audit we were able to identify that one session is updating the table and at the same time another session issued a select statement of same table .
I am wondering will this cause object no longer exist?
have seen number articles this can cause only with truncate and select in 2 different session may cause this issue.
Could you please provide some insight.
session 1:
UPDATE PSSTATUS SET DATABASE_OPTIONS = DATABASE_OPTIONS + :1 WHERE
MOD(FLOOR(DATABASE_OPTIONS/:2),?) = ?
session 2:
SELECT UNICODE_ENABLED FROM PSSTATUS