內容包括
statspack安裝
statspack報告的具體說明
Statspack 使用說明
一．statspack系統安裝 1
二．Statspack介紹 2
三．Statspack使用 4
四．Statspack報告說明 5
一．statspack系統安裝
statspack的安裝程序在@?/rdbms/admin/下:
spcreate.sql 安裝
spdrop.sql 卸載
spauto.sql: 生成自動采集數據任務
sPReport.sql 生成分析報告
spueXP.sql 參數文件
sppurge.sql 清除不在需要的數據
sptrunc.sql 清除所有的數據
sprepsql.sql:用于根據給定的SQL HASH值生成SQL報告
為了能順利地運行Statspack 工具，則需要設置以下參數：
job_queue_processes>0 (假如不采用自動采集數據則可不設)
timed_statistics=true (假如不采用自動采集數據則可不設)
安裝
1.建一個單獨的表空間用于Statspack 或建在tools表空間上(>100MB)
$sqlplus “/ as sysdba”
SQL>create tablespace perfstat
SQL>datafile ‘/Oracle/oradata/perfstat.dbf’
SQL>size 500M extent management local;
2.建用戶perfstat及表
SQL>@?/rdbms/admin/spcreate.sql
要求輸入表空間及臨時表空間.
建完后會在本目錄下生成：
spauto.lis
spcpkg.lis
spctab.lis
spcusr.lis
spdtab.lis
spdusr.lis
grep –I “ora-“ *.lis 查看是否有錯。
3．刪除statspack表
SQL>@?/rdbms/admin/spdrop.sql
4.測試statspack
采樣數據
SQL> exec statspack.snap
后隔幾分鐘后再次采樣數據
SQL> exec statspack.snap
生成報表
SQL>@?/rdbms/admin/spreport.sql
二．Statspack介紹
Oracle9i調優順序一般采用自頂向下的順序：
Statspack源于utlbstat和utlestat工具，在執行快照時，statspack會從 SGA內部的RAW內存結構中來采樣數據，并將結果存入相應表中。
RAW v$內存結構表 à statspack stats$內存結構表
V$sysstat stats$sysstat
V$sgastat stats$sgastat
V$parameter stats$parameter
V$librarycache stats$librarycache
1． 外部環境
內存
vmstat
bash-2.03$ vmstat 2 5
procs memory page disk faults cpu
r b w swap free re mf pi po fr de sr s0 s1 s1 -- in sy cs us sy id
0 0 0 9868032 2120968 14 3 159 8 8 0 0 0 0 24 0 306 455 1204 1 2 97
0 1 0 9813224 2154792 29 6 0 20 20 0 0 0 0 39 0 388 9587 2353 3 3 94
0 0 0 9813224 2154296 39 0 0 40 40 0 0 0 1 46 0 393 9529 2363 5 3 92
0 1 0 9813224 2153736 36 3 0 20 20 0 0 0 0 48 0 397 9387 2364 3 3 93
0 0 0 9813224 2153232 37 3 0 20 20 0 0 0 0 48 0 397 9483 2360 4 3 93
其中：
CPU瓶頸:
proc下：
r:正在運行的任務隊列，當r>CPU數量時，則會出現CPU等待瓶頸
查看CPU個數：
psrinfo –vgrep –I “status of processor” wc -l
RAM瓶頸:
Page下：
Pi:頁導入次數：假如RAW短缺時，系統會產生pi操作
查看內存容量
prtconfgrep –i “mem”
2． 系統IO
sar –d
bash-2.03$ sar -d 2 2
SunOS mydb001 5.8 Generic_108528-13 sun4us 01/09/04
08:35:11 device %busy avque r+w/s blks/s avwait avserv
08:35:13 nfs1 0 0.0 0 0 0.0 0.0
sd0 0 0.0 0 0 0.0 0.0
sd1 0 0.0 0 40 0.0 6.3
sd1,a 0 0.0 0 40 0.0 6.3
sd1,c 0 0.0 0 0 0.0 0.0
sd1,d 0 0.0 0 0 0.0 0.0
sd1,e 0 0.0 0 0 0.0 0.0
sd1,f 0 0.0 0 0 0.0 0.0
sd16 28 0.5 51 817 0.0 10.2
sd16,a 28 0.5 51 817 0.0 10.2
sd16,c 0 0.0 0 0 0.0 0.0
ohci0,bu 0 0.0 0 0 0.0 0.0
ohci0,ct 0 0.0 0 0 0.0 0.0
ohci0,in 0 0.0 0 0 0.0 0.0
ohci0,is 0 0.0 0 0 0.0 0.0
ohci0,to 0 0.0 0 0 0.0 0.0
08:35:15 nfs1 0 0.0 0 0 0.0 0.0
sd0 0 0.0 0 0 0.0 0.0
sd1 0 0.0 1 79 0.0 4.9
sd1,a 0 0.0 1 79 0.0 4.9
sd1,c 0 0.0 0 0 0.0 0.0
sd1,d 0 0.0 0 0 0.0 0.0
sd1,e 0 0.0 0 0 0.0 0.0
sd1,f 0 0.0 0 0 0.0 0.0
sd16 27 0.5 47 745 0.0 10.4
sd16,a 27 0.5 47 745 0.0 10.4
sd16,c 0 0.0 0 0 0.0 0.0
ohci0,bu 0 0.0 0 0 0.0 0.0
ohci0,ct 0 0.0 0 0 0.0 0.0
ohci0,in 0 0.0 0 0 0.0 0.0
ohci0,is 0 0.0 0 0 0.0 0.0
ohci0,to 0 0.0 0 0 0.0 0.0
Average nfs1 0 0.0 0 0 0.0 0.0
sd0 0 0.0 0 0 0.0 0.0
sd1 0 0.0 1 59 0.0 5.4
sd1,a 0 0.0 1 59 0.0 5.4
sd1,c 0 0.0 0 0 0.0 0.0
sd1,d 0 0.0 0 0 0.0 0.0
sd1,e 0 0.0 0 0 0.0 0.0
sd1,f 0 0.0 0 0 0.0 0.0
sd16 27 0.5 49 781 0.0 10.3
sd16,a 27 0.5 49 781 0.0 10.3
sd16,c 0 0.0 0 0 0.0 0.0
ohci0,bu 0 0.0 0 0 0.0 0.0
ohci0,ct 0 0.0 0 0 0.0 0.0
ohci0,in 0 0.0 0 0 0.0 0.0
ohci0,is 0 0.0 0 0 0.0 0.0
ohci0,to 0 0.0 0 0 0.0 0.0
說明 ：
一般%busy高些，%avque低些，文件系統的效率會較高,目前系統文件系統效率已達到
三．Statspack使用
3． 手工采樣數據
sqlplus perfstat/perfstat
SQL> exec statspack.snap
后隔幾分鐘后再次采樣數據
SQL> exec statspack.snap
生成報表
SQL>@?/rdbms/admin/spreport.sql
4． 系統自動采樣數據
定義定時任務
修改spauto.sql內容，定義采樣數據的時間間隔
dbms_job.submit(:jobno,’statspack.snap;’,trunc(sysdate+1/24,”HH”),’trunc(sysdate+1/24,”HH”),TRUE,:instno);
一天24小時，1440分鐘，則：
每小時一次： 1/24 (建議使用)
每30分鐘一次： 1/48
每10分鐘一次 1/144
每5分鐘一次 1/288
后執行
SQL>＠?/rdbms/admin/spauto.sql
生成分析報告
SQL>＠?/rdbms/admin/spreport.sql
停止定時任務
sqlplus perfstat/perfstat
SQL>select job,interval from user_jobs;
SQL>exec dbms_job.remove(‘:job_no’);
刪除歷史數據
delete from stats$snapshot where snap_id<???
刪除全部數據
SQL>＠?/rdbms/admin/sptrunc.sql
四．Statspack報告說明
Statspack報告分為幾個部分：
5． 數據庫總體信息
6． 每秒每事務的資源消耗情況
7． 實例的各組件的命中率
8． 共享池總體情況
9． 前5個等待事件
10． DB所有等待事件
11． 后臺進程等待事件
12． 根據BufferGets進行排序的SQL
13． 按物理IO進行排序的SQL
14． 按執行次數排序的SQL
15． 按分析次數排序的SQL
16． 實例的當前活動的統計數據
17． tablespace IO統計數據
18． 表空間文件 IO統計數據
19． buffer池統計數據
20． 實例恢復統計數據
21． Buffer池的參考數據
22． Buffer等待統計數據
23． PGA總體統計數據 1
24． PGA總體統計數據2
25． PGA內存參考數據
26． 回滾段統計
27． 回滾段存儲統計
28． undo段總體情況
29． undo段統計
30． 鎖存器的當前情況
31． 鎖存器睡眠等待統計
32． 鎖存器失敗情況
33． 數據字典cache性能統計
34． 庫cache 性能統計
35． 共享池性能統計
36． SGA區總體情況
37． SGA各組件的活動情況
38． 系統配置參數
STATSPACK report for
------------------------------------1.DB的總體信息----------------------------------------------------
DB Name DB Id Instance Inst Num Release Cluster Host
------------ ----------- ------------ -------- ----------- ------- ------------
MYDB 2125240762 mydb 1 9.2.0.1.0 NO VCS-SERVER1
Snap Id Snap Time sessions Curs/Sess Comment
------- ------------------ ------- --------- -------------------
Begin Snap: 1 09-Aug-04 19:28:12 32 2.7
End Snap: 2 09-Aug-04 19:33:06 32 3.0
Elapsed: 4.90 (mins) (本次報告的間隔時間)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 1,536M Std Block Size: 8K
Shared Pool Size: 112M Log Buffer: 16,000K
--------------------------2.每秒每事務的資源消耗情況---------------------
Load Profile
~~~~~~~~~~~~ Per Second (每秒) Per Transaction(每事務)
--------------- ---------------
Redo size: 38,498.93 6,733.30 –每秒/每事務產生的redo大小
Logical reads: 593.28 103.76 –每秒/每事務邏輯讀
Block changes: 77.60 13.57 –每秒/每事務修改的塊數
Physical reads: 2.65 0.46 -- 每秒/每事務物理讀
Physical writes: 8.17 1.43 —每秒/每事務物理寫
User calls: 38.32 6.70
Parses: 6.52 1.14 --SQL分析的次數
Hard parses: 0.05 0.01 –SQL硬分析的次數
Sorts: 0.73 0.13--
Logons: 0.01 0.00
Executes: 39.64 6.93
Transactions: 5.72
% Blocks changed per Read: 13.08 Recursive Call %: 24.84
Rollback per transaction %: 0.00 Rows per Sort: 138.04
說明：
硬分析：就是之前不存在此SQL，是第一次解析。 假如SQL重用度很高，則硬解析應保持很低。
% Blocks changed per Read：表示邏輯讀用于只讀而不是修改的塊的比例
Recursive Call %:遞歸調用SQL的比例，在PL/SQL上執行的SQL稱為遞歸的SQL
Rollback per transaction %: 事務的回滾率
Rows per Sort: 每次排序的記錄行數
-----------------------------------3.實例的各組件的命中率-----------------------------------
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.55 In-memory Sort %: 100.00
Library Hit %: 99.33 Soft Parse %: 99.16
Execute to Parse %: 83.56 Latch Hit %: 99.99
Parse CPU to Parse ElaPSD %: % Non-Parse CPU:
說明：
Execute to Parse %: 是語句執行與分析的比例，假如要SQL重用率高，則這個比例會很高。
Soft Parse %:軟分析：即在共享池中重復使用的SQL，系統應保持較高的軟分析率，否則說明系統的SQL沒有綁定變量。
Parse CPU to Parse Elapsd %: 用于分析每個CPU 花費的秒數，應該處于較高比例。假如=100%,說明CPU沒有等待。
---------------------------------4.共享池總體情況---------------------------------------------------------
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 89.91 90.55
% SQL with executions>1: 32.14 32.67
% Memory for SQL w/exec>1: 31.30 33.38
說明：
Memory Usage %: 正在使用的共享池的%,這個值應保持在75%~100%,假如這個值太低，就浪費內存，假如太高，會使共享池外部的組件老化，假如SQL語句被再次執行，則就會發生硬分析。
% SQL with executions>1:共享池中有多少執行次數大于一次的SQL語句的度量。
% Memory for SQL w/exec>1: 頻繁使用的SQL語句消耗內存多少的比例。
------------------------------5.前5個等待事件------------------------------------------------
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
db file sequential read 623 3 46.70
log file sync 1,682 2 32.30
control file parallel write 95 1 8.16
db file parallel write 190 0 6.09
log file parallel write 1,674 0 5.77
-------------------------------------------------------------
說明：
log file sync:當一個用戶的會話提交時，會話的重寫信息需要刷新到重做日志文件中，這個用戶會話將發送LGWR將日志緩沖寫到重做日志文件，當LGWR已經完成寫入操作時，它將發送這個用戶會話。
Wait Time:等待時間包括日志緩沖的寫入和發送操作。
--------------------------------------6.DB所有等待事件-------------------------------------------------
Wait Events for DB: MYDB Instance: mydb Snaps: 1 -2
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
db file sequential read 623 0 3 5 0.4
log file sync 1,682 0 2 1 1.0
control file parallel write 95 0 1 6 0.1
db file parallel write 190 95 0 2 0.1
log file parallel write 1,674 1,664 0 0 1.0
db file scattered read 25 0 0 2 0.0
control file sequential read 78 0 0 0 0.0
LGWR wait for redo copy 13 0 0 0 0.0
SQL*Net break/reset to clien 4 0 0 0 0.0
buffer busy waits 2 0 0 0 0.0
latch free 1 0 0 0 0.0
SQL*Net message from client 10,830 0 4,364 403 6.4
SQL*Net more data from clien 1,596 0 0 0 0.9
SQL*Net message to client 10,830 0 0 0 6.4
-------------------------------------------------------------
--------------------------------7.后臺進程等待事件-----------------------------------------
Background Wait Events for DB: MYDB Instance: mydb Snaps: 1 -2
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
control file parallel write 95 0 1 6 0.1
db file parallel write 190 95 0 2 0.1
log file parallel write 1,674 1,664 0 0 1.0
control file sequential read 36 0 0 0 0.0
LGWR wait for redo copy 13 0 0 0 0.0
rdbms ipc message 5,352 3,687 1,148 214 3.2
smon timer 1 1 281 ###### 0.0
-------------------------------------------------------------
------------------8.根據BufferGets進行排序的SQL-----------------------------------
SQL ordered by Gets for DB: MYDB Instance: mydb Snaps: 1 -2
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
74,380 20 3,719.0 42.6 0.00 5.03 1027916473
select count(*) from myuser.userbaseinfo
10,920 1,291 8.5 6.3 0.00 0.71 1385081364
insert into Refence_tabvalues(:p1, :p2, :p3, :p4, :p5,:p6)
10,629 132 80.5 6.1 0.00 0.49 2785281485
update msginfo set Orig_Addr=:p1,Dest_Addr=:p2,service_type=:p3
,sub_serv_type=:p4,TransactionID=:p5,Priority=:p6,state=:p7,Send
Count=:p8,errorCode=:p9,finalDate=:p10,smFlag=:p11,tVaspId=:p12,
tVasId=:p13,tServiceCode=:p14,DateTime=:p15,DeliveryTime=:p16,Re
adReply=:p17,bAdaptations=:p18,ContentType=:p19,bMsgDistributeIn
9,751 2,435 4.0 5.6 0.00 0.70 2271041384
select * from msginfo where msg_id=:p1
9,625 2,907 3.3 5.5 0.00 0.93 1077832894
select * from userinfo where sub_isdn=:p1
5,824 1,962 3.0 3.3 0.00 1.72 2431777133
select * from destinfo where sub_isdn=:p1
5,787 1,156 5.0 3.3 0.00 0.55 3134087587
select * from msginfo_all where msg_id=:p1
4,648 90 51.6 2.7 0.00 0.51 1112211039
begin smsc_util.modify_destinfo(:p1,:p2,:p3,:p4,:p5,:p6,:p7,:p8,:p9,:p10,:p11,:p12,:p13,:p14); end;
4,031 90 44.8 2.3 0.00 0.23 3842824015
UPDATE destinfo SET sub_isdn = :b14, NonMmsEmailAddr = :b13, sub_state= :b12,
local_time = :b11, desiredTime =:b10, dest_inf = :b9, msg_num = :b8, done_msg_info = :b7, mailN
3,293 67 49.1 1.9 0.00 0.16 2175688974
insert into msginfo values(:p1,:p2,:p3,:p4,:p5,:p6,:p7,:p8,:p9,
:p10,:p11,:p12,:p13,:p14,:p15,:p16,:p17,:p18,:p19,:p20,:p21,:p22
,:p23,:p24,:p25,:p26,:p27,:p28,:p29,:p30,:p31,:p32,:p33,:p34,:p3
5,:p36,:p37,:p38,:p39,:p40,:p41,:p42,:p43,:p44,:p45,:p46,:p47,:p
48,:p49,:p50,:p51,:p52,:p53,:p54,:p55,:p56,:p57,:p58,:p59,:p60,:
2,149 28 76.8 1.2 0.00 0.21 3752979796
delete from Refence_tabwhere SrvMsgID=:p1 and dest_addr=:p2
1,888 118 16.0 1.1 0.00 0.08 2500993063
select ISDN,pass from smReq where isDel = '0'
1,888 118 16.0 1.1 0.00 0.11 4041890278
delete smReq where isDel = '1' and regType = '0'
1,842 56 32.9 1.1 0.00 0.27 1728016048
begin smsc_util.OriginDone(:p1, :p2); end;
1,679 23 73.0 1.0 0.00 0.05 156420249
select Refrence, orig_addr, MMType from Refence_tabwhere SrvMsgID=:p1 and dest_addr=:p2
930 198 4.7 0.5 0.00 0.06 3744392743
UPDATE origininfo set sendnum=:b3, MsgList=:b2 where sub_isdn=:b1
717 220 3.3 0.4 0.00 0.13 3466225112
SELECT sendnum, MsgList from origininfo where sub_isdn=:b1
640 40 16.0 0.4 0.00 0.03 776298407
select count(*) from smReq
527 42 12.5 0.3 0.00 0.12 3721822251
INSERT INTO destinfo VALUES(:b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9,:b10, :b11, :b12, :b13, :b14)
187 48 3.9 0.1 0.00 0.23 4009906312
select bMonthBillState, bMsgStatus from monthbillinfo where wYear=:p1 and bMonth=:p2 and tBillAddr=:p3 and tVaspId=:p4 and tVasId=:p5 and tServiceCode=:p6 and tDestAddr=:p7
171 12 14.3 0.1 0.00 0.08 664582079
begin smsc_util.Auto_OpenSubServ(:p1,:p2,:p3,:p4,:p5,:p6,:p7,:p8,:p9,:p10,:p11,:p12,:p13,:p14,:p15,:p16,:p17,:p18,:p19,:p20,:p21,:p22); end;
140 20 7.0 0.1 0.00 0.01 2872798779
select count(*) from myuser.sys_var
139 22 6.3 0.1 0.00 0.01 714875384
INSERT into origininfo values(:b1, :b3, :b2)
114 57 2.0 0.1 0.00 0.02 2963598673
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date < :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5) ) and (this_date is null) order by next_date, job
110 12 9.2 0.1 0.00 0.02 1315078830
INSERT INTO userinfo VALUES(:b22 ,:b21 ,:b20 ,:b19 ,:b18
-------------------------------------------------------------
說明：
就是通過執行了多少個邏輯IO來排序
--------------------------9.按物理IO進行排序的SQL------------------------------------------------
SQL ordered by Reads for DB: MYDB Instance: mydb Snaps: 1 -2
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
246 1,962 0.1 31.5 0.00 1.72 2431777133
select * from destinfo where sub_isdn=:p1
149 20 7.5 19.1 0.00 5.03 1027916473
select count(*) from myuser.userbaseinfo
110 2,907 0.0 14.1 0.00 0.93 1077832894
select * from userinfo where sub_isdn=:p1
100 1,156 0.1 12.8 0.00 0.55 3134087587
select * from msginfo_all where msg_id=:p1
89 1 89.0 11.4 0.00 2.46 2700929825
Module: SQL*Plus BEGIN statspack.snap(); END;
31 2,435 0.0 4.0 0.00 0.70 2271041384
select * from msginfo where msg_id=:p1
31 48 0.6 4.0 0.00 0.23 4009906312
select bMonthBillState, bMsgStatus from monthbillinfo where wYear=:p1 and bMonth=:p2 and tBillAddr=:p3 and tVaspId=:p4 and tVasId=:p5 and tServiceCode=:p6 and tDestAddr=:p7
-------------------------------------------------------------
說明：
假如發現系統的IO有限制，則可檢查上述的SQL語句。
--------------------------------10.按執行次數排序的SQL-----------------------------------------
SQL ordered by Executions for DB: MYDB Instance: mydb Snaps: 1 -2
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
2,907 904 0.3 0.00 0.00 1077832894
select * from userinfo where sub_isdn=:p1
2,435 2,435 1.0 0.00 0.00 2271041384
select * from msginfo where msg_id=:p1
1,962 1,893 1.0 0.00 0.00 2431777133
select * from destinfo where sub_isdn=:p1
1,291 1,291 1.0 0.00 0.00 1385081364
insert into Refence_tabvalues(:p1, :p2, :p3, :p4, :p5,:p6)
1,156 1,156 1.0 0.00 0.00 3134087587
select * from msginfo_all where msg_id=:p1
220 198 0.9 0.00 0.00 3466225112
SELECT sendnum, MsgList from origininfo where sub_isdn=:b1
198 198 1.0 0.00 0.00 3744392743
UPDATE origininfo set sendnum=:b3, MsgList=:b2 where sub_isdn=:b1
132 3,171 24.0 0.00 0.00 2785281485
update msginfo set Orig_Addr=:p1,Dest_Addr=:p2,service_type=:p3
,sub_serv_type=:p4,TransactionID=:p5,Priority=:p6,state=:p7,Send
Count=:p8,errorCode=:p9,finalDate=:p10,smFlag=:p11,tVaspId=:p12,
tVasId=:p13,tServiceCode=:p14,DateTime=:p15,DeliveryTime=:p16,Re
adReply=:p17,bAdaptations=:p18,ContentType=:p19,bMsgDistributeIn
118 0 0.0 0.00 0.00 2500993063
select ISDN,pass from smReq where isDel = '0'
118 0 0.0 0.00 0.00 4041890278
delete smReq where isDel = '1' and regType = '0'
90 90 1.0 0.00 0.01 1112211039
begin smsc_util.modify_destinfo(:p1,:p2,:p3,:p4,:p5,:p6,:p7,:p8,:p9,:p10,:p11,:p12,:p13,:p14); end;
90 0 0.0 0.00 0.00 1912568914
COMMIT WORK
90 1,152 12.8 0.00 0.00 3842824015
UPDATE destinfo SET sub_isdn = :b14, NonMmsEmailAddr = :b13, sub_state = :b12,
local_time = :b11, desiredTime =:b10, dest_info = :b9, msg_num = :b8, done_msg_info = :b7, mailN
68 0 0.0 0.00 0.00 3615375148
COMMIT
67 1,206 18.0 0.00 0.00 2175688974
insert into msginfo values(:p1,:p2,:p3,:p4,:p5,:p6,:p7,:p8,:p9,
:p10,:p11,:p12,:p13,:p14,:p15,:p16,:p17,:p18,:p19,:p20,:p21,:p22
,:p23,:p24,:p25,:p26,:p27,:p28,:p29,:p30,:p31,:p32,:p33,:p34,:p3
5,:p36,:p37,:p38,:p39,:p40,:p41,:p42,:p43,:p44,:p45,:p46,:p47,:p
48,:p49,:p50,:p51,:p52,:p53,:p54,:p55,:p56,:p57,:p58,:p59,:p60,:
59 0 0.0 0.00 0.00 4064019595
select ISDN from syncsubReq where regType='D'
57 0 0.0 0.00 0.00 2963598673
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= n
ext_date) and (next_date < :2)) or ((last_date is null) and
(next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)
) and (this_date is null) order by next_date, job
57 57 1.0 0.00 0.00 2964743345
select count(*) from sys.job$ where (next_date > sysdate) and (n
ext_date < (sysdate+5/86400))
56 56 1.0 0.00 0.00 1728016048
begin smsc_util.OriginDone(:p1, :p2); end;
48 43 0.9 0.00 0.00 4009906312
select bMonthBillState, bMsgStatus from monthbillinfo where wYea
r=:p1 and bMonth=:p2 and tBillAddr=:p3 and tVaspId=:p4 and tVasI
d=:p5 and tServiceCode=:p6 and tDestAddr=:p7
42 81 1.9 0.00 0.00 3721822251
INSERT INTO destinfo VALUES(:b1, :b2, :b3,:b4, :b5, :b6, :b7, :b8, :b9,
:b10, :b11, :b12, :b13, :b14)
40 40 1.0 0.00 0.00 776298407
select count(*) from smReq
28 26 0.9 0.00 0.01 3752979796
delete from Refence_tabwhere SrvMsgID=:p1 and dest_addr=:p2
23 10 0.4 0.00 0.00 156420249
select Refrence, orig_addr, MMType from Refence_tabwhere SrvMsgID=:p1 and dest_addr=:p2
22 22 1.0 0.00 0.00 714875384
