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:295918-Feb-14 09:00:35783 2.7
End Snap:296018-Feb-14 10:00:37788 2.7
Elapsed:  60.03 (mins)  
DB Time:  39.55 (mins)  

Report Summary

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 0.7 0.0 0.00 0.00
DB CPU(s): 0.6 0.0 0.00 0.00
Redo size (bytes): 644,545.7 6,283.5  
Logical read (blocks): 177,754.9 1,732.9  
Block changes: 3,710.9 36.2  
Physical read (blocks): 19.1 0.2  
Physical write (blocks): 529.3 5.2  
Read IO requests: 19.1 0.2  
Write IO requests: 364.1 3.6  
Read IO (MB): 0.2 0.0  
Write IO (MB): 4.1 0.0  
User calls: 831.7 8.1  
Parses (SQL): 357.2 3.5  
Hard parses (SQL): 0.7 0.0  
SQL Work Area (MB): 0.1 0.0  
Logons: 0.6 0.0  
Executes (SQL): 373.7 3.6  
Rollbacks: 44.3 0.4  
Transactions: 102.6   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.99In-memory Sort %: 100.00
Library Hit %: 99.61Soft Parse %: 99.81
Execute to Parse %: 4.41Latch Hit %: 99.78
Parse CPU to Parse Elapsd %: 37.14% Non-Parse CPU: 99.39

Top 10 Foreground Events by Total Wait Time

EventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Class
DB CPU 2135.3 90.0 
db file sequential read52,901141.836.0User I/O
log file sync206,791135.915.7Commit
SQL*Net break/reset to client252,60263.702.7Application
enq: TX - allocate ITL entry149.1650.4Configuration
enq: TX - row lock contention245.8240.2Application
SQL*Net message to client1,791,8903.50.1Network
control file sequential read12,8531.50.1System I/O
undo segment extension60.47.0Configuration
recovery area: computing obsolete files1.3318.0Other

Wait Classes by Total Wait Time

Wait ClassWaitsTotal Wait Time (sec)Avg Wait (ms)% DB timeAvg Active Sessions
DB CPU 2,135 90.00.6
System I/O2,881,61622909.70.1
User I/O58,56514326.00.0
Commit206,79313615.70.0
Application252,6266902.90.0
Configuration1611060.40.0
Other11,57540.20.0
Network1,798,27040.20.0
Concurrency84133.10.0

Host CPU

CPUsCoresSocketsLoad Average BeginLoad Average End%User%System%WIO%Idle
80 40 4 1.52 1.67 0.8 0.2 0.1 99.0

Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
0.9 88.3 0.0

IO Profile

Read+Write Per SecondRead per SecondWrite Per Second
Total Requests: 464.2 26.4 437.8
Database Requests: 383.2 19.1 364.1
Optimized Requests: 0.0 0.0 0.0
Redo Requests: 72.1 0.7 71.4
Total (MB): 6.6 1.0 5.6
Database (MB): 4.3 0.2 4.1
Optimized Total (MB): 0.0 0.0 0.0
Redo (MB): 1.3 0.7 0.7
Database (blocks): 548.3 19.1 529.3
Via Buffer Cache (blocks): 542.8 14.6 528.3
Direct (blocks): 5.5 4.5 1.0

Memory Statistics

BeginEnd
Host Mem (MB): 387,577.0 387,577.0
SGA use (MB): 203,885.7 203,885.7
PGA use (MB): 2,818.7 2,764.3
% Host Mem used for SGA+PGA: 53.33 53.32

Cache Sizes

BeginEnd
Buffer Cache: 152,064M 152,064MStd Block Size: 8K
Shared Pool Size: 6,739M 6,739MLog Buffer: 110,120K

Shared Pool Statistics

