Oracle Database Discussions

Hi,

Can someone please guide me to some references on how to read oracle trace files? I've got some oracle deadlock files but not able to read it... This is an example:

DEADLOCK DETECTED
Current SQL statement for this session:
UPDATE SMCC.SMSCC_PROPAGATION_1 SET BALANCE=:b1 + :b2 + :b3 + :b4 ,BALANCE_UPDATE_DATE=DECODE(PROPAGATED_BALANCE,0,BALANCE_UPDATE_DATE,SYSDATE),PROPAGATED_BALANCE=:b5,SERVICE_SEQ=SMCC.SMCC_SERVICE_SEQ.NEXTVAL,SCP_NUM=1 WHERE PROVISIONID = :b6

----- PL/SQL Call Stack -----
object line object
handle number name
db411360 50 SMS_SH.SMCC_1_UPDATE
d7e07790 1 anonymous block
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-0006004e-00272176 18 20 X 384 357 X
TX-00090012-00271e00 384 357 X 18 20 X
session 20: DID 0001-0012-00000001 session 357: DID 0001-0180-00000001
session 357: DID 0001-0180-00000001 session 20: DID 0001-0012-00000001
Rows waited on:
Session 357: obj - rowid = 000008A6 - AAAAimAAOAAAHlaAAJ
Session 20: obj - rowid = 00000A23 - AAAAojAAjAAAAI/AB9
===================================================

There's alot more information in the file and I'm not entirely sure where to start. There's alot of info with nothing to indicate what it all means. Just wanting to extract information for troubleshooting. it's a pretty big database with many reads and writes happening.

From what I can see.. the statement causing the problem is the 'update' above with issues on the objects with rowid = 000008A6 and 00000A23.

Am I on the right track? Any help would be appreciated.
Thanks!