附:Dump file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_3844.trc
Wed Dec 14 12:20:49 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:587M/1982M, Ph+PgF:2391M/3879M, VA:1275M/2047M
Instance name: orclRedo thread mounted by this instance: 1Oracle process number: 17Windows thread id: 3844, image: ORACLE.EXE (SHAD)
*** SERVICE NAME:(SYS$USERS) 2011-12-14 12:20:49.859
*** SESSION ID:(142.1456) 2011-12-14 12:20:49.859
Memory Notification: Library Cache Object loaded into SGA
Heap size 2654K exceeds notification threshold (2048K)
LIBRARY OBJECT HANDLE: handle=32953680 mutex=32953734(0)
name=SYS.ALERT_QUE
hash=ac8b6e1e4ca94b6f517f04aaaa810f64 timestamp=08-30-2005 14:11:40
namespace=QUEU flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0000-0000 lock=N pin=S latch#=1 hpc=05ca hlc=05ca
lwt=329536DC[329536DC,329536DC] ltm=329536E4[329536E4,329536E4]
pwt=329536C0[329536C0,329536C0] ptm=329536C8[329536C8,329536C8]
ref=329536FC[329536FC,329536FC] lnd=32953708[32953708,32953708]
LIBRARY OBJECT: object=2fc65648
type=QUEU flags=EXS/LOC[0005] pflags=[0000] status=VALD load=X
DEPENDENCIES: count=4 size=16
dependency# table reference handle position flags
----------- -------- --------- -------- -------- -------------------
0 2fc65a04 2fc4a8f0 328f9ebc 0 DEP[01]
1 2fc65a04 2fc4a924 328f9d64 0 DEP[01]
2 2fc65a04 2fc4a958 328f9c0c 0 DEP[01]
3 2fc65a04 2fc4a98c 32a52700 0 DEP[01]
DATA BLOCKS:
data# heap pointer status pins change whr alloc(K) size(K)
----- -------- -------- --------- ---- ------ --- -------- --------
0 32956870 2fc656e0 I/P/A/-/- 0 NONE 00 2654.94 0.00
Dump file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_3844.trc
Fri Dec 23 11:34:21 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:162M/1982M, Ph+PgF:1414M/3879M, VA:1256M/2047M
Instance name: orclRedo thread mounted by this instance: 1Oracle process number: 32Windows thread id: 3844, image: ORACLE.EXE (SHAD)
*** SERVICE NAME:(SYS$USERS) 2011-12-23 11:34:21.093
*** SESSION ID:(128.1351) 2011-12-23 11:34:21.093
Memory Notification: Library Cache Object loaded into SGA
Heap size 2364K exceeds notification threshold (2048K)
LIBRARY OBJECT HANDLE: handle=2a7b2824 mutex=2A7B28D8(0)
name=SYS.ALERT_QUE
hash=ac8b6e1e4ca94b6f517f04aaaa810f64 timestamp=08-30-2005 14:11:40
namespace=QUEU flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0000-0000 lock=N pin=S latch#=1 hpc=0528 hlc=0528
lwt=2A7B2880[2A7B2880,2A7B2880] ltm=2A7B2888[2A7B2888,2A7B2888]
pwt=2A7B2864[2A7B2864,2A7B2864] ptm=2A7B286C[2A7B286C,2A7B286C]
ref=2A7B28A0[2A7B28A0,2A7B28A0] lnd=2A7B28AC[2A7B28AC,2A7B28AC]
LIBRARY OBJECT: object=2e60ab1c
type=QUEU flags=EXS/LOC[0005] pflags=[0000] status=VALD load=X
DEPENDENCIES: count=4 size=16
dependency# table reference handle position flags
----------- -------- --------- -------- -------- -------------------
0 2e60aed8 2e5f8a70 3286e7f4 0 DEP[01]
1 2e60aed8 2e5f8aa4 2a6d2e18 0 DEP[01]
2 2e60aed8 2e5f8ad8 2a5908e8 0 DEP[01]
3 2e60aed8 2e5f8b0c 3289496c 0 DEP[01]
DATA BLOCKS:
data# heap pointer status pins change whr alloc(K) size(K)
----- -------- -------- --------- ---- ------ --- -------- --------
0 328cef3c 2e60abb4 I/P/A/-/- 0 NONE 00 2364.36 0.00
Dump file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_3844.trc
Fri Dec 23 12:08:33 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:180M/1982M, Ph+PgF:1438M/3879M, VA:1265M/2047M
Instance name: orclRedo thread mounted by this instance: 1Oracle process number: 30Windows thread id: 3844, image: ORACLE.EXE (SHAD)
Wed Dec 14 12:20:49 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:587M/1982M, Ph+PgF:2391M/3879M, VA:1275M/2047M
Instance name: orclRedo thread mounted by this instance: 1Oracle process number: 17Windows thread id: 3844, image: ORACLE.EXE (SHAD)
*** SERVICE NAME:(SYS$USERS) 2011-12-14 12:20:49.859
*** SESSION ID:(142.1456) 2011-12-14 12:20:49.859
Memory Notification: Library Cache Object loaded into SGA
Heap size 2654K exceeds notification threshold (2048K)
LIBRARY OBJECT HANDLE: handle=32953680 mutex=32953734(0)
name=SYS.ALERT_QUE
hash=ac8b6e1e4ca94b6f517f04aaaa810f64 timestamp=08-30-2005 14:11:40
namespace=QUEU flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0000-0000 lock=N pin=S latch#=1 hpc=05ca hlc=05ca
lwt=329536DC[329536DC,329536DC] ltm=329536E4[329536E4,329536E4]
pwt=329536C0[329536C0,329536C0] ptm=329536C8[329536C8,329536C8]
ref=329536FC[329536FC,329536FC] lnd=32953708[32953708,32953708]
LIBRARY OBJECT: object=2fc65648
type=QUEU flags=EXS/LOC[0005] pflags=[0000] status=VALD load=X
DEPENDENCIES: count=4 size=16
dependency# table reference handle position flags
----------- -------- --------- -------- -------- -------------------
0 2fc65a04 2fc4a8f0 328f9ebc 0 DEP[01]
1 2fc65a04 2fc4a924 328f9d64 0 DEP[01]
2 2fc65a04 2fc4a958 328f9c0c 0 DEP[01]
3 2fc65a04 2fc4a98c 32a52700 0 DEP[01]
DATA BLOCKS:
data# heap pointer status pins change whr alloc(K) size(K)
----- -------- -------- --------- ---- ------ --- -------- --------
0 32956870 2fc656e0 I/P/A/-/- 0 NONE 00 2654.94 0.00
Dump file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_3844.trc
Fri Dec 23 11:34:21 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:162M/1982M, Ph+PgF:1414M/3879M, VA:1256M/2047M
Instance name: orclRedo thread mounted by this instance: 1Oracle process number: 32Windows thread id: 3844, image: ORACLE.EXE (SHAD)
*** SERVICE NAME:(SYS$USERS) 2011-12-23 11:34:21.093
*** SESSION ID:(128.1351) 2011-12-23 11:34:21.093
Memory Notification: Library Cache Object loaded into SGA
Heap size 2364K exceeds notification threshold (2048K)
LIBRARY OBJECT HANDLE: handle=2a7b2824 mutex=2A7B28D8(0)
name=SYS.ALERT_QUE
hash=ac8b6e1e4ca94b6f517f04aaaa810f64 timestamp=08-30-2005 14:11:40
namespace=QUEU flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0000-0000 lock=N pin=S latch#=1 hpc=0528 hlc=0528
lwt=2A7B2880[2A7B2880,2A7B2880] ltm=2A7B2888[2A7B2888,2A7B2888]
pwt=2A7B2864[2A7B2864,2A7B2864] ptm=2A7B286C[2A7B286C,2A7B286C]
ref=2A7B28A0[2A7B28A0,2A7B28A0] lnd=2A7B28AC[2A7B28AC,2A7B28AC]
LIBRARY OBJECT: object=2e60ab1c
type=QUEU flags=EXS/LOC[0005] pflags=[0000] status=VALD load=X
DEPENDENCIES: count=4 size=16
dependency# table reference handle position flags
----------- -------- --------- -------- -------- -------------------
0 2e60aed8 2e5f8a70 3286e7f4 0 DEP[01]
1 2e60aed8 2e5f8aa4 2a6d2e18 0 DEP[01]
2 2e60aed8 2e5f8ad8 2a5908e8 0 DEP[01]
3 2e60aed8 2e5f8b0c 3289496c 0 DEP[01]
DATA BLOCKS:
data# heap pointer status pins change whr alloc(K) size(K)
----- -------- -------- --------- ---- ------ --- -------- --------
0 328cef3c 2e60abb4 I/P/A/-/- 0 NONE 00 2364.36 0.00
Dump file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_3844.trc
Fri Dec 23 12:08:33 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:180M/1982M, Ph+PgF:1438M/3879M, VA:1265M/2047M
Instance name: orclRedo thread mounted by this instance: 1Oracle process number: 30Windows thread id: 3844, image: ORACLE.EXE (SHAD)
请大虾协助看看
在d:\oracle\product\10.2.0\admin\orcl\udump\下執行:
tkprof orcl_ora_3844.trc orcl_ora_3844.txt
然後看 txt文件會清晰一些。