显示内容如下:
/oracle/admin/mptms/bdump/mptms2_j002_671784.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 -64bit Production
With the Partitioning,Real Application Clusters,OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Oracle_home =/oracle/ora92
System name : AIX
Node name : odb2
Release : 3
Version: 5
Machine: 00C514EB4C00
Instance name:mptms2
Redo thread mounted by this instance:2
Oracle procedd number:18
Unix process pid:671784,image:oracle@odb2(J002)*** 2012-09-18 12:46:59.335
*** SESSION ID:(23.15439) 2012-09-18 12:46:59.307
Shared Pool LRU Simulator State:
=====================================Pinned List [0] heap count = 35
Total size = 57896 [no invalid 0]
Total pinned memory on list [0] =76656, in 29 heapsPinned List [0] heap count = 29
Total size = 44160 [no invalid 0]
Total pinned memory on list [0] =44160, in 35 heaps
Pinned List [0] heap count = 37
Total size = 30040 [no invalid 0]
Total pinned memory on list [0] =35696, in 37 heapsPinned List [0] heap count = 30
Total size = 32536 [no invalid 0]
Total pinned memory on list [0] =46064, in 30 heapsPinned List [0] heap count = 25
Total size = 60832 [no invalid 0]
Total pinned memory on list [0] =70216, in 25 heapsPinned List [5] heap count = 0
Total size = 0 [no invalid 0]
Total pinned memory on list [5] =0, in 0 heapsTotal momory on 6 pinned lists = 272792 LRU list [1] bktcnt=19
Bucket Summary (time in second)
0: start= 100663296 size=117440512 Ht=21099814 Tm=61966
Tot= 8204 sz=117548760 (117548760) Ld= 12 Msz=1518520312[1476553]
1: start= 218103808 size=117440512 Ht=8462 Tm=22
Tot= 8204 sz=119803520 (117440512) Ld= 12 Msz=119764648[5145]
2: ......
10: start= 1275068416 size=117440512 Ht=2424 Tm=5
Tot= 6957 sz=117266896 (117266896) Ld= 8 Msz= 0[ 0]
XX: .......
/oracle/admin/mptms/bdump/mptms2_j002_671784.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 -64bit Production
With the Partitioning,Real Application Clusters,OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Oracle_home =/oracle/ora92
System name : AIX
Node name : odb2
Release : 3
Version: 5
Machine: 00C514EB4C00
Instance name:mptms2
Redo thread mounted by this instance:2
Oracle procedd number:18
Unix process pid:671784,image:oracle@odb2(J002)*** 2012-09-18 12:46:59.335
*** SESSION ID:(23.15439) 2012-09-18 12:46:59.307
Shared Pool LRU Simulator State:
=====================================Pinned List [0] heap count = 35
Total size = 57896 [no invalid 0]
Total pinned memory on list [0] =76656, in 29 heapsPinned List [0] heap count = 29
Total size = 44160 [no invalid 0]
Total pinned memory on list [0] =44160, in 35 heaps
Pinned List [0] heap count = 37
Total size = 30040 [no invalid 0]
Total pinned memory on list [0] =35696, in 37 heapsPinned List [0] heap count = 30
Total size = 32536 [no invalid 0]
Total pinned memory on list [0] =46064, in 30 heapsPinned List [0] heap count = 25
Total size = 60832 [no invalid 0]
Total pinned memory on list [0] =70216, in 25 heapsPinned List [5] heap count = 0
Total size = 0 [no invalid 0]
Total pinned memory on list [5] =0, in 0 heapsTotal momory on 6 pinned lists = 272792 LRU list [1] bktcnt=19
Bucket Summary (time in second)
0: start= 100663296 size=117440512 Ht=21099814 Tm=61966
Tot= 8204 sz=117548760 (117548760) Ld= 12 Msz=1518520312[1476553]
1: start= 218103808 size=117440512 Ht=8462 Tm=22
Tot= 8204 sz=119803520 (117440512) Ld= 12 Msz=119764648[5145]
2: ......
10: start= 1275068416 size=117440512 Ht=2424 Tm=5
Tot= 6957 sz=117266896 (117266896) Ld= 8 Msz= 0[ 0]
XX: .......
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货