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:298219-Feb-14 08:00:52829 2.6
End Snap:298319-Feb-14 09:00:54461 3.0
Elapsed:  60.03 (mins)  
DB Time:  25.19 (mins)  

Report Summary

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 0.4 0.0 0.00 0.00
DB CPU(s): 0.3 0.0 0.00 0.00
Redo size (bytes): 590,363.4 3,616.3  
Logical read (blocks): 6,949.9 42.6  
Block changes: 3,532.6 21.6  
Physical read (blocks): 25.9 0.2  
Physical write (blocks): 480.1 2.9  
Read IO requests: 25.3 0.2  
Write IO requests: 320.6 2.0  
Read IO (MB): 0.2 0.0  
Write IO (MB): 3.8 0.0  
User calls: 840.8 5.2  
Parses (SQL): 370.3 2.3  
Hard parses (SQL): 0.5 0.0  
SQL Work Area (MB): 0.2 0.0  
Logons: 0.5 0.0  
Executes (SQL): 378.2 2.3  
Rollbacks: 100.0 0.6  
Transactions: 163.3   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.93Redo NoWait %: 100.00
Buffer Hit %: 99.68In-memory Sort %: 100.00
Library Hit %: 99.79Soft Parse %: 99.88
Execute to Parse %: 2.08Latch Hit %: 99.97
Parse CPU to Parse Elapsd %: 40.46% Non-Parse CPU: 98.50

Top 10 Foreground Events by Total Wait Time

EventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Class
DB CPU 1080.6 71.5 
db file sequential read78,389173.4211.5User I/O
log file sync240,774150.6110.0Commit
SQL*Net break/reset to client506,060137.809.1Application
enq: TX - row lock contention2,705100.8376.7Application
read by other session8,59812.81.8User I/O
enq: TX - allocate ITL entry451247.3Configuration
SQL*Net message to client1,884,7023.90.3Network
control file sequential read12,8491.50.1System I/O
db file scattered read3621.44.1User I/O

Wait Classes by Total Wait Time

Wait ClassWaitsTotal Wait Time (sec)Avg Wait (ms)% DB timeAvg Active Sessions
DB CPU 1,081 71.50.3
Application508,765239015.80.1
System I/O2,723,238225014.90.1
User I/O93,768189212.50.1
Commit240,776151110.00.0
Configuration108548.30.0
Other14,98150.30.0
Network1,890,82540.30.0
Concurrency4,85641.20.0

Host CPU

CPUsCoresSocketsLoad Average BeginLoad Average End%User%System%WIO%Idle
80 40 4 1.47 1.25 0.4 0.2 0.1 99.4

Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
0.5 82.5 0.0

IO Profile

Read+Write Per SecondRead per SecondWrite Per Second
Total Requests: 472.7 32.4 440.2
Database Requests: 345.9 25.3 320.6
Optimized Requests: 0.0 0.0 0.0
Redo Requests: 118.0 0.7 117.3
Total (MB): 6.3 1.0 5.2
Database (MB): 4.0 0.2 3.8
Optimized Total (MB): 0.0 0.0 0.0
Redo (MB): 1.3 0.7 0.6
Database (blocks): 505.9 25.9 480.1
Via Buffer Cache (blocks): 501.6 22.3 479.2
Direct (blocks): 4.4 3.5 0.8

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,545.9 1,574.7
% Host Mem used for SGA+PGA: 53.26 53.01

Cache Sizes

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

Shared Pool Statistics