BeginEnd
Memory Usage %: 94.02 93.99
% SQL with executions>1: 97.19 96.90
% Memory for SQL w/exec>1: 97.77 97.13

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU2,135.3289.99
sql execute elapsed time1,826.8276.99
parse time elapsed54.552.30
hard parse elapsed time8.430.36
hard parse (sharing criteria) elapsed time6.260.26
hard parse (bind mismatch) elapsed time3.900.16
connection management call elapsed time2.240.09
PL/SQL execution elapsed time1.310.06
inbound PL/SQL rpc elapsed time1.190.05
RMAN cpu time (backup/restore)0.040.00
PL/SQL compilation elapsed time0.020.00
repeated bind elapsed time0.010.00
DB time2,372.75 
background elapsed time726.53 
background cpu time426.66 


Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME290,011 
IDLE_TIME28,474,119 
IOWAIT_TIME23,825 
NICE_TIME0 
SYS_TIME56,879 
USER_TIME228,293 
LOAD22
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
18-Feb 09:00:351.52     
18-Feb 10:00:371.671.010.790.2098.990.08


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  2,135 89.99
User I/O54,328014235.98
Commit206,791013615.73
Application252,62606902.93
Configuration8076101200.41
Network1,794,6020400.15
System I/O12,9540200.07
Other2254130.03
Concurrency6680000.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
db file sequential read52,901014230.145.98
log file sync206,791013610.565.73
SQL*Net break/reset to client252,60206400.682.68
enq: TX - allocate ITL entry144396500.000.38
enq: TX - row lock contention24062400.000.24
SQL*Net message to client1,791,8900404.850.15
control file sequential read12,8530200.030.07
undo segment extension6092070.000.02
recovery area: computing obsolete files1003180.000.01
recovery area: computing backed up files1002830.000.01
Disk file operations I/O1,4240000.000.00
log file switch completion500150.000.00
control file single write670010.000.00
recovery area: computing dropped files100710.000.00
buffer busy waits3000000.000.00
SQL*Net more data from client2,6920000.010.00
latch: In memory undo latch1460000.000.00
db file scattered read300110.000.00
enq: TX - index contention370010.000.00
cursor: pin S50040.000.00
cursor: pin S wait on X200100.000.00
library cache: mutex X1380000.000.00
latch free100020.000.00
log file switch (private strand flush incomplete)100110.000.00
latch: object queue header operation1220000.000.00
control file parallel write340000.000.00
ADR block file read360000.000.00
CSS initialization10040.000.00
latch: shared pool120000.000.00
latch: redo allocation210000.000.00
latch: cache buffers chains220000.000.00
SQL*Net message from client1,791,88404,300,77524004.85 
jobq slave wait7,8491003,9305010.02 
KSV master wait220000.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
db file parallel write1,307,690018303.5425.13
log file parallel write239,29803200.654.41
log file sequential read1,2790860.001.09
os thread startup13603200.000.37
control file sequential read9,9880200.030.32
db file async I/O submit1,307,6890203.540.32
ASM file metadata operation1,8900210.010.23
reliable message6630110.000.13
LGWR wait for redo copy5,9430100.020.10
control file parallel write2,7590000.010.06
Data file init write1620020.000.04
db file sequential read5340010.000.04
latch free6160000.000.02
RMAN backup & recovery I/O60070.000.01
Disk file operations I/O3,5070000.010.01
rdbms ipc reply70050.000.01
CSS initialization40060.000.00
asynch descriptor resize1,910100000.010.00
kfk: async disk IO280010.000.00
latch: object queue header operation1310000.000.00
enq: CF - contention40030.000.00
Log archive I/O70020.000.00
latch: redo writing810000.000.00
enq: CI - contention20040.000.00
ADR block file read160010.000.00
CSS operation: action40020.000.00
latch: call allocation270000.000.00
log file single write140000.000.00
SQL*Net message to client3,6600000.010.00
latch: messages430000.000.00
latch: redo allocation270000.000.00
db file single write70000.000.00
direct path write290000.000.00
CSS operation: query240000.000.00
buffer busy waits300000.000.00
log file sync20010.000.00
rdbms ipc message269,1521192,9463450.73 
Space Manager: slave idle wait11,8373636,01430420.03 
EMON slave idle wait3,60010018,00350010.01 
class slave wait1,23007,20258560.00 
DIAG idle wait7,1751007,18210010.02 
wait for unread message on broadcast channel3,5981003,60210010.01 
shared server idle wait1201003,601300120.00 
Streams AQ: emn coordinator idle wait3601003,601100030.00 
dispatcher timer601003,601600130.00 
ASM background timer97403,60036960.00 
smon timer55003,59965440.00 
pmon timer1,1981003,59830030.00 
Streams AQ: qmn slave idle wait12803,585280090.00 
Streams AQ: qmn coordinator idle wait256503,585140040.00 
Streams AQ: waiting for time management or cleanup tasks15672,2811520700.00 
SQL*Net message from client5,43401830.01 
KSV master wait5030120.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 read5298.1  1.9    
ADR block file write10100.0       
ADR file lock12100.0       
ARCH wait for archivelog lock7100.0       
ASM file metadata operation189094.81.7.8.4.61.1.6 
CSS initialization5  20.080.0    
CSS operation: action520.080.0      
CSS operation: query30100.0       
Data file init write16245.719.122.211.71.2   
Disk file operations I/O4930100.0.0.0     
LGWR wait for redo copy594199.0.8.2.0    
Log archive I/O728.642.928.6     
RMAN backup & recovery I/O650.0  33.3 16.7  
SQL*Net break/reset to client252.6K98.41.2.2.1.0.0.0 
SQL*Net message to client1795.3K100.0.0      
SQL*Net more data from client2695100.0       
SQL*Net more data to client24100.0       
asynch descriptor resize1910100.0       
buffer busy waits33094.83.91.2     
buffer deadlock10100.0       
control file parallel write279499.8.2      
control file sequential read22.8K99.0.2.6.1.1.0.0 
control file single write6741.852.26.0     
cursor: mutex S3100.0       
cursor: mutex X2100.0       
cursor: pin S560.0   40.0   
cursor: pin S wait on X2    100.0   
db file async I/O submit1307.6K100.0       
db file parallel write1307.6K100.0.0.0.0.0 .0 
db file scattered read333.3   33.333.3  
db file sequential read53.4K55.012.67.420.83.11.0.1 
db file single write7100.0       
direct path write29100.0       
enq: CF - contention425.0 75.0     
enq: CI - contention2  50.050.0    
enq: TX - allocate ITL entry14    7.1 92.9 
enq: TX - index contention3781.113.55.4     
enq: TX - row lock contention24 4.24.2  4.283.34.2
kfk: async disk IO2892.9 7.1     
latch free62597.61.9 .3 .2  
latch: In memory undo latch14796.62.7.7     
latch: active service list1100.0       
latch: cache buffers chains24100.0       
latch: cache buffers lru chain16100.0       
latch: call allocation2796.3 3.7     
latch: checkpoint queue latch5100.0       
latch: enqueue hash chains1100.0       
latch: messages45100.0       
latch: object queue header operation25399.2.8      
latch: redo allocation48100.0       
latch: redo writing81100.0       
latch: row cache objects3100.0       
latch: shared pool1392.37.7      
library cache: mutex X13998.6  .7.7   
log file parallel write239.3K99.7.2.0.0.0.0  
log file sequential read127933.319.420.012.48.43.82.8 
log file single write14100.0       
log file switch (private strand flush incomplete)1    100.0   
log file switch completion5   20.040.040.0  
log file sync206.8K94.84.7.4.1.0.0  
os thread startup136    11.089.0  
rdbms ipc reply7  28.657.114.3   
recovery area: computing backed up files1      100.0 
recovery area: computing dropped files1      100.0 
recovery area: computing obsolete files1      100.0 
reliable message66334.459.41.73.9.5.2  
undo segment extension6051.7   31.713.33.3 
ASM background timer97415.02.31.42.21.2.71.575.7
DIAG idle wait7175      100.0 
EMON slave idle wait3604       100.0
KSV master wait52588.45.71.7.81.1.41.9 
SQL*Net message from client1797K48.420.99.44.53.01.54.48.0
Space Manager: slave idle wait11.8K2.1.2.3.61.31.316.677.6
Streams AQ: emn coordinator idle wait360       100.0
Streams AQ: qmn coordinator idle wait25650.0      50.0
Streams AQ: qmn slave idle wait128       100.0
Streams AQ: waiting for time management or cleanup tasks1533.3     33.333.3
class slave wait123034.32.814.34.14.011.11.228.3
dispatcher timer60       100.0
jobq slave wait7846.0     100.0 
pmon timer1199       100.0
rdbms ipc message269.1K10.37.014.331.214.55.69.27.9
shared server idle wait120       100.0
smon timer5504.9.2 1.52.92.716.271.6
wait for unread message on broadcast channel3598      100.0 


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 operation1199.4.4.2     
SQL*Net break/reset to client1100.0   .0   
control file sequential read1100.0.0      
db file parallel write1100.0.0      
db file sequential read5399.9.1.0.0    
enq: TX - allocate ITL entry137.1 7.17.121.457.1  
enq: TX - row lock contention2112.516.725.025.04.212.54.2 
log file sequential read3697.21.31.0.5    
recovery area: computing backed up files1    100.0   
recovery area: computing dropped files1  100.0     
recovery area: computing obsolete files1    100.0   
undo segment extension296.73.3      


Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

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)
dbquery1,3391,11451122,142
SYS$USERS1,0321,0202517,692
SYS$BACKGROUND001668
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 5170813257800017197573
SYS$USERS 26441090000749720
SYS$BACKGROUND 4212117230000


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
613.641,2410.4925.8699.450.004c26ux3t5cz2x JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
158.811401.136.6999.690.008xq7a5u95h5ab JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
101.98801.274.3099.830.00523j4678qy5a2 JDBC Thin Client select count(id) from T_EXP_OP...
91.17741.233.8498.730.001936x2bzxvr37 JDBC Thin Client SELECT WAYBILL_NO, EXP_TYPE, W...
46.53840.551.962.8497.95fpvzbqsarvfrn JDBC Thin Client select id, waybill_no, exp_typ...
14.50210.690.612.8897.94cs04nczkzvwf1 JDBC Thin Client select id, waybill_no, exp_typ...
13.9697,7440.000.5944.350.00fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
12.78148,6300.000.5439.880.00c2gkrw5buc9wb JDBC Thin Client select sysdate from DUAL
11.33  0.4860.19 8wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
9.417430.010.4057.282.91fr956v842tq26 JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...


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
610.251,2410.4928.58613.6499.450.004c26ux3t5cz2x JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
158.331401.137.41158.8199.690.008xq7a5u95h5ab JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
101.80801.274.77101.9899.830.00523j4678qy5a2 JDBC Thin Client select count(id) from T_EXP_OP...
90.02741.224.2291.1798.730.001936x2bzxvr37 JDBC Thin Client SELECT WAYBILL_NO, EXP_TYPE, W...
6.82  0.3211.3360.19 8wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
6.1997,7440.000.2913.9644.350.00fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
5.60770.070.265.6898.630.00btrdhh3maycfw JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
5.397430.010.259.4157.282.91fr956v842tq26 JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...
5.10148,6300.000.2412.7839.880.00c2gkrw5buc9wb JDBC Thin Client select sysdate from DUAL
3.25  0.156.5949.33 d7khudn7c54n6   INSERT INTO T_EXP_DELIVERY_STA...


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
45.58840.5431.9646.532.8497.95fpvzbqsarvfrn JDBC Thin Client select id, waybill_no, exp_typ...
14.20210.689.9614.502.8897.94cs04nczkzvwf1 JDBC Thin Client select id, waybill_no, exp_typ...
5.58100.563.915.733.4797.45cpp62mu3faspc JDBC Thin Client select id, waybill_no, exp_typ...
3.5650.712.493.632.9497.914u3f35csp4hb4 JDBC Thin Client select id, waybill_no, exp_typ...
3.25410.082.283.8319.0684.743bykv3f2040nd JDBC Thin Client select id from T_EXP_OP_RECORD...
2.7650.551.932.812.8897.91b3ad53x79qa2p JDBC Thin Client select id, waybill_no, exp_typ...
0.491,1780.000.342.6869.9818.10b7a003qmdc7u5 JDBC Thin Client select id, waybill_no, exp_typ...
0.277430.000.199.4157.282.91fr956v842tq26 JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...
0.179,9730.000.124.3752.653.970v9u1u536y9b4 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
0.111,2050.000.082.3678.964.64f5qcxg530ahn4 JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...


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
333,081,6031,241268,397.7552.03613.6499.404c26ux3t5cz2x JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
78,600,275140561,430.5412.28158.8199.708xq7a5u95h5ab JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
48,488,67680606,108.457.57101.9899.80523j4678qy5a2 JDBC Thin Client select count(id) from T_EXP_OP...
43,907,35674593,342.656.8691.1798.701936x2bzxvr37 JDBC Thin Client SELECT WAYBILL_NO, EXP_TYPE, W...
2,569,7177733,372.950.405.6898.60btrdhh3maycfw JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
1,133,1547714,716.290.182.63970cff0jg7qb802n JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
738,4293421,718.500.121.6397.80b8na8z00q7bdv JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
659,4792625,364.580.101.799907fsh2z0q1rj6v JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
418,222743562.880.079.4157.32.9fr956v842tq26 JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...
322,8001,178274.020.052.687018.1b7a003qmdc7u5 JDBC Thin Client select id, waybill_no, exp_typ...


Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
7,0938484.4410.3146.532.8497.95fpvzbqsarvfrn JDBC Thin Client select id, waybill_no, exp_typ...
3,4644184.495.043.8319.0684.743bykv3f2040nd JDBC Thin Client select id from T_EXP_OP_RECORD...
2,28721108.903.3314.502.8897.94cs04nczkzvwf1 JDBC Thin Client select id, waybill_no, exp_typ...
1,10110110.101.605.733.4797.45cpp62mu3faspc JDBC Thin Client select id, waybill_no, exp_typ...
5945118.800.863.632.9497.914u3f35csp4hb4 JDBC Thin Client select id, waybill_no, exp_typ...
466593.200.682.812.8897.91b3ad53x79qa2p JDBC Thin Client select id, waybill_no, exp_typ...
2467430.330.369.4157.282.91fr956v842tq26 JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...
1639,9730.020.244.3752.653.970v9u1u536y9b4 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
1041,2050.090.152.3678.964.64f5qcxg530ahn4 JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...
851,2540.070.122.2677.874.009z2byt2r9xsns JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_1...


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
7,0937,0938484.440.0010.32fpvzbqsarvfrn JDBC Thin Client select id, waybill_no, exp_typ...
3,4643,4644184.490.005.043bykv3f2040nd JDBC Thin Client select id from T_EXP_OP_RECORD...
2,2872,28721108.900.003.33cs04nczkzvwf1 JDBC Thin Client select id, waybill_no, exp_typ...
2,2862,2866038.100.003.336gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
5945945118.800.000.864u3f35csp4hb4 JDBC Thin Client select id, waybill_no, exp_typ...
466466593.200.000.68b3ad53x79qa2p JDBC Thin Client select id, waybill_no, exp_typ...
1201201012.000.000.17cpp62mu3faspc JDBC Thin Client select id, waybill_no, exp_typ...
74741,1780.060.000.11b7a003qmdc7u5 JDBC Thin Client select id, waybill_no, exp_typ...
73738300.090.000.114pj9j8bkd2hpr JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...
55559,9730.010.000.080v9u1u536y9b4 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...


Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
148,630148,6301.0012.7839.90c2gkrw5buc9wb JDBC Thin Client select sysdate from DUAL
97,7442,3720.0213.9644.30fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
41,83641,7521.002.9330.801bqk0pmqg1vq6 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
29,11129,1111.002.7471.502jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
15,52315,4370.991.1231.50d9pmgnn15y65k JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
12,09811,9950.991.2936.2.1acwagtju00dpq JDBC Thin Client SELECT ID, DEST_OUT_SCAN_TIME,...
12,02612,0271.004.3847.8.4cj9mymcb3d5q0 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
11,20611,1911.001.1133.604cyus4bbq04kb JDBC Thin Client SELECT ID, DEST_OUT_SCAN_TIME,...
11,19311,1931.003.3444.9.18nb3scp8prkc4 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
10,92710,8570.990.7831.609qux0wxcavh9p JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...


Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
148,460148,63011.54c2gkrw5buc9wb JDBC Thin Client select sysdate from DUAL
97,74497,7447.60fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
41,80841,8363.251bqk0pmqg1vq6 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
29,11129,1112.262jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
18,784 1.468wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
15,897 1.24d7khudn7c54n6   INSERT INTO T_EXP_DELIVERY_STA...
15,52115,5231.21d9pmgnn15y65k JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
12,09812,0980.94acwagtju00dpq JDBC Thin Client SELECT ID, DEST_OUT_SCAN_TIME,...
12,02612,0260.93cj9mymcb3d5q0 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
11,20511,2060.874cyus4bbq04kb JDBC Thin Client SELECT ID, DEST_OUT_SCAN_TIME,...


Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
31,591,888 0.45c2mffjag542y2   INSERT INTO T_EXP_OP_RECORD_CO...
21,712,080 0.31cak25du5pyzcp   INSERT INTO T_EXP_DELIVERY_STA...
21,450,744 0.308wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
20,865,352 0.301864ycgvgvyam   INSERT INTO T_EXP_DELIVERY_STA...
20,711,528 0.29d7khudn7c54n6   INSERT INTO T_EXP_DELIVERY_STA...
19,334,488 0.27du2aujnxqm6fv   INSERT INTO T_EXP_OP_RECORD_CO...
18,394,120 0.267g04ytfkrfcat   INSERT INTO T_EXP_OP_RECORD_CO...
17,331,848 0.25a6nwkg0nu1grj   INSERT INTO T_EXP_DELIVERY_STA...
17,112,888 0.242ayhh3ddjwg7y   INSERT INTO T_EXP_DELIVERY_STA...
16,533,328 0.2396bau1p59dh0y   INSERT INTO T_EXP_DELIVERY_STA...
16,237,536 0.2309qtbd90zbmkv   INSERT INTO T_EXP_DELIVERY_STA...
15,775,560 0.22gf25wm6hncp21   INSERT INTO T_EXP_DELIVERY_STA...
15,686,504 0.229pxk46nsp5snk   INSERT INTO T_EXP_OP_RECORD_CO...
14,787,000 0.2186n8k008j5fg5   INSERT INTO T_EXP_DELIVERY_STA...
14,758,416 0.217ymaac33ytc92   INSERT INTO T_EXP_DELIVERY_STA...
14,665,032 0.214zg34tvzdpa1z   INSERT INTO T_EXP_OP_RECORD_CO...
14,175,072 0.204sbkzmudwcd68   INSERT INTO T_EXP_DELIVERY_STA...
13,664,312 0.197zdvpgv74gvqd   INSERT INTO T_EXP_DELIVERY_STA...
13,429,208 0.191crrgmqhtap69   INSERT INTO T_EXP_DELIVERY_STA...
13,250,992 0.198p3fp2jguk11n   INSERT INTO T_EXP_DELIVERY_STA...
13,142,0159240.1950ud38fypmwtd JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
13,060,160 0.1809c07pa97cdkj   INSERT INTO T_EXP_OP_RECORD_CO...
13,028,320 0.187y9zax9taks2q   INSERT INTO T_EXP_DELIVERY_STA...
12,744,584 0.188tp9p80p00b0u   INSERT INTO T_EXP_DELIVERY_STA...
12,729,4237030.18ba3md9ywn7phu JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
12,582,520 0.185ntqv80pf9q0n   INSERT INTO T_EXP_DELIVERY_STA...
11,901,728 0.17c5zm115aa6kwx   INSERT INTO T_EXP_DELIVERY_STA...
11,800,368 0.17fqws7ksfz8mv0   INSERT INTO T_EXP_DELIVERY_STA...
11,557,208 0.164ahp03j8z3u1g   INSERT INTO T_EXP_DELIVERY_STA...
11,310,104 0.1685warqm7hf8f2   INSERT INTO T_EXP_DELIVERY_STA...
10,714,488 0.155dzr1p10ydh03   INSERT INTO T_EXP_DELIVERY_STA...
9,077,352 0.13733xjzj58vkx0   INSERT INTO T_EXP_DELIVERY_STA...
2,485,9375430.04gyx912cqtkd9s JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
2,290,15397,7440.03fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
2,071,6125670.039w95phvbrjw3x JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_1...
1,478,4019,9730.020v9u1u536y9b4 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...


Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
560 c2mffjag542y2   INSERT INTO T_EXP_OP_RECORD_CO...
420 cak25du5pyzcp   INSERT INTO T_EXP_DELIVERY_STA...
400 1864ycgvgvyam   INSERT INTO T_EXP_DELIVERY_STA...
397 d7khudn7c54n6   INSERT INTO T_EXP_DELIVERY_STA...
350 7g04ytfkrfcat   INSERT INTO T_EXP_OP_RECORD_CO...
331 2ayhh3ddjwg7y   INSERT INTO T_EXP_DELIVERY_STA...
331 a6nwkg0nu1grj   INSERT INTO T_EXP_DELIVERY_STA...
317 96bau1p59dh0y   INSERT INTO T_EXP_DELIVERY_STA...
311 09qtbd90zbmkv   INSERT INTO T_EXP_DELIVERY_STA...
304 du2aujnxqm6fv   INSERT INTO T_EXP_OP_RECORD_CO...
304 gf25wm6hncp21   INSERT INTO T_EXP_DELIVERY_STA...
295 8wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
293 86n8k008j5fg5   INSERT INTO T_EXP_DELIVERY_STA...
285 7ymaac33ytc92   INSERT INTO T_EXP_DELIVERY_STA...
275 5ntqv80pf9q0n   INSERT INTO T_EXP_DELIVERY_STA...
272 4sbkzmudwcd68   INSERT INTO T_EXP_DELIVERY_STA...
269 9pxk46nsp5snk   INSERT INTO T_EXP_OP_RECORD_CO...
264 7zdvpgv74gvqd   INSERT INTO T_EXP_DELIVERY_STA...
262703ba3md9ywn7phu JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
259 733xjzj58vkx0   INSERT INTO T_EXP_DELIVERY_STA...
258 1crrgmqhtap69   INSERT INTO T_EXP_DELIVERY_STA...
255 8p3fp2jguk11n   INSERT INTO T_EXP_DELIVERY_STA...
251 8tp9p80p00b0u   INSERT INTO T_EXP_DELIVERY_STA...
249 4zg34tvzdpa1z   INSERT INTO T_EXP_OP_RECORD_CO...
249 7y9zax9taks2q   INSERT INTO T_EXP_DELIVERY_STA...
235 5dzr1p10ydh03   INSERT INTO T_EXP_DELIVERY_STA...
234 fqws7ksfz8mv0   INSERT INTO T_EXP_DELIVERY_STA...
229 c5zm115aa6kwx   INSERT INTO T_EXP_DELIVERY_STA...
222 4ahp03j8z3u1g   INSERT INTO T_EXP_DELIVERY_STA...
220 09c07pa97cdkj   INSERT INTO T_EXP_OP_RECORD_CO...
217 85warqm7hf8f2   INSERT INTO T_EXP_DELIVERY_STA...
17592450ud38fypmwtd JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
57543gyx912cqtkd9s JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
5597,744fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
359,9730v9u1u536y9b4 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...


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 )
0v9u1u536y9b4INSERT INTO T_EXP_DELIVERY_STATUS_215 (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 )
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 )
1936x2bzxvr37SELECT WAYBILL_NO, EXP_TYPE, WEIGH_WEIGHT, INPUT_WEIGHT, VOLUME_WEIGHT, TAKING_WEIGHT, PKG_QTY, CREATE_TIME FROM T_EXP_OP_RECORD_CONTAINER_165 WHERE OP_CODE=:1 AND CONTAINER_NO=:2 AND STATUS>'0' AND ORG_CODE=:3 AND CREATE_TIME>=:4 -3 AND CREATE_TIME<=:5 +2
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 )
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 )
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#
3bykv3f2040ndselect id from T_EXP_OP_RECORD_HANDON_203 where status <> 0 and ID=:1
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 )
4c26ux3t5cz2xSELECT t.id, t.waybill_no, t.aux_op_code, t.op_code, t.weigh_weight, t.input_weight, t.volume_weight, t.container_no, t.status, t.taking_weight FROM ytexp.t_exp_op_record_container_161 t WHERE t.op_code=111 AND t.status>'0' AND t.container_no=:1 AND t.org_code=:2 AND t.create_time>=:3 -3 AND t.create_time<=:4 +2
4cyus4bbq04kbSELECT 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 FROM T_EXP_DELIVERY_STATUS_219 WHERE WAYBILL_NO = :1
4pj9j8bkd2hprUPDATE T_EXP_DELIVERY_STATUS_215 SET DES_ORG_SCAN_TIME = :1 , EXP_TYPE = :2 , STATUS = CASE WHEN STATUS > :3 THEN STATUS ELSE :4 END , DES_ORG_CODE = :5 WHERE WAYBILL_NO = :6
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 )
4u3f35csp4hb4 select 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, to_char(upload_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as upload_time , op_code, aux_op_code, route_code, aux_route_code, status, transfer_status, to_char(create_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as create_time, create_user_code, create_user_name, create_org_code, create_terminal, device_type, remark, ref_id, to_char(modify_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as 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, to_char(out_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as out_time, fee_weight, pkg_pcs, org_type, query_flag from T_EXP_OP_RECORD_ CONTAINER_194 where status <> 0 and ID=:1
4zg34tvzdpa1z INSERT INTO T_EXP_OP_RECORD_CONTAINER_178 (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 )
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 )
523j4678qy5a2select count(id) from T_EXP_OP_RECORD_CONTAINER_165 WHERE OP_CODE=:1 AND CONTAINER_NO=:2 AND STATUS>'0' AND ORG_CODE=:3 AND CREATE_TIME>=:4 -3 AND CREATE_TIME<=:5 +2
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 )
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 )
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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 )
7fsh2z0q1rj6vSELECT t.id, t.waybill_no, t.aux_op_code, t.op_code, t.weigh_weight, t.input_weight, t.volume_weight, t.container_no, t.status, t.taking_weight FROM ytexp.t_exp_op_record_container_208 t WHERE t.op_code=111 AND t.status>'0' AND t.container_no=:1 AND t.org_code=:2 AND t.create_time>=:3 -3 AND t.create_time<=:4 +2
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 )
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 )
8nb3scp8prkc4DELETE FROM T_EXP_DELIVERY_STATUS_219 WHERE WAYBILL_NO = :1
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 )
8tp9p80p00b0uINSERT INTO T_EXP_DELIVERY_STATUS_193 (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 )
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 )
8xq7a5u95h5abSELECT t.id, t.waybill_no, t.aux_op_code, t.op_code, t.weigh_weight, t.input_weight, t.volume_weight, t.container_no, t.status, t.taking_weight FROM ytexp.t_exp_op_record_container_165 t WHERE t.op_code=111 AND t.status>'0' AND t.container_no=:1 AND t.org_code=:2 AND t.create_time>=:3 -3 AND t.create_time<=:4 +2
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 )
9pxk46nsp5snk INSERT INTO T_EXP_OP_RECORD_CONTAINER_238 (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 )
9qux0wxcavh9pSELECT WAYBILL_NO FROM T_EXP_DELIVERY_STATUS_215 WHERE WAYBILL_NO = :1
9w95phvbrjw3xUPDATE T_EXP_DELIVERY_STATUS_161 SET STATUS = CASE WHEN STATUS > :1 THEN STATUS ELSE :2 END , DES_ORG_CODE =:3 , DELIVERY_EMP_CODE = :4 , DELIVERY_TIME =:5 WHERE WAYBILL_NO =:6
9z2byt2r9xsnsUPDATE T_EXP_DELIVERY_STATUS_175 SET DES_ORG_SCAN_TIME = :1 , EXP_TYPE = :2 , STATUS = CASE WHEN STATUS > :3 THEN STATUS ELSE :4 END , DES_ORG_CODE = :5 WHERE WAYBILL_NO = :6
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 )
acwagtju00dpqSELECT 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 FROM T_EXP_DELIVERY_STATUS_165 WHERE WAYBILL_NO = :1
b3ad53x79qa2p select 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, to_char(upload_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as upload_time , op_code, aux_op_code, route_code, aux_route_code, status, transfer_status, to_char(create_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as create_time, create_user_code, create_user_name, create_org_code, create_terminal, device_type, remark, ref_id, to_char(modify_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as 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, to_char(out_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as out_time, fee_weight, pkg_pcs, org_type, query_flag from T_EXP_OP_RECORD_ CONTAINER_199 where status <> 0 and ID=:1
b7a003qmdc7u5 select id, waybill_no, exp_type, pkg_qty, emp_code, emp_name, fee_flag, fee_amt, org_code, frequency_no, signoff_type_code, reciever_signoff, amount_collected, amount_agency, delivery_fail_reason_code, delivery_fail_reason, contact, to_char(contact_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as contact_time, contact_result, to_char(upload_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as upload_time , op_code, aux_op_code, route_code, aux_route_code, status, transfer_status, to_char(create_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as create_time, create_user_code, create_user_name, create_org_code, create_terminal, device_type, remark, ref_id, to_char(modify_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as modify_time, modify_user_code, modify_user_name , modify_org_code, modify_terminal, trace_status, fst_success_siginoff, to_char(delivery_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as delivery_time, delivery_id, has_sign_name, has_sign_pic, org_type, query_flag from T_EXP_OP_RECORD_SIGNATURE_174 where waybill_No = :1 an d org_Code = :2 and status <> 0 and op_code = :3 and rownum < 2
b8na8z00q7bdvSELECT t.id, t.waybill_no, t.aux_op_code, t.op_code, t.weigh_weight, t.input_weight, t.volume_weight, t.container_no, t.status, t.taking_weight FROM ytexp.t_exp_op_record_container_169 t WHERE t.op_code=111 AND t.status>'0' AND t.container_no=:1 AND t.org_code=:2 AND t.create_time>=:3 -3 AND t.create_time<=:4 +2
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 )
btrdhh3maycfwSELECT t.id, t.waybill_no, t.aux_op_code, t.op_code, t.weigh_weight, t.input_weight, t.volume_weight, t.container_no, t.status, t.taking_weight FROM ytexp.t_exp_op_record_container_186 t WHERE t.op_code=111 AND t.status>'0' AND t.container_no=:1 AND t.org_code=:2 AND t.create_time>=:3 -3 AND t.create_time<=:4 +2
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 )
cff0jg7qb802nSELECT t.id, t.waybill_no, t.aux_op_code, t.op_code, t.weigh_weight, t.input_weight, t.volume_weight, t.container_no, t.status, t.taking_weight FROM ytexp.t_exp_op_record_container_180 t WHERE t.op_code=111 AND t.status>'0' AND t.container_no=:1 AND t.org_code=:2 AND t.create_time>=:3 -3 AND t.create_time<=:4 +2
cj9mymcb3d5q0DELETE FROM T_EXP_DELIVERY_STATUS_165 WHERE WAYBILL_NO = :1
cpp62mu3faspc select 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, to_char(upload_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as upload_time , op_code, aux_op_code, route_code, aux_route_code, status, transfer_status, to_char(create_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as create_time, create_user_code, create_user_name, create_org_code, create_terminal, device_type, remark, ref_id, to_char(modify_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as 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, to_char(out_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as out_time, fee_weight, pkg_pcs, org_type, query_flag from T_EXP_OP_RECORD_ CONTAINER_237 where status <> 0 and ID=:1
cs04nczkzvwf1 select 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, to_char(upload_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as upload_time , op_code, aux_op_code, route_code, aux_route_code, status, transfer_status, to_char(create_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as create_time, create_user_code, create_user_name, create_org_code, create_terminal, device_type, remark, ref_id, to_char(modify_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as 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, to_char(out_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as out_time, fee_weight, pkg_pcs, org_type, query_flag from T_EXP_OP_RECORD_ CONTAINER_208 where status <> 0 and ID=:1
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
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 )
f5qcxg530ahn4UPDATE T_EXP_DELIVERY_STATUS_202 SET STATUS = CASE WHEN STATUS > :1 THEN STATUS ELSE :2 END , DES_ORG_CODE =:3 , DELIVERY_EMP_CODE = :4 , DELIVERY_TIME =:5 WHERE WAYBILL_NO =:6
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 )
fpvzbqsarvfrn select 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, to_char(upload_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as upload_time , op_code, aux_op_code, route_code, aux_route_code, status, transfer_status, to_char(create_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as create_time, create_user_code, create_user_name, create_org_code, create_terminal, device_type, remark, ref_id, to_char(modify_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as 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, to_char(out_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as out_time, fee_weight, pkg_pcs, org_type, query_flag from T_EXP_OP_RECORD_ CONTAINER_165 where status <> 0 and ID=:1
fqws7ksfz8mv0INSERT INTO T_EXP_DELIVERY_STATUS_227 (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 )
fr956v842tq26UPDATE T_EXP_DELIVERY_STATUS_215 SET STATUS = CASE WHEN STATUS > :1 THEN STATUS ELSE :2 END , DES_ORG_CODE =:3 , DELIVERY_EMP_CODE = :4 , DELIVERY_TIME =:5 WHERE WAYBILL_NO =:6
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 )
gyx912cqtkd9sINSERT INTO T_EXP_OP_RECORD_HANDON_215 (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 )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

StatisticTotalper Secondper Trans
db block changes13,365,6423,710.9036.18
execute count1,345,863373.673.64
logons cumulative1,9780.550.01
opened cursors cumulative1,265,307351.313.42
parse count (total)1,286,528357.203.48
parse time elapsed3,5220.980.01
physical reads68,77219.090.19
physical writes1,906,207529.255.16
redo size2,321,479,696644,545.736,283.51
session cursor cache hits337,94993.830.91
session logical reads640,225,261177,754.931,732.89
user calls2,995,531831.698.11
user commits209,75958.240.57
user rollbacks159,69744.340.43
workarea executions - onepass00.000.00
workarea executions - optimal11,7933.270.03


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 referenced9,7302.700.03
CCursor + sql area evicted730.020.00
CPU used by this session164,23845.600.44
CPU used when call started162,40145.090.44
CR blocks created4200.120.00
Cached Commit SCN referenced2120.060.00
Commit SCN cached20,3285.640.06
DBWR checkpoint buffers written1,902,627528.255.15
DBWR checkpoints70.000.00
DBWR object drop buffers written00.000.00
DBWR revisited being-written buffer00.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes5680.160.00
DBWR undo block writes139,19138.650.38
Effective IO time00.000.00
HSC Heap Segment Block Changes1,307,522363.033.54
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts85,95223.860.23
Heap Segment Array Updates1,0370.290.00
IMU CR rollbacks100.000.00
IMU Flushes161,46144.830.44
IMU Redo allocation size311,937,22886,607.61844.31
IMU commits173,64348.210.47
IMU contention7330.200.00
IMU ktichg flush00.000.00
IMU pool not allocated1,2670.350.00
IMU recursive-transaction flush3260.090.00
IMU undo allocation size1,367,801,400379,762.343,702.20
IMU- failed to get a private strand1,2670.350.00
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 client1,790,076497.004.85
RowCR - row contention310.010.00
RowCR attempts9,2002.550.02
RowCR hits9,3352.590.03
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink1180.030.00
SQL*Net roundtrips to/from client1,791,835497.494.85
TBS Extension: bytes extended325,058,56090,250.67879.83
TBS Extension: files extended70.000.00
TBS Extension: tasks created330.010.00
TBS Extension: tasks executed330.010.00
active txn count during cleanout124,64134.610.34
background checkpoints completed70.000.00
background checkpoints started70.000.00
background timeouts29,6478.230.08
branch node splits140.000.00
buffer is not pinned count610,525,422169,508.941,652.50
buffer is pinned count697,106,905193,547.801,886.85
bytes received via SQL*Net from client1,041,626,333289,201.672,819.35
bytes sent via SQL*Net to client341,588,51094,840.12924.57
calls to get snapshot scn: kcmgss2,050,899569.425.55
calls to kcmgas309,90386.040.84
calls to kcmgcs517,993143.821.40
cell physical IO interconnect bytes24,773,411,3286,878,197.7967,053.75
change write time10,0512.790.03
cleanout - number of ktugct calls106,28929.510.29
cleanouts and rollbacks - consistent read gets900.020.00
cleanouts only - consistent read gets4760.130.00
cluster key scan block gets37,85410.510.10
cluster key scans34,9799.710.09
commit batch performed1190.030.00
commit batch requested1190.030.00
commit batch/immediate performed29,4058.160.08
commit batch/immediate requested29,4058.160.08
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written50.000.00
commit cleanout failures: callback failure5,7351.590.02
commit cleanout failures: cannot pin7580.210.00
commit cleanouts4,301,8071,194.3711.64
commit cleanouts successfully completed4,295,3091,192.5711.63
commit immediate performed29,2868.130.08
commit immediate requested29,2868.130.08
commit txn count during cleanout97,75627.140.26
consistent changes35,4469.840.10
consistent gets624,109,526173,280.491,689.27
consistent gets - examination3,685,4881,023.259.98
consistent gets direct00.000.00
consistent gets from cache624,109,577173,280.501,689.27
consistent gets from cache (fastpath)620,358,270172,238.971,679.11
cursor authentications2,0520.570.01
data blocks consistent reads - undo records applied1,4530.400.00
db block gets16,118,6124,475.2443.63
db block gets direct120.000.00
db block gets from cache16,118,6004,475.2443.63
db block gets from cache (fastpath)5,117,7931,420.9313.85
deferred (CURRENT) block cleanout applications1,080,891300.102.93
dirty buffers inspected20.000.00
doubling up with imu segment00.000.00
enqueue conversions3,5320.980.01
enqueue deadlocks00.000.00
enqueue releases1,321,636366.943.58
enqueue requests1,321,607366.943.58
enqueue timeouts60.000.00
enqueue waits810.020.00
exchange deadlocks100.000.00
failed probes on index block reclamation00.000.00
file io service time00.000.00
frame signature mismatch00.000.00
free buffer inspected69,23719.220.19
free buffer requested232,59364.580.63
heap block compress222,55461.790.60
hot buffers moved to head of LRU61,58017.100.17
immediate (CR) block cleanout applications5660.160.00
immediate (CURRENT) block cleanout applications592,338164.461.60
index crx upgrade (positioned)150.000.00
index crx upgrade (prefetch)10.000.00
index fast full scans (full)10.000.00
index fetch by key1,280,294355.473.47
index scans kdiixs11,223,994339.843.31
leaf node 90-10 splits1460.040.00
leaf node splits16,7134.640.05
lob reads8,4792.350.02
lob writes8,5282.370.02
lob writes unaligned8,5282.370.02
logical read bytes from cache5,244,750,340,0961,456,175,321.3314,195,872.69
max cf enq hold time700.020.00
messages received1,548,826430.024.19
messages sent1,548,827430.024.19
min active SCN optimization applied on CR63,96817.760.17
no buffer to keep pinned count00.000.00
no work - consistent read gets619,969,083172,130.921,678.06
non-idle wait count5,223,7351,450.3414.14
parse count (describe)50.000.00
parse count (failures)00.000.00
parse count (hard)2,4720.690.01
parse time cpu1,3080.360.00
physical read IO requests68,74419.090.19
physical read bytes563,380,224156,419.341,524.89
physical read total IO requests94,99326.370.26
physical read total bytes3,729,243,1361,035,403.3010,093.88
physical read total multi block requests2,7020.750.01
physical reads cache52,49314.570.14
physical reads cache prefetch280.010.00
physical reads direct16,2794.520.04
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests1,311,404364.103.55
physical write bytes15,615,631,3604,335,591.8942,266.55
physical write total IO requests1,576,982437.844.27
physical write total bytes21,044,168,1925,842,794.4956,959.88
physical write total multi block requests17,0314.730.05
physical writes direct3,5810.990.01
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache1,902,625528.255.15
physical writes non checkpoint143,67739.890.39
pinned buffers inspected00.000.00
prefetch clients - default00.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 time4,0301.120.01
recovery blocks read00.000.00
recursive aborts on index block reclamation00.000.00
recursive calls900,447250.002.44
recursive cpu usage4,0611.130.01
redo KB read2,445,513678.986.62
redo blocks checksummed by FG (exclusive)1,721,037477.844.66
redo blocks read for recovery00.000.00
redo blocks written4,816,2801,337.2113.04
redo buffer allocation retries1160.030.00
redo entries6,328,1701,756.9817.13
redo k-bytes read for recovery00.000.00
redo log space requests1180.030.00
redo ordering marks17,5604.880.05
redo size for direct writes98,73627.410.27
redo subscn max counts286,47279.540.78
redo synch long waits00.000.00
redo synch poll writes239,01666.360.65
redo synch polls249,18469.180.67
redo synch time13,6813.800.04
redo synch time (usec)136,843,90037,993.94370.39
redo synch time overhead (usec)89,440,20224,832.57242.09
redo synch time overhead count (<128 msec)10.000.00
redo synch time overhead count (<2 msec)236,22365.590.64
redo synch time overhead count (<32 msec)1620.040.00
redo synch time overhead count (<8 msec)2,0780.580.01
redo synch time overhead count (>=128 msec)10.000.00
redo synch writes239,01666.360.65
redo wastage64,430,34417,888.72174.39
redo write info find238,46666.210.65
redo write info find fail10.000.00
redo write time8,3092.310.02
redo writes239,29766.440.65
rollback changes - undo records applied96,64526.830.26
rollbacks only - consistent read gets2430.070.00
root node splits00.000.00
rows fetched via callback157,50143.730.43
session connect time00.000.00
shared hash latch upgrades - no wait13,4783.740.04
shared hash latch upgrades - wait00.000.00
sorts (disk)00.000.00
sorts (memory)18,4825.130.05
sorts (rows)166,84646.320.45
sql area evicted2,1280.590.01
sql area purged00.000.00
summed dirty queue length20.000.00
switch current to new buffer40,19211.160.11
table fetch by rowid652,193,049181,077.721,765.28
table fetch continued row3,2140.890.01
table scan blocks gotten4,917,0131,365.1813.31
table scan rows gotten468,426,170130,055.881,267.88
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (short tables)23,4606.510.06
temp space allocated (bytes)00.000.00
total cf enq hold time3,5500.990.01
total number of cf enq holders4120.110.00
total number of times SMON posted5500.150.00
transaction rollbacks29,4058.160.08
transaction tables consistent read rollbacks10.000.00
transaction tables consistent reads - undo records applied480.010.00
undo change vector size814,438,740226,124.322,204.43
user logons cumulative1,7740.490.00
user logouts cumulative1,7690.490.00
write clones created in background00.000.00
write clones created in foreground30.000.00


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current783788
opened cursors current2,0892,090
session cursor cache count3,345,3023,353,824
session pga memory74,245,307,45674,395,149,488
session pga memory max92,453,250,62492,549,652,080
session uga memory71,763,508,88871,936,064,680
session uga memory max498,189,967,256498,813,987,320


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)77.00


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)
DBWR0M0.010M14.5G363.004.126M470.00
Others2.9G7.18.836M2.8G2.27.784M26.2K0.03
LGWR2M0.05.001M2.3G71.44.653M239.5K0.01
Buffer Cache Reads410M14.57.114M0M0.000M52.5K2.12
Direct Reads127M4.52.035M23M0.79.006M0 
RMAN5M0.05.001M1M0.010M2140.22
Direct Writes0M0.000M5M0.20.001M0 
Streams AQ0M0.000M0M0.000M18.00
TOTAL:3.5G26.37.987M19.6G437.725.571M318.5K0.36


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 File547M19.35.152M14.5G363.984.134M2.4723.00
Log File2.3G0.68.663M2.3G71.39.653M0.319.27
Archive Log0M0.000M2.3G0.66.663M6.50 
Control File624M6.34.173M128M1.57.036M0.012.01
TOTAL:3.5G26.37.988M19.3G437.605.486M1.878.44


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 0M0.010M14.5G362.974.125M470.00
DBWR (Data File) 0M0.000M14.5G362.974.125M0 
DBWR (Control File) 0M0.010M0M0.000M470.00
Others 2.9G7.18.836M2.8G2.27.784M23.5K0.04
Others (Archive Log) 0M0.000M2.3G0.66.663M0 
Others (Log File) 2.3G0.67.663M0M0.000M280.46
Others (Control File) 615M6.24.171M125M1.52.035M22.5K0.04
Others (Data File) 8M0.27.002M311M0.09.086M9750.00
LGWR 2M0.05.001M2.3G71.42.653M1810.06
LGWR (Log File) 0M0.000M2.3G71.39.653M280.00
LGWR (Control File) 2M0.04.001M2M0.04.001M1530.07
Buffer Cache Reads 410M14.57.114M0M0.000M52.5K2.12
Buffer Cache Reads (Data File) 410M14.57.114M0M0.000M52.5K2.12
Direct Reads 127M4.52.035M23M0.79.006M0 
Direct Reads (Data File) 127M4.52.035M23M0.79.006M0 
RMAN 5M0.05.001M1M0.010M1890.25
RMAN (Control File) 5M0.05.001M1M0.010M1830.04
RMAN (Archive Log) 0M0.000M0M0.000M66.50
Direct Writes 0M0.000M5M0.20.001M0 
Direct Writes (Data File) 0M0.000M5M0.20.001M0 
Streams AQ 0M0.000M0M0.000M18.00
Streams AQ (Data File) 0M0.000M0M0.000M18.00
TOTAL: 3.5G26.37.987M19.6G437.675.571M76.4K1.47


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 3,89010.961.00863,7571.0812401160.09
TS_YTEXP 50201.591.00317,4090.14288100.00
TS_IDX_CONTAINER 15,87045.931.0046,5344.41613320.00
TS_IDX_HANDON 27,98580.881.007,2307.771200.00
TS_CONTAINER_02 46900.091.0013,7610.130490.00
UNDOTBS1 700.001.0010,0140.00031190.08
TS_HANDON_02 41000.051.007,5210.110200.00
TS_IDX_SIGNATURE 1,99510.751.004,2100.551100.00
TS_SIGNATURE_02 43200.231.063,2150.120110.00
TS_IDX_TAKE 2,22810.711.001,0570.621000.00
TS_IDX_T_EXP_CONTAINER_165 5400.001.003,0920.010100.00
TS_YTMDM 74405.261.002,1540.215100.00
TS_IDX_T_EXP_CONTAINER_208 2800.001.002,7370.010100.00
TS_IDX_YTMDM 91905.931.009770.266000.00
TS_TAKE_02 43600.071.009680.120000.00
SYSAUX 4703.831.008910.014000.00
TS_IDX_T_EXP_CONTAINER_219 3500.001.007070.010000.00
TS_IDX_T_EXP_CONTAINER_199 2800.001.007070.010000.00
TS_IDX_T_EXP_W_215 5400.561.005910.011000.00
TS_IDX_T_EXP_W_174 12303.981.005140.034000.00
TS_IDX_T_EXP_CONTAINER_227 3500.001.005930.010000.00
TS_IDX_T_EXP_CONTAINER_186 2100.001.006020.010000.00
TS_HANDON_01 47300.001.001110.130000.00
TS_TAKE_01 47200.001.00800.130000.00
TS_IDX_T_EXP_CONTAINER_206 2800.001.005050.010000.00
TS_IDX_T_EXP_W_175 4700.001.004660.010000.00
TS_CONTAINER_01 41600.001.00800.120000.00
SYSTEM 700.001.004880.0000730.00
TS_SIGNATURE_01 40200.051.00800.110000.00
TS_IDX_T_EXP_CONTAINER_181 2100.001.004360.010000.00
TS_IDX_T_EXP_W_229 4000.001.004030.010000.00
TS_IDX_T_EXP_CONTAINER_194 2800.001.003980.010000.00
TS_IDX_T_EXP_CONTAINER_215 3500.001.003860.010000.00
TS_IDX_T_EXP_W_181 4000.001.003800.010000.00
TS_IDX_T_EXP_W_170 10103.561.003160.034000.00
TS_IDX_T_EXP_W_161 21005.861.001970.066000.00
TS_IDX_T_EXP_CONTAINER_225 3500.001.003650.010000.00
TS_IDX_T_EXP_CONTAINER_175 2100.001.003640.010000.00
TS_IDX_T_EXP_W_164 16805.001.002150.055000.00
TS_IDX_T_EXP_W_233 9203.701.002800.034000.00
TS_IDX_T_EXP_W_162 8603.721.002750.024000.00
TS_IDX_T_EXP_W_207 4100.001.002780.010000.00
TS_IDX_T_EXP_CONTAINER_166 1400.001.002960.000000.00
TS_IDX_T_EXP_CONTAINER_202 2800.001.002810.010000.00
TS_IDX_T_EXP_W_209 4000.001.002660.010000.00
TS_IDX_T_EXP_W_172 7102.821.002320.023000.00
TBS_OTH_SPLEX 24000.001.00550.070000.00
TS_IDX_T_EXP_CONTAINER_237 3500.001.002490.010000.00
TS_IDX_T_EXP_CONTAINER_179 2200.001.002520.010000.00
TS_IDX_T_EXP_W_188 4100.241.002300.010000.00
TS_IDX_T_EXP_CONTAINER_209 2800.001.002330.010000.00
TS_IDX_T_EXP_W_178 4800.631.002090.011000.00
TS_IDX_T_EXP_W_203 4000.001.002100.010000.00
TS_IDX_T_EXP_W_208 4400.451.002010.010000.00
TS_IDX_T_EXP_CONTAINER_207 2800.001.002150.010000.00
TS_IDX_T_EXP_W_202 4800.001.001940.010000.00
TS_IDX_T_EXP_W_204 4000.001.001960.010000.00
TS_IDX_T_EXP_W_205 8304.341.001510.024000.00
TS_IDX_T_EXP_W_237 6703.281.001660.023000.00
TS_IDX_T_EXP_W_169 4700.001.001840.010000.00
TS_IDX_T_EXP_W_183 4100.001.001860.010000.00
TS_IDX_T_EXP_CONTAINER_233 3500.001.001890.010000.00
TS_IDX_T_EXP_W_179 4700.001.001740.010000.00
TS_IDX_T_EXP_W_166 3900.001.001810.010000.00
TS_IDX_T_EXP_W_182 4000.001.001770.010000.00
TS_IDX_T_EXP_W_190 4200.001.001750.010000.00
TS_IDX_T_EXP_W_218 5901.361.001550.021000.00
TS_IDX_T_EXP_W_186 4200.241.001710.010000.00
TS_IDX_T_EXP_W_199 4800.001.001640.010000.00
TS_IDX_T_EXP_W_239 9203.481.001140.033000.00
TS_IDX_T_EXP_W_187 8703.221.001150.023000.00
TS_IDX_T_EXP_W_180 4100.001.001570.010000.00
TS_IDX_T_EXP_W_177 4700.001.001480.010000.00
TS_IDX_T_EXP_CONTAINER_193 2800.001.001640.010000.00
TS_IDX_T_EXP_W_193 6501.691.001270.022000.00
TS_IDX_T_EXP_W_231 4000.001.001440.010000.00
TS_IDX_T_EXP_CONTAINER_162 1400.001.001690.000000.00
TS_IDX_T_EXP_CONTAINER_195 2800.001.001550.010000.00
TS_IDX_T_EXP_CONTAINER_221 3500.001.001480.010000.00
TS_IDX_T_EXP_W_221 5000.401.001320.010000.00
TS_IDX_T_EXP_CONTAINER_216 3500.001.001460.010000.00
TS_IDX_T_EXP_CONTAINER_173 2100.001.001590.010000.00
TS_IDX_T_EXP_W_196 4800.001.001320.010000.00
TS_IDX_T_EXP_W_191 4000.001.001390.010000.00
TS_IDX_T_EXP_W_167 3900.001.001370.010000.00
TS_IDX_T_EXP_W_201 6001.331.001130.021000.00
TS_IDX_T_EXP_W_214 4000.001.001300.010000.00
TS_IDX_T_EXP_W_171 4700.001.001190.010000.00
TS_IDX_T_EXP_CONTAINER_188 2100.001.001440.010000.00
TS_IDX_T_EXP_W_206 4000.001.001220.010000.00
TS_IDX_T_EXP_W_217 4800.001.001120.010000.00
TS_IDX_T_EXP_W_165 4701.061.001120.011000.00
TS_IDX_T_EXP_W_168 3900.001.001200.010000.00
TS_IDX_T_EXP_W_163 4300.471.001150.011000.00
TS_IDX_T_EXP_W_227 4000.001.001160.010000.00
TS_IDX_T_EXP_CONTAINER_182 2100.001.001320.010000.00
TS_IDX_T_EXP_W_210 5701.581.00960.022000.00
TS_IDX_T_EXP_W_212 4000.001.001130.010000.00
TS_IDX_T_EXP_CONTAINER_220 3500.001.001170.010000.00
TS_IDX_T_EXP_CONTAINER_229 3500.001.001160.010000.00
TS_IDX_T_EXP_W_240 4800.001.001010.010000.00
TS_IDX_T_EXP_CONTAINER_174 2100.001.001270.010000.00
TS_IDX_T_EXP_W_228 4000.001.001050.010000.00
TS_IDX_T_EXP_W_194 4800.001.00940.010000.00
TS_IDX_T_EXP_W_197 4800.001.00930.010000.00
TS_IDX_T_EXP_W_173 4700.001.00930.010000.00
TS_IDX_T_EXP_W_219 4800.001.00920.010000.00
TS_IDX_T_EXP_W_185 4000.001.00990.010000.00
TS_IDX_T_EXP_W_226 4200.241.00960.010000.00
TS_IDX_T_EXP_CONTAINER_161 1400.001.001230.000000.00
TS_IDX_T_EXP_CONTAINER_214 2800.001.001090.010000.00
TS_IDX_T_EXP_W_200 4800.001.00890.010000.00
TS_IDX_T_EXP_W_220 4900.201.00850.010000.00
TS_IDX_T_EXP_CONTAINER_198 2800.001.001050.010000.00
TS_IDX_T_EXP_W_189 4000.001.00920.010000.00
TS_IDX_T_EXP_W_235 4000.001.00910.010000.00
TS_IDX_T_EXP_W_184 4000.001.00900.010000.00
TS_IDX_T_EXP_CONTAINER_217 3500.001.00940.010000.00
TS_IDX_T_EXP_W_213 4000.001.00890.010000.00
TS_IDX_T_EXP_W_225 4800.001.00810.010000.00
TS_IDX_T_EXP_W_216 4900.201.00790.010000.00
TS_IDX_T_EXP_CONTAINER_180 2100.001.001050.010000.00
TS_IDX_T_EXP_W_222 6401.251.00620.021000.00
TS_IDX_T_EXP_CONTAINER_177 2100.001.001040.010000.00
TS_IDX_T_EXP_W_198 4800.001.00750.010000.00
TS_IDX_T_EXP_CONTAINER_164 1400.001.001060.000000.00
TS_IDX_T_EXP_CONTAINER_183 2100.001.00990.010000.00
TS_IDX_T_EXP_W_195 5000.001.00700.010000.00
TS_IDX_T_EXP_CONTAINER_178 2100.001.00980.010000.00
TS_IDX_T_EXP_W_238 5100.201.00680.010000.00
TS_IDX_T_EXP_W_192 4800.001.00700.010000.00
TS_IDX_T_EXP_CONTAINER_203 2800.001.00860.010000.00
TS_IDX_T_EXP_CONTAINER_187 2100.001.00920.010000.00
TS_IDX_T_EXP_CONTAINER_191 2100.001.00900.010000.00
TS_IDX_T_EXP_CONTAINER_228 3500.001.00750.010000.00
TS_IDX_T_EXP_CONTAINER_236 3500.001.00750.010000.00
TS_IDX_T_EXP_W_223 4800.001.00620.010000.00
TS_T_EXP_CONTAINER_165 8700.001.00230.020000.00
TS_IDX_T_EXP_W_224 5100.391.00580.011000.00
TS_IDX_T_EXP_CONTAINER_171 2100.001.00850.010000.00
TS_IDX_T_EXP_CONTAINER_169 2100.001.00840.010000.00
TS_IDX_T_EXP_W_232 4000.001.00640.010000.00
TS_IDX_T_EXP_CONTAINER_204 2800.001.00730.010000.00
TS_IDX_T_EXP_CONTAINER_200 2800.001.00710.010000.00
TS_IDX_T_EXP_CONTAINER_201 2800.001.00640.010000.00
TS_IDX_T_EXP_CONTAINER_210 2800.001.00620.010000.00
TS_IDX_T_EXP_W_211 4000.001.00500.010000.00
TS_IDX_T_EXP_CONTAINER_172 2100.001.00680.010000.00
TS_IDX_T_EXP_CONTAINER_222 3500.001.00540.010000.00
TS_IDX_T_EXP_CONTAINER_185 2100.001.00660.010000.00
TS_IDX_T_EXP_CONTAINER_234 3500.001.00500.010000.00
TS_IDX_T_EXP_CONTAINER_235 3500.001.00500.010000.00
TS_IDX_T_EXP_CONTAINER_197 2800.001.00550.010000.00
TS_IDX_T_EXP_W_236 4000.001.00430.010000.00
TS_IDX_T_EXP_CONTAINER_224 3500.001.00420.010000.00
TS_IDX_T_EXP_CONTAINER_196 2900.341.00470.010000.00
TS_IDX_T_EXP_CONTAINER_170 2200.451.00520.010000.00
TS_IDX_T_EXP_CONTAINER_189 2100.001.00530.010000.00
TS_IDX_T_EXP_CONTAINER_212 2800.001.00460.010000.00
TS_IDX_T_EXP_W_230 4000.001.00340.010000.00
TS_IDX_T_EXP_W_234 4000.001.00340.010000.00
TS_IDX_T_EXP_CONTAINER_163 1400.001.00570.000000.00
TS_IDX_T_EXP_CONTAINER_176 2100.001.00490.010000.00
TS_IDX_T_EXP_CONTAINER_213 2800.001.00410.010000.00
TS_IDX_T_EXP_CONTAINER_231 3500.001.00300.010000.00
TS_IDX_T_EXP_CONTAINER_190 2100.001.00420.010000.00
TS_IDX_T_EXP_CONTAINER_238 4300.001.00190.010000.00
TS_IDX_T_EXP_W_176 4700.001.00150.010000.00
TS_T_EXP_CONTAINER_208 4700.001.00150.010000.00
TS_IDX_T_EXP_CONTAINER_232 3500.001.00240.010000.00
TS_IDX_T_EXP_CONTAINER_167 1400.001.00440.000000.00
TS_IDX_T_EXP_CONTAINER_192 2800.001.00300.010000.00
TS_IDX_T_EXP_CONTAINER_240 4300.001.00150.010000.00
TS_IDX_T_EXP_CONTAINER_218 3500.001.00220.010000.00
TS_IDX_T_EXP_CONTAINER_223 3500.001.00220.010000.00
TS_IDX_T_EXP_CONTAINER_205 2800.001.00280.010000.00
TS_IDX_T_EXP_CONTAINER_230 3500.001.00200.010000.00
TS_IDX_T_EXP_CONTAINER_239 4300.001.00110.010000.00
TS_T_EXP_W_226 4600.001.0080.010000.00
TS_T_EXP_W_227 4600.001.0080.010000.00
TS_T_EXP_W_228 4600.001.0080.010000.00
TS_T_EXP_W_229 4600.001.0080.010000.00
TS_T_EXP_W_230 4600.221.0080.010000.00
TS_T_EXP_W_231 4600.001.0080.010000.00
TS_T_EXP_W_232 4600.001.0080.010000.00
TS_T_EXP_W_233 4600.001.0080.010000.00
TS_T_EXP_W_234 4600.001.0080.010000.00
TS_T_EXP_W_235 4600.001.0080.010000.00
TS_T_EXP_W_236 4600.001.0080.010000.00
TS_IDX_T_EXP_CONTAINER_226 3500.001.00180.010000.00
TS_T_EXP_W_203 4500.001.0080.010000.00
TS_T_EXP_W_204 4500.001.0080.010000.00
TS_T_EXP_W_205 4500.001.0080.010000.00
TS_T_EXP_W_206 4500.001.0080.010000.00
TS_T_EXP_W_207 4500.001.0080.010000.00
TS_T_EXP_W_208 4500.001.0080.010000.00
TS_T_EXP_W_209 4500.001.0080.010000.00
TS_T_EXP_W_210 4500.001.0080.010000.00
TS_T_EXP_W_211 4500.001.0080.010000.00
TS_T_EXP_W_212 4500.001.0080.010000.00
TS_T_EXP_W_213 4500.001.0080.010000.00
TS_T_EXP_W_180 4400.001.0080.010000.00
TS_T_EXP_W_181 4400.001.0080.010000.00
TS_T_EXP_W_182 4400.001.0080.010000.00
TS_T_EXP_W_183 4400.001.0080.010000.00
TS_T_EXP_W_184 4400.001.0080.010000.00
TS_T_EXP_W_185 4400.001.0080.010000.00
TS_T_EXP_W_186 4400.001.0080.010000.00
TS_T_EXP_W_187 4400.001.0080.010000.00
TS_T_EXP_W_188 4400.001.0080.010000.00
TS_T_EXP_W_189 4400.001.0080.010000.00
TS_T_EXP_W_190 4400.001.0080.010000.00
TS_T_EXP_W_160 4300.001.0080.010000.00
TS_T_EXP_W_161 4300.001.0080.010000.00
TS_T_EXP_W_162 4300.001.0080.010000.00
TS_T_EXP_W_163 4300.001.0080.010000.00
TS_T_EXP_W_164 4300.001.0080.010000.00
TS_T_EXP_W_165 4300.001.0080.010000.00
TS_T_EXP_W_166 4300.001.0080.010000.00
TS_T_EXP_W_167 4300.001.0080.010000.00
TS_T_EXP_W_237 3900.001.0080.010000.00
TS_T_EXP_W_238 3900.001.0080.010000.00
TS_T_EXP_W_239 3900.001.0080.010000.00
TS_T_EXP_W_240 3900.001.0080.010000.00
TS_T_EXP_W_200 3800.261.0080.010000.00
TS_T_EXP_W_214 3800.001.0080.010000.00
TS_T_EXP_W_215 3800.001.0080.010000.00
TS_T_EXP_W_216 3800.001.0080.010000.00
TS_T_EXP_W_217 3800.001.0080.010000.00
TS_T_EXP_W_218 3800.001.0080.010000.00
TS_T_EXP_W_219 3800.001.0080.010000.00
TS_T_EXP_W_220 3800.001.0080.010000.00
TS_T_EXP_W_221 3800.001.0080.010000.00
TS_T_EXP_W_222 3800.001.0080.010000.00
TS_T_EXP_W_223 3800.001.0080.010000.00
TS_T_EXP_W_224 3800.001.0080.010000.00
TS_T_EXP_W_225 3800.001.0080.010000.00
TS_T_EXP_W_168 3700.271.0080.010000.00
TS_T_EXP_W_191 3700.001.0080.010000.00
TS_T_EXP_W_192 3700.001.0080.010000.00
TS_T_EXP_W_193 3700.001.0080.010000.00
TS_T_EXP_W_194 3700.001.0080.010000.00
TS_T_EXP_W_195 3700.001.0080.010000.00
TS_T_EXP_W_196 3700.001.0080.010000.00
TS_T_EXP_W_197 3700.001.0080.010000.00
TS_T_EXP_W_198 3700.001.0080.010000.00
TS_T_EXP_W_199 3700.001.0080.010000.00
TS_T_EXP_W_201 3700.001.0080.010000.00
TS_T_EXP_W_202 3700.001.0080.010000.00
TS_T_EXP_W_169 3600.001.0080.010000.00
TS_T_EXP_W_170 3600.001.0080.010000.00
TS_T_EXP_W_171 3600.001.0080.010000.00
TS_T_EXP_W_172 3600.001.0080.010000.00
TS_T_EXP_W_173 3600.001.0080.010000.00
TS_T_EXP_W_174 3600.001.0080.010000.00
TS_T_EXP_W_175 3600.001.0080.010000.00
TS_T_EXP_W_176 3600.001.0080.010000.00
TS_T_EXP_W_177 3600.001.0080.010000.00
TS_T_EXP_W_178 3600.001.0080.010000.00
TS_T_EXP_W_179 3600.001.0080.010000.00
TS_IDX_T_EXP_CONTAINER_211 2800.001.00130.010000.00
TS_IDX_T_EXP_CONTAINER_184 2100.001.00160.010000.00
TS_IDX_T_EXP_CONTAINER_168 1400.001.00100.000000.00
TS_T_EXP_CONTAINER_180 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_181 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_182 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_183 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_184 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_185 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_186 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_187 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_188 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_189 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_190 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_191 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_192 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_193 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_194 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_195 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_196 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_197 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_198 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_199 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_200 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_201 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_202 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_226 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_227 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_228 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_229 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_230 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_231 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_232 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_233 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_234 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_235 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_236 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_237 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_238 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_239 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_240 1400.001.0070.000000.00
TS_T_EXP_CONTAINER_161 700.001.0070.000000.00
TS_T_EXP_CONTAINER_162 700.001.0070.000000.00
TS_T_EXP_CONTAINER_163 700.001.0070.000000.00
TS_T_EXP_CONTAINER_164 700.001.0070.000000.00
TS_T_EXP_CONTAINER_166 700.001.0070.000000.00
TS_T_EXP_CONTAINER_167 700.001.0070.000000.00
TS_T_EXP_CONTAINER_168 700.001.0070.000000.00
TS_T_EXP_CONTAINER_169 700.001.0070.000000.00
TS_T_EXP_CONTAINER_170 700.001.0070.000000.00
TS_T_EXP_CONTAINER_171 700.001.0070.000000.00
TS_T_EXP_CONTAINER_172 700.001.0070.000000.00
TS_T_EXP_CONTAINER_173 700.001.0070.000000.00
TS_T_EXP_CONTAINER_174 700.001.0070.000000.00
TS_T_EXP_CONTAINER_175 700.001.0070.000000.00
TS_T_EXP_CONTAINER_176 700.001.0070.000000.00
TS_T_EXP_CONTAINER_177 700.001.0070.000000.00
TS_T_EXP_CONTAINER_178 700.001.0070.000000.00
TS_T_EXP_CONTAINER_179 700.001.0070.000000.00
TS_T_EXP_CONTAINER_203 700.001.0070.000000.00
TS_T_EXP_CONTAINER_204 700.001.0070.000000.00
TS_T_EXP_CONTAINER_205 700.001.0070.000000.00
TS_T_EXP_CONTAINER_206 700.001.0070.000000.00
TS_T_EXP_CONTAINER_207 700.001.0070.000000.00
TS_T_EXP_CONTAINER_209 700.001.0070.000000.00
TS_T_EXP_CONTAINER_210 700.001.0070.000000.00
TS_T_EXP_CONTAINER_211 700.001.0070.000000.00
TS_T_EXP_CONTAINER_212 700.001.0070.000000.00
TS_T_EXP_CONTAINER_213 700.001.0070.000000.00
TS_T_EXP_CONTAINER_214 700.001.0070.000000.00
TS_T_EXP_CONTAINER_215 700.001.0070.000000.00
TS_T_EXP_CONTAINER_216 700.001.0070.000000.00
TS_T_EXP_CONTAINER_217 700.001.0070.000000.00
TS_T_EXP_CONTAINER_218 700.001.0070.000000.00
TS_T_EXP_CONTAINER_219 700.001.0070.000000.00
TS_T_EXP_CONTAINER_220 700.001.0070.000000.00
TS_T_EXP_CONTAINER_221 700.001.0070.000000.00
TS_T_EXP_CONTAINER_222 700.001.0070.000000.00
TS_T_EXP_CONTAINER_223 700.001.0070.000000.00
TS_T_EXP_CONTAINER_224 700.001.0070.000000.00
TS_T_EXP_CONTAINER_225 700.001.0070.000000.00
USERS 700.001.0070.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 4703.831.0003.62891000.00
SYSTEM+DATA_DG/dbquery/datafile/system.261.828812051 700.001.0000.004880730.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_01.dbf 4800.001.0000.008000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_02.dbf 4800.001.0000.008000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_03.dbf 4800.001.0000.008000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_04.dbf 4800.001.0000.008000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_05.dbf 4800.001.0000.0023000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_01.dbf 4000.001.0000.008000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_02.dbf 4000.001.0000.008000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_03.dbf 4000.001.0000.008000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_04.dbf 4000.001.0000.008000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_05.dbf 4000.001.0000.008000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_06.dbf 4000.001.0000.008000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_07.dbf 4000.001.0000.008000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_08.dbf 4000.001.0000.008000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_09.dbf 4800.001.0000.008000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_10.dbf 4800.001.0000.008000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_01.dbf 4100.001.0000.24452000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_02.dbf 4900.201.0000.411,591000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_03.dbf 4700.001.0000.00730000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_04.dbf 4900.201.0000.201,962110.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_05.dbf 4700.001.0000.002,470140.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_06.dbf 4700.001.0000.001,583000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_07.dbf 4700.001.0000.001,544000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_08.dbf 4700.001.0000.00925010.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_09.dbf 4700.001.0000.001,611030.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_10.dbf 4800.421.0000.42893000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_01.dbf 4800.001.0000.008000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_02.dbf 4800.001.0000.0023000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_03.dbf 4800.001.0000.0010000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_04.dbf 4900.001.0000.2015000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_05.dbf 4800.001.0000.0012000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_06.dbf 4800.001.0000.0010000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_07.dbf 4800.001.0000.009000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_08.dbf 4800.001.0000.008000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_09.dbf 4800.001.0000.008000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_10.dbf 4000.001.0000.008000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_01.dbf 5000.201.0000.40564000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_02.dbf 4700.001.0000.00571000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_03.dbf 3900.001.0000.00247000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_04.dbf 3900.001.0000.00717000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_05.dbf 4000.251.0000.001,130000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_06.dbf 3900.001.0000.00886000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_07.dbf 3900.001.0000.001,496000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_08.dbf 3900.001.0000.00245000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_09.dbf 3900.001.0000.00721000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_10.dbf 3900.001.0000.00944000.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_01.dbf 1,71105.701.0005.705,536210.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_02.dbf 1,60205.871.0005.875,775200.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_03.dbf 1,59105.921.0005.925,530240.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_04.dbf 1,51005.931.0005.934,503100.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_05.dbf 1,59106.111.0006.113,697110.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_06.dbf 1,46006.041.0006.033,888120.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_07.dbf 1,56705.881.0005.883,980190.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_08.dbf 1,63805.991.0005.993,616110.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_09.dbf 1,52706.021.0006.024,5761120.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_10.dbf 1,67305.871.0005.875,433220.00
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_01.dbf 3,07510.871.0010.87859000.00
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_02.dbf 3,32810.881.0010.88715000.00
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_03.dbf 3,04510.911.0010.91963000.00
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_04.dbf 2,82210.901.0010.90661000.00
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_05.dbf 2,50210.871.0010.87628000.00
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_06.dbf 2,82410.871.0010.87758000.00
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_07.dbf 2,89410.871.0010.87991000.00
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_08.dbf 2,41010.861.0010.86445000.00
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_09.dbf 2,44710.871.0010.87371000.00
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_10.dbf 2,63810.881.0010.88839000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_01.dbf 23400.851.0000.85397000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_02.dbf 28500.811.0000.84132000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_03.dbf 23900.791.0000.79419000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_04.dbf 14500.691.0000.69692000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_05.dbf 18500.701.0000.70634000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_06.dbf 13700.661.0000.66608000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_07.dbf 17700.731.0000.68438000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_08.dbf 16300.671.0000.67304000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_09.dbf 17500.691.0000.69324000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_10.dbf 25500.751.0000.75262000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_01.dbf 24300.701.0000.70136000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_02.dbf 21400.751.0000.70137000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_03.dbf 20600.681.0000.6862000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_04.dbf 23200.731.0000.73171000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_05.dbf 24900.721.0000.72150000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_06.dbf 27400.731.0000.73105000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_07.dbf 23300.731.0000.6951000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_08.dbf 20200.691.0000.6945000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_09.dbf 17400.691.0000.6953000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_10.dbf 20100.701.0000.70147000.00
TS_IDX_T_EXP_CONTAINER_161+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_161.dbf 1400.001.0000.00123000.00
TS_IDX_T_EXP_CONTAINER_162+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_162.dbf 1400.001.0000.00169000.00
TS_IDX_T_EXP_CONTAINER_163+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_163.dbf 1400.001.0000.0057000.00
TS_IDX_T_EXP_CONTAINER_164+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_164.dbf 1400.001.0000.00106000.00
TS_IDX_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_165.dbf 1400.001.0000.001,612000.00
TS_IDX_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165_01.dbf 4000.001.0000.001,480000.00
TS_IDX_T_EXP_CONTAINER_166+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_166.dbf 1400.001.0000.00296000.00
TS_IDX_T_EXP_CONTAINER_167+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_167.dbf 1400.001.0000.0044000.00
TS_IDX_T_EXP_CONTAINER_168+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_168.dbf 1400.001.0000.0010000.00
TS_IDX_T_EXP_CONTAINER_169+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_169.dbf 2100.001.0000.0084000.00
TS_IDX_T_EXP_CONTAINER_170+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_170.dbf 2200.451.0000.0052000.00
TS_IDX_T_EXP_CONTAINER_171+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_171.dbf 2100.001.0000.0085000.00
TS_IDX_T_EXP_CONTAINER_172+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_172.dbf 2100.001.0000.0068000.00
TS_IDX_T_EXP_CONTAINER_173+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_173.dbf 2100.001.0000.00159000.00
TS_IDX_T_EXP_CONTAINER_174+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_174.dbf 2100.001.0000.00127000.00
TS_IDX_T_EXP_CONTAINER_175+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_175.dbf 2100.001.0000.00364000.00
TS_IDX_T_EXP_CONTAINER_176+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_176.dbf 2100.001.0000.0049000.00
TS_IDX_T_EXP_CONTAINER_177+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_177.dbf 2100.001.0000.00104000.00
TS_IDX_T_EXP_CONTAINER_178+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_178.dbf 2100.001.0000.0098000.00
TS_IDX_T_EXP_CONTAINER_179+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_179.dbf 2200.001.0000.00252000.00
TS_IDX_T_EXP_CONTAINER_180+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_180.dbf 2100.001.0000.00105000.00
TS_IDX_T_EXP_CONTAINER_181+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_181.dbf 2100.001.0000.00436000.00
TS_IDX_T_EXP_CONTAINER_182+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_182.dbf 2100.001.0000.00132000.00
TS_IDX_T_EXP_CONTAINER_183+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_183.dbf 2100.001.0000.0099000.00
TS_IDX_T_EXP_CONTAINER_184+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_184.dbf 2100.001.0000.0016000.00
TS_IDX_T_EXP_CONTAINER_185+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_185.dbf 2100.001.0000.0066000.00
TS_IDX_T_EXP_CONTAINER_186+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_186.dbf 2100.001.0000.00602000.00
TS_IDX_T_EXP_CONTAINER_187+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_187.dbf 2100.001.0000.0092000.00
TS_IDX_T_EXP_CONTAINER_188+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_188.dbf 2100.001.0000.00144000.00
TS_IDX_T_EXP_CONTAINER_189+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_189.dbf 2100.001.0000.0053000.00
TS_IDX_T_EXP_CONTAINER_190+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_190.dbf 2100.001.0000.0042000.00
TS_IDX_T_EXP_CONTAINER_191+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_191.dbf 2100.001.0000.0090000.00
TS_IDX_T_EXP_CONTAINER_192+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_192.dbf 2800.001.0000.0030000.00
TS_IDX_T_EXP_CONTAINER_193+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_193.dbf 2800.001.0000.00164000.00
TS_IDX_T_EXP_CONTAINER_194+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_194.dbf 2800.001.0000.00398000.00
TS_IDX_T_EXP_CONTAINER_195+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_195.dbf 2800.001.0000.00155000.00
TS_IDX_T_EXP_CONTAINER_196+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_196.dbf 2900.341.0000.3447000.00
TS_IDX_T_EXP_CONTAINER_197+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_197.dbf 2800.001.0000.0055000.00
TS_IDX_T_EXP_CONTAINER_198+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_198.dbf 2800.001.0000.00105000.00
TS_IDX_T_EXP_CONTAINER_199+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_199.dbf 2800.001.0000.00707000.00
TS_IDX_T_EXP_CONTAINER_200+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_200.dbf 2800.001.0000.0071000.00
TS_IDX_T_EXP_CONTAINER_201+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_201.dbf 2800.001.0000.0064000.00
TS_IDX_T_EXP_CONTAINER_202+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_202.dbf 2800.001.0000.00281000.00
TS_IDX_T_EXP_CONTAINER_203+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_203.dbf 2800.001.0000.0086000.00
TS_IDX_T_EXP_CONTAINER_204+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_204.dbf 2800.001.0000.0073000.00
TS_IDX_T_EXP_CONTAINER_205+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_205.dbf 2800.001.0000.0028000.00
TS_IDX_T_EXP_CONTAINER_206+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_206.dbf 2800.001.0000.00505000.00
TS_IDX_T_EXP_CONTAINER_207+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_207.dbf 2800.001.0000.00215000.00
TS_IDX_T_EXP_CONTAINER_208+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_208.dbf 2800.001.0000.002,737100.00
TS_IDX_T_EXP_CONTAINER_209+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_209.dbf 2800.001.0000.00233000.00
TS_IDX_T_EXP_CONTAINER_210+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_210.dbf 2800.001.0000.0062000.00
TS_IDX_T_EXP_CONTAINER_211+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_211.dbf 2800.001.0000.0013000.00
TS_IDX_T_EXP_CONTAINER_212+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_212.dbf 2800.001.0000.0046000.00
TS_IDX_T_EXP_CONTAINER_213+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_213.dbf 2800.001.0000.0041000.00
TS_IDX_T_EXP_CONTAINER_214+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_214.dbf 2800.001.0000.00109000.00
TS_IDX_T_EXP_CONTAINER_215+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_215.dbf 3500.001.0000.00386000.00
TS_IDX_T_EXP_CONTAINER_216+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_216.dbf 3500.001.0000.00146000.00
TS_IDX_T_EXP_CONTAINER_217+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_217.dbf 3500.001.0000.0094000.00
TS_IDX_T_EXP_CONTAINER_218+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_218.dbf 3500.001.0000.0022000.00
TS_IDX_T_EXP_CONTAINER_219+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_219.dbf 3500.001.0000.00707000.00
TS_IDX_T_EXP_CONTAINER_220+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_220.dbf 3500.001.0000.00117000.00
TS_IDX_T_EXP_CONTAINER_221+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_221.dbf 3500.001.0000.00148000.00
TS_IDX_T_EXP_CONTAINER_222+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_222.dbf 3500.001.0000.0054000.00
TS_IDX_T_EXP_CONTAINER_223+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_223.dbf 3500.001.0000.0022000.00
TS_IDX_T_EXP_CONTAINER_224+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_224.dbf 3500.001.0000.0042000.00
TS_IDX_T_EXP_CONTAINER_225+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_225.dbf 3500.001.0000.00365000.00
TS_IDX_T_EXP_CONTAINER_226+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_226.dbf 3500.001.0000.0018000.00
TS_IDX_T_EXP_CONTAINER_227+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_227.dbf 3500.001.0000.00593000.00
TS_IDX_T_EXP_CONTAINER_228+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_228.dbf 3500.001.0000.0075000.00
TS_IDX_T_EXP_CONTAINER_229+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_229.dbf 3500.001.0000.00116000.00
TS_IDX_T_EXP_CONTAINER_230+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_230.dbf 3500.001.0000.0020000.00
TS_IDX_T_EXP_CONTAINER_231+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_231.dbf 3500.001.0000.0030000.00
TS_IDX_T_EXP_CONTAINER_232+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_232.dbf 3500.001.0000.0024000.00
TS_IDX_T_EXP_CONTAINER_233+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_233.dbf 3500.001.0000.00189000.00
TS_IDX_T_EXP_CONTAINER_234+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_234.dbf 3500.001.0000.0050000.00
TS_IDX_T_EXP_CONTAINER_235+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_235.dbf 3500.001.0000.0050000.00
TS_IDX_T_EXP_CONTAINER_236+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_236.dbf 3500.001.0000.0075000.00
TS_IDX_T_EXP_CONTAINER_237+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_237.dbf 3500.001.0000.00249000.00
TS_IDX_T_EXP_CONTAINER_238+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_238.dbf 4300.001.0000.0019000.00
TS_IDX_T_EXP_CONTAINER_239+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_239.dbf 4300.001.0000.0011000.00
TS_IDX_T_EXP_CONTAINER_240+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_240.dbf 4300.001.0000.0015000.00
TS_IDX_T_EXP_W_161+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_161.dbf 21005.861.0005.86197000.00
TS_IDX_T_EXP_W_162+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_162.dbf 8603.721.0003.84275000.00
TS_IDX_T_EXP_W_163+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_163.dbf 4300.471.0000.70115000.00
TS_IDX_T_EXP_W_164+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_164.dbf 16805.001.0005.00215000.00
TS_IDX_T_EXP_W_165+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_165.dbf 4701.061.0001.06112000.00
TS_IDX_T_EXP_W_166+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_166.dbf 3900.001.0000.00181000.00
TS_IDX_T_EXP_W_167+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_167.dbf 3900.001.0000.00137000.00
TS_IDX_T_EXP_W_168+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_168.dbf 3900.001.0000.00120000.00
TS_IDX_T_EXP_W_169+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_169.dbf 4700.001.0000.00184000.00
TS_IDX_T_EXP_W_170+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_170.dbf 10103.561.0003.56316000.00
TS_IDX_T_EXP_W_171+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_171.dbf 4700.001.0000.00119000.00
TS_IDX_T_EXP_W_172+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_172.dbf 7102.821.0002.82232000.00
TS_IDX_T_EXP_W_173+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_173.dbf 4700.001.0000.0093000.00
TS_IDX_T_EXP_W_174+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_174.dbf 12303.981.0004.07514000.00
TS_IDX_T_EXP_W_175+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_175.dbf 4700.001.0000.00466000.00
TS_IDX_T_EXP_W_176+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_176.dbf 4700.001.0000.0015000.00
TS_IDX_T_EXP_W_177+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_177.dbf 4700.001.0000.00148000.00
TS_IDX_T_EXP_W_178+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_178.dbf 4800.631.0000.63209000.00
TS_IDX_T_EXP_W_179+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_179.dbf 4700.001.0000.00174000.00
TS_IDX_T_EXP_W_180+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_180.dbf 4100.001.0000.00157000.00
TS_IDX_T_EXP_W_181+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_181.dbf 4000.001.0000.00380000.00
TS_IDX_T_EXP_W_182+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_182.dbf 4000.001.0000.00177000.00
TS_IDX_T_EXP_W_183+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_183.dbf 4100.001.0000.24186000.00
TS_IDX_T_EXP_W_184+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_184.dbf 4000.001.0000.0090000.00
TS_IDX_T_EXP_W_185+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_185.dbf 4000.001.0000.0099000.00
TS_IDX_T_EXP_W_186+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_186.dbf 4200.241.0000.24171000.00
TS_IDX_T_EXP_W_187+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_187.dbf 8703.221.0003.33115000.00
TS_IDX_T_EXP_W_188+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_188.dbf 4100.241.0000.24230000.00
TS_IDX_T_EXP_W_189+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_189.dbf 4000.001.0000.0092000.00
TS_IDX_T_EXP_W_190+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_190.dbf 4200.001.0000.00175000.00
TS_IDX_T_EXP_W_191+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_191.dbf 4000.001.0000.00139000.00
TS_IDX_T_EXP_W_192+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_192.dbf 4800.001.0000.0070000.00
TS_IDX_T_EXP_W_193+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_193.dbf 6501.691.0001.69127000.00
TS_IDX_T_EXP_W_194+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_194.dbf 4800.001.0000.0094000.00
TS_IDX_T_EXP_W_195+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_195.dbf 5000.001.0000.2070000.00
TS_IDX_T_EXP_W_196+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_196.dbf 4800.001.0000.00132000.00
TS_IDX_T_EXP_W_197+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_197.dbf 4800.001.0000.0093000.00
TS_IDX_T_EXP_W_198+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_198.dbf 4800.001.0000.0075000.00
TS_IDX_T_EXP_W_199+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_199.dbf 4800.001.0000.00164000.00
TS_IDX_T_EXP_W_200+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_200.dbf 4800.001.0000.0089000.00
TS_IDX_T_EXP_W_201+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_201.dbf 6001.331.0001.33113000.00
TS_IDX_T_EXP_W_202+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_202.dbf 4800.001.0000.00194000.00
TS_IDX_T_EXP_W_203+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_203.dbf 4000.001.0000.00210000.00
TS_IDX_T_EXP_W_204+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_204.dbf 4000.001.0000.00196000.00
TS_IDX_T_EXP_W_205+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_205.dbf 8304.341.0004.34151000.00
TS_IDX_T_EXP_W_206+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_206.dbf 4000.001.0000.00122000.00
TS_IDX_T_EXP_W_207+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_207.dbf 4100.001.0000.24278000.00
TS_IDX_T_EXP_W_208+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_208.dbf 4400.451.0000.45201000.00
TS_IDX_T_EXP_W_209+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_209.dbf 4000.001.0000.00266000.00
TS_IDX_T_EXP_W_210+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_210.dbf 5701.581.0001.5896000.00
TS_IDX_T_EXP_W_211+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_211.dbf 4000.001.0000.0050000.00
TS_IDX_T_EXP_W_212+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_212.dbf 4000.001.0000.00113000.00
TS_IDX_T_EXP_W_213+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_213.dbf 4000.001.0000.0089000.00
TS_IDX_T_EXP_W_214+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_214.dbf 4000.001.0000.00130000.00
TS_IDX_T_EXP_W_215+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_215.dbf 5400.561.0000.74591000.00
TS_IDX_T_EXP_W_216+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_216.dbf 4900.201.0000.2079000.00
TS_IDX_T_EXP_W_217+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_217.dbf 4800.001.0000.00112000.00
TS_IDX_T_EXP_W_218+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_218.dbf 5901.361.0001.36155000.00
TS_IDX_T_EXP_W_219+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_219.dbf 4800.001.0000.0092000.00
TS_IDX_T_EXP_W_220+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_220.dbf 4900.201.0000.2085000.00
TS_IDX_T_EXP_W_221+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_221.dbf 5000.401.0000.20132000.00
TS_IDX_T_EXP_W_222+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_222.dbf 6401.251.0001.2562000.00
TS_IDX_T_EXP_W_223+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_223.dbf 4800.001.0000.0062000.00
TS_IDX_T_EXP_W_224+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_224.dbf 5100.391.0000.5958000.00
TS_IDX_T_EXP_W_225+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_225.dbf 4800.001.0000.0081000.00
TS_IDX_T_EXP_W_226+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_226.dbf 4200.241.0000.2496000.00
TS_IDX_T_EXP_W_227+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_227.dbf 4000.001.0000.00116000.00
TS_IDX_T_EXP_W_228+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_228.dbf 4000.001.0000.00105000.00
TS_IDX_T_EXP_W_229+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_229.dbf 4000.001.0000.00403000.00
TS_IDX_T_EXP_W_230+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_230.dbf 4000.001.0000.0034000.00
TS_IDX_T_EXP_W_231+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_231.dbf 4000.001.0000.00144000.00
TS_IDX_T_EXP_W_232+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_232.dbf 4000.001.0000.0064000.00
TS_IDX_T_EXP_W_233+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_233.dbf 9203.701.0003.70280000.00
TS_IDX_T_EXP_W_234+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_234.dbf 4000.001.0000.0034000.00
TS_IDX_T_EXP_W_235+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_235.dbf 4000.001.0000.0091000.00
TS_IDX_T_EXP_W_236+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_236.dbf 4000.001.0000.0043000.00
TS_IDX_T_EXP_W_237+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_237.dbf 6703.281.0003.28166000.00
TS_IDX_T_EXP_W_238+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_238.dbf 5100.201.0000.2068000.00
TS_IDX_T_EXP_W_239+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_239.dbf 9203.481.0003.48114000.00
TS_IDX_T_EXP_W_240+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_240.dbf 4800.001.0000.00101000.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_01.dbf 33500.931.0000.9385,51424230.43
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_02.dbf 34100.911.0000.9485,8612480.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_03.dbf 40301.021.0000.9989,83225100.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_04.dbf 42400.941.0000.9488,36125110.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_05.dbf 36700.931.0000.9386,9702480.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_06.dbf 44201.001.0001.0086,12624200.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_07.dbf 40101.001.0000.9787,03324120.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_08.dbf 30300.921.0000.9682,9182360.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_09.dbf 53300.981.0000.9885,39124110.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_10.dbf 34100.941.0000.9485,7512470.00
TS_IDX_YTMDM+DATA_DG/dbquery/datafile/ts_idx_ytmdm.dbf 91905.931.0005.93977000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_01.dbf 4000.001.0000.008000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_02.dbf 4000.001.0000.008000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_03.dbf 4100.241.0000.248000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_04.dbf 4000.001.0000.008000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_05.dbf 4000.001.0000.008000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_06.dbf 4000.001.0000.008000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_07.dbf 4100.241.0000.248000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_08.dbf 4000.001.0000.008000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_09.dbf 4000.001.0000.008000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_10.dbf 4000.001.0000.008000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_01.dbf 4700.211.0000.21463000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_02.dbf 4800.421.0000.42265000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_03.dbf 4600.001.0000.00333000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_04.dbf 4900.411.0000.41311000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_05.dbf 4700.211.0000.21302000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_06.dbf 3800.001.0000.00397010.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_07.dbf 4200.951.6700.00478000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_08.dbf 3800.001.0000.00198000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_09.dbf 3900.001.0000.00161000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_10.dbf 3800.001.0000.00307000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_01.dbf 4000.001.0000.008000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_02.dbf 4800.001.0000.008000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_03.dbf 4800.001.0000.008000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_04.dbf 4800.001.0000.008000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_05.dbf 4800.001.0000.008000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_06.dbf 4800.001.0000.008000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_07.dbf 4800.001.0000.008000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_08.dbf 4800.001.0000.008000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_09.dbf 4800.001.0000.008000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_10.dbf 4800.001.0000.008000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_01.dbf 3900.001.0000.0054000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_02.dbf 3900.001.0000.0091000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_03.dbf 4000.251.0000.25149000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_04.dbf 3900.001.0000.0023000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_05.dbf 4600.001.0000.00280000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_06.dbf 4600.001.0000.0041000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_07.dbf 4800.211.0000.0094000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_08.dbf 4600.001.0000.0039000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_09.dbf 4600.001.0000.0090000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_10.dbf 4700.211.0000.21107000.00
TS_T_EXP_CONTAINER_161+DATA_DG/dbquery/datafile/ts_t_exp_container_161.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_162+DATA_DG/dbquery/datafile/ts_t_exp_container_162.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_163+DATA_DG/dbquery/datafile/ts_t_exp_container_163.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_164+DATA_DG/dbquery/datafile/ts_t_exp_container_164.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165_1.dbf 4000.001.0000.008000.00
TS_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165_2.dbf 4000.001.0000.008000.00
TS_T_EXP_CONTAINER_166+DATA_DG/dbquery/datafile/ts_t_exp_container_166.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_167+DATA_DG/dbquery/datafile/ts_t_exp_container_167.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_168+DATA_DG/dbquery/datafile/ts_t_exp_container_168.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_169+DATA_DG/dbquery/datafile/ts_t_exp_container_169.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_170+DATA_DG/dbquery/datafile/ts_t_exp_container_170.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_171+DATA_DG/dbquery/datafile/ts_t_exp_container_171.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_172+DATA_DG/dbquery/datafile/ts_t_exp_container_172.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_173+DATA_DG/dbquery/datafile/ts_t_exp_container_173.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_174+DATA_DG/dbquery/datafile/ts_t_exp_container_174.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_175+DATA_DG/dbquery/datafile/ts_t_exp_container_175.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_176+DATA_DG/dbquery/datafile/ts_t_exp_container_176.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_177+DATA_DG/dbquery/datafile/ts_t_exp_container_177.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_178+DATA_DG/dbquery/datafile/ts_t_exp_container_178.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_179+DATA_DG/dbquery/datafile/ts_t_exp_container_179.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_180+DATA_DG/dbquery/datafile/ts_t_exp_container_180.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_181+DATA_DG/dbquery/datafile/ts_t_exp_container_181.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_182+DATA_DG/dbquery/datafile/ts_t_exp_container_182.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_183+DATA_DG/dbquery/datafile/ts_t_exp_container_183.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_184+DATA_DG/dbquery/datafile/ts_t_exp_container_184.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_185+DATA_DG/dbquery/datafile/ts_t_exp_container_185.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_186+DATA_DG/dbquery/datafile/ts_t_exp_container_186.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_187+DATA_DG/dbquery/datafile/ts_t_exp_container_187.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_188+DATA_DG/dbquery/datafile/ts_t_exp_container_188.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_189+DATA_DG/dbquery/datafile/ts_t_exp_container_189.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_190+DATA_DG/dbquery/datafile/ts_t_exp_container_190.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_191+DATA_DG/dbquery/datafile/ts_t_exp_container_191.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_192+DATA_DG/dbquery/datafile/ts_t_exp_container_192.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_193+DATA_DG/dbquery/datafile/ts_t_exp_container_193.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_194+DATA_DG/dbquery/datafile/ts_t_exp_container_194.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_195+DATA_DG/dbquery/datafile/ts_t_exp_container_195.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_196+DATA_DG/dbquery/datafile/ts_t_exp_container_196.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_197+DATA_DG/dbquery/datafile/ts_t_exp_container_197.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_198+DATA_DG/dbquery/datafile/ts_t_exp_container_198.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_199+DATA_DG/dbquery/datafile/ts_t_exp_container_199.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_200+DATA_DG/dbquery/datafile/ts_t_exp_container_200.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_201+DATA_DG/dbquery/datafile/ts_t_exp_container_201.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_202+DATA_DG/dbquery/datafile/ts_t_exp_container_202.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_203+DATA_DG/dbquery/datafile/ts_t_exp_container_203.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_204+DATA_DG/dbquery/datafile/ts_t_exp_container_204.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_205+DATA_DG/dbquery/datafile/ts_t_exp_container_205.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_206+DATA_DG/dbquery/datafile/ts_t_exp_container_206.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_207+DATA_DG/dbquery/datafile/ts_t_exp_container_207.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_208+DATA_DG/dbquery/datafile/ts_t_exp_container_208.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_208+DATA_DG/dbquery/datafile/ts_t_exp_container_208_1.dbf 4000.001.0000.008000.00
TS_T_EXP_CONTAINER_209+DATA_DG/dbquery/datafile/ts_t_exp_container_209.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_210+DATA_DG/dbquery/datafile/ts_t_exp_container_210.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_211+DATA_DG/dbquery/datafile/ts_t_exp_container_211.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_212+DATA_DG/dbquery/datafile/ts_t_exp_container_212.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_213+DATA_DG/dbquery/datafile/ts_t_exp_container_213.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_214+DATA_DG/dbquery/datafile/ts_t_exp_container_214.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_215+DATA_DG/dbquery/datafile/ts_t_exp_container_215.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_216+DATA_DG/dbquery/datafile/ts_t_exp_container_216.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_217+DATA_DG/dbquery/datafile/ts_t_exp_container_217.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_218+DATA_DG/dbquery/datafile/ts_t_exp_container_218.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_219+DATA_DG/dbquery/datafile/ts_t_exp_container_219.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_220+DATA_DG/dbquery/datafile/ts_t_exp_container_220.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_221+DATA_DG/dbquery/datafile/ts_t_exp_container_221.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_222+DATA_DG/dbquery/datafile/ts_t_exp_container_222.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_223+DATA_DG/dbquery/datafile/ts_t_exp_container_223.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_224+DATA_DG/dbquery/datafile/ts_t_exp_container_224.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_225+DATA_DG/dbquery/datafile/ts_t_exp_container_225.dbf 700.001.0000.007000.00
TS_T_EXP_CONTAINER_226+DATA_DG/dbquery/datafile/ts_t_exp_container_226.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_227+DATA_DG/dbquery/datafile/ts_t_exp_container_227.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_228+DATA_DG/dbquery/datafile/ts_t_exp_container_228.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_229+DATA_DG/dbquery/datafile/ts_t_exp_container_229.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_230+DATA_DG/dbquery/datafile/ts_t_exp_container_230.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_231+DATA_DG/dbquery/datafile/ts_t_exp_container_231.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_232+DATA_DG/dbquery/datafile/ts_t_exp_container_232.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_233+DATA_DG/dbquery/datafile/ts_t_exp_container_233.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_234+DATA_DG/dbquery/datafile/ts_t_exp_container_234.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_235+DATA_DG/dbquery/datafile/ts_t_exp_container_235.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_236+DATA_DG/dbquery/datafile/ts_t_exp_container_236.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_237+DATA_DG/dbquery/datafile/ts_t_exp_container_237.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_238+DATA_DG/dbquery/datafile/ts_t_exp_container_238.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_239+DATA_DG/dbquery/datafile/ts_t_exp_container_239.dbf 1400.001.0000.007000.00
TS_T_EXP_CONTAINER_240+DATA_DG/dbquery/datafile/ts_t_exp_container_240.dbf 1400.001.0000.007000.00
TS_T_EXP_W_160+DATA_DG/dbquery/datafile/ts_t_exp_w_160.dbf 4300.001.0000.008000.00
TS_T_EXP_W_161+DATA_DG/dbquery/datafile/ts_t_exp_w_161.dbf 4300.001.0000.008000.00
TS_T_EXP_W_162+DATA_DG/dbquery/datafile/ts_t_exp_w_162.dbf 4300.001.0000.008000.00
TS_T_EXP_W_163+DATA_DG/dbquery/datafile/ts_t_exp_w_163.dbf 4300.001.0000.008000.00
TS_T_EXP_W_164+DATA_DG/dbquery/datafile/ts_t_exp_w_164.dbf 4300.001.0000.008000.00
TS_T_EXP_W_165+DATA_DG/dbquery/datafile/ts_t_exp_w_165.dbf 4300.001.0000.008000.00
TS_T_EXP_W_166+DATA_DG/dbquery/datafile/ts_t_exp_w_166.dbf 4300.001.0000.008000.00
TS_T_EXP_W_167+DATA_DG/dbquery/datafile/ts_t_exp_w_167.dbf 4300.001.0000.008000.00
TS_T_EXP_W_168+DATA_DG/dbquery/datafile/ts_t_exp_w_168.dbf 3700.271.0000.278000.00
TS_T_EXP_W_169+DATA_DG/dbquery/datafile/ts_t_exp_w_169.dbf 3600.001.0000.008000.00
TS_T_EXP_W_170+DATA_DG/dbquery/datafile/ts_t_exp_w_170.dbf 3600.001.0000.008000.00
TS_T_EXP_W_171+DATA_DG/dbquery/datafile/ts_t_exp_w_171.dbf 3600.001.0000.008000.00
TS_T_EXP_W_172+DATA_DG/dbquery/datafile/ts_t_exp_w_172.dbf 3600.001.0000.008000.00
TS_T_EXP_W_173+DATA_DG/dbquery/datafile/ts_t_exp_w_173.dbf 3600.001.0000.008000.00
TS_T_EXP_W_174+DATA_DG/dbquery/datafile/ts_t_exp_w_174.dbf 3600.001.0000.008000.00
TS_T_EXP_W_175+DATA_DG/dbquery/datafile/ts_t_exp_w_175.dbf 3600.001.0000.008000.00
TS_T_EXP_W_176+DATA_DG/dbquery/datafile/ts_t_exp_w_176.dbf 3600.001.0000.008000.00
TS_T_EXP_W_177+DATA_DG/dbquery/datafile/ts_t_exp_w_177.dbf 3600.001.0000.008000.00
TS_T_EXP_W_178+DATA_DG/dbquery/datafile/ts_t_exp_w_178.dbf 3600.001.0000.008000.00
TS_T_EXP_W_179+DATA_DG/dbquery/datafile/ts_t_exp_w_179.dbf 3600.001.0000.008000.00
TS_T_EXP_W_180+DATA_DG/dbquery/datafile/ts_t_exp_w_180.dbf 4400.001.0000.008000.00
TS_T_EXP_W_181+DATA_DG/dbquery/datafile/ts_t_exp_w_181.dbf 4400.001.0000.008000.00
TS_T_EXP_W_182+DATA_DG/dbquery/datafile/ts_t_exp_w_182.dbf 4400.001.0000.008000.00
TS_T_EXP_W_183+DATA_DG/dbquery/datafile/ts_t_exp_w_183.dbf 4400.001.0000.008000.00
TS_T_EXP_W_184+DATA_DG/dbquery/datafile/ts_t_exp_w_184.dbf 4400.001.0000.008000.00
TS_T_EXP_W_185+DATA_DG/dbquery/datafile/ts_t_exp_w_185.dbf 4400.001.0000.008000.00
TS_T_EXP_W_186+DATA_DG/dbquery/datafile/ts_t_exp_w_186.dbf 4400.001.0000.008000.00
TS_T_EXP_W_187+DATA_DG/dbquery/datafile/ts_t_exp_w_187.dbf 4400.001.0000.008000.00
TS_T_EXP_W_188+DATA_DG/dbquery/datafile/ts_t_exp_w_188.dbf 4400.001.0000.008000.00
TS_T_EXP_W_189+DATA_DG/dbquery/datafile/ts_t_exp_w_189.dbf 4400.001.0000.008000.00
TS_T_EXP_W_190+DATA_DG/dbquery/datafile/ts_t_exp_w_190.dbf 4400.001.0000.008000.00
TS_T_EXP_W_191+DATA_DG/dbquery/datafile/ts_t_exp_w_191.dbf 3700.001.0000.008000.00
TS_T_EXP_W_192+DATA_DG/dbquery/datafile/ts_t_exp_w_192.dbf 3700.001.0000.008000.00
TS_T_EXP_W_193+DATA_DG/dbquery/datafile/ts_t_exp_w_193.dbf 3700.001.0000.008000.00
TS_T_EXP_W_194+DATA_DG/dbquery/datafile/ts_t_exp_w_194.dbf 3700.001.0000.008000.00
TS_T_EXP_W_195+DATA_DG/dbquery/datafile/ts_t_exp_w_195.dbf 3700.001.0000.008000.00
TS_T_EXP_W_196+DATA_DG/dbquery/datafile/ts_t_exp_w_196.dbf 3700.001.0000.008000.00
TS_T_EXP_W_197+DATA_DG/dbquery/datafile/ts_t_exp_w_197.dbf 3700.001.0000.008000.00
TS_T_EXP_W_198+DATA_DG/dbquery/datafile/ts_t_exp_w_198.dbf 3700.001.0000.008000.00
TS_T_EXP_W_199+DATA_DG/dbquery/datafile/ts_t_exp_w_199.dbf 3700.001.0000.008000.00
TS_T_EXP_W_200+DATA_DG/dbquery/datafile/ts_t_exp_w_200.dbf 3800.261.0000.268000.00
TS_T_EXP_W_201+DATA_DG/dbquery/datafile/ts_t_exp_w_201.dbf 3700.001.0000.008000.00
TS_T_EXP_W_202+DATA_DG/dbquery/datafile/ts_t_exp_w_202.dbf 3700.001.0000.008000.00
TS_T_EXP_W_203+DATA_DG/dbquery/datafile/ts_t_exp_w_203.dbf 4500.001.0000.008000.00
TS_T_EXP_W_204+DATA_DG/dbquery/datafile/ts_t_exp_w_204.dbf 4500.001.0000.008000.00
TS_T_EXP_W_205+DATA_DG/dbquery/datafile/ts_t_exp_w_205.dbf 4500.001.0000.008000.00
TS_T_EXP_W_206+DATA_DG/dbquery/datafile/ts_t_exp_w_206.dbf 4500.001.0000.008000.00
TS_T_EXP_W_207+DATA_DG/dbquery/datafile/ts_t_exp_w_207.dbf 4500.001.0000.008000.00
TS_T_EXP_W_208+DATA_DG/dbquery/datafile/ts_t_exp_w_208.dbf 4500.001.0000.008000.00
TS_T_EXP_W_209+DATA_DG/dbquery/datafile/ts_t_exp_w_209.dbf 4500.001.0000.008000.00
TS_T_EXP_W_210+DATA_DG/dbquery/datafile/ts_t_exp_w_210.dbf 4500.001.0000.008000.00
TS_T_EXP_W_211+DATA_DG/dbquery/datafile/ts_t_exp_w_211.dbf 4500.001.0000.008000.00
TS_T_EXP_W_212+DATA_DG/dbquery/datafile/ts_t_exp_w_212.dbf 4500.001.0000.008000.00
TS_T_EXP_W_213+DATA_DG/dbquery/datafile/ts_t_exp_w_213.dbf 4500.001.0000.008000.00
TS_T_EXP_W_214+DATA_DG/dbquery/datafile/ts_t_exp_w_214.dbf 3800.001.0000.008000.00
TS_T_EXP_W_215+DATA_DG/dbquery/datafile/ts_t_exp_w_215.dbf 3800.001.0000.008000.00
TS_T_EXP_W_216+DATA_DG/dbquery/datafile/ts_t_exp_w_216.dbf 3800.001.0000.008000.00
TS_T_EXP_W_217+DATA_DG/dbquery/datafile/ts_t_exp_w_217.dbf 3800.001.0000.008000.00
TS_T_EXP_W_218+DATA_DG/dbquery/datafile/ts_t_exp_w_218.dbf 3800.001.0000.008000.00
TS_T_EXP_W_219+DATA_DG/dbquery/datafile/ts_t_exp_w_219.dbf 3800.001.0000.008000.00
TS_T_EXP_W_220+DATA_DG/dbquery/datafile/ts_t_exp_w_220.dbf 3800.001.0000.008000.00
TS_T_EXP_W_221+DATA_DG/dbquery/datafile/ts_t_exp_w_221.dbf 3800.001.0000.008000.00
TS_T_EXP_W_222+DATA_DG/dbquery/datafile/ts_t_exp_w_222.dbf 3800.001.0000.008000.00
TS_T_EXP_W_223+DATA_DG/dbquery/datafile/ts_t_exp_w_223.dbf 3800.001.0000.008000.00
TS_T_EXP_W_224+DATA_DG/dbquery/datafile/ts_t_exp_w_224.dbf 3800.001.0000.008000.00
TS_T_EXP_W_225+DATA_DG/dbquery/datafile/ts_t_exp_w_225.dbf 3800.001.0000.008000.00
TS_T_EXP_W_226+DATA_DG/dbquery/datafile/ts_t_exp_w_226.dbf 4600.001.0000.008000.00
TS_T_EXP_W_227+DATA_DG/dbquery/datafile/ts_t_exp_w_227.dbf 4600.001.0000.008000.00
TS_T_EXP_W_228+DATA_DG/dbquery/datafile/ts_t_exp_w_228.dbf 4600.001.0000.008000.00
TS_T_EXP_W_229+DATA_DG/dbquery/datafile/ts_t_exp_w_229.dbf 4600.001.0000.008000.00
TS_T_EXP_W_230+DATA_DG/dbquery/datafile/ts_t_exp_w_230.dbf 4600.221.0000.008000.00
TS_T_EXP_W_231+DATA_DG/dbquery/datafile/ts_t_exp_w_231.dbf 4600.001.0000.008000.00
TS_T_EXP_W_232+DATA_DG/dbquery/datafile/ts_t_exp_w_232.dbf 4600.001.0000.008000.00
TS_T_EXP_W_233+DATA_DG/dbquery/datafile/ts_t_exp_w_233.dbf 4600.001.0000.008000.00
TS_T_EXP_W_234+DATA_DG/dbquery/datafile/ts_t_exp_w_234.dbf 4600.001.0000.008000.00
TS_T_EXP_W_235+DATA_DG/dbquery/datafile/ts_t_exp_w_235.dbf 4600.001.0000.008000.00
TS_T_EXP_W_236+DATA_DG/dbquery/datafile/ts_t_exp_w_236.dbf 4600.001.0000.008000.00
TS_T_EXP_W_237+DATA_DG/dbquery/datafile/ts_t_exp_w_237.dbf 3900.001.0000.008000.00
TS_T_EXP_W_238+DATA_DG/dbquery/datafile/ts_t_exp_w_238.dbf 3900.001.0000.008000.00
TS_T_EXP_W_239+DATA_DG/dbquery/datafile/ts_t_exp_w_239.dbf 3900.001.0000.008000.00
TS_T_EXP_W_240+DATA_DG/dbquery/datafile/ts_t_exp_w_240.dbf 3900.001.0000.008000.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_01.dbf 4500.891.0000.8937,6631000.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_02.dbf 4200.241.0000.2439,7031130.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_03.dbf 4504.441.0004.4434,9731000.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_04.dbf 5301.321.0001.3237,6911000.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_05.dbf 5502.361.0002.3632,418900.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_06.dbf 5101.181.0001.3725,223710.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_07.dbf 5301.891.0001.8922,619610.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_08.dbf 5400.741.0000.9323,825740.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_09.dbf 5000.801.0000.8029,238800.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_10.dbf 5402.041.0002.0434,056910.00
TS_YTMDM+DATA_DG/dbquery/datafile/ts_ytmdb.dbf 62805.511.0005.511,674000.00
TS_YTMDM+DATA_DG/dbquery/datafile/ts_ytmdb1.dbf 11603.881.0003.88480000.00
UNDOTBS1+DATA_DG/dbquery/datafile/undotbs1.263.828812057 700.001.0000.0010,01431190.08
USERS+DATA_DG/dbquery/datafile/users.265.828812065 700.001.0000.007000.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,733,869100639,689,97752,4931,902,24600360


Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00001,902,1820


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
B077181854547656356142141472003561421   
E060136815384600205686241472002056862   


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.33392,3411716555.00
D29,6960.193,6581.58266,1971374813.00
D44,5440.295,4881.37230,3091277587.00
D59,3920.397,3171.27214,1511233814.00
D74,2400.489,1461.21202,8551203211.00
D89,0880.5810,9751.15193,7471178535.00
D103,9360.6812,8051.11186,6841159400.00
D118,7840.7814,6341.06179,0611138748.00
D133,6320.8716,4631.03173,1081122621.00
D148,4800.9718,2921.01169,3001112305.00
D153,0881.0018,8601.00168,3261109667.00
D163,3281.0720,1220.98164,9451100506.00
D178,1761.1621,9510.96162,289193312.00
D193,0241.2623,7800.95159,692186276.00
D207,8721.3625,6090.93157,035179078.00
D222,7201.4527,4380.92154,759172913.00
D237,5681.5529,2680.91153,203168698.00
D252,4161.6531,0970.90151,819164947.00
D267,2641.7532,9260.90150,944162577.00
D282,1121.8434,7550.89150,223160623.00
D296,9601.9436,5850.89149,065157485.00


Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.003260


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,44053,3812,818.730.000.000.000.001,048,576
E61,44053,4002,764.270.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
2K4K11,51911,51900
64K128K363600
128K256K2200
256K512K2200
512K1024K777700
1M2M13713700
2M4M131300
4M8M5500


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,173,144.525,296.81100.00032,585,301
15,3600.251,173,144.525,296.81100.00032,585,301
30,7200.501,173,144.525,296.81100.00032,585,301
46,0800.751,173,144.525,296.81100.00032,585,301
61,4401.001,173,144.525,296.81100.00032,585,301
73,7281.201,173,144.522,351.22100.00032,503,852
86,0161.401,173,144.522,351.22100.00032,503,852
98,3041.601,173,144.522,351.22100.00032,503,852
110,5921.801,173,144.522,351.22100.00032,503,852
122,8802.001,173,144.522,351.22100.00032,503,852
184,3203.001,173,144.522,351.22100.00032,503,852
245,7604.001,173,144.522,351.22100.00032,503,852
368,6406.001,173,144.522,351.22100.00032,503,852
491,5208.001,173,144.522,351.22100.00032,503,852


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)
5,6320.7353914,6681,855,3750.69838,75145.39289,091
6,1440.801,04825,4342,671,8311.0022,2951.21435,492
6,6560.871,56035,8272,674,6311.0019,4951.06436,186
7,1680.932,07251,2442,675,1631.0018,9631.03436,333
7,6801.002,58464,0852,675,6491.0018,4771.00436,958
8,1921.073,09674,5882,676,3591.0017,7670.96437,171
8,7041.133,60886,7522,676,4461.0017,6800.96437,194
9,2161.204,12099,6312,676,5241.0017,6020.95437,213
9,7281.274,631114,5792,676,5831.0017,5430.95437,228
10,2401.335,142129,0052,676,6331.0017,4930.95437,240
10,7521.405,654144,1812,676,6641.0017,4620.95437,249
11,2641.476,166159,4682,676,6871.0017,4390.94437,253
11,7761.536,678175,0052,676,6991.0017,4270.94437,255
12,2881.607,190191,2532,676,7081.0017,4180.94437,258
12,8001.677,702207,5012,676,7191.0017,4070.94437,260
13,8241.808,726239,9982,676,7441.0017,3820.94437,265
14,8481.939,750272,4952,676,7861.0017,3400.94437,271
15,8722.0710,774304,9922,676,7961.0017,3300.94437,272


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 block23300
undo header11900
1st level bmb800


Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (allocate ITL entry) 23176149650.00
TX-Transaction (row lock contention) 86860246239.17
CF-Controlfile Transaction 2,0462,0460405.00
TX-Transaction (index contention) 3,8993,89903700.00
CI-Cross-Instance Call Invocation 14140200.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
2133.52258,8721,1001520.3/31.40/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
18-Feb 09:5917,58839,40649713200/00/0/0/0/0/0
18-Feb 09:4918,34834,6611,10011310/00/0/0/0/0/0
18-Feb 09:3921,02138,29649715210/00/0/0/0/0/0
18-Feb 09:2921,83941,4331,10013310/00/0/0/0/0/0
18-Feb 09:1926,74649,38849915210/00/0/0/0/0/0
18-Feb 09:0927,97555,6881,10011310/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 latch560.00 00 
AQ dequeue txn counter latch100.00 00 
AQ disk delete txn counter latch100.00 00 
ASM Keyed state latch3,8150.00 00 
ASM allocation8720.00 00 
ASM db client latch3,0710.00 00 
ASM map headers3750.00 00 
ASM map load waiting list930.00 00 
ASM map operation freelist4200.00 00 
ASM map operation hash table3,545,7840.000.0000 
ASM network background latch2,3710.040.0000 
ASM network state latch9490.00 00 
AWR Alerted Metric Element list88,4660.00 00 
Change Notification Hash table latch1,2010.00 00 
Consistent RBA239,3570.010.0000 
DML lock allocation1,572,0070.000.0500 
Event Group Locks3,8890.00 00 
FAL Queue1590.00 00 
FIB s.o chain latch780.00 00 
FOB s.o list latch10,0610.040.0000 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch3,327,2580.010.820339,3370.00
JS Sh mem access70.00 00 
JS mem alloc latch40.00 00 
JS queue access latch50.00 00 
JS queue state obj latch26,1340.00 00 
JS slv state obj latch2410.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KFK SGA Libload latch1,0880.00 00 
KFMD SGA50.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 
KMG MMAN ready and startup request latch1,2000.00 00 
KTF sga latch240.00 01,2130.00
KWQMN job cache list latch260.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch190.00 00 
KWQS pqueue ctx latch1070.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch2,1740.00 00 
MQL Tracking Latch0  0720.00
Memory Management Latch10.00 01,2000.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 Latch400.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process8,3060.00 00 
OS process allocation11,5250.00 00 
OS process: request allocation3,8150.00 00 
PL/SQL warning settings2,5220.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch78,4200.00 00 
Reserved Space Latch280.00 00 
Result Cache: RC Latch233,1540.010.0000 
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 01,1980.00
SQL memory manager workarea list latch102,1100.00 00 
Shared B-Tree4200.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,320,1240.640.0200 
active service list13,9180.050.1403,5560.00
alert log latch140.00 00 
archive control3290.00 00 
archive process latch4850.621.0000 
begin backup scn array10.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles36,4190.000.0000 
cache buffers chains1,315,426,2820.240.000190,1630.00
cache buffers lru chain2,032,0990.000.2802,241,5950.00
cache table scan latch30.00 030.00
call allocation10,2800.540.5600 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch3,8300.00 00 
channel operations parent latch37,5940.00 00 
checkpoint queue latch35,117,1310.000.0101,850,1580.00
client/application info3,6100.00 00 
compile environment latch1,9780.00 00 
corrupted undo seg latch319,3400.000.0000 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch570.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch570.00 00 
dml lock allocation3130.00 00 
done queue latch10.00 00 
dummy allocation3,9520.030.0000 
eighth spare latch - X parent10.00 00 
eleventh spare latch - children10.00 00 
enqueue freelist latch10.00 0545,7290.00
enqueue hash chains2,647,0300.010.01070.00
fifteenth spare latch - children10.00 00 
file cache latch8,9200.00 00 
first Audit Vault latch1540.650.0000 
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 SGA1580.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch1,0110.00 018,6230.00
hash table modification latch4310.00 00 
heartbeat check10.00 00 
internal temp table object number allocation latch60.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch690.00 0681.47
job_queue_processes free list latch1400.00 00 
job_queue_processes parameter latch8510.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch70.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch80.00 00 
krbmrosl500.00 00 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock330.00 00 
ksuosstats global area3630.00 00 
ksv allocation latch1210.00 00 
ksv class latch4,0350.300.0000 
ksv instance latch300.00 00 
ksv msg queue latch620.00 0610.00
ksz_so allocation latch3,8150.00 00 
ktm global data2,2200.00 00 
kwqbsn:qsga1400.00 00 
lgwr LWN SCN240,3840.050.0000 
list of block allocation203,0740.000.0000 
loader state object freelist2,0780.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch130.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 parent10.00 00 
managed standby latch1520.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch1,9900.00 00 
messages3,406,4810.290.0000 
mostly latch-free SCN243,2880.880.0000 
msg queue latch10.00 00 
multiblock read objects80.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch570.00 00 
nineth spare latch - X parent10.00 00 
object queue header heap38,2530.00 037,1940.00
object queue header operation6,175,9330.030.1600 
object stats modification54,2990.002.0000 
parallel query alloc buffer2,4010.00 00 
parallel query stats10.00 00 
parameter list6,8600.00 00 
parameter table management4,9850.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue10,6772.400.00015,8662.20
process allocation3,9510.051.0001,9100.00
process group creation3,8150.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch5210.00 00 
query server freelists10.00 00 
queued dump request120.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation2,148,7230.160.0106,323,9630.24
redo copy10.00 06,329,0490.11
redo writing2,058,6630.320.0100 
reservation so alloc latch140.00 00 
resmgr group change latch3080.00 00 
resmgr:active threads3,9520.00 00 
resmgr:actses change group2510.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list3,9510.030.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 objects1,489,4800.010.0105390.00
rules engine rule set statistics1000.00 00 
second Audit Vault latch10.00 00 
segmented array pool680.00 00 
sequence cache5,7280.00 00 
session allocation525,8770.000.000521,9620.00
session idle bit6,516,5650.000.0000 
session queue latch10.00 00 
session state list latch8960.00 00 
session switching1,9630.00 00 
session timer1,1980.00 00 
seventh spare latch - X parent10.00 00 
shared pool446,0010.060.0501,3780.00
shared pool sim alloc230.00 00 
shared pool simulator7,7300.00 00 
sim partition latch10.00 00 
simulator hash latch39,705,1710.000.0100 
simulator lru latch221,4960.010.00039,473,7791.69
sixth spare latch - X parent10.00 00 
sort extent pool6370.00 00 
space background state object latch20.00 00 
space background task latch27,46012.470.1402,7980.57
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation40.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,1760.00 00 
transaction allocation8,3670.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 data1,651,8150.000.0000 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 
write info latch0  0239,3060.00


Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains1,315,426,2823,132,009243,133,293
messages3,406,4819,939469,894
active checkpoint queue latch1,320,1248,4631368,328
redo writing2,058,6636,566816,485
space background task latch27,4603,4254762,950
redo allocation2,148,7233,331483,283
mostly latch-free SCN243,2882,13762,131
object queue header operation6,175,9331,5962601,344
checkpoint queue latch35,117,1314405435
shared pool446,00126114248
post/wait queue10,6772561255
simulator hash latch39,705,1712352233
row cache objects1,489,4802123209
In memory undo latch3,327,25818615339
enqueue hash chains2,647,0301741173
cache buffers lru chain2,032,099571641
call allocation10,280553128
DML lock allocation1,572,00722121
active service list13,918716
archive process latch485330
process allocation3,951220
object stats modification54,299120


Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
DML lock allocationktaiam011
In memory undo latchktiFlush: child012333
In memory undo latchkticmt: child02625
In memory undo latchktiFlushMe062
In memory undo latchktichg: child0196
PC and Classifier lists for WLMNo latch050
active checkpoint queue latchkcbbacq: scan active checkpoints0136136
active service listkswslogon: session logout011
archive process latchkcrrsarc030
cache buffers chainskcbgtcr: fast path0190
cache buffers chainskcbbxsv020
cache buffers chainskcbget: pin buffer021
cache buffers chainskcbgcur_2010
cache buffers chainskcbgtcr: fast path (cr pin)014
cache buffers chainskcbnew: new latch again010
cache buffers chainskcbzwb010
cache buffers lru chainkcbzgws0120
cache buffers lru chainkcbzgb021
cache buffers lru chainkcbo_link_q010
cache buffers lru chainkcbzswcu010
call allocationksuxds02012
call allocationksudlp: top call01118
checkpoint queue latchkcbkubc_4041
checkpoint queue latchkcbbcthc: check thread queue010
enqueue hash chainsksqrcl010
lgwr LWN SCNkcs023060
messagesksarcv0269
messagesksaamb: after wakeup01833
messagesksarcv: after wait024
object queue header operationkcbo_switch_cq0204115
object queue header operationkcbo_switch_q_bg05157
object queue header operationkcbo_switch_mq_bg01382
object queue header operationkcbo_link_q0127
object queue header operationkcbo_unlink_q078
object stats modificationksols_rank020
post/wait queueksliwat:remove011
process allocationksucrp:1020
redo allocationkcrfw_redo_gen: redo allocation 10460
redo allocationkcrfw_redo_gen: redo allocation 2010
redo allocationkcrfw_redo_write: before write017
redo writingkcrfwcr07677
redo writingkcrfw_post: rba scn pair040
redo writingkcrfw_cal_target_rba010
row cache objectskqreqd: reget030
shared poolkghalo0136
shared poolkghalp010
simulator hash latchkcbsacc: lookup dba022
space background task latchktsj_grab_task0469475
space background task latchktsj_detach_task021


Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpndl1 95690
Library Cachekgllkdl1 85260
Library Cachekglhdgn1 62180
Library Cachekglhdgn2 106130
Library Cachekgllkc1 5790
Cursor Pinkkslce [KKSCHLPIN2]90
Cursor Pinkksfbc [KKSCHLPIN1]50
Library Cachekglpnal1 9040
Library Cachekglhdgh1 6420
Library Cachekglpin1 420
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]20
Cursor ParentkkscsPruneChild [KKSPRTLOC35]20
Library CachekglReleaseHandleReference 12510
Library Cachekglget1 110
Cursor PinkksLockDelete [KKSCHLPIN6]10
hash tablekkshGetNextChild [KKSHBKLOC1]10


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
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_161PAR_2014_02_17TABLE PARTITION108,468,09616.94
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_161PAR_2014_02_15TABLE PARTITION97,355,93615.21
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_161PAR_2014_02_16TABLE PARTITION83,677,92013.07
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_16TABLE PARTITION78,245,16812.22
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_17TABLE PARTITION78,026,36812.19


Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_02 INDEX2010.29
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_03 INDEX1160.17
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_05 INDEX860.13
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_202_02 INDEX820.12
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_175_02 INDEX720.10


Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_02 INDEX2010.29
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_03 INDEX1160.17
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_05 INDEX860.13
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_202_02 INDEX820.12
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_175_02 INDEX720.10


Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_02 INDEX2010.29
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_03 INDEX1160.17
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_05 INDEX860.13
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_202_02 INDEX820.12
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_175_02 INDEX720.10


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_CONTAINERPK_EXP_CONTAINER_165PAR_2014_02_18INDEX PARTITION24,9301.31
YTEXPTS_YTEXPT_EXP_TAKING_STATUS_161 TABLE19,9161.04
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_03 INDEX19,6671.03
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_215 TABLE14,1020.74
YTEXPTS_IDX_YTEXPUK_EXP_DELIVERY_STATUS_165 INDEX12,9990.68


Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
YTEXPTS_YTEXPT_EXP_TAKING_STATUS_161 TABLE15,3201.17
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_03 INDEX14,4181.10
YTEXPTS_IDX_YTEXPUK_EXP_DELIVERY_STATUS_165 INDEX11,3090.86
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_215 TABLE8,3720.64
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_05 INDEX7,2030.55


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_YTEXPIDX_EXP_DELIVERY_STATUS_215_02 INDEX73,0886.72
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_03 INDEX56,4965.19
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_215 TABLE54,8325.04
YTEXPTS_IDX_CONTAINERPK_EXP_CONTAINER_165PAR_2014_02_18INDEX PARTITION45,5044.18
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_202_02 INDEX34,5123.17


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_215_02 INDEX18713.41
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_202_02 INDEX906.45
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_175_02 INDEX795.66
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_161_02 INDEX725.16
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_186_02 INDEX594.23


Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_175 TABLE440.00
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_186 TABLE220.00
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_215 TABLE220.00
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_188 TABLE110.00
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_217 TABLE110.00


Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYSSYSTEMAUD$ TABLE7247.37
YTEXPTS_IDX_CONTAINERIDX1_EXP_CONTAINER_165PAR_2014_02_18INDEX PARTITION117.24
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_229_02 INDEX106.58
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_175_02 INDEX85.26
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_188_02 INDEX85.26


Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control650.000 21
dc_files4770.000 0477
dc_global_oids2326.900 012
dc_histogram_data6,1030.850 025,801
dc_histogram_defs11,2150.290 056,365
dc_object_grants220.000 019
dc_objects136,1430.020 59,678
dc_profiles3860.000 01
dc_rollback_segments3,9770.000 067
dc_segments69,9860.200 1,17853,976
dc_sequences80.000 89
dc_tablespaces120,6090.000 0344
dc_users154,9570.000 0513
global database name2,6510.000 01
outstanding_alerts2,0480.000 0342
sch_lj_oids4100.000 00



Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS4741.050 00
BODY1,1271.862,0101.0900
CLUSTER277.41296.9000
DBLINK2,1000.000 00
EDITION2490.004750.0000
INDEX135,7500.003,4878.572940
QUEUE1040.009860.0000
SCHEMA1,9320.000 00
SQL AREA241,9150.151,870,4350.272,1210
SQL AREA BUILD2,57113.920 00
SQL AREA STATS2,30156.672,30156.6700
SUBSCRIPTION70.0070.0000
TABLE/PROCEDURE159,0930.03122,7730.914680
TRIGGER1870.002410.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 cache152,064.00152,064.00152,064.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 pool7,680.007,680.006,144.007,680.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
BOther2,489.52 3.173.404444785785
Freeable312.060.000.650.787 477477
SQL15.071.360.020.01020755746
PL/SQL2.531.070.000.0201783783
EOther2,442.69 3.093.364444790790
Freeable304.500.000.670.888 453453
SQL15.011.410.020.01020760751
PL/SQL2.541.050.000.0201788788


Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers159,450,660,864 
Fixed Size2,265,864 
Redo Buffers112,762,880 
Variable Size54,223,965,432 

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,016.211,024.570.82
sharedKGLHD89.3789.01-0.40
sharedPRTMV99.11100.181.08
sharedSQLA2,208.292,197.88-0.47
shareddb_block_hash_buckets1,424.001,424.000.00
sharedfree memory403.06405.190.53
sharedobject queue461.54461.540.00
streamsfree memory511.37511.370.00
 buffer_cache152,064.00152,064.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:190.150.010.00
QMON Coordinator0203 15:50:080.080.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

No data exists for this section of the report.

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) 00  0.000.00  
SYS.AQ$_ALERT_QT_E(13068) 500.000.000.000.000.000.00
SYSMAN.MGMT_TASK_Q(77312) 61610.000.000.010.050.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.00  
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 0050.000.000.00
NGMYSQLDB87_3872_IDBQUERY4(41)/SYS.ALERT_QUE 0050.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 %
3,6010.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.003,6010.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_size159450660864  
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_size8053063680  
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