WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
DBQUERY475955152dbquery4103-Feb-14 15:0211.2.0.4.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
mysqldb87Linux x86 64-bit 80 40 4 378.49

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:298319-Feb-14 09:00:54461 3.0
End Snap:298419-Feb-14 10:46:17563 1.9
Elapsed:  105.39 (mins)  
DB Time:  197.87 (mins)  

Report Summary

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 1.9 0.0 0.00 0.00
DB CPU(s): 1.4 0.0 0.00 0.00
Redo size (bytes): 2,998,251.1 4,293.3  
Logical read (blocks): 39,809.5 57.0  
Block changes: 17,253.7 24.7  
Physical read (blocks): 76.4 0.1  
Physical write (blocks): 1,193.1 1.7  
Read IO requests: 75.2 0.1  
Write IO requests: 657.8 0.9  
Read IO (MB): 0.6 0.0  
Write IO (MB): 9.3 0.0  
User calls: 4,446.6 6.4  
Parses (SQL): 1,584.1 2.3  
Hard parses (SQL): 0.9 0.0  
SQL Work Area (MB): 0.6 0.0  
Logons: 0.5 0.0  
Executes (SQL): 1,678.5 2.4  
Rollbacks: 226.7 0.3  
Transactions: 698.4   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99Redo NoWait %: 100.00
Buffer Hit %: 99.82In-memory Sort %: 100.00
Library Hit %: 99.91Soft Parse %: 99.94
Execute to Parse %: 5.62Latch Hit %: 99.95
Parse CPU to Parse Elapsd %: 38.93% Non-Parse CPU: 98.63

Top 10 Foreground Events by Total Wait Time

EventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Class
DB CPU 8570.2 72.2 
log file sync3,324,8002735123.0Commit
db file sequential read432,783798.126.7User I/O
enq: TX - row lock contention3,133435.21393.7Application
SQL*Net break/reset to client775,742224.601.9Application
SQL*Net message to client19,161,56941.60.4Network
read by other session6,39632.95.3User I/O
enq: TX - allocate ITL entry2212.1549.1Configuration
log file switch (checkpoint incomplete)4444.19.0Configuration
db file scattered read1,0693.94.0User I/O

Wait Classes by Total Wait Time

Wait ClassWaitsTotal Wait Time (sec)Avg Wait (ms)% DB timeAvg Active Sessions
DB CPU 8,570 72.21.4
Commit3,324,8022,735123.00.4
Concurrency27,395994368.40.2
User I/O458,59383927.10.1
System I/O6,646,90377506.50.1
Application778,87566015.60.1
Other362,564620.50.0
Network19,205,809430.40.0
Configuration1,8372112.20.0

Host CPU

CPUsCoresSocketsLoad Average BeginLoad Average End%User%System%WIO%Idle
80 40 4 1.25 1.88 1.3 0.6 0.2 97.9

Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
2.0 96.5 0.0

IO Profile

Read+Write Per SecondRead per SecondWrite Per Second
Total Requests: 1,334.1 84.5 1,249.6
Database Requests: 733.0 75.2 657.8
Optimized Requests: 0.0 0.0 0.0
Redo Requests: 590.1 3.2 586.9
Total (MB): 19.8 3.9 16.0
Database (MB): 9.9 0.6 9.3
Optimized Total (MB): 0.0 0.0 0.0
Redo (MB): 6.2 3.1 3.1
Database (blocks): 1,269.5 76.4 1,193.1
Via Buffer Cache (blocks): 1,261.4 69.7 1,191.6
Direct (blocks): 8.1 6.7 1.4

Memory Statistics

BeginEnd
Host Mem (MB): 387,577.0 387,577.0
SGA use (MB): 203,885.7 203,885.7
PGA use (MB): 1,574.7 1,623.6
% Host Mem used for SGA+PGA: 53.01 53.02

Cache Sizes

BeginEnd
Buffer Cache: 151,040M 151,040MStd Block Size: 8K
Shared Pool Size: 7,700M 7,757MLog Buffer: 110,120K

Shared Pool Statistics

