Skip to Content
avatar image
Former Member

SQL error "SQL code: 60" occurred while accessing table "GRACUSER"

Hello Experts,

Wondering if anybody has encountered this error message - I am getting many of my synch jobs - both Incremental and Full - failing with the same error.

Database error text: "SQL message: ORA-00060: deadlock detected while waiting
for resource"

Could this possibly be due to the fact that many jobs are scheduled to start around the same time ?

Thanks for your input,

Kind Regards,

Siobhan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 08, 2016 at 12:16 PM

    Hi Siobhan,

    As a best practice, it is not recommended to start many sync jobs at the same time to avoid performance issues.

    Can you start the jobs a couple of hours apart and check if it works fine.

    Regards,

    Manju

    Add comment
    10|10000 characters needed characters exceeded