Skip to Content
0

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

Oct 24, 2016 at 07:46 AM

632

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Manjunath Indrakumar Nov 08, 2016 at 12:16 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded