/u01/app/oracle/admin/racdb/udump/racdb1_ora_27706.trc Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1 System name: Linux Node name: hpevo1 Release: 2.6.18-164.el5 Version: #1 SMP Thu Sep 3 02:16:47 EDT 2009 Machine: i686 Instance name: racdb1 Redo thread mounted by this instance: 1 Oracle process number: 23 Unix process pid: 27706, image: oracle@hpevo1 (TNS V1-V3) *** SERVICE NAME:(SYS$USERS) 2010-03-20 13:55:30.768 *** SESSION ID:(125.233) 2010-03-20 13:55:30.768 *** 2010-03-20 13:55:30.768 ============== HANG ANALYSIS: ============== Open chains found: Other chains found: Chain 1 : : <0/125/233/27706/No Wait> Chain 2 : : <0/126/277/18247/jobq slave wait> Chain 3 : : <0/132/3/3392/Streams AQ: waiting for messages> Chain 4 : : <0/136/1/3280/Streams AQ: waiting for time man> Chain 5 : : <0/142/8/2966/Streams AQ: qmn coordinator idle> Chain 6 : : <0/144/990/25191/Streams AQ: qmn slave idle wait> Chain 7 : : <0/169/1/2376/DIAG idle wait> Extra information that will be dumped at higher levels: [level 5] : 7 node dumps -- [SINGLE_NODE] [SINGLE_NODE_NW] [IGN_DMP] [level 10] : 23 node dumps -- [IGN] State of nodes ([nodenum]/cnode/sid/sess_srno/session/ospid/state/start/finish/[adjlist]/predecessor): [121]/0/122/4/0x30ee0054/3411/IGN/1/2//none [124]/0/125/233/0x30ee3870/27706/SINGLE_NODE_NW/3/4//none [125]/0/126/277/0x30ee4b24/18247/SINGLE_NODE/5/6//none [127]/0/128/191/0x30ee708c/14235/IGN/7/8//none [128]/0/129/2/0x30ee8340/3399/IGN/9/10//none [131]/0/132/3/0x30eebb5c/3392/SINGLE_NODE/11/12//none [135]/0/136/1/0x30ef062c/3280/SINGLE_NODE/13/14//none [137]/0/138/1/0x30ef2b94/3247/IGN/15/16//none [141]/0/142/8/0x30ef7664/2966/SINGLE_NODE/17/18//none [143]/0/144/990/0x30ef9bcc/25191/SINGLE_NODE/19/20//none [144]/0/145/1/0x30efae80/2735/IGN/21/22//none [145]/0/146/1/0x30efc134/2737/IGN/23/24//none [149]/0/150/1/0x30f00c04/2472/IGN/25/26//none [150]/0/151/1/0x30f01eb8/2468/IGN/27/28//none [153]/0/154/1/0x30f056d4/2463/IGN/29/30//none [154]/0/155/1/0x30f06988/2431/IGN/31/32//none [155]/0/156/1/0x30f07c3c/2429/IGN/33/34//none [156]/0/157/1/0x30f08ef0/2427/IGN/35/36//none [157]/0/158/1/0x30f0a1a4/2425/IGN/37/38//none [158]/0/159/1/0x30f0b458/2423/IGN/39/40//none [159]/0/160/1/0x30f0c70c/2421/IGN/41/42//none [160]/0/161/1/0x30f0d9c0/2419/IGN/43/44//none [162]/0/163/1/0x30f0ff28/2417/IGN/45/46//none [163]/0/164/1/0x30f111dc/2414/IGN/47/48//none [164]/0/165/1/0x30f12490/2404/IGN/49/50//none [165]/0/166/1/0x30f13744/2395/IGN/51/52//none [166]/0/167/1/0x30f149f8/2382/IGN/53/54//none [167]/0/168/1/0x30f15cac/2380/IGN/55/56//none [168]/0/169/1/0x30f16f60/2376/SINGLE_NODE/57/58//none [169]/0/170/1/0x30f18214/2367/IGN/59/60//none ==================== END OF HANG ANALYSIS ====================