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:293517-Feb-14 09:00:53678 2.7
End Snap:293617-Feb-14 10:00:55689 2.7
Elapsed:  60.03 (mins)  
DB Time:  32.68 (mins)  

Report Summary

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 0.5 0.0 0.00 0.00
DB CPU(s): 0.5 0.0 0.00 0.00
Redo size (bytes): 772,520.7 7,280.9  
Logical read (blocks): 75,535.3 711.9  
Block changes: 4,463.5 42.1  
Physical read (blocks): 24.5 0.2  
Physical write (blocks): 645.4 6.1  
Read IO requests: 24.3 0.2  
Write IO requests: 434.9 4.1  
Read IO (MB): 0.2 0.0  
Write IO (MB): 5.0 0.1  
User calls: 952.4 9.0  
Parses (SQL): 408.1 3.9  
Hard parses (SQL): 0.7 0.0  
SQL Work Area (MB): 0.4 0.0  
Logons: 0.5 0.0  
Executes (SQL): 425.2 4.0  
Rollbacks: 43.3 0.4  
Transactions: 106.1   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.97In-memory Sort %: 100.00
Library Hit %: 99.63Soft Parse %: 99.82
Execute to Parse %: 4.02Latch Hit %: 99.93
Parse CPU to Parse Elapsd %: 38.15% Non-Parse CPU: 98.98

Top 10 Foreground Events by Total Wait Time

EventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Class
DB CPU 1670.6 85.2 
db file sequential read69,721186.539.5User I/O
log file sync221,861150.517.7Commit
SQL*Net break/reset to client231,36063.303.2Application
enq: TX - row lock contention9915.3155.8Application
read by other session4,5674.41.2User I/O
SQL*Net message to client2,039,2304.10.2Network
control file sequential read12,8431.50.1System I/O
enq: TX - allocate ITL entry31.1379.1Configuration
undo segment extension78.57.0Configuration

Wait Classes by Total Wait Time

Wait ClassWaitsTotal Wait Time (sec)Avg Wait (ms)% DB timeAvg Active Sessions
DB CPU 1,671 85.20.5
System I/O3,403,083272013.90.1
User I/O79,61419229.80.1
Commit221,86315117.70.0
Application231,4597904.00.0
Other12,55150.20.0
Network2,045,79740.20.0
Concurrency2,00731.20.0
Configuration19229.10.0

Host CPU

CPUsCoresSocketsLoad Average BeginLoad Average End%User%System%WIO%Idle
80 40 4 2.75 2.14 0.6 0.2 0.1 99.2

Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
0.8 88.7 0.0

IO Profile

Read+Write Per SecondRead per SecondWrite Per Second
Total Requests: 545.8 31.8 514.0
Database Requests: 459.3 24.3 434.9
Optimized Requests: 0.0 0.0 0.0
Redo Requests: 77.3 0.8 76.5
Total (MB): 7.8 1.1 6.7
Database (MB): 5.2 0.2 5.0
Optimized Total (MB): 0.0 0.0 0.0
Redo (MB): 1.5 0.8 0.8
Database (blocks): 669.9 24.5 645.4
Via Buffer Cache (blocks): 663.7 19.5 644.2
Direct (blocks): 6.3 5.1 1.2

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,593.9 2,684.0
% Host Mem used for SGA+PGA: 53.27 53.30

Cache Sizes

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

Shared Pool Statistics

