Skip to Content
0
Former Member
Jun 03, 2009 at 04:20 AM

DEADLOCK DETECTED ( ORA-00060 )

146 Views

Hi,

We are getting deadlocks when the System (Exteranl-Portal-

Production) Cache Upload process runs. It's Looks like

application problem.

We have been getting this deadlock problem whenever the CACHE job gets

executed.

Basically its a portal SRM Business package system.

We have scheduled the CACHE job on portal at 1 AM MSTAZ time , so it

will use Jco to connect R3 and SRM system to bring the data.

We have been observing this deadlock problem only at the time of cache

job.

But cache job is executing succesfully , but we could see the deadlock

in the logs.

In the beginning of trace file (Location:-

/oracle/RPE/saptrace/usertrace/) we found the information as follows

more rpe_ora_1835342.trc

Dump file /oracle/RPE/saptrace/usertrace/rpe_ora_1835342.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

ORACLE_HOME = /oracle/RPE/102_64

System name: AIX

Node name: fsp55a08

Release: 3

Version: 5

Machine: 000788ABD600

Instance name: RPE

Redo thread mounted by this instance: 1

Oracle process number: 17

Unix process pid: 1835342, image: oracle@fsp55a08

  • 2009-05-31 01:00:49.485

  • ACTION NAME:() 2009-05-31 01:00:49.485

  • MODULE NAME:(JDBC Thin Client) 2009-05-31 01:00:49.485

  • SERVICE NAME:(SYS$USERS) 2009-05-31 01:00:49.485

  • SESSION ID:(275.1229) 2009-05-31 01:00:49.485

DEADLOCK DETECTED ( ORA-00060 )

[Transaction Deadlock]

The following deadlock is not an ORACLE error. It is a

deadlock due to user error in the design of an application

or from issuing incorrect ad-hoc SQL. The following

information may aid in determining the deadlock:

Deadlock graph:

-


Blocker(s)--


-
Waiter(s)--


Resource Name process session holds waits process session holds waits

TX-00050010-00003981 17 275 X 18 284 X

TX-00010000-000038a3 18 284 X 17 275 X

session 275: DID 0001-0011-00000139 session 284: DID 0001-0012-0000004F

session 284: DID 0001-0012-0000004F session 275: DID 0001-0011-00000139

Rows waited on:

Session 284: obj - rowid = 0000561D - AAAFYdAAJAAAHUlAAU

(dictionary objn - 22045, file - 9, block - 29989, slot - 20)

Session 275: obj - rowid = 00005617 - AAAFYXAAJAAAG1aAAc

(dictionary objn - 22039, file - 9, block - 27994, slot - 28)

Information on the OTHER waiting sessions:

Session 284:

pid=18 serial=1236 audsid=672749 user: 21/SAPRPEDB

O/S info: user: rpeadm, term: unknown, ospid: 1234, machine: fsp65003

program: JDBC Thin Client

Please help me on this issue.

Please let me know if you need any more information on the same.

Thank you in advance.

Regards,

A.Naresh

SAP-BASIS