BeginEnd
Memory Usage %: 94.25 94.07
% SQL with executions>1: 99.02 98.43
% Memory for SQL w/exec>1: 98.90 98.72

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU8,570.1672.19
sql execute elapsed time5,334.0544.93
parse time elapsed414.523.49
connection management call elapsed time89.420.75
hard parse elapsed time19.330.16
hard parse (sharing criteria) elapsed time16.610.14
hard parse (bind mismatch) elapsed time11.350.10
PL/SQL execution elapsed time1.440.01
inbound PL/SQL rpc elapsed time1.210.01
repeated bind elapsed time0.090.00
RMAN cpu time (backup/restore)0.020.00
PL/SQL compilation elapsed time0.020.00
DB time11,872.05 
background elapsed time4,083.29 
background cpu time1,498.03 


Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME1,043,086 
IDLE_TIME49,399,839 
IOWAIT_TIME80,267 
NICE_TIME0 
SYS_TIME320,515 
USER_TIME673,725 
LOAD12
RSRC_MGR_CPU_WAIT_TIME0 
PHYSICAL_MEMORY_BYTES406,403,956,736 
NUM_CPUS80 
NUM_CPU_CORES40 
NUM_CPU_SOCKETS4 
GLOBAL_RECEIVE_SIZE_MAX2,107,649,024 
GLOBAL_SEND_SIZE_MAX1,048,576 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX4,194,304 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX4,194,304 
TCP_SEND_SIZE_MIN4,096 


Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
19-Feb 09:00:541.25     
19-Feb 10:46:171.882.071.340.6497.930.16


Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  8,570 72.19
Commit3,324,80002,735123.04
User I/O451,722083627.04
Application778,875066015.56
Network19,200,08504300.36
Configuration934721230.18
Concurrency26,1480900.07
System I/O15,5460200.02
Other5,6744200.01


Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
log file sync3,324,80002,73510.7523.04
db file sequential read432,783079820.106.72
enq: TX - row lock contention3,13304351390.003.67
SQL*Net break/reset to client775,742022500.181.89
SQL*Net message to client19,161,56904204.340.35
read by other session6,39603350.000.28
enq: TX - allocate ITL entry2236125490.000.10
log file switch (checkpoint incomplete)4440490.000.03
db file scattered read1,0690440.000.03
log file switch (private strand flush incomplete)29904120.000.03
library cache: mutex X1,5230220.000.02
control file sequential read15,4410200.000.02
SQL*Net more data from client38,3270200.010.01
enq: TX - index contention1,1230110.000.01
cursor: mutex S1,1750110.000.01
Disk file operations I/O11,4390100.000.01
buffer busy waits8,5160100.000.01
undo segment extension64951120.000.01
latch: In memory undo latch4,3760100.000.01
cursor: pin S1450150.000.01
log file switch completion3700110.000.00
cursor: pin S wait on X2100180.000.00
latch: redo allocation1,3980000.000.00
cursor: mutex X4,8410000.000.00
recovery area: computing obsolete files1003370.000.00
latch: cache buffers chains4,0640000.000.00
latch: object queue header operation2,6830000.000.00
recovery area: computing backed up files1002750.000.00
latch free6770000.000.00
enq: HW - contention680010.000.00
Data file init write310030.000.00
recovery area: computing dropped files100750.000.00
control file single write670010.000.00
latch: row cache objects2960000.000.00
latch: messages2130000.000.00
latch: enqueue hash chains1590000.000.00
enq: FB - contention410010.000.00
db file parallel read200130.000.00
ADR block file read840000.000.00
latch: shared pool680000.000.00
enq: TX - contention140010.000.00
CSS initialization30050.000.00
latch: undo global data580000.000.00
buffer deadlock249100000.000.00
control file parallel write370000.000.00
enq: CF - contention10060.000.00
latch: cache buffers lru chain270000.000.00
CSS operation: action30020.000.00
rdbms ipc reply10040.000.00
SQL*Net more data to client1890000.000.00
ADR block file write150000.000.00
CSS operation: query180000.000.00
SQL*Net message from client19,160,61605,332,7352784.34 
jobq slave wait8,2801004,1445010.00 
KSV master wait400010.00 


Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
os thread startup1,14209868630.0024.14
log file parallel write2,940,041043100.6710.55
db file parallel write1,823,880030300.417.43
LGWR wait for redo copy335,67203300.080.81
log file sequential read10,41802730.000.66
enq: PR - contention270103880.000.26
ASM file metadata operation5,2290820.000.20
control file sequential read22,0910700.010.17
reliable message3,5920620.000.14
db file async I/O submit1,828,1240400.410.09
Data file init write1,1770220.000.05
control file parallel write6,5050100.000.03
latch: redo allocation3,1610100.000.02
db file sequential read6310110.000.02
direct path read1340140.000.01
rdbms ipc reply4200100.000.01
latch free1,3140000.000.01
latch: object queue header operation3,5600000.000.01
kfk: async disk IO2010010.000.01
enq: CF - contention1000270.000.01
Disk file operations I/O4,8230000.000.00
latch: redo writing9030000.000.00
latch: messages7380000.000.00
Log archive I/O530020.000.00
db file single write420020.000.00
latch: checkpoint queue latch1830000.000.00
log file single write1060000.000.00
enq: CI - contention200140.000.00
latch: cache buffers lru chain2890000.000.00
asynch descriptor resize2,945100000.000.00
CSS initialization40060.000.00
ADR block file read160010.000.00
RMAN backup & recovery I/O20050.000.00
buffer busy waits680000.000.00
SQL*Net message to client5,7100000.000.00
direct path write630000.000.00
CSS operation: action40010.000.00
wait list latch free30010.000.00
latch: cache buffers chains240000.000.00
latch: call allocation200000.000.00
CSS operation: query240000.000.00
rdbms ipc message2,601,8702159,446610.59 
Space Manager: slave idle wait19,2673859,41130840.00 
EMON slave idle wait6,34310031,61849850.00 
class slave wait3,671012,64234440.00 
DIAG idle wait12,59010012,60610010.00 
Streams AQ: waiting for time management or cleanup tasks30576,3652121550.00 
dispatcher timer1061006,361600110.00 
shared server idle wait2111006,332300120.00 
Streams AQ: emn coordinator idle wait6331006,332100030.00 
Streams AQ: qmn coordinator idle wait452506,330140050.00 
Streams AQ: qmn slave idle wait22606,330280090.00 
wait for unread message on broadcast channel6,3161006,32410010.00 
ASM background timer2,81806,32322440.00 
pmon timer2,128976,31629680.00 
smon timer89806,31470320.00 
SQL*Net message from client8,49503340.00 
KSV master wait1,9170740.00 


Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read10098.0  1.01.0   
ADR block file write20100.0       
ADR file lock24100.0       
ARCH wait for archivelog lock54100.0       
ASM file metadata operation523389.44.62.1.71.0.91.4 
CSS initialization7   100.0    
CSS operation: action7 100.0      
CSS operation: query42100.0       
Data file init write120850.719.819.08.32.0.2  
Disk file operations I/O16.3K99.6.2.1.1.0   
LGWR wait for redo copy336.5K99.7.3.0.0    
Log archive I/O5318.947.232.11.9    
RMAN backup & recovery I/O250.0   50.0   
SQL*Net break/reset to client775.6K96.52.8.5.2.0.0.0.0
SQL*Net message to client19.2M100.0.0.0     
SQL*Net more data from client38.3K99.6.2.1.1.0.0.0 
SQL*Net more data to client196100.0       
asynch descriptor resize2947100.0       
buffer busy waits859299.4.6.0 .0   
buffer deadlock24999.2.8      
control file parallel write654399.3.4.2.1.0   
control file sequential read37.5K97.8.81.0.3.1.0.0 
control file single write6740.356.73.0     
cursor: mutex S117588.4.9  10.7   
cursor: mutex X484199.0.5.0 .5   
cursor: pin S14656.2   43.8   
cursor: pin S wait on X21  4.8 76.29.59.5 
db file async I/O submit1828.1K100.0       
db file parallel read2    100.0   
db file parallel write1823.8K99.8.1.0.0.0.0.0 
db file scattered read106948.55.913.121.97.62.7.4 
db file sequential read433.5K56.125.77.57.42.3.8.1 
db file single write4374.4 9.37.09.3   
direct path read13434.321.623.96.77.56.0  
direct path write63100.0       
direct path write temp1100.0       
enq: CF - contention11 9.19.19.1 63.69.1 
enq: CI - contention2    100.0   
enq: FB - contention4173.226.8      
enq: HW - contention6880.94.42.94.47.4   
enq: PR - contention273.73.77.43.725.93.751.9 
enq: TX - allocate ITL entry2218.2     77.34.5
enq: TX - contention1450.035.714.3     
enq: TX - index contention112374.211.87.24.31.6.7.2 
enq: TX - row lock contention313617.928.427.410.54.3.86.54.4
enq: XL - fault extent map1100.0       
kfk: async disk IO20293.6.5 4.01.0.5.5 
latch free199398.1.6.11.1.2   
latch: In memory undo latch439199.2.6.2     
latch: cache buffer handles1100.0       
latch: cache buffers chains408999.7.2.0     
latch: cache buffers lru chain31699.4.3.3     
latch: call allocation20100.0       
latch: checkpoint queue latch18397.32.7      
latch: enqueue hash chains15997.52.5      
latch: messages95198.21.8      
latch: object queue header operation625299.5.4.1.0    
latch: redo allocation456898.61.3.0     
latch: redo writing903100.0       
latch: row cache objects299100.0       
latch: session allocation4100.0       
latch: shared pool7593.36.7      
latch: undo global data60100.0       
library cache: mutex X152484.4.9  14.8   
log file parallel write2943.7K99.6.3.1.0.0.0.0 
log file sequential read10.4K46.722.620.26.22.51.1.7 
log file single write106100.0       
log file switch (checkpoint incomplete)444.92.78.126.657.93.8  
log file switch (private strand flush incomplete)2991.72.05.719.163.92.35.4 
log file switch completion372.75.4 16.273.02.7  
log file sync3329.6K84.013.11.7.9.3.0.0.0
os thread startup1142    1.312.786.0 
rdbms ipc reply43  55.820.97.07.09.3 
read by other session639623.58.79.645.49.92.6.4 
recovery area: computing backed up files1      100.0 
recovery area: computing dropped files1      100.0 
recovery area: computing obsolete files1      100.0 
reliable message360662.623.5.413.1.4   
undo segment extension6445.3   25.018.810.9 
wait list latch free3 100.0      
ASM background timer281832.25.13.34.41.31.54.847.4
DIAG idle wait12.6K      99.9.1
EMON slave idle wait6343.0.0 .1  .199.8
KSV master wait195780.110.04.21.01.6.22.8.1
SQL*Net message from client19.2M19.418.717.017.420.63.12.9.9
Space Manager: slave idle wait19.2K1.1.2.3.4.81.118.477.8
Streams AQ: emn coordinator idle wait632       100.0
Streams AQ: qmn coordinator idle wait45250.0      50.0
Streams AQ: qmn slave idle wait226       100.0
Streams AQ: waiting for time management or cleanup tasks3030.0     26.743.3
class slave wait367133.64.512.25.73.710.63.826.0
dispatcher timer106       100.0
jobq slave wait8285.1     99.9 
pmon timer2128      1.298.8
rdbms ipc message2605.1K67.415.610.32.8.9.41.11.4
shared server idle wait211       100.0
smon timer9002.9.2.3.91.41.719.772.9
wait for unread message on broadcast channel6318      99.9.1


Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
ASM file metadata operation7298.6.8.5.1    
SQL*Net break/reset to client7100.0.0  .0 .0 
SQL*Net more data from client1100.0   .0   
control file sequential read3100.0.0      
cursor: pin S wait on X290.5 9.5     
db file parallel write7100.0.0.0     
db file scattered read499.6.4      
db file sequential read26299.9.1.0.0.0   
enq: CF - contention190.9 9.1     
enq: PR - contention1448.13.77.4  40.7  
enq: TX - allocate ITL entry1818.24.513.64.513.640.94.5 
enq: TX - index contention299.8.1.1     
enq: TX - row lock contention27989.2.71.92.01.0.92.41.9
kfk: async disk IO199.5 .5     
log file parallel write12100.0.0.0.0    
log file sequential read7599.3.5.2.1.0   
log file switch (private strand flush incomplete)1694.65.4      
log file sync161100.0.0.0.0.0.0 .0
os thread startup98214.0    86.0  
rdbms ipc reply490.77.02.3     
read by other session2499.6.3.0     
recovery area: computing backed up files1    100.0   
recovery area: computing dropped files1  100.0     
recovery area: computing obsolete files1    100.0   
undo segment extension789.17.83.1     


Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
enq: TX - row lock contention6198.11.6.1.2 .0  
log file sync14100.0.0.0.0    


Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
dbquery11,3848,162420180,331
SYS$USERS4713982171,265
SYS$BACKGROUND0042106
dbquery4XDB0000


Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
dbquery 437323782260919001838113842
SYS$USERS 1441254570008185512
SYS$BACKGROUND 6856312419860000


Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO SQL IdSQL ModuleSQL Text
101.36141,9590.000.8563.091.2009c07pa97cdkj JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
59.9379,3500.000.5058.1210.128ghzucdwu0gmt JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
59.73  0.5066.30 8wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
47.905,6040.010.403.570.456m3jdhd2f64f1 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
47.4090,6770.000.4052.741.80cj9mymcb3d5q0 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
42.4550,9940.000.3669.001.659axsck9pv0447 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
41.4884,9680.000.3554.509.30b3tcj0dddr2v2 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
40.6725,5930.000.3438.9852.937b67dft33n0x4 JDBC Thin Client INSERT INTO T_EXP_TAKING_STATU...
39.97170,6090.000.3450.680.02fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
39.7246,8440.000.3364.725.538vdryg1pt3vgk JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...


Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
63.94141,9590.000.75101.3663.091.2009c07pa97cdkj JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
39.60  0.4659.7366.30 8wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
34.8379,3500.000.4159.9358.1210.128ghzucdwu0gmt JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
33.12650.510.3934.1497.022.59fgcvgtv12rhrj JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
29.2950,9940.000.3442.4569.001.659axsck9pv0447 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
25.7146,8440.000.3039.7264.725.538vdryg1pt3vgk JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
25.2047,0060.000.2938.7265.092.5462b5gtpzmvaph JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
25.0090,6770.000.2947.4052.741.80cj9mymcb3d5q0 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
22.6084,9680.000.2641.4854.509.30b3tcj0dddr2v2 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
22.0649,4830.000.2635.4562.244.12fmc5ungbx9cbu JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...


Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
21.5225,5930.002.5640.6738.9852.937b67dft33n0x4 JDBC Thin Client INSERT INTO T_EXP_TAKING_STATU...
14.545,9250.001.7326.2839.3655.328wrf2prwmjcrw JDBC Thin Client select id from T_EXP_OP_RECORD...
6.0779,3500.000.7259.9358.1210.128ghzucdwu0gmt JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
3.8684,9680.000.4641.4854.509.30b3tcj0dddr2v2 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
3.3913,5670.000.4013.8652.3024.447g04ytfkrfcat JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
3.3819,7550.000.4021.1462.5916.01armutyhd6crgf JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
2.3524,7600.000.2823.6764.769.935jbmg171mz7mz JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
2.2046,8440.000.2639.7264.725.538vdryg1pt3vgk JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
1.4649,4830.000.1735.4562.244.12fmc5ungbx9cbu JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
1.4427,4670.000.1722.4460.336.4169u6frfbj80ya JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...


Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
11,128,51365171,207.894.4234.14972.6fgcvgtv12rhrj JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
4,743,423141,95933.411.88101.3663.11.209c07pa97cdkj JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
2,656,08784,96831.261.0641.4854.59.3b3tcj0dddr2v2 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
2,123,52790,67723.420.8447.4052.71.8cj9mymcb3d5q0 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
1,994,16479,35025.130.7959.9358.110.18ghzucdwu0gmt JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
1,791,6694143,699.240.7124.1134.2bvn82frd8avz4 JDBC Thin Client SELECT * FROM (SELECT T.*, ROW...
1,753,312219,1678.000.7022.5770.302jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
1,742,97059,76029.170.6929.6159.33.87puph7ypx8g5a JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
1,599,8915,925270.020.6426.2839.455.38wrf2prwmjcrw JDBC Thin Client select id from T_EXP_OP_RECORD...
1,556,64750,99430.530.6242.45691.79axsck9pv0447 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...


Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
14,0145,9252.372.9026.2839.3655.328wrf2prwmjcrw JDBC Thin Client select id from T_EXP_OP_RECORD...
12,31325,5930.482.5540.6738.9852.937b67dft33n0x4 JDBC Thin Client INSERT INTO T_EXP_TAKING_STATU...
2,10184,9680.020.4341.4854.509.30b3tcj0dddr2v2 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
1,61679,3500.020.3359.9358.1210.128ghzucdwu0gmt JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
88613,5670.070.1813.8652.3024.447g04ytfkrfcat JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
75559,7600.010.1629.6159.323.787puph7ypx8g5a JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
69146,8440.010.1439.7264.725.538vdryg1pt3vgk JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
66119,7550.030.1421.1462.5916.01armutyhd6crgf JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
65224,7600.030.1323.6764.769.935jbmg171mz7mz JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
51236,5750.010.1121.2161.515.37aby73nja82u62 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...


Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModuleSQL Text
14,01414,0145,9252.370.002.958wrf2prwmjcrw JDBC Thin Client select id from T_EXP_OP_RECORD...
41341336,5750.010.000.09aby73nja82u62 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
26826859,7600.000.000.067puph7ypx8g5a JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
224224653.450.000.05fgcvgtv12rhrj JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
11211229,5780.000.000.02ghdbndgv3sjm4 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
52525,6040.010.000.016m3jdhd2f64f1 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
4949331,5420.000.000.01d9pmgnn15y65k JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
3737112,0180.000.000.01dsqa57za58kcw JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
313195,0020.000.000.017b9fzy1w3dq3d JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
2424210,0490.000.000.011bqk0pmqg1vq6 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...


Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
331,542242,2810.7331.1240.3.3d9pmgnn15y65k JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
231,867231,8581.0023.08510c2gkrw5buc9wb JDBC Thin Client select sysdate from DUAL
219,167219,1631.0022.5770.302jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
210,049191,8790.9118.5340.3.21bqk0pmqg1vq6 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
171,055160,6640.9415.2339.1338nwhf0f1ypv JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
170,6092,9260.0239.9750.70fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
163,055110,9530.6814.7242.80fyx52u79xsh06 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
156,837157,0831.0029.4248.7.116w9b2tyb12u6 JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...
155,227105,5370.6814.0444.7.12mx77j4jyu90s JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
141,959380,8242.68101.3663.11.209c07pa97cdkj JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
131,398102,4280.7811.80430gf8mx1rhb7rf5 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
112,01892,0820.8210.2339.3.4dsqa57za58kcw JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
109,364135,4371.2420.9651.601txs4c06ctb1d JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_1...


Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
331,452331,5423.31d9pmgnn15y65k JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
231,758231,8672.31c2gkrw5buc9wb JDBC Thin Client select sysdate from DUAL
219,164219,1672.192jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
210,039210,0492.101bqk0pmqg1vq6 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
171,043171,0551.71338nwhf0f1ypv JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
170,609170,6091.70fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
163,055163,0551.63fyx52u79xsh06 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
156,831156,8371.5716w9b2tyb12u6 JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...
155,220155,2271.552mx77j4jyu90s JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
141,947141,9591.4209c07pa97cdkj JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
131,381131,3981.31gf8mx1rhb7rf5 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
112,004112,0181.12dsqa57za58kcw JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
109,362109,3641.091txs4c06ctb1d JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_1...


Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
23,260,536 0.29d7khudn7c54n6   INSERT INTO T_EXP_DELIVERY_STA...
22,044,416 0.27cak25du5pyzcp   INSERT INTO T_EXP_DELIVERY_STA...
19,408,096 0.248wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
18,766,256 0.23gf25wm6hncp21   INSERT INTO T_EXP_DELIVERY_STA...
18,413,824 0.231864ycgvgvyam   INSERT INTO T_EXP_DELIVERY_STA...
17,425,016 0.21a6nwkg0nu1grj   INSERT INTO T_EXP_DELIVERY_STA...
16,667,176 0.2009qtbd90zbmkv   INSERT INTO T_EXP_DELIVERY_STA...
15,577,112 0.192ayhh3ddjwg7y   INSERT INTO T_EXP_DELIVERY_STA...
15,577,048 0.1996bau1p59dh0y   INSERT INTO T_EXP_DELIVERY_STA...
14,969,152 0.181crrgmqhtap69   INSERT INTO T_EXP_DELIVERY_STA...
14,393,792 0.188p3fp2jguk11n   INSERT INTO T_EXP_DELIVERY_STA...
14,292,792 0.184sbkzmudwcd68   INSERT INTO T_EXP_DELIVERY_STA...
13,741,672 0.17733xjzj58vkx0   INSERT INTO T_EXP_DELIVERY_STA...
13,652,520 0.175dzr1p10ydh03   INSERT INTO T_EXP_DELIVERY_STA...
13,406,135141,9590.1609c07pa97cdkj JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
13,190,480 0.167y9zax9taks2q   INSERT INTO T_EXP_DELIVERY_STA...
12,825,576 0.16aq1j9m909q63y   INSERT INTO T_EXP_DELIVERY_STA...
12,692,048 0.1686n8k008j5fg5   INSERT INTO T_EXP_DELIVERY_STA...
12,630,976 0.16d0k01scdqf6c1   INSERT INTO T_EXP_DELIVERY_STA...
12,330,288 0.15c2mffjag542y2   INSERT INTO T_EXP_OP_RECORD_CO...
11,887,55113,5670.157g04ytfkrfcat JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
11,844,848 0.1533tf72t97ah8t   INSERT INTO T_EXP_DELIVERY_STA...
11,743,872 0.145ntqv80pf9q0n   INSERT INTO T_EXP_DELIVERY_STA...
11,528,848 0.142c6mwvt053r3y   INSERT INTO T_EXP_DELIVERY_STA...
11,465,74333,5370.143s4x5qxnjcxhv JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
11,350,824 0.1485warqm7hf8f2   INSERT INTO T_EXP_DELIVERY_STA...
10,973,640 0.137ymaac33ytc92   INSERT INTO T_EXP_DELIVERY_STA...
10,738,568 0.135b0v0afu4udxj   INSERT INTO T_EXP_DELIVERY_STA...
10,536,536 0.134hsvdcgu6k88f   INSERT INTO T_EXP_DELIVERY_STA...
10,475,200 0.1346fd6utb5tmd7   INSERT INTO T_EXP_DELIVERY_STA...
9,364,51149,4830.12fmc5ungbx9cbu JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
9,024,424 0.117zdvpgv74gvqd   INSERT INTO T_EXP_DELIVERY_STA...
8,402,94319,7550.10armutyhd6crgf JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
8,304,63944,0310.1050ud38fypmwtd JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
8,253,78346,8440.108vdryg1pt3vgk JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
7,987,216 0.10c5zm115aa6kwx   INSERT INTO T_EXP_DELIVERY_STA...
7,500,72735,5820.09du2aujnxqm6fv JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
7,372,51129,9300.09ba3md9ywn7phu JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
7,301,36727,4670.0969u6frfbj80ya JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
6,961,856 0.094ahp03j8z3u1g   INSERT INTO T_EXP_DELIVERY_STA...
6,790,83923,2960.08dd259qgnsq41z JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
6,271,20750,9940.089axsck9pv0447 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
4,822,28747,0060.0662b5gtpzmvaph JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
4,635,83122,0750.0699gg10vrvpn2t JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
4,359,71179,3500.058ghzucdwu0gmt JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
4,158,63153,2980.05d2b2uf9j9mfj3 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
2,414,161170,6090.03fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
1,885,23124,7600.025jbmg171mz7mz JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...


Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
445 d7khudn7c54n6   INSERT INTO T_EXP_DELIVERY_STA...
426 cak25du5pyzcp   INSERT INTO T_EXP_DELIVERY_STA...
397 1864ycgvgvyam   INSERT INTO T_EXP_DELIVERY_STA...
36513,5677g04ytfkrfcat JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
362 gf25wm6hncp21   INSERT INTO T_EXP_DELIVERY_STA...
361 2ayhh3ddjwg7y   INSERT INTO T_EXP_DELIVERY_STA...
341 a6nwkg0nu1grj   INSERT INTO T_EXP_DELIVERY_STA...
339 09qtbd90zbmkv   INSERT INTO T_EXP_DELIVERY_STA...
309 96bau1p59dh0y   INSERT INTO T_EXP_DELIVERY_STA...
30435,582du2aujnxqm6fv JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
300141,95909c07pa97cdkj JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
293 7zdvpgv74gvqd   INSERT INTO T_EXP_DELIVERY_STA...
292 86n8k008j5fg5   INSERT INTO T_EXP_DELIVERY_STA...
289 1crrgmqhtap69   INSERT INTO T_EXP_DELIVERY_STA...
280 8p3fp2jguk11n   INSERT INTO T_EXP_DELIVERY_STA...
274 4sbkzmudwcd68   INSERT INTO T_EXP_DELIVERY_STA...
267 8wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
264 733xjzj58vkx0   INSERT INTO T_EXP_DELIVERY_STA...
262 5dzr1p10ydh03   INSERT INTO T_EXP_DELIVERY_STA...
26229,930ba3md9ywn7phu JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
254 7y9zax9taks2q   INSERT INTO T_EXP_DELIVERY_STA...
254 c5zm115aa6kwx   INSERT INTO T_EXP_DELIVERY_STA...
249 4ahp03j8z3u1g   INSERT INTO T_EXP_DELIVERY_STA...
247 aq1j9m909q63y   INSERT INTO T_EXP_DELIVERY_STA...
243 7ymaac33ytc92   INSERT INTO T_EXP_DELIVERY_STA...
242 d0k01scdqf6c1   INSERT INTO T_EXP_DELIVERY_STA...
232 33tf72t97ah8t   INSERT INTO T_EXP_DELIVERY_STA...
22833,5373s4x5qxnjcxhv JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
225 2c6mwvt053r3y   INSERT INTO T_EXP_DELIVERY_STA...
224 5ntqv80pf9q0n   INSERT INTO T_EXP_DELIVERY_STA...
217 85warqm7hf8f2   INSERT INTO T_EXP_DELIVERY_STA...
213 c2mffjag542y2   INSERT INTO T_EXP_OP_RECORD_CO...
206 5b0v0afu4udxj   INSERT INTO T_EXP_DELIVERY_STA...
20450,9949axsck9pv0447 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
202 4hsvdcgu6k88f   INSERT INTO T_EXP_DELIVERY_STA...
201 46fd6utb5tmd7   INSERT INTO T_EXP_DELIVERY_STA...
19846,8448vdryg1pt3vgk JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
18244,03150ud38fypmwtd JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
17949,483fmc5ungbx9cbu JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
17527,46769u6frfbj80ya JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
17347,00662b5gtpzmvaph JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
15219,755armutyhd6crgf JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
14823,296dd259qgnsq41z JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
12953,298d2b2uf9j9mfj3 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
10922,07599gg10vrvpn2t JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
5879,3508ghzucdwu0gmt JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
55170,609fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
3024,7605jbmg171mz7mz JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...


Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
09c07pa97cdkj INSERT INTO T_EXP_OP_RECORD_CONTAINER_208 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
09qtbd90zbmkvINSERT INTO T_EXP_DELIVERY_STATUS_220 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
16w9b2tyb12u6UPDATE T_EXP_DELIVERY_STATUS_208 SET STATUS = CASE WHEN STATUS > :1 THEN STATUS ELSE :2 END , DEST_OUT_SCAN_TIME = :3 , DEST_CENTER_ORG_CODE = :4 WHERE WAYBILL_NO = :5
1864ycgvgvyamINSERT INTO T_EXP_DELIVERY_STATUS_208 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
1bqk0pmqg1vq6SELECT WAYBILL_NO FROM T_EXP_DELIVERY_STATUS_165 WHERE WAYBILL_NO = :1
1crrgmqhtap69INSERT INTO T_EXP_DELIVERY_STATUS_172 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
1txs4c06ctb1dUPDATE T_EXP_DELIVERY_STATUS_165 SET STATUS = CASE WHEN STATUS > :1 THEN STATUS ELSE :2 END , DEST_OUT_SCAN_TIME = :3 , DEST_CENTER_ORG_CODE = :4 WHERE WAYBILL_NO = :5
2ayhh3ddjwg7yINSERT INTO T_EXP_DELIVERY_STATUS_202 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
2c6mwvt053r3yINSERT INTO T_EXP_DELIVERY_STATUS_189 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
2jfqzrxhrm93bselect /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
2mx77j4jyu90sSELECT WAYBILL_NO FROM T_EXP_DELIVERY_STATUS_233 WHERE WAYBILL_NO = :1
338nwhf0f1ypvSELECT WAYBILL_NO FROM T_EXP_DELIVERY_STATUS_219 WHERE WAYBILL_NO = :1
33tf72t97ah8tINSERT INTO T_EXP_DELIVERY_STATUS_203 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
3s4x5qxnjcxhv INSERT INTO T_EXP_OP_RECORD_CONTAINER_216 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
46fd6utb5tmd7INSERT INTO T_EXP_DELIVERY_STATUS_217 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
4ahp03j8z3u1gINSERT INTO T_EXP_DELIVERY_STATUS_209 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
4hsvdcgu6k88fINSERT INTO T_EXP_DELIVERY_STATUS_170 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
4sbkzmudwcd68INSERT INTO T_EXP_DELIVERY_STATUS_216 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
50ud38fypmwtd INSERT INTO T_EXP_OP_RECORD_CONTAINER_199 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
5b0v0afu4udxjINSERT INTO T_EXP_DELIVERY_STATUS_190 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
5dzr1p10ydh03INSERT INTO T_EXP_DELIVERY_STATUS_194 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
5jbmg171mz7mz INSERT INTO T_EXP_OP_RECORD_CONTAINER_181 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
5ntqv80pf9q0nINSERT INTO T_EXP_DELIVERY_STATUS_233 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
62b5gtpzmvaph INSERT INTO T_EXP_OP_RECORD_CONTAINER_233 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
69u6frfbj80ya INSERT INTO T_EXP_OP_RECORD_CONTAINER_194 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
6m3jdhd2f64f1INSERT INTO T_EXP_DELIVERY_STATUS_191 (ID , WAYBILL_NO , DES_ORG_SCAN_TIME , EXP_TYPE , STATUS , DES_ORG_CODE , DEST_ORG_CODE) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 )
733xjzj58vkx0INSERT INTO T_EXP_DELIVERY_STATUS_224 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
7b67dft33n0x4INSERT INTO T_EXP_TAKING_STATUS_161 (ID , WAYBILL_NO , EXP_TYPE , STATUS , SRC_ORG_CODE , TAKING_TIME , TAKING_WEIGHT , TAKING_EMP_CODE , SENDER_CUSTOMER_CODE , SENDER_CUSTOMER_NAME , BUSINESS_TYPE_CODE , EXPRESS_CONTENT_CODE , EFFECTIVE_TYPE_CODE , DEST_ORG_CODE ) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 )
7b9fzy1w3dq3dSELECT WAYBILL_NO FROM T_EXP_DELIVERY_STATUS_186 WHERE WAYBILL_NO = :1
7g04ytfkrfcat INSERT INTO T_EXP_OP_RECORD_CONTAINER_204 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
7puph7ypx8g5aINSERT INTO T_EXP_DELIVERY_STATUS_208 (ID , WAYBILL_NO , DES_ORG_SCAN_TIME , EXP_TYPE , STATUS , DES_ORG_CODE , DEST_ORG_CODE) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 )
7y9zax9taks2qINSERT INTO T_EXP_DELIVERY_STATUS_219 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
7ymaac33ytc92INSERT INTO T_EXP_DELIVERY_STATUS_199 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
7zdvpgv74gvqdINSERT INTO T_EXP_DELIVERY_STATUS_175 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
85warqm7hf8f2INSERT INTO T_EXP_DELIVERY_STATUS_166 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
86n8k008j5fg5INSERT INTO T_EXP_DELIVERY_STATUS_195 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
8ghzucdwu0gmt INSERT INTO T_EXP_OP_RECORD_CONTAINER_195 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
8p3fp2jguk11nINSERT INTO T_EXP_DELIVERY_STATUS_164 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
8vdryg1pt3vgk INSERT INTO T_EXP_OP_RECORD_CONTAINER_227 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
8wbzcapy4x69v INSERT INTO T_EXP_OP_RECORD_CONTAINER_165 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
8wrf2prwmjcrwselect id from T_EXP_OP_RECORD_TAKING_170 where status <> 0 and ID=:1
96bau1p59dh0yINSERT INTO T_EXP_DELIVERY_STATUS_207 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
99gg10vrvpn2t INSERT INTO T_EXP_OP_RECORD_CONTAINER_161 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
9axsck9pv0447 INSERT INTO T_EXP_OP_RECORD_CONTAINER_225 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
a6nwkg0nu1grjINSERT INTO T_EXP_DELIVERY_STATUS_206 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
aby73nja82u62INSERT INTO T_EXP_DELIVERY_STATUS_165 (ID , WAYBILL_NO , DES_ORG_SCAN_TIME , EXP_TYPE , STATUS , DES_ORG_CODE , DEST_ORG_CODE) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 )
aq1j9m909q63yINSERT INTO T_EXP_DELIVERY_STATUS_191 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
armutyhd6crgf INSERT INTO T_EXP_OP_RECORD_CONTAINER_209 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
b3tcj0dddr2v2INSERT INTO T_EXP_DELIVERY_STATUS_161 (ID , WAYBILL_NO , DES_ORG_SCAN_TIME , EXP_TYPE , STATUS , DES_ORG_CODE , DEST_ORG_CODE) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 )
ba3md9ywn7phu INSERT INTO T_EXP_OP_RECORD_CONTAINER_207 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
bvn82frd8avz4 SELECT * FROM (SELECT T.*, ROWNUM RN FROM ( SELECT DISTINCT ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, FEE_WEIGHT, TRANS_FEE, IN_OUT_FLAG, OUT_TIME, PKG_PCS, ORG_TYPE, QUERY_FLAG FROM T_EXP_OP_RECORD_CONTAINER_165 WHERE 1=1 AND CREATE_TIME>=:1 AND CREATE_TIME<=:2 AND OP_CODE=:3 AND ORG_CODE=:4 AND STATUS=:5 AND EFFECTIVE_TYPE_CODE = :6 ) T WHERE ROWNUM <= :7 ) WHERE RN >= :8
c2gkrw5buc9wbselect sysdate from DUAL
c2mffjag542y2 INSERT INTO T_EXP_OP_RECORD_CONTAINER_202 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
c5zm115aa6kwxINSERT INTO T_EXP_DELIVERY_STATUS_174 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
cak25du5pyzcpINSERT INTO T_EXP_DELIVERY_STATUS_161 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
cj9mymcb3d5q0DELETE FROM T_EXP_DELIVERY_STATUS_165 WHERE WAYBILL_NO = :1
d0k01scdqf6c1INSERT INTO T_EXP_DELIVERY_STATUS_223 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
d2b2uf9j9mfj3 INSERT INTO T_EXP_OP_RECORD_CONTAINER_219 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
d7khudn7c54n6INSERT INTO T_EXP_DELIVERY_STATUS_165 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
d9pmgnn15y65kSELECT WAYBILL_NO FROM T_EXP_DELIVERY_STATUS_208 WHERE WAYBILL_NO = :1
dd259qgnsq41z INSERT INTO T_EXP_OP_RECORD_CONTAINER_224 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
dsqa57za58kcwSELECT WAYBILL_NO FROM T_EXP_DELIVERY_STATUS_181 WHERE WAYBILL_NO = :1
du2aujnxqm6fv INSERT INTO T_EXP_OP_RECORD_CONTAINER_186 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
fgcvgtv12rhrjSELECT COUNT(1) FROM ( SELECT DISTINCT ID FROM T_EXP_OP_RECORD_CONTAINER_165 WHERE 1=1 AND CREATE_TIME>=:1 AND CREATE_TIME<=:2 AND OP_CODE=:3 AND ORG_CODE=:4 AND STATUS=:5 )
fk97qz5tcpuxaINSERT INTO T_EXP_OP_RECORD_HANDON_208 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EMP_CODE, EMP_NAME, HANDON_TYPE, WEIGH_WEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, ORG_CODE, FREQUENCY_NO, HANDON_ID, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, CONTAINER_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, SIGINOFF_OP_CODE, SIGINOFF_ID, FST_SUCCESS_SIGINOFF, DELIVERY_SEQ, ORG_TYPE, QUERY_FLAG) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 )
fmc5ungbx9cbu INSERT INTO T_EXP_OP_RECORD_CONTAINER_220 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
fyx52u79xsh06SELECT WAYBILL_NO FROM T_EXP_DELIVERY_STATUS_220 WHERE WAYBILL_NO = :1
gf25wm6hncp21INSERT INTO T_EXP_DELIVERY_STATUS_186 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
gf8mx1rhb7rf5SELECT WAYBILL_NO FROM T_EXP_DELIVERY_STATUS_195 WHERE WAYBILL_NO = :1
ghdbndgv3sjm4DELETE FROM T_EXP_DELIVERY_STATUS_208 WHERE WAYBILL_NO = :1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