BeginEnd
Memory Usage %: 94.64 94.25
% SQL with executions>1: 99.07 99.02
% Memory for SQL w/exec>1: 98.24 98.90

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU1,080.6171.49
sql execute elapsed time826.1054.65
parse time elapsed60.123.98
hard parse elapsed time5.720.38
hard parse (sharing criteria) elapsed time5.080.34
hard parse (bind mismatch) elapsed time2.970.20
connection management call elapsed time1.830.12
PL/SQL execution elapsed time1.260.08
inbound PL/SQL rpc elapsed time1.160.08
repeated bind elapsed time0.030.00
RMAN cpu time (backup/restore)0.020.00
DB time1,511.52 
background elapsed time714.27 
background cpu time427.74 


Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME182,753 
IDLE_TIME28,578,298 
IOWAIT_TIME24,996 
NICE_TIME0 
SYS_TIME61,641 
USER_TIME115,421 
LOAD11
RSRC_MGR_CPU_WAIT_TIME0 
PHYSICAL_MEMORY_BYTES406,403,956,736 
NUM_CPUS80 
NUM_CPU_CORES40 
NUM_CPU_SOCKETS4 
GLOBAL_RECEIVE_SIZE_MAX2,107,649,024 
GLOBAL_SEND_SIZE_MAX1,048,576 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX4,194,304 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX4,194,304 
TCP_SEND_SIZE_MIN4,096 


Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
19-Feb 08:00:521.47     
19-Feb 09:00:541.250.640.400.2199.360.09


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,081 71.49
Application508,7650239015.78
User I/O89,3420188212.42
Commit240,774015119.96
Configuration305751710.34
Network1,887,3590400.26
System I/O12,9500200.10
Concurrency4,6510100.06
Other1762140.05


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 read78,389017320.1311.47
log file sync240,774015110.419.96
SQL*Net break/reset to client506,060013800.869.11
enq: TX - row lock contention2,7050101370.006.67
read by other session8,59801310.010.85
enq: TX - allocate ITL entry475512470.000.33
SQL*Net message to client1,884,7020403.210.26
control file sequential read12,8490100.020.10
db file scattered read3620140.000.09
recovery area: computing obsolete files1003190.000.02
cursor: pin S wait on X2800100.000.02
recovery area: computing backed up files1002770.000.02
buffer busy waits6430000.000.02
latch: cache buffers chains3,4750000.010.01
library cache lock150090.000.01
Disk file operations I/O1,9910000.000.01
undo segment extension1688050.000.00
recovery area: computing dropped files100720.000.00
library cache: mutex X1520000.000.00
log file switch (private strand flush incomplete)70090.000.00
control file single write670010.000.00
SQL*Net more data from client2,6450000.000.00
latch: In memory undo latch2720000.000.00
ADR block file read420000.000.00
enq: TX - index contention140010.000.00
latch: redo allocation420000.000.00
control file parallel write340000.000.00
db file parallel read20020.000.00
CSS initialization10040.000.00
latch: object queue header operation370000.000.00
latch free100000.000.00
latch: enqueue hash chains100000.000.00
latch: messages80000.000.00
CSS operation: action10020.000.00
enq: HW - contention30000.000.00
library cache load lock210000.000.00
SQL*Net message from client1,885,068010,780,07957193.21 
jobq slave wait7,6191003,8155010.01 
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,151,813016101.9622.49
log file parallel write393,19704800.676.74
log file sequential read1,2910970.001.33
os thread startup14103190.000.38
control file sequential read9,4990200.020.31
db file async I/O submit1,151,8130201.960.29
ASM file metadata operation1,9330210.000.26
reliable message8070110.000.16
LGWR wait for redo copy9,3430100.020.14
Data file init write3290120.000.10
control file parallel write2,6050000.000.06
db file sequential read5570010.000.06
latch free5340000.000.01
rdbms ipc reply110060.000.01
Disk file operations I/O3,5030000.010.01
kfk: async disk IO320010.000.00
latch: redo allocation650000.000.00
asynch descriptor resize1,824100000.000.00
db file single write110010.000.00
CSS initialization30050.000.00
Log archive I/O70020.000.00
enq: CF - contention30030.000.00
latch: call allocation740000.000.00
undo segment extension2100050.000.00
CSS operation: action40020.000.00
RMAN backup & recovery I/O20040.000.00
latch: redo writing760000.000.00
latch: messages590000.000.00
latch: object queue header operation780000.000.00
buffer busy waits360000.000.00
SQL*Net message to client3,4580000.010.00
log file single write140000.000.00
enq: CI - contention10030.000.00
CSS operation: query180000.000.00
ADR block file read160000.000.00
direct path write260000.000.00
latch: checkpoint queue latch100000.000.00
latch: cache buffers chains240000.000.00
rdbms ipc message422,900792,9652200.72 
Streams AQ: waiting for time management or cleanup tasks156738,22725484700.00 
Space Manager: slave idle wait13,2482836,04827210.02 
EMON slave idle wait3,60010018,00350010.01 
class slave wait1,13307,20263570.00 
DIAG idle wait7,1751007,18210010.01 
Streams AQ: qmn coordinator idle wait260503,612138930.00 
Streams AQ: qmn slave idle wait13003,612277860.00 
smon timer72703,61249680.00 
ASM background timer1,01003,60635700.00 
wait for unread message on broadcast channel3,5981003,60210010.01 
shared server idle wait1201003,601300120.00 
Streams AQ: emn coordinator idle wait3601003,601100030.00 
dispatcher timer601003,601600130.00 
pmon timer1,1991003,60030030.00 
SQL*Net message from client5,14101220.01 
KSV master wait4570120.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 read5898.3   1.7   
ADR block file write10100.0       
ADR file lock12100.0       
ARCH wait for archivelog lock7100.0       
ASM file metadata operation193294.02.3.9.5.61.1.7 
CSS initialization4  25.075.0    
CSS operation: action5 80.020.0     
CSS operation: query2495.84.2      
Data file init write32940.416.426.413.43.3   
Disk file operations I/O549499.8.1.1.0    
LGWR wait for redo copy933899.7.3.0     
Log archive I/O714.328.657.1     
RMAN backup & recovery I/O250.0  50.0    
SQL*Net break/reset to client506.3K97.42.0.4.2.0.0.0 
SQL*Net message to client1887.7K100.0.0      
SQL*Net more data from client2649100.0.0      
SQL*Net more data to client16100.0       
asynch descriptor resize1824100.0       
buffer busy waits67989.27.72.9.1    
buffer deadlock3100.0       
control file parallel write263999.7.2.0.1    
control file sequential read22.3K99.0.2.6.1.0.0.0 
control file single write6741.858.2      
cursor: mutex S2100.0       
cursor: mutex X10100.0       
cursor: pin S5100.0       
cursor: pin S wait on X28  17.9 75.07.1  
db file async I/O submit1151.8K100.0       
db file parallel read250.0  50.0    
db file parallel write1151.8K100.0.0.0.0.0.0.0 
db file scattered read36247.510.212.218.58.33.0.3 
db file sequential read78.9K59.216.16.415.61.9.6.1 
db file single write1172.7 9.118.2    
direct path write26100.0       
enq: CF - contention3  100.0     
enq: CI - contention1  100.0     
enq: FB - contention1100.0       
enq: HW - contention3100.0       
enq: TX - allocate ITL entry4      75.025.0
enq: TX - contention1100.0       
enq: TX - index contention1471.414.314.3     
enq: TX - row lock contention270533.752.56.62.31.61.02.1.3
kfk: async disk IO3290.63.13.13.1    
latch free54497.62.2 .2    
latch: In memory undo latch27498.21.8      
latch: cache buffers chains349999.8.2      
latch: cache buffers lru chain4100.0       
latch: call allocation7498.61.4      
latch: checkpoint queue latch10100.0       
latch: enqueue hash chains10100.0       
latch: messages67100.0       
latch: object queue header operation115100.0       
latch: redo allocation10797.22.8      
latch: redo writing76100.0       
latch: row cache objects5100.0       
latch: shared pool11100.0       
library cache load lock21100.0       
library cache lock1546.7 26.76.7 6.713.3 
library cache: mutex X15294.72.0.7 2.0.7  
log file parallel write393.2K99.8.1.0.0 .0.0 
log file sequential read129137.218.219.010.68.62.63.8 
log file single write14100.0       
log file switch (private strand flush incomplete)7   14.385.7   
log file sync240.7K96.03.5.4.1.0.0.0 
os thread startup141    13.586.5  
rdbms ipc reply11  54.527.318.2   
read by other session859870.719.12.86.3.8.2.0 
recovery area: computing backed up files1      100.0 
recovery area: computing dropped files1      100.0 
recovery area: computing obsolete files1      100.0 
reliable message80747.343.51.77.4    
undo segment extension1866.7   22.211.1  
ASM background timer100916.62.61.32.41.5.62.073.1
DIAG idle wait7176      100.0 
EMON slave idle wait3600       100.0
KSV master wait47987.96.91.9.41.0 1.9 
SQL*Net message from client1889.7K36.325.611.78.97.32.62.74.9
Space Manager: slave idle wait13.1K1.8.1.6.41.51.920.473.2
Streams AQ: emn coordinator idle wait361       100.0
Streams AQ: qmn coordinator idle wait25849.6  .4   50.0
Streams AQ: qmn slave idle wait129       100.0
Streams AQ: waiting for time management or cleanup tasks1533.3     33.333.3
class slave wait113334.33.315.13.55.18.51.428.8
dispatcher timer60       100.0
jobq slave wait7619.0.0.0   100.0 
pmon timer1199       100.0
rdbms ipc message422.9K16.19.929.820.511.53.33.85.1
shared server idle wait120       100.0
smon timer7273.0.11.01.02.83.622.466.2
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 operation1399.3.6.1.1    
SQL*Net break/reset to client5100.0.0 .0.0   
control file sequential read1100.0.0      
db file parallel write1100.0.0      
db file scattered read199.7 .3     
db file sequential read6299.9.1.0.0    
enq: TX - allocate ITL entry4     75.025.0 
enq: TX - row lock contention5697.71.2.5.1.2.1 .3
library cache lock286.713.3      
log file parallel write3100.0.0.0     
log file sequential read4996.21.9.8.9.3   
log file sync4100.0.0.0     
read by other session4100.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   


Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
enq: TX - row lock contention799.7.2.0   .0 


Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
dbquery1,4771,0577522,974
SYS$USERS352451,995
SYS$BACKGROUND001366
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 84892174464210018692974
SYS$USERS 4464137000181580
SYS$BACKGROUND 4412120430000


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
67.49451.504.460.070.02ccyu6t27pczpb JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_1...
30.43430.712.012.7598.12fpvzbqsarvfrn JDBC Thin Client select id, waybill_no, exp_typ...
23.38100,5940.001.5549.580.00fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
15.95230.691.063.3097.68dd092634txw4v JDBC Thin Client select id, waybill_no, exp_typ...
15.33157,3020.001.0168.650.002jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
15.20  1.0158.20 8wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
12.5536,5820.000.8346.771.09cj9mymcb3d5q0 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
11.7715,7000.000.7863.500.16gyx912cqtkd9s JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
9.71130.750.642.9098.05cs04nczkzvwf1 JDBC Thin Client select id, waybill_no, exp_typ...
8.5092,4980.000.5642.010.00c2gkrw5buc9wb JDBC Thin Client select sysdate from DUAL


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
11.59100,5940.001.0723.3849.580.00fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
10.52157,3020.000.9715.3368.650.002jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
8.85  0.8215.2058.20 8wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
7.4715,7000.000.6911.7763.500.16gyx912cqtkd9s JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
5.8736,5820.000.5412.5546.771.09cj9mymcb3d5q0 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
4.068,4910.000.386.4063.470.002x2jvh739zmhd JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
3.5792,4980.000.338.5042.010.00c2gkrw5buc9wb JDBC Thin Client select sysdate from DUAL
3.47  0.326.4753.63 d7khudn7c54n6   INSERT INTO T_EXP_DELIVERY_STA...
3.085,5650.000.294.7165.440.00d1tszpz8ga9a0 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
2.505,3070.000.233.9862.680.00azs01cjvz8smy JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...


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
29.86430.6915.8030.432.7598.12fpvzbqsarvfrn JDBC Thin Client select id, waybill_no, exp_typ...
15.58230.688.2415.953.3097.68dd092634txw4v JDBC Thin Client select id, waybill_no, exp_typ...
9.52130.735.049.712.9098.05cs04nczkzvwf1 JDBC Thin Client select id, waybill_no, exp_typ...
6.1690.683.266.303.3397.75cy9jtugs2s3ty JDBC Thin Client select id, waybill_no, exp_typ...
3.4650.691.833.543.3397.6798wth622mgm21 JDBC Thin Client select id, waybill_no, exp_typ...
2.8940.721.534.0930.0470.5404u93q64635mq JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
2.716300.001.443.9629.2568.570x4m5wqrrp7dj JDBC Thin Client select id, waybill_no, exp_typ...
2.5340.631.344.6846.3154.013ybrvrk9xs8g4 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
1.618580.000.853.5349.3745.7432wyc5f6nxbxf JDBC Thin Client select id, waybill_no, exp_typ...
0.645,7230.000.343.9352.7816.270v9u1u536y9b4 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...


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
1,258,408157,3028.005.0315.3368.602jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
826,51536,58222.593.3012.5546.81.1cj9mymcb3d5q0 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
752,4004188,100.003.014.6846.3543ybrvrk9xs8g4 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
519,75815,70033.112.0811.7763.5.2gyx912cqtkd9s JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
329,620482,405.001.324.093070.504u93q64635mq JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
300,6661,067281.791.202.2377.21284vuzu1ma5j4z JDBC Thin Client select id, waybill_no, exp_typ...
268,25512,03222.301.073.7145.4.75anas4sv977r6 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
250,9458,49129.551.006.4063.502x2jvh739zmhd JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
244,695858285.190.983.5349.445.732wyc5f6nxbxf JDBC Thin Client select id, waybill_no, exp_typ...
190,0825,56534.160.764.7165.40d1tszpz8ga9a0 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...


Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
4,70643109.445.0530.432.7598.12fpvzbqsarvfrn JDBC Thin Client select id, waybill_no, exp_typ...
2,90323126.223.1215.953.3097.68dd092634txw4v JDBC Thin Client select id, waybill_no, exp_typ...
1,58713122.081.709.712.9098.05cs04nczkzvwf1 JDBC Thin Client select id, waybill_no, exp_typ...
1,1699129.891.266.303.3397.75cy9jtugs2s3ty JDBC Thin Client select id, waybill_no, exp_typ...
6385127.600.683.543.3397.6798wth622mgm21 JDBC Thin Client select id, waybill_no, exp_typ...
6175,7230.110.663.9352.7816.270v9u1u536y9b4 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
5974149.250.644.0930.0470.5404u93q64635mq JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
4704117.500.504.6846.3154.013ybrvrk9xs8g4 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
4284,7550.090.462.9351.4716.439n71ddkf8r4bn JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
3264,5770.070.352.8353.4412.59f2xx7qvwxwjjh JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...


Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModuleSQL Text
2,9032,90323126.220.003.19dd092634txw4v JDBC Thin Client select id, waybill_no, exp_typ...
6386385127.600.000.7098wth622mgm21 JDBC Thin Client select id, waybill_no, exp_typ...
5975974149.250.000.6604u93q64635mq JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
4704704117.500.000.523ybrvrk9xs8g4 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
2192196300.350.000.240x4m5wqrrp7dj JDBC Thin Client select id, waybill_no, exp_typ...
1301308580.150.000.1432wyc5f6nxbxf JDBC Thin Client select id, waybill_no, exp_typ...
97974,5770.020.000.11f2xx7qvwxwjjh JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
83832,7930.030.000.09aby73nja82u62 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
26265,3060.000.000.035rpg6p8mn7hd5 JDBC Thin Client SELECT ID, DEST_OUT_SCAN_TIME,...
232312,0320.000.000.035anas4sv977r6 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,302157,2961.0015.3368.602jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
100,5943,3810.0323.3849.60fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
92,49892,4971.008.50420c2gkrw5buc9wb JDBC Thin Client select sysdate from DUAL
37,66335,3480.943.0135.4.31bqk0pmqg1vq6 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
36,58336,5701.004.1938.7acwagtju00dpq JDBC Thin Client SELECT ID, DEST_OUT_SCAN_TIME,...
36,58236,5821.0012.5546.81.1cj9mymcb3d5q0 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
15,70016,0781.0211.7763.5.2gyx912cqtkd9s JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
12,04812,0321.001.2740.11.1g4m3vzd4cp624 JDBC Thin Client SELECT ID, DEST_OUT_SCAN_TIME,...
12,03212,0311.003.7145.4.75anas4sv977r6 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
9,55934,3733.602.9962.73.31txs4c06ctb1d JDBC Thin Client UPDATE T_EXP_DELIVERY_STATUS_1...


Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
157,301157,30211.792jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
100,594100,5947.54fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
92,36292,4986.92c2gkrw5buc9wb JDBC Thin Client select sysdate from DUAL
37,64937,6632.821bqk0pmqg1vq6 JDBC Thin Client SELECT WAYBILL_NO FROM T_EXP_D...
36,58236,5822.74cj9mymcb3d5q0 JDBC Thin Client DELETE FROM T_EXP_DELIVERY_STA...
36,56536,5832.74acwagtju00dpq JDBC Thin Client SELECT ID, DEST_OUT_SCAN_TIME,...
19,303 1.458wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
15,70015,7001.18gyx912cqtkd9s JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
13,740 1.03d7khudn7c54n6   INSERT INTO T_EXP_DELIVERY_STA...
12,04612,0480.90g4m3vzd4cp624 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
22,166,312 0.27d7khudn7c54n6   INSERT INTO T_EXP_DELIVERY_STA...
20,435,632 0.25cak25du5pyzcp   INSERT INTO T_EXP_DELIVERY_STA...
17,007,560 0.21gf25wm6hncp21   INSERT INTO T_EXP_DELIVERY_STA...
16,854,352 0.218wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
16,792,856 0.21a6nwkg0nu1grj   INSERT INTO T_EXP_DELIVERY_STA...
15,804,032 0.201864ycgvgvyam   INSERT INTO T_EXP_DELIVERY_STA...
14,657,096 0.181crrgmqhtap69   INSERT INTO T_EXP_DELIVERY_STA...
14,636,888 0.182ayhh3ddjwg7y   INSERT INTO T_EXP_DELIVERY_STA...
14,616,680 0.1809qtbd90zbmkv   INSERT INTO T_EXP_DELIVERY_STA...
14,012,800 0.1796bau1p59dh0y   INSERT INTO T_EXP_DELIVERY_STA...
13,344,512 0.174sbkzmudwcd68   INSERT INTO T_EXP_DELIVERY_STA...
13,202,416 0.168p3fp2jguk11n   INSERT INTO T_EXP_DELIVERY_STA...
13,133,832 0.165dzr1p10ydh03   INSERT INTO T_EXP_DELIVERY_STA...
12,310,944 0.15aq1j9m909q63y   INSERT INTO T_EXP_DELIVERY_STA...
12,189,600 0.15733xjzj58vkx0   INSERT INTO T_EXP_DELIVERY_STA...
11,334,256 0.14d0k01scdqf6c1   INSERT INTO T_EXP_DELIVERY_STA...
11,322,320 0.1486n8k008j5fg5   INSERT INTO T_EXP_DELIVERY_STA...
11,290,3676590.14c2mffjag542y2 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
11,172,176 0.1433tf72t97ah8t   INSERT INTO T_EXP_DELIVERY_STA...
10,931,8571,4350.1485warqm7hf8f2 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
10,848,312 0.135ntqv80pf9q0n   INSERT INTO T_EXP_DELIVERY_STA...
10,823,816 0.137y9zax9taks2q   INSERT INTO T_EXP_DELIVERY_STA...
10,580,584 0.132c6mwvt053r3y   INSERT INTO T_EXP_DELIVERY_STA...
10,215,2971,5040.134hsvdcgu6k88f JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
10,200,3851,9440.135b0v0afu4udxj JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
10,153,3771,1000.1346fd6utb5tmd7 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
10,093,3439100.1309c07pa97cdkj JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
9,733,7133,0530.1291hmct9bqr6km JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
9,684,936 0.127ymaac33ytc92   INSERT INTO T_EXP_DELIVERY_STA...
9,207,5857830.119v3y0sxzr49t2 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
9,030,8491,2610.117matnus0q1hy5 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
7,630,456 0.097zdvpgv74gvqd   INSERT INTO T_EXP_DELIVERY_STA...
7,253,752 0.09c5zm115aa6kwx   INSERT INTO T_EXP_DELIVERY_STA...
6,025,760 0.074ahp03j8z3u1g   INSERT INTO T_EXP_DELIVERY_STA...
4,305,4653,3960.054n7dm1sc7su74 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
3,555,2254,7550.049n71ddkf8r4bn JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
3,421,4415,3070.04azs01cjvz8smy JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
3,137,2815,7230.040v9u1u536y9b4 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
2,914,4013,0560.04dwbnwwf6adc7t JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
2,413,6414,5770.03f2xx7qvwxwjjh JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
2,352,313100,5940.03fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
1,945,73715,7000.02gyx912cqtkd9s JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
1,801,5534,8250.02dthf3xswmawq9 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
1,556,9173,9540.02b8xmfh255xx8s JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_SI...
1,451,0015,5650.02d1tszpz8ga9a0 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
1,219,6912520.029pt0j66ysf7g6 JDBC Thin Client UPDATE T_EXP_TAKING_STATUS_187...
1,066,5533,1330.01gamxp0g1qtsq5 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...


Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
560659c2mffjag542y2 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
431 d7khudn7c54n6   INSERT INTO T_EXP_DELIVERY_STA...
395 cak25du5pyzcp   INSERT INTO T_EXP_DELIVERY_STA...
372 1864ycgvgvyam   INSERT INTO T_EXP_DELIVERY_STA...
361 2ayhh3ddjwg7y   INSERT INTO T_EXP_DELIVERY_STA...
3511,10046fd6utb5tmd7 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
3321,43585warqm7hf8f2 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
3301,2617matnus0q1hy5 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
329 a6nwkg0nu1grj   INSERT INTO T_EXP_DELIVERY_STA...
328 09qtbd90zbmkv   INSERT INTO T_EXP_DELIVERY_STA...
328 gf25wm6hncp21   INSERT INTO T_EXP_DELIVERY_STA...
3261,9445b0v0afu4udxj JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
303 96bau1p59dh0y   INSERT INTO T_EXP_DELIVERY_STA...
30091009c07pa97cdkj JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_CO...
293 7zdvpgv74gvqd   INSERT INTO T_EXP_DELIVERY_STA...
2861,5044hsvdcgu6k88f JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
284 1crrgmqhtap69   INSERT INTO T_EXP_DELIVERY_STA...
2827839v3y0sxzr49t2 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
277 86n8k008j5fg5   INSERT INTO T_EXP_DELIVERY_STA...
2733,05391hmct9bqr6km JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
2714,577f2xx7qvwxwjjh JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
261 8p3fp2jguk11n   INSERT INTO T_EXP_DELIVERY_STA...
256 4sbkzmudwcd68   INSERT INTO T_EXP_DELIVERY_STA...
254 c5zm115aa6kwx   INSERT INTO T_EXP_DELIVERY_STA...
252 5dzr1p10ydh03   INSERT INTO T_EXP_DELIVERY_STA...
249 4ahp03j8z3u1g   INSERT INTO T_EXP_DELIVERY_STA...
240 7ymaac33ytc92   INSERT INTO T_EXP_DELIVERY_STA...
237 aq1j9m909q63y   INSERT INTO T_EXP_DELIVERY_STA...
234 733xjzj58vkx0   INSERT INTO T_EXP_DELIVERY_STA...
231 8wbzcapy4x69v   INSERT INTO T_EXP_OP_RECORD_CO...
220 33tf72t97ah8t   INSERT INTO T_EXP_DELIVERY_STA...
217 d0k01scdqf6c1   INSERT INTO T_EXP_DELIVERY_STA...
213 7y9zax9taks2q   INSERT INTO T_EXP_DELIVERY_STA...
207 2c6mwvt053r3y   INSERT INTO T_EXP_DELIVERY_STA...
207 5ntqv80pf9q0n   INSERT INTO T_EXP_DELIVERY_STA...
1053,3964n7dm1sc7su74 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
915,307azs01cjvz8smy JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
664,7559n71ddkf8r4bn JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
633,954b8xmfh255xx8s JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_SI...
625,565d1tszpz8ga9a0 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
603,056dwbnwwf6adc7t JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
585,7230v9u1u536y9b4 JDBC Thin Client INSERT INTO T_EXP_DELIVERY_STA...
5715,700gyx912cqtkd9s JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
554,825dthf3xswmawq9 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
55100,594fk97qz5tcpuxa JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
474,809bbfrz8d24p7qc JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
468,4912x2jvh739zmhd JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
403,133gamxp0g1qtsq5 JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
323,2612kw8hmru9qxxf JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...
323,946dmzw9wmmb5c5q JDBC Thin Client INSERT INTO T_EXP_OP_RECORD_HA...


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 )
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 )
0x4m5wqrrp7dj select id, waybill_no, exp_type, pkg_qty, emp_code, emp_name, fee_flag, fee_amt, org_code, frequency_no, signoff_type_code, reciever_signoff, amount_collected, amount_agency, delivery_fail_reason_code, delivery_fail_reason, contact, to_char(contact_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as contact_time, contact_result, to_char(upload_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as upload_time , op_code, aux_op_code, route_code, aux_route_code, status, transfer_status, to_char(create_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as create_time, create_user_code, create_user_name, create_org_code, create_terminal, device_type, remark, ref_id, to_char(modify_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as modify_time, modify_user_code, modify_user_name , modify_org_code, modify_terminal, trace_status, fst_success_siginoff, to_char(delivery_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as delivery_time, delivery_id, has_sign_name, has_sign_pic, org_type, query_flag from T_EXP_OP_RECORD_SIGNATURE_164 where waybill_No = :1 an d org_Code = :2 and status <> 0 and op_code = :3 and rownum < 2
1864ycgvgvyamINSERT INTO T_EXP_DELIVERY_STATUS_208 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
1bqk0pmqg1vq6SELECT WAYBILL_NO FROM T_EXP_DELIVERY_STATUS_165 WHERE WAYBILL_NO = :1
1crrgmqhtap69INSERT INTO T_EXP_DELIVERY_STATUS_172 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
1txs4c06ctb1dUPDATE T_EXP_DELIVERY_STATUS_165 SET STATUS = CASE WHEN STATUS > :1 THEN STATUS ELSE :2 END , DEST_OUT_SCAN_TIME = :3 , DEST_CENTER_ORG_CODE = :4 WHERE WAYBILL_NO = :5
2ayhh3ddjwg7yINSERT INTO T_EXP_DELIVERY_STATUS_202 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
2c6mwvt053r3yINSERT INTO T_EXP_DELIVERY_STATUS_189 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
2jfqzrxhrm93bselect /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
2kw8hmru9qxxfINSERT INTO T_EXP_OP_RECORD_HANDON_213 (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 )
2x2jvh739zmhdINSERT INTO T_EXP_OP_RECORD_HANDON_177 (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 )
32wyc5f6nxbxf select id, waybill_no, exp_type, pkg_qty, emp_code, emp_name, fee_flag, fee_amt, org_code, frequency_no, signoff_type_code, reciever_signoff, amount_collected, amount_agency, delivery_fail_reason_code, delivery_fail_reason, contact, to_char(contact_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as contact_time, contact_result, to_char(upload_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as upload_time , op_code, aux_op_code, route_code, aux_route_code, status, transfer_status, to_char(create_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as create_time, create_user_code, create_user_name, create_org_code, create_terminal, device_type, remark, ref_id, to_char(modify_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as modify_time, modify_user_code, modify_user_name , modify_org_code, modify_terminal, trace_status, fst_success_siginoff, to_char(delivery_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as delivery_time, delivery_id, has_sign_name, has_sign_pic, org_type, query_flag from T_EXP_OP_RECORD_SIGNATURE_167 where waybill_No = :1 an d org_Code = :2 and status <> 0 and op_code = :3 and rownum < 2
33tf72t97ah8tINSERT INTO T_EXP_DELIVERY_STATUS_203 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
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 )
46fd6utb5tmd7INSERT INTO T_EXP_DELIVERY_STATUS_217 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
4ahp03j8z3u1gINSERT INTO T_EXP_DELIVERY_STATUS_209 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
4hsvdcgu6k88fINSERT INTO T_EXP_DELIVERY_STATUS_170 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
4n7dm1sc7su74INSERT INTO T_EXP_OP_RECORD_HANDON_170 (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 )
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 )
5anas4sv977r6DELETE FROM T_EXP_DELIVERY_STATUS_206 WHERE WAYBILL_NO = :1
5b0v0afu4udxjINSERT INTO T_EXP_DELIVERY_STATUS_190 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
5dzr1p10ydh03INSERT INTO T_EXP_DELIVERY_STATUS_194 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
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 )
5rpg6p8mn7hd5SELECT 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_161 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 )
7matnus0q1hy5INSERT INTO T_EXP_DELIVERY_STATUS_176 (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 )
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 )
84vuzu1ma5j4z select id, waybill_no, exp_type, pkg_qty, emp_code, emp_name, fee_flag, fee_amt, org_code, frequency_no, signoff_type_code, reciever_signoff, amount_collected, amount_agency, delivery_fail_reason_code, delivery_fail_reason, contact, to_char(contact_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as contact_time, contact_result, to_char(upload_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as upload_time , op_code, aux_op_code, route_code, aux_route_code, status, transfer_status, to_char(create_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as create_time, create_user_code, create_user_name, create_org_code, create_terminal, device_type, remark, ref_id, to_char(modify_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as modify_time, modify_user_code, modify_user_name , modify_org_code, modify_terminal, trace_status, fst_success_siginoff, to_char(delivery_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as delivery_time, delivery_id, has_sign_name, has_sign_pic, org_type, query_flag from T_EXP_OP_RECORD_SIGNATURE_170 where waybill_No = :1 an d org_Code = :2 and status <> 0 and op_code = :3 and rownum < 2
85warqm7hf8f2INSERT INTO T_EXP_DELIVERY_STATUS_166 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
86n8k008j5fg5INSERT INTO T_EXP_DELIVERY_STATUS_195 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
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 )
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 )
91hmct9bqr6kmINSERT INTO T_EXP_DELIVERY_STATUS_162 (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 )
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 )
98wth622mgm21 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_212 where status <> 0 and ID=:1
9n71ddkf8r4bnINSERT INTO T_EXP_DELIVERY_STATUS_169 (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 )
9pt0j66ysf7g6UPDATE T_EXP_TAKING_STATUS_187 SET STATUS =CASE WHEN STATUS > :1 THEN STATUS ELSE :2 END, SIGIN_USER =:3 , SIGIN_TIME =:4 , DELIVERY_FAIL_REASON =:5 , DELIVERY_FAIL_REASON_CODE=:6 , DEST_ORG_CODE =:7 WHERE WAYBILL_NO = :8
9v3y0sxzr49t2INSERT INTO T_EXP_DELIVERY_STATUS_232 (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 )
a6nwkg0nu1grjINSERT INTO T_EXP_DELIVERY_STATUS_206 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
aby73nja82u62INSERT INTO T_EXP_DELIVERY_STATUS_165 (ID , WAYBILL_NO , DES_ORG_SCAN_TIME , EXP_TYPE , STATUS , DES_ORG_CODE , DEST_ORG_CODE) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 )
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 )
azs01cjvz8smyINSERT INTO T_EXP_OP_RECORD_HANDON_196 (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 )
b8xmfh255xx8s INSERT INTO T_EXP_OP_RECORD_SIGNATURE_240 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EMP_CODE, EMP_NAME, FEE_FLAG, FEE_AMT, ORG_CODE, FREQUENCY_NO, SIGNOFF_TYPE_CODE, RECIEVER_SIGNOFF, AMOUNT_COLLECTED, AMOUNT_AGENCY, DELIVERY_FAIL_REASON_CODE, DELIVERY_FAIL_REASON, CONTACT, CONTACT_TIME, CONTACT_RESULT, 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, FST_SUCCESS_SIGINOFF, DELIVERY_TIME, DELIVERY_ID, HAS_SIGN_NAME, HAS_SIGN_PIC, 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 , :45 , :46 , :47 )
bbfrz8d24p7qcINSERT INTO T_EXP_OP_RECORD_HANDON_212 (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 )
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 )
ccyu6t27pczpbUPDATE T_EXP_DELIVERY_STATUS_179 SET DS_AMT = :1 , ORIGIN_DS_AMT = :2 , DF_FEE = :3 , ORIGIN_DF_FEE = :4 , EFFECTIVE_TYPE_CODE = :5 , ASSURANCE_AMT = :6 , TAKING_TIME = :7 , BUSINESS_TYPE_CODE = :8 , TAKING_WEIGHT = :9 , EXPRESS_CONTENT_CODE = :10 , SRC_ORG_CODE = :11 WHERE WAYBILL_NO = :12
cj9mymcb3d5q0DELETE FROM T_EXP_DELIVERY_STATUS_165 WHERE WAYBILL_NO = :1
cs04nczkzvwf1 select id, waybill_no, exp_type, pkg_qty, express_content_code, effective_type_code, transport_type_code, weigh_weight , input_weight, pkg_length, pkg_width, pkg_height , volume_weight, fee_flag, fee_amt, source_org_code, des_org_code, org_code, container_no, line_no, frequency_no, previous_org_code, next_org_code, vehicle_plate_no, to_char(upload_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as upload_time , op_code, aux_op_code, route_code, aux_route_code, status, transfer_status, to_char(create_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as create_time, create_user_code, create_user_name, create_org_code, create_terminal, device_type, remark, ref_id, to_char(modify_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as modify_time, modify_user_code, modify_user_name , modify_org_code, modify_terminal, trace_status, io_type, cmp_flag, line_frequency_no, bill_source_org_code, in_out_flag, to_char(out_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as out_time, fee_weight, pkg_pcs, org_type, query_flag from T_EXP_OP_RECORD_ CONTAINER_208 where status <> 0 and ID=:1
cy9jtugs2s3ty 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_173 where status <> 0 and ID=:1
d0k01scdqf6c1INSERT INTO T_EXP_DELIVERY_STATUS_223 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
d1tszpz8ga9a0INSERT INTO T_EXP_OP_RECORD_HANDON_175 (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 )
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 )
dd092634txw4v 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_179 where status <> 0 and ID=:1
dmzw9wmmb5c5qINSERT INTO T_EXP_OP_RECORD_HANDON_231 (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 )
dthf3xswmawq9INSERT INTO T_EXP_OP_RECORD_HANDON_209 (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 )
dwbnwwf6adc7tINSERT INTO T_EXP_OP_RECORD_HANDON_224 (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 )
f2xx7qvwxwjjhINSERT INTO T_EXP_DELIVERY_STATUS_185 (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 )
fk97qz5tcpuxaINSERT INTO T_EXP_OP_RECORD_HANDON_208 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EMP_CODE, EMP_NAME, HANDON_TYPE, WEIGH_WEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, ORG_CODE, FREQUENCY_NO, HANDON_ID, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, CONTAINER_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, SIGINOFF_OP_CODE, SIGINOFF_ID, FST_SUCCESS_SIGINOFF, DELIVERY_SEQ, ORG_TYPE, QUERY_FLAG) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 )
fpvzbqsarvfrn select id, waybill_no, exp_type, pkg_qty, express_content_code, effective_type_code, transport_type_code, weigh_weight , input_weight, pkg_length, pkg_width, pkg_height , volume_weight, fee_flag, fee_amt, source_org_code, des_org_code, org_code, container_no, line_no, frequency_no, previous_org_code, next_org_code, vehicle_plate_no, to_char(upload_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as upload_time , op_code, aux_op_code, route_code, aux_route_code, status, transfer_status, to_char(create_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as create_time, create_user_code, create_user_name, create_org_code, create_terminal, device_type, remark, ref_id, to_char(modify_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as modify_time, modify_user_code, modify_user_name , modify_org_code, modify_terminal, trace_status, io_type, cmp_flag, line_frequency_no, bill_source_org_code, in_out_flag, to_char(out_time, 'YYYY-MM-DD HH24:MI:SS.FF3') as out_time, fee_weight, pkg_pcs, org_type, query_flag from T_EXP_OP_RECORD_ CONTAINER_165 where status <> 0 and ID=:1
g4m3vzd4cp624SELECT 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_206 WHERE WAYBILL_NO = :1
gamxp0g1qtsq5INSERT INTO T_EXP_OP_RECORD_HANDON_203 (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 )
gf25wm6hncp21INSERT INTO T_EXP_DELIVERY_STATUS_186 (ID, DEST_OUT_SCAN_TIME, DEST_CENTER_ORG_CODE, DES_ORG_SCAN_TIME, EXP_TYPE, WAYBILL_NO, STATUS, SRC_ORG_CODE, SRC_PARENT_ID, DES_PARENT_ID, DES_ORG_CODE, TAKING_TIME, DS_AMT, ORIGIN_DS_AMT, DF_FEE, ORIGIN_DF_FEE, BUSINESS_TYPE_CODE, EXPRESS_CONTENT_CODE, EFFECTIVE_TYPE_CODE, ASSURANCE_AMT, TAKING_WEIGHT, SIGIN_TYPE, SIGIN_USER, DELIVERY_EMP_CODE, DELIVERY_TIME, SIGIN_TIME, DELIVERY_FAIL_REASON, DELIVERY_FAIL_REASON_CODE, LAST_ISSUE_TIME, LAST_ISSUE_DES) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 )
gyx912cqtkd9sINSERT INTO T_EXP_OP_RECORD_HANDON_215 (ID, WAYBILL_NO, EXP_TYPE, PKG_QTY, EMP_CODE, EMP_NAME, HANDON_TYPE, WEIGH_WEIGHT, VOLUME_WEIGHT, FEE_FLAG, FEE_AMT, ORG_CODE, FREQUENCY_NO, HANDON_ID, UPLOAD_TIME, OP_CODE, AUX_OP_CODE, ROUTE_CODE, AUX_ROUTE_CODE, STATUS, TRANSFER_STATUS, CREATE_TIME, CREATE_USER_CODE, CREATE_USER_NAME, CREATE_ORG_CODE, CREATE_TERMINAL, DEVICE_TYPE, REMARK, REF_ID, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, MODIFY_ORG_CODE, MODIFY_TERMINAL, TRACE_STATUS, CONTAINER_NO, PREVIOUS_ORG_CODE, NEXT_ORG_CODE, SIGINOFF_OP_CODE, SIGINOFF_ID, FST_SUCCESS_SIGINOFF, DELIVERY_SEQ, ORG_TYPE, QUERY_FLAG) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

StatisticTotalper Secondper Trans
db block changes12,723,3513,532.6021.64
execute count1,362,164378.202.32
logons cumulative1,8920.530.00
opened cursors cumulative1,340,120372.082.28
parse count (total)1,333,834370.342.27
parse time elapsed4,0161.120.01
physical reads93,14525.860.16
physical writes1,728,985480.052.94
redo size2,126,306,652590,363.433,616.33
session cursor cache hits689,853191.541.17
session logical reads25,031,3736,949.8942.57
user calls3,028,355840.815.15
user commits227,66963.210.39
user rollbacks360,304100.040.61
workarea executions - onepass00.000.00
workarea executions - optimal6,5101.810.01


Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (space) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced9,5952.660.02
CCursor + sql area evicted50.000.00
CPU used by this session53,37614.820.09
CPU used when call started51,48514.290.09
CR blocks created1,2030.330.00
Cached Commit SCN referenced00.000.00
Commit SCN cached24,7696.880.04
DBWR checkpoint buffers written1,726,001479.222.94
DBWR checkpoints70.000.00
DBWR object drop buffers written00.000.00
DBWR revisited being-written buffer00.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes5720.160.00
DBWR undo block writes248,07168.880.42
Effective IO time00.000.00
HSC Heap Segment Block Changes1,023,921284.291.74
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts69,20419.210.12
Heap Segment Array Updates1,4660.410.00
IMU CR rollbacks3640.100.00
IMU Flushes300,32883.390.51
IMU Redo allocation size570,215,224158,318.75969.80
IMU commits191,44853.160.33
IMU contention3,0450.850.01
IMU ktichg flush00.000.00
IMU pool not allocated3,0740.850.01
IMU recursive-transaction flush2030.060.00
IMU undo allocation size1,465,464,736406,882.422,492.40
IMU- failed to get a private strand3,0740.850.01
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued00.000.00
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Requests to/from client1,882,722522.733.20
RowCR - row contention170.000.00
RowCR attempts9,0422.510.02
RowCR hits9,7232.700.02
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink1510.040.00
SQL*Net roundtrips to/from client1,884,409523.203.20
TBS Extension: bytes extended576,716,800160,123.90980.86
TBS Extension: files extended110.000.00
TBS Extension: tasks created360.010.00
TBS Extension: tasks executed360.010.00
active txn count during cleanout97,69527.120.17
background checkpoints completed60.000.00
background checkpoints started70.000.00
background timeouts29,6458.230.05
branch node splits250.010.00
buffer is not pinned count5,253,0701,458.508.93
buffer is pinned count2,242,682622.673.81
bytes received via SQL*Net from client1,155,306,351320,767.761,964.90
bytes sent via SQL*Net to client315,023,83387,465.54535.78
calls to get snapshot scn: kcmgss1,696,541471.042.89
calls to kcmgas538,453149.500.92
calls to kcmgcs544,779151.260.93
cell physical IO interconnect bytes23,592,615,9366,550,427.5540,125.34
change write time9,6262.670.02
cleanout - number of ktugct calls79,54122.080.14
cleanouts and rollbacks - consistent read gets4070.110.00
cleanouts only - consistent read gets4910.140.00
cluster key scan block gets178,60649.590.30
cluster key scans177,83149.370.30
commit batch performed7650.210.00
commit batch requested7650.210.00
commit batch/immediate performed170,86847.440.29
commit batch/immediate requested170,86847.440.29
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written10.000.00
commit cleanout failures: callback failure3,7401.040.01
commit cleanout failures: cannot pin4,7591.320.01
commit cleanouts3,576,371992.976.08
commit cleanouts successfully completed3,567,871990.616.07
commit immediate performed170,10347.230.29
commit immediate requested170,10347.230.29
commit txn count during cleanout94,20126.150.16
consistent changes35,6729.900.06
consistent gets9,068,8832,517.9515.42
consistent gets - examination3,473,128964.305.91
consistent gets direct00.000.00
consistent gets from cache9,068,8832,517.9515.42
consistent gets from cache (fastpath)5,514,5861,531.119.38
cursor authentications1,5700.440.00
data blocks consistent reads - undo records applied1,2340.340.00
db block gets15,962,5214,431.9527.15
db block gets direct70.000.00
db block gets from cache15,962,5144,431.9527.15
db block gets from cache (fastpath)5,575,9661,548.159.48
deferred (CURRENT) block cleanout applications689,898191.551.17
dirty buffers inspected00.000.00
doubling up with imu segment00.000.00
enqueue conversions4,1461.150.01
enqueue deadlocks00.000.00
enqueue releases1,684,239467.622.86
enqueue requests1,683,819467.512.86
enqueue timeouts30.000.00
enqueue waits2,7320.760.00
exchange deadlocks30.000.00
failed probes on index block reclamation00.000.00
file io service time00.000.00
frame signature mismatch00.000.00
free buffer inspected183,46650.940.31
free buffer requested303,14884.170.52
heap block compress150,90741.900.26
hot buffers moved to head of LRU2,6360.730.00
immediate (CR) block cleanout applications8980.250.00
immediate (CURRENT) block cleanout applications639,597177.581.09
index crx upgrade (positioned)150.000.00
index crx upgrade (prefetch)10.000.00
index fast full scans (full)10.000.00
index fetch by key1,152,842320.081.96
index scans kdiixs11,408,997391.202.40
leaf node 90-10 splits1630.050.00
leaf node splits14,1423.930.02
lob reads8,5312.370.01
lob writes8,5592.380.01
lob writes unaligned8,5592.380.01
logical read bytes from cache205,057,179,64856,933,584.71348,752.71
max cf enq hold time900.020.00
messages received1,546,839429.482.63
messages sent1,546,839429.482.63
min active SCN optimization applied on CR62,96617.480.11
no buffer to keep pinned count00.000.00
no work - consistent read gets5,066,2711,406.648.62
non-idle wait count5,513,0821,530.699.38
parse count (describe)00.000.00
parse count (failures)00.000.00
parse count (hard)1,6030.450.00
parse time cpu1,6250.450.00
physical read IO requests91,06625.280.15
physical read bytes763,043,840211,857.111,297.75
physical read total IO requests116,82632.440.20
physical read total bytes3,920,005,6321,088,379.226,666.98
physical read total multi block requests2,7370.760.00
physical reads cache80,42222.330.14
physical reads cache prefetch2,0910.580.00
physical reads direct12,7233.530.02
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests1,154,766320.621.96
physical write bytes14,163,845,1203,932,554.2124,089.28
physical write total IO requests1,585,574440.232.70
physical write total bytes19,672,610,3045,462,048.3333,458.36
physical write total multi block requests20,9545.820.04
physical writes direct2,9840.830.01
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache1,726,001479.222.94
physical writes non checkpoint237,33665.900.40
pinned buffers inspected00.000.00
prefetch clients - default70.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 time3,3510.930.01
recovery blocks read00.000.00
recursive aborts on index block reclamation00.000.00
recursive calls2,111,081586.143.59
recursive cpu usage5,6121.560.01
redo KB read2,446,806679.354.16
redo blocks checksummed by FG (exclusive)1,629,653452.472.77
redo blocks read for recovery00.000.00
redo blocks written4,488,5091,246.227.63
redo buffer allocation retries320.010.00
redo entries5,783,2841,605.719.84
redo k-bytes read for recovery00.000.00
redo log space requests320.010.00
redo ordering marks118,01332.770.20
redo size for direct writes57,64016.000.10
redo subscn max counts344,60995.680.59
redo synch long waits00.000.00
redo synch poll writes397,936110.490.68
redo synch polls295,38482.010.50
redo synch time15,1654.210.03
redo synch time (usec)151,861,63642,163.98258.28
redo synch time overhead (usec)254,475,16470,654.36432.80
redo synch time overhead count (<128 msec)100.000.00
redo synch time overhead count (<2 msec)384,266106.690.65
redo synch time overhead count (<32 msec)1,5510.430.00
redo synch time overhead count (<8 msec)10,1032.810.02
redo synch time overhead count (>=128 msec)80.000.00
redo synch writes397,936110.490.68
redo wastage97,578,04827,092.29165.96
redo write info find395,938109.930.67
redo write info find fail00.000.00
redo write time12,9223.590.02
redo writes393,145109.160.67
rollback changes - undo records applied511,374141.980.87
rollbacks only - consistent read gets7500.210.00
root node splits00.000.00
rows fetched via callback270,76375.180.46
session connect time00.000.00
shared hash latch upgrades - no wait14,9214.140.03
shared hash latch upgrades - wait00.000.00
sorts (disk)00.000.00
sorts (memory)12,0713.350.02
sorts (rows)65,27618.120.11
sql area evicted7020.190.00
sql area purged00.000.00
summed dirty queue length00.000.00
switch current to new buffer1,5950.440.00
table fetch by rowid2,179,241605.063.71
table fetch continued row1,4330.400.00
table scan blocks gotten221,25161.430.38
table scan rows gotten5,672,9141,575.079.65
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (short tables)5,7981.610.01
total cf enq hold time3,1400.870.01
total number of cf enq holders3940.110.00
total number of times SMON posted7270.200.00
transaction rollbacks170,86747.440.29
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size693,749,840192,617.811,179.90
user logons cumulative1,6830.470.00
user logouts cumulative2,0510.570.00
write clones created in background00.000.00
write clones created in foreground70.000.00


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current829461
opened cursors current2,1401,392
session cursor cache count3,468,4993,475,086
session pga memory78,528,549,37677,928,152,192
session pga memory max97,301,794,40096,590,759,008
session uga memory76,043,108,39276,072,245,080
session uga memory max511,433,221,352512,015,845,848


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)77.00


Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
DBWR1M0.020M13.2G319.783.744M750.13
Others2.9G7.06.834M3G2.26.85M25.7K0.03
LGWR3M0.05.001M2.1G117.36.609M393.5K0.01
Buffer Cache Reads627M21.75.174M0M0.000M78.3K1.63
Direct Reads99M3.53.027M16M0.55.004M0 
Direct Writes0M0.000M7M0.27.002M0 
RMAN2M0.02.001M1M0.010M820.13
Streams AQ0M0.000M0M0.000M28.00
TOTAL:3.6G32.431.038M18.3G440.245.209M497.6K0.26


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 File732M25.55.203M13.2G320.563.75M1.889.08
Log File2.3G0.68.663M2.1G117.34.609M1.0710.15
Archive Log0M0.000M2.3G0.66.663M3.50 
Control File615M6.21.171M123M1.48.034M0.011.79
TOTAL:3.6G32.431.037M17.8G440.055.057M1.529.20


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.020M13.2G319.723.743M750.13
DBWR (Data File) 0M0.000M13.2G319.723.743M0 
DBWR (Control File) 1M0.020M0M0.000M750.13
Others 2.9G7.06.834M3G2.26.85M23.1K0.03
Others (Archive Log) 0M0.000M2.3G0.66.663M0 
Others (Log File) 2.3G0.67.663M0M0.000M281.64
Others (Control File) 609M6.12.169M121M1.44.034M22.1K0.03
Others (Data File) 7M0.27.002M550M0.16.153M9870.01
LGWR 3M0.05.001M2.1G117.38.609M1960.00
LGWR (Log File) 0M0.000M2.1G117.34.609M280.00
LGWR (Control File) 3M0.05.001M3M0.04.001M1680.00
Buffer Cache Reads 627M21.75.174M0M0.000M78.3K1.63
Buffer Cache Reads (Data File) 627M21.75.174M0M0.000M78.3K1.63
Direct Reads 99M3.53.027M16M0.55.004M0 
Direct Reads (Data File) 99M3.53.027M16M0.55.004M0 
Direct Writes 0M0.000M7M0.27.002M0 
Direct Writes (Data File) 0M0.000M7M0.27.002M0 
RMAN 2M0.02.001M1M0.010M710.15
RMAN (Control File) 2M0.02.001M1M0.010M690.06
RMAN (Archive Log) 0M0.000M0M0.000M23.50
Streams AQ 0M0.000M0M0.000M28.00
Streams AQ (Data File) 0M0.000M0M0.000M28.00
TOTAL: 3.6G32.431.038M18.3G440.195.209M101.8K1.27


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 18,70951.081.00851,7615.191236380.00
TS_YTEXP 1,43605.421.00218,5120.4056120.00
TS_IDX_CONTAINER 15,01845.671.0025,7674.176740.00
TS_IDX_HANDON 36,985100.921.003,10810.271114,3490.54
UNDOTBS1 600.001.0017,7530.00051830.11
TS_HANDON_02 16001.881.009,1020.0423370.00
TS_CONTAINER_02 3,23013.651.425,5970.834260.00
TS_IDX_SIGNATURE 1,81010.851.002,3430.50114320.53
TS_IDX_T_EXP_CONTAINER_165 9702.061.003,8360.032100.00
TS_SIGNATURE_02 53704.022.331,9980.1141840.24
SYSAUX 6204.841.009130.025000.00
TS_IDX_T_EXP_CONTAINER_206 4301.401.006640.011000.00
SYSTEM 8704.371.005800.02402521.15
TS_CONTAINER_01 44501.211.00700.121000.00
TS_HANDON_01 39800.031.001030.110000.00
TS_TAKE_01 40300.001.00700.110000.00
TS_IDX_T_EXP_W_164 25105.821.002030.07603583.41
TS_SIGNATURE_01 34400.091.00700.100000.00
TS_IDX_T_EXP_W_229 14306.361.002350.04601293.80
TS_IDX_T_EXP_W_174 3800.261.002640.010070.00
TS_IDX_T_EXP_W_215 3800.001.002560.010010.00
TS_IDX_T_EXP_W_224 13504.441.001500.04501994.02
TS_IDX_T_EXP_W_167 15905.911.001220.04601364.93
TS_IDX_T_EXP_W_197 12604.441.001410.03501473.67
TS_IDX_T_EXP_W_185 6603.331.002000.023050.00
TS_IDX_T_EXP_W_236 17204.591.00860.055000.00
TS_IDX_T_EXP_W_217 12704.091.001170.04401853.03
TS_IDX_T_EXP_W_170 5702.631.001840.0230343.24
TS_IDX_TAKE 18000.001.00600.050000.00
TS_IDX_T_EXP_W_183 3400.591.002020.011020.00
TS_IDX_T_EXP_W_177 12104.211.001120.034010.00
TS_IDX_T_EXP_W_193 10103.371.001310.033000.00
TS_IDX_T_EXP_W_162 3600.831.001950.011060.00
TBS_OTH_SPLEX 19500.001.00350.050000.00
TS_IDX_T_EXP_W_175 3600.001.001870.010060.00
TS_IDX_T_EXP_W_169 4401.141.001770.011020.00
TS_IDX_T_EXP_W_202 4301.161.001720.011010.00
TS_IDX_T_EXP_W_198 7204.581.001310.025000.00
TS_IDX_T_EXP_W_237 4702.341.001550.012000.00
TS_IDX_T_EXP_W_173 14605.341.00490.045000.00
TS_IDX_T_EXP_W_206 3701.081.001440.011065.00
TS_IDX_T_EXP_W_180 5802.761.001130.0230393.85
TS_IDX_T_EXP_W_216 4301.161.001260.011020.00
TS_IDX_T_EXP_W_219 4000.251.001270.010000.00
TS_IDX_T_EXP_W_240 6402.191.001020.0220150.67
TS_IDX_T_EXP_W_166 3000.001.001340.010000.00
TS_IDX_T_EXP_W_238 7403.241.00900.0230823.54
TS_IDX_T_EXP_W_201 4903.271.001130.013000.00
TS_IDX_T_EXP_W_161 3000.001.001300.010000.00
TS_IDX_T_EXP_CONTAINER_163 2500.401.001310.010000.00
TS_TAKE_02 9600.001.00600.030000.00
TS_IDX_T_EXP_W_223 3900.001.001150.010010.00
TS_IDX_T_EXP_W_231 3200.001.001200.010030.00
TS_IDX_T_EXP_W_196 3700.001.001140.010050.00
TS_IDX_T_EXP_W_218 4702.131.001000.012020.00
TS_IDX_T_EXP_W_203 3100.001.001150.010030.00
TS_IDX_T_EXP_W_178 3600.001.001080.010000.00
TS_IDX_T_EXP_W_195 6202.741.00820.0230753.33
TS_IDX_T_EXP_W_186 9404.471.00490.035000.00
TS_IDX_T_EXP_W_191 3000.001.001130.010020.00
TS_IDX_T_EXP_CONTAINER_197 4100.241.001010.010000.00
TS_IDX_T_EXP_W_205 3100.001.001080.010000.00
TS_IDX_T_EXP_W_220 3800.001.001010.0100130.00
TS_IDX_T_EXP_CONTAINER_229 3100.001.001040.010000.00
TS_IDX_T_EXP_W_209 3100.001.001040.010000.00
TS_IDX_T_EXP_W_210 3400.291.001010.010010.00
TS_IDX_T_EXP_W_165 3000.001.001040.0100160.00
TS_IDX_T_EXP_W_189 3000.001.001040.010000.00
TS_IDX_T_EXP_W_188 3000.001.001030.010000.00
TS_IDX_T_EXP_W_233 3701.351.00960.011000.00
TS_IDX_T_EXP_W_213 3100.001.001000.0100110.00
TS_IDX_T_EXP_W_207 3100.001.00990.010030.00
TS_IDX_T_EXP_W_226 3200.001.00970.010020.00
TS_IDX_T_EXP_W_214 3100.001.00940.010010.00
TS_IDX_T_EXP_W_212 3100.001.00930.010000.00
TS_IDX_T_EXP_CONTAINER_228 3200.311.00870.010000.00
TS_IDX_T_EXP_W_172 3600.001.00830.010000.00
TS_IDX_T_EXP_W_227 6002.671.00580.023000.00
TS_IDX_T_EXP_W_179 3600.001.00810.010000.00
TS_IDX_T_EXP_W_182 3000.001.00870.010000.00
TS_IDX_T_EXP_W_187 5602.681.00610.023000.00
TS_IDX_T_EXP_CONTAINER_219 3700.001.00790.010000.00
TS_IDX_T_EXP_W_184 3000.001.00850.010000.00
TS_IDX_T_EXP_W_176 3600.001.00770.010000.00
TS_IDX_T_EXP_W_190 3000.001.00830.010050.00
TS_IDX_T_EXP_W_239 3900.001.00740.010000.00
TS_IDX_T_EXP_W_208 3200.001.00800.010000.00
TS_IDX_T_EXP_CONTAINER_185 3100.321.00790.010000.00
TS_IDX_T_EXP_W_181 3000.001.00790.010000.00
TS_IDX_T_EXP_CONTAINER_231 3000.001.00780.010000.00
TS_IDX_T_EXP_CONTAINER_161 2700.741.00790.011000.00
TS_IDX_T_EXP_W_211 3200.311.00740.010000.00
TS_IDX_T_EXP_CONTAINER_193 3801.051.00660.011000.00
TS_IDX_T_EXP_CONTAINER_198 3700.271.00660.010000.00
TS_IDX_T_EXP_W_199 3700.001.00660.010000.00
TS_IDX_T_EXP_W_225 3800.001.00650.010010.00
TS_IDX_T_EXP_CONTAINER_238 3900.771.00620.011000.00
TS_IDX_T_EXP_W_221 3800.001.00630.010010.00
TS_IDX_T_EXP_W_204 3100.001.00680.010000.00
TS_IDX_T_EXP_W_228 3200.001.00670.010010.00
TS_IDX_T_EXP_CONTAINER_170 3000.001.00680.010000.00
TS_IDX_T_EXP_CONTAINER_191 3300.301.00650.011000.00
TS_IDX_T_EXP_CONTAINER_216 3600.001.00610.010000.00
TS_IDX_T_EXP_W_168 3000.001.00630.010000.00
TS_IDX_T_EXP_CONTAINER_232 3100.001.00610.010000.00
TS_T_EXP_CONTAINER_165 7200.001.00200.020000.00
TS_YTMDM 7800.001.00140.020000.00
TS_IDX_T_EXP_CONTAINER_162 2600.381.00650.010000.00
TS_IDX_T_EXP_W_163 3000.001.00610.010000.00
TS_IDX_T_EXP_CONTAINER_166 2400.001.00650.010000.00
TS_IDX_T_EXP_W_192 3700.001.00520.010000.00
TS_IDX_T_EXP_W_230 5203.461.00370.013000.00
TS_IDX_T_EXP_W_235 3200.001.00570.010000.00
TS_IDX_T_EXP_CONTAINER_220 3700.271.00510.010000.00
TS_IDX_T_EXP_CONTAINER_194 3700.271.00500.010000.00
TS_IDX_T_EXP_W_232 3200.001.00530.010000.00
TS_IDX_T_EXP_CONTAINER_202 3600.001.00460.010000.00
TS_IDX_T_EXP_CONTAINER_218 3600.001.00460.010000.00
TS_IDX_T_EXP_CONTAINER_240 3800.261.00440.010000.00
TS_IDX_T_EXP_CONTAINER_208 3000.001.00510.010000.00
TS_IDX_T_EXP_CONTAINER_210 3100.321.00490.010000.00
TS_IDX_T_EXP_CONTAINER_233 3100.001.00490.010000.00
TS_IDX_T_EXP_W_171 3600.001.00440.010000.00
TS_IDX_T_EXP_CONTAINER_167 2600.381.00530.010000.00
TS_IDX_T_EXP_CONTAINER_180 3200.311.00470.010000.00
TS_IDX_T_EXP_CONTAINER_188 3000.001.00480.010000.00
TS_IDX_T_EXP_CONTAINER_203 3000.001.00470.010000.00
TS_IDX_T_EXP_CONTAINER_171 3000.001.00460.010000.00
TS_IDX_T_EXP_CONTAINER_213 3000.001.00460.010000.00
TS_IDX_T_EXP_CONTAINER_174 3200.631.00430.011000.00
TS_IDX_T_EXP_CONTAINER_183 3100.321.00410.010000.00
TS_IDX_T_EXP_W_194 3700.001.00350.010000.00
TS_IDX_T_EXP_CONTAINER_217 3700.271.00340.010000.00
TS_IDX_T_EXP_CONTAINER_226 3200.631.00390.011000.00
TS_IDX_T_EXP_W_200 3700.001.00340.010000.00
TS_IDX_T_EXP_CONTAINER_169 3000.001.00390.010000.00
TS_IDX_T_EXP_CONTAINER_199 3800.261.00300.010000.00
TS_IDX_T_EXP_CONTAINER_201 3600.001.00320.010000.00
TS_IDX_T_EXP_W_222 3800.001.00290.010000.00
TS_IDX_T_EXP_W_234 3200.001.00350.010000.00
TS_T_EXP_CONTAINER_208 5100.001.00130.010000.00
TS_IDX_T_EXP_CONTAINER_225 3700.001.00250.010000.00
TS_IDX_T_EXP_CONTAINER_172 3000.001.00290.010000.00
TS_IDX_T_EXP_CONTAINER_175 3000.001.00290.010000.00
TS_IDX_T_EXP_CONTAINER_176 3000.001.00290.010000.00
TS_IDX_T_EXP_CONTAINER_195 3700.271.00220.010000.00
TS_IDX_T_EXP_CONTAINER_224 3600.001.00220.010000.00
TS_IDX_T_EXP_CONTAINER_173 3100.321.00250.010000.00
TS_IDX_T_EXP_CONTAINER_164 2600.381.00290.011000.00
TS_IDX_T_EXP_CONTAINER_181 3000.001.00250.010000.00
TS_IDX_T_EXP_CONTAINER_204 3000.001.00250.010000.00
TS_IDX_T_EXP_CONTAINER_239 3800.261.00170.010000.00
TS_IDX_T_EXP_CONTAINER_205 3000.001.00240.010000.00
TS_IDX_T_EXP_CONTAINER_221 3700.271.00170.010000.00
TS_IDX_T_EXP_CONTAINER_236 3000.001.00240.010000.00
TS_IDX_T_EXP_CONTAINER_178 3200.311.00200.010000.00
TS_IDX_T_EXP_CONTAINER_196 3600.001.00150.010000.00
TS_IDX_T_EXP_CONTAINER_223 3600.001.00120.010000.00
TS_IDX_T_EXP_CONTAINER_234 3000.001.00180.010000.00
TS_IDX_T_EXP_CONTAINER_184 3100.321.00160.010000.00
TS_IDX_YTMDM 3900.001.0070.010000.00
TS_IDX_T_EXP_CONTAINER_237 3000.001.00150.010000.00
TS_T_EXP_W_208 3900.511.0060.011000.00
TS_IDX_T_EXP_CONTAINER_168 2500.401.00190.010000.00
TS_IDX_T_EXP_CONTAINER_207 3000.001.00130.010000.00
TS_IDX_T_EXP_CONTAINER_192 3600.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_200 3600.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_215 3600.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_222 3600.001.0060.010000.00
TS_T_EXP_W_160 3600.001.0060.010000.00
TS_T_EXP_W_161 3600.001.0060.010000.00
TS_T_EXP_W_162 3600.001.0060.010000.00
TS_T_EXP_W_163 3600.001.0060.010000.00
TS_T_EXP_W_164 3600.001.0060.010000.00
TS_T_EXP_W_165 3600.001.0060.010000.00
TS_T_EXP_W_166 3600.001.0060.010000.00
TS_T_EXP_W_167 3600.001.0060.010000.00
TS_T_EXP_W_180 3600.001.0060.010000.00
TS_T_EXP_W_181 3600.001.0060.010000.00
TS_T_EXP_W_182 3600.001.0060.010000.00
TS_T_EXP_W_183 3600.001.0060.010000.00
TS_T_EXP_W_184 3600.001.0060.010000.00
TS_T_EXP_W_185 3600.001.0060.010000.00
TS_T_EXP_W_186 3600.001.0060.010000.00
TS_T_EXP_W_187 3600.001.0060.010000.00
TS_T_EXP_W_188 3600.001.0060.010000.00
TS_T_EXP_W_189 3600.001.0060.010000.00
TS_T_EXP_W_190 3600.001.0060.010000.00
TS_T_EXP_W_203 3600.001.0060.010000.00
TS_T_EXP_W_204 3600.001.0060.010000.00
TS_T_EXP_W_205 3600.001.0060.010000.00
TS_T_EXP_W_206 3600.001.0060.010000.00
TS_T_EXP_W_207 3600.001.0060.010000.00
TS_T_EXP_W_209 3600.001.0060.010000.00
TS_T_EXP_W_210 3600.001.0060.010000.00
TS_T_EXP_W_211 3600.001.0060.010000.00
TS_T_EXP_W_212 3600.001.0060.010000.00
TS_T_EXP_W_213 3600.001.0060.010000.00
TS_T_EXP_W_226 3600.001.0060.010000.00
TS_T_EXP_W_227 3600.001.0060.010000.00
TS_T_EXP_W_228 3600.001.0060.010000.00
TS_T_EXP_W_229 3600.001.0060.010000.00
TS_T_EXP_W_230 3600.001.0060.010000.00
TS_T_EXP_W_231 3600.001.0060.010000.00
TS_T_EXP_W_232 3600.001.0060.010000.00
TS_T_EXP_W_233 3600.001.0060.010000.00
TS_T_EXP_W_234 3600.001.0060.010000.00
TS_T_EXP_W_235 3600.001.0060.010000.00
TS_T_EXP_W_236 3600.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_177 3000.001.00100.010000.00
TS_IDX_T_EXP_CONTAINER_190 3000.001.00100.010000.00
TS_IDX_T_EXP_CONTAINER_230 3000.001.00100.010000.00
TS_IDX_T_EXP_CONTAINER_214 3000.001.0090.010000.00
TS_T_EXP_W_197 3100.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_179 3000.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_182 3000.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_186 3000.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_187 3000.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_189 3000.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_209 3000.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_211 3000.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_212 3000.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_227 3000.001.0060.010000.00
TS_IDX_T_EXP_CONTAINER_235 3000.001.0060.010000.00
TS_T_EXP_W_168 3000.001.0060.010000.00
TS_T_EXP_W_169 3000.001.0060.010000.00
TS_T_EXP_W_170 3000.001.0060.010000.00
TS_T_EXP_W_171 3000.001.0060.010000.00
TS_T_EXP_W_172 3000.001.0060.010000.00
TS_T_EXP_W_173 3000.001.0060.010000.00
TS_T_EXP_W_174 3000.001.0060.010000.00
TS_T_EXP_W_175 3000.001.0060.010000.00
TS_T_EXP_W_176 3000.001.0060.010000.00
TS_T_EXP_W_177 3000.001.0060.010000.00
TS_T_EXP_W_178 3000.001.0060.010000.00
TS_T_EXP_W_179 3000.001.0060.010000.00
TS_T_EXP_W_191 3000.001.0060.010000.00
TS_T_EXP_W_192 3000.001.0060.010000.00
TS_T_EXP_W_193 3000.001.0060.010000.00
TS_T_EXP_W_194 3000.001.0060.010000.00
TS_T_EXP_W_195 3000.001.0060.010000.00
TS_T_EXP_W_196 3000.001.0060.010000.00
TS_T_EXP_W_198 3000.001.0060.010000.00
TS_T_EXP_W_199 3000.001.0060.010000.00
TS_T_EXP_W_200 3000.001.0060.010000.00
TS_T_EXP_W_201 3000.001.0060.010000.00
TS_T_EXP_W_202 3000.001.0060.010000.00
TS_T_EXP_W_214 3000.001.0060.010000.00
TS_T_EXP_W_215 3000.001.0060.010000.00
TS_T_EXP_W_216 3000.001.0060.010000.00
TS_T_EXP_W_217 3000.001.0060.010000.00
TS_T_EXP_W_218 3000.001.0060.010000.00
TS_T_EXP_W_219 3000.001.0060.010000.00
TS_T_EXP_W_220 3000.001.0060.010000.00
TS_T_EXP_W_221 3000.001.0060.010000.00
TS_T_EXP_W_222 3000.001.0060.010000.00
TS_T_EXP_W_223 3000.001.0060.010000.00
TS_T_EXP_W_224 3000.001.0060.010000.00
TS_T_EXP_W_225 3000.001.0060.010000.00
TS_T_EXP_W_237 3000.001.0060.010000.00
TS_T_EXP_W_238 3000.001.0060.010000.00
TS_T_EXP_W_239 3000.001.0060.010000.00
TS_T_EXP_W_240 3000.001.0060.010000.00
TS_T_EXP_CONTAINER_226 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_227 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_228 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_229 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_230 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_231 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_232 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_233 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_234 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_235 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_236 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_237 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_238 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_239 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_240 2400.001.0060.010000.00
TS_T_EXP_CONTAINER_203 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_204 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_205 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_206 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_207 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_209 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_210 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_211 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_212 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_213 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_214 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_215 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_216 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_217 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_218 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_219 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_220 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_221 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_222 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_223 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_224 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_225 1800.001.0060.000000.00
TS_T_EXP_CONTAINER_180 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_181 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_182 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_183 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_184 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_185 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_186 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_187 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_188 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_189 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_190 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_191 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_192 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_193 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_194 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_195 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_196 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_197 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_198 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_199 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_200 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_201 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_202 1200.001.0060.000000.00
TS_T_EXP_CONTAINER_161 600.001.0060.000000.00
TS_T_EXP_CONTAINER_162 600.001.0060.000000.00
TS_T_EXP_CONTAINER_163 600.001.0060.000000.00
TS_T_EXP_CONTAINER_164 600.001.0060.000000.00
TS_T_EXP_CONTAINER_166 600.001.0060.000000.00
TS_T_EXP_CONTAINER_167 600.001.0060.000000.00
TS_T_EXP_CONTAINER_168 600.001.0060.000000.00
TS_T_EXP_CONTAINER_169 600.001.0060.000000.00
TS_T_EXP_CONTAINER_170 600.001.0060.000000.00
TS_T_EXP_CONTAINER_171 600.001.0060.000000.00
TS_T_EXP_CONTAINER_172 600.001.0060.000000.00
TS_T_EXP_CONTAINER_173 600.001.0060.000000.00
TS_T_EXP_CONTAINER_174 600.001.0060.000000.00
TS_T_EXP_CONTAINER_175 600.001.0060.000000.00
TS_T_EXP_CONTAINER_176 600.001.0060.000000.00
TS_T_EXP_CONTAINER_177 600.001.0060.000000.00
TS_T_EXP_CONTAINER_178 600.001.0060.000000.00
TS_T_EXP_CONTAINER_179 600.001.0060.000000.00
USERS 600.001.0060.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 6204.841.0004.68913000.00
SYSTEM+DATA_DG/dbquery/datafile/system.261.828812051 8704.371.0004.3758002521.15
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_01.dbf 3900.001.0000.007000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_02.dbf 3900.001.0000.007000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_03.dbf 3900.001.0000.007000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_04.dbf 3900.001.0000.007000.00
TBS_OTH_SPLEX+DATA_DG/dbquery/datafile/tbs_oth_splex_05.dbf 3900.001.0000.007000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_01.dbf 11103.151.0003.157000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_02.dbf 3300.001.0000.007000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_03.dbf 5003.201.0003.207000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_04.dbf 3300.001.0000.007000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_05.dbf 3900.771.0000.777000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_06.dbf 3300.001.0000.007000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_07.dbf 3300.001.0000.007000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_08.dbf 3300.001.0000.007000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_09.dbf 4000.001.0000.007000.00
TS_CONTAINER_01+DATA_DG/dbquery/datafile/ts_container_01_10.dbf 4000.001.0000.007000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_01.dbf 15803.921.0003.99137000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_02.dbf 68203.081.8003.00575010.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_03.dbf 8605.231.0005.23433020.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_04.dbf 20404.072.9804.70724000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_05.dbf 81903.191.0003.19862000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_06.dbf 26603.721.0003.72804030.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_07.dbf 14704.421.2804.48221000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_08.dbf 25103.822.5104.21348000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_09.dbf 32703.941.0003.94777000.00
TS_CONTAINER_02+DATA_DG/dbquery/datafile/ts_container_02_10.dbf 29004.451.0004.45716000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_01.dbf 4000.001.0000.007000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_02.dbf 4300.231.0000.2321000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_03.dbf 4000.001.0000.009000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_04.dbf 4000.001.0000.0013000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_05.dbf 4000.001.0000.0012000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_06.dbf 4000.001.0000.007000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_07.dbf 4000.001.0000.009000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_08.dbf 4100.001.0000.0011000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_09.dbf 4000.001.0000.007000.00
TS_HANDON_01+DATA_DG/dbquery/datafile/ts_handon_01_10.dbf 3400.001.0000.007000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_01.dbf 700.001.0001.43782000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_02.dbf 702.861.0002.861,417060.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_03.dbf 1101.821.0001.821,030040.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_04.dbf 1002.001.0002.001,071020.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_05.dbf 2002.001.0002.001,443030.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_06.dbf 1203.331.0003.33699000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_07.dbf 1101.821.0001.82742000.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_08.dbf 600.001.0000.00469030.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_09.dbf 6902.031.0001.88783080.00
TS_HANDON_02+DATA_DG/dbquery/datafile/ts_handon_02_10.dbf 700.001.0000.006660110.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_01.dbf 1,54005.681.0005.672,941100.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_02.dbf 1,50605.731.0005.722,510100.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_03.dbf 1,52505.541.0005.542,180100.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_04.dbf 1,48005.821.0005.822,400120.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_05.dbf 1,50005.761.0005.762,872110.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_06.dbf 1,51005.541.0005.542,869110.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_07.dbf 1,44205.451.0005.442,225100.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_08.dbf 1,48905.921.0005.922,450100.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_09.dbf 1,48805.591.0005.592,862100.00
TS_IDX_CONTAINER+DATA_DG/dbquery/datafile/ts_idx_container_10.dbf 1,53805.661.0005.662,458100.00
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_01.dbf 3,72210.911.0010.9133301,7230.45
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_02.dbf 4,11010.891.0010.8924501,7440.51
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_03.dbf 3,86910.921.0010.9224001,5370.55
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_04.dbf 3,84910.931.0010.9344301,3170.53
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_05.dbf 3,82410.931.0010.9345601,6710.53
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_06.dbf 4,13010.911.0010.9127401,4190.57
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_07.dbf 4,07210.921.0010.9134001,3760.49
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_08.dbf 3,67010.921.0010.9132401,2560.52
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_09.dbf 2,89710.931.0010.9227801,1810.58
TS_IDX_HANDON+INDEX_DG/idx_data/ts_idx_handon_10.dbf 2,84210.911.0010.9117501,1250.68
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_01.dbf 23900.881.0000.884030860.58
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_02.dbf 19000.841.0000.844940670.60
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_03.dbf 16300.861.0000.862450740.41
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_04.dbf 18200.881.0000.822310930.43
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_05.dbf 13800.871.0000.87760350.57
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_06.dbf 11100.811.0000.811820171.18
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_07.dbf 16200.801.0000.86161030.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_08.dbf 16700.841.0000.84250025.00
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_09.dbf 19500.821.0000.871160330.30
TS_IDX_SIGNATURE+INDEX_DG/idx_data/ts_idx_signature_10.dbf 26300.841.0000.871850220.45
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_01.dbf 1800.001.0000.006000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_02.dbf 1800.001.0000.006000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_03.dbf 1800.001.0000.006000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_04.dbf 1800.001.0000.006000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_05.dbf 1800.001.0000.006000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_06.dbf 1800.001.0000.006000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_07.dbf 1800.001.0000.006000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_08.dbf 1800.001.0000.006000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_09.dbf 1800.001.0000.006000.00
TS_IDX_TAKE+INDEX_DG/idx_data/ts_idx_take_10.dbf 1800.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_161+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_161.dbf 2700.741.0000.7479000.00
TS_IDX_T_EXP_CONTAINER_162+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_162.dbf 2600.381.0000.3865000.00
TS_IDX_T_EXP_CONTAINER_163+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_163.dbf 2500.401.0000.40131000.00
TS_IDX_T_EXP_CONTAINER_164+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_164.dbf 2600.381.0000.7729000.00
TS_IDX_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_165.dbf 6403.131.0003.131,923100.00
TS_IDX_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165_01.dbf 3300.001.0000.001,913100.00
TS_IDX_T_EXP_CONTAINER_166+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_166.dbf 2400.001.0000.0065000.00
TS_IDX_T_EXP_CONTAINER_167+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_167.dbf 2600.381.0000.3853000.00
TS_IDX_T_EXP_CONTAINER_168+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_168.dbf 2500.401.0000.0019000.00
TS_IDX_T_EXP_CONTAINER_169+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_169.dbf 3000.001.0000.0039000.00
TS_IDX_T_EXP_CONTAINER_170+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_170.dbf 3000.001.0000.0068000.00
TS_IDX_T_EXP_CONTAINER_171+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_171.dbf 3000.001.0000.0046000.00
TS_IDX_T_EXP_CONTAINER_172+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_172.dbf 3000.001.0000.0029000.00
TS_IDX_T_EXP_CONTAINER_173+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_173.dbf 3100.321.0000.3225000.00
TS_IDX_T_EXP_CONTAINER_174+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_174.dbf 3200.631.0000.6343000.00
TS_IDX_T_EXP_CONTAINER_175+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_175.dbf 3000.001.0000.0029000.00
TS_IDX_T_EXP_CONTAINER_176+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_176.dbf 3000.001.0000.0029000.00
TS_IDX_T_EXP_CONTAINER_177+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_177.dbf 3000.001.0000.0010000.00
TS_IDX_T_EXP_CONTAINER_178+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_178.dbf 3200.311.0000.3120000.00
TS_IDX_T_EXP_CONTAINER_179+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_179.dbf 3000.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_180+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_180.dbf 3200.311.0000.3147000.00
TS_IDX_T_EXP_CONTAINER_181+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_181.dbf 3000.001.0000.0025000.00
TS_IDX_T_EXP_CONTAINER_182+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_182.dbf 3000.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_183+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_183.dbf 3100.321.0000.0041000.00
TS_IDX_T_EXP_CONTAINER_184+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_184.dbf 3100.321.0000.3216000.00
TS_IDX_T_EXP_CONTAINER_185+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_185.dbf 3100.321.0000.0079000.00
TS_IDX_T_EXP_CONTAINER_186+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_186.dbf 3000.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_187+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_187.dbf 3000.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_188+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_188.dbf 3000.001.0000.0048000.00
TS_IDX_T_EXP_CONTAINER_189+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_189.dbf 3000.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_190+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_190.dbf 3000.001.0000.0010000.00
TS_IDX_T_EXP_CONTAINER_191+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_191.dbf 3300.301.0000.6165000.00
TS_IDX_T_EXP_CONTAINER_192+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_192.dbf 3600.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_193+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_193.dbf 3801.051.0001.0566000.00
TS_IDX_T_EXP_CONTAINER_194+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_194.dbf 3700.271.0000.2750000.00
TS_IDX_T_EXP_CONTAINER_195+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_195.dbf 3700.271.0000.2722000.00
TS_IDX_T_EXP_CONTAINER_196+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_196.dbf 3600.001.0000.0015000.00
TS_IDX_T_EXP_CONTAINER_197+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_197.dbf 4100.241.0000.24101000.00
TS_IDX_T_EXP_CONTAINER_198+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_198.dbf 3700.271.0000.2766000.00
TS_IDX_T_EXP_CONTAINER_199+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_199.dbf 3800.261.0000.2630000.00
TS_IDX_T_EXP_CONTAINER_200+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_200.dbf 3600.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_201+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_201.dbf 3600.001.0000.0032000.00
TS_IDX_T_EXP_CONTAINER_202+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_202.dbf 3600.001.0000.0046000.00
TS_IDX_T_EXP_CONTAINER_203+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_203.dbf 3000.001.0000.0047000.00
TS_IDX_T_EXP_CONTAINER_204+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_204.dbf 3000.001.0000.0025000.00
TS_IDX_T_EXP_CONTAINER_205+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_205.dbf 3000.001.0000.0024000.00
TS_IDX_T_EXP_CONTAINER_206+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_206.dbf 4301.401.0001.40664000.00
TS_IDX_T_EXP_CONTAINER_207+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_207.dbf 3000.001.0000.0013000.00
TS_IDX_T_EXP_CONTAINER_208+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_208.dbf 3000.001.0000.0051000.00
TS_IDX_T_EXP_CONTAINER_209+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_209.dbf 3000.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_210+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_210.dbf 3100.321.0000.0049000.00
TS_IDX_T_EXP_CONTAINER_211+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_211.dbf 3000.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_212+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_212.dbf 3000.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_213+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_213.dbf 3000.001.0000.0046000.00
TS_IDX_T_EXP_CONTAINER_214+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_214.dbf 3000.001.0000.009000.00
TS_IDX_T_EXP_CONTAINER_215+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_215.dbf 3600.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_216+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_216.dbf 3600.001.0000.0061000.00
TS_IDX_T_EXP_CONTAINER_217+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_217.dbf 3700.271.0000.2734000.00
TS_IDX_T_EXP_CONTAINER_218+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_218.dbf 3600.001.0000.0046000.00
TS_IDX_T_EXP_CONTAINER_219+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_219.dbf 3700.001.0000.2779000.00
TS_IDX_T_EXP_CONTAINER_220+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_220.dbf 3700.271.0000.0051000.00
TS_IDX_T_EXP_CONTAINER_221+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_221.dbf 3700.271.0000.0017000.00
TS_IDX_T_EXP_CONTAINER_222+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_222.dbf 3600.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_223+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_223.dbf 3600.001.0000.0012000.00
TS_IDX_T_EXP_CONTAINER_224+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_224.dbf 3600.001.0000.0022000.00
TS_IDX_T_EXP_CONTAINER_225+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_225.dbf 3700.001.0000.0025000.00
TS_IDX_T_EXP_CONTAINER_226+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_226.dbf 3200.631.0000.6339000.00
TS_IDX_T_EXP_CONTAINER_227+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_227.dbf 3000.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_228+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_228.dbf 3200.311.0000.3187000.00
TS_IDX_T_EXP_CONTAINER_229+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_229.dbf 3100.001.0000.00104000.00
TS_IDX_T_EXP_CONTAINER_230+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_230.dbf 3000.001.0000.0010000.00
TS_IDX_T_EXP_CONTAINER_231+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_231.dbf 3000.001.0000.0078000.00
TS_IDX_T_EXP_CONTAINER_232+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_232.dbf 3100.001.0000.0061000.00
TS_IDX_T_EXP_CONTAINER_233+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_233.dbf 3100.001.0000.3249000.00
TS_IDX_T_EXP_CONTAINER_234+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_234.dbf 3000.001.0000.0018000.00
TS_IDX_T_EXP_CONTAINER_235+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_235.dbf 3000.001.0000.006000.00
TS_IDX_T_EXP_CONTAINER_236+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_236.dbf 3000.001.0000.0024000.00
TS_IDX_T_EXP_CONTAINER_237+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_237.dbf 3000.001.0000.0015000.00
TS_IDX_T_EXP_CONTAINER_238+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_238.dbf 3900.771.0000.5162000.00
TS_IDX_T_EXP_CONTAINER_239+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_239.dbf 3800.261.0000.2617000.00
TS_IDX_T_EXP_CONTAINER_240+DATA_DG/dbquery/datafile/ts_idx_t_exp_container_240.dbf 3800.261.0000.2644000.00
TS_IDX_T_EXP_W_161+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_161.dbf 3000.001.0000.00130000.00
TS_IDX_T_EXP_W_162+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_162.dbf 3600.831.0000.83195060.00
TS_IDX_T_EXP_W_163+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_163.dbf 3000.001.0000.0061000.00
TS_IDX_T_EXP_W_164+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_164.dbf 25105.821.0005.8220303583.41
TS_IDX_T_EXP_W_165+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_165.dbf 3000.001.0000.001040160.00
TS_IDX_T_EXP_W_166+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_166.dbf 3000.001.0000.00134000.00
TS_IDX_T_EXP_W_167+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_167.dbf 15905.911.0005.9112201364.93
TS_IDX_T_EXP_W_168+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_168.dbf 3000.001.0000.0063000.00
TS_IDX_T_EXP_W_169+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_169.dbf 4401.141.0001.14177020.00
TS_IDX_T_EXP_W_170+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_170.dbf 5702.631.0002.631840343.24
TS_IDX_T_EXP_W_171+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_171.dbf 3600.001.0000.0044000.00
TS_IDX_T_EXP_W_172+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_172.dbf 3600.001.0000.0083000.00
TS_IDX_T_EXP_W_173+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_173.dbf 14605.341.0005.3449000.00
TS_IDX_T_EXP_W_174+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_174.dbf 3800.261.0000.26264070.00
TS_IDX_T_EXP_W_175+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_175.dbf 3600.001.0000.00187060.00
TS_IDX_T_EXP_W_176+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_176.dbf 3600.001.0000.0077000.00
TS_IDX_T_EXP_W_177+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_177.dbf 12104.211.0004.30112010.00
TS_IDX_T_EXP_W_178+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_178.dbf 3600.001.0000.00108000.00
TS_IDX_T_EXP_W_179+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_179.dbf 3600.001.0000.0081000.00
TS_IDX_T_EXP_W_180+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_180.dbf 5802.761.0002.761130393.85
TS_IDX_T_EXP_W_181+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_181.dbf 3000.001.0000.0079000.00
TS_IDX_T_EXP_W_182+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_182.dbf 3000.001.0000.0087000.00
TS_IDX_T_EXP_W_183+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_183.dbf 3400.591.0000.59202020.00
TS_IDX_T_EXP_W_184+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_184.dbf 3000.001.0000.0085000.00
TS_IDX_T_EXP_W_185+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_185.dbf 6603.331.0003.48200050.00
TS_IDX_T_EXP_W_186+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_186.dbf 9404.471.0004.5749000.00
TS_IDX_T_EXP_W_187+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_187.dbf 5602.681.0002.6861000.00
TS_IDX_T_EXP_W_188+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_188.dbf 3000.001.0000.00103000.00
TS_IDX_T_EXP_W_189+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_189.dbf 3000.001.0000.00104000.00
TS_IDX_T_EXP_W_190+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_190.dbf 3000.001.0000.0083050.00
TS_IDX_T_EXP_W_191+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_191.dbf 3000.001.0000.00113020.00
TS_IDX_T_EXP_W_192+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_192.dbf 3700.001.0000.0052000.00
TS_IDX_T_EXP_W_193+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_193.dbf 10103.371.0003.37131000.00
TS_IDX_T_EXP_W_194+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_194.dbf 3700.001.0000.0035000.00
TS_IDX_T_EXP_W_195+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_195.dbf 6202.741.0002.74820753.33
TS_IDX_T_EXP_W_196+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_196.dbf 3700.001.0000.00114050.00
TS_IDX_T_EXP_W_197+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_197.dbf 12604.441.0004.5214101473.67
TS_IDX_T_EXP_W_198+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_198.dbf 7204.581.0004.58131000.00
TS_IDX_T_EXP_W_199+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_199.dbf 3700.001.0000.0066000.00
TS_IDX_T_EXP_W_200+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_200.dbf 3700.001.0000.0034000.00
TS_IDX_T_EXP_W_201+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_201.dbf 4903.271.0003.27113000.00
TS_IDX_T_EXP_W_202+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_202.dbf 4301.161.0001.16172010.00
TS_IDX_T_EXP_W_203+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_203.dbf 3100.001.0000.00115030.00
TS_IDX_T_EXP_W_204+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_204.dbf 3100.001.0000.0068000.00
TS_IDX_T_EXP_W_205+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_205.dbf 3100.001.0000.00108000.00
TS_IDX_T_EXP_W_206+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_206.dbf 3701.081.0001.08144065.00
TS_IDX_T_EXP_W_207+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_207.dbf 3100.001.0000.0099030.00
TS_IDX_T_EXP_W_208+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_208.dbf 3200.001.0000.3180000.00
TS_IDX_T_EXP_W_209+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_209.dbf 3100.001.0000.00104000.00
TS_IDX_T_EXP_W_210+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_210.dbf 3400.291.0000.29101010.00
TS_IDX_T_EXP_W_211+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_211.dbf 3200.311.0000.3174000.00
TS_IDX_T_EXP_W_212+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_212.dbf 3100.001.0000.0093000.00
TS_IDX_T_EXP_W_213+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_213.dbf 3100.001.0000.001000110.00
TS_IDX_T_EXP_W_214+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_214.dbf 3100.001.0000.0094010.00
TS_IDX_T_EXP_W_215+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_215.dbf 3800.001.0000.00256010.00
TS_IDX_T_EXP_W_216+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_216.dbf 4301.161.0001.16126020.00
TS_IDX_T_EXP_W_217+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_217.dbf 12704.091.0004.0911701853.03
TS_IDX_T_EXP_W_218+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_218.dbf 4702.131.0002.13100020.00
TS_IDX_T_EXP_W_219+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_219.dbf 4000.251.0000.25127000.00
TS_IDX_T_EXP_W_220+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_220.dbf 3800.001.0000.001010130.00
TS_IDX_T_EXP_W_221+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_221.dbf 3800.001.0000.0063010.00
TS_IDX_T_EXP_W_222+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_222.dbf 3800.001.0000.0029000.00
TS_IDX_T_EXP_W_223+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_223.dbf 3900.001.0000.00115010.00
TS_IDX_T_EXP_W_224+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_224.dbf 13504.441.0004.5215001994.02
TS_IDX_T_EXP_W_225+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_225.dbf 3800.001.0000.0065010.00
TS_IDX_T_EXP_W_226+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_226.dbf 3200.001.0000.0097020.00
TS_IDX_T_EXP_W_227+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_227.dbf 6002.671.0002.5058000.00
TS_IDX_T_EXP_W_228+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_228.dbf 3200.001.0000.0067010.00
TS_IDX_T_EXP_W_229+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_229.dbf 14306.361.0006.4323501293.80
TS_IDX_T_EXP_W_230+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_230.dbf 5203.461.0003.4637000.00
TS_IDX_T_EXP_W_231+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_231.dbf 3200.001.0000.00120030.00
TS_IDX_T_EXP_W_232+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_232.dbf 3200.001.0000.0053000.00
TS_IDX_T_EXP_W_233+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_233.dbf 3701.351.0001.0896000.00
TS_IDX_T_EXP_W_234+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_234.dbf 3200.001.0000.0035000.00
TS_IDX_T_EXP_W_235+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_235.dbf 3200.001.0000.0057000.00
TS_IDX_T_EXP_W_236+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_236.dbf 17204.591.0004.5986000.00
TS_IDX_T_EXP_W_237+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_237.dbf 4702.341.0002.13155000.00
TS_IDX_T_EXP_W_238+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_238.dbf 7403.241.0003.24900823.54
TS_IDX_T_EXP_W_239+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_239.dbf 3900.001.0000.0074000.00
TS_IDX_T_EXP_W_240+DATA_DG/dbquery/datafile/ts_idx_t_exp_w_240.dbf 6402.191.0002.191020150.67
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_01.dbf 1,85111.061.0011.0682,1152380.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_02.dbf 1,85111.061.0011.0782,7092340.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_03.dbf 1,98011.051.0011.0588,1382430.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_04.dbf 1,89811.061.0011.0687,5902410.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_05.dbf 1,91811.061.0011.0687,4212420.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_06.dbf 1,98511.091.0011.0986,9442480.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_07.dbf 1,81011.111.0011.1088,4672520.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_08.dbf 1,88111.081.0011.0883,1242330.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_09.dbf 1,84011.071.0011.0783,9352360.00
TS_IDX_YTEXP+INDEX_DG/idx_data/ts_idx_ytexp_10.dbf 1,69501.111.0001.1181,3182310.00
TS_IDX_YTMDM+DATA_DG/dbquery/datafile/ts_idx_ytmdm.dbf 3900.001.0000.007000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_01.dbf 3400.001.0000.007000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_02.dbf 3400.001.0000.007000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_03.dbf 3400.001.0000.007000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_04.dbf 3400.001.0000.007000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_05.dbf 3400.001.0000.007000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_06.dbf 3600.281.0000.287000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_07.dbf 3600.561.0000.567000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_08.dbf 3400.001.0000.007000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_09.dbf 3400.001.0000.007000.00
TS_SIGNATURE_01+DATA_DG/dbquery/datafile/ts_signature_01_10.dbf 3400.001.0000.007000.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_01.dbf 5405.374.2603.571380110.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_02.dbf 5004.402.0204.00128040.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_03.dbf 13902.732.6401.972850130.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_04.dbf 7305.621.6705.56152091.11
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_05.dbf 5502.731.9103.611820180.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_06.dbf 2803.571.0003.931710150.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_07.dbf 2803.931.4603.85269030.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_08.dbf 2803.572.3203.48248060.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_09.dbf 4005.251.0005.251320110.00
TS_SIGNATURE_02+DATA_DG/dbquery/datafile/ts_signature_02_10.dbf 4204.523.6004.15293040.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_01.dbf 3400.001.0000.007000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_02.dbf 4100.001.0000.007000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_03.dbf 4100.001.0000.007000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_04.dbf 4100.001.0000.007000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_05.dbf 4100.001.0000.007000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_06.dbf 4100.001.0000.007000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_07.dbf 4100.001.0000.007000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_08.dbf 4100.001.0000.007000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_09.dbf 4100.001.0000.007000.00
TS_TAKE_01+DATA_DG/dbquery/datafile/ts_take_01_10.dbf 4100.001.0000.007000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_01.dbf 600.001.0000.006000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_02.dbf 600.001.0000.006000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_03.dbf 600.001.0000.006000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_04.dbf 600.001.0000.006000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_05.dbf 1200.001.0000.006000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_06.dbf 1200.001.0000.006000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_07.dbf 1200.001.0000.006000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_08.dbf 1200.001.0000.006000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_09.dbf 1200.001.0000.006000.00
TS_TAKE_02+DATA_DG/dbquery/datafile/ts_take_02_10.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_161+DATA_DG/dbquery/datafile/ts_t_exp_container_161.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_162+DATA_DG/dbquery/datafile/ts_t_exp_container_162.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_163+DATA_DG/dbquery/datafile/ts_t_exp_container_163.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_164+DATA_DG/dbquery/datafile/ts_t_exp_container_164.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165_1.dbf 3300.001.0000.007000.00
TS_T_EXP_CONTAINER_165+DATA_DG/dbquery/datafile/ts_t_exp_container_165_2.dbf 3300.001.0000.007000.00
TS_T_EXP_CONTAINER_166+DATA_DG/dbquery/datafile/ts_t_exp_container_166.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_167+DATA_DG/dbquery/datafile/ts_t_exp_container_167.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_168+DATA_DG/dbquery/datafile/ts_t_exp_container_168.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_169+DATA_DG/dbquery/datafile/ts_t_exp_container_169.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_170+DATA_DG/dbquery/datafile/ts_t_exp_container_170.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_171+DATA_DG/dbquery/datafile/ts_t_exp_container_171.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_172+DATA_DG/dbquery/datafile/ts_t_exp_container_172.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_173+DATA_DG/dbquery/datafile/ts_t_exp_container_173.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_174+DATA_DG/dbquery/datafile/ts_t_exp_container_174.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_175+DATA_DG/dbquery/datafile/ts_t_exp_container_175.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_176+DATA_DG/dbquery/datafile/ts_t_exp_container_176.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_177+DATA_DG/dbquery/datafile/ts_t_exp_container_177.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_178+DATA_DG/dbquery/datafile/ts_t_exp_container_178.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_179+DATA_DG/dbquery/datafile/ts_t_exp_container_179.dbf 600.001.0000.006000.00
TS_T_EXP_CONTAINER_180+DATA_DG/dbquery/datafile/ts_t_exp_container_180.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_181+DATA_DG/dbquery/datafile/ts_t_exp_container_181.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_182+DATA_DG/dbquery/datafile/ts_t_exp_container_182.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_183+DATA_DG/dbquery/datafile/ts_t_exp_container_183.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_184+DATA_DG/dbquery/datafile/ts_t_exp_container_184.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_185+DATA_DG/dbquery/datafile/ts_t_exp_container_185.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_186+DATA_DG/dbquery/datafile/ts_t_exp_container_186.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_187+DATA_DG/dbquery/datafile/ts_t_exp_container_187.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_188+DATA_DG/dbquery/datafile/ts_t_exp_container_188.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_189+DATA_DG/dbquery/datafile/ts_t_exp_container_189.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_190+DATA_DG/dbquery/datafile/ts_t_exp_container_190.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_191+DATA_DG/dbquery/datafile/ts_t_exp_container_191.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_192+DATA_DG/dbquery/datafile/ts_t_exp_container_192.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_193+DATA_DG/dbquery/datafile/ts_t_exp_container_193.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_194+DATA_DG/dbquery/datafile/ts_t_exp_container_194.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_195+DATA_DG/dbquery/datafile/ts_t_exp_container_195.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_196+DATA_DG/dbquery/datafile/ts_t_exp_container_196.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_197+DATA_DG/dbquery/datafile/ts_t_exp_container_197.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_198+DATA_DG/dbquery/datafile/ts_t_exp_container_198.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_199+DATA_DG/dbquery/datafile/ts_t_exp_container_199.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_200+DATA_DG/dbquery/datafile/ts_t_exp_container_200.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_201+DATA_DG/dbquery/datafile/ts_t_exp_container_201.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_202+DATA_DG/dbquery/datafile/ts_t_exp_container_202.dbf 1200.001.0000.006000.00
TS_T_EXP_CONTAINER_203+DATA_DG/dbquery/datafile/ts_t_exp_container_203.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_204+DATA_DG/dbquery/datafile/ts_t_exp_container_204.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_205+DATA_DG/dbquery/datafile/ts_t_exp_container_205.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_206+DATA_DG/dbquery/datafile/ts_t_exp_container_206.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_207+DATA_DG/dbquery/datafile/ts_t_exp_container_207.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_208+DATA_DG/dbquery/datafile/ts_t_exp_container_208.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_208+DATA_DG/dbquery/datafile/ts_t_exp_container_208_1.dbf 3300.001.0000.007000.00
TS_T_EXP_CONTAINER_209+DATA_DG/dbquery/datafile/ts_t_exp_container_209.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_210+DATA_DG/dbquery/datafile/ts_t_exp_container_210.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_211+DATA_DG/dbquery/datafile/ts_t_exp_container_211.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_212+DATA_DG/dbquery/datafile/ts_t_exp_container_212.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_213+DATA_DG/dbquery/datafile/ts_t_exp_container_213.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_214+DATA_DG/dbquery/datafile/ts_t_exp_container_214.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_215+DATA_DG/dbquery/datafile/ts_t_exp_container_215.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_216+DATA_DG/dbquery/datafile/ts_t_exp_container_216.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_217+DATA_DG/dbquery/datafile/ts_t_exp_container_217.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_218+DATA_DG/dbquery/datafile/ts_t_exp_container_218.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_219+DATA_DG/dbquery/datafile/ts_t_exp_container_219.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_220+DATA_DG/dbquery/datafile/ts_t_exp_container_220.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_221+DATA_DG/dbquery/datafile/ts_t_exp_container_221.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_222+DATA_DG/dbquery/datafile/ts_t_exp_container_222.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_223+DATA_DG/dbquery/datafile/ts_t_exp_container_223.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_224+DATA_DG/dbquery/datafile/ts_t_exp_container_224.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_225+DATA_DG/dbquery/datafile/ts_t_exp_container_225.dbf 1800.001.0000.006000.00
TS_T_EXP_CONTAINER_226+DATA_DG/dbquery/datafile/ts_t_exp_container_226.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_227+DATA_DG/dbquery/datafile/ts_t_exp_container_227.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_228+DATA_DG/dbquery/datafile/ts_t_exp_container_228.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_229+DATA_DG/dbquery/datafile/ts_t_exp_container_229.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_230+DATA_DG/dbquery/datafile/ts_t_exp_container_230.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_231+DATA_DG/dbquery/datafile/ts_t_exp_container_231.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_232+DATA_DG/dbquery/datafile/ts_t_exp_container_232.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_233+DATA_DG/dbquery/datafile/ts_t_exp_container_233.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_234+DATA_DG/dbquery/datafile/ts_t_exp_container_234.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_235+DATA_DG/dbquery/datafile/ts_t_exp_container_235.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_236+DATA_DG/dbquery/datafile/ts_t_exp_container_236.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_237+DATA_DG/dbquery/datafile/ts_t_exp_container_237.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_238+DATA_DG/dbquery/datafile/ts_t_exp_container_238.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_239+DATA_DG/dbquery/datafile/ts_t_exp_container_239.dbf 2400.001.0000.006000.00
TS_T_EXP_CONTAINER_240+DATA_DG/dbquery/datafile/ts_t_exp_container_240.dbf 2400.001.0000.006000.00
TS_T_EXP_W_160+DATA_DG/dbquery/datafile/ts_t_exp_w_160.dbf 3600.001.0000.006000.00
TS_T_EXP_W_161+DATA_DG/dbquery/datafile/ts_t_exp_w_161.dbf 3600.001.0000.006000.00
TS_T_EXP_W_162+DATA_DG/dbquery/datafile/ts_t_exp_w_162.dbf 3600.001.0000.006000.00
TS_T_EXP_W_163+DATA_DG/dbquery/datafile/ts_t_exp_w_163.dbf 3600.001.0000.006000.00
TS_T_EXP_W_164+DATA_DG/dbquery/datafile/ts_t_exp_w_164.dbf 3600.001.0000.006000.00
TS_T_EXP_W_165+DATA_DG/dbquery/datafile/ts_t_exp_w_165.dbf 3600.001.0000.006000.00
TS_T_EXP_W_166+DATA_DG/dbquery/datafile/ts_t_exp_w_166.dbf 3600.001.0000.006000.00
TS_T_EXP_W_167+DATA_DG/dbquery/datafile/ts_t_exp_w_167.dbf 3600.001.0000.006000.00
TS_T_EXP_W_168+DATA_DG/dbquery/datafile/ts_t_exp_w_168.dbf 3000.001.0000.006000.00
TS_T_EXP_W_169+DATA_DG/dbquery/datafile/ts_t_exp_w_169.dbf 3000.001.0000.006000.00
TS_T_EXP_W_170+DATA_DG/dbquery/datafile/ts_t_exp_w_170.dbf 3000.001.0000.006000.00
TS_T_EXP_W_171+DATA_DG/dbquery/datafile/ts_t_exp_w_171.dbf 3000.001.0000.006000.00
TS_T_EXP_W_172+DATA_DG/dbquery/datafile/ts_t_exp_w_172.dbf 3000.001.0000.006000.00
TS_T_EXP_W_173+DATA_DG/dbquery/datafile/ts_t_exp_w_173.dbf 3000.001.0000.006000.00
TS_T_EXP_W_174+DATA_DG/dbquery/datafile/ts_t_exp_w_174.dbf 3000.001.0000.006000.00
TS_T_EXP_W_175+DATA_DG/dbquery/datafile/ts_t_exp_w_175.dbf 3000.001.0000.006000.00
TS_T_EXP_W_176+DATA_DG/dbquery/datafile/ts_t_exp_w_176.dbf 3000.001.0000.006000.00
TS_T_EXP_W_177+DATA_DG/dbquery/datafile/ts_t_exp_w_177.dbf 3000.001.0000.006000.00
TS_T_EXP_W_178+DATA_DG/dbquery/datafile/ts_t_exp_w_178.dbf 3000.001.0000.006000.00
TS_T_EXP_W_179+DATA_DG/dbquery/datafile/ts_t_exp_w_179.dbf 3000.001.0000.006000.00
TS_T_EXP_W_180+DATA_DG/dbquery/datafile/ts_t_exp_w_180.dbf 3600.001.0000.006000.00
TS_T_EXP_W_181+DATA_DG/dbquery/datafile/ts_t_exp_w_181.dbf 3600.001.0000.006000.00
TS_T_EXP_W_182+DATA_DG/dbquery/datafile/ts_t_exp_w_182.dbf 3600.001.0000.006000.00
TS_T_EXP_W_183+DATA_DG/dbquery/datafile/ts_t_exp_w_183.dbf 3600.001.0000.006000.00
TS_T_EXP_W_184+DATA_DG/dbquery/datafile/ts_t_exp_w_184.dbf 3600.001.0000.006000.00
TS_T_EXP_W_185+DATA_DG/dbquery/datafile/ts_t_exp_w_185.dbf 3600.001.0000.006000.00
TS_T_EXP_W_186+DATA_DG/dbquery/datafile/ts_t_exp_w_186.dbf 3600.001.0000.006000.00
TS_T_EXP_W_187+DATA_DG/dbquery/datafile/ts_t_exp_w_187.dbf 3600.001.0000.006000.00
TS_T_EXP_W_188+DATA_DG/dbquery/datafile/ts_t_exp_w_188.dbf 3600.001.0000.006000.00
TS_T_EXP_W_189+DATA_DG/dbquery/datafile/ts_t_exp_w_189.dbf 3600.001.0000.006000.00
TS_T_EXP_W_190+DATA_DG/dbquery/datafile/ts_t_exp_w_190.dbf 3600.001.0000.006000.00
TS_T_EXP_W_191+DATA_DG/dbquery/datafile/ts_t_exp_w_191.dbf 3000.001.0000.006000.00
TS_T_EXP_W_192+DATA_DG/dbquery/datafile/ts_t_exp_w_192.dbf 3000.001.0000.006000.00
TS_T_EXP_W_193+DATA_DG/dbquery/datafile/ts_t_exp_w_193.dbf 3000.001.0000.006000.00
TS_T_EXP_W_194+DATA_DG/dbquery/datafile/ts_t_exp_w_194.dbf 3000.001.0000.006000.00
TS_T_EXP_W_195+DATA_DG/dbquery/datafile/ts_t_exp_w_195.dbf 3000.001.0000.006000.00
TS_T_EXP_W_196+DATA_DG/dbquery/datafile/ts_t_exp_w_196.dbf 3000.001.0000.006000.00
TS_T_EXP_W_197+DATA_DG/dbquery/datafile/ts_t_exp_w_197.dbf 3100.001.0000.006000.00
TS_T_EXP_W_198+DATA_DG/dbquery/datafile/ts_t_exp_w_198.dbf 3000.001.0000.006000.00
TS_T_EXP_W_199+DATA_DG/dbquery/datafile/ts_t_exp_w_199.dbf 3000.001.0000.006000.00
TS_T_EXP_W_200+DATA_DG/dbquery/datafile/ts_t_exp_w_200.dbf 3000.001.0000.006000.00
TS_T_EXP_W_201+DATA_DG/dbquery/datafile/ts_t_exp_w_201.dbf 3000.001.0000.006000.00
TS_T_EXP_W_202+DATA_DG/dbquery/datafile/ts_t_exp_w_202.dbf 3000.001.0000.006000.00
TS_T_EXP_W_203+DATA_DG/dbquery/datafile/ts_t_exp_w_203.dbf 3600.001.0000.006000.00
TS_T_EXP_W_204+DATA_DG/dbquery/datafile/ts_t_exp_w_204.dbf 3600.001.0000.006000.00
TS_T_EXP_W_205+DATA_DG/dbquery/datafile/ts_t_exp_w_205.dbf 3600.001.0000.006000.00
TS_T_EXP_W_206+DATA_DG/dbquery/datafile/ts_t_exp_w_206.dbf 3600.001.0000.006000.00
TS_T_EXP_W_207+DATA_DG/dbquery/datafile/ts_t_exp_w_207.dbf 3600.001.0000.006000.00
TS_T_EXP_W_208+DATA_DG/dbquery/datafile/ts_t_exp_w_208.dbf 3900.511.0000.516000.00
TS_T_EXP_W_209+DATA_DG/dbquery/datafile/ts_t_exp_w_209.dbf 3600.001.0000.006000.00
TS_T_EXP_W_210+DATA_DG/dbquery/datafile/ts_t_exp_w_210.dbf 3600.001.0000.006000.00
TS_T_EXP_W_211+DATA_DG/dbquery/datafile/ts_t_exp_w_211.dbf 3600.001.0000.006000.00
TS_T_EXP_W_212+DATA_DG/dbquery/datafile/ts_t_exp_w_212.dbf 3600.001.0000.006000.00
TS_T_EXP_W_213+DATA_DG/dbquery/datafile/ts_t_exp_w_213.dbf 3600.001.0000.006000.00
TS_T_EXP_W_214+DATA_DG/dbquery/datafile/ts_t_exp_w_214.dbf 3000.001.0000.006000.00
TS_T_EXP_W_215+DATA_DG/dbquery/datafile/ts_t_exp_w_215.dbf 3000.001.0000.006000.00
TS_T_EXP_W_216+DATA_DG/dbquery/datafile/ts_t_exp_w_216.dbf 3000.001.0000.006000.00
TS_T_EXP_W_217+DATA_DG/dbquery/datafile/ts_t_exp_w_217.dbf 3000.001.0000.006000.00
TS_T_EXP_W_218+DATA_DG/dbquery/datafile/ts_t_exp_w_218.dbf 3000.001.0000.006000.00
TS_T_EXP_W_219+DATA_DG/dbquery/datafile/ts_t_exp_w_219.dbf 3000.001.0000.006000.00
TS_T_EXP_W_220+DATA_DG/dbquery/datafile/ts_t_exp_w_220.dbf 3000.001.0000.006000.00
TS_T_EXP_W_221+DATA_DG/dbquery/datafile/ts_t_exp_w_221.dbf 3000.001.0000.006000.00
TS_T_EXP_W_222+DATA_DG/dbquery/datafile/ts_t_exp_w_222.dbf 3000.001.0000.006000.00
TS_T_EXP_W_223+DATA_DG/dbquery/datafile/ts_t_exp_w_223.dbf 3000.001.0000.006000.00
TS_T_EXP_W_224+DATA_DG/dbquery/datafile/ts_t_exp_w_224.dbf 3000.001.0000.006000.00
TS_T_EXP_W_225+DATA_DG/dbquery/datafile/ts_t_exp_w_225.dbf 3000.001.0000.006000.00
TS_T_EXP_W_226+DATA_DG/dbquery/datafile/ts_t_exp_w_226.dbf 3600.001.0000.006000.00
TS_T_EXP_W_227+DATA_DG/dbquery/datafile/ts_t_exp_w_227.dbf 3600.001.0000.006000.00
TS_T_EXP_W_228+DATA_DG/dbquery/datafile/ts_t_exp_w_228.dbf 3600.001.0000.006000.00
TS_T_EXP_W_229+DATA_DG/dbquery/datafile/ts_t_exp_w_229.dbf 3600.001.0000.006000.00
TS_T_EXP_W_230+DATA_DG/dbquery/datafile/ts_t_exp_w_230.dbf 3600.001.0000.006000.00
TS_T_EXP_W_231+DATA_DG/dbquery/datafile/ts_t_exp_w_231.dbf 3600.001.0000.006000.00
TS_T_EXP_W_232+DATA_DG/dbquery/datafile/ts_t_exp_w_232.dbf 3600.001.0000.006000.00
TS_T_EXP_W_233+DATA_DG/dbquery/datafile/ts_t_exp_w_233.dbf 3600.001.0000.006000.00
TS_T_EXP_W_234+DATA_DG/dbquery/datafile/ts_t_exp_w_234.dbf 3600.001.0000.006000.00
TS_T_EXP_W_235+DATA_DG/dbquery/datafile/ts_t_exp_w_235.dbf 3600.001.0000.006000.00
TS_T_EXP_W_236+DATA_DG/dbquery/datafile/ts_t_exp_w_236.dbf 3600.001.0000.006000.00
TS_T_EXP_W_237+DATA_DG/dbquery/datafile/ts_t_exp_w_237.dbf 3000.001.0000.006000.00
TS_T_EXP_W_238+DATA_DG/dbquery/datafile/ts_t_exp_w_238.dbf 3000.001.0000.006000.00
TS_T_EXP_W_239+DATA_DG/dbquery/datafile/ts_t_exp_w_239.dbf 3000.001.0000.006000.00
TS_T_EXP_W_240+DATA_DG/dbquery/datafile/ts_t_exp_w_240.dbf 3000.001.0000.006000.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_01.dbf 15204.931.0004.9325,231720.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_02.dbf 19006.001.0006.0027,994800.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_03.dbf 16105.161.0005.1625,353700.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_04.dbf 12204.841.0004.7522,226600.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_05.dbf 13605.221.0005.2222,732600.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_06.dbf 10404.901.0004.9017,806500.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_07.dbf 14105.671.0005.6717,268500.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_08.dbf 11205.451.0005.4516,693500.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_09.dbf 13206.061.0005.9818,791500.00
TS_YTEXP+DATA_DG/dbquery/datafile/ts_ytexp_10.dbf 18605.651.0005.6524,418700.00
TS_YTMDM+DATA_DG/dbquery/datafile/ts_ytmdb.dbf 3900.001.0000.007000.00
TS_YTMDM+DATA_DG/dbquery/datafile/ts_ytmdb1.dbf 3900.001.0000.007000.00
UNDOTBS1+DATA_DG/dbquery/datafile/undotbs1.263.828812057 600.001.0000.0017,75351830.11
USERS+DATA_DG/dbquery/datafile/users.265.828812065 600.001.0000.006000.00


Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D18,607,71510025,030,65880,4251,726,0010016,888


Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00001,725,9680


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
B056126223319037154656241472001546562   
E02922367147572178100741472001781007   


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.05462,1551760432.00
D29,6960.203,6581.47331,0031405571.00
D44,5440.295,4881.30293,3901303799.00
D59,3920.397,3171.22276,4811258049.00
D74,2400.499,1461.17264,7071226190.00
D89,0880.5910,9751.13255,2421200581.00
D103,9360.6812,8051.10247,5571179789.00
D118,7840.7814,6341.06238,4411155123.00
D133,6320.8816,4631.03231,5491136475.00
D148,4800.9818,2921.01227,0761124372.00
D152,0641.0018,7341.00225,9121121221.00
D163,3281.0720,1220.98222,1941111162.00
D178,1761.1721,9510.97219,2151103102.00
D193,0241.2723,7800.96216,324195279.00
D207,8721.3725,6090.94213,456187520.00
D222,7201.4627,4380.93211,060181037.00
D237,5681.5629,2680.93209,382176498.00
D252,4161.6631,0970.92207,876172421.00
D267,2641.7632,9260.92206,915169821.00
D282,1121.8634,7550.91206,103167626.00
D296,9601.9536,5850.91204,869164287.00


Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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


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,4742,545.950.000.000.000.001,048,576
E61,44054,1691,574.740.000.000.000.001,048,576


Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K6,0096,00900
64K128K363600
128K256K2200
256K512K2200
512K1024K606000
1M2M37137100
2M4M191900
4M8M101000
8M16M1100


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,288,790.525,742.27100.00035,174,844
15,3600.251,288,790.525,742.27100.00035,174,844
30,7200.501,288,790.525,742.27100.00035,174,844
46,0800.751,288,790.525,742.27100.00035,174,844
61,4401.001,288,790.525,742.27100.00035,174,844
73,7281.201,288,790.522,351.22100.00035,082,703
86,0161.401,288,790.522,351.22100.00035,082,703
98,3041.601,288,790.522,351.22100.00035,082,703
110,5921.801,288,790.522,351.22100.00035,082,703
122,8802.001,288,790.522,351.22100.00035,082,703
184,3203.001,288,790.522,351.22100.00035,082,703
245,7604.001,288,790.522,351.22100.00035,082,703
368,6406.001,288,790.522,351.22100.00035,082,703
491,5208.001,288,790.522,351.22100.00035,082,703


Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
6,6560.7655318,4992,851,9431.0022,3521.11460,843
7,1680.821,06230,3312,852,5661.0021,7291.08461,011
7,6800.881,57447,3222,853,0991.0021,1961.05461,668
8,1920.942,08564,0732,853,9421.0020,3531.01461,922
8,7041.002,59780,8492,854,0961.0020,1991.00461,963
9,2161.063,10997,1672,854,1921.0020,1031.00461,988
9,7281.123,621113,0452,854,2571.0020,0380.99462,004
10,2401.184,133127,6922,854,3121.0019,9830.99462,018
10,7521.244,645138,9232,854,3481.0019,9470.99462,028
11,2641.295,157149,5682,854,3781.0019,9170.99462,034
11,7761.355,669160,6382,854,3941.0019,9010.99462,037
12,2881.416,181175,9042,854,4071.0019,8880.98462,040
12,8001.476,693186,5772,854,4221.0019,8730.98462,044
13,3121.537,205199,8042,854,4441.0019,8510.98462,047
13,8241.597,717213,0312,854,4661.0019,8290.98462,051
14,8481.718,741243,4492,854,5391.0019,7560.98462,060
15,8721.829,765276,2872,854,5961.0019,6990.98462,069
16,8961.9410,789310,6562,854,6531.0019,6420.97462,076
17,9202.0611,813345,0252,854,7041.0019,5910.97462,082


Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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


Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block16,694131
undo header17500
undo block1000
1st level bmb500
segment header400


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) 2,7572,75702,70510137.23
TX-Transaction (allocate ITL entry) 1183451,247.50
TX-Transaction (index contention) 2,6592,65901401.43
CF-Controlfile Transaction 2,0112,0110303.33
HW-Segment High Water Mark 5,4615,4610300.00
TX-Transaction 419,112419,1060100.00
FB-Format Block 3,0373,0370100.00
CI-Cross-Instance Call Invocation 22220100.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
2246.89417,5887481615.4/25.50/00/0/0/0/0/0


Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
19-Feb 08:5931,63830,2621445150/00/0/0/0/0/0
19-Feb 08:4936,59836,1917477250/00/0/0/0/0/0
19-Feb 08:3962,162114,81114516150/00/0/0/0/0/0
19-Feb 08:2944,03994,88474811250/00/0/0/0/0/0
19-Feb 08:1943,16184,4491469150/00/0/0/0/0/0
19-Feb 08:0929,29556,9917479250/00/0/0/0/0/0


Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch560.00 00 
AQ dequeue txn counter latch100.00 00 
AQ disk delete txn counter latch100.00 00 
ASM Keyed state latch4,0160.00 00 
ASM allocation8260.120.0000 
ASM db client latch3,2100.00 00 
ASM map headers4350.00 00 
ASM map load waiting list1050.00 00 
ASM map operation freelist6170.160.0000 
ASM map operation hash table3,661,1420.000.0000 
ASM network background latch2,4280.040.0000 
ASM network state latch9130.110.0000 
AWR Alerted Metric Element list84,7790.00 00 
Change Notification Hash table latch1,2010.00 00 
Consistent RBA393,2800.010.0000 
DML lock allocation2,012,7980.000.0000 
Event Group Locks3,7170.00 00 
FAL Queue1590.00 00 
FIB s.o chain latch780.00 00 
FOB s.o list latch14,0690.310.0000 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch4,581,7250.010.720497,7720.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 latch2530.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KFK SGA Libload latch1,0880.00 00 
KFMD SGA50.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list10.00 00 
KJCT flow control latch10.00 00 
KMG MMAN ready and startup request latch1,2000.00 00 
KTF sga latch230.00 01,1930.00
KWQMN job cache list latch260.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch190.00 00 
KWQS pqueue ctx latch1100.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch2,5560.00 00 
MQL Tracking Latch0  0710.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 process9,1060.00 00 
OS process allocation11,7460.020.0000 
OS process: request allocation4,0160.00 00 
PL/SQL warning settings2,4020.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch80,7000.00 00 
Reserved Space Latch280.00 00 
Result Cache: RC Latch248,7650.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,1980.00
SQL memory manager workarea list latch102,9020.00 00 
Shared B-Tree4300.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,164,1150.670.0200 
active service list13,7520.090.0005,8700.00
alert log latch140.00 00 
archive control3290.00 00 
archive process latch4850.411.0000 
begin backup scn array20.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles29,5100.010.0000 
cache buffers chains84,547,3630.010.680380,6340.00
cache buffers lru chain1,788,0930.000.0602,279,9280.00
cache table scan latch3620.00 03620.00
call allocation10,0441.600.5200 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch4,0330.00 00 
channel operations parent latch39,3620.00 00 
checkpoint queue latch31,266,2520.000.0201,615,4240.00
client/application info2,9540.00 00 
compile environment latch1,8920.00 00 
corrupted undo seg latch1,704,8130.010.0000 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch570.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch570.00 00 
dml lock allocation4530.00 00 
done queue latch10.00 00 
dummy allocation4,1530.00 00 
eighth spare latch - X parent10.00 00 
eleventh spare latch - children10.00 00 
enqueue freelist latch10.00 0516,4140.00
enqueue hash chains3,375,6350.010.030360.00
fifteenth spare latch - children10.00 00 
file cache latch9,7010.00 00 
first Audit Vault latch660.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 SGA660.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch4520.00 02,9340.00
hash table modification latch3970.00 00 
heartbeat check10.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch690.00 0680.00
job_queue_processes free list latch1400.00 00 
job_queue_processes parameter latch8510.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch70.00 00 
kcfis latch20.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch40.00 00 
krbmrosl400.00 00 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock310.00 00 
ksuosstats global area3630.00 00 
ksv allocation latch1170.00 00 
ksv class latch3,7120.160.0000 
ksv instance latch280.00 00 
ksv msg queue latch520.00 0510.00
ksz_so allocation latch4,0160.100.0000 
ktm global data2,9330.00 00 
kwqbsn:qsga1410.00 00 
lgwr LWN SCN394,7640.040.0000 
list of block allocation148,3020.010.0000 
loader state object freelist1,8720.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch130.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation20.00 00 
logminer local10.00 00 
logminer work area10.00 00 
longop free list parent10.00 00 
managed standby latch1520.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch2,4220.00 00 
messages3,567,5760.280.0100 
mostly latch-free SCN399,2720.920.0000 
msg queue latch10.00 00 
multiblock read objects1,4400.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch570.00 00 
nineth spare latch - X parent10.00 00 
object queue header heap59,3290.00 08,3730.00
object queue header operation5,610,4970.020.1000 
object stats modification48,9800.010.0000 
parallel query alloc buffer2,4010.00 00 
parallel query stats10.00 00 
parameter list6,0460.00 00 
parameter table management4,9340.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue10,4721.490.01017,3141.83
process allocation4,1570.050.5001,8240.00
process group creation4,0160.120.0000 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch5290.00 00 
query server freelists10.00 00 
queued dump request120.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation3,403,3000.170.0205,775,9870.37
redo copy10.00 05,783,8040.18
redo writing2,375,5170.260.0100 
reservation so alloc latch140.00 00 
resmgr group change latch2160.00 00 
resmgr:active threads4,1530.00 00 
resmgr:actses change group1580.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list4,1520.050.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 objects2,498,4360.070.0006090.00
rules engine rule set statistics1000.00 00 
second Audit Vault latch10.00 00 
segmented array pool680.00 00 
sequence cache5,3400.00 00 
session allocation870,2100.000.000865,7190.00
session idle bit6,926,8420.000.0000 
session queue latch10.00 00 
session state list latch7320.00 00 
session switching2,2500.040.0000 
session timer1,1990.00 00 
seventh spare latch - X parent10.00 00 
shared pool499,9540.130.0201260.00
shared pool sim alloc130.00 00 
shared pool simulator4,3180.00 00 
sim partition latch10.00 00 
simulator hash latch1,951,6650.000.0000 
simulator lru latch332,5430.000.0001,544,4320.06
sixth spare latch - X parent10.00 00 
sort extent pool8160.00 00 
space background task latch30,68212.840.1003,0380.10
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation50.00 00 
temporary table state object allocation10.00 00 
tenth spare latch - X parent10.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
thirteenth spare latch - children10.00 00 
threshold alerts latch4,1760.00 00 
transaction allocation9,3320.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 data2,804,4080.000.0000 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 
write info latch0  0393,1660.00


Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
messages3,567,5769,846699,779
active checkpoint queue latch1,164,1157,8291187,712
redo writing2,375,5176,273766,197
redo allocation3,403,3005,6421075,535
cache buffers chains84,547,3635,4963,7351,997
space background task latch30,6823,9404113,529
mostly latch-free SCN399,2723,673123,662
row cache objects2,498,4361,79751,792
object queue header operation5,610,4971,2001171,086
shared pool499,95465311642
checkpoint queue latch31,266,25249910489
In memory undo latch4,581,725403289129
enqueue hash chains3,375,63537210362
call allocation10,0441618389
post/wait queue10,4721562154
cache buffers lru chain1,788,09366462
archive process latch485220
process allocation4,157211


Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latchktiFlush: child022067
In memory undo latchkticmt: child05631
In memory undo latchktiFlushMe01840
In memory undo latchktichg: child04147
PC and Classifier lists for WLMNo latch040
active checkpoint queue latchkcbbacq: scan active checkpoints0118118
archive process latchkcrrsarc020
cache buffers chainskcbgtcr_202,851718
cache buffers chainskcbgtcr: fast path (cr pin)08792,954
cache buffers chainskcbgtcr: fast path0340
cache buffers chainskcbgcur_20238
cache buffers chainskcbgtcr: kslbegin excl01459
cache buffers chainskcbget: fast exchange083
cache buffers chainskcbchg1: mod cr pin058
cache buffers chainskcbget: pin buffer040
cache buffers chainskcbzwb030
cache buffers chainskcbgcur_4023
cache buffers chainskcb_post_apply: kcbhq62011
cache buffers chainskcbnlc010
cache buffers lru chainkcbzgws030
cache buffers lru chainkcbo_link_q010
call allocationksuxds06645
call allocationksudlp: top call01737
checkpoint queue latchkcbklbc_cql050
checkpoint queue latchkcbkubc_4050
enqueue hash chainsksqrcl075
enqueue hash chainsksqgtl3035
lgwr LWN SCNkcs0230100
messagesksarcv04016
messagesksaamb: after wakeup02550
messagesksarcv: after wait043
mostly latch-free SCNkcslcu30212
object queue header operationkcbo_switch_cq07733
object queue header operationkcbo_switch_q_bg03137
object queue header operationkcbo_link_q0167
object queue header operationkcbo_switch_mq_bg0445
post/wait queueksliwat:remove022
process allocationksucrp:1010
redo allocationkcrfw_redo_gen: redo allocation 10970
redo allocationkcrfw_redo_write: before write0530
redo allocationkcrfw_post: more space0328
redo allocationkcrfw_redo_gen: redo allocation 30249
redo writingkcrfwcr06365
redo writingkcrfw_post: rba scn pair080
redo writingkcrfw_cal_target_rba041
redo writingkcrfw_post: after write0110
row cache objectskqrpre: find obj035
row cache objectskqreqd: reget010
row cache objectskqrpup010
shared poolkghalo083
shared poolkghfre035
space background task latchktsj_grab_task0406411
space background task latchktsjCreateTask010


Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Cursor Pinkkslce [KKSCHLPIN2]890
Library Cachekglhdgn1 62540
Library Cachekgllkdl1 85450
Library Cachekglhdgn2 106320
Library Cachekgllkc1 57260
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]110
Library CachekglUpgradeLock 11940
Library Cachekglpnal1 9020
Library Cachekglpndl1 9520
Cursor PinkksLockDelete [KKSCHLPIN6]20
Cursor ParentkkscsPruneChild [KKSPRTLOC35]20
Cursor Pinkksfbc [KKSCHLFSP2]20


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_18TABLE PARTITION634,0802.53
YTEXPTS_IDX_YTEXPUK_EXP_DELIVERY_STATUS_165 INDEX621,9682.48
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_13TABLE PARTITION364,5121.46
SYSSYSTEMI_CDEF4 INDEX313,1361.25
SYSSYSTEMI_CON2 INDEX312,8961.25


Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_18TABLE PARTITION8710.94
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_13TABLE PARTITION5000.54
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_03 INDEX1160.12
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_05 INDEX1060.11
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_02 INDEX1020.11


Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_18TABLE PARTITION8710.96
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_13TABLE PARTITION5000.55
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_03 INDEX1160.13
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_05 INDEX1060.12
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_02 INDEX1020.11


Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_18TABLE PARTITION8710.96
YTEXPTS_CONTAINER_02T_EXP_OP_RECORD_CONTAINER_165PAR_2014_02_13TABLE PARTITION5000.55
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_03 INDEX1160.13
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_05 INDEX1060.12
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_02 INDEX1020.11


Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
YTEXPTS_IDX_YTEXPPK_EXP_DELIVERY_STATUS_165 INDEX54,2783.14
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_165 TABLE33,3331.93
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_03 INDEX26,8361.55
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_05 INDEX26,7991.55
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_02 INDEX25,4281.47


Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
YTEXPTS_IDX_YTEXPPK_EXP_DELIVERY_STATUS_165 INDEX39,8613.45
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_03 INDEX21,3871.85
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_02 INDEX21,1801.83
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_05 INDEX19,6841.70
YTEXPTS_YTEXPT_EXP_DELIVERY_STATUS_165 TABLE19,5701.69


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_YTEXPT_EXP_DELIVERY_STATUS_165 TABLE44,5925.38
YTEXPTS_IDX_YTEXPIDX_EXP_DELIVERY_STATUS_165_05 INDEX37,1684.48
YTEXPTS_IDX_CONTAINERPK_EXP_CONTAINER_165PAR_2014_02_19INDEX PARTITION36,4324.39
** MISSING **TEMP** TRANSIENT: 8307200** MISSING **UNDEFINED34,1284.11
YTEXPTS_IDX_T_EXP_CONTAINER_165IDX2_EXP_CONTAINER_165PAR_2014_02_19INDEX PARTITION32,6083.93


Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
YTEXPTS_IDX_HANDONPK_EXP_HANDON_206PAR_2014_02_19INDEX PARTITION1356.69
YTEXPTS_IDX_HANDONPK_EXP_HANDON_231PAR_2014_02_19INDEX PARTITION1095.40
YTEXPTS_IDX_HANDONPK_EXP_HANDON_220PAR_2014_02_19INDEX PARTITION1004.96
YTEXPTS_IDX_HANDONPK_EXP_HANDON_175PAR_2014_02_19INDEX PARTITION904.46
YTEXPTS_IDX_HANDONPK_EXP_HANDON_240PAR_2014_02_19INDEX PARTITION904.46


Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
YTEXPTS_IDX_CONTAINERIDX1_EXP_CONTAINER_165PAR_2014_02_19INDEX PARTITION1100.00


Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYSSYSTEMAUD$ TABLE23277.85
YTEXPTS_SIGNATURE_02T_EXP_OP_RECORD_SIGNATURE_164PAR_2014_02_18TABLE PARTITION134.36
YTEXPTS_SIGNATURE_02T_EXP_OP_RECORD_SIGNATURE_238PAR_2014_02_18TABLE PARTITION113.69
YTEXPTS_SIGNATURE_02T_EXP_OP_RECORD_SIGNATURE_197PAR_2014_02_18TABLE PARTITION82.68
YTEXPTS_SIGNATURE_02T_EXP_OP_RECORD_SIGNATURE_229PAR_2014_02_18TABLE PARTITION82.68


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_oids1910.000 042
dc_histogram_data3,4568.830 034,474
dc_histogram_defs7,2957.900 044,773
dc_object_grants180.000 017
dc_objects120,8930.090 573,238
dc_profiles2020.000 01
dc_rollback_segments3,8630.000 067
dc_segments29,81752.560 1,725118,546
dc_sequences30.000 36
dc_tablespaces531,4640.000 0344
dc_users128,8760.000 01,962
global database name2,5590.000 01
outstanding_alerts2,0480.000 0342
sch_lj_oids40.000 012



Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS1980.000 00
BODY1,1440.001,9980.0000
DBLINK1,8250.000 00
EDITION1570.002910.0000
INDEX589,785-0.002,6924.75980
QUEUE1040.009920.0000
SCHEMA1,7460.000 00
SQL AREA340,1080.022,134,6520.151,4540
SQL AREA BUILD1,67617.360 00
SQL AREA STATS1,56279.261,56279.2600
SUBSCRIPTION80.0080.0000
TABLE/PROCEDURE302,898-0.00113,0440.141410
TRIGGER1880.002420.0000



Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

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


Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther2,296.31 2.763.294444831831
Freeable232.380.000.660.948 350350
SQL14.861.760.020.01027802794
PL/SQL2.891.060.000.0200829829
EOther1,410.56 3.054.314444463463
Freeable153.810.000.831.258 185185
SQL8.781.030.020.01013434426
PL/SQL1.850.980.000.0200461461


Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory3,584.003,584.000.00
largefree memory3,583.633,583.630.00
sharedASH buffers160.00160.000.00
sharedCheckpoint queue390.66390.660.00
sharedFileOpenBlock486.40486.400.00
sharedKGLH01,094.551,107.601.19
sharedKGLHD127.22126.54-0.53
sharedPRTMV92.8194.882.23
sharedSQLA3,035.573,005.93-0.98
shareddb_block_hash_buckets1,424.001,424.000.00
sharedfree memory411.85442.927.54
sharedobject queue461.54461.540.00
streamsfree memory511.37511.370.00
 buffer_cache151,040.00151,040.000.00
 fixed_sga2.162.160.00
 log_buffer107.54107.540.00


Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonCPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0203 15:50:190.660.020.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) 500.000.000.030.000.000.00
SYSMAN.MGMT_TASK_Q(77312) 64640.000.000.010.050.000.00


Back to Streams Statistics
Back to Top

Persistent Queues Rate

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


Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

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


Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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


Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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


Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
3,6010.00100.000.000.00


Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

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


Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

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


Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

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


Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report