BeginEnd
Memory Usage %: 93.48 93.46
% SQL with executions>1: 95.99 95.71
% Memory for SQL w/exec>1: 97.00 97.82

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU1,670.6285.21
sql execute elapsed time1,335.0368.09
parse time elapsed67.983.47
hard parse elapsed time11.690.60
PL/SQL execution elapsed time10.310.53
hard parse (sharing criteria) elapsed time7.620.39
hard parse (bind mismatch) elapsed time4.930.25
connection management call elapsed time1.850.09
inbound PL/SQL rpc elapsed time1.110.06
PL/SQL compilation elapsed time0.100.01
RMAN cpu time (backup/restore)0.030.00
failed parse elapsed time0.020.00
repeated bind elapsed time0.010.00
sequence load elapsed time0.000.00
DB time1,960.55 
background elapsed time849.60 
background cpu time495.96 


Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME244,210 
IDLE_TIME28,516,540 
IOWAIT_TIME29,374 
NICE_TIME0 
SYS_TIME56,578 
USER_TIME181,732 
LOAD32
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
17-Feb 09:00:532.75     
17-Feb 10:00:552.140.850.630.2099.150.10


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  1,671 85.21
User I/O75,410019139.75
Commit221,861015117.68
Application231,45907904.01
Network2,042,2850400.21
Configuration92702190.09
System I/O12,9440200.08
Other1794140.04
Concurrency1,8120000.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 read69,721018730.189.51
log file sync221,861015110.587.68
SQL*Net break/reset to client231,36006300.613.23
enq: TX - row lock contention990151550.000.78
read by other session4,5670410.010.22
SQL*Net message to client2,039,2300405.340.21
control file sequential read12,8430200.030.08
enq: TX - allocate ITL entry3013790.000.06
undo segment extension7882170.000.03
recovery area: computing obsolete files1003190.000.02
recovery area: computing backed up files1002790.000.01
db file scattered read590040.000.01
cursor: pin S wait on X900100.000.00
log file switch (private strand flush incomplete)800100.000.00
recovery area: computing dropped files100740.000.00
Disk file operations I/O1,0630000.000.00
control file single write670010.000.00
SQL*Net more data from client2,9450000.010.00
latch: cache buffers chains1,2420000.000.00
enq: TX - contention100500.000.00
buffer busy waits2780000.000.00
latch: In memory undo latch1490000.000.00
cursor: mutex S30070.000.00
enq: TX - index contention340000.000.00
library cache lock30030.000.00
latch: object queue header operation640000.000.00
ADR block file read360000.000.00
control file parallel write340000.000.00
latch: shared pool300000.000.00
CSS initialization10050.000.00
latch: redo allocation290000.000.00
SQL*Net more data to client1100000.000.00
library cache: mutex X470000.000.00
CSS operation: action10020.000.00
enq: FB - contention10010.000.00
SQL*Net message from client2,039,22202,932,53114385.34 
jobq slave wait7,9211003,9675010.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,562,341022004.0925.86
log file parallel write250,37903400.664.05
log file sequential read1,48601070.001.19
db file async I/O submit1,562,3390304.090.33
os thread startup13803190.000.31
control file sequential read10,4050200.030.29
ASM file metadata operation1,9190210.010.20
reliable message8480110.000.13
LGWR wait for redo copy6,8600100.020.08
control file parallel write2,9170000.010.06
db file sequential read5180000.000.02
latch free5740000.000.01
Data file init write1450010.000.01
Disk file operations I/O3,4960000.010.01
rdbms ipc reply60060.000.00
RMAN backup & recovery I/O60030.000.00
kfk: async disk IO300010.000.00
asynch descriptor resize1,836100000.000.00
Log archive I/O80020.000.00
enq: CF - contention30040.000.00
latch: messages900000.000.00
CSS initialization20050.000.00
db file single write60020.000.00
latch: redo writing1000000.000.00
latch: object queue header operation1060000.000.00
latch: redo allocation500000.000.00
SQL*Net more data from client100010.000.00
ADR block file read160000.000.00
buffer busy waits460000.000.00
log file single write160000.000.00
SQL*Net message to client3,4920000.010.00
enq: CI - contention10040.000.00
CSS operation: action20020.000.00
latch: call allocation120000.000.00
direct path write390000.000.00
latch: checkpoint queue latch110000.000.00
CSS operation: query120000.000.00
log file sync20010.000.00
rdbms ipc message280,7341092,8293310.73 
Space Manager: slave idle wait11,7313635,96930660.03 
EMON slave idle wait3,60010018,00350010.01 
class slave wait1,35607,20253110.00 
DIAG idle wait7,1751007,18210010.02 
ASM background timer98303,60536670.00 
wait for unread message on broadcast channel3,5981003,60210010.01 
shared server idle wait1201003,601300100.00 
Streams AQ: emn coordinator idle wait3601003,601100030.00 
dispatcher timer601003,601600120.00 
pmon timer1,1991003,60030030.00 
smon timer56903,59963250.00 
Streams AQ: qmn coordinator idle wait256503,585140040.00 
Streams AQ: qmn slave idle wait12803,585280090.00 
SQL*Net message from client5,19001630.01 
KSV master wait5640120.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 lock8100.0       
ASM file metadata operation191694.82.0.5.7.5.7.8 
CSS initialization3   100.0    
CSS operation: action3 100.0      
CSS operation: query18100.0       
Data file init write14583.411.72.12.8    
Disk file operations I/O455999.8.0.0.1    
LGWR wait for redo copy685899.6.4.0     
Log archive I/O825.037.537.5     
RMAN backup & recovery I/O650.0 16.733.3    
SQL*Net break/reset to client231.4K97.61.9.3.1.0.0.0 
SQL*Net message to client2042.6K100.0.0.0     
SQL*Net more data from client295599.7.2.0.0    
SQL*Net more data to client120100.0       
asynch descriptor resize1835100.0       
buffer busy waits32498.1.9.6.3    
buffer deadlock8100.0       
control file parallel write295099.9.1.0     
control file sequential read23.2K99.1.2.6.1.0.0.0 
control file single write6741.858.2      
cursor: mutex S333.3   66.7   
cursor: mutex X3100.0       
cursor: pin S1100.0       
cursor: pin S wait on X9  22.2 66.711.1  
db file async I/O submit1562.2K100.0       
db file parallel write1562.1K100.0.0.0.0.0.0.0 
db file scattered read5916.923.713.633.911.9   
db file sequential read70.3K55.210.89.020.83.21.0.1 
db file single write683.3  16.7    
direct path write39100.0       
enq: CF - contention3  66.733.3    
enq: CI - contention1  100.0     
enq: FB - contention1 100.0      
enq: HW - contention3100.0       
enq: TX - allocate ITL entry3     33.366.7 
enq: TX - contention1      100.0 
enq: TX - index contention3488.25.95.9     
enq: TX - row lock contention992.0  7.142.47.141.4 
kfk: async disk IO3096.7  3.3    
latch free58597.61.21.0.2    
latch: In memory undo latch15098.02.0      
latch: cache buffers chains125299.8.2      
latch: cache buffers lru chain5100.0       
latch: call allocation1291.78.3      
latch: checkpoint queue latch12100.0       
latch: enqueue hash chains3100.0       
latch: messages93100.0       
latch: object queue header operation17099.4.6      
latch: redo allocation79100.0       
latch: redo writing100100.0       
latch: row cache objects2100.0       
latch: shared pool3096.73.3      
library cache load lock11100.0       
library cache lock366.7  33.3    
library cache: mutex X4797.92.1      
log file parallel write250.3K99.7.2.0.0.0.0.0 
log file sequential read148627.815.822.813.011.65.23.8 
log file single write16100.0       
log file switch (private strand flush incomplete)8   25.075.0   
log file sync221.8K94.45.0.4.1.0.0.0 
os thread startup138    14.585.5  
rdbms ipc reply6  50.016.733.3   
read by other session456779.919.6.5.0    
recovery area: computing backed up files1      100.0 
recovery area: computing dropped files1      100.0 
recovery area: computing obsolete files1      100.0 
reliable message84828.866.0.64.5.1   
undo segment extension7861.5   17.917.92.6 
ASM background timer98215.02.31.62.1.8.42.774.9
DIAG idle wait7175      100.0 
EMON slave idle wait3600       100.0
KSV master wait58688.45.31.51.51.2.21.9 
SQL*Net message from client2044.2K48.123.38.73.82.21.55.07.4
Space Manager: slave idle wait11.7K2.3.1.6.6.61.017.477.4
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
class slave wait135633.92.813.54.16.49.41.228.7
dispatcher timer60       100.0
jobq slave wait7920.0     100.0 
pmon timer1199       100.0
rdbms ipc message280.7K10.57.112.430.216.66.29.57.6
shared server idle wait120       100.0
smon timer5695.1.2.51.41.22.117.472.1
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 operation1699.2.7.1     
SQL*Net break/reset to client3100.0.0.0.0    
control file sequential read3100.0.0      
db file parallel write1100.0.0      
db file sequential read8799.9.1.0.0    
enq: TX - allocate ITL entry233.3   33.333.3  
enq: TX - contention1 100.0      
enq: TX - row lock contention4158.65.17.16.113.110.1  
log file parallel write4100.0.0.0     
log file sequential read5796.22.61.1.1.1   
log file sync7100.0.0.0     
recovery area: computing backed up files1    100.0   
recovery area: computing dropped files1  100.0     
recovery area: computing obsolete files1    100.0   
undo segment extension297.42.6      


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,3651,1205447,962
SYS$USERS59355016223,959
SYS$BACKGROUND001869
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 59106148179500019284284
SYS$USERS 1629943170001139270
SYS$BACKGROUND 4180019530000


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
390.373291.1919.9199.710.008xq7a5u95h5ab JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
42.46880.482.172.9297.84fpvzbqsarvfrn JDBC Thin Client select id, waybill_no, exp_typ...
32.61261.251.665.3296.531bmjn8d3zv707 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
19.3292,2830.000.9949.110.00fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
18.46121.540.9499.790.00523j4678qy5a2 JDBC Thin Client select count(id) from T_EXP_OP...
14.82380.390.7699.680.006jfqh58kthra6 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
14.80340.440.7599.680.003ybrvrk9xs8g4 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
14.28157,4120.000.7339.370.00c2gkrw5buc9wb JDBC Thin Client select sysdate from DUAL
13.03310.420.663.2497.62cpp62mu3faspc JDBC Thin Client select id, waybill_no, exp_typ...
12.41112.410.6343.4856.83at2yfw83uhs6h PL/SQL Developer select sum(bytes) / 1024 / 102...


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
389.233291.1823.30390.3799.710.008xq7a5u95h5ab JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
18.42121.541.1018.4699.790.00523j4678qy5a2 JDBC Thin Client select count(id) from T_EXP_OP...
14.78380.390.8814.8299.680.006jfqh58kthra6 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
14.75340.430.8814.8099.680.003ybrvrk9xs8g4 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
10.18410.250.6110.2499.430.0060t151zvb392t JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
9.5161.590.579.9695.520.001936x2bzxvr37 JDBC Thin Client SELECT WAYBILL_NO, EXP_TYPE, W...
9.4992,2830.000.5719.3249.110.00fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
7.591,1900.010.458.1593.120.20fr956v842tq26 JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...
6.15380.160.377.7379.460.0052n7tayuhf0dy JDBC Thin Client SELECT * FROM (SELECT T.*, ROW...
5.98  0.369.9759.98 8wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...


Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
41.54880.4721.6842.462.9297.84fpvzbqsarvfrn JDBC Thin Client select id, waybill_no, exp_typ...
31.48261.2116.4332.615.3296.531bmjn8d3zv707 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
12.72310.416.6413.033.2497.62cpp62mu3faspc JDBC Thin Client select id, waybill_no, exp_typ...
7.89150.534.128.093.2697.608shw0444gmpm1 JDBC Thin Client select id, waybill_no, exp_typ...
7.51120.633.927.672.8397.9744arq6h9x6tfq JDBC Thin Client select id, waybill_no, exp_typ...
7.0517.053.6812.4143.4856.83at2yfw83uhs6h PL/SQL Developer select sum(bytes) / 1024 / 102...
4.1560.692.174.243.1197.91b3ad53x79qa2p JDBC Thin Client select id, waybill_no, exp_typ...
4.051080.042.114.8219.8384.0915xqqs2wvj1g1 JDBC Thin Client select id from T_EXP_OP_RECORD...
3.254180.011.704.6429.8070.176tmw6qrt9zatr JDBC Thin Client select id from T_EXP_OP_RECORD...
0.1420.070.073.0591.624.61bd502nbh9abbs plsqldev.exe select s.synonym_name object_n...


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
186,968,802329568,294.2368.72390.3799.708xq7a5u95h5ab JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
8,849,31512737,442.923.2518.4699.80523j4678qy5a2 JDBC Thin Client select count(id) from T_EXP_OP...
6,903,76234203,051.822.5414.8099.703ybrvrk9xs8g4 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
4,779,26541116,567.441.7610.2499.4060t151zvb392t JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
4,616,9396769,489.831.709.9695.501936x2bzxvr37 JDBC Thin Client SELECT WAYBILL_NO, EXP_TYPE, W...
2,288,8603860,233.160.847.7379.5052n7tayuhf0dy JDBC Thin Client SELECT * FROM (SELECT T.*, ROW...
1,971,9483359,756.000.724.2399.504x8zxaffuaduk JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
1,869,2066528,757.020.694.4797.40btrdhh3maycfw JDBC Thin Client SELECT t.id, t.waybill_no, t.a...
1,610,7443842,388.000.5914.8299.706jfqh58kthra6 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
1,446,8312168,896.710.533.9893.60g512cuuqs7qrz JDBC Thin Client SELECT WAYBILL_NO, EXP_TYPE, W...


Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
13,22326508.5814.9632.615.3296.531bmjn8d3zv707 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
6,3198871.817.1542.462.9297.84fpvzbqsarvfrn JDBC Thin Client select id, waybill_no, exp_typ...
4,47710841.455.074.8219.8384.0915xqqs2wvj1g1 JDBC Thin Client select id from T_EXP_OP_RECORD...
2,2653173.062.5613.033.2497.62cpp62mu3faspc JDBC Thin Client select id, waybill_no, exp_typ...
1,8594184.452.104.6429.8070.176tmw6qrt9zatr JDBC Thin Client select id from T_EXP_OP_RECORD...
1,3511590.071.538.093.2697.608shw0444gmpm1 JDBC Thin Client select id, waybill_no, exp_typ...
1,25611,256.001.4212.4143.4856.83at2yfw83uhs6h PL/SQL Developer select sum(bytes) / 1024 / 102...
1,1581296.501.317.672.8397.9744arq6h9x6tfq JDBC Thin Client select id, waybill_no, exp_typ...
7056117.500.804.243.1197.91b3ad53x79qa2p JDBC Thin Client select id, waybill_no, exp_typ...
291,8080.020.034.8976.160.67dkadnv9v3zbxj JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...


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
13,22313,22326508.580.0015.091bmjn8d3zv707 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
4,4774,47710841.450.005.1115xqqs2wvj1g1 JDBC Thin Client select id from T_EXP_OP_RECORD...
1,2561,25611,256.000.001.43at2yfw83uhs6h PL/SQL Developer select sum(bytes) / 1024 / 102...
2323211.500.000.03bd502nbh9abbs plsqldev.exe select s.synonym_name object_n...
559,7540.000.000.010v9u1u536y9b4 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
2270.290.000.0004u93q64635mq JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
117,7350.000.000.0070hgzk0hj7rnf JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
117,2130.000.000.00dk3jc30w2f9u6 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
1110,1920.000.000.00ghdbndgv3sjm4 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
008,6620.00 0.000nkqj01vbxzq0 JDBC Thin Client DELETE FROM 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
157,412157,4071.0014.2839.40c2gkrw5buc9wb JDBC Thin Client select sysdate from DUAL
92,2833,7090.0419.3249.10fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
35,30735,2401.002.6033.301bqk0pmqg1vq6 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
24,13024,1301.002.4373.302jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
15,95615,9081.001.2030.50a7gc1kus3vwc6 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
13,38013,2830.991.5136.6.1acwagtju00dpq JDBC Thin Client SELECT ID, DEST_OUT_SCAN_TIME,...
13,31913,3221.004.9349.3cj9mymcb3d5q0 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
10,23210,1861.001.1138.9047p8ggp4zttad JDBC Thin Client SELECT ID, DEST_OUT_SCAN_TIME,...
10,19210,1931.003.42450ghdbndgv3sjm4 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
9,9059,8611.000.7432.309qux0wxcavh9p 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
157,315157,41210.70c2gkrw5buc9wb JDBC Thin Client select sysdate from DUAL
92,28392,2836.28fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
35,29435,3072.401bqk0pmqg1vq6 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
24,13024,1301.642jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
15,95515,9561.09a7gc1kus3vwc6 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
15,897 1.08d7khudn7c54n6   INSERT INTO T_EXP_DELIVERY_STA...
15,255 1.048wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
13,38013,3800.91acwagtju00dpq JDBC Thin Client SELECT ID, DEST_OUT_SCAN_TIME,...
13,31713,3190.91cj9mymcb3d5q0 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
10,23210,2320.7047p8ggp4zttad 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
38,669,096 0.54c2mffjag542y2   INSERT INTO T_EXP_OP_RECORD_CO...
24,806,536 0.357g04ytfkrfcat   INSERT INTO T_EXP_OP_RECORD_CO...
21,158,456 0.30du2aujnxqm6fv   INSERT INTO T_EXP_OP_RECORD_CO...
20,064,472 0.288wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
19,625,128 0.28cak25du5pyzcp   INSERT INTO T_EXP_DELIVERY_STA...
18,750,872 0.269pxk46nsp5snk   INSERT INTO T_EXP_OP_RECORD_CO...
18,393,600 0.26d7khudn7c54n6   INSERT INTO T_EXP_DELIVERY_STA...
17,959,848 0.251864ycgvgvyam   INSERT INTO T_EXP_DELIVERY_STA...
17,364,584 0.244zg34tvzdpa1z   INSERT INTO T_EXP_OP_RECORD_CO...
16,270,448 0.2309c07pa97cdkj   INSERT INTO T_EXP_OP_RECORD_CO...
15,082,704 0.21a6nwkg0nu1grj   INSERT INTO T_EXP_DELIVERY_STA...
14,786,824 0.2196bau1p59dh0y   INSERT INTO T_EXP_DELIVERY_STA...
14,519,376 0.2009qtbd90zbmkv   INSERT INTO T_EXP_DELIVERY_STA...
14,507,384 0.2086n8k008j5fg5   INSERT INTO T_EXP_DELIVERY_STA...
14,305,9753240.203s4x5qxnjcxhv JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
14,280,424 0.205ntqv80pf9q0n   INSERT INTO T_EXP_DELIVERY_STA...
14,072,7192390.20f2q8qvn33yd3y JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
13,554,888 0.19gf25wm6hncp21   INSERT INTO T_EXP_DELIVERY_STA...
13,514,376 0.197ymaac33ytc92   INSERT INTO T_EXP_DELIVERY_STA...
13,210,432 0.192ayhh3ddjwg7y   INSERT INTO T_EXP_DELIVERY_STA...
13,088,5671,1350.18ba3md9ywn7phu JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
13,079,2952,7530.1884u9vy133wnwj JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
13,028,280 0.184sbkzmudwcd68   INSERT INTO T_EXP_DELIVERY_STA...
12,826,0154020.1862b5gtpzmvaph JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
12,655,8553,1930.18fmc5ungbx9cbu JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
12,651,2391,2310.1869u6frfbj80ya JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
12,307,056 0.17733xjzj58vkx0   INSERT INTO T_EXP_DELIVERY_STA...
11,767,944 0.17fqws7ksfz8mv0   INSERT INTO T_EXP_DELIVERY_STA...
11,727,296 0.161crrgmqhtap69   INSERT INTO T_EXP_DELIVERY_STA...
11,626,168 0.168tp9p80p00b0u   INSERT INTO T_EXP_DELIVERY_STA...
11,614,024 0.167y9zax9taks2q   INSERT INTO T_EXP_DELIVERY_STA...
11,435,520 0.168p3fp2jguk11n   INSERT INTO T_EXP_DELIVERY_STA...
11,346,728 0.165dzr1p10ydh03   INSERT INTO T_EXP_DELIVERY_STA...
10,823,672 0.157zdvpgv74gvqd   INSERT INTO T_EXP_DELIVERY_STA...
10,722,512 0.15c5zm115aa6kwx   INSERT INTO T_EXP_DELIVERY_STA...
9,668,760 0.14aq1j9m909q63y   INSERT INTO T_EXP_DELIVERY_STA...
2,975,3619590.04gyx912cqtkd9s JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
2,656,72992,2830.04fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
1,811,3139,7540.030v9u1u536y9b4 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
1,234,4041,6400.02bwrx7q7jppjug JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...
1,137,3271,8080.02dkadnv9v3zbxj JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_2...
1,082,96620.02bd502nbh9abbs plsqldev.exe select s.synonym_name object_n...


Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
546 c2mffjag542y2   INSERT INTO T_EXP_OP_RECORD_CO...
415 cak25du5pyzcp   INSERT INTO T_EXP_DELIVERY_STA...
365 7g04ytfkrfcat   INSERT INTO T_EXP_OP_RECORD_CO...
351 d7khudn7c54n6   INSERT INTO T_EXP_DELIVERY_STA...
344 1864ycgvgvyam   INSERT INTO T_EXP_DELIVERY_STA...
304 a6nwkg0nu1grj   INSERT INTO T_EXP_DELIVERY_STA...
296 du2aujnxqm6fv   INSERT INTO T_EXP_OP_RECORD_CO...
294 96bau1p59dh0y   INSERT INTO T_EXP_DELIVERY_STA...
293 09qtbd90zbmkv   INSERT INTO T_EXP_DELIVERY_STA...
282 8wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
277 86n8k008j5fg5   INSERT INTO T_EXP_DELIVERY_STA...
272 5ntqv80pf9q0n   INSERT INTO T_EXP_DELIVERY_STA...
269 7ymaac33ytc92   INSERT INTO T_EXP_DELIVERY_STA...
269 9pxk46nsp5snk   INSERT INTO T_EXP_OP_RECORD_CO...
2621,135ba3md9ywn7phu JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
261 gf25wm6hncp21   INSERT INTO T_EXP_DELIVERY_STA...
254 2ayhh3ddjwg7y   INSERT INTO T_EXP_DELIVERY_STA...
250 4sbkzmudwcd68   INSERT INTO T_EXP_DELIVERY_STA...
249 4zg34tvzdpa1z   INSERT INTO T_EXP_OP_RECORD_CO...
242 8p3fp2jguk11n   INSERT INTO T_EXP_DELIVERY_STA...
237 733xjzj58vkx0   INSERT INTO T_EXP_DELIVERY_STA...
234 09c07pa97cdkj   INSERT INTO T_EXP_OP_RECORD_CO...
233 1crrgmqhtap69   INSERT INTO T_EXP_DELIVERY_STA...
2283243s4x5qxnjcxhv JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
225 fqws7ksfz8mv0   INSERT INTO T_EXP_DELIVERY_STA...
224 8tp9p80p00b0u   INSERT INTO T_EXP_DELIVERY_STA...
222 7y9zax9taks2q   INSERT INTO T_EXP_DELIVERY_STA...
217 5dzr1p10ydh03   INSERT INTO T_EXP_DELIVERY_STA...
209 7zdvpgv74gvqd   INSERT INTO T_EXP_DELIVERY_STA...
207 aq1j9m909q63y   INSERT INTO T_EXP_DELIVERY_STA...
206 c5zm115aa6kwx   INSERT INTO T_EXP_DELIVERY_STA...
198239f2q8qvn33yd3y JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
1793,193fmc5ungbx9cbu JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
1751,23169u6frfbj80ya JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
1752,75384u9vy133wnwj JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
17240262b5gtpzmvaph JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
57959gyx912cqtkd9s JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
5592,283fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
499,7540v9u1u536y9b4 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...


Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04u93q64635mqSELECT COUNT(1) FROM ( SELECT DISTINCT ID FROM T_EXP_OP_RECORD_CONTAINER_165 WHERE 1=1 AND CREATE_TIME>=:1 AND CREATE_TIME<=:2 AND OP_CODE=:3 AND ORG_CODE=:4 AND STATUS=:5 AND EFFECTIVE_TYPE_CODE = :6 )
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 )
0nkqj01vbxzq0DELETE FROM T_EXP_DELIVERY_STATUS_233 WHERE WAYBILL_NO = :1
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 )
15xqqs2wvj1g1select id from T_EXP_OP_RECORD_HANDON_213 where status <> 0 and ID=:1
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
1bmjn8d3zv707SELECT COUNT(1) FROM ( SELECT DISTINCT ID FROM T_EXP_OP_RECORD_CONTAINER_202 WHERE 1=1 AND CREATE_TIME>=:1 AND CREATE_TIME<=:2 AND OP_CODE=:3 AND ORG_CODE=:4 AND NEXT_ORG_CODE=:5 AND STATUS=:6 )
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#
3s4x5qxnjcxhv INSERT INTO T_EXP_OP_RECORD_CONTAINER_216 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
3ybrvrk9xs8g4SELECT COUNT(1) FROM ( SELECT DISTINCT ID FROM T_EXP_OP_RECORD_CONTAINER_165 WHERE 1=1 AND CREATE_TIME>=:1 AND CREATE_TIME<=:2 AND OP_CODE=:3 AND ORG_CODE=:4 AND NEXT_ORG_CODE=:5 AND STATUS=:6 )
44arq6h9x6tfq 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_195 where status <> 0 and ID=:1
47p8ggp4zttadSELECT 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_208 WHERE WAYBILL_NO = :1
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 )
4x8zxaffuadukSELECT COUNT(1) FROM ( SELECT DISTINCT ID FROM T_EXP_OP_RECORD_CONTAINER_206 WHERE 1=1 AND CREATE_TIME>=:1 AND CREATE_TIME<=:2 AND OP_CODE=:3 AND ORG_CODE=:4 AND NEXT_ORG_CODE=:5 AND STATUS=:6 )
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 )
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
52n7tayuhf0dy SELECT * FROM (SELECT T.*, ROWNUM RN FROM ( SELECT DISTINCT ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, FEE_WEIGHT, TRANS_FEE, IN_OUT_FLAG, OUT_TIME, PKG_PCS, ORG_TYPE, QUERY_FLAG FROM T_EXP_OP_RECORD_CONTAINER_208 WHERE 1=1 AND CREATE_TIME>=:1 AND CREATE_TIME<=:2 AND OP_CODE=:3 AND ORG_CODE=:4 AND CREATE_USER_CODE=:5 AND STATUS=:6 ) T WHERE ROWNUM <= :7 ) WHERE RN >= :8
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 )
60t151zvb392tSELECT 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_220 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
62b5gtpzmvaph INSERT INTO T_EXP_OP_RECORD_CONTAINER_233 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
69u6frfbj80ya INSERT INTO T_EXP_OP_RECORD_CONTAINER_194 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
6jfqh58kthra6SELECT COUNT(1) FROM ( SELECT DISTINCT ID FROM T_EXP_OP_RECORD_CONTAINER_208 WHERE 1=1 AND CREATE_TIME>=:1 AND CREATE_TIME<=:2 AND OP_CODE=:3 AND ORG_CODE=:4 AND CREATE_USER_CODE=:5 AND STATUS=:6 )
6tmw6qrt9zatrselect id from T_EXP_OP_RECORD_HANDON_161 where status <> 0 and ID=:1
70hgzk0hj7rnfDELETE FROM T_EXP_DELIVERY_STATUS_216 WHERE WAYBILL_NO = :1
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 )
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 )
84u9vy133wnwj INSERT INTO T_EXP_OP_RECORD_CONTAINER_175 (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 )
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 )
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 )
8shw0444gmpm1 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_203 where status <> 0 and ID=:1
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
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 )
a7gc1kus3vwc6SELECT WAYBILL_NO FROM T_EXP_DELIVERY_STATUS_202 WHERE WAYBILL_NO = :1
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
aq1j9m909q63yINSERT INTO T_EXP_DELIVERY_STATUS_191 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
at2yfw83uhs6hselect sum(bytes) / 1024 / 1024 / 1024 from dba_segments where owner = 'YTEXP' and segment_name in( select index_name from dba_indexes where table_owner='YTEXP' and table_name like 'T_EXP_OP_RECORD_CONTAINER____')
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
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 )
bd502nbh9abbsselect s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
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
bwrx7q7jppjugUPDATE T_EXP_DELIVERY_STATUS_214 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
c2gkrw5buc9wbselect sysdate from DUAL
c2mffjag542y2 INSERT INTO T_EXP_OP_RECORD_CONTAINER_202 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
c5zm115aa6kwxINSERT INTO T_EXP_DELIVERY_STATUS_174 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
cak25du5pyzcpINSERT INTO T_EXP_DELIVERY_STATUS_161 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
cj9mymcb3d5q0DELETE FROM T_EXP_DELIVERY_STATUS_165 WHERE WAYBILL_NO = :1
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
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 )
dk3jc30w2f9u6DELETE FROM T_EXP_DELIVERY_STATUS_195 WHERE WAYBILL_NO = :1
dkadnv9v3zbxjUPDATE T_EXP_DELIVERY_STATUS_202 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
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 )
f2q8qvn33yd3y INSERT INTO T_EXP_OP_RECORD_CONTAINER_221 (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 )
fk97qz5tcpuxaINSERT INTO T_EXP_OP_RECORD_HANDON_208 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EMP_CODE, EMP_NAME, HANDON_TYPE, WEIGH_WEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, ORG_CODE, FREQUENCY_NO, HANDON_ID, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, CONTAINER_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, SIGINOFF_OP_CODE, SIGINOFF_ID, FST_SUCCESS_SIGINOFF, DELIVERY_SEQ, ORG_TYPE, QUERY_FLAG) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 )
fmc5ungbx9cbu INSERT INTO T_EXP_OP_RECORD_CONTAINER_220 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, TRANSPORT_TYPE_CODE, WEIGH_WEIGHT, INPUT_WEIGHT, PKG_LENGTH, PKG_WIDTH, PKG_HEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, SOURCE_ORG_CODE, DES_ORG_CODE, ORG_CODE, CONTAINER_NO, LINE_NO, FREQUENCY_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, VEHICLE_PLATE_NO, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, IO_TYPE, CMP_FLAG, LINE_FREQUENCY_NO, BILL_SOURCE_ORG_CODE, IN_OUT_FLAG, OUT_TIME, FEE_WEIGHT, PKG_PCS, ORG_TYPE, QUERY_FLAG, TAKING_WEIGHT) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 )
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
g512cuuqs7qrzSELECT WAYBILL_NO, EXP_TYPE, WEIGH_WEIGHT, INPUT_WEIGHT, VOLUME_WEIGHT, TAKING_WEIGHT, PKG_QTY, CREATE_TIME FROM T_EXP_OP_RECORD_CONTAINER_220 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
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 )
ghdbndgv3sjm4DELETE FROM T_EXP_DELIVERY_STATUS_208 WHERE WAYBILL_NO = :1
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 changes16,076,0894,463.4542.07
execute count1,531,536425.224.01
logons cumulative1,9040.530.00
opened cursors cumulative1,449,612402.483.79
parse count (total)1,469,893408.113.85
parse time elapsed4,4611.240.01
physical reads88,36524.530.23
physical writes2,324,565645.406.08
redo size2,782,400,176772,520.707,280.87
session cursor cache hits437,186121.381.14
session logical reads272,056,50275,535.25711.91
user calls3,430,419952.448.98
user commits226,31962.840.59
user rollbacks155,83343.270.41
workarea executions - onepass00.000.00
workarea executions - optimal14,2843.970.04


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 referenced11,0663.070.03
CCursor + sql area evicted1730.050.00
CPU used by this session108,23830.050.28
CPU used when call started106,55929.590.28
CR blocks created4050.110.00
Cached Commit SCN referenced3030.080.00
Commit SCN cached27,3947.610.07
DBWR checkpoint buffers written2,320,283644.226.07
DBWR checkpoints80.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 writes5770.160.00
DBWR undo block writes162,37645.080.42
Effective IO time00.000.00
HSC Heap Segment Block Changes1,541,837428.084.03
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts103,58228.760.27
Heap Segment Array Updates9820.270.00
IMU CR rollbacks20.000.00
IMU Flushes155,36043.130.41
IMU Redo allocation size349,288,90096,978.47914.01
IMU commits185,18651.420.48
IMU contention7410.210.00
IMU ktichg flush00.000.00
IMU pool not allocated1,6720.460.00
IMU recursive-transaction flush3970.110.00
IMU undo allocation size1,555,199,328431,793.994,069.58
IMU- failed to get a private strand1,6720.460.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 client2,037,585565.735.33
RowCR - row contention320.010.00
RowCR attempts4,7871.330.01
RowCR hits4,7991.330.01
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink1380.040.00
SQL*Net roundtrips to/from client2,039,287566.205.34
TBS Extension: bytes extended314,572,80087,339.70823.16
TBS Extension: files extended60.000.00
TBS Extension: tasks created400.010.00
TBS Extension: tasks executed400.010.00
active txn count during cleanout137,44138.160.36
background checkpoints completed90.000.00
background checkpoints started80.000.00
background timeouts29,6448.230.08
branch node splits400.010.00
buffer is not pinned count237,926,97466,059.34622.60
buffer is pinned count279,662,89777,647.13731.81
bytes received via SQL*Net from client1,175,727,129326,435.273,076.60
bytes sent via SQL*Net to client495,062,020137,451.711,295.46
calls to get snapshot scn: kcmgss2,318,024643.596.07
calls to kcmgas323,91689.930.85
calls to kcmgcs591,268164.161.55
cell physical IO interconnect bytes29,562,999,8088,208,031.9077,359.27
change write time11,8983.300.03
cleanout - number of ktugct calls123,18934.200.32
cleanouts and rollbacks - consistent read gets1040.030.00
cleanouts only - consistent read gets5830.160.00
cluster key scan block gets36,72910.200.10
cluster key scans32,8409.120.09
commit batch performed1180.030.00
commit batch requested1180.030.00
commit batch/immediate performed24,3206.750.06
commit batch/immediate requested24,3206.750.06
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written30.000.00
commit cleanout failures: callback failure6,9261.920.02
commit cleanout failures: cannot pin7880.220.00
commit cleanouts5,265,2591,461.8813.78
commit cleanouts successfully completed5,257,5421,459.7313.76
commit immediate performed24,2026.720.06
commit immediate requested24,2026.720.06
commit txn count during cleanout128,27435.610.34
consistent changes35,2419.780.09
consistent gets252,779,01770,182.94661.46
consistent gets - examination4,361,3111,210.9011.41
consistent gets direct00.000.00
consistent gets from cache252,779,02370,182.94661.46
consistent gets from cache (fastpath)248,328,91268,947.39649.82
cursor authentications2,1530.600.01
data blocks consistent reads - undo records applied1,4790.410.00
db block gets19,278,1095,352.4850.45
db block gets direct100.000.00
db block gets from cache19,278,0995,352.4850.45
db block gets from cache (fastpath)6,269,4341,740.6816.41
deferred (CURRENT) block cleanout applications1,203,709334.203.15
dirty buffers inspected10.000.00
doubling up with imu segment00.000.00
enqueue conversions4,3011.190.01
enqueue deadlocks00.000.00
enqueue releases1,549,339430.174.05
enqueue requests1,549,362430.174.05
enqueue timeouts00.000.00
enqueue waits1450.040.00
exchange deadlocks80.000.00
failed probes on index block reclamation10.000.00
file io service time00.000.00
frame signature mismatch00.000.00
free buffer inspected75,44220.950.20
free buffer requested278,35277.280.73
heap block compress261,38872.570.68
hot buffers moved to head of LRU58,83316.330.15
immediate (CR) block cleanout applications6870.190.00
immediate (CURRENT) block cleanout applications761,689211.481.99
index crx upgrade (positioned)00.000.00
index crx upgrade (prefetch)10.000.00
index fast full scans (full)30.000.00
index fetch by key2,309,728641.296.04
index scans kdiixs11,745,030484.504.57
leaf node 90-10 splits1110.030.00
leaf node splits20,1705.600.05
lob reads8,4232.340.02
lob writes8,4532.350.02
lob writes unaligned8,4532.350.02
logical read bytes from cache2,228,691,763,200618,786,090.635,831,951.06
max cf enq hold time300.010.00
messages received1,814,382503.754.75
messages sent1,814,382503.754.75
min active SCN optimization applied on CR108,53930.140.28
no buffer to keep pinned count00.000.00
no work - consistent read gets247,895,56668,827.07648.68
non-idle wait count6,019,4461,671.2715.75
parse count (describe)50.000.00
parse count (failures)30.000.00
parse count (hard)2,6380.730.01
parse time cpu1,7020.470.00
physical read IO requests87,61624.330.23
physical read bytes723,886,080200,983.661,894.24
physical read total IO requests114,61831.820.30
physical read total bytes4,252,751,8721,180,757.1411,128.43
physical read total multi block requests3,0590.850.01
physical reads cache70,04319.450.18
physical reads cache prefetch7490.210.00
physical reads direct18,3225.090.05
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests1,566,516434.944.10
physical write bytes19,042,836,4805,287,156.5949,830.53
physical write total IO requests1,851,205513.984.84
physical write total bytes25,310,247,9367,027,274.7666,230.84
physical write total multi block requests20,0205.560.05
physical writes direct4,2801.190.01
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache2,320,285644.226.07
physical writes non checkpoint175,01348.590.46
pinned buffers inspected00.000.00
pinned cursors current20.000.00
prefetch clients - default80.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,0271.120.01
recovery blocks read00.000.00
recursive aborts on index block reclamation00.000.00
recursive calls877,144243.542.30
recursive cpu usage4,7271.310.01
redo KB read2,799,953777.397.33
redo blocks checksummed by FG (exclusive)2,026,368562.615.30
redo blocks read for recovery00.000.00
redo blocks written5,756,1121,598.1615.06
redo buffer allocation retries80.000.00
redo entries7,736,1862,147.9220.24
redo k-bytes read for recovery00.000.00
redo log space requests100.000.00
redo ordering marks14,7764.100.04
redo size for direct writes82,32422.860.22
redo subscn max counts341,73394.880.89
redo synch long waits00.000.00
redo synch poll writes250,32769.500.66
redo synch polls266,08173.880.70
redo synch time15,1614.210.04
redo synch time (usec)151,589,26142,088.07396.67
redo synch time overhead (usec)96,110,32226,684.59251.50
redo synch time overhead count (<128 msec)30.000.00
redo synch time overhead count (<2 msec)247,08268.600.65
redo synch time overhead count (<32 msec)1650.050.00
redo synch time overhead count (<8 msec)2,6980.750.01
redo synch time overhead count (>=128 msec)10.000.00
redo synch writes250,32769.500.66
redo wastage69,370,96819,260.53181.53
redo write info find249,95169.400.65
redo write info find fail20.000.00
redo write time8,9602.490.02
redo writes250,36269.510.66
rollback changes - undo records applied82,53122.910.22
rollbacks only - consistent read gets2330.060.00
root node splits40.000.00
rows fetched via callback196,22454.480.51
session connect time00.000.00
shared hash latch upgrades - no wait10,7472.980.03
shared hash latch upgrades - wait00.000.00
sorts (disk)00.000.00
sorts (memory)20,3085.640.05
sorts (rows)199,27555.330.52
sql area evicted2,6700.740.01
sql area purged30.000.00
summed dirty queue length10.000.00
switch current to new buffer40,29511.190.11
table fetch by rowid256,781,54271,294.22671.94
table fetch continued row4,7791.330.01
table scan blocks gotten7,939,6362,204.4020.78
table scan rows gotten532,387,156147,814.861,393.13
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (short tables)23,5546.540.06
temp space allocated (bytes)00.000.00
total cf enq hold time3,9401.090.01
total number of cf enq holders4460.120.00
total number of times SMON posted5690.160.00
transaction rollbacks24,3206.750.06
transaction tables consistent read rollbacks30.000.00
transaction tables consistent reads - undo records applied410.010.00
undo change vector size983,548,928273,077.872,573.71
user logons cumulative1,6980.470.00
user logouts cumulative1,6870.470.00
write clones created in background00.000.00
write clones created in foreground50.000.00


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current678689
opened cursors current1,8631,881
session cursor cache count3,224,2473,229,519
session pga memory69,157,610,04869,427,416,240
session pga memory max86,608,481,34486,917,856,912
session uga memory66,830,736,60867,073,047,600
session uga memory max483,881,491,992484,510,622,016
workarea memory allocated024,948


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)88.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)
DBWR1M0.010M17.7G433.715.032M420.02
Others3.3G7.38.932M3.1G2.45.878M26.8K0.03
LGWR3M0.06.001M2.7G76.57.781M250.6K0.02
Buffer Cache Reads547M19.25.152M0M0.000M69.3K2.14
Direct Reads143M5.09.04M22M0.79.006M0 
Direct Writes0M0.000M11M0.40.003M0 
RMAN6M0.05.002M1M0.010M2140.10
TOTAL:4G31.841.127M23.6G513.936.701M347K0.44


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 File709M24.60.197M17.7G434.895.041M2.395.55
Log File2.7G0.77.759M2.7G76.51.78M0.4710.09
Archive Log0M0.000M2.7G0.76.759M2.50 
Control File623M6.45.173M131M1.66.036M0.011.94
TOTAL:4G31.831.129M23.3G513.816.617M1.909.25


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 1M0.010M17.7G433.685.032M420.02
DBWR (Data File) 0M0.000M17.7G433.685.032M0 
DBWR (Control File) 1M0.010M0M0.000M420.02
Others 3.3G7.38.932M3.1G2.45.878M23.9K0.04
Others (Archive Log) 0M0.000M2.7G0.76.759M0 
Others (Log File) 2.7G0.77.759M0M0.000M320.69
Others (Control File) 614M6.34.17M128M1.60.036M22.9K0.04
Others (Data File) 8M0.27.002M300M0.09.083M9720.01
LGWR 3M0.06.001M2.7G76.55.781M2170.00
LGWR (Log File) 0M0.000M2.7G76.51.78M320.00
LGWR (Control File) 3M0.05.001M2M0.04.001M1850.00
Buffer Cache Reads 549M19.30.152M0M0.000M69.5K2.14
Buffer Cache Reads (Data File) 549M19.30.152M0M0.000M69.5K2.14
Direct Reads 143M5.09.04M22M0.79.006M0 
Direct Reads (Data File) 143M5.09.04M22M0.79.006M0 
Direct Writes 0M0.000M11M0.40.003M0 
Direct Writes (Data File) 0M0.000M11M0.40.003M0 
RMAN 6M0.05.002M1M0.010M1890.12
RMAN (Control File) 6M0.05.002M1M0.010M1830.04
RMAN (Archive Log) 0M0.000M0M0.000M62.50
TOTAL: 4G31.881.127M23.6G513.886.7M93.9K1.60


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 2,17310.881.001,036,6980.6012881060.00
TS_YTEXP 51200.351.00382,2410.14010690.00
TS_IDX_CONTAINER 16,97555.971.0051,8394.71614280.00
TS_IDX_HANDON 29,88680.891.009,8598.30138,7510.51
TS_CONTAINER_02 45600.291.0315,3950.130430.00
TS_T_EXP_CONTAINER_202 12,40832.331.0093.452000.00
UNDOTBS1 900.001.0011,5970.00031380.22
TS_HANDON_02 45800.151.009,6280.1303350.29
TS_IDX_SIGNATURE 3,85510.831.004,1951.071130.00
TS_SIGNATURE_02 50400.201.004,2670.140100.00
TS_IDX_TAKE 2,87310.741.008980.801000.00
TS_IDX_T_EXP_CONTAINER_165 7001.861.002,8500.022110.00
TS_YTMDM 35606.541.001,7110.107000.00
TS_IDX_T_EXP_CONTAINER_208 6401.721.001,9530.022100.00
TS_TAKE_02 50400.001.001,1150.140000.00
TS_IDX_T_EXP_W_215 29507.291.009280.087000.00
SYSAUX 3802.371.009250.012000.00
TS_IDX_T_EXP_CONTAINER_202 6901.161.008040.021000.00
TS_IDX_T_EXP_CONTAINER_227 5600.891.007880.021000.00
TS_IDX_T_EXP_CONTAINER_206 5601.251.006700.021000.00
TS_IDX_T_EXP_CONTAINER_199 7201.671.005930.022000.00
TS_IDX_T_EXP_CONTAINER_186 5801.211.005760.021000.00
TS_IDX_T_EXP_W_172 10102.971.005230.033000.00
TS_IDX_T_EXP_CONTAINER_181 6301.431.005590.021000.00
TS_IDX_T_EXP_CONTAINER_225 6400.631.005060.021000.00
TS_IDX_T_EXP_W_174 12403.551.004430.034000.00
TS_IDX_T_EXP_CONTAINER_175 6401.881.004760.022000.00
TS_IDX_T_EXP_W_202 6000.501.004770.021000.00
TS_IDX_T_EXP_CONTAINER_228 5801.031.004580.021010.00
SYSTEM 4405.231.004680.0150320.63
TS_IDX_T_EXP_CONTAINER_215 7001.431.004220.021000.00
TS_IDX_YTMDM 19406.291.002770.056000.00
TS_IDX_T_EXP_W_199 28806.111.001810.086000.00
TS_IDX_T_EXP_CONTAINER_233 6601.671.003930.022000.00
TS_IDX_T_EXP_W_181 4400.001.003970.010000.00
TS_TAKE_01 35100.001.00900.100000.00
TS_IDX_T_EXP_CONTAINER_194 6200.651.003600.021000.00
TS_IDX_T_EXP_CONTAINER_219 7100.991.003440.021000.00
TS_IDX_T_EXP_W_170 7902.531.003320.023000.00
TS_HANDON_01 27100.041.001350.080000.00
TS_IDX_T_EXP_CONTAINER_195 6800.881.003040.021000.00
TS_CONTAINER_01 27702.131.00900.082000.00
TS_IDX_T_EXP_W_175 5300.001.003120.010000.00
TS_SIGNATURE_01 27400.181.00910.080000.00
TS_IDX_T_EXP_W_195 11904.961.002310.035000.00
TS_IDX_T_EXP_W_233 900.001.003270.000000.00
TS_IDX_T_EXP_CONTAINER_166 5001.401.002810.011000.00
TS_IDX_T_EXP_CONTAINER_237 5901.021.002610.021010.00
TS_IDX_T_EXP_W_162 4400.001.002670.010000.00
TS_IDX_T_EXP_W_236 6906.381.002410.026000.00
TS_IDX_T_EXP_W_161 4600.221.002600.010000.00
TS_IDX_T_EXP_W_224 2204.551.002740.015000.00
TS_IDX_T_EXP_W_237 3004.331.002590.014000.00
TS_IDX_T_EXP_CONTAINER_207 5801.381.002220.021000.00
TS_IDX_T_EXP_W_209 4400.001.002350.010000.00
TS_IDX_T_EXP_CONTAINER_162 5101.571.002230.012000.00
TS_IDX_T_EXP_CONTAINER_220 7301.371.002000.021000.00
TS_IDX_T_EXP_W_164 4600.001.002160.010020.00
TS_IDX_T_EXP_W_201 6601.211.001940.021000.00
TS_IDX_T_EXP_W_208 4400.001.002160.010000.00
TS_IDX_T_EXP_W_184 9106.371.001680.036000.00
TS_IDX_T_EXP_W_186 4400.001.002150.010000.00
TS_IDX_T_EXP_W_235 10707.011.001520.037000.00
TS_IDX_T_EXP_CONTAINER_174 6302.061.001950.022000.00
TS_IDX_T_EXP_CONTAINER_179 5701.231.001970.021000.00
TS_IDX_T_EXP_CONTAINER_188 6301.901.001840.022000.00
TS_IDX_T_EXP_W_214 4400.001.001990.010000.00
TS_IDX_T_EXP_W_210 4400.001.001980.010000.00
TS_IDX_T_EXP_CONTAINER_216 7201.251.001660.021000.00
TS_IDX_T_EXP_W_178 5300.001.001850.010000.00
TS_IDX_T_EXP_W_183 4400.001.001930.010020.00
TS_IDX_T_EXP_W_229 900.001.002280.000000.00
TS_IDX_T_EXP_W_177 5300.001.001820.010000.00
TS_IDX_T_EXP_W_220 1402.141.002210.002000.00
TS_IDX_T_EXP_CONTAINER_221 6200.481.001710.021000.00
TS_IDX_T_EXP_CONTAINER_209 5801.381.001720.021000.00
TS_IDX_T_EXP_CONTAINER_224 6100.491.001680.020000.00
TS_IDX_T_EXP_W_189 4400.001.001840.010000.00
TS_IDX_T_EXP_W_231 900.001.002160.000000.00
TS_IDX_T_EXP_W_188 4400.001.001800.010000.00
TS_IDX_T_EXP_W_239 6506.001.001580.026000.00
TS_IDX_T_EXP_W_187 4400.001.001770.010000.00
TS_IDX_T_EXP_CONTAINER_204 5901.531.001600.022000.00
TS_IDX_T_EXP_CONTAINER_161 5602.501.001620.022000.00
TS_IDX_T_EXP_CONTAINER_229 6401.561.001530.022000.00
TS_IDX_T_EXP_CONTAINER_214 6301.751.001530.022000.00
TS_IDX_T_EXP_W_185 6402.191.001520.022000.00
TS_IDX_T_EXP_W_179 5300.001.001620.010010.00
TS_IDX_T_EXP_W_207 4400.001.001680.010000.00
TS_IDX_T_EXP_W_232 3106.771.001810.017000.00
TS_IDX_T_EXP_W_168 4400.001.001670.010000.00
TS_IDX_T_EXP_W_193 5300.001.001580.010000.00
TS_IDX_T_EXP_CONTAINER_198 7301.231.001370.021000.00
TS_IDX_T_EXP_CONTAINER_177 6301.431.001450.022000.00
TS_IDX_T_EXP_CONTAINER_173 5300.941.001540.011000.00
TS_IDX_T_EXP_W_180 4400.001.001630.010000.00
TS_IDX_T_EXP_CONTAINER_193 7301.231.001320.021000.00
TS_IDX_T_EXP_W_166 4700.211.001550.010000.00
TS_IDX_T_EXP_W_196 5300.001.001480.010000.00
TS_IDX_T_EXP_CONTAINER_170 6601.971.001310.022000.00
TS_IDX_T_EXP_CONTAINER_191 6401.721.001330.022000.00
TS_IDX_T_EXP_CONTAINER_178 6401.251.001310.021000.00
TS_IDX_T_EXP_W_212 4400.001.001510.010000.00
TS_IDX_T_EXP_W_191 4900.821.001450.011000.00
TS_IDX_T_EXP_W_198 5300.001.001410.010000.00
TS_IDX_T_EXP_W_169 5300.001.001400.010000.00
TS_IDX_T_EXP_CONTAINER_238 6901.161.001230.021000.00
TS_IDX_T_EXP_W_238 1800.001.001740.000000.00
TS_IDX_T_EXP_W_226 4305.351.001480.015000.00
TS_IDX_T_EXP_W_190 4400.001.001460.010000.00
TS_IDX_T_EXP_W_216 900.001.001810.000000.00
TS_IDX_T_EXP_W_197 5300.001.001350.010000.00
TS_IDX_T_EXP_W_213 4400.001.001430.010000.00
TS_IDX_T_EXP_W_171 5300.001.001330.010000.00
TS_IDX_T_EXP_W_167 4400.001.001400.010000.00
TS_IDX_T_EXP_W_200 5300.001.001300.010000.00
TS_IDX_T_EXP_CONTAINER_203 5901.021.001230.021000.00
TS_IDX_T_EXP_W_211 4400.001.001370.010000.00
TS_IDX_T_EXP_W_165 6301.751.001130.022000.00
TS_IDX_T_EXP_W_173 5800.521.001170.020000.00
TS_IDX_T_EXP_W_176 5300.001.001200.010000.00
TS_IDX_T_EXP_W_203 4400.001.001290.010000.00
TS_IDX_T_EXP_CONTAINER_183 6101.311.001100.021000.00
TS_IDX_T_EXP_W_217 1100.911.001580.001000.00
TS_IDX_T_EXP_W_223 900.001.001570.000000.00
TS_IDX_T_EXP_CONTAINER_236 6301.111.001020.021000.00
TS_IDX_T_EXP_W_194 5300.001.001110.010000.00
TS_IDX_T_EXP_CONTAINER_200 6000.331.001010.020000.00
TS_IDX_T_EXP_CONTAINER_223 5800.171.001020.020000.00
TS_IDX_T_EXP_CONTAINER_187 5500.731.001040.021000.00
TS_IDX_T_EXP_CONTAINER_222 6701.041.00920.021000.00
TS_IDX_T_EXP_CONTAINER_197 6701.041.00910.021000.00
TS_IDX_T_EXP_CONTAINER_171 5901.191.00970.021010.00
TS_IDX_T_EXP_CONTAINER_172 5901.531.00950.022000.00
TS_IDX_T_EXP_W_205 4400.001.001100.010000.00
TS_IDX_T_EXP_W_192 5300.001.001000.010000.00
TS_IDX_T_EXP_W_204 4400.001.001090.010000.00
TS_IDX_T_EXP_CONTAINER_180 6601.821.00860.022000.00
TBS_OTH_SPLEX 9000.001.00570.020000.00
TS_IDX_T_EXP_CONTAINER_217 7201.111.00720.021000.00
TS_IDX_T_EXP_W_163 4400.001.001000.010000.00
TS_IDX_T_EXP_W_206 4400.001.001000.010000.00
TS_IDX_T_EXP_W_240 4604.351.00970.014000.00
TS_IDX_T_EXP_CONTAINER_201 7101.411.00690.021000.00
TS_IDX_T_EXP_W_182 4400.001.00950.010000.00
TS_IDX_T_EXP_CONTAINER_182 6201.941.00750.022000.00
TS_IDX_T_EXP_CONTAINER_196 7101.411.00630.021000.00
TS_IDX_T_EXP_CONTAINER_185 6101.311.00720.021000.00
TS_IDX_T_EXP_W_218 900.001.001230.000000.00
TS_IDX_T_EXP_W_222 900.001.001230.000000.00
TS_IDX_T_EXP_CONTAINER_218 7100.991.00600.021000.00
TS_IDX_T_EXP_CONTAINER_164 3600.001.00920.010000.00
TS_IDX_T_EXP_W_227 900.001.001190.000000.00
TS_IDX_T_EXP_W_228 1303.851.001140.004000.00
TS_IDX_T_EXP_W_219 900.001.001150.000000.00
TS_IDX_T_EXP_W_225 900.001.001150.000000.00
TS_IDX_T_EXP_CONTAINER_210 6201.291.00610.021000.00
TS_T_EXP_W_206 11502.177.4080.020000.00
TS_IDX_T_EXP_CONTAINER_231 6601.971.00540.022000.00
TS_IDX_T_EXP_CONTAINER_226 6101.481.00550.021000.00
TS_IDX_T_EXP_W_221 900.001.001060.000000.00
TS_IDX_T_EXP_CONTAINER_205 6201.451.00520.021000.00
TS_IDX_T_EXP_CONTAINER_235 6401.251.00500.021000.00
TS_IDX_T_EXP_CONTAINER_232 6502.001.00460.022000.00
TS_IDX_T_EXP_CONTAINER_184 6401.251.00460.021000.00
TS_IDX_T_EXP_CONTAINER_239 7101.551.00390.022000.00
TS_IDX_T_EXP_CONTAINER_167 5701.931.00510.022000.00
TS_IDX_T_EXP_CONTAINER_192 5400.001.00540.010000.00
TS_IDX_T_EXP_CONTAINER_213 6101.311.00450.021000.00
TS_IDX_T_EXP_CONTAINER_212 6402.501.00370.023000.00
TS_IDX_T_EXP_CONTAINER_234 5801.211.00430.021000.00
TS_IDX_T_EXP_CONTAINER_168 5402.411.00430.012000.00
TS_IDX_T_EXP_CONTAINER_189 5801.211.00390.021000.00
TS_IDX_T_EXP_CONTAINER_230 5801.901.00380.022000.00
TS_IDX_T_EXP_CONTAINER_240 6701.491.00290.021000.00
TS_IDX_T_EXP_CONTAINER_190 6402.341.00280.022000.00
TS_IDX_T_EXP_CONTAINER_169 6401.411.00270.021000.00
TS_IDX_T_EXP_CONTAINER_176 4500.001.00430.010000.00
TS_IDX_T_EXP_CONTAINER_211 5801.031.00250.021000.00
TS_T_EXP_CONTAINER_165 4500.001.00270.010000.00
TS_IDX_T_EXP_CONTAINER_163 5401.851.00170.012000.00
TS_T_EXP_CONTAINER_208 4500.001.00180.010000.00
TS_T_EXP_W_160 5400.001.0090.010000.00
TS_T_EXP_W_161 5400.001.0090.010000.00
TS_T_EXP_W_162 5400.001.0090.010000.00
TS_T_EXP_W_163 5400.001.0090.010000.00
TS_T_EXP_W_164 5400.001.0090.010000.00
TS_T_EXP_W_165 5400.001.0090.010000.00
TS_T_EXP_W_166 5400.001.0090.010000.00
TS_T_EXP_W_167 5400.001.0090.010000.00
TS_T_EXP_W_180 5400.001.0090.010000.00
TS_T_EXP_W_181 5400.001.0090.010000.00
TS_T_EXP_W_182 5400.001.0090.010000.00
TS_T_EXP_W_183 5400.001.0090.010000.00
TS_T_EXP_W_184 5400.001.0090.010000.00
TS_T_EXP_W_185 5400.001.0090.010000.00
TS_T_EXP_W_186 5400.001.0090.010000.00
TS_T_EXP_W_187 5400.001.0090.010000.00
TS_T_EXP_W_188 5400.001.0090.010000.00
TS_T_EXP_W_189 5400.001.0090.010000.00
TS_T_EXP_W_190 5400.001.0090.010000.00
TS_T_EXP_W_235 5400.191.0090.010000.00
TS_T_EXP_W_226 5300.001.0090.010000.00
TS_T_EXP_W_227 5300.001.0090.010000.00
TS_T_EXP_W_228 5300.001.0090.010000.00
TS_T_EXP_W_229 5300.001.0090.010000.00
TS_T_EXP_W_230 5300.001.0090.010000.00
TS_T_EXP_W_231 5300.001.0090.010000.00
TS_T_EXP_W_232 5300.001.0090.010000.00
TS_T_EXP_W_233 5300.001.0090.010000.00
TS_T_EXP_W_234 5300.001.0090.010000.00
TS_T_EXP_W_236 5300.001.0090.010000.00
TS_IDX_T_EXP_W_230 900.001.00520.000000.00
TS_T_EXP_CONTAINER_229 5201.921.0090.012000.00
TS_T_EXP_W_203 5300.001.0080.010000.00
TS_T_EXP_W_204 5300.001.0080.010000.00
TS_T_EXP_W_205 5300.001.0080.010000.00
TS_T_EXP_W_207 5300.001.0080.010000.00
TS_T_EXP_W_208 5300.001.0080.010000.00
TS_T_EXP_W_209 5300.001.0080.010000.00
TS_T_EXP_W_210 5300.001.0080.010000.00
TS_T_EXP_W_211 5300.001.0080.010000.00
TS_T_EXP_W_212 5300.001.0080.010000.00
TS_T_EXP_W_213 5300.001.0080.010000.00
TS_T_EXP_CONTAINER_238 5101.961.0090.012000.00
TS_IDX_T_EXP_W_234 900.001.00490.000000.00
TS_T_EXP_CONTAINER_219 4802.921.0090.013000.00
TS_T_EXP_W_168 4500.001.0090.010000.00
TS_T_EXP_W_169 4500.001.0090.010000.00
TS_T_EXP_W_170 4500.001.0090.010000.00
TS_T_EXP_W_171 4500.001.0090.010000.00
TS_T_EXP_W_172 4500.001.0090.010000.00
TS_T_EXP_W_173 4500.001.0090.010000.00
TS_T_EXP_W_174 4500.001.0090.010000.00
TS_T_EXP_W_175 4500.001.0090.010000.00
TS_T_EXP_W_176 4500.001.0090.010000.00
TS_T_EXP_W_177 4500.001.0090.010000.00
TS_T_EXP_W_178 4500.001.0090.010000.00
TS_T_EXP_W_179 4500.001.0090.010000.00
TS_T_EXP_W_191 4500.001.0090.010000.00
TS_T_EXP_W_192 4500.001.0090.010000.00
TS_T_EXP_W_193 4500.001.0090.010000.00
TS_T_EXP_W_194 4500.001.0090.010000.00
TS_T_EXP_W_195 4500.001.0090.010000.00
TS_T_EXP_W_196 4500.001.0090.010000.00
TS_T_EXP_W_197 4500.001.0090.010000.00
TS_T_EXP_W_198 4500.001.0090.010000.00
TS_T_EXP_W_199 4500.001.0090.010000.00
TS_T_EXP_W_200 4500.001.0090.010000.00
TS_T_EXP_W_201 4500.001.0090.010000.00
TS_T_EXP_W_202 4500.001.0090.010000.00
TS_T_EXP_CONTAINER_225 4402.501.0090.013000.00
TS_T_EXP_W_237 4400.001.0090.010000.00
TS_T_EXP_W_238 4400.001.0090.010000.00
TS_T_EXP_W_239 4400.001.0090.010000.00
TS_T_EXP_W_240 4400.001.0090.010000.00
TS_T_EXP_W_214 4400.001.0080.010000.00
TS_T_EXP_W_215 4400.001.0080.010000.00
TS_T_EXP_W_216 4400.001.0080.010000.00
TS_T_EXP_W_217 4400.001.0080.010000.00
TS_T_EXP_W_218 4400.001.0080.010000.00
TS_T_EXP_W_219 4400.001.0080.010000.00
TS_T_EXP_W_220 4400.001.0080.010000.00
TS_T_EXP_W_221 4400.001.0080.010000.00
TS_T_EXP_W_222 4400.001.0080.010000.00
TS_T_EXP_W_223 4400.001.0080.010000.00
TS_T_EXP_W_224 4400.001.0080.010000.00
TS_T_EXP_W_225 4400.001.0080.010000.00
TS_T_EXP_CONTAINER_221 4201.901.0090.012000.00
TS_T_EXP_CONTAINER_235 4100.491.0090.011000.00
TS_T_EXP_CONTAINER_216 4001.751.0090.012000.00
TS_T_EXP_CONTAINER_236 4001.001.0090.011000.00
TS_T_EXP_CONTAINER_214 3802.371.0090.012000.00
TS_T_EXP_CONTAINER_240 3700.001.0090.010000.00
TS_T_EXP_CONTAINER_203 3601.391.0090.011000.00
TS_T_EXP_CONTAINER_226 3600.001.0090.010000.00
TS_T_EXP_CONTAINER_227 3600.001.0090.010000.00
TS_T_EXP_CONTAINER_228 3600.001.0090.010000.00
TS_T_EXP_CONTAINER_230 3600.001.0090.010000.00
TS_T_EXP_CONTAINER_231 3600.001.0090.010000.00
TS_T_EXP_CONTAINER_232 3600.001.0090.010000.00
TS_T_EXP_CONTAINER_233 3600.001.0090.010000.00
TS_T_EXP_CONTAINER_234 3600.001.0090.010000.00
TS_T_EXP_CONTAINER_237 3600.001.0090.010000.00
TS_T_EXP_CONTAINER_239 3600.001.0090.010000.00
TS_T_EXP_CONTAINER_223 3501.711.0090.011000.00
TS_T_EXP_CONTAINER_217 3201.561.0090.012000.00
TS_T_EXP_CONTAINER_193 3102.261.0090.012000.00
TS_T_EXP_CONTAINER_205 2900.341.0090.010000.00
TS_T_EXP_CONTAINER_210 2900.341.0090.010000.00
TS_T_EXP_CONTAINER_211 2900.691.0090.010000.00
TS_T_EXP_CONTAINER_222 2900.341.0090.010000.00
TS_T_EXP_CONTAINER_209 2800.001.0090.010000.00
TS_T_EXP_CONTAINER_212 2800.361.0090.010000.00
TS_T_EXP_CONTAINER_215 2800.361.0090.010000.00
TS_T_EXP_CONTAINER_188 2703.331.0090.013000.00
TS_T_EXP_CONTAINER_196 2701.481.0090.011000.00
TS_T_EXP_CONTAINER_204 2700.001.0090.010000.00
TS_T_EXP_CONTAINER_206 2700.001.0090.010000.00
TS_T_EXP_CONTAINER_207 2700.001.0090.010000.00
TS_T_EXP_CONTAINER_213 2700.001.0090.010000.00
TS_T_EXP_CONTAINER_218 2700.001.0090.010000.00
TS_T_EXP_CONTAINER_220 2700.001.0090.010000.00
TS_T_EXP_CONTAINER_224 2700.001.0090.010000.00
TS_T_EXP_CONTAINER_182 2601.541.0090.012000.00
TS_T_EXP_CONTAINER_169 2404.581.0090.015000.00
TS_T_EXP_CONTAINER_197 2400.831.0090.011000.00
TS_T_EXP_CONTAINER_201 2401.251.0090.011000.00
TS_T_EXP_CONTAINER_180 2201.361.0090.011000.00
TS_T_EXP_CONTAINER_187 2200.911.0090.011000.00
TS_T_EXP_CONTAINER_190 2200.911.0090.011000.00
TS_T_EXP_CONTAINER_200 2200.911.0090.011000.00
TS_T_EXP_CONTAINER_198 2100.951.0090.011000.00
TS_T_EXP_CONTAINER_191 1900.001.0090.010000.00
TS_T_EXP_CONTAINER_181 1800.001.0090.000000.00
TS_T_EXP_CONTAINER_183 1800.001.0090.000000.00
TS_T_EXP_CONTAINER_184 1800.001.0090.000000.00
TS_T_EXP_CONTAINER_185 1800.001.0090.000000.00
TS_T_EXP_CONTAINER_186 1800.001.0090.000000.00
TS_T_EXP_CONTAINER_189 1800.001.0090.000000.00
TS_T_EXP_CONTAINER_192 1800.001.0090.000000.00
TS_T_EXP_CONTAINER_194 1800.001.0090.000000.00
TS_T_EXP_CONTAINER_195 1800.001.0090.000000.00
TS_T_EXP_CONTAINER_199 1800.001.0090.000000.00
TS_T_EXP_CONTAINER_167 1200.831.0090.002000.00
TS_T_EXP_CONTAINER_170 1001.001.0090.001000.00
TS_T_EXP_CONTAINER_161 900.001.0090.000000.00
TS_T_EXP_CONTAINER_162 900.001.0090.000000.00
TS_T_EXP_CONTAINER_163 900.001.0090.000000.00
TS_T_EXP_CONTAINER_164 900.001.0090.000000.00
TS_T_EXP_CONTAINER_166 900.001.0090.000000.00
TS_T_EXP_CONTAINER_168 900.001.0090.000000.00
TS_T_EXP_CONTAINER_171 900.001.0090.000000.00
TS_T_EXP_CONTAINER_172 900.001.0090.000000.00
TS_T_EXP_CONTAINER_173 900.001.0090.000000.00
TS_T_EXP_CONTAINER_174 900.001.0090.000000.00
TS_T_EXP_CONTAINER_175 900.001.0090.000000.00
TS_T_EXP_CONTAINER_176 900.001.0090.000000.00
TS_T_EXP_CONTAINER_177 900.001.0090.000000.00
TS_T_EXP_CONTAINER_178 900.001.0090.000000.00
TS_T_EXP_CONTAINER_179 900.001.0090.000000.00
USERS 900.001.0090.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 3802.371.0002.37925000.00
SYSTEM+DATA_DG/dbquery/datafile/system.261.828812051 4405.231.0005.004680320.63
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_01.dbf 1800.001.0000.009000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_02.dbf 1800.001.0000.009000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_03.dbf 1800.001.0000.009000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_04.dbf 1800.001.0000.009000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_05.dbf 1800.001.0000.0021000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_01.dbf 2200.911.0000.919000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_02.dbf 2802.141.0002.149000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_03.dbf 2502.401.0002.409000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_04.dbf 2301.741.0001.749000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_05.dbf 2903.451.0003.109000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_06.dbf 3402.941.0002.949000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_07.dbf 2301.741.0001.309000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_08.dbf 2302.611.0002.619000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_09.dbf 3301.521.0001.529000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_10.dbf 3701.621.0001.629000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_01.dbf 3901.031.0001.03557000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_02.dbf 4500.001.0000.002,963110.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_03.dbf 4500.001.0000.001,783010.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_04.dbf 4800.421.2700.221,519010.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_05.dbf 4500.001.0000.001,989100.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_06.dbf 4600.221.0000.222,234100.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_07.dbf 4800.211.0000.421,347000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_08.dbf 4900.821.0000.821,442000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_09.dbf 4500.001.0000.001,025000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_10.dbf 4600.221.0000.22536000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_01.dbf 2700.001.0000.009000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_02.dbf 2700.001.0000.0024000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_03.dbf 2700.001.0000.0013000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_04.dbf 2700.001.0000.0023000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_05.dbf 2700.001.0000.0014000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_06.dbf 2800.361.0000.3611000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_07.dbf 2700.001.0000.0011000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_08.dbf 2700.001.0000.0012000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_09.dbf 2700.001.0000.009000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_10.dbf 2700.001.0000.009000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_01.dbf 4500.001.0000.00773000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_02.dbf 4500.001.0000.00940030.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_03.dbf 4800.421.0000.421,017052.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_04.dbf 4500.001.0000.0017000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_05.dbf 4500.001.0000.00425020.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_06.dbf 4500.001.0000.007720190.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_07.dbf 4500.001.0000.002,461120.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_08.dbf 4500.001.0000.00709000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_09.dbf 4500.001.0000.001,211000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_10.dbf 5001.001.0001.001,303040.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_01.dbf 1,69205.891.0005.895,301130.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_02.dbf 1,71606.041.0006.046,3342130.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_03.dbf 1,70406.091.0006.095,097110.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_04.dbf 1,83015.891.0015.893,720120.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_05.dbf 1,62206.001.0006.004,072100.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_06.dbf 1,55806.231.0006.234,919120.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_07.dbf 1,56705.761.0005.765,286100.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_08.dbf 1,87515.771.0015.775,165100.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_09.dbf 1,70606.121.0006.126,569240.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_10.dbf 1,70505.961.0005.965,376130.00
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_01.dbf 3,13610.881.0010.8869709010.67
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_02.dbf 3,47010.891.0010.8998701,0920.58
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_03.dbf 3,66010.881.0010.8996501,4470.47
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_04.dbf 2,80910.881.0010.8866901,3860.51
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_05.dbf 2,92810.901.0010.911,12806770.44
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_06.dbf 2,50010.921.0010.921,40807090.41
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_07.dbf 2,52110.901.0010.901,51604360.50
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_08.dbf 2,75110.891.0010.8979005130.60
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_09.dbf 3,16210.891.0010.8962108100.57
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_10.dbf 2,94910.891.0010.881,07807800.37
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_01.dbf 41500.821.0000.82371000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_02.dbf 42100.881.0000.90246000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_03.dbf 36100.801.0000.83396000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_04.dbf 38300.861.0000.86706010.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_05.dbf 33700.831.0000.80450000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_06.dbf 30400.791.0000.79398000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_07.dbf 34700.841.0000.84379000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_08.dbf 53800.871.0000.87179000.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_09.dbf 42000.811.0000.81670020.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_10.dbf 32900.791.0000.79400000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_01.dbf 33800.771.0000.7747000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_02.dbf 31000.771.0000.7762000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_03.dbf 37300.781.0000.7844000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_04.dbf 26000.691.0000.69106000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_05.dbf 23500.721.0000.7276000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_06.dbf 23100.691.0000.7441000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_07.dbf 25100.721.0000.72110000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_08.dbf 30100.731.0000.73247000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_09.dbf 27500.761.0000.7666000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_10.dbf 29900.771.0000.7799000.00
TS_IDX_T_EXP_CONTAINER_161+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_161.dbf 5602.501.0002.32162000.00
TS_IDX_T_EXP_CONTAINER_162+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_162.dbf 5101.571.0001.57223000.00
TS_IDX_T_EXP_CONTAINER_163+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_163.dbf 5401.851.0001.8517000.00
TS_IDX_T_EXP_CONTAINER_164+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_164.dbf 3600.001.0000.0092000.00
TS_IDX_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_165.dbf 5202.501.0002.311,488010.00
TS_IDX_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165_01.dbf 1800.001.0000.001,362000.00
TS_IDX_T_EXP_CONTAINER_166+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_166.dbf 5001.401.0001.40281000.00
TS_IDX_T_EXP_CONTAINER_167+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_167.dbf 5701.931.0001.9351000.00
TS_IDX_T_EXP_CONTAINER_168+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_168.dbf 5402.411.0002.4143000.00
TS_IDX_T_EXP_CONTAINER_169+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_169.dbf 6401.411.0001.4127000.00
TS_IDX_T_EXP_CONTAINER_170+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_170.dbf 6601.971.0001.97131000.00
TS_IDX_T_EXP_CONTAINER_171+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_171.dbf 5901.191.0001.3697010.00
TS_IDX_T_EXP_CONTAINER_172+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_172.dbf 5901.531.0001.5395000.00
TS_IDX_T_EXP_CONTAINER_173+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_173.dbf 5300.941.0000.94154000.00
TS_IDX_T_EXP_CONTAINER_174+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_174.dbf 6302.061.0002.06195000.00
TS_IDX_T_EXP_CONTAINER_175+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_175.dbf 6401.881.0001.88476000.00
TS_IDX_T_EXP_CONTAINER_176+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_176.dbf 4500.001.0000.0043000.00
TS_IDX_T_EXP_CONTAINER_177+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_177.dbf 6301.431.0001.59145000.00
TS_IDX_T_EXP_CONTAINER_178+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_178.dbf 6401.251.0001.25131000.00
TS_IDX_T_EXP_CONTAINER_179+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_179.dbf 5701.231.0001.40197000.00
TS_IDX_T_EXP_CONTAINER_180+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_180.dbf 6601.821.0001.6786000.00
TS_IDX_T_EXP_CONTAINER_181+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_181.dbf 6301.431.0001.43559000.00
TS_IDX_T_EXP_CONTAINER_182+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_182.dbf 6201.941.0001.9475000.00
TS_IDX_T_EXP_CONTAINER_183+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_183.dbf 6101.311.0001.31110000.00
TS_IDX_T_EXP_CONTAINER_184+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_184.dbf 6401.251.0001.0946000.00
TS_IDX_T_EXP_CONTAINER_185+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_185.dbf 6101.311.0001.3172000.00
TS_IDX_T_EXP_CONTAINER_186+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_186.dbf 5801.211.0001.21576000.00
TS_IDX_T_EXP_CONTAINER_187+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_187.dbf 5500.731.0000.73104000.00
TS_IDX_T_EXP_CONTAINER_188+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_188.dbf 6301.901.0001.90184000.00
TS_IDX_T_EXP_CONTAINER_189+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_189.dbf 5801.211.0001.2139000.00
TS_IDX_T_EXP_CONTAINER_190+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_190.dbf 6402.341.0002.3428000.00
TS_IDX_T_EXP_CONTAINER_191+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_191.dbf 6401.721.0001.88133000.00
TS_IDX_T_EXP_CONTAINER_192+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_192.dbf 5400.001.0000.0054000.00
TS_IDX_T_EXP_CONTAINER_193+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_193.dbf 7301.231.0001.23132000.00
TS_IDX_T_EXP_CONTAINER_194+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_194.dbf 6200.651.0000.65360000.00
TS_IDX_T_EXP_CONTAINER_195+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_195.dbf 6800.881.0000.88304000.00
TS_IDX_T_EXP_CONTAINER_196+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_196.dbf 7101.411.0001.4163000.00
TS_IDX_T_EXP_CONTAINER_197+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_197.dbf 6701.041.0001.0491000.00
TS_IDX_T_EXP_CONTAINER_198+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_198.dbf 7301.231.0001.23137000.00
TS_IDX_T_EXP_CONTAINER_199+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_199.dbf 7201.671.0001.67593000.00
TS_IDX_T_EXP_CONTAINER_200+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_200.dbf 6000.331.0000.33101000.00
TS_IDX_T_EXP_CONTAINER_201+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_201.dbf 7101.411.0001.4169000.00
TS_IDX_T_EXP_CONTAINER_202+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_202.dbf 6901.161.0001.16804000.00
TS_IDX_T_EXP_CONTAINER_203+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_203.dbf 5901.021.0001.19123000.00
TS_IDX_T_EXP_CONTAINER_204+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_204.dbf 5901.531.0001.53160000.00
TS_IDX_T_EXP_CONTAINER_205+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_205.dbf 6201.451.0001.4552000.00
TS_IDX_T_EXP_CONTAINER_206+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_206.dbf 5601.251.0001.07670000.00
TS_IDX_T_EXP_CONTAINER_207+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_207.dbf 5801.381.0001.38222000.00
TS_IDX_T_EXP_CONTAINER_208+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_208.dbf 6401.721.0001.721,953100.00
TS_IDX_T_EXP_CONTAINER_209+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_209.dbf 5801.381.0001.21172000.00
TS_IDX_T_EXP_CONTAINER_210+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_210.dbf 6201.291.0001.2961000.00
TS_IDX_T_EXP_CONTAINER_211+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_211.dbf 5801.031.0001.2125000.00
TS_IDX_T_EXP_CONTAINER_212+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_212.dbf 6402.501.0002.5037000.00
TS_IDX_T_EXP_CONTAINER_213+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_213.dbf 6101.311.0001.3145000.00
TS_IDX_T_EXP_CONTAINER_214+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_214.dbf 6301.751.0001.75153000.00
TS_IDX_T_EXP_CONTAINER_215+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_215.dbf 7001.431.0001.29422000.00
TS_IDX_T_EXP_CONTAINER_216+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_216.dbf 7201.251.0001.25166000.00
TS_IDX_T_EXP_CONTAINER_217+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_217.dbf 7201.111.0001.1172000.00
TS_IDX_T_EXP_CONTAINER_218+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_218.dbf 7100.991.0000.9960000.00
TS_IDX_T_EXP_CONTAINER_219+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_219.dbf 7100.991.0000.99344000.00
TS_IDX_T_EXP_CONTAINER_220+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_220.dbf 7301.371.0001.37200000.00
TS_IDX_T_EXP_CONTAINER_221+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_221.dbf 6200.481.0000.65171000.00
TS_IDX_T_EXP_CONTAINER_222+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_222.dbf 6701.041.0001.0492000.00
TS_IDX_T_EXP_CONTAINER_223+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_223.dbf 5800.171.0000.34102000.00
TS_IDX_T_EXP_CONTAINER_224+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_224.dbf 6100.491.0000.49168000.00
TS_IDX_T_EXP_CONTAINER_225+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_225.dbf 6400.631.0000.63506000.00
TS_IDX_T_EXP_CONTAINER_226+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_226.dbf 6101.481.0001.4855000.00
TS_IDX_T_EXP_CONTAINER_227+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_227.dbf 5600.891.0000.89788000.00
TS_IDX_T_EXP_CONTAINER_228+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_228.dbf 5801.031.0001.03458010.00
TS_IDX_T_EXP_CONTAINER_229+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_229.dbf 6401.561.0001.56153000.00
TS_IDX_T_EXP_CONTAINER_230+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_230.dbf 5801.901.0001.9038000.00
TS_IDX_T_EXP_CONTAINER_231+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_231.dbf 6601.971.0001.9754000.00
TS_IDX_T_EXP_CONTAINER_232+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_232.dbf 6502.001.0002.0046000.00
TS_IDX_T_EXP_CONTAINER_233+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_233.dbf 6601.671.0001.67393000.00
TS_IDX_T_EXP_CONTAINER_234+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_234.dbf 5801.211.0001.2143000.00
TS_IDX_T_EXP_CONTAINER_235+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_235.dbf 6401.251.0001.2550000.00
TS_IDX_T_EXP_CONTAINER_236+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_236.dbf 6301.111.0001.27102000.00
TS_IDX_T_EXP_CONTAINER_237+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_237.dbf 5901.021.0001.02261010.00
TS_IDX_T_EXP_CONTAINER_238+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_238.dbf 6901.161.0001.16123000.00
TS_IDX_T_EXP_CONTAINER_239+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_239.dbf 7101.551.0001.5539000.00
TS_IDX_T_EXP_CONTAINER_240+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_240.dbf 6701.491.0001.4929000.00
TS_IDX_T_EXP_W_161+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_161.dbf 4600.221.0000.22260000.00
TS_IDX_T_EXP_W_162+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_162.dbf 4400.001.0000.00267000.00
TS_IDX_T_EXP_W_163+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_163.dbf 4400.001.0000.00100000.00
TS_IDX_T_EXP_W_164+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_164.dbf 4600.001.0000.22216020.00
TS_IDX_T_EXP_W_165+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_165.dbf 6301.751.0001.75113000.00
TS_IDX_T_EXP_W_166+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_166.dbf 4700.211.0000.43155000.00
TS_IDX_T_EXP_W_167+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_167.dbf 4400.001.0000.00140000.00
TS_IDX_T_EXP_W_168+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_168.dbf 4400.001.0000.00167000.00
TS_IDX_T_EXP_W_169+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_169.dbf 5300.001.0000.00140000.00
TS_IDX_T_EXP_W_170+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_170.dbf 7902.531.0002.53332000.00
TS_IDX_T_EXP_W_171+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_171.dbf 5300.001.0000.00133000.00
TS_IDX_T_EXP_W_172+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_172.dbf 10102.971.0003.07523000.00
TS_IDX_T_EXP_W_173+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_173.dbf 5800.521.0000.34117000.00
TS_IDX_T_EXP_W_174+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_174.dbf 12403.551.0003.55443000.00
TS_IDX_T_EXP_W_175+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_175.dbf 5300.001.0000.00312000.00
TS_IDX_T_EXP_W_176+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_176.dbf 5300.001.0000.00120000.00
TS_IDX_T_EXP_W_177+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_177.dbf 5300.001.0000.00182000.00
TS_IDX_T_EXP_W_178+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_178.dbf 5300.001.0000.00185000.00
TS_IDX_T_EXP_W_179+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_179.dbf 5300.001.0000.00162010.00
TS_IDX_T_EXP_W_180+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_180.dbf 4400.001.0000.00163000.00
TS_IDX_T_EXP_W_181+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_181.dbf 4400.001.0000.00397000.00
TS_IDX_T_EXP_W_182+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_182.dbf 4400.001.0000.0095000.00
TS_IDX_T_EXP_W_183+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_183.dbf 4400.001.0000.00193020.00
TS_IDX_T_EXP_W_184+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_184.dbf 9106.371.0006.26168000.00
TS_IDX_T_EXP_W_185+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_185.dbf 6402.191.0002.34152000.00
TS_IDX_T_EXP_W_186+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_186.dbf 4400.001.0000.00215000.00
TS_IDX_T_EXP_W_187+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_187.dbf 4400.001.0000.00177000.00
TS_IDX_T_EXP_W_188+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_188.dbf 4400.001.0000.00180000.00
TS_IDX_T_EXP_W_189+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_189.dbf 4400.001.0000.00184000.00
TS_IDX_T_EXP_W_190+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_190.dbf 4400.001.0000.00146000.00
TS_IDX_T_EXP_W_191+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_191.dbf 4900.821.0000.82145000.00
TS_IDX_T_EXP_W_192+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_192.dbf 5300.001.0000.00100000.00
TS_IDX_T_EXP_W_193+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_193.dbf 5300.001.0000.00158000.00
TS_IDX_T_EXP_W_194+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_194.dbf 5300.001.0000.00111000.00
TS_IDX_T_EXP_W_195+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_195.dbf 11904.961.0004.96231000.00
TS_IDX_T_EXP_W_196+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_196.dbf 5300.001.0000.00148000.00
TS_IDX_T_EXP_W_197+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_197.dbf 5300.001.0000.00135000.00
TS_IDX_T_EXP_W_198+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_198.dbf 5300.001.0000.00141000.00
TS_IDX_T_EXP_W_199+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_199.dbf 28806.111.0006.11181000.00
TS_IDX_T_EXP_W_200+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_200.dbf 5300.001.0000.00130000.00
TS_IDX_T_EXP_W_201+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_201.dbf 6601.211.0001.21194000.00
TS_IDX_T_EXP_W_202+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_202.dbf 6000.501.0000.67477000.00
TS_IDX_T_EXP_W_203+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_203.dbf 4400.001.0000.00129000.00
TS_IDX_T_EXP_W_204+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_204.dbf 4400.001.0000.00109000.00
TS_IDX_T_EXP_W_205+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_205.dbf 4400.001.0000.00110000.00
TS_IDX_T_EXP_W_206+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_206.dbf 4400.001.0000.00100000.00
TS_IDX_T_EXP_W_207+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_207.dbf 4400.001.0000.00168000.00
TS_IDX_T_EXP_W_208+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_208.dbf 4400.001.0000.00216000.00
TS_IDX_T_EXP_W_209+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_209.dbf 4400.001.0000.00235000.00
TS_IDX_T_EXP_W_210+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_210.dbf 4400.001.0000.00198000.00
TS_IDX_T_EXP_W_211+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_211.dbf 4400.001.0000.00137000.00
TS_IDX_T_EXP_W_212+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_212.dbf 4400.001.0000.00151000.00
TS_IDX_T_EXP_W_213+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_213.dbf 4400.001.0000.00143000.00
TS_IDX_T_EXP_W_214+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_214.dbf 4400.001.0000.00199000.00
TS_IDX_T_EXP_W_215+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_215.dbf 29507.291.0007.29928000.00
TS_IDX_T_EXP_W_216+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_216.dbf 900.001.0000.00181000.00
TS_IDX_T_EXP_W_217+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_217.dbf 1100.911.0000.91158000.00
TS_IDX_T_EXP_W_218+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_218.dbf 900.001.0000.00123000.00
TS_IDX_T_EXP_W_219+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_219.dbf 900.001.0000.00115000.00
TS_IDX_T_EXP_W_220+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_220.dbf 1402.141.0002.14221000.00
TS_IDX_T_EXP_W_221+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_221.dbf 900.001.0000.00106000.00
TS_IDX_T_EXP_W_222+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_222.dbf 900.001.0000.00123000.00
TS_IDX_T_EXP_W_223+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_223.dbf 900.001.0000.00157000.00
TS_IDX_T_EXP_W_224+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_224.dbf 2204.551.0004.55274000.00
TS_IDX_T_EXP_W_225+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_225.dbf 900.001.0000.00115000.00
TS_IDX_T_EXP_W_226+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_226.dbf 4305.351.0005.12148000.00
TS_IDX_T_EXP_W_227+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_227.dbf 900.001.0000.00119000.00
TS_IDX_T_EXP_W_228+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_228.dbf 1303.851.0003.85114000.00
TS_IDX_T_EXP_W_229+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_229.dbf 900.001.0000.00228000.00
TS_IDX_T_EXP_W_230+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_230.dbf 900.001.0000.0052000.00
TS_IDX_T_EXP_W_231+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_231.dbf 900.001.0000.00216000.00
TS_IDX_T_EXP_W_232+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_232.dbf 3106.771.0007.10181000.00
TS_IDX_T_EXP_W_233+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_233.dbf 900.001.0000.00327000.00
TS_IDX_T_EXP_W_234+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_234.dbf 900.001.0000.0049000.00
TS_IDX_T_EXP_W_235+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_235.dbf 10707.011.0007.01152000.00
TS_IDX_T_EXP_W_236+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_236.dbf 6906.381.0006.38241000.00
TS_IDX_T_EXP_W_237+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_237.dbf 3004.331.0004.33259000.00
TS_IDX_T_EXP_W_238+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_238.dbf 1800.001.0000.00174000.00
TS_IDX_T_EXP_W_239+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_239.dbf 6506.001.0006.00158000.00
TS_IDX_T_EXP_W_240+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_240.dbf 4604.351.0004.3597000.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_01.dbf 24200.911.0000.91107,8783030.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_02.dbf 14400.691.0000.69100,2532860.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_03.dbf 34701.011.0000.98106,20129160.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_04.dbf 19800.811.0000.86106,8483090.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_05.dbf 21900.871.0000.91103,21429190.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_06.dbf 23100.911.0000.91103,1762980.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_07.dbf 23200.911.0000.91106,1322920.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_08.dbf 19500.821.0000.82101,65028100.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_09.dbf 17400.861.0000.8098,73827120.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_10.dbf 19100.891.0000.89102,60828210.00
TS_IDX_YTMDM+DATA_DG/dbquery/datafile/ts_idx_ytmdm.dbf 19406.291.0006.29277000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_01.dbf 2700.001.0000.009000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_02.dbf 2700.001.0000.009000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_03.dbf 2700.001.0000.009000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_04.dbf 2700.001.0000.009000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_05.dbf 3000.671.0000.6710000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_06.dbf 2700.001.0000.009000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_07.dbf 2801.071.0001.079000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_08.dbf 2700.001.0000.009000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_09.dbf 2700.001.0000.009000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_10.dbf 2700.001.0000.009000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_01.dbf 5400.001.0000.00345000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_02.dbf 5400.001.0000.00356000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_03.dbf 5600.361.0000.18271000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_04.dbf 5400.001.0000.00361000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_05.dbf 5700.531.0000.53474000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_06.dbf 4500.001.0000.00425000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_07.dbf 4500.001.0000.00115000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_08.dbf 4800.831.0001.04902000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_09.dbf 4500.001.0000.00598000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_10.dbf 4600.221.0000.22420000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_01.dbf 2700.001.0000.009000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_02.dbf 3600.001.0000.009000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_03.dbf 3600.001.0000.009000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_04.dbf 3600.001.0000.009000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_05.dbf 3600.001.0000.009000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_06.dbf 3600.001.0000.009000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_07.dbf 3600.001.0000.009000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_08.dbf 3600.001.0000.009000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_09.dbf 3600.001.0000.009000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_10.dbf 3600.001.0000.009000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_01.dbf 4500.001.0000.00162000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_02.dbf 4500.001.0000.0081000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_03.dbf 4500.001.0000.0089000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_04.dbf 4500.001.0000.0085000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_05.dbf 5400.001.0000.0029000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_06.dbf 5400.001.0000.00139000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_07.dbf 5400.001.0000.00224000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_08.dbf 5400.001.0000.0083000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_09.dbf 5400.001.0000.00111000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_10.dbf 5400.001.0000.00112000.00
TS_T_EXP_CONTAINER_161+DATA_DG/dbquery/datafile/ts_t_exp_container_161.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_162+DATA_DG/dbquery/datafile/ts_t_exp_container_162.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_163+DATA_DG/dbquery/datafile/ts_t_exp_container_163.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_164+DATA_DG/dbquery/datafile/ts_t_exp_container_164.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165_1.dbf 1800.001.0000.009000.00
TS_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165_2.dbf 1800.001.0000.009000.00
TS_T_EXP_CONTAINER_166+DATA_DG/dbquery/datafile/ts_t_exp_container_166.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_167+DATA_DG/dbquery/datafile/ts_t_exp_container_167.dbf 1200.831.0001.679000.00
TS_T_EXP_CONTAINER_168+DATA_DG/dbquery/datafile/ts_t_exp_container_168.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_169+DATA_DG/dbquery/datafile/ts_t_exp_container_169.dbf 2404.581.0004.589000.00
TS_T_EXP_CONTAINER_170+DATA_DG/dbquery/datafile/ts_t_exp_container_170.dbf 1001.001.0001.009000.00
TS_T_EXP_CONTAINER_171+DATA_DG/dbquery/datafile/ts_t_exp_container_171.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_172+DATA_DG/dbquery/datafile/ts_t_exp_container_172.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_173+DATA_DG/dbquery/datafile/ts_t_exp_container_173.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_174+DATA_DG/dbquery/datafile/ts_t_exp_container_174.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_175+DATA_DG/dbquery/datafile/ts_t_exp_container_175.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_176+DATA_DG/dbquery/datafile/ts_t_exp_container_176.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_177+DATA_DG/dbquery/datafile/ts_t_exp_container_177.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_178+DATA_DG/dbquery/datafile/ts_t_exp_container_178.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_179+DATA_DG/dbquery/datafile/ts_t_exp_container_179.dbf 900.001.0000.009000.00
TS_T_EXP_CONTAINER_180+DATA_DG/dbquery/datafile/ts_t_exp_container_180.dbf 2201.361.0001.369000.00
TS_T_EXP_CONTAINER_181+DATA_DG/dbquery/datafile/ts_t_exp_container_181.dbf 1800.001.0000.009000.00
TS_T_EXP_CONTAINER_182+DATA_DG/dbquery/datafile/ts_t_exp_container_182.dbf 2601.541.0001.549000.00
TS_T_EXP_CONTAINER_183+DATA_DG/dbquery/datafile/ts_t_exp_container_183.dbf 1800.001.0000.009000.00
TS_T_EXP_CONTAINER_184+DATA_DG/dbquery/datafile/ts_t_exp_container_184.dbf 1800.001.0000.009000.00
TS_T_EXP_CONTAINER_185+DATA_DG/dbquery/datafile/ts_t_exp_container_185.dbf 1800.001.0000.009000.00
TS_T_EXP_CONTAINER_186+DATA_DG/dbquery/datafile/ts_t_exp_container_186.dbf 1800.001.0000.009000.00
TS_T_EXP_CONTAINER_187+DATA_DG/dbquery/datafile/ts_t_exp_container_187.dbf 2200.911.0001.369000.00
TS_T_EXP_CONTAINER_188+DATA_DG/dbquery/datafile/ts_t_exp_container_188.dbf 2703.331.0002.969000.00
TS_T_EXP_CONTAINER_189+DATA_DG/dbquery/datafile/ts_t_exp_container_189.dbf 1800.001.0000.009000.00
TS_T_EXP_CONTAINER_190+DATA_DG/dbquery/datafile/ts_t_exp_container_190.dbf 2200.911.0000.919000.00
TS_T_EXP_CONTAINER_191+DATA_DG/dbquery/datafile/ts_t_exp_container_191.dbf 1900.001.0000.009000.00
TS_T_EXP_CONTAINER_192+DATA_DG/dbquery/datafile/ts_t_exp_container_192.dbf 1800.001.0000.009000.00
TS_T_EXP_CONTAINER_193+DATA_DG/dbquery/datafile/ts_t_exp_container_193.dbf 3102.261.0002.269000.00
TS_T_EXP_CONTAINER_194+DATA_DG/dbquery/datafile/ts_t_exp_container_194.dbf 1800.001.0000.009000.00
TS_T_EXP_CONTAINER_195+DATA_DG/dbquery/datafile/ts_t_exp_container_195.dbf 1800.001.0000.009000.00
TS_T_EXP_CONTAINER_196+DATA_DG/dbquery/datafile/ts_t_exp_container_196.dbf 2701.481.0001.489000.00
TS_T_EXP_CONTAINER_197+DATA_DG/dbquery/datafile/ts_t_exp_container_197.dbf 2400.831.0000.839000.00
TS_T_EXP_CONTAINER_198+DATA_DG/dbquery/datafile/ts_t_exp_container_198.dbf 2100.951.0000.959000.00
TS_T_EXP_CONTAINER_199+DATA_DG/dbquery/datafile/ts_t_exp_container_199.dbf 1800.001.0000.009000.00
TS_T_EXP_CONTAINER_200+DATA_DG/dbquery/datafile/ts_t_exp_container_200.dbf 2200.911.0000.919000.00
TS_T_EXP_CONTAINER_201+DATA_DG/dbquery/datafile/ts_t_exp_container_201.dbf 2401.251.0001.259000.00
TS_T_EXP_CONTAINER_202+DATA_DG/dbquery/datafile/ts_t_exp_container_202.dbf 12,40832.331.0032.339000.00
TS_T_EXP_CONTAINER_203+DATA_DG/dbquery/datafile/ts_t_exp_container_203.dbf 3601.391.0001.399000.00
TS_T_EXP_CONTAINER_204+DATA_DG/dbquery/datafile/ts_t_exp_container_204.dbf 2700.001.0000.009000.00
TS_T_EXP_CONTAINER_205+DATA_DG/dbquery/datafile/ts_t_exp_container_205.dbf 2900.341.0000.349000.00
TS_T_EXP_CONTAINER_206+DATA_DG/dbquery/datafile/ts_t_exp_container_206.dbf 2700.001.0000.009000.00
TS_T_EXP_CONTAINER_207+DATA_DG/dbquery/datafile/ts_t_exp_container_207.dbf 2700.001.0000.009000.00
TS_T_EXP_CONTAINER_208+DATA_DG/dbquery/datafile/ts_t_exp_container_208.dbf 2700.001.0000.009000.00
TS_T_EXP_CONTAINER_208+DATA_DG/dbquery/datafile/ts_t_exp_container_208_1.dbf 1800.001.0000.009000.00
TS_T_EXP_CONTAINER_209+DATA_DG/dbquery/datafile/ts_t_exp_container_209.dbf 2800.001.0000.009000.00
TS_T_EXP_CONTAINER_210+DATA_DG/dbquery/datafile/ts_t_exp_container_210.dbf 2900.341.0000.349000.00
TS_T_EXP_CONTAINER_211+DATA_DG/dbquery/datafile/ts_t_exp_container_211.dbf 2900.691.0000.349000.00
TS_T_EXP_CONTAINER_212+DATA_DG/dbquery/datafile/ts_t_exp_container_212.dbf 2800.361.0000.369000.00
TS_T_EXP_CONTAINER_213+DATA_DG/dbquery/datafile/ts_t_exp_container_213.dbf 2700.001.0000.009000.00
TS_T_EXP_CONTAINER_214+DATA_DG/dbquery/datafile/ts_t_exp_container_214.dbf 3802.371.0002.379000.00
TS_T_EXP_CONTAINER_215+DATA_DG/dbquery/datafile/ts_t_exp_container_215.dbf 2800.361.0000.009000.00
TS_T_EXP_CONTAINER_216+DATA_DG/dbquery/datafile/ts_t_exp_container_216.dbf 4001.751.0002.009000.00
TS_T_EXP_CONTAINER_217+DATA_DG/dbquery/datafile/ts_t_exp_container_217.dbf 3201.561.0001.569000.00
TS_T_EXP_CONTAINER_218+DATA_DG/dbquery/datafile/ts_t_exp_container_218.dbf 2700.001.0000.009000.00
TS_T_EXP_CONTAINER_219+DATA_DG/dbquery/datafile/ts_t_exp_container_219.dbf 4802.921.0002.929000.00
TS_T_EXP_CONTAINER_220+DATA_DG/dbquery/datafile/ts_t_exp_container_220.dbf 2700.001.0000.009000.00
TS_T_EXP_CONTAINER_221+DATA_DG/dbquery/datafile/ts_t_exp_container_221.dbf 4201.901.0001.909000.00
TS_T_EXP_CONTAINER_222+DATA_DG/dbquery/datafile/ts_t_exp_container_222.dbf 2900.341.0000.009000.00
TS_T_EXP_CONTAINER_223+DATA_DG/dbquery/datafile/ts_t_exp_container_223.dbf 3501.711.0001.439000.00
TS_T_EXP_CONTAINER_224+DATA_DG/dbquery/datafile/ts_t_exp_container_224.dbf 2700.001.0000.009000.00
TS_T_EXP_CONTAINER_225+DATA_DG/dbquery/datafile/ts_t_exp_container_225.dbf 4402.501.0002.509000.00
TS_T_EXP_CONTAINER_226+DATA_DG/dbquery/datafile/ts_t_exp_container_226.dbf 3600.001.0000.009000.00
TS_T_EXP_CONTAINER_227+DATA_DG/dbquery/datafile/ts_t_exp_container_227.dbf 3600.001.0000.009000.00
TS_T_EXP_CONTAINER_228+DATA_DG/dbquery/datafile/ts_t_exp_container_228.dbf 3600.001.0000.009000.00
TS_T_EXP_CONTAINER_229+DATA_DG/dbquery/datafile/ts_t_exp_container_229.dbf 5201.921.0001.929000.00
TS_T_EXP_CONTAINER_230+DATA_DG/dbquery/datafile/ts_t_exp_container_230.dbf 3600.001.0000.009000.00
TS_T_EXP_CONTAINER_231+DATA_DG/dbquery/datafile/ts_t_exp_container_231.dbf 3600.001.0000.009000.00
TS_T_EXP_CONTAINER_232+DATA_DG/dbquery/datafile/ts_t_exp_container_232.dbf 3600.001.0000.009000.00
TS_T_EXP_CONTAINER_233+DATA_DG/dbquery/datafile/ts_t_exp_container_233.dbf 3600.001.0000.009000.00
TS_T_EXP_CONTAINER_234+DATA_DG/dbquery/datafile/ts_t_exp_container_234.dbf 3600.001.0000.009000.00
TS_T_EXP_CONTAINER_235+DATA_DG/dbquery/datafile/ts_t_exp_container_235.dbf 4100.491.0000.739000.00
TS_T_EXP_CONTAINER_236+DATA_DG/dbquery/datafile/ts_t_exp_container_236.dbf 4001.001.0001.259000.00
TS_T_EXP_CONTAINER_237+DATA_DG/dbquery/datafile/ts_t_exp_container_237.dbf 3600.001.0000.009000.00
TS_T_EXP_CONTAINER_238+DATA_DG/dbquery/datafile/ts_t_exp_container_238.dbf 5101.961.0001.969000.00
TS_T_EXP_CONTAINER_239+DATA_DG/dbquery/datafile/ts_t_exp_container_239.dbf 3600.001.0000.009000.00
TS_T_EXP_CONTAINER_240+DATA_DG/dbquery/datafile/ts_t_exp_container_240.dbf 3700.001.0000.009000.00
TS_T_EXP_W_160+DATA_DG/dbquery/datafile/ts_t_exp_w_160.dbf 5400.001.0000.009000.00
TS_T_EXP_W_161+DATA_DG/dbquery/datafile/ts_t_exp_w_161.dbf 5400.001.0000.009000.00
TS_T_EXP_W_162+DATA_DG/dbquery/datafile/ts_t_exp_w_162.dbf 5400.001.0000.009000.00
TS_T_EXP_W_163+DATA_DG/dbquery/datafile/ts_t_exp_w_163.dbf 5400.001.0000.009000.00
TS_T_EXP_W_164+DATA_DG/dbquery/datafile/ts_t_exp_w_164.dbf 5400.001.0000.009000.00
TS_T_EXP_W_165+DATA_DG/dbquery/datafile/ts_t_exp_w_165.dbf 5400.001.0000.009000.00
TS_T_EXP_W_166+DATA_DG/dbquery/datafile/ts_t_exp_w_166.dbf 5400.001.0000.009000.00
TS_T_EXP_W_167+DATA_DG/dbquery/datafile/ts_t_exp_w_167.dbf 5400.001.0000.009000.00
TS_T_EXP_W_168+DATA_DG/dbquery/datafile/ts_t_exp_w_168.dbf 4500.001.0000.009000.00
TS_T_EXP_W_169+DATA_DG/dbquery/datafile/ts_t_exp_w_169.dbf 4500.001.0000.009000.00
TS_T_EXP_W_170+DATA_DG/dbquery/datafile/ts_t_exp_w_170.dbf 4500.001.0000.009000.00
TS_T_EXP_W_171+DATA_DG/dbquery/datafile/ts_t_exp_w_171.dbf 4500.001.0000.009000.00
TS_T_EXP_W_172+DATA_DG/dbquery/datafile/ts_t_exp_w_172.dbf 4500.001.0000.009000.00
TS_T_EXP_W_173+DATA_DG/dbquery/datafile/ts_t_exp_w_173.dbf 4500.001.0000.009000.00
TS_T_EXP_W_174+DATA_DG/dbquery/datafile/ts_t_exp_w_174.dbf 4500.001.0000.009000.00
TS_T_EXP_W_175+DATA_DG/dbquery/datafile/ts_t_exp_w_175.dbf 4500.001.0000.009000.00
TS_T_EXP_W_176+DATA_DG/dbquery/datafile/ts_t_exp_w_176.dbf 4500.001.0000.009000.00
TS_T_EXP_W_177+DATA_DG/dbquery/datafile/ts_t_exp_w_177.dbf 4500.001.0000.009000.00
TS_T_EXP_W_178+DATA_DG/dbquery/datafile/ts_t_exp_w_178.dbf 4500.001.0000.009000.00
TS_T_EXP_W_179+DATA_DG/dbquery/datafile/ts_t_exp_w_179.dbf 4500.001.0000.009000.00
TS_T_EXP_W_180+DATA_DG/dbquery/datafile/ts_t_exp_w_180.dbf 5400.001.0000.009000.00
TS_T_EXP_W_181+DATA_DG/dbquery/datafile/ts_t_exp_w_181.dbf 5400.001.0000.009000.00
TS_T_EXP_W_182+DATA_DG/dbquery/datafile/ts_t_exp_w_182.dbf 5400.001.0000.009000.00
TS_T_EXP_W_183+DATA_DG/dbquery/datafile/ts_t_exp_w_183.dbf 5400.001.0000.009000.00
TS_T_EXP_W_184+DATA_DG/dbquery/datafile/ts_t_exp_w_184.dbf 5400.001.0000.009000.00
TS_T_EXP_W_185+DATA_DG/dbquery/datafile/ts_t_exp_w_185.dbf 5400.001.0000.009000.00
TS_T_EXP_W_186+DATA_DG/dbquery/datafile/ts_t_exp_w_186.dbf 5400.001.0000.009000.00
TS_T_EXP_W_187+DATA_DG/dbquery/datafile/ts_t_exp_w_187.dbf 5400.001.0000.009000.00
TS_T_EXP_W_188+DATA_DG/dbquery/datafile/ts_t_exp_w_188.dbf 5400.001.0000.009000.00
TS_T_EXP_W_189+DATA_DG/dbquery/datafile/ts_t_exp_w_189.dbf 5400.001.0000.009000.00
TS_T_EXP_W_190+DATA_DG/dbquery/datafile/ts_t_exp_w_190.dbf 5400.001.0000.009000.00
TS_T_EXP_W_191+DATA_DG/dbquery/datafile/ts_t_exp_w_191.dbf 4500.001.0000.009000.00
TS_T_EXP_W_192+DATA_DG/dbquery/datafile/ts_t_exp_w_192.dbf 4500.001.0000.009000.00
TS_T_EXP_W_193+DATA_DG/dbquery/datafile/ts_t_exp_w_193.dbf 4500.001.0000.009000.00
TS_T_EXP_W_194+DATA_DG/dbquery/datafile/ts_t_exp_w_194.dbf 4500.001.0000.009000.00
TS_T_EXP_W_195+DATA_DG/dbquery/datafile/ts_t_exp_w_195.dbf 4500.001.0000.009000.00
TS_T_EXP_W_196+DATA_DG/dbquery/datafile/ts_t_exp_w_196.dbf 4500.001.0000.009000.00
TS_T_EXP_W_197+DATA_DG/dbquery/datafile/ts_t_exp_w_197.dbf 4500.001.0000.009000.00
TS_T_EXP_W_198+DATA_DG/dbquery/datafile/ts_t_exp_w_198.dbf 4500.001.0000.009000.00
TS_T_EXP_W_199+DATA_DG/dbquery/datafile/ts_t_exp_w_199.dbf 4500.001.0000.009000.00
TS_T_EXP_W_200+DATA_DG/dbquery/datafile/ts_t_exp_w_200.dbf 4500.001.0000.009000.00
TS_T_EXP_W_201+DATA_DG/dbquery/datafile/ts_t_exp_w_201.dbf 4500.001.0000.009000.00
TS_T_EXP_W_202+DATA_DG/dbquery/datafile/ts_t_exp_w_202.dbf 4500.001.0000.009000.00
TS_T_EXP_W_203+DATA_DG/dbquery/datafile/ts_t_exp_w_203.dbf 5300.001.0000.008000.00
TS_T_EXP_W_204+DATA_DG/dbquery/datafile/ts_t_exp_w_204.dbf 5300.001.0000.008000.00
TS_T_EXP_W_205+DATA_DG/dbquery/datafile/ts_t_exp_w_205.dbf 5300.001.0000.008000.00
TS_T_EXP_W_206+DATA_DG/dbquery/datafile/ts_t_exp_w_206.dbf 11502.177.4000.178000.00
TS_T_EXP_W_207+DATA_DG/dbquery/datafile/ts_t_exp_w_207.dbf 5300.001.0000.008000.00
TS_T_EXP_W_208+DATA_DG/dbquery/datafile/ts_t_exp_w_208.dbf 5300.001.0000.008000.00
TS_T_EXP_W_209+DATA_DG/dbquery/datafile/ts_t_exp_w_209.dbf 5300.001.0000.008000.00
TS_T_EXP_W_210+DATA_DG/dbquery/datafile/ts_t_exp_w_210.dbf 5300.001.0000.008000.00
TS_T_EXP_W_211+DATA_DG/dbquery/datafile/ts_t_exp_w_211.dbf 5300.001.0000.008000.00
TS_T_EXP_W_212+DATA_DG/dbquery/datafile/ts_t_exp_w_212.dbf 5300.001.0000.008000.00
TS_T_EXP_W_213+DATA_DG/dbquery/datafile/ts_t_exp_w_213.dbf 5300.001.0000.008000.00
TS_T_EXP_W_214+DATA_DG/dbquery/datafile/ts_t_exp_w_214.dbf 4400.001.0000.008000.00
TS_T_EXP_W_215+DATA_DG/dbquery/datafile/ts_t_exp_w_215.dbf 4400.001.0000.008000.00
TS_T_EXP_W_216+DATA_DG/dbquery/datafile/ts_t_exp_w_216.dbf 4400.001.0000.008000.00
TS_T_EXP_W_217+DATA_DG/dbquery/datafile/ts_t_exp_w_217.dbf 4400.001.0000.008000.00
TS_T_EXP_W_218+DATA_DG/dbquery/datafile/ts_t_exp_w_218.dbf 4400.001.0000.008000.00
TS_T_EXP_W_219+DATA_DG/dbquery/datafile/ts_t_exp_w_219.dbf 4400.001.0000.008000.00
TS_T_EXP_W_220+DATA_DG/dbquery/datafile/ts_t_exp_w_220.dbf 4400.001.0000.008000.00
TS_T_EXP_W_221+DATA_DG/dbquery/datafile/ts_t_exp_w_221.dbf 4400.001.0000.008000.00
TS_T_EXP_W_222+DATA_DG/dbquery/datafile/ts_t_exp_w_222.dbf 4400.001.0000.008000.00
TS_T_EXP_W_223+DATA_DG/dbquery/datafile/ts_t_exp_w_223.dbf 4400.001.0000.008000.00
TS_T_EXP_W_224+DATA_DG/dbquery/datafile/ts_t_exp_w_224.dbf 4400.001.0000.008000.00
TS_T_EXP_W_225+DATA_DG/dbquery/datafile/ts_t_exp_w_225.dbf 4400.001.0000.008000.00
TS_T_EXP_W_226+DATA_DG/dbquery/datafile/ts_t_exp_w_226.dbf 5300.001.0000.009000.00
TS_T_EXP_W_227+DATA_DG/dbquery/datafile/ts_t_exp_w_227.dbf 5300.001.0000.009000.00
TS_T_EXP_W_228+DATA_DG/dbquery/datafile/ts_t_exp_w_228.dbf 5300.001.0000.009000.00
TS_T_EXP_W_229+DATA_DG/dbquery/datafile/ts_t_exp_w_229.dbf 5300.001.0000.009000.00
TS_T_EXP_W_230+DATA_DG/dbquery/datafile/ts_t_exp_w_230.dbf 5300.001.0000.009000.00
TS_T_EXP_W_231+DATA_DG/dbquery/datafile/ts_t_exp_w_231.dbf 5300.001.0000.009000.00
TS_T_EXP_W_232+DATA_DG/dbquery/datafile/ts_t_exp_w_232.dbf 5300.001.0000.009000.00
TS_T_EXP_W_233+DATA_DG/dbquery/datafile/ts_t_exp_w_233.dbf 5300.001.0000.009000.00
TS_T_EXP_W_234+DATA_DG/dbquery/datafile/ts_t_exp_w_234.dbf 5300.001.0000.009000.00
TS_T_EXP_W_235+DATA_DG/dbquery/datafile/ts_t_exp_w_235.dbf 5400.191.0000.199000.00
TS_T_EXP_W_236+DATA_DG/dbquery/datafile/ts_t_exp_w_236.dbf 5300.001.0000.009000.00
TS_T_EXP_W_237+DATA_DG/dbquery/datafile/ts_t_exp_w_237.dbf 4400.001.0000.009000.00
TS_T_EXP_W_238+DATA_DG/dbquery/datafile/ts_t_exp_w_238.dbf 4400.001.0000.009000.00
TS_T_EXP_W_239+DATA_DG/dbquery/datafile/ts_t_exp_w_239.dbf 4400.001.0000.009000.00
TS_T_EXP_W_240+DATA_DG/dbquery/datafile/ts_t_exp_w_240.dbf 4400.001.0000.009000.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_01.dbf 3901.031.0001.0346,9931330.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_02.dbf 3700.001.0000.2748,5641300.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_03.dbf 3600.001.0000.0042,5841200.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_04.dbf 5700.351.0000.3544,3351210.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_05.dbf 5700.181.0000.1842,1891250.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_06.dbf 5400.001.0000.0034,2571000.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_07.dbf 5800.341.0000.3427,917800.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_08.dbf 5500.181.0000.1827,170800.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_09.dbf 5900.681.0000.6829,781800.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_10.dbf 6000.671.0000.5038,4511100.00
TS_YTMDM+DATA_DG/dbquery/datafile/ts_ytmdb.dbf 29106.981.0006.981,398000.00
TS_YTMDM+DATA_DG/dbquery/datafile/ts_ytmdb1.dbf 6504.621.0004.77313000.00
UNDOTBS1+DATA_DG/dbquery/datafile/undotbs1.263.828812057 900.001.0000.0011,59731380.22
USERS+DATA_DG/dbquery/datafile/users.265.828812065 900.001.0000.009000.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,869100271,863,45970,0072,320,285009,114


Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00002,320,1800


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
B086212545632254414720041472004148035   
E056123844320468238938341472002389383   


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.25366,2951645002.00
D29,6960.193,6581.53248,8351332188.00
D44,5440.295,4881.33215,7311244026.00
D59,3920.397,3171.24201,2971205586.00
D74,2400.489,1461.18191,4291179306.00
D89,0880.5810,9751.13184,0191159570.00
D103,9360.6812,8051.10178,0281143617.00
D118,7840.7814,6341.06171,7001126762.00
D133,6320.8716,4631.03166,8081113735.00
D148,4800.9718,2921.01163,5231104986.00
D153,0881.0018,8601.00162,5871102493.00
D163,3281.0720,1220.98159,303193748.00
D178,1761.1621,9510.96156,803187089.00
D193,0241.2623,7800.95154,245180278.00
D207,8721.3625,6090.93151,765173673.00
D222,7201.4527,4380.92149,555167786.00
D237,5681.5529,2680.91148,057163798.00
D252,4161.6531,0970.90146,694160169.00
D267,2641.7532,9260.90145,856157935.00
D282,1121.8434,7550.89145,169156108.00
D296,9601.9436,5850.89144,081153209.00


Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.001,4400


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,5272,593.880.000.000.000.001,048,576
E61,44053,5022,683.9824.360.91100.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
2K4K13,32713,32700
64K128K373700
128K256K2200
256K512K2200
512K1024K636300
1M2M73273200
2M4M818100
4M8M353500
8M16M2200
16M32M3300


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,129,867.195,049.46100.00030,894,835
15,3600.251,129,867.195,049.46100.00030,894,835
30,7200.501,129,867.195,049.46100.00030,894,835
46,0800.751,129,867.195,049.46100.00030,894,835
61,4401.001,129,867.195,049.46100.00030,894,835
73,7281.201,129,867.192,351.22100.00030,821,383
86,0161.401,129,867.192,351.22100.00030,821,383
98,3041.601,129,867.192,351.22100.00030,821,383
110,5921.801,129,867.192,351.22100.00030,821,383
122,8802.001,129,867.192,351.22100.00030,821,383
184,3203.001,129,867.192,351.22100.00030,821,383
245,7604.001,129,867.192,351.22100.00030,821,383
368,6406.001,129,867.192,351.22100.00030,821,383
491,5208.001,129,867.192,351.22100.00030,821,383


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.7369917,0081,661,1520.67837,00949.01262,556
6,1440.801,20827,1072,477,4271.0020,7341.21408,897
6,6560.871,71937,6422,480,1571.0018,0041.05409,569
7,1680.932,23049,8912,480,6531.0017,5081.03409,704
7,6801.002,74261,5682,481,0821.0017,0791.00410,232
8,1921.073,25474,7342,481,6901.0016,4710.96410,414
8,7041.133,76589,7552,481,7711.0016,3900.96410,435
9,2161.204,277103,4842,481,8421.0016,3190.96410,452
9,7281.274,789118,3902,481,8951.0016,2660.95410,466
10,2401.335,300133,1262,481,9371.0016,2240.95410,476
10,7521.405,812148,7682,481,9651.0016,1960.95410,483
11,2641.476,323164,2412,481,9851.0016,1760.95410,487
11,7761.536,835180,3782,481,9961.0016,1650.95410,488
12,2881.607,347196,6212,482,0041.0016,1570.95410,491
12,8001.677,859212,8642,482,0131.0016,1480.95410,493
13,8241.808,883245,3502,482,0371.0016,1240.94410,497
14,8481.939,907277,8362,482,0791.0016,0820.94410,503
15,8722.0710,931310,3222,482,0831.0016,0780.94410,503


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 block8,97451
undo header13100
file header block701
1st level bmb200


Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 17217209915155.15
TX-Transaction (allocate ITL entry) 88031373.33
TX-Transaction 277,430277,43001050.00
CF-Controlfile Transaction 2,1182,1180306.67
TX-Transaction (index contention) 3,7733,77303400.29
CI-Cross-Instance Call Invocation 121201010.00
HW-Segment High Water Mark 5,0445,0440300.00
FB-Format Block 3,7393,7390100.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
2155.80279,1298521316.2/26.20/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
17-Feb 09:5918,88233,42385011260/00/0/0/0/0/0
17-Feb 09:4921,64538,01224812160/00/0/0/0/0/0
17-Feb 09:3925,09443,60285211260/00/0/0/0/0/0
17-Feb 09:2926,57447,76024911160/00/0/0/0/0/0
17-Feb 09:1931,09455,16585213260/00/0/0/0/0/0
17-Feb 09:0932,51561,16725012160/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 latch10.00 00 
ASM Keyed state latch3,6610.00 00 
ASM allocation9520.00 00 
ASM db client latch3,2580.00 00 
ASM map headers3830.00 00 
ASM map load waiting list990.00 00 
ASM map operation freelist1530.00 00 
ASM map operation hash table4,137,8950.000.0000 
ASM network background latch2,4220.00 00 
ASM network state latch1,0210.00 00 
AWR Alerted Metric Element list82,5320.00 00 
Change Notification Hash table latch1,2010.00 00 
Consistent RBA250,4570.010.0000 
DML lock allocation1,870,7940.000.0000 
Event Group Locks3,7410.00 00 
FAL Queue1610.00 00 
FIB s.o chain latch820.00 00 
FOB s.o list latch8,6030.00 00 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch3,613,8790.010.870345,0680.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 SGA30.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 latch10.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch90.00 00 
KWQS pqueue ctx latch970.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch1,9710.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,0020.00 00 
OS process allocation11,3790.010.0000 
OS process: request allocation3,6610.00 00 
PL/SQL warning settings2,4740.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch74,6420.00 00 
Reserved Space Latch320.00 00 
Result Cache: RC Latch278,1960.000.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,1970.00
SQL memory manager workarea list latch102,9740.00 00 
Shared B-Tree3700.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,574,8170.750.0100 
active service list13,4300.050.0003,8700.00
alert log latch160.00 00 
archive control3320.00 00 
archive process latch4920.411.0000 
begin backup scn array10.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles70,6220.000.0000 
cache buffers chains586,626,3520.080.000242,8560.00
cache buffers lru chain2,452,2360.000.0602,745,4400.00
cache table scan latch590.00 0590.00
call allocation10,1200.210.6200 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch3,6760.00 00 
channel operations parent latch39,1010.00 00 
checkpoint queue latch41,745,4500.000.0202,222,7080.00
client/application info3,0680.00 00 
compile environment latch1,9040.00 00 
corrupted undo seg latch271,9130.00 00 
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 allocation2490.00 00 
done queue latch10.00 00 
dummy allocation3,7980.00 00 
eighth spare latch - X parent10.00 00 
eleventh spare latch - children10.00 00 
enqueue freelist latch10.00 0672,2610.00
enqueue hash chains3,103,2400.010.02030.00
fifteenth spare latch - children10.00 00 
file cache latch9,3250.00 00 
first Audit Vault latch770.00 00 
flashback copy10.00 00 
fourteenth spare latch - children10.00 00 
fourth Audit Vault latch10.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs resource validate list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA800.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch8850.00 0125,5340.00
hash table modification latch4430.00 00 
heartbeat check10.00 00 
internal temp table object number allocation latch90.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 latch80.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 lock370.00 00 
ksuosstats global area3630.00 00 
ksv allocation latch1290.00 00 
ksv class latch4,4670.270.0000 
ksv instance latch280.00 00 
ksv msg queue latch730.00 0720.00
ksz_so allocation latch3,6610.030.0000 
ktm global data2,3030.00 00 
kwqbsn:qsga1400.00 00 
lgwr LWN SCN251,4270.040.0000 
list of block allocation264,7640.010.0000 
loader state object freelist2,4020.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 latch1530.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch2,5450.00 00 
messages3,950,3040.360.0100 
mostly latch-free SCN255,2331.080.0000 
msg queue latch10.00 00 
multiblock read objects1320.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch570.00 00 
nineth spare latch - X parent10.00 00 
object queue header heap40,0040.00 011,0970.00
object queue header operation7,489,9630.020.1000 
object stats modification67,2790.000.0000 
parallel query alloc buffer2,4010.00 00 
parallel query stats10.00 00 
parameter list6,0930.00 00 
parameter table management4,7480.040.5000 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue10,4851.800.00015,8171.73
process allocation3,7990.031.0001,8360.00
process group creation3,6610.030.0000 
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,236,1080.190.0207,729,7900.27
redo copy10.00 07,736,4520.10
redo writing2,353,8090.390.0100 
reservation so alloc latch160.00 00 
resmgr group change latch2330.00 00 
resmgr:active threads3,7980.00 00 
resmgr:actses change group1750.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list3,7970.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,661,9390.020.0102630.00
rules engine rule set statistics1000.00 00 
second Audit Vault latch10.00 00 
segmented array pool720.00 00 
sequence cache5,4270.00 00 
session allocation537,1540.000.000533,4030.00
session idle bit7,397,7660.000.0100 
session queue latch10.00 00 
session state list latch7480.00 00 
session switching1,8830.00 00 
session timer1,1990.00 00 
seventh spare latch - X parent10.00 00 
shared pool458,0530.030.2201,3830.00
shared pool sim alloc240.00 00 
shared pool simulator8,6580.00 00 
sim partition latch10.00 00 
simulator hash latch17,098,4860.000.0000 
simulator lru latch255,9860.010.00016,828,4730.72
sixth spare latch - X parent10.00 00 
sort extent pool6560.00 00 
space background state object latch60.00 00 
space background task latch27,27911.630.1302,7810.68
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,1750.00 00 
transaction allocation9,3920.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,763,9140.000.0000 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 
write info latch0  0250,3760.00


Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains586,626,352441,1251,310439,873
messages3,950,30414,2179414,124
active checkpoint queue latch1,574,81711,87715611,722
redo writing2,353,8099,0801008,980
redo allocation2,236,1084,241824,162
space background task latch27,2793,1724152,757
mostly latch-free SCN255,2332,750102,740
object queue header operation7,489,9631,7741751,604
checkpoint queue latch41,745,45068712675
row cache objects1,661,9392842282
enqueue hash chains3,103,2401893186
In memory undo latch3,613,87918416034
shared pool458,05313931109
cache buffers lru chain2,452,23680575
session idle bit7,397,76678177
call allocation10,12021139
archive process latch492220
parameter table management4,748211
process allocation3,799110


Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latchktiFlush: child012738
In memory undo latchkticmt: child02923
In memory undo latchktiFlushMe071
PC and Classifier lists for WLMNo latch050
active checkpoint queue latchkcbbacq: scan active checkpoints0156156
archive process latchkcrrsarc020
cache buffers chainskcbgtcr_20884422
cache buffers chainskcbgtcr: fast path (cr pin)0446874
cache buffers chainskcbgtcr: fast path0150
cache buffers chainskcbgtcr: kslbegin excl01348
cache buffers chainskcbgcur_2066
cache buffers chainskcbchg1: mod cr pin042
cache buffers chainskcbbxsv010
cache buffers chainskcbrls_2010
cache buffers lru chainkcbzgws050
call allocationksuxds0108
call allocationksudlp: top call033
checkpoint queue latchkcbklbc_cql050
checkpoint queue latchkcbkubc_4043
checkpoint queue latchkcbbwthc: thread checkpoint buffers028
checkpoint queue latchkcbbcthc: check thread queue010
enqueue hash chainsksqgtl3022
enqueue hash chainsksqrcl011
lgwr LWN SCNkcs023090
messagesksarcv05721
messagesksaamb: after wakeup03672
messagesksarcv: after wait011
mostly latch-free SCNkcslcu30110
object queue header operationkcbo_switch_cq011971
object queue header operationkcbo_switch_q_bg05953
object queue header operationkcbo_switch_mq_bg01058
object queue header operationkcbo_link_q073
object queue header operationkcbo_unlink_q024
object queue header operationkcbo_sw_buf012
parameter table managementksp_param_table_free010
process allocationksucrp:1010
redo allocationkcrfw_redo_gen: redo allocation 10800
redo allocationkcrfw_redo_gen: redo allocation 30142
redo allocationkcrfw_redo_write: before write0119
redo writingkcrfwcr09596
redo writingkcrfw_post: rba scn pair030
redo writingkcrfw_cal_target_rba020
row cache objectskqreqd: reget010
row cache objectskqrpre: find obj012
session idle bitksupuc: clear busy010
shared poolkghalo0288
shared poolkghupr1028
shared poolkghalp013
space background task latchktsj_grab_task0408413
space background task latchktsjCreateTask010
space background task latchktsj_detach_task012


Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Cursor Pinkkslce [KKSCHLPIN2]280
Library Cachekglhdgn2 106120
Library Cachekgllkc1 57110
Library Cachekglhdgn1 6290
Library Cachekgllkdl1 8590
Cursor ParentkkscsPruneChild [KKSPRTLOC35]70
Library Cachekglpndl1 9530
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]30
Library Cachekglini1 3210
Library Cachekgllldl1 9710
Library Cachekglpin1 410
Library Cachekglpnal1 9010


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_165PAR_2014_02_15TABLE PARTITION70,719,07225.99
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_16TABLE PARTITION60,906,40022.39
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_14TABLE PARTITION53,747,88819.76
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_17TABLE PARTITION19,096,5287.02
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_13TABLE PARTITION3,383,6321.24


Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_202_02 INDEX790.09
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_161_02 INDEX660.07
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_186_02 INDEX660.07
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_183_02 INDEX550.06
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_229_02 INDEX500.06


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_202_02 INDEX790.09
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_161_02 INDEX660.08
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_186_02 INDEX660.08
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_183_02 INDEX550.06
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_229_02 INDEX500.06


Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_202_02 INDEX790.09
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_161_02 INDEX660.08
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_186_02 INDEX660.08
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_183_02 INDEX550.06
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_229_02 INDEX500.06


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_YTEXPT_EXP_TAKING_STATUS_161 TABLE28,6371.23
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_215 TABLE20,9900.90
YTEXPTS_IDX_CONTAINERPK_EXP_CONTAINER_165PAR_2014_02_17INDEX PARTITION19,8860.86
YTEXPTS_IDX_YTEXPUK_EXP_DELIVERY_STATUS_165 INDEX13,2060.57
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_202 TABLE10,6640.46


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 TABLE20,6531.32
YTEXPTS_IDX_YTEXPUK_EXP_DELIVERY_STATUS_165 INDEX11,6180.74
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_215 TABLE11,5170.74
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_208_02 INDEX7,3400.47
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_202 TABLE6,6080.42


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 INDEX99,8247.88
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_215 TABLE66,0165.21
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_202_02 INDEX47,1843.72
YTEXPTS_YTEXPT_EXP_TAKING_STATUS_161 TABLE36,7362.90
YTEXPTS_IDX_CONTAINERPK_EXP_CONTAINER_165PAR_2014_02_17INDEX PARTITION36,5122.88


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 INDEX27117.37
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_186_02 INDEX966.15
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_202_04 INDEX915.83
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_161_02 INDEX805.13
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_04 INDEX764.87


Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
YTEXPTS_IDX_T_EXP_W_215IDX1_EXP_HANDON_W_215PAR_2014_02_17INDEX PARTITION120.00
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_229_04 INDEX120.00
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_209 TABLE120.00
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_226 TABLE120.00
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_229 TABLE120.00


Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_215_02 INDEX2322.77
YTEXPTS_HANDON_02T_EXP_OP_RECORD_HANDON_161PAR_2014_02_17TABLE PARTITION1918.81
YTEXPTS_IDX_CONTAINERIDX1_EXP_CONTAINER_165PAR_2014_02_17INDEX PARTITION87.92
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_161_02 INDEX87.92
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_183_02 INDEX87.92


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_oids2449.840 012
dc_histogram_data14,9821.920 016,642
dc_histogram_defs43,0090.890 037,000
dc_object_grants303.330 07
dc_objects135,4220.070 56,578
dc_profiles2300.000 01
dc_rollback_segments4,7800.000 067
dc_segments77,9000.140 1,07732,891
dc_sequences60.000 69
dc_tablespaces126,6080.000 0344
dc_users161,8230.000 0259
global database name2,5730.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_STATUS2402.920 00
BODY1,1392.192,1221.2300
CLUSTER603.33623.2300
DBLINK1,8680.000 00
EDITION1710.003190.0000
INDEX446,4980.004,9857.103460
QUEUE690.009410.0000
SCHEMA1,9140.000 00
SQL AREA328,1850.132,150,1770.252,3623
SQL AREA BUILD2,75115.270 00
SQL AREA STATS2,44652.212,44652.2510
SUBSCRIPTION70.0070.0000
TABLE/PROCEDURE259,0110.04118,1251.035220
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,286.02 3.363.604444681681
Freeable294.060.000.690.847 424424
SQL13.160.750.020.01027651644
PL/SQL2.310.900.000.0200678678
EOther2,327.47 3.373.584444691691
Freeable316.310.000.700.9713 452452
SQL38.1425.410.060.902335662655
PL/SQL2.451.010.000.0200689689


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
sharedKGLH0981.81985.890.42
sharedKGLHD85.5084.17-1.56
sharedPRTMV95.4195.410.00
sharedSQLA2,277.752,273.55-0.18
shareddb_block_hash_buckets1,424.001,424.000.00
sharedfree memory442.08443.440.31
sharedobject queue441.48441.480.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.070.000.00
QMON Coordinator0203 15:50:080.070.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) 00  0.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.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 0000.000.000.00
NGMYSQLDB87_3872_IDBQUERY4(41)/SYS.ALERT_QUE 0000.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