StatisticTotalper Secondper Trans
db block changes109,102,14317,253.7424.71
execute count10,613,6021,678.472.40
logons cumulative3,0430.480.00
opened cursors cumulative9,261,3341,464.622.10
parse count (total)10,016,9861,584.122.27
parse time elapsed30,1414.770.01
physical reads483,13676.400.11
physical writes7,544,1651,193.061.71
redo size18,959,110,9922,998,251.104,293.26
session cursor cache hits5,037,463796.641.14
session logical reads251,730,98739,809.5057.00
user calls28,117,6244,446.616.37
user commits2,982,575471.670.68
user rollbacks1,433,446226.690.32
workarea executions - onepass00.000.00
workarea executions - optimal74,77811.830.02


Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (space) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced89,79114.200.02
CCursor + sql area evicted210.000.00
CPU used by this session438,30269.310.10
CPU used when call started434,84868.770.10
CR blocks created12,6111.990.00
Cached Commit SCN referenced4950.080.00
Commit SCN cached337,19453.320.08
DBWR checkpoint buffers written7,535,1451,191.631.71
DBWR checkpoints530.010.00
DBWR object drop buffers written00.000.00
DBWR revisited being-written buffer290.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR thread checkpoint buffers written3,586,915567.250.81
DBWR transaction table writes1,0610.170.00
DBWR undo block writes1,372,098216.990.31
Effective IO time00.000.00
HSC Heap Segment Block Changes7,909,2971,250.801.79
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts901,101142.500.20
Heap Segment Array Updates2,2060.350.00
IMU CR rollbacks2,1250.340.00
IMU Flushes1,031,518163.130.23
IMU Redo allocation size2,406,067,364380,502.76544.85
IMU commits2,599,615411.110.59
IMU contention44,4237.030.01
IMU ktichg flush10.000.00
IMU pool not allocated114,55918.120.03
IMU recursive-transaction flush1,8760.300.00
IMU undo allocation size12,020,578,3121,900,970.572,722.04
IMU- failed to get a private strand114,55918.120.03
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued00.000.00
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Requests to/from client19,162,8023,030.464.34
RowCR - row contention6880.110.00
RowCR attempts271,66142.960.06
RowCR hits289,15945.730.07
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink2090.030.00
SQL*Net roundtrips to/from client19,165,7813,030.934.34
TBS Extension: bytes extended2,621,440,000414,562.44593.62
TBS Extension: files extended420.010.00
TBS Extension: tasks created370.010.00
TBS Extension: tasks executed370.010.00
active txn count during cleanout1,114,423176.240.25
background checkpoints completed530.010.00
background checkpoints started530.010.00
background timeouts52,4238.290.01
branch node splits3150.050.00
buffer is not pinned count46,427,4557,342.1810.51
buffer is pinned count30,768,9014,865.896.97
bytes received via SQL*Net from client8,364,117,5391,322,726.821,894.04
bytes sent via SQL*Net to client2,835,142,992448,358.08642.01
calls to get snapshot scn: kcmgss11,806,7201,867.152.67
calls to kcmgas4,279,190676.720.97
calls to kcmgcs5,087,788804.601.15
cell physical IO interconnect bytes131,512,966,14420,797,857.8229,780.87
change write time73,29111.590.02
cleanout - number of ktugct calls972,560153.800.22
cleanouts and rollbacks - consistent read gets7,5341.190.00
cleanouts only - consistent read gets4,1590.660.00
cluster key scan block gets275,82543.620.06
cluster key scans273,80643.300.06
commit batch performed1,1660.180.00
commit batch requested1,1660.180.00
commit batch/immediate performed589,93993.290.13
commit batch/immediate requested589,93993.290.13
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written2,6200.410.00
commit cleanout failures: callback failure41,0876.500.01
commit cleanout failures: cannot pin29,8794.730.01
commit cleanouts31,252,3144,942.347.08
commit cleanouts successfully completed31,178,7284,930.707.06
commit immediate performed588,77393.110.13
commit immediate requested588,77393.110.13
commit txn count during cleanout1,433,278226.660.32
consistent changes56,8138.980.01
consistent gets115,458,65218,258.9826.15
consistent gets - examination23,955,8223,788.455.42
consistent gets direct00.000.00
consistent gets from cache115,458,65218,258.9826.15
consistent gets from cache (fastpath)90,922,98114,378.8320.59
cursor authentications5,2810.840.00
data blocks consistent reads - undo records applied16,8992.670.00
db block gets136,272,53421,550.5530.86
db block gets direct550.010.00
db block gets from cache136,272,48621,550.5430.86
db block gets from cache (fastpath)46,857,4987,410.1910.61
deferred (CURRENT) block cleanout applications7,097,9921,122.501.61
dirty buffers inspected540.010.00
doubling up with imu segment00.000.00
enqueue conversions16,8282.660.00
enqueue deadlocks00.000.00
enqueue releases11,789,1351,864.372.67
enqueue requests11,789,6081,864.442.67
enqueue timeouts100.000.00
enqueue waits4,4420.700.00
exchange deadlocks2490.040.00
failed probes on index block reclamation40.000.00
file io service time554,94987.760.13
frame signature mismatch10.000.00
free buffer inspected1,610,915254.750.36
free buffer requested2,566,164405.820.58
heap block compress675,805106.870.15
hot buffers moved to head of LRU17,1652.710.00
immediate (CR) block cleanout applications11,6931.850.00
immediate (CURRENT) block cleanout applications2,966,558469.140.67
index crx upgrade (positioned)280.000.00
index crx upgrade (prefetch)10.000.00
index fast full scans (full)80.000.00
index fetch by key7,226,0971,142.761.64
index scans kdiixs19,385,2491,484.212.13
leaf node 90-10 splits4190.070.00
leaf node splits161,05725.470.04
lob reads8,5311.350.00
lob writes8,5911.360.00
lob writes unaligned8,5911.360.00
logical read bytes from cache2,062,180,270,080326,119,418.55466,977.01
max cf enq hold time3700.060.00
messages received4,784,489756.631.08
messages sent4,784,489756.631.08
min active SCN optimization applied on CR214,37033.900.05
no buffer to keep pinned count00.000.00
no work - consistent read gets86,421,13313,666.9019.57
non-idle wait count31,288,5904,948.077.09
parse count (describe)30.000.00
parse count (failures)00.000.00
parse count (hard)5,5730.880.00
parse time cpu11,7331.860.00
physical read IO requests475,78575.240.11
physical read bytes3,957,850,112625,906.37896.25
physical read total IO requests534,37284.510.12
physical read total bytes25,578,742,2724,045,099.595,792.26
physical read total multi block requests20,1653.190.00
physical reads cache440,82369.710.10
physical reads cache prefetch7,3611.160.00
physical reads direct42,3136.690.01
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests4,159,336657.770.94
physical write bytes61,801,799,6809,773,523.3313,994.91
physical write total IO requests7,901,4101,249.551.79
physical write total bytes105,934,223,87216,752,758.2323,988.61
physical write total multi block requests120,36619.040.03
physical writes direct8,9571.420.00
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace10.000.00
physical writes from cache7,535,2081,191.641.71
physical writes non checkpoint1,745,760276.080.40
pinned buffers inspected110.000.00
prefetch clients - default10.000.00
prefetch warmup blocks aged out before use00.000.00
prefetch warmup blocks flushed out before use00.000.00
prefetched blocks aged out before use00.000.00
process last non-idle time6,6741.060.00
recovery blocks read00.000.00
recursive aborts on index block reclamation10.000.00
recursive calls10,705,1731,692.952.42
recursive cpu usage37,7935.980.01
redo KB read20,141,7503,185.284.56
redo blocks checksummed by FG (exclusive)15,874,4302,510.433.59
redo blocks read for recovery00.000.00
redo blocks written40,189,0326,355.619.10
redo buffer allocation retries1,4110.220.00
redo entries39,436,9686,236.688.93
redo k-bytes read for recovery00.000.00
redo log space requests1,6920.270.00
redo ordering marks124,78919.730.03
redo size for direct writes444,35670.270.10
redo subscn max counts1,135,670179.600.26
redo synch long waits00.000.00
redo synch poll writes3,572,200564.920.81
redo synch polls4,631,921732.511.05
redo synch time275,24243.530.06
redo synch time (usec)2,752,450,903435,280.90623.29
redo synch time overhead (usec)1,225,533,451193,809.56277.52
redo synch time overhead count (<128 msec)310.000.00
redo synch time overhead count (<2 msec)3,523,114557.160.80
redo synch time overhead count (<32 msec)2,1550.340.00
redo synch time overhead count (<8 msec)42,2926.690.01
redo synch time overhead count (>=128 msec)160.000.00
redo synch writes3,572,200564.920.81
redo wastage958,580,504151,592.82217.07
redo write info find3,567,613564.190.81
redo write info find fail50.000.00
redo write time111,67117.660.03
redo writes2,940,659465.040.67
rollback changes - undo records applied3,896,893616.270.88
rollbacks only - consistent read gets3,7660.600.00
root node splits520.010.00
rows fetched via callback909,659143.860.21
session connect time00.000.00
shared hash latch upgrades - no wait311,55549.270.07
shared hash latch upgrades - wait40.000.00
sorts (disk)00.000.00
sorts (memory)85,76013.560.02
sorts (rows)523,65682.810.12
sql area evicted2,2700.360.00
sql area purged00.000.00
summed dirty queue length790.010.00
switch current to new buffer553,76487.570.13
table fetch by rowid28,830,4104,559.336.53
table fetch continued row4,0120.630.00
table scan blocks gotten39,822,8426,297.709.02
table scan rows gotten4,268,554,632675,042.13966.61
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (short tables)271,05642.870.06
temp space allocated (bytes)00.000.00
total cf enq hold time13,9702.210.00
total number of cf enq holders1,1730.190.00
total number of times SMON posted8980.140.00
transaction rollbacks589,94093.290.13
transaction tables consistent read rollbacks180.000.00
transaction tables consistent reads - undo records applied3,9790.630.00
undo change vector size6,456,942,5961,021,120.411,462.16
user logons cumulative2,7870.440.00
user logouts cumulative2,6850.420.00
write clones created in background30.000.00
write clones created in foreground10,3371.630.00


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current461563
opened cursors current1,3921,049
session cursor cache count3,475,0863,506,070
session pga memory77,928,152,19278,257,650,912
session pga memory max96,590,759,00896,834,593,184
session uga memory76,072,245,08077,085,007,656
session uga memory max512,015,845,848513,486,698,504


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)5330.17


Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
DBWR5M0.04.001M57.5G656.279.309M2830.45
Others20.1G8.973.256M21.9G5.443.55M43.2K0.15
LGWR22M0.24.003M19.2G586.923.108M2946K0.02
Buffer Cache Reads3.4G68.55.545M0M0.000M433.6K1.34
Direct Reads331M6.69.052M53M1.08.008M0 
Direct Writes0M0.000M16M0.32.003M0 
RMAN2M0.010M0M0.000M820.21
Streams AQ0M0.000M0M0.000M25.00
TOTAL:23.8G84.513.858M98.7G1250.0515.977M3423.1K0.19


Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Data File3.7G75.43.597M57.6G657.779.321M1.6211.56
Log File19.2G3.163.111M19.2G586.893.105M0.967.39
Archive Log0M0.000M19.2G3.113.111M5.00 
Control File941M5.93.149M244M2.08.039M0.042.20
Temp File0M0.000M0M0.000M0.00 
TOTAL:23.8G84.533.857M96.2G1249.8515.576M1.517.31


Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
DBWR 5M0.04.001M57.5G656.279.308M2830.45
DBWR (Data File) 0M0.000M57.5G656.279.308M0 
DBWR (Control File) 5M0.04.001M0M0.000M2830.45
Others 20.1G8.973.256M21.9G5.443.55M37.1K0.15
Others (Archive Log) 0M0.000M19.2G3.113.111M0 
Others (Log File) 19.2G3.153.111M0M0.000M2131.38
Others (Data File) 8M0.16.001M2.5G0.42.403M10832.60
Others (Control File) 913M5.66.144M227M1.91.036M35.8K0.06
LGWR 22M0.24.003M19.2G587.063.108M16070.04
LGWR (Log File) 0M0.020M19.2G586.893.105M2120.06
LGWR (Control File) 22M0.22.003M16M0.17.003M13950.04
Buffer Cache Reads 3.4G68.56.545M0M0.000M433.6K1.34
Buffer Cache Reads (Data File) 3.4G68.56.545M0M0.000M433.6K1.34
Direct Reads 331M6.69.052M53M1.08.008M0 
Direct Reads (Data File) 331M6.69.052M53M1.08.008M0 
Direct Writes 0M0.000M16M0.32.003M0 
Direct Writes (Data File) 0M0.000M16M0.32.003M0 
RMAN 2M0.010M0M0.000M710.23
RMAN (Control File) 2M0.010M0M0.000M690.09
RMAN (Archive Log) 0M0.000M0M0.000M25.00
Streams AQ 0M0.000M0M0.000M25.00
Streams AQ (Data File) 0M0.000M0M0.000M25.00
TOTAL: 23.8G84.513.858M98.7G1250.1815.977M472.7K1.24


Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Rds/sAv Rd(ms)Av Blks/Rd 1-bk Rds/sAv 1-bk Rd(ms)WritesWrites avg/sBuffer WaitsAv Buf Wt(ms)
TS_IDX_YTEXP 150,183241.841.002,956,88423.7524688730.13
TS_YTEXP 9,56625.401.00530,0661.515843490.29
UNDOTBS1 1900.001.00257,1970.000412,7770.11
TS_IDX_TAKE 178,020281.221.0027,00128.1514170.59
TS_IDX_CONTAINER 11,69823.201.00141,3921.853223,1090.12
TS_CONTAINER_02 13,27923.221.3060,1301.973106590.06
TS_IDX_HANDON 36,14961.131.0017,6765.72131,4150.49
TS_IDX_SIGNATURE 20,56931.081.0013,5843.25122,1040.68
TS_TAKE_02 4,24712.621.0021,7820.6733311.29
TS_SIGNATURE_02 2,13803.091.6013,8660.31324800.81
TS_HANDON_02 92200.821.0012,8180.151280.00
TS_YTMDM 2,98104.741.004,7650.4751120.00
TS_IDX_T_EXP_CONTAINER_165 20300.691.006,9640.0311130.00
TS_IDX_T_EXP_CONTAINER_208 12901.241.003,8540.0211570.00
TS_IDX_YTMDM 1,58005.471.001,4330.255000.00
TS_IDX_T_EXP_CONTAINER_195 49202.681.001,7990.0830440.00
TS_IDX_T_EXP_CONTAINER_233 19801.871.001,9100.0320190.00
TS_IDX_T_EXP_W_182 1,24106.311.007430.2060704.86
TS_IDX_T_EXP_W_215 12500.401.001,8420.020060.00
TS_IDX_T_EXP_W_174 39904.611.001,3210.065070.00
TS_IDX_T_EXP_W_164 44705.121.001,2430.07503454.06
TS_IDX_T_EXP_W_183 42005.211.001,2250.075020.00
TS_IDX_T_EXP_W_161 16202.591.001,4520.0330180.00
TS_IDX_T_EXP_W_162 45205.271.001,0820.07505433.83
TS_IDX_T_EXP_W_175 13901.221.001,3520.021050.00
TS_IDX_T_EXP_W_170 27904.341.001,1840.04402014.28
TS_IDX_T_EXP_W_236 73606.151.006710.12601,4384.07
TS_IDX_T_EXP_W_240 73606.291.006440.12607174.55
SYSAUX 8603.951.001,2480.014000.00
TS_IDX_T_EXP_CONTAINER_219 15801.011.001,1450.0210420.00
TS_IDX_T_EXP_CONTAINER_206 9500.001.001,2000.020020.00
TS_HANDON_01 1,06700.041.002170.170000.00
TS_IDX_T_EXP_CONTAINER_199 18601.611.001,0830.0320120.00
SYSTEM 17504.511.001,0930.03501040.48
TS_IDX_T_EXP_W_202 18902.491.001,0740.032000.00
TS_IDX_T_EXP_W_185 46005.521.007940.07605213.90
TS_TAKE_01 1,06200.001.001800.170000.00
TS_IDX_T_EXP_CONTAINER_181 17201.401.001,0210.0310190.00
TS_IDX_T_EXP_CONTAINER_220 15301.181.001,0290.0210170.59
TS_IDX_T_EXP_CONTAINER_225 13401.041.001,0220.0210210.00
TS_IDX_T_EXP_CONTAINER_216 12800.631.001,0100.021090.00
TS_IDX_T_EXP_W_224 36505.121.007730.06506144.10
TS_CONTAINER_01 93600.001.001800.150000.00
TS_IDX_T_EXP_W_181 23904.141.008700.04402743.83
TS_IDX_T_EXP_W_233 23604.321.008640.044020.00
TS_SIGNATURE_01 91800.202.341820.140000.00
TS_IDX_T_EXP_W_188 10700.931.009660.021020.00
TS_IDX_T_EXP_W_177 21603.241.008540.033010.00
TS_IDX_T_EXP_W_186 30403.721.007520.054000.00
TS_IDX_T_EXP_CONTAINER_209 21503.121.008000.033040.00
TS_IDX_T_EXP_CONTAINER_215 14300.771.008640.021050.00
TS_IDX_T_EXP_CONTAINER_194 16601.081.008360.0310110.00
TS_IDX_T_EXP_W_169 14601.441.008510.0210110.00
TS_IDX_T_EXP_W_208 20002.901.007670.033020.00
TS_IDX_T_EXP_W_237 21703.961.007280.03402624.24
TS_IDX_T_EXP_CONTAINER_186 12501.041.008180.0210220.00
TS_IDX_T_EXP_CONTAINER_228 12200.661.008070.021060.00
TS_IDX_T_EXP_W_206 12201.391.008020.0210664.39
TS_IDX_T_EXP_CONTAINER_227 11300.881.008020.0210300.00
TS_IDX_T_EXP_W_167 30304.621.006050.055090.00
TS_IDX_T_EXP_W_229 16803.571.007370.0340183.33
TS_IDX_T_EXP_W_172 14801.551.007560.0220100.00
TS_IDX_T_EXP_W_216 30704.721.005920.055030.00
TS_IDX_T_EXP_W_197 31304.701.005750.05501283.91
TS_IDX_T_EXP_W_239 40304.991.004850.065000.00
TS_IDX_T_EXP_W_173 22704.271.006510.0440239.13
TS_IDX_T_EXP_W_198 23703.761.006320.0440413.41
TS_IDX_T_EXP_W_205 46305.181.004050.075010.00
TS_IDX_T_EXP_W_176 30504.431.005470.05403984.42
TS_IDX_T_EXP_W_238 18402.931.006620.0330853.53
TS_IDX_T_EXP_CONTAINER_202 17801.011.006660.0310110.00
TS_IDX_T_EXP_CONTAINER_204 20802.361.006220.032090.00
TS_IDX_T_EXP_W_171 12900.701.007010.021033.33
TS_IDX_T_EXP_W_178 12000.421.006950.020070.00
TS_IDX_T_EXP_W_203 17504.001.006270.03401765.06
TS_IDX_T_EXP_W_195 32204.881.004780.05505274.50
TS_IDX_T_EXP_W_209 9600.421.007010.020000.00
TS_IDX_T_EXP_CONTAINER_221 18501.351.006040.0310110.00
TS_IDX_T_EXP_W_187 16602.951.006020.033070.00
TS_IDX_T_EXP_W_214 10600.661.006470.021000.00
TS_IDX_T_EXP_W_184 31404.901.004310.05501803.56
TS_IDX_T_EXP_CONTAINER_162 15301.631.005630.022060.00
TS_IDX_T_EXP_W_191 9800.511.006130.021000.00
TS_IDX_T_EXP_W_180 12701.811.005810.0220265.38
TS_IDX_T_EXP_W_201 18402.501.005210.033033.33
TS_IDX_T_EXP_CONTAINER_175 15701.911.005440.022030.00
TS_IDX_T_EXP_W_168 13901.651.005560.022042.50
TS_IDX_T_EXP_CONTAINER_224 15201.451.005410.021070.00
TS_IDX_T_EXP_W_213 12402.021.005610.022030.00
TS_IDX_T_EXP_W_166 9900.401.005740.020050.00
TS_IDX_T_EXP_W_196 12000.581.005460.021000.00
TS_IDX_T_EXP_W_231 9800.411.005670.020020.00
TS_IDX_T_EXP_W_227 10900.641.005530.021010.00
TBS_OTH_SPLEX 54000.001.001200.090000.00
TS_IDX_T_EXP_W_220 11300.351.005430.020000.00
TS_IDX_T_EXP_W_165 14002.641.005130.0230874.60
TS_IDX_T_EXP_W_179 11300.181.005390.020030.00
TS_IDX_T_EXP_CONTAINER_174 14501.721.005060.022030.00
TS_IDX_T_EXP_W_199 11700.431.005210.020033.33
TS_IDX_T_EXP_W_193 17802.131.004560.032000.00
TS_IDX_T_EXP_W_192 11300.271.005160.020000.00
TS_IDX_T_EXP_W_217 13500.961.004890.021070.00
TS_IDX_T_EXP_W_163 12702.281.004890.022030.00
TS_IDX_T_EXP_CONTAINER_161 9501.051.005190.0210350.00
TS_IDX_T_EXP_W_232 19203.281.004090.03302482.98
TS_IDX_T_EXP_W_225 21503.071.003780.03301593.71
TS_IDX_T_EXP_W_218 24204.091.003490.044000.00
TS_IDX_T_EXP_W_189 10700.471.004810.020040.00
TS_IDX_T_EXP_W_190 9700.521.004770.021010.00
TS_IDX_T_EXP_W_223 17402.871.003940.03301044.23
TS_IDX_T_EXP_W_219 11200.271.004390.020000.00
TS_IDX_T_EXP_CONTAINER_166 11701.201.004300.0210130.00
TS_IDX_T_EXP_W_200 13801.091.004040.0210553.09
TS_IDX_T_EXP_W_204 10100.301.004410.020010.00
TS_IDX_T_EXP_W_207 10100.401.004290.020000.00
TS_IDX_T_EXP_CONTAINER_164 7900.251.004240.010010.00
TS_IDX_T_EXP_CONTAINER_207 12500.881.003730.0210160.00
TS_IDX_T_EXP_W_212 9800.311.003980.020020.00
TS_IDX_T_EXP_W_210 11701.971.003660.022020.00
TS_IDX_T_EXP_W_194 12000.331.003480.020000.00
TS_IDX_T_EXP_CONTAINER_229 11101.081.003420.021000.00
TS_IDX_T_EXP_CONTAINER_237 11701.541.003320.021000.00
TS_IDX_T_EXP_W_226 14002.501.003050.023020.00
TS_IDX_T_EXP_CONTAINER_231 9600.001.003420.020010.00
TS_IDX_T_EXP_CONTAINER_188 10200.491.003330.020000.00
TS_IDX_T_EXP_CONTAINER_172 9500.001.003360.020050.00
TS_IDX_T_EXP_CONTAINER_234 9700.101.003340.020030.00
TS_IDX_T_EXP_CONTAINER_177 12300.891.003020.021030.00
TS_IDX_T_EXP_CONTAINER_238 13401.571.002840.022010.00
TS_IDX_T_EXP_CONTAINER_179 11801.441.002940.022040.00
TS_IDX_T_EXP_W_230 13001.541.002790.022030.00
TS_IDX_T_EXP_CONTAINER_198 13901.011.002670.021060.00
TS_IDX_T_EXP_W_228 10200.491.002930.020020.00
TS_IDX_T_EXP_CONTAINER_214 9500.001.002980.020000.00
TS_IDX_T_EXP_CONTAINER_169 9800.101.002930.020020.00
TS_IDX_T_EXP_CONTAINER_170 9900.201.002890.020010.00
TS_IDX_T_EXP_W_235 9600.311.002870.020000.00
TS_IDX_T_EXP_W_211 10100.401.002550.020000.00
TS_IDX_T_EXP_CONTAINER_180 9900.201.002560.020050.00
TS_IDX_T_EXP_W_222 12100.331.002320.020000.00
TS_IDX_T_EXP_W_221 12902.021.002230.022030.00
TS_IDX_T_EXP_CONTAINER_193 11800.171.002200.020000.00
TS_IDX_T_EXP_CONTAINER_176 9500.001.002410.020010.00
TS_IDX_T_EXP_CONTAINER_222 12200.411.002100.020020.00
TS_IDX_T_EXP_CONTAINER_185 10000.201.002260.020000.00
TS_IDX_T_EXP_CONTAINER_201 11500.001.002090.020000.00
TS_IDX_T_EXP_CONTAINER_182 10500.671.002180.021000.00
TS_IDX_T_EXP_CONTAINER_187 10000.201.002200.020040.00
TS_IDX_T_EXP_CONTAINER_178 10000.201.002160.020040.00
TS_IDX_T_EXP_CONTAINER_197 11400.001.002010.020000.00
TS_IDX_T_EXP_CONTAINER_173 10200.101.002120.020010.00
TS_IDX_T_EXP_CONTAINER_183 9800.101.002120.020000.00
TS_IDX_T_EXP_CONTAINER_167 8301.081.002260.011010.00
TS_IDX_T_EXP_CONTAINER_210 9600.001.002050.020010.00
TS_IDX_T_EXP_CONTAINER_196 11700.171.001800.020000.00
TS_IDX_T_EXP_CONTAINER_223 12000.331.001740.020050.00
TS_IDX_T_EXP_CONTAINER_200 11600.091.001690.020000.00
TS_IDX_T_EXP_CONTAINER_205 10000.201.001830.020000.00
TS_IDX_T_EXP_CONTAINER_171 9700.001.001820.020020.00
TS_IDX_T_EXP_CONTAINER_192 12100.171.001560.020010.00
TS_IDX_T_EXP_CONTAINER_191 9600.101.001800.020025.00
TS_IDX_T_EXP_CONTAINER_232 9700.101.001690.020000.00
TS_IDX_T_EXP_W_234 10100.591.001640.021000.00
TS_IDX_T_EXP_CONTAINER_218 11500.091.001400.020000.00
TS_T_EXP_CONTAINER_165 19900.001.00550.030000.00
TS_IDX_T_EXP_CONTAINER_168 7800.131.001700.010000.00
TS_IDX_T_EXP_CONTAINER_217 11500.001.001290.020010.00
TS_IDX_T_EXP_CONTAINER_184 9900.201.001440.020030.00
TS_IDX_T_EXP_CONTAINER_189 10000.101.001430.020000.00
TS_IDX_T_EXP_CONTAINER_240 11500.091.001270.020000.00
TS_IDX_T_EXP_CONTAINER_190 9800.311.001430.020010.00
TS_IDX_T_EXP_CONTAINER_203 9500.001.001460.020000.00
TS_IDX_T_EXP_CONTAINER_213 9700.101.001390.020010.00
TS_IDX_T_EXP_CONTAINER_235 9700.101.001360.020010.00
TS_IDX_T_EXP_CONTAINER_226 10000.501.001320.021000.00
TS_IDX_T_EXP_CONTAINER_239 12000.081.00970.020000.00
TS_IDX_T_EXP_CONTAINER_212 9800.311.001110.020040.00
TS_IDX_T_EXP_CONTAINER_163 7600.001.001280.010000.00
TS_IDX_T_EXP_CONTAINER_230 9700.211.00980.020000.00
TS_T_EXP_CONTAINER_208 14700.001.00370.020000.00
TS_IDX_T_EXP_CONTAINER_211 10000.501.00670.021010.00
TS_IDX_T_EXP_CONTAINER_236 9500.001.00530.020000.00
TS_T_EXP_W_208 11900.251.00190.020000.00
TS_T_EXP_W_232 11601.728.51180.020000.00
TS_T_EXP_W_160 11400.001.00190.020000.00
TS_T_EXP_W_161 11400.001.00190.020000.00
TS_T_EXP_W_162 11400.001.00190.020000.00
TS_T_EXP_W_163 11400.001.00190.020000.00
TS_T_EXP_W_164 11400.001.00190.020000.00
TS_T_EXP_W_165 11400.001.00190.020000.00
TS_T_EXP_W_166 11400.001.00190.020000.00
TS_T_EXP_W_167 11400.001.00190.020000.00
TS_T_EXP_W_180 11400.001.00190.020000.00
TS_T_EXP_W_181 11400.001.00190.020000.00
TS_T_EXP_W_182 11400.001.00190.020000.00
TS_T_EXP_W_183 11400.001.00190.020000.00
TS_T_EXP_W_184 11400.001.00190.020000.00
TS_T_EXP_W_185 11400.001.00190.020000.00
TS_T_EXP_W_186 11400.001.00190.020000.00
TS_T_EXP_W_187 11400.001.00190.020000.00
TS_T_EXP_W_188 11400.001.00190.020000.00
TS_T_EXP_W_189 11400.001.00190.020000.00
TS_T_EXP_W_190 11400.001.00190.020000.00
TS_T_EXP_W_203 11400.001.00190.020000.00
TS_T_EXP_W_204 11400.001.00190.020000.00
TS_T_EXP_W_205 11400.001.00190.020000.00
TS_T_EXP_W_206 11400.001.00190.020000.00
TS_T_EXP_W_207 11400.001.00190.020000.00
TS_T_EXP_W_209 11400.001.00190.020000.00
TS_T_EXP_W_210 11400.001.00190.020000.00
TS_T_EXP_W_211 11400.001.00190.020000.00
TS_T_EXP_W_212 11400.001.00190.020000.00
TS_T_EXP_W_213 11400.001.00190.020000.00
TS_T_EXP_W_226 10800.001.00180.020000.00
TS_T_EXP_W_227 10800.001.00180.020000.00
TS_T_EXP_W_228 10800.001.00180.020000.00
TS_T_EXP_W_229 10800.001.00180.020000.00
TS_T_EXP_W_230 10800.001.00180.020000.00
TS_T_EXP_W_231 10800.001.00180.020000.00
TS_T_EXP_W_233 10800.001.00180.020000.00
TS_T_EXP_W_234 10800.001.00180.020000.00
TS_T_EXP_W_235 10800.001.00180.020000.00
TS_T_EXP_W_236 10800.001.00180.020000.00
TS_T_EXP_W_217 9800.201.00210.020000.00
TS_T_EXP_W_168 9600.001.00190.020000.00
TS_T_EXP_W_173 9600.101.00190.020000.00
TS_T_EXP_W_169 9500.001.00190.020000.00
TS_T_EXP_W_170 9500.001.00190.020000.00
TS_T_EXP_W_171 9500.001.00190.020000.00
TS_T_EXP_W_172 9500.001.00190.020000.00
TS_T_EXP_W_174 9500.001.00190.020000.00
TS_T_EXP_W_175 9500.001.00190.020000.00
TS_T_EXP_W_176 9500.001.00190.020000.00
TS_T_EXP_W_177 9500.001.00190.020000.00
TS_T_EXP_W_178 9500.001.00190.020000.00
TS_T_EXP_W_179 9500.001.00190.020000.00
TS_T_EXP_W_191 9500.001.00190.020000.00
TS_T_EXP_W_192 9500.001.00190.020000.00
TS_T_EXP_W_193 9500.001.00190.020000.00
TS_T_EXP_W_194 9500.001.00190.020000.00
TS_T_EXP_W_195 9500.001.00190.020000.00
TS_T_EXP_W_196 9500.001.00190.020000.00
TS_T_EXP_W_197 9500.001.00190.020000.00
TS_T_EXP_W_198 9500.001.00190.020000.00
TS_T_EXP_W_199 9500.001.00190.020000.00
TS_T_EXP_W_200 9500.001.00190.020000.00
TS_T_EXP_W_201 9500.001.00190.020000.00
TS_T_EXP_W_202 9500.001.00190.020000.00
TS_T_EXP_W_214 9500.001.00190.020000.00
TS_T_EXP_W_215 9500.001.00190.020000.00
TS_T_EXP_W_216 9500.001.00190.020000.00
TS_T_EXP_W_218 9500.001.00190.020000.00
TS_T_EXP_W_219 9500.001.00190.020000.00
TS_T_EXP_W_220 9500.001.00190.020000.00
TS_T_EXP_W_221 9500.001.00190.020000.00
TS_T_EXP_W_222 9500.001.00190.020000.00
TS_T_EXP_W_223 9500.001.00190.020000.00
TS_T_EXP_W_224 9500.001.00190.020000.00
TS_T_EXP_W_225 9500.001.00190.020000.00
TS_T_EXP_W_237 9000.001.00180.010000.00
TS_T_EXP_W_238 9000.001.00180.010000.00
TS_T_EXP_W_239 9000.001.00180.010000.00
TS_T_EXP_W_240 9000.001.00180.010000.00
TS_T_EXP_CONTAINER_226 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_227 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_228 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_229 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_230 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_231 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_232 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_233 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_234 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_235 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_236 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_237 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_238 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_239 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_240 7600.001.00190.010000.00
TS_T_EXP_CONTAINER_203 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_204 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_205 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_206 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_207 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_209 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_210 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_211 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_212 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_213 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_214 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_215 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_216 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_217 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_218 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_219 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_220 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_221 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_222 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_223 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_224 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_225 5700.001.00190.010000.00
TS_T_EXP_CONTAINER_180 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_181 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_182 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_183 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_184 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_185 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_186 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_187 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_188 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_189 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_190 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_191 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_192 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_193 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_194 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_195 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_196 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_197 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_198 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_199 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_200 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_201 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_202 3800.001.00190.010000.00
TS_T_EXP_CONTAINER_161 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_162 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_163 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_164 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_166 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_167 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_168 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_169 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_170 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_171 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_172 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_173 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_174 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_175 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_176 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_177 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_178 1900.001.00190.000000.00
TS_T_EXP_CONTAINER_179 1900.001.00190.000000.00
USERS 1900.001.00190.000000.00
TEMP 100.001.0010.000000.00


Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Rds/sAv Rd(ms)Av Blks/Rd 1-bk Rds/sAv 1-bk Rd(ms)WritesWrites avg/sBuffer WaitsAv Buf Wt(ms)
SYSAUX+DATA_DG/dbquery/datafile/sysaux.262.828812055 8603.951.0004.071,248000.00
SYSTEM+DATA_DG/dbquery/datafile/system.261.828812051 17504.511.0004.511,09301040.48
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_01.dbf 10800.001.0000.0018000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_02.dbf 10800.001.0000.0018000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_03.dbf 10800.001.0000.0018000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_04.dbf 10800.001.0000.0018000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_05.dbf 10800.001.0000.0048000.00
TEMP+DATA_DG/dbquery/tempfile/temp.264.828812057 100.001.0000.00100 
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_01.dbf 9000.001.0000.0018000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_02.dbf 9000.001.0000.0018000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_03.dbf 9000.001.0000.0018000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_04.dbf 9000.001.0000.0018000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_05.dbf 9000.001.0000.0018000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_06.dbf 9000.001.0000.0018000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_07.dbf 9000.001.0000.0018000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_08.dbf 9000.001.0000.0018000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_09.dbf 10800.001.0000.0018000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_10.dbf 10800.001.0000.0018000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_01.dbf 57404.342.4804.283,6141430.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_02.dbf 1,33303.431.7703.367,2761280.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_03.dbf 1,39103.191.1703.146,4881400.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_04.dbf 1,26803.411.0903.366,46111630.06
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_05.dbf 1,93603.501.0903.467,4001490.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_06.dbf 1,70602.581.0602.585,3871290.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_07.dbf 1,92002.571.2802.543,9941480.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_08.dbf 57903.521.2303.817,5131570.18
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_09.dbf 1,54103.271.3603.406,91311170.17
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_10.dbf 1,03103.651.2203.665,0841850.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_01.dbf 10800.001.0000.0018000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_02.dbf 10800.001.0000.0020000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_03.dbf 10900.091.0000.0922000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_04.dbf 10800.001.0000.0027000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_05.dbf 11100.181.0000.1835000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_06.dbf 10800.001.0000.0018000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_07.dbf 10800.001.0000.0021000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_08.dbf 10900.091.0000.0920000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_09.dbf 10800.001.0000.0018000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_10.dbf 9000.001.0000.0018000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_01.dbf 9800.311.0000.201,072000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_02.dbf 10100.501.0000.502,066030.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_03.dbf 10101.881.0001.781,259000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_04.dbf 8600.581.0000.581,975020.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_05.dbf 9900.611.0000.611,962010.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_06.dbf 8801.701.0001.70797000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_07.dbf 9200.761.0000.761,210000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_08.dbf 8200.371.0000.24693010.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_09.dbf 8900.791.0000.90935000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_10.dbf 8600.701.0000.70849010.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_01.dbf 1,46903.121.0003.1215,41222500.20
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_02.dbf 1,15203.111.0003.1114,51422960.17
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_03.dbf 87903.891.0003.8914,20823180.03
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_04.dbf 93803.401.0003.4014,54822890.14
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_05.dbf 67803.011.0003.0112,69522740.22
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_06.dbf 92603.521.0003.5212,64923670.16
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_07.dbf 1,13003.431.0003.4412,27422820.11
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_08.dbf 1,68602.861.0002.8613,41323460.12
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_09.dbf 1,35002.961.0002.9615,29723730.05
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_10.dbf 1,49003.131.0003.1316,38233140.03
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_01.dbf 3,46611.101.0011.102,60101470.41
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_02.dbf 3,51711.081.0011.072,09201420.49
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_03.dbf 3,74511.151.0011.152,60701310.31
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_04.dbf 3,89111.151.0011.152,24701460.89
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_05.dbf 4,38311.081.0011.091,29801960.46
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_06.dbf 4,26211.091.0011.091,09301610.62
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_07.dbf 3,49611.161.0011.161,10201340.45
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_08.dbf 3,41311.171.0011.171,10201710.35
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_09.dbf 2,99901.121.0001.131,68501160.60
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_10.dbf 2,97701.181.0001.181,8490710.28
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_01.dbf 1,48101.131.0001.131,90401820.71
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_02.dbf 1,80501.211.0001.212,01702210.95
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_03.dbf 3,52410.951.0010.951,32502370.68
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_04.dbf 2,71701.061.0001.061,56201760.40
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_05.dbf 2,33501.051.0001.0558601970.91
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_06.dbf 2,05001.061.0001.061,28502490.48
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_07.dbf 1,17801.201.0001.201,22001230.57
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_08.dbf 1,31101.271.0001.271,36302980.60
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_09.dbf 1,38501.261.0001.251,10901581.01
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_10.dbf 2,78300.951.0000.951,21302630.57
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_01.dbf 18,26831.221.0031.223,007010.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_02.dbf 16,23431.241.0031.243,418100.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_03.dbf 18,13431.201.0031.203,897110.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_04.dbf 18,87431.211.0031.213,411142.50
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_05.dbf 16,27631.241.0031.242,809000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_06.dbf 17,68831.211.0031.213,256130.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_07.dbf 20,14731.211.0031.212,594000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_08.dbf 18,55031.191.0031.191,406000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_09.dbf 16,50531.201.0031.20910000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_10.dbf 17,34431.251.0031.252,293080.00
TS_IDX_T_EXP_CONTAINER_161+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_161.dbf 9501.051.0001.055190350.00
TS_IDX_T_EXP_CONTAINER_162+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_162.dbf 15301.631.0001.57563060.00
TS_IDX_T_EXP_CONTAINER_163+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_163.dbf 7600.001.0000.00128000.00
TS_IDX_T_EXP_CONTAINER_164+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_164.dbf 7900.251.0000.25424010.00
TS_IDX_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_165.dbf 11301.241.0001.243,473190.00
TS_IDX_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165_01.dbf 9000.001.0000.003,491140.00
TS_IDX_T_EXP_CONTAINER_166+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_166.dbf 11701.201.0001.204300130.00
TS_IDX_T_EXP_CONTAINER_167+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_167.dbf 8301.081.0000.96226010.00
TS_IDX_T_EXP_CONTAINER_168+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_168.dbf 7800.131.0000.13170000.00
TS_IDX_T_EXP_CONTAINER_169+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_169.dbf 9800.101.0000.10293020.00
TS_IDX_T_EXP_CONTAINER_170+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_170.dbf 9900.201.0000.20289010.00
TS_IDX_T_EXP_CONTAINER_171+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_171.dbf 9700.001.0000.10182020.00
TS_IDX_T_EXP_CONTAINER_172+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_172.dbf 9500.001.0000.00336050.00
TS_IDX_T_EXP_CONTAINER_173+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_173.dbf 10200.101.0000.10212010.00
TS_IDX_T_EXP_CONTAINER_174+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_174.dbf 14501.721.0001.66506030.00
TS_IDX_T_EXP_CONTAINER_175+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_175.dbf 15701.911.0001.91544030.00
TS_IDX_T_EXP_CONTAINER_176+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_176.dbf 9500.001.0000.00241010.00
TS_IDX_T_EXP_CONTAINER_177+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_177.dbf 12300.891.0000.81302030.00
TS_IDX_T_EXP_CONTAINER_178+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_178.dbf 10000.201.0000.20216040.00
TS_IDX_T_EXP_CONTAINER_179+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_179.dbf 11801.441.0001.53294040.00
TS_IDX_T_EXP_CONTAINER_180+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_180.dbf 9900.201.0000.30256050.00
TS_IDX_T_EXP_CONTAINER_181+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_181.dbf 17201.401.0001.401,0210190.00
TS_IDX_T_EXP_CONTAINER_182+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_182.dbf 10500.671.0000.67218000.00
TS_IDX_T_EXP_CONTAINER_183+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_183.dbf 9800.101.0000.20212000.00
TS_IDX_T_EXP_CONTAINER_184+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_184.dbf 9900.201.0000.10144030.00
TS_IDX_T_EXP_CONTAINER_185+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_185.dbf 10000.201.0000.20226000.00
TS_IDX_T_EXP_CONTAINER_186+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_186.dbf 12501.041.0001.048180220.00
TS_IDX_T_EXP_CONTAINER_187+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_187.dbf 10000.201.0000.10220040.00
TS_IDX_T_EXP_CONTAINER_188+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_188.dbf 10200.491.0000.49333000.00
TS_IDX_T_EXP_CONTAINER_189+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_189.dbf 10000.101.0000.00143000.00
TS_IDX_T_EXP_CONTAINER_190+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_190.dbf 9800.311.0000.31143010.00
TS_IDX_T_EXP_CONTAINER_191+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_191.dbf 9600.101.0000.00180025.00
TS_IDX_T_EXP_CONTAINER_192+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_192.dbf 12100.171.0000.17156010.00
TS_IDX_T_EXP_CONTAINER_193+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_193.dbf 11800.171.0000.17220000.00
TS_IDX_T_EXP_CONTAINER_194+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_194.dbf 16601.081.0001.088360110.00
TS_IDX_T_EXP_CONTAINER_195+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_195.dbf 49202.681.0002.681,7990440.00
TS_IDX_T_EXP_CONTAINER_196+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_196.dbf 11700.171.0000.17180000.00
TS_IDX_T_EXP_CONTAINER_197+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_197.dbf 11400.001.0000.00201000.00
TS_IDX_T_EXP_CONTAINER_198+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_198.dbf 13901.011.0001.01267060.00
TS_IDX_T_EXP_CONTAINER_199+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_199.dbf 18601.611.0001.611,0830120.00
TS_IDX_T_EXP_CONTAINER_200+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_200.dbf 11600.091.0000.09169000.00
TS_IDX_T_EXP_CONTAINER_201+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_201.dbf 11500.001.0000.00209000.00
TS_IDX_T_EXP_CONTAINER_202+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_202.dbf 17801.011.0001.016660110.00
TS_IDX_T_EXP_CONTAINER_203+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_203.dbf 9500.001.0000.00146000.00
TS_IDX_T_EXP_CONTAINER_204+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_204.dbf 20802.361.0002.36622090.00
TS_IDX_T_EXP_CONTAINER_205+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_205.dbf 10000.201.0000.20183000.00
TS_IDX_T_EXP_CONTAINER_206+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_206.dbf 9500.001.0000.001,200020.00
TS_IDX_T_EXP_CONTAINER_207+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_207.dbf 12500.881.0000.883730160.00
TS_IDX_T_EXP_CONTAINER_208+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_208.dbf 12901.241.0001.243,8541570.00
TS_IDX_T_EXP_CONTAINER_209+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_209.dbf 21503.121.0003.07800040.00
TS_IDX_T_EXP_CONTAINER_210+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_210.dbf 9600.001.0000.10205010.00
TS_IDX_T_EXP_CONTAINER_211+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_211.dbf 10000.501.0000.5067010.00
TS_IDX_T_EXP_CONTAINER_212+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_212.dbf 9800.311.0000.20111040.00
TS_IDX_T_EXP_CONTAINER_213+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_213.dbf 9700.101.0000.21139010.00
TS_IDX_T_EXP_CONTAINER_214+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_214.dbf 9500.001.0000.00298000.00
TS_IDX_T_EXP_CONTAINER_215+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_215.dbf 14300.771.0000.77864050.00
TS_IDX_T_EXP_CONTAINER_216+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_216.dbf 12800.631.0000.631,010090.00
TS_IDX_T_EXP_CONTAINER_217+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_217.dbf 11500.001.0000.00129010.00
TS_IDX_T_EXP_CONTAINER_218+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_218.dbf 11500.091.0000.09140000.00
TS_IDX_T_EXP_CONTAINER_219+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_219.dbf 15801.011.0000.951,1450420.00
TS_IDX_T_EXP_CONTAINER_220+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_220.dbf 15301.181.0001.181,0290170.59
TS_IDX_T_EXP_CONTAINER_221+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_221.dbf 18501.351.0001.356040110.00
TS_IDX_T_EXP_CONTAINER_222+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_222.dbf 12200.411.0000.41210020.00
TS_IDX_T_EXP_CONTAINER_223+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_223.dbf 12000.331.0000.33174050.00
TS_IDX_T_EXP_CONTAINER_224+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_224.dbf 15201.451.0001.45541070.00
TS_IDX_T_EXP_CONTAINER_225+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_225.dbf 13401.041.0001.041,0220210.00
TS_IDX_T_EXP_CONTAINER_226+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_226.dbf 10000.501.0000.50132000.00
TS_IDX_T_EXP_CONTAINER_227+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_227.dbf 11300.881.0000.808020300.00
TS_IDX_T_EXP_CONTAINER_228+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_228.dbf 12200.661.0000.66807060.00
TS_IDX_T_EXP_CONTAINER_229+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_229.dbf 11101.081.0001.08342000.00
TS_IDX_T_EXP_CONTAINER_230+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_230.dbf 9700.211.0000.2198000.00
TS_IDX_T_EXP_CONTAINER_231+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_231.dbf 9600.001.0000.00342010.00
TS_IDX_T_EXP_CONTAINER_232+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_232.dbf 9700.101.0000.10169000.00
TS_IDX_T_EXP_CONTAINER_233+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_233.dbf 19801.871.0001.821,9100190.00
TS_IDX_T_EXP_CONTAINER_234+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_234.dbf 9700.101.0000.10334030.00
TS_IDX_T_EXP_CONTAINER_235+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_235.dbf 9700.101.0000.10136010.00
TS_IDX_T_EXP_CONTAINER_236+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_236.dbf 9500.001.0000.0053000.00
TS_IDX_T_EXP_CONTAINER_237+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_237.dbf 11701.541.0001.45332000.00
TS_IDX_T_EXP_CONTAINER_238+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_238.dbf 13401.571.0001.64284010.00
TS_IDX_T_EXP_CONTAINER_239+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_239.dbf 12000.081.0000.0897000.00
TS_IDX_T_EXP_CONTAINER_240+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_240.dbf 11500.091.0000.09127000.00
TS_IDX_T_EXP_W_161+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_161.dbf 16202.591.0002.651,4520180.00
TS_IDX_T_EXP_W_162+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_162.dbf 45205.271.0005.291,08205433.83
TS_IDX_T_EXP_W_163+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_163.dbf 12702.281.0002.36489030.00
TS_IDX_T_EXP_W_164+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_164.dbf 44705.121.0005.121,24303454.06
TS_IDX_T_EXP_W_165+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_165.dbf 14002.641.0002.645130874.60
TS_IDX_T_EXP_W_166+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_166.dbf 9900.401.0000.40574050.00
TS_IDX_T_EXP_W_167+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_167.dbf 30304.621.0004.62605090.00
TS_IDX_T_EXP_W_168+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_168.dbf 13901.651.0001.58556042.50
TS_IDX_T_EXP_W_169+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_169.dbf 14601.441.0001.448510110.00
TS_IDX_T_EXP_W_170+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_170.dbf 27904.341.0004.341,18402014.28
TS_IDX_T_EXP_W_171+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_171.dbf 12900.701.0000.70701033.33
TS_IDX_T_EXP_W_172+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_172.dbf 14801.551.0001.627560100.00
TS_IDX_T_EXP_W_173+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_173.dbf 22704.271.0004.276510239.13
TS_IDX_T_EXP_W_174+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_174.dbf 39904.611.0004.641,321070.00
TS_IDX_T_EXP_W_175+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_175.dbf 13901.221.0001.221,352050.00
TS_IDX_T_EXP_W_176+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_176.dbf 30504.431.0004.4354703984.42
TS_IDX_T_EXP_W_177+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_177.dbf 21603.241.0003.24854010.00
TS_IDX_T_EXP_W_178+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_178.dbf 12000.421.0000.42695070.00
TS_IDX_T_EXP_W_179+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_179.dbf 11300.181.0000.18539030.00
TS_IDX_T_EXP_W_180+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_180.dbf 12701.811.0001.895810265.38
TS_IDX_T_EXP_W_181+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_181.dbf 23904.141.0004.1087002743.83
TS_IDX_T_EXP_W_182+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_182.dbf 1,24106.311.0006.317430704.86
TS_IDX_T_EXP_W_183+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_183.dbf 42005.211.0005.241,225020.00
TS_IDX_T_EXP_W_184+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_184.dbf 31404.901.0004.9043101803.56
TS_IDX_T_EXP_W_185+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_185.dbf 46005.521.0005.5079405213.90
TS_IDX_T_EXP_W_186+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_186.dbf 30403.721.0003.72752000.00
TS_IDX_T_EXP_W_187+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_187.dbf 16602.951.0002.95602070.00
TS_IDX_T_EXP_W_188+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_188.dbf 10700.931.0000.93966020.00
TS_IDX_T_EXP_W_189+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_189.dbf 10700.471.0000.47481040.00
TS_IDX_T_EXP_W_190+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_190.dbf 9700.521.0000.52477010.00
TS_IDX_T_EXP_W_191+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_191.dbf 9800.511.0000.51613000.00
TS_IDX_T_EXP_W_192+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_192.dbf 11300.271.0000.27516000.00
TS_IDX_T_EXP_W_193+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_193.dbf 17802.131.0002.13456000.00
TS_IDX_T_EXP_W_194+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_194.dbf 12000.331.0000.33348000.00
TS_IDX_T_EXP_W_195+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_195.dbf 32204.881.0004.8847805274.50
TS_IDX_T_EXP_W_196+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_196.dbf 12000.581.0000.67546000.00
TS_IDX_T_EXP_W_197+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_197.dbf 31304.701.0004.7057501283.91
TS_IDX_T_EXP_W_198+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_198.dbf 23703.761.0003.766320413.41
TS_IDX_T_EXP_W_199+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_199.dbf 11700.431.0000.43521033.33
TS_IDX_T_EXP_W_200+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_200.dbf 13801.091.0001.094040553.09
TS_IDX_T_EXP_W_201+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_201.dbf 18402.501.0002.50521033.33
TS_IDX_T_EXP_W_202+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_202.dbf 18902.491.0002.491,074000.00
TS_IDX_T_EXP_W_203+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_203.dbf 17504.001.0004.0662701765.06
TS_IDX_T_EXP_W_204+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_204.dbf 10100.301.0000.30441010.00
TS_IDX_T_EXP_W_205+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_205.dbf 46305.181.0005.21405010.00
TS_IDX_T_EXP_W_206+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_206.dbf 12201.391.0001.488020664.39
TS_IDX_T_EXP_W_207+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_207.dbf 10100.401.0000.40429000.00
TS_IDX_T_EXP_W_208+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_208.dbf 20002.901.0002.85767020.00
TS_IDX_T_EXP_W_209+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_209.dbf 9600.421.0000.31701000.00
TS_IDX_T_EXP_W_210+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_210.dbf 11701.971.0001.97366020.00
TS_IDX_T_EXP_W_211+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_211.dbf 10100.401.0000.40255000.00
TS_IDX_T_EXP_W_212+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_212.dbf 9800.311.0000.31398020.00
TS_IDX_T_EXP_W_213+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_213.dbf 12402.021.0002.10561030.00
TS_IDX_T_EXP_W_214+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_214.dbf 10600.661.0000.66647000.00
TS_IDX_T_EXP_W_215+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_215.dbf 12500.401.0000.401,842060.00
TS_IDX_T_EXP_W_216+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_216.dbf 30704.721.0004.76592030.00
TS_IDX_T_EXP_W_217+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_217.dbf 13500.961.0000.96489070.00
TS_IDX_T_EXP_W_218+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_218.dbf 24204.091.0004.09349000.00
TS_IDX_T_EXP_W_219+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_219.dbf 11200.271.0000.27439000.00
TS_IDX_T_EXP_W_220+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_220.dbf 11300.351.0000.35543000.00
TS_IDX_T_EXP_W_221+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_221.dbf 12902.021.0002.02223030.00
TS_IDX_T_EXP_W_222+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_222.dbf 12100.331.0000.33232000.00
TS_IDX_T_EXP_W_223+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_223.dbf 17402.871.0002.8739401044.23
TS_IDX_T_EXP_W_224+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_224.dbf 36505.121.0005.1077306144.10
TS_IDX_T_EXP_W_225+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_225.dbf 21503.071.0003.0737801593.71
TS_IDX_T_EXP_W_226+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_226.dbf 14002.501.0002.50305020.00
TS_IDX_T_EXP_W_227+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_227.dbf 10900.641.0000.73553010.00
TS_IDX_T_EXP_W_228+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_228.dbf 10200.491.0000.49293020.00
TS_IDX_T_EXP_W_229+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_229.dbf 16803.571.0003.577370183.33
TS_IDX_T_EXP_W_230+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_230.dbf 13001.541.0001.62279030.00
TS_IDX_T_EXP_W_231+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_231.dbf 9800.411.0000.31567020.00
TS_IDX_T_EXP_W_232+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_232.dbf 19203.281.0003.3340902482.98
TS_IDX_T_EXP_W_233+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_233.dbf 23604.321.0004.32864020.00
TS_IDX_T_EXP_W_234+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_234.dbf 10100.591.0000.59164000.00
TS_IDX_T_EXP_W_235+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_235.dbf 9600.311.0000.31287000.00
TS_IDX_T_EXP_W_236+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_236.dbf 73606.151.0006.1567101,4384.07
TS_IDX_T_EXP_W_237+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_237.dbf 21703.961.0003.9672802624.24
TS_IDX_T_EXP_W_238+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_238.dbf 18402.931.0002.936620853.53
TS_IDX_T_EXP_W_239+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_239.dbf 40304.991.0004.99485000.00
TS_IDX_T_EXP_W_240+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_240.dbf 73606.291.0006.2964407174.55
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_01.dbf 14,37121.831.0021.83293,45646770.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_02.dbf 16,12831.831.0031.83293,36046840.12
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_03.dbf 15,72821.831.0021.83295,53547870.11
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_04.dbf 14,77621.881.0021.88298,360471000.10
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_05.dbf 16,52731.841.0031.84300,807481220.16
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_06.dbf 16,44131.851.0031.85302,661481230.16
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_07.dbf 15,16421.851.0021.85303,40948780.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_08.dbf 13,87321.861.0021.86287,90646700.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_09.dbf 13,35721.821.0021.82293,91046740.41
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_10.dbf 13,81821.801.0021.80287,48045580.17
TS_IDX_YTMDM+DATA_DG/dbquery/datafile/ts_idx_ytmdm.dbf 1,58005.471.0005.471,433000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_01.dbf 9600.737.4300.1118000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_02.dbf 9000.001.0000.0018000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_03.dbf 9000.001.0000.0018000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_04.dbf 9000.001.0000.0018000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_05.dbf 9600.837.4300.0018000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_06.dbf 9000.001.0000.0019000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_07.dbf 9000.001.0000.0018000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_08.dbf 9000.001.0000.0018000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_09.dbf 9400.211.0000.2119000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_10.dbf 9200.111.0000.1118000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_01.dbf 24202.071.3801.901,0280280.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_02.dbf 29703.301.9003.381,1820732.74
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_03.dbf 34502.641.1502.631,87101510.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_04.dbf 22303.724.5903.191,6560270.37
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_05.dbf 14701.561.0301.551,1450440.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_06.dbf 14902.891.0902.641,0240350.29
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_07.dbf 15202.831.0002.831,9050340.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_08.dbf 15405.711.0005.711,5510250.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_09.dbf 21403.131.2703.417820254.80
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_10.dbf 21503.441.0303.461,7220381.32
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_01.dbf 9000.001.0000.0018000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_02.dbf 10800.001.0000.0018000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_03.dbf 10800.001.0000.0018000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_04.dbf 10800.001.0000.0018000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_05.dbf 10800.001.0000.0018000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_06.dbf 10800.001.0000.0018000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_07.dbf 10800.001.0000.0018000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_08.dbf 10800.001.0000.0018000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_09.dbf 10800.001.0000.0018000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_10.dbf 10800.001.0000.0018000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_01.dbf 23302.751.0002.702,902063.33
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_02.dbf 49403.001.0002.982,545052.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_03.dbf 36402.061.0002.061,961020.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_04.dbf 16201.421.0001.362,073000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_05.dbf 94802.711.0002.703,457133.33
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_06.dbf 23401.971.0001.921,556080.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_07.dbf 36502.111.0002.111,263030.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_08.dbf 20402.301.0002.301,556000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_09.dbf 75902.831.0002.822,566030.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_10.dbf 48403.351.0003.351,903010.00
TS_T_EXP_CONTAINER_161+DATA_DG/dbquery/datafile/ts_t_exp_container_161.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_162+DATA_DG/dbquery/datafile/ts_t_exp_container_162.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_163+DATA_DG/dbquery/datafile/ts_t_exp_container_163.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_164+DATA_DG/dbquery/datafile/ts_t_exp_container_164.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165_1.dbf 9000.001.0000.0018000.00
TS_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165_2.dbf 9000.001.0000.0018000.00
TS_T_EXP_CONTAINER_166+DATA_DG/dbquery/datafile/ts_t_exp_container_166.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_167+DATA_DG/dbquery/datafile/ts_t_exp_container_167.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_168+DATA_DG/dbquery/datafile/ts_t_exp_container_168.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_169+DATA_DG/dbquery/datafile/ts_t_exp_container_169.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_170+DATA_DG/dbquery/datafile/ts_t_exp_container_170.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_171+DATA_DG/dbquery/datafile/ts_t_exp_container_171.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_172+DATA_DG/dbquery/datafile/ts_t_exp_container_172.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_173+DATA_DG/dbquery/datafile/ts_t_exp_container_173.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_174+DATA_DG/dbquery/datafile/ts_t_exp_container_174.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_175+DATA_DG/dbquery/datafile/ts_t_exp_container_175.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_176+DATA_DG/dbquery/datafile/ts_t_exp_container_176.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_177+DATA_DG/dbquery/datafile/ts_t_exp_container_177.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_178+DATA_DG/dbquery/datafile/ts_t_exp_container_178.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_179+DATA_DG/dbquery/datafile/ts_t_exp_container_179.dbf 1900.001.0000.0019000.00
TS_T_EXP_CONTAINER_180+DATA_DG/dbquery/datafile/ts_t_exp_container_180.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_181+DATA_DG/dbquery/datafile/ts_t_exp_container_181.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_182+DATA_DG/dbquery/datafile/ts_t_exp_container_182.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_183+DATA_DG/dbquery/datafile/ts_t_exp_container_183.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_184+DATA_DG/dbquery/datafile/ts_t_exp_container_184.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_185+DATA_DG/dbquery/datafile/ts_t_exp_container_185.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_186+DATA_DG/dbquery/datafile/ts_t_exp_container_186.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_187+DATA_DG/dbquery/datafile/ts_t_exp_container_187.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_188+DATA_DG/dbquery/datafile/ts_t_exp_container_188.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_189+DATA_DG/dbquery/datafile/ts_t_exp_container_189.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_190+DATA_DG/dbquery/datafile/ts_t_exp_container_190.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_191+DATA_DG/dbquery/datafile/ts_t_exp_container_191.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_192+DATA_DG/dbquery/datafile/ts_t_exp_container_192.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_193+DATA_DG/dbquery/datafile/ts_t_exp_container_193.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_194+DATA_DG/dbquery/datafile/ts_t_exp_container_194.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_195+DATA_DG/dbquery/datafile/ts_t_exp_container_195.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_196+DATA_DG/dbquery/datafile/ts_t_exp_container_196.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_197+DATA_DG/dbquery/datafile/ts_t_exp_container_197.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_198+DATA_DG/dbquery/datafile/ts_t_exp_container_198.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_199+DATA_DG/dbquery/datafile/ts_t_exp_container_199.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_200+DATA_DG/dbquery/datafile/ts_t_exp_container_200.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_201+DATA_DG/dbquery/datafile/ts_t_exp_container_201.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_202+DATA_DG/dbquery/datafile/ts_t_exp_container_202.dbf 3800.001.0000.0019000.00
TS_T_EXP_CONTAINER_203+DATA_DG/dbquery/datafile/ts_t_exp_container_203.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_204+DATA_DG/dbquery/datafile/ts_t_exp_container_204.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_205+DATA_DG/dbquery/datafile/ts_t_exp_container_205.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_206+DATA_DG/dbquery/datafile/ts_t_exp_container_206.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_207+DATA_DG/dbquery/datafile/ts_t_exp_container_207.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_208+DATA_DG/dbquery/datafile/ts_t_exp_container_208.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_208+DATA_DG/dbquery/datafile/ts_t_exp_container_208_1.dbf 9000.001.0000.0018000.00
TS_T_EXP_CONTAINER_209+DATA_DG/dbquery/datafile/ts_t_exp_container_209.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_210+DATA_DG/dbquery/datafile/ts_t_exp_container_210.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_211+DATA_DG/dbquery/datafile/ts_t_exp_container_211.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_212+DATA_DG/dbquery/datafile/ts_t_exp_container_212.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_213+DATA_DG/dbquery/datafile/ts_t_exp_container_213.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_214+DATA_DG/dbquery/datafile/ts_t_exp_container_214.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_215+DATA_DG/dbquery/datafile/ts_t_exp_container_215.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_216+DATA_DG/dbquery/datafile/ts_t_exp_container_216.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_217+DATA_DG/dbquery/datafile/ts_t_exp_container_217.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_218+DATA_DG/dbquery/datafile/ts_t_exp_container_218.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_219+DATA_DG/dbquery/datafile/ts_t_exp_container_219.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_220+DATA_DG/dbquery/datafile/ts_t_exp_container_220.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_221+DATA_DG/dbquery/datafile/ts_t_exp_container_221.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_222+DATA_DG/dbquery/datafile/ts_t_exp_container_222.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_223+DATA_DG/dbquery/datafile/ts_t_exp_container_223.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_224+DATA_DG/dbquery/datafile/ts_t_exp_container_224.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_225+DATA_DG/dbquery/datafile/ts_t_exp_container_225.dbf 5700.001.0000.0019000.00
TS_T_EXP_CONTAINER_226+DATA_DG/dbquery/datafile/ts_t_exp_container_226.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_227+DATA_DG/dbquery/datafile/ts_t_exp_container_227.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_228+DATA_DG/dbquery/datafile/ts_t_exp_container_228.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_229+DATA_DG/dbquery/datafile/ts_t_exp_container_229.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_230+DATA_DG/dbquery/datafile/ts_t_exp_container_230.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_231+DATA_DG/dbquery/datafile/ts_t_exp_container_231.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_232+DATA_DG/dbquery/datafile/ts_t_exp_container_232.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_233+DATA_DG/dbquery/datafile/ts_t_exp_container_233.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_234+DATA_DG/dbquery/datafile/ts_t_exp_container_234.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_235+DATA_DG/dbquery/datafile/ts_t_exp_container_235.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_236+DATA_DG/dbquery/datafile/ts_t_exp_container_236.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_237+DATA_DG/dbquery/datafile/ts_t_exp_container_237.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_238+DATA_DG/dbquery/datafile/ts_t_exp_container_238.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_239+DATA_DG/dbquery/datafile/ts_t_exp_container_239.dbf 7600.001.0000.0019000.00
TS_T_EXP_CONTAINER_240+DATA_DG/dbquery/datafile/ts_t_exp_container_240.dbf 7600.001.0000.0019000.00
TS_T_EXP_W_160+DATA_DG/dbquery/datafile/ts_t_exp_w_160.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_161+DATA_DG/dbquery/datafile/ts_t_exp_w_161.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_162+DATA_DG/dbquery/datafile/ts_t_exp_w_162.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_163+DATA_DG/dbquery/datafile/ts_t_exp_w_163.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_164+DATA_DG/dbquery/datafile/ts_t_exp_w_164.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_165+DATA_DG/dbquery/datafile/ts_t_exp_w_165.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_166+DATA_DG/dbquery/datafile/ts_t_exp_w_166.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_167+DATA_DG/dbquery/datafile/ts_t_exp_w_167.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_168+DATA_DG/dbquery/datafile/ts_t_exp_w_168.dbf 9600.001.0000.1019000.00
TS_T_EXP_W_169+DATA_DG/dbquery/datafile/ts_t_exp_w_169.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_170+DATA_DG/dbquery/datafile/ts_t_exp_w_170.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_171+DATA_DG/dbquery/datafile/ts_t_exp_w_171.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_172+DATA_DG/dbquery/datafile/ts_t_exp_w_172.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_173+DATA_DG/dbquery/datafile/ts_t_exp_w_173.dbf 9600.101.0000.1019000.00
TS_T_EXP_W_174+DATA_DG/dbquery/datafile/ts_t_exp_w_174.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_175+DATA_DG/dbquery/datafile/ts_t_exp_w_175.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_176+DATA_DG/dbquery/datafile/ts_t_exp_w_176.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_177+DATA_DG/dbquery/datafile/ts_t_exp_w_177.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_178+DATA_DG/dbquery/datafile/ts_t_exp_w_178.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_179+DATA_DG/dbquery/datafile/ts_t_exp_w_179.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_180+DATA_DG/dbquery/datafile/ts_t_exp_w_180.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_181+DATA_DG/dbquery/datafile/ts_t_exp_w_181.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_182+DATA_DG/dbquery/datafile/ts_t_exp_w_182.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_183+DATA_DG/dbquery/datafile/ts_t_exp_w_183.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_184+DATA_DG/dbquery/datafile/ts_t_exp_w_184.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_185+DATA_DG/dbquery/datafile/ts_t_exp_w_185.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_186+DATA_DG/dbquery/datafile/ts_t_exp_w_186.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_187+DATA_DG/dbquery/datafile/ts_t_exp_w_187.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_188+DATA_DG/dbquery/datafile/ts_t_exp_w_188.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_189+DATA_DG/dbquery/datafile/ts_t_exp_w_189.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_190+DATA_DG/dbquery/datafile/ts_t_exp_w_190.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_191+DATA_DG/dbquery/datafile/ts_t_exp_w_191.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_192+DATA_DG/dbquery/datafile/ts_t_exp_w_192.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_193+DATA_DG/dbquery/datafile/ts_t_exp_w_193.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_194+DATA_DG/dbquery/datafile/ts_t_exp_w_194.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_195+DATA_DG/dbquery/datafile/ts_t_exp_w_195.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_196+DATA_DG/dbquery/datafile/ts_t_exp_w_196.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_197+DATA_DG/dbquery/datafile/ts_t_exp_w_197.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_198+DATA_DG/dbquery/datafile/ts_t_exp_w_198.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_199+DATA_DG/dbquery/datafile/ts_t_exp_w_199.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_200+DATA_DG/dbquery/datafile/ts_t_exp_w_200.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_201+DATA_DG/dbquery/datafile/ts_t_exp_w_201.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_202+DATA_DG/dbquery/datafile/ts_t_exp_w_202.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_203+DATA_DG/dbquery/datafile/ts_t_exp_w_203.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_204+DATA_DG/dbquery/datafile/ts_t_exp_w_204.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_205+DATA_DG/dbquery/datafile/ts_t_exp_w_205.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_206+DATA_DG/dbquery/datafile/ts_t_exp_w_206.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_207+DATA_DG/dbquery/datafile/ts_t_exp_w_207.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_208+DATA_DG/dbquery/datafile/ts_t_exp_w_208.dbf 11900.251.0000.1719000.00
TS_T_EXP_W_209+DATA_DG/dbquery/datafile/ts_t_exp_w_209.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_210+DATA_DG/dbquery/datafile/ts_t_exp_w_210.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_211+DATA_DG/dbquery/datafile/ts_t_exp_w_211.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_212+DATA_DG/dbquery/datafile/ts_t_exp_w_212.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_213+DATA_DG/dbquery/datafile/ts_t_exp_w_213.dbf 11400.001.0000.0019000.00
TS_T_EXP_W_214+DATA_DG/dbquery/datafile/ts_t_exp_w_214.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_215+DATA_DG/dbquery/datafile/ts_t_exp_w_215.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_216+DATA_DG/dbquery/datafile/ts_t_exp_w_216.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_217+DATA_DG/dbquery/datafile/ts_t_exp_w_217.dbf 9800.201.0000.2021000.00
TS_T_EXP_W_218+DATA_DG/dbquery/datafile/ts_t_exp_w_218.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_219+DATA_DG/dbquery/datafile/ts_t_exp_w_219.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_220+DATA_DG/dbquery/datafile/ts_t_exp_w_220.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_221+DATA_DG/dbquery/datafile/ts_t_exp_w_221.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_222+DATA_DG/dbquery/datafile/ts_t_exp_w_222.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_223+DATA_DG/dbquery/datafile/ts_t_exp_w_223.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_224+DATA_DG/dbquery/datafile/ts_t_exp_w_224.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_225+DATA_DG/dbquery/datafile/ts_t_exp_w_225.dbf 9500.001.0000.0019000.00
TS_T_EXP_W_226+DATA_DG/dbquery/datafile/ts_t_exp_w_226.dbf 10800.001.0000.0018000.00
TS_T_EXP_W_227+DATA_DG/dbquery/datafile/ts_t_exp_w_227.dbf 10800.001.0000.0018000.00
TS_T_EXP_W_228+DATA_DG/dbquery/datafile/ts_t_exp_w_228.dbf 10800.001.0000.0018000.00
TS_T_EXP_W_229+DATA_DG/dbquery/datafile/ts_t_exp_w_229.dbf 10800.001.0000.0018000.00
TS_T_EXP_W_230+DATA_DG/dbquery/datafile/ts_t_exp_w_230.dbf 10800.001.0000.0018000.00
TS_T_EXP_W_231+DATA_DG/dbquery/datafile/ts_t_exp_w_231.dbf 10800.001.0000.0018000.00
TS_T_EXP_W_232+DATA_DG/dbquery/datafile/ts_t_exp_w_232.dbf 11601.728.5100.0918000.00
TS_T_EXP_W_233+DATA_DG/dbquery/datafile/ts_t_exp_w_233.dbf 10800.001.0000.0018000.00
TS_T_EXP_W_234+DATA_DG/dbquery/datafile/ts_t_exp_w_234.dbf 10800.001.0000.0018000.00
TS_T_EXP_W_235+DATA_DG/dbquery/datafile/ts_t_exp_w_235.dbf 10800.001.0000.0018000.00
TS_T_EXP_W_236+DATA_DG/dbquery/datafile/ts_t_exp_w_236.dbf 10800.001.0000.0018000.00
TS_T_EXP_W_237+DATA_DG/dbquery/datafile/ts_t_exp_w_237.dbf 9000.001.0000.0018000.00
TS_T_EXP_W_238+DATA_DG/dbquery/datafile/ts_t_exp_w_238.dbf 9000.001.0000.0018000.00
TS_T_EXP_W_239+DATA_DG/dbquery/datafile/ts_t_exp_w_239.dbf 9000.001.0000.0018000.00
TS_T_EXP_W_240+DATA_DG/dbquery/datafile/ts_t_exp_w_240.dbf 9000.001.0000.0018000.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_01.dbf 1,02806.021.0006.0162,29110370.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_02.dbf 1,27405.311.0005.3065,88910360.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_03.dbf 1,25205.591.0005.5958,6229730.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_04.dbf 74905.711.0005.7354,7239810.25
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_05.dbf 82205.431.0005.4349,1658291.03
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_06.dbf 46404.811.0004.8143,9147200.50
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_07.dbf 63505.611.0005.6140,6416120.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_08.dbf 84505.801.0005.8043,7887190.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_09.dbf 1,15404.341.0004.3550,5068171.18
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_10.dbf 1,34305.441.0005.4460,52710250.80
TS_YTMDM+DATA_DG/dbquery/datafile/ts_ytmdb.dbf 2,62304.851.0004.853,9951120.00
TS_YTMDM+DATA_DG/dbquery/datafile/ts_ytmdb1.dbf 35803.971.0003.97770000.00
UNDOTBS1+DATA_DG/dbquery/datafile/undotbs1.263.828812057 1900.001.0000.00257,197412,7770.11
USERS+DATA_DG/dbquery/datafile/users.265.828812065 1900.001.0000.0019000.00


Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D18,607,715100251,709,810440,8147,535,2080019,915


Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
02,690,075003,948,036896,840


Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual RedoBlksTarget RedoBlksLog Sz RedoBlksLog Ckpt Timeout RedoBlksLog Ckpt Interval RedoBlksOpt Log Sz(M)Estd RAC Avail Time
B02922367147572178100741472001781007   
E076251899533574414720041472005587493   


Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D14,8480.101,8292.04462,1091757523.00
D29,6960.203,6581.46330,7911403564.00
D44,5440.295,4881.30293,2851302469.00
D59,3920.397,3171.22276,5191257278.00
D74,2400.499,1461.17264,8401225798.00
D89,0880.5910,9751.13255,4521200493.00
D103,9360.6812,8051.09247,8271179941.00
D118,7840.7814,6341.05238,7851155568.00
D133,6320.8816,4631.02231,9481137140.00
D148,4800.9818,2921.01227,5071125170.00
D152,0641.0018,7341.00226,3521122057.00
D163,3281.0720,1220.98222,6631112112.00
D178,1761.1721,9510.97219,7051104140.00
D193,0241.2723,7800.96216,832196394.00
D207,8721.3725,6090.95213,983188716.00
D222,7201.4627,4380.93211,600182291.00
D237,5681.5629,2680.93209,932177795.00
D252,4161.6631,0970.92208,433173755.00
D267,2641.7632,9260.92207,477171178.00
D282,1121.8634,7550.91206,670169003.00
D296,9601.9536,5850.91205,441165691.00


Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.003,9070


Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B61,44054,1691,574.740.000.000.000.001,048,576
E61,44054,0541,623.560.000.000.000.001,048,576


Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K73,41273,41200
64K128K757500
128K256K4400
256K512K2200
512K1024K10010000
1M2M83683600
2M4M808000
4M8M16416400
8M16M171700
16M32M868600


Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
7,6800.131,292,697.715,742.27100.00035,281,313
15,3600.251,292,697.715,742.27100.00035,281,313
30,7200.501,292,697.715,742.27100.00035,281,313
46,0800.751,292,697.715,742.27100.00035,281,313
61,4401.001,292,697.715,742.27100.00035,281,313
73,7281.201,292,697.712,351.22100.00035,189,172
86,0161.401,292,697.712,351.22100.00035,189,172
98,3041.601,292,697.712,351.22100.00035,189,172
110,5921.801,292,697.712,351.22100.00035,189,172
122,8802.001,292,697.712,351.22100.00035,189,172
184,3203.001,292,697.712,351.22100.00035,189,172
245,7604.001,292,697.712,351.22100.00035,189,172
368,6406.001,292,697.712,351.22100.00035,189,172
491,5208.001,292,697.712,351.22100.00035,189,172


Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
6,6560.7670321,5522,897,0651.0022,8601.11472,409
7,1680.821,21431,5282,897,7441.0022,1811.08472,595
7,6800.881,72343,7512,898,2961.0021,6291.05473,257
8,1920.942,23460,5252,899,1391.0020,7861.01473,511
8,7041.002,74677,2992,899,3121.0020,6131.00473,557
9,2161.063,25794,0692,899,4081.0020,5171.00473,582
9,7281.123,769110,3652,899,4731.0020,4520.99473,598
10,2401.184,281126,1422,899,5281.0020,3970.99473,612
10,7521.244,793140,8552,899,5641.0020,3610.99473,622
11,2641.295,305151,8902,899,5961.0020,3290.99473,629
11,7761.355,817163,1042,899,6161.0020,3090.99473,633
12,2881.416,329178,1892,899,6301.0020,2950.98473,637
12,8001.476,841189,2992,899,6471.0020,2780.98473,641
13,3121.537,353202,6302,899,6691.0020,2560.98473,644
13,8241.597,865215,9612,899,6931.0020,2320.98473,648
14,8481.718,889246,7662,899,7681.0020,1570.98473,658
15,8721.829,913279,9852,899,8261.0020,0990.98473,667
16,8961.9410,937314,4612,899,8831.0020,0420.97473,674
17,9202.0611,961348,9372,899,9341.0019,9910.97473,680


Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
5121.000000
1,0242.000000
1,5363.000000
2,0484.000000
2,5605.000000
3,0726.000000
3,5847.000000
4,0968.000000
4,6089.000000
5,12010.000000
5,63211.000000
6,14412.000000
6,65613.000000
7,16814.000000
7,68015.000000
8,19216.000000
8,70417.000000
9,21618.000000
9,72819.000000
10,24020.000000


Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block16,467332
undo header2,73700
1st level bmb61900
undo block3700
2nd level bmb2600
segment header2000
file header block100


Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 3,6423,64203,133435138.88
TX-Transaction (allocate ITL entry) 16215482212548.64
PR-Process Startup 1,1421,14202711389.63
TX-Transaction (index contention) 25,45225,45201,12321.39
CF-Controlfile Transaction 4,6114,610111023.64
HW-Segment High Water Mark 23,41523,41506801.03
FB-Format Block 28,79128,79104101.46
TX-Transaction 3,752,1643,751,78101402.14
CI-Cross-Instance Call Invocation 868602010.00
XL-ASM Extent Fault Lock (fault extent map) 78780100.00


Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
21,358.503,672,5631,3493815.4/35.50/00/0/0/0/0/0


Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
19-Feb 10:3928,204106,73314314150/00/0/0/0/0/0
19-Feb 10:2977,664565,34274716250/00/0/0/0/0/0
19-Feb 10:19109,166547,33228026180/00/0/0/0/0/0
19-Feb 10:09166,983390,94874632250/00/0/0/0/0/0
19-Feb 09:59428,6211,062,5961,34938350/00/0/0/0/0/0
19-Feb 09:49236,842684,92574636250/00/0/0/0/0/0
19-Feb 09:39139,867173,69014327150/00/0/0/0/0/0
19-Feb 09:2978,39059,28474619250/00/0/0/0/0/0
19-Feb 09:1955,43747,0041448150/00/0/0/0/0/0
19-Feb 09:0937,32134,7097466250/00/0/0/0/0/0


Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch610.00 00 
AQ dequeue txn counter latch200.00 00 
AQ disk delete txn counter latch100.00 00 
ASM Keyed state latch5,7900.00 00 
ASM allocation2,9760.00 00 
ASM db client latch7,8730.00 00 
ASM map headers2,3260.00 00 
ASM map load waiting list5730.00 00 
ASM map operation freelist2,2860.00 00 
ASM map operation hash table18,281,7730.000.0100 
ASM network background latch6,8230.00 00 
ASM network state latch2,8990.00 00 
AWR Alerted Metric Element list96,4470.00 00 
Change Notification Hash table latch2,1010.00 00 
Consistent RBA2,943,2440.030.0200 
DML lock allocation11,495,5450.010.0400 
Event Group Locks5,9880.020.0000 
FAL Queue3590.00 00 
FIB s.o chain latch4200.00 00 
FOB s.o list latch33,1560.00 00 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch32,853,6400.020.7813,752,9640.00
JS Sh mem access110.00 00 
JS mem alloc latch110.00 00 
JS queue access latch120.00 00 
JS queue state obj latch66,1100.00 00 
JS slv state obj latch2780.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KFK SGA Libload latch1,8320.00 00 
KFMD SGA70.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list10.00 00 
KJCT flow control latch10.00 00 
KKCN reg stat latch110.00 00 
KMG MMAN ready and startup request latch2,1070.00 00 
KPON ksr channel latch50.00 00 
KTF sga latch420.00 02,1010.00
KWQMN job cache list latch590.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch370.00 00 
KWQS pqueue ctx latch1640.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch5,4480.00 00 
MQL Tracking Latch0  01260.00
Memory Management Latch10.00 02,1070.00
Memory Queue10.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch700.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process17,1880.00 00 
OS process allocation23,9210.010.0000 
OS process: request allocation5,7890.00 00 
PL/SQL warning settings3,7570.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch141,3060.00 00 
Reserved Space Latch2120.00 00 
Result Cache: RC Latch3,297,7870.020.0000 
SGA IO buffer pool latch7,5610.030.0007,7950.22
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch10.00 02,1010.00
SQL memory manager workarea list latch180,0840.00 00 
Shared B-Tree6920.00 00 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP110.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch1,856,5871.400.0300 
active service list30,2050.030.0007,0010.00
alert log latch1060.00 00 
archive control5430.00 00 
archive process latch1,1311.151.0000 
begin backup scn array20.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles384,6730.010.0200 
cache buffers chains774,433,6360.000.2702,443,9020.00
cache buffers lru chain9,009,3990.010.24011,203,8250.03
cache table scan latch1,0690.00 01,0690.00
call allocation15,0400.290.5100 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch5,8080.00 00 
channel operations parent latch86,5220.000.0000 
checkpoint queue latch59,731,0040.010.0507,742,3190.01
client/application info10,6860.00 00 
compile environment latch3,0410.00 00 
corrupted undo seg latch12,280,7950.030.0000 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch1410.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch1410.00 00 
dml lock allocation8510.00 00 
done queue latch10.00 00 
dummy allocation5,9820.050.0000 
eighth spare latch - X parent10.00 00 
eleventh spare latch - children10.00 00 
enqueue freelist latch10.00 04,571,4570.00
enqueue hash chains23,596,7600.020.0401560.00
enqueues460.00 00 
fifteenth spare latch - children10.00 00 
file cache latch19,5730.010.0000 
first Audit Vault latch1,1220.00 00 
flashback copy10.00 00 
fourteenth spare latch - children10.00 00 
fourth Audit Vault latch10.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs resource validate list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA1,1260.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch9610.00 09,3740.00
hash table modification latch1,2520.00 00 
heartbeat check10.00 00 
internal temp table object number allocation latch30.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch970.00 0960.00
job_queue_processes free list latch1980.00 00 
job_queue_processes parameter latch2,0180.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch530.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch80.00 00 
kpon sga structure10.00 00 
krbmrosl400.00 00 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock1170.00 00 
ksuosstats global area6350.00 00 
ksv allocation latch4110.00 00 
ksv class latch13,0220.150.0000 
ksv instance latch440.00 00 
ksv msg queue latch3640.00 03630.00
ksz_so allocation latch5,7890.00 00 
ktm global data3,6300.00 00 
kwqbsn:qsga2430.00 00 
lgwr LWN SCN2,954,3700.230.0000 
list of block allocation1,164,7210.040.0400 
loader state object freelist5,2480.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch210.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation20.00 00 
logminer local10.00 00 
logminer work area10.00 00 
longop free list parent20.00 010.00
managed standby latch3060.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch10,7870.00 00 
messages12,799,1890.350.0200 
mostly latch-free SCN3,114,0094.650.0000 
msg queue latch10.00 00 
multiblock read objects6,2880.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch1410.00 00 
nineth spare latch - X parent10.00 00 
object queue header heap187,3590.00 055,1820.00
object queue header operation28,192,5870.130.1810 
object stats modification222,6930.010.0000 
parallel query alloc buffer4,2010.00 00 
parallel query stats10.00 00 
parameter list16,1490.030.0000 
parameter table management9,1530.020.0000 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue18,5381.860.00027,5881.61
process allocation7,9130.301.1702,9450.00
process group creation5,7890.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch9190.00 00 
query server freelists10.00 00 
queued dump request210.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation26,030,0700.590.03139,300,9821.34
redo copy10.00 039,442,1851.11
redo writing11,449,7850.190.0400 
reservation so alloc latch1060.00 00 
resmgr group change latch1,3170.00 00 
resmgr:active threads5,9820.00 00 
resmgr:actses change group1,2450.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list5,9810.100.0000 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config810.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects14,093,1410.360.0103,1500.06
rules engine aggregate statistics50.00 00 
rules engine rule set statistics1100.00 00 
second Audit Vault latch10.00 00 
segmented array pool4100.00 00 
sequence cache8,7800.070.0000 
session allocation8,852,3150.010.0108,846,4760.01
session idle bit65,074,8440.010.0300 
session queue latch10.00 00 
session state list latch2,9870.400.0000 
session switching2,1220.00 01,7280.00
session timer2,1270.00 00 
seventh spare latch - X parent10.00 00 
shared pool1,057,7140.060.1303610.00
shared pool sim alloc580.00 00 
shared pool simulator14,8080.00 00 
sim partition latch10.00 00 
simulator hash latch18,251,3220.000.0600 
simulator lru latch2,200,2450.020.08015,737,2520.03
sixth spare latch - X parent10.00 00 
sort extent pool1,0750.00 00 
space background state object latch90.00 00 
space background task latch45,00210.910.1105,2780.13
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation40.00 00 
temporary table state object allocation20.00 00 
tenth spare latch - X parent10.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
thirteenth spare latch - children10.00 00 
threshold alerts latch4,2340.00 00 
trace latch180.00 00 
transaction allocation40,6080.00 00 
twelfth spare latch - children10.00 00 
twenty-fifth spare latch - S par10.00 00 
twenty-first spare latch - S par10.00 00 
twenty-fourth spare latch - S par10.00 00 
twenty-second spare latch - S par10.00 00 
twenty-third spare latch - S par10.00 00 
undo global data22,917,0860.010.0300 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 
write info latch0  02,940,4260.00


Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
redo allocation26,030,070154,1834,702149,623
mostly latch-free SCN3,114,009144,732535144,216
row cache objects14,093,14150,19531849,896
messages12,799,18944,50696743,555
object queue header operation28,192,58735,7136,44429,504
active checkpoint queue latch1,856,58726,08165925,430
redo writing11,449,78521,85491620,951
cache buffers chains774,433,63617,5084,74113,426
lgwr LWN SCN2,954,3706,820176,805
In memory undo latch32,853,6405,9194,6021,540
space background task latch45,0024,9085604,348
enqueue hash chains23,596,7604,7531774,594
checkpoint queue latch59,731,0043,5011863,318
session idle bit65,074,8443,381913,293
corrupted undo seg latch12,280,7953,13193,122
undo global data22,917,0862,277622,218
cache buffers lru chain9,009,3991,3513271,035
Consistent RBA2,943,24495121931
DML lock allocation11,495,54588332852
shared pool1,057,71460576530
session allocation8,852,3155274523
list of block allocation1,164,72147521455
simulator lru latch2,200,24539532363
simulator hash latch18,251,32221512204
ASM map operation hash table18,281,7731752173
call allocation15,040432223
cache buffer handles384,67341140
process allocation7,91324280
archive process latch1,13113130


Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
ASM map operation hash tablekffmDoDone_1011
ASM map operation hash tablekffmTranslate011
DML lock allocationktaiam02417
DML lock allocationktaidm0815
In memory undo latchktiFlush: child03,6341,041
In memory undo latchkticmt: child0867983
In memory undo latchktiFlushMe0163183
In memory undo latchktichg: child0382,402
In memory undo latchkticflush_2080
In memory undo latchktiFlushTopTxn011
PC and Classifier lists for WLMNo latch070
active checkpoint queue latchkcbbacq: scan active checkpoints0659659
archive process latchkcrrsarc0130
cache buffer handleskcbzgs011
cache buffers chainskcbgtcr_202,7261,419
cache buffers chainskcbgtcr: fast path (cr pin)01,1852,337
cache buffers chainskcbgtcr: fast path066925
cache buffers chainskcbget: fast exchange09917
cache buffers chainskcbgcur_208138
cache buffers chainskcbchg1: mod cr pin05530
cache buffers chainskcbgcur: fast path (shr)02016
cache buffers chainskcbgtcr: kslbegin excl01853
cache buffers chainskcbgcur_401128
cache buffers chainskcbnlc0825
cache buffers chainskcbesc: escalate050
cache buffers chainskcbget: pin buffer050
cache buffers chainskcbzpbuf05111
cache buffers chainskcbzwb0510
cache buffers chainskcbchg1: clear MS bit04385
cache buffers chainskcb_post_apply: kcbhq6203158
cache buffers chainskcbbxsv037
cache buffers chainskcbchg1: mod cur pin0328
cache buffers chainskcbrls_20313
cache buffers chainskcb_commit0234
cache buffers chainskcbget: fast path020
cache buffers chainskcbnew: new latch again020
cache buffers chainskcbrls: fast release02102
cache buffers chainskcb_pre_apply: kcbhq610167
cache buffers chainskcbbic1010
cache buffers chainskcbget_1011
cache buffers chainskcbso1: set no access010
cache buffers chainskcbzgb: scan from tail. nowait010
cache buffers lru chainkcbzgws02810
cache buffers lru chainkcbo_link_q0282
cache buffers lru chainkcbzgb01022
cache buffers lru chainkcbbic205298
cache buffers lru chainkcbbxsv: move to being written020
cache buffers lru chainkcbkflb : age buffer out010
call allocationksuxds02010
call allocationksudlp: top call0210
checkpoint queue latchkcbkubc_408372
checkpoint queue latchkcbklbc_cql0800
checkpoint queue latchkcbbwthc: thread checkpoint buffers014110
checkpoint queue latchkcbbwdl: thread checkpoint queue082
checkpoint queue latchkcbklbc: Link buffer into ckpt queue010
corrupted undo seg latchktudiscorrupted099
enqueue hash chainsksqgtl3010197
enqueue hash chainsksqrcl07680
lgwr LWN SCNkcs02301952
list of block allocationktlabl02118
messagesksaamb: after wakeup0460674
messagesksarcv0437269
messagesksarcv: after wait07024
mostly latch-free SCNkcslcu30340550
mostly latch-free SCNkcs0240170
mostly latch-free SCNkcsnew_scn_rba0150
mostly latch-free SCNkcs010621
object queue header operationkcbo_switch_cq04,8132,336
object queue header operationkcbo_switch_q_bg08361,740
object queue header operationkcbo_link_q0767307
object queue header operationkcbo_switch_mq_bg04092,103
object queue header operationkcbo_unlink_q0325389
object queue header operationkcbo_link_q:reget0153
object queue header operationkcbo_sw_buf0159
process allocationksucrp:10250
process allocationksuapc0327
redo allocationkcrfw_redo_gen: redo allocation 103,9330
redo allocationkcrfw_redo_gen: redo allocation 303451,662
redo allocationkcrfw_redo_write: before write02341,363
redo allocationkcrfw_post: more space01261,677
redo allocationkcrfw_redo_gen: redo allocation 20630
redo allocationkcrfwnf:2010
redo writingkcrfwcr0572754
redo writingkcrfw_post: rba scn pair01770
redo writingkcrfw_cal_target_rba014125
redo writingkcrfw_post: after write025137
redo writingkcrfwnf: new logfile010
row cache objectskqrpre: find obj0208196
row cache objectskqreqd: reget0941
row cache objectskqreqd015115
row cache objectskqrpup012
session allocationksucri_int : SSO020
session allocationksuxds024
session idle bitksupuc: set busy04932
session idle bitksupuc: clear busy03742
session idle bitksuxds0921
shared poolkghalo06442
shared poolkghalp096
shared poolkghupr10222
shared poolkghfre015
simulator hash latchkcbsacc: lookup dba01011
simulator hash latchkcbs_lookup_setid: lookup dba021
simulator lru latchkcbs_simulate: simulate set0270
simulator lru latchkcbs_simbufseq0532
space background task latchktsj_grab_task0553560
undo global dataktusmupst: KSLBEGIN03637
undo global dataktudba: KSLBEGIN075
undo global dataktudnx:child071
undo global dataktubnd_4060
undo global dataktufrbs_20520
undo global dataktubnd_3010
undo global datakturax010


Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]4,8990
Cursor ParentkkscsPruneChild [KKSPRTLOC35]1,1060
Library Cachekgllkdl1 858060
Library Cachekgllkc1 575020
hash tablekkshGetNextChild [KKSHBKLOC1]3760
Library Cachekglhdgn2 1063750
Cursor Pinkksfbc [KKSCHLPIN1]1770
Cursor Pinkkslce [KKSCHLPIN2]1390
Library Cachekglpndl1 951310
Library Cachekglhdgn1 621250
Library Cachekglpnal1 90730
Cursor PinkksLockDelete [KKSCHLPIN6]550
Library Cachekglpin1 4420
hash tablekkscsSearchChildList [KKSHBKLOC2]40
Cursor Pinkksfbc [KKSCHLFSP2]40
Cursor Parentkksfbc [KKSPRTLOC3]30
Library Cachekglget1 120
Library Cachekglati1 4510
Library Cachekglobpn1 7110
Cursor ParentkkscsAddChildNodeToNewChild [KKSPRTLOC3310


Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
YTMDMTS_YTMDMMV_MDM_ORG_RPT TABLE14,813,1045.88
YTMDMTS_YTMDMMV_MDM_ORG_STL TABLE14,813,0245.88
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_18TABLE PARTITION13,840,3045.50
YTMDMTS_YTMDMMV_MDM_ORG TABLE10,696,4804.25
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_19TABLE PARTITION5,726,6882.27


Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
YTEXPTS_IDX_YTEXPIDX_EXP_TAKING_STATUS_161_03 INDEX2,0170.42
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_15TABLE PARTITION1,5060.31
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_161_05 INDEX1,0400.22
YTEXPTS_IDX_YTEXPUK_EXP_DELIVERY_STATUS_161 INDEX6370.13
YTEXPTS_IDX_YTEXPIDX_EXP_TAKING_STATUS_161_02 INDEX6230.13


Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
YTEXPTS_IDX_YTEXPIDX_EXP_TAKING_STATUS_161_03 INDEX2,0170.42
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_15TABLE PARTITION1,5060.32
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_161_05 INDEX1,0400.22
YTEXPTS_IDX_YTEXPUK_EXP_DELIVERY_STATUS_161 INDEX6370.13
YTEXPTS_IDX_YTEXPIDX_EXP_TAKING_STATUS_161_02 INDEX6230.13


Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
YTEXPTS_IDX_YTEXPIDX_EXP_TAKING_STATUS_161_03 INDEX2,0170.42
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_15TABLE PARTITION1,5060.32
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_161_05 INDEX1,0400.22
YTEXPTS_IDX_YTEXPUK_EXP_DELIVERY_STATUS_161 INDEX6370.13
YTEXPTS_IDX_YTEXPIDX_EXP_TAKING_STATUS_161_02 INDEX6230.13


Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
YTEXPTS_IDX_YTEXPPK_EXP_DELIVERY_STATUS_165 INDEX137,6301.82
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_165 TABLE60,6820.80
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_05 INDEX46,1530.61
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_03 INDEX45,8800.61
YTEXPTS_IDX_YTEXPUK_EXP_DELIVERY_STATUS_165 INDEX41,4510.55


Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
YTEXPTS_IDX_YTEXPPK_EXP_DELIVERY_STATUS_165 INDEX87,0452.09
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_03 INDEX36,5670.88
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_05 INDEX33,6860.81
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_165 TABLE32,4650.78
YTEXPTS_IDX_YTEXPUK_EXP_DELIVERY_STATUS_165 INDEX31,6080.76


Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
YTEXPTS_IDX_CONTAINERPK_EXP_CONTAINER_208PAR_2014_02_19INDEX PARTITION285,5685.15
YTEXPTS_IDX_T_EXP_CONTAINER_208IDX2_EXP_CONTAINER_208PAR_2014_02_19INDEX PARTITION263,0244.74
YTEXPTS_IDX_CONTAINERIDX3_EXP_CONTAINER_208PAR_2014_02_19INDEX PARTITION232,2884.19
YTEXPTS_IDX_CONTAINERIDX1_EXP_CONTAINER_208PAR_2014_02_19INDEX PARTITION199,0883.59
YTMDMTS_YTMDMMV_MDM_ORG_STL TABLE185,2643.34


Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_208_04 INDEX3907.52
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_161_04 INDEX3817.35
YTEXPTS_SIGNATURE_02T_EXP_OP_RECORD_SIGNATURE_236PAR_2014_02_18TABLE PARTITION3476.69
YTEXPTS_IDX_YTEXPIDX_EXP_TAKING_STATUS_161_02 INDEX2825.44
YTEXPTS_SIGNATURE_02T_EXP_OP_RECORD_SIGNATURE_170PAR_2014_02_18TABLE PARTITION2675.15


Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
YTEXPTS_IDX_CONTAINERIDX3_EXP_CONTAINER_227PAR_2014_02_18INDEX PARTITION620.00
YTEXPTS_IDX_CONTAINERIDX3_EXP_CONTAINER_208PAR_2014_02_19INDEX PARTITION516.67
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_161_02 INDEX413.33
YTEXPTS_IDX_CONTAINERIDX1_EXP_CONTAINER_208PAR_2014_02_19INDEX PARTITION26.67
YTEXPTS_IDX_CONTAINERIDX1_EXP_CONTAINER_219PAR_2014_02_19INDEX PARTITION13.33


Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
YTEXPTS_IDX_CONTAINERIDX1_EXP_CONTAINER_208PAR_2014_02_19INDEX PARTITION1558.53
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_208 TABLE1176.44
YTEXPTS_IDX_CONTAINERIDX1_EXP_CONTAINER_165PAR_2014_02_19INDEX PARTITION925.06
YTEXPTS_IDX_CONTAINERIDX3_EXP_CONTAINER_208PAR_2014_02_19INDEX PARTITION824.51
YTEXPTS_IDX_YTEXPUK_EXP_DELIVERY_STATUS_208 INDEX784.29


Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control1130.000 21
dc_files9540.000 0477
dc_global_oids2470.400 043
dc_histogram_data14,5174.700 025,356
dc_histogram_defs19,0587.470 029,267
dc_object_grants250.000 016
dc_objects251,3530.120 972,639
dc_profiles2,3430.000 01
dc_rollback_segments14,4280.000 067
dc_segments81,72150.820 2,756153,103
dc_sequences714.290 77
dc_tablespaces3,944,7240.000 0344
dc_users415,9440.000 01,176
global database name5,4600.000 01
outstanding_alerts2,0550.100 5341
sch_lj_oids90.000 012



Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS3,3810.030 00
BODY1,3830.002,5310.0410
CLUSTER100.00100.0000
DBLINK5,0540.000 00
EDITION1,2410.002,4540.0000
INDEX2,881,264-0.0011,8332.732470
LOCATION520.00520.0000
QUEUE1390.001,6520.0000
RULESET0 50.0000
SCHEMA2,8810.000 00
SQL AREA1,300,2470.0216,913,6580.065,2080
SQL AREA BUILD6,00514.150 00
SQL AREA STATS5,42980.145,42980.1400
SUBSCRIPTION90.00147.1410
TABLE/PROCEDURE1,021,688-0.00226,1320.254390
TRIGGER2280.003040.0000



Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache151,040.00151,040.00151,040.00153,600.000SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target61,440.0061,440.0061,440.0061,440.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target0.000.000.000.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool3,584.003,584.003,584.003,584.000STA/
large pool3,584.003,584.003,584.003,584.000STA/
shared pool8,704.008,704.006,144.008,704.000GRO/IMM
streams pool512.00512.00512.00512.000STA/


Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther1,410.56 3.054.314444463463
Freeable153.810.000.831.258 185185
SQL8.781.030.020.01013434426
PL/SQL1.850.980.000.0200461461
EOther1,518.77 2.693.934545565565
Freeable95.560.001.031.708 9393
SQL7.752.820.010.0103535527
PL/SQL1.920.890.000.0200563563


Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers158,376,919,040 
Fixed Size2,265,864 
Redo Buffers112,762,880 
Variable Size55,297,707,256 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory3,584.003,584.000.00
largefree memory3,583.633,583.630.00
sharedASH buffers160.00160.000.00
sharedCheckpoint queue390.66390.660.00
sharedFileOpenBlock486.40486.400.00
sharedKGLH01,107.601,147.623.61
sharedKGLHD126.54122.96-2.83
sharedKQR M PO 89.77 
sharedPRTMV94.8898.183.48
sharedSQLA3,005.932,915.45-3.01
shareddb_block_hash_buckets1,424.001,424.000.00
sharedfree memory442.92459.933.84
sharedobject queue461.54461.540.00
streamsfree memory511.37511.370.00
 buffer_cache151,040.00151,040.000.00
 fixed_sga2.162.160.00
 log_buffer107.54107.540.00


Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonCPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0203 15:50:191.000.000.00
QMON Coordinator0203 15:50:080.120.000.00


Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

RuleEvalsNo-SQL Eval%SQL ExecsCPU(s)Ela(s)Eval /SecSQL per EvalEla(s) per EvalCPU(s) per EvalReloads
SYS.ALERT_QUE_R 50.0000.000.000.000.000.000.000


Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(13069) 50100.000.000.030.000.002.41
SYS.AQ$_ALERT_QT_E(13068) 500.000.000.000.000.000.00
SYSMAN.MGMT_TASK_Q(77312) 96960.000.000.020.070.000.00


Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
SYS.ALERT_QUE(13069) 0.000.000.01 
SYS.AQ$_ALERT_QT_E(13068) 0.000.000.00 
SYSMAN.MGMT_TASK_Q(77312) 0.020.020.000.00


Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE 000   
MYSQLDB87_3938_DBQUERY4(22)/SYS.ALERT_QUE 5050.000.000.00
NGMYSQLDB87_3872_IDBQUERY4(41)/SYS.ALERT_QUE 5050.000.000.00


Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total ConnectionsAvg Active ConnectionsAvg Total Shared SrvrsAvg Active Shared SrvrsAvg Total DispatchersAvg Active Dispatchers
001010


Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per SecDisp Queue Per SecServer Msgs/SecServer KB/SecCommon Queue TotalDisp Queue TotalServer Total MsgsServer Total(KB)
0000.000000


Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
6,3250.00100.000.000.00


Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0000.006,3250.00100.0000 


Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/u01/app/oracle/admin/dbquery/adump  
audit_trailDB  
compatible11.2.0.4.0  
control_files+DATA_DG/dbquery/control01.ctl, +DATA_DG/dbquery/control02.ctl  
db_block_size8192  
db_cache_size158376919040  
db_domain    
db_files5000  
db_namedbquery  
db_recovery_file_dest+DATA_DG  
db_recovery_file_dest_size1099511627776  
diagnostic_dest/u01/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=dbquery4XDB)  
java_pool_size3758096384  
large_pool_size3758096384  
local_listener(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.193.87)(PORT=1521))  
open_cursors300  
pga_aggregate_target64424509440  
plsql_warningsDISABLE:ALL  
processes2000  
remote_login_passwordfileEXCLUSIVE  
sga_max_size214748364800  
sga_target0  
shared_pool_size9126805504  
spfile+DATA_DG/dbquery/spfiledbquery.ora  
streams_pool_size536870912  
undo_tablespaceUNDOTBS1  


Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files+DATA_DG/dbquery/control01.ctl  
+DATA_DG/dbquery/control02.ctl  


Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report