WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
DFACSCF1001502775DFACSCF2210.2.0.5.0YESDFAC-550D

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2212913-6ÔÂ -13 08:00:5053 18.5
End Snap:2213113-6ÔÂ -13 09:18:4353 21.4
Elapsed:  77.87 (mins)  
DB Time:  95.81 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 7,008M 7,008MStd Block Size: 8K
Shared Pool Size: 1,104M 1,104MLog Buffer: 14,316K

Load Profile

Per SecondPer Transaction
Redo size: 7,911.69 14,990.68
Logical reads: 69,056.13 130,844.11
Block changes: 74.28 140.74
Physical reads: 270.44 512.42
Physical writes: 2.86 5.41
User calls: 16.81 31.84
Parses: 6.24 11.82
Hard parses: 0.17 0.32
Sorts: 11.01 20.85
Logons: 0.04 0.08
Executes: 117.48 222.60
Transactions: 0.53 

% Blocks changed per Read: 0.11Recursive Call %: 90.30
Rollback per transaction %: 3.53Rows per Sort: 661.43

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.61In-memory Sort %: 100.00
Library Hit %: 99.48Soft Parse %: 97.27
Execute to Parse %: 94.69Latch Hit %: 99.84
Parse CPU to Parse Elapsd %: 20.32% Non-Parse CPU: 99.98

Shared Pool Statistics

BeginEnd
Memory Usage %: 67.30 71.29
% SQL with executions>1: 95.12 94.16
% Memory for SQL w/exec>1: 89.44 87.22

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  5,420  94.3 
gc cr multi block request 141,669 104 1 1.8Cluster
gc current block 2-way 58,448 63 1 1.1Cluster
db file scattered read 10,092 36 4 .6User I/O
db file sequential read 4,126 15 4 .3User I/O

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 44.65 84.61
Global Cache blocks served: 9.21 17.45
GCS/GES messages received: 21.72 41.16
GCS/GES messages sent: 72.61 137.57
DBWR Fusion writes: 0.32 0.61
Estd Interconnect traffic (KB) 449.32 

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: 99.54
Buffer access - remote cache %: 0.06
Buffer access - disk %: 0.39

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1
Avg global cache cr block receive time (ms): 1.7
Avg global cache current block receive time (ms): 4.5
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 0.4
Avg global cache cr block flush time (ms): 1.9
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.1
Avg global cache current block flush time (ms): 1.8

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.3
Avg message sent queue time on ksxp (ms): 0.5
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 43.62
% of indirect sent messages: 53.28
% of flow controlled messages: 3.10


Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 5,716.48 99.44
DB CPU 5,420.14 94.28
PL/SQL execution elapsed time 16.83 0.29
parse time elapsed 15.70 0.27
hard parse elapsed time 12.80 0.22
hard parse (sharing criteria) elapsed time 2.18 0.04
hard parse (bind mismatch) elapsed time 1.89 0.03
PL/SQL compilation elapsed time 1.16 0.02
sequence load elapsed time 0.71 0.01
repeated bind elapsed time 0.25 0.00
connection management call elapsed time 0.02 0.00
failed parse elapsed time 0.01 0.00
DB time 5,748.84  
background elapsed time 53.80  
background cpu time 38.88  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
CPU time     5,420   94.28
Cluster 216,738 0 181 1 3.15
User I/O 14,564   52 4 0.90
System I/O 24,771   11 0 0.20
Application 402 1 4 9 0.06
Concurrency 3,501 1 3 1 0.05
Other 61,333 92 2 0 0.04
Commit 1,618   2 1 0.04
Network 68,268   0 0 0.01
Configuration 18   0 0 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
gc cr multi block request 141,669   104 1 57.45
gc current block 2-way 58,448 0 63 1 23.70
db file scattered read 10,092   36 4 4.09
db file sequential read 4,126   15 4 1.67
gc cr block 2-way 9,552   11 1 3.87
control file parallel write 1,727   5 3 0.70
enq: TX - row lock contention 7 86 3 484 0.00
log file parallel write 3,591   3 1 1.46
control file sequential read 19,453   3 0 7.89
log file sync 1,618   2 1 0.66
gc current grant busy 4,682   2 0 1.90
os thread startup 41   1 32 0.02
reliable message 363   1 3 0.15
row cache lock 1,971   1 0 0.80
db file parallel read 75   1 8 0.03
cursor: pin S wait on X 42 100 0 10 0.02
gc cr grant 2-way 1,398   0 0 0.57
CGS wait for IPC msg 46,098 100 0 0 18.69
library cache lock 735   0 0 0.30
gc current grant 2-way 724   0 0 0.29
SQL*Net message from dblink 13   0 16 0.01
gcs log flush sync 239   0 1 0.10
gc cr block busy 76   0 2 0.03
gc current block busy 27   0 6 0.01
enq: TM - contention 380   0 0 0.15
DFS lock handle 345   0 0 0.14
enq: PS - contention 203   0 1 0.08
CSS initialization 12   0 9 0.00
PX Deq Credit: send blkd 272 68 0 0 0.11
library cache pin 281   0 0 0.11
latch free 2   0 37 0.00
PX Deq: reap credit 4,760 97 0 0 1.93
rdbms ipc reply 306   0 0 0.12
ksxr poll remote instances 8,230 68 0 0 3.34
PX Deq: Signal ACK 253 34 0 0 0.10
SQL*Net message to client 66,147   0 0 26.82
direct path read temp 96   0 0 0.04
direct path sync 29   0 1 0.01
direct path write 32   0 1 0.01
gc buffer busy 39   0 1 0.02
IPC send completion sync 43 100 0 1 0.02
SQL*Net more data from client 696   0 0 0.28
direct path write temp 102   0 0 0.04
SQL*Net more data to client 1,400   0 0 0.57
latch: cache buffers chains 428   0 0 0.17
enq: TT - contention 65   0 0 0.03
CSS operation: query 6   0 3 0.00
direct path read 12   0 1 0.00
gc current multi block request 114 1 0 0 0.05
gc current block congested 1   0 11 0.00
gc current block unknown 8   0 1 0.00
enq: WF - contention 21   0 0 0.01
enq: CF - contention 14   0 1 0.01
enq: FB - contention 16   0 0 0.01
enq: HW - contention 18   0 0 0.01
SQL*Net break/reset to client 10   0 1 0.00
CSS operation: action 25   0 0 0.01
enq: TA - contention 16   0 0 0.01
enq: TO - contention 4   0 0 0.00
library cache load lock 1   0 1 0.00
enq: PW - flush prewarm buffers 3   0 0 0.00
enq: JS - job run lock - synchronize 2   0 0 0.00
LGWR wait for redo copy 23   0 0 0.01
enq: IR - contention 2   0 0 0.00
enq: JQ - contention 2   0 0 0.00
enq: FU - contention 1   0 1 0.00
enq: UL - contention 2   0 0 0.00
enq: AF - task serialization 1   0 0 0.00
enq: US - contention 1   0 0 0.00
CSS group membership query 2   0 0 0.00
latch: ges resource hash list 2   0 0 0.00
buffer busy waits 2   0 0 0.00
latch: KCL gc element parent latch 2   0 0 0.00
latch: gcs resource hash 2   0 0 0.00
SQL*Net message to dblink 12   0 0 0.00
SQL*Net message from client 66,154   110,144 1665 26.83
gcs remote message 362,905 81 9,119 25 147.16
virtual circuit status 156 100 4,564 29255 0.06
Streams AQ: qmn slave idle wait 180 8 4,563 25348 0.07
Streams AQ: qmn coordinator idle wait 344 51 4,563 13264 0.14
DIAG idle wait 23,360   4,562 195 9.47
ges remote message 65,397 88 4,562 70 26.52
PX Idle Wait 1,927 93 4,557 2365 0.78
Streams AQ: waiting for time management or cleanup tasks 16 100 4,532 283244 0.01
jobq slave wait 758 97 2,191 2891 0.31
PX Deq: Execution Msg 447 8 4 9 0.18
PX Deq: Join ACK 258 35 0 1 0.10
PX Deq: Parse Reply 273 33 0 1 0.11
PX Deq: Msg Fragment 202 8 0 1 0.08
i/o slave wait 65   0 1 0.03
single-task message 1   0 63 0.00
PX Deq: Execute Reply 274 34 0 0 0.11
class slave wait 12   0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 344 99 0 0 0.14

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write 1,727   5 3 0.70
log file parallel write 3,590   3 1 1.46
control file sequential read 10,530   3 0 4.27
os thread startup 41   1 32 0.02
events in waitclass Other 55,084 94 1 0 22.34
gc current block 2-way 139   0 1 0.06
enq: TM - contention 370   0 0 0.15
gc cr block 2-way 109   0 1 0.04
gc current grant busy 24   0 1 0.01
direct path write 1   0 4 0.00
gc current block busy 1   0 4 0.00
library cache lock 10   0 0 0.00
db file sequential read 4   0 1 0.00
row cache lock 3   0 1 0.00
direct path sync 1   0 2 0.00
enq: PW - flush prewarm buffers 1   0 1 0.00
gc current grant 2-way 2   0 0 0.00
latch: cache buffers chains 4   0 0 0.00
buffer busy waits 2   0 0 0.00
rdbms ipc message 85,508 74 50,185 587 34.67
gcs remote message 362,896 81 9,119 25 147.16
smon timer 19 84 4,621 243187 0.01
Streams AQ: qmn slave idle wait 180 8 4,563 25348 0.07
Streams AQ: qmn coordinator idle wait 344 51 4,563 13264 0.14
DIAG idle wait 23,361   4,563 195 9.47
ges remote message 65,395 88 4,562 70 26.52
pmon timer 1,586 100 4,560 2875 0.64
Streams AQ: waiting for time management or cleanup tasks 16 100 4,532 283244 0.01
Streams AQ: RAC qmn coordinator idle wait 344 99 0 0 0.14
class slave wait 1   0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 75,289
AVG_IDLE_TIME 392,652
AVG_IOWAIT_TIME 565
AVG_SYS_TIME 4,824
AVG_USER_TIME 70,320
BUSY_TIME 603,412
IDLE_TIME 3,142,335
IOWAIT_TIME 5,620
SYS_TIME 39,713
USER_TIME 563,699
LOAD 2
OS_CPU_WAIT_TIME 688,800
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 371,318,784
VM_OUT_BYTES 1,251,835,904
PHYSICAL_MEMORY_BYTES 16,106,127,360
NUM_CPUS 8
NUM_CPU_CORES 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
DFACSCF 5,577.40 5,306.50 29,266 320,526,099
SYS$USERS 171.30 113.50 1,234,208 2,060,110
SYS$BACKGROUND 0.10 0.10 140 67,056
DFACSCFXDB 0.00 0.00 0 0

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
DFACSCF 4222 17 2094 1 0 0 66987 0
SYS$USERS 10052 34 1113 0 0 0 1254 0
SYS$BACKGROUND 290 1 294 2 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
3,144 3,150 5 628.82 54.69 7t3bfw6kvdunq JDBC Thin Client SELECT a.sessionid, decode(a.s...
1,144 1,122 144 7.94 19.89 b6cmfd9gfjmqd JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
211 198 140 1.51 3.67 2baqvamkstzv2 JDBC Thin Client begin pw_add_yjzsscpz(:1, :2, ...
115 112 789 0.15 2.00 7f039z54cu4rx JDBC Thin Client SELECT * FROM TW_WLYDPZMX T WH...
82 66 4 20.45 1.42 61y0t64h2d92j JDBC Thin Client BEGIN SAP2SCF_TOTABLE.Sap03(:1...
78 75 80 0.97 1.35 393drhftjj4dt JDBC Thin Client BEGIN Pw_Add_Impmmdsap(:1, :2,...
77 75 71 1.09 1.34 dn8fxy9kcv288 JDBC Thin Client SELECT COUNT(1) FROM TW_PZDYGX...
77 49 2 38.45 1.34 98jypbmtc6sgc   DECLARE job BINARY_INTEGER := ...
76 75 81 0.94 1.32 a08ad1gmt11q9 JDBC Thin Client SELECT * FROM TW_WLYDPZMX WHER...
74 53 512 0.14 1.28 4tanzh2jp8tsn JDBC Thin Client select BO from SYSTASKBO where...
66 54 122 0.54 1.15 9qfvjprb5psvp JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
59 32 2 29.38 1.02 85np1pfuxhgy6   UPDATE TWLXQZKQD_HIS SET XQLX=...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total% Total DB Time SQL IdSQL ModuleSQL Text
3,150 3,144 5 629.97 58.11 54.69 7t3bfw6kvdunq JDBC Thin Client SELECT a.sessionid, decode(a.s...
1,122 1,144 144 7.79 20.70 19.89 b6cmfd9gfjmqd JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
198 211 140 1.42 3.66 3.67 2baqvamkstzv2 JDBC Thin Client begin pw_add_yjzsscpz(:1, :2, ...
112 115 789 0.14 2.07 2.00 7f039z54cu4rx JDBC Thin Client SELECT * FROM TW_WLYDPZMX T WH...
75 78 80 0.94 1.39 1.35 393drhftjj4dt JDBC Thin Client BEGIN Pw_Add_Impmmdsap(:1, :2,...
75 77 71 1.05 1.38 1.34 dn8fxy9kcv288 JDBC Thin Client SELECT COUNT(1) FROM TW_PZDYGX...
75 76 81 0.92 1.37 1.32 a08ad1gmt11q9 JDBC Thin Client SELECT * FROM TW_WLYDPZMX WHER...
66 82 4 16.43 1.21 1.42 61y0t64h2d92j JDBC Thin Client BEGIN SAP2SCF_TOTABLE.Sap03(:1...
54 66 122 0.44 0.99 1.15 9qfvjprb5psvp JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
53 74 512 0.10 0.98 1.28 4tanzh2jp8tsn JDBC Thin Client select BO from SYSTASKBO where...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
187,513,126 144 1,302,174.49 58.11 1121.71 1143.66 b6cmfd9gfjmqd JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
29,354,279 80 366,928.49 9.10 75.08 77.67 393drhftjj4dt JDBC Thin Client BEGIN Pw_Add_Impmmdsap(:1, :2,...
29,343,569 71 413,289.70 9.09 74.89 77.28 dn8fxy9kcv288 JDBC Thin Client SELECT COUNT(1) FROM TW_PZDYGX...
28,883,652 5 5,776,730.40 8.95 3149.87 3144.09 7t3bfw6kvdunq JDBC Thin Client SELECT a.sessionid, decode(a.s...
13,998,080 512 27,340.00 4.34 53.04 73.82 4tanzh2jp8tsn JDBC Thin Client select BO from SYSTASKBO where...
6,559,640 4 1,639,910.00 2.03 65.72 81.78 61y0t64h2d92j JDBC Thin Client BEGIN SAP2SCF_TOTABLE.Sap03(:1...
6,067,701 140 43,340.72 1.88 198.40 210.96 2baqvamkstzv2 JDBC Thin Client begin pw_add_yjzsscpz(:1, :2, ...
3,960,293 30 132,009.77 1.23 12.82 15.60 ayv0vhg5vbcg1 JDBC Thin Client SELECT SQ.*, (SELECT ZZ.CKMC F...
3,735,158 1 3,735,158.00 1.16 22.32 24.02 7d6k1q0qwhnq2 JDBC Thin Client SELECT x.*, y.c_llsxsj, y.c_ll...
3,701,544 2,834 1,306.12 1.15 21.21 22.60 bs8uw9gjz14ts JDBC Thin Client SELECT C_MC FROM T_ZZZSJ X, T_...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
1,233,990 2 616,995.00 97.65 32.43 58.77 85np1pfuxhgy6   UPDATE TWLXQZKQD_HIS SET XQLX=...
1,233,990 2 616,995.00 97.65 48.60 76.90 98jypbmtc6sgc   DECLARE job BINARY_INTEGER := ...
15,914 1 15,914.00 1.26 17.54 20.93 f77qar2jsz9fx JDBC Thin Client SELECT NY, TO_CHAR(XQRQ, 'yyyy...
2,740 7 391.43 0.22 1.81 2.54 gf4thkbsgfd45 JDBC Thin Client SELECT C_CXH, C_CLYS, C_SCSX, ...
1,441 1 1,441.00 0.11 19.98 39.94 0gshzbuaxq8pz JDBC Thin Client SELECT SQ.*, ZZ.C_MC C_SHDW, Y...
873 7 124.71 0.07 3.99 5.68 8x2vjs56gj3a6 JDBC Thin Client BEGIN PRC_MPS_problemDeliveryD...
733 7 104.71 0.06 4.86 9.00 1ykxq1vvu3pw5 JDBC Thin Client BEGIN Prc_Mps_Gyscgbljc(:1, :2...
709 7 101.29 0.06 4.58 8.60 7ccj64p5ga76t JDBC Thin Client INSERT INTO TEMP_CGBLJY (WLBM,...
268 21 12.76 0.02 39.57 49.17 546whxffw127p JDBC Thin Client SELECT WLBM, WLMC, TSYT, TSYTM...
223 122 1.83 0.02 53.60 65.96 9qfvjprb5psvp JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
2,834 2,834 1.00 0.01 0.01 bs8uw9gjz14ts JDBC Thin Client SELECT C_MC FROM T_ZZZSJ X, T_...
2,475 2,475 1.00 0.00 0.00 0sv6rmy7ys3mn JDBC Thin Client SELECT T.* FROM TW_YWLBZSJ T W...
1,152 1,152 1.00 0.00 0.00 1cjy8v3c0agny   select sys_nc_oid$ from xdb.xd...
1,056 1,056 1.00 0.00 0.00 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
1,013 1,008 1.00 0.00 0.00 3c1kubcdjnppq   update sys.col_usage$ set equa...
795 1,622 2.04 0.00 0.01 0s90x7g3jd9sk JDBC Thin Client SELECT INN.*, YG.C_YGMC C_BGYX...
789 789 1.00 0.14 0.15 7f039z54cu4rx JDBC Thin Client SELECT * FROM TW_WLYDPZMX T WH...
756 756 1.00 0.00 0.00 2ghbsfvq9mn3v   INSERT /*+ NO_PARTIAL_COMMIT R...
756 0 0.00 0.00 0.00 d8kbp93qjp4up   DELETE /*+ REF_CASCADE_CURSOR ...
728 728 1.00 0.00 0.00 2tq3dknsjum6d JDBC Thin Client SELECT :"SYS_B_0" FROM DUAL...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
1,152 1,152 3.95 1cjy8v3c0agny   select sys_nc_oid$ from xdb.xd...
1,056 1,056 3.62 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
795 795 2.73 0s90x7g3jd9sk JDBC Thin Client SELECT INN.*, YG.C_YGMC C_BGYX...
756 756 2.59 2ghbsfvq9mn3v   INSERT /*+ NO_PARTIAL_COMMIT R...
756 756 2.59 d8kbp93qjp4up   DELETE /*+ REF_CASCADE_CURSOR ...
728 728 2.50 2tq3dknsjum6d JDBC Thin Client SELECT :"SYS_B_0" FROM DUAL...
512 512 1.76 4tanzh2jp8tsn JDBC Thin Client select BO from SYSTASKBO where...
512 512 1.76 buzx5wrw4dfgw JDBC Thin Client select * from gzlctree where d...
481 481 1.65 9qmza4gnx5rj6 JDBC Thin Client insert into tw_pzdygxhxm(scfwl...
396 396 1.36 3utzy3g1xn2g3 JDBC Thin Client SELECT HXM.C_ZSH, ZS.C_ZSLY, H...
391 391 1.34 grwydz59pu6mc   select text from view$ where r...
367 367 1.26 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
367 367 1.26 g00cj285jmgsw   update sys.mon_mods$ set inser...
330 5 1.13 0v3dvmc22qnam   insert into sys.col_usage$ (ob...
330 1,013 1.13 3c1kubcdjnppq   update sys.col_usage$ set equa...
330 330 1.13 b2gnxm5z6r51n   lock table sys.col_usage$ in e...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,251,390 5 0.19 0km2mucn8vsau JDBC Thin Client INSERT INTO TCGBJDWLCBMX (gysb...
1,971,808 2 0.17 a49buuashyhmn PL/SQL Developer explain plan set statement_id ...
1,253,571 144 0.11 b6cmfd9gfjmqd JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
54 5 0km2mucn8vsau JDBC Thin Client INSERT INTO TCGBJDWLCBMX (gysb...
27 15 1gu8t96d0bdmu   select t.ts#, t.file#, t.block...
27 15 1gu8t96d0bdmu   select t.ts#, t.file#, t.block...
25 32 2ym6hhaq30r73   select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
20.63 51.66 39.94 19.98 1 0gshzbuaxq8pz JDBC Thin Client SELECT SQ.*, ZZ.C_MC C_SHDW, Y...
19.59 26.54 73.82 53.04 512 4tanzh2jp8tsn JDBC Thin Client select BO from SYSTASKBO where...
18.57 94.92 19.56 1.88 2 dps90d8mpnuzv JDBC Thin Client SELECT YGH, CGZXLH, CGZBM, WLB...
16.69 20.41 81.78 65.72 4 61y0t64h2d92j JDBC Thin Client BEGIN SAP2SCF_TOTABLE.Sap03(:1...
16.53 91.24 18.12 2.40 4 15z9yzrsff0p6 JDBC Thin Client SELECT DISTINCT CUR.MBLNR FROM...
7.27 14.78 49.17 39.57 21 546whxffw127p JDBC Thin Client SELECT WLBM, WLMC, TSYT, TSYTM...
6.36 23.72 26.80 20.52 7 crvmbwtcbfb2d JDBC Thin Client BEGIN PKG_ZZKKC_SUBMIT.PRC_WLY...
6.34 24.48 25.88 19.79 7 6r58mcgr1p2mj JDBC Thin Client SELECT A.C_CWTS FROM TW_WLYDZS...
5.36 86.10 6.22 0.84 13 8sdq50a3vjgbn JDBC Thin Client select c.nyr, c.dd, nyrview fr...
4.22 91.92 4.59 0.49 2 0pxsqp3jpy0kn JDBC Thin Client select c.nyr, c.dd, nyrview fr...
4.11 0.36 1,143.66 1,121.71 144 b6cmfd9gfjmqd JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
3.87 1.83 210.96 198.40 140 2baqvamkstzv2 JDBC Thin Client begin pw_add_yjzsscpz(:1, :2, ...
2.82 46.58 6.06 3.11 1 g20awzjss95wu JDBC Thin Client SELECT pz.c_zzbm, pz.c_ywlbbm,...
2.15 13.78 15.60 12.82 30 ayv0vhg5vbcg1 JDBC Thin Client SELECT SQ.*, (SELECT ZZ.CKMC F...
1.90 2.88 65.96 53.60 122 9qfvjprb5psvp JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
1.79 2.32 76.90 48.60 2 98jypbmtc6sgc   DECLARE job BINARY_INTEGER := ...
1.63 0.05 3,144.09 3,149.87 5 7t3bfw6kvdunq JDBC Thin Client SELECT a.sessionid, decode(a.s...
1.61 7.71 20.93 17.54 1 f77qar2jsz9fx JDBC Thin Client SELECT NY, TO_CHAR(XQRQ, 'yyyy...
1.47 22.10 6.63 2.47 512 buzx5wrw4dfgw JDBC Thin Client select * from gzlctree where d...
1.04 5.76 18.09 15.94 38 44m843r687ymt JDBC Thin Client BEGIN pkg_ifc_mes.IFC_MES_SCF_...
0.74 8.25 9.00 4.86 7 1ykxq1vvu3pw5 JDBC Thin Client BEGIN Prc_Mps_Gyscgbljc(:1, :2...
0.73 7.77 9.35 7.93 2 f8gnxvnu28cqf JDBC Thin Client Select :"SYS_B_000" Lx, :"SYS_...
0.72 8.37 8.60 4.58 7 7ccj64p5ga76t JDBC Thin Client INSERT INTO TEMP_CGBLJY (WLBM,...
0.65 24.17 2.70 1.90 1 92kcbw0qn13za JDBC Thin Client select distinct t.ny jhny from...
0.59 23.04 2.55 1.70 1 2z80gcnamvmu9 JDBC Thin Client select c.sfjj, c.djh, c.djhh, ...
0.59 10.77 5.46 3.80 795 0s90x7g3jd9sk JDBC Thin Client SELECT INN.*, YG.C_YGMC C_BGYX...
0.53 2.50 21.06 20.20 35 gmzva85wy3h8n JDBC Thin Client SELECT COUNT(:"SYS_B_0") c_hs,...
0.30 15.72 1.93 1.42 1 gp2srf6v3th3r plsqldev.exe select s.synonym_name object_n...
0.28 58.17 0.48 0.03 481 9qmza4gnx5rj6 JDBC Thin Client insert into tw_pzdygxhxm(scfwl...
0.27 1.14 24.02 22.32 1 7d6k1q0qwhnq2 JDBC Thin Client SELECT x.*, y.c_llsxsj, y.c_ll...
0.25 3.72 6.79 4.67 396 3utzy3g1xn2g3 JDBC Thin Client SELECT HXM.C_ZSH, ZS.C_ZSLY, H...
0.24 1.42 17.25 16.30 49 255j544nntz6k JDBC Thin Client SELECT jhd.gysbm zzbm, (SELECT...
0.24 0.21 114.88 112.21 789 7f039z54cu4rx JDBC Thin Client SELECT * FROM TW_WLYDPZMX T WH...
0.24 0.52 45.89 45.36 2 cf0wmg632udvh JDBC Thin Client begin pw_add_wlydpzs(:1, :2, :...
0.24 0.90 26.19 23.80 82 b2qkbbfj29xxn JDBC Thin Client select monitertab.interfaceid,...
0.24 0.30 77.67 75.08 80 393drhftjj4dt JDBC Thin Client BEGIN Pw_Add_Impmmdsap(:1, :2,...
0.18 8.91 2.07 1.67 90 d80h6a7665f79 JDBC Thin Client SELECT PZ.C_PZH, PZ.C_ZZBM, PZ...
0.17 1.29 13.20 10.59 7 fby16d9fz7k72 JDBC Thin Client BEGIN PKG_MPS_CHECKREQUIREMENT...
0.13 5.24 2.54 1.81 7 gf4thkbsgfd45 JDBC Thin Client SELECT C_CXH, C_CLYS, C_SCSX, ...
0.12 0.55 22.60 21.21 2,834 bs8uw9gjz14ts JDBC Thin Client SELECT C_MC FROM T_ZZZSJ X, T_...
0.12 49.18 0.24 0.00 268 4wmmawv1xc9na JDBC Thin Client insert into tw_pzdygx(scfwlydp...
0.10 7.01 1.49 1.16 90 2v4q7k45ffnwt JDBC Thin Client SELECT MX.C_PZH, MX.C_PZHH, MX...
0.09 43.23 0.22 0.14 167 dc1gr75uzn5z8 JDBC Thin Client SELECT mx.* FROM tw_wlydpzmxte...
0.09 1.48 6.27 6.02 6 1bsp1wphh5m3r JDBC Thin Client SELECT ZS.C_ZSH, HXM.C_XMH, HX...
0.09 37.47 0.23 0.07 1,013 3c1kubcdjnppq   update sys.col_usage$ set equa...
0.08 1.39 5.68 3.99 7 8x2vjs56gj3a6 JDBC Thin Client BEGIN PRC_MPS_problemDeliveryD...
0.06 2.93 2.06 1.68 10 7b7676zfuur7t JDBC Thin Client BEGIN PRC_MES_JHDDY(:1, :2, :3...
0.05 0.23 21.78 21.46 90 1xybtqw3288aw JDBC Thin Client SELECT * FROM SAP2SCF_SF03_EXP...
0.05 54.86 0.09 0.00 94 3m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
0.04 0.06 75.79 74.52 81 a08ad1gmt11q9 JDBC Thin Client SELECT * FROM TW_WLYDPZMX WHER...
0.04 31.18 0.13 0.06 161 dgh4xu8hcq1cc JDBC Thin Client SELECT mx.* FROM tw_wlydpzmxte...
0.04 0.53 7.79 6.03 126 95jdqszh5gv9s JDBC Thin Client SELECT MX.C_CXH, MX.C_SCJHCXH,...
0.04 69.46 0.06 0.02 42 9h4fy0p489gu3 JDBC Thin Client update TASKGROUPSTATES set STA...
0.04 0.18 21.12 21.09 90 3uvgj2xtjzbpx JDBC Thin Client UPDATE SAP2SCF_SF03_EXPORT_MSE...
0.04 15.21 0.25 0.00 1,056 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
0.03 0.28 11.77 11.77 1 fhy8k6wf4unkp JDBC Thin Client SELECT pz.c_zzbm, pz.c_ywlbbm,...
0.03 30.40 0.10 0.01 150 451q2032pshqm   select owner#, name, namespace...
0.03 1.35 2.12 1.81 9 32b5nn8haqrnf JDBC Thin Client UPDATE monitertab SET OUTTIME=...
0.03 38.18 0.07 0.03 302 04xtrk7uyhknh   select obj#, type#, ctime, mti...
0.03 29.06 0.10 0.00 150 8swypbbr0m372   select order#, columns, types ...
0.03 11.68 0.22 0.01 48 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
0.02 0.77 3.20 2.97 14 gj73u9azpmf9t JDBC Thin Client select :"SYS_B_00" Lx, count(:...
0.02 28.11 0.09 0.03 2 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
0.02 27.82 0.09 0.00 367 g00cj285jmgsw   update sys.mon_mods$ set inser...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0gshzbuaxq8pz SELECT SQ.*, ZZ.C_MC C_SHDW, YS.C_YSMC C_WLYSMC, WL.C_WLMC, DY.CGWLYDPZH C_HPH, DY.BACKSL C_HPSL, (CASE NVL(DY.CXBJ, '0') WHEN '1' THEN 'ÒѳåÏú' WHEN '0' THEN 'δ³åÏú' END) C_CXBJ FROM (SELECT HEAD.C_KJZQ, WHL.C_ZZBM, WHL.C_WLBM, NVL(HEAD.C_QC, 0) + NVL(MIDD.C_BWQ, 0) C_QC, WHL.C_WLYSBM, NVL(HEAD.C_QC, 0) + NVL(BACKWARD.C_BWQ, 0) C_KCJY, BACKWARD.C_BWQ, BWBILL.C_RKPZH, BWBILL.C_RKSL, BWBILL.C_RKLB, BWBILL.C_RKRQ, BWBILL.C_CKPZH, BWBILL.C_CKSL, BWBILL.C_CKLB, BWBILL.C_CKRQ, BWBILL.C_WLDWBM, WHL.C_GYSBM, GYS.C_MC C_GYSMC, BWBILL.C_JZRQ, WHL.C_KCZT, BWBILL.SCFWLYDPZHH, CK.C_CKMC C_WLCKMC FROM (SELECT KCZ.C_KJZQ, KCZ.C_ZZBM, KCZ.C_WLBM, SUM(KCZ.C_QC) C_QC, PCZSJ.C_YSGYSBM C_GYSBM, PCZSJ.C_WLYSBM, ZD.C_QZ C_KCZT FROM TW_XLHZ KCZ LEFT JOIN TW_PCZSJ PCZSJ ON KCZ.C_ZZBM = PCZSJ.C_ZZBM AND KCZ.C_WLBM = PCZSJ.C_WLBM AND KCZ.C_PC = PCZSJ.C_PC LEFT JOIN T_SJZD ZD ON KCZ.C_KCZT = ZD.C_CLBM WHERE KCZ.C_KJZQ = :B14 AND KCZ.C_ZZBM = :B13 AND (:B1 = 0 OR KCZ.C_CKBM IN (SELECT * FROM TABLE(:B6 ))) AND (:B12 = 0 OR KCZ.C_WLBM IN (SELECT * FROM TABLE(:B15 ))) AND (:B11 = 0 OR KCZ.C_KCLX IN (SELECT * FROM TABLE(:B16 ))) AND (:B10 = 0 OR KCZ.C_KCZT IN (SELECT * FROM TABLE(:B17 ))) AND (:B9 = 0 OR PCZSJ.C_YSGYSBM IN (SELECT * FROM TABLE(:B18 ))) GROUP BY KCZ.C_KJZQ, KCZ.C_ZZBM, KCZ.C_WLBM, PCZSJ.C_YSGYSBM, PCZSJ.C_WLYSBM, ZD.C_QZ) WHL LEFT JOIN (SELECT KCZ.C_KJZQ, KCZ.C_ZZBM, KCZ.C_WLBM, SUM(NVL(KCZ.C_QC, 0)) C_QC, PCZSJ.C_YSGYSBM C_GYSBM, PCZSJ.C_WL YSBM, ZD.C_QZ C_KCZT FROM TW_XLHZ KCZ LEFT JOIN TW_PCZSJ PCZSJ ON KCZ.C_ZZBM = PCZSJ.C_ZZBM AND KCZ.C_WLBM = PCZSJ.C_WLBM AND KCZ.C_PC = PCZSJ.C_PC LEFT JOIN T_SJZD ZD ON KCZ.C_KCZT = ZD.C_CLBM WHERE KCZ.C_KJZQ = :B8 AND (:B1 = 0 OR KCZ.C_CKBM IN (SELECT * FROM TABLE(:B6 ))) GROUP BY KCZ.C_KJZQ, KCZ.C_ZZBM, KCZ.C_WLBM, PCZSJ.C_YSGYSBM, PCZSJ.C_WLYSBM, ZD.C_QZ) HEAD ON HEAD.C_ZZBM = WHL.C_ZZBM AND HEAD.C_WLBM = WHL.C_WLBM AND HEAD.C_GYSBM = WHL.C_GYSBM AND HEAD.C_KCZT = WHL.C_KCZT LEFT JOIN (SELECT M.C_ZZBM, S.C_WLBM, PCZSJ.C_YSGYSBM C_GYSBM, SUM(CASE B.C_JZFX WHEN '+' THEN S.C_SL ELSE S.C_SL * -1 END) C_BWQ, ZD.C_QZ C_KCZT FROM TW_WLYDPZ M INNER JOIN TW_WLYDPZMX S ON M.C_PZH = S.C_PZH INNER JOIN TW_YWLBZSJ B ON M.C_YWLBBM = B.C_YWLBBM LEFT JOIN T_SJZD ZD ON S.C_KCZT = ZD.C_CLBM LEFT JOIN TW_PCZSJ PCZSJ ON M.C_ZZBM = PCZSJ.C_ZZBM AND S.C_WLBM = PCZSJ.C_WLBM AND S.C_PC = PCZSJ.C_PC WHERE M.C_JZRQ > :B7 AND M.C_JZRQ < :B3 AND (:B1 = 0 OR S.C_CKBM IN (SELECT * FROM TABLE(:B6 ))) GROUP BY M.C_ZZBM, S.C_WLBM, ZD.C_QZ, ZD.C_QZ, PCZSJ.C_YSGYSBM) MIDD ON WHL.C_ZZBM = MIDD.C_ZZBM AND WHL.C_WLBM = MIDD.C_WLBM AND WHL.C_GYSBM = MIDD.C_GYSBM AND WHL.C_KCZT = MIDD.C_KCZT LEFT JOIN (SELECT M.C_ZZBM, S.C_WLBM, PCZSJ.C_YSGYSBM C_GYSBM, SUM(CASE B.C_JZFX WHEN '+' THEN S.C_SL ELSE S.C_SL * -1 END) C_BWQ, ZD.C_QZ C_KCZT FROM TW_WLYDPZ M INNER JOIN TW_WLYDPZMX S ON M.C_PZH = S.C_PZH INNER JOIN TW_YWLBZSJ B ON M.C_YWLBBM = B.C_YWLBBM LEFT JOIN T_SJZD ZD ON S.C_KCZT = ZD.C_CLBM LE FT JOIN TW_PCZSJ PCZSJ ON M.C_ZZBM = PCZSJ.C_ZZBM AND S.C_WLBM = PCZSJ.C_WLBM AND S.C_PC = PCZSJ.C_PC WHERE M.C_JZRQ > :B7 AND M.C_JZRQ < :B2 AND (:B1 = 0 OR S.C_CKBM IN (SELECT * FROM TABLE(:B6 ))) GROUP BY M.C_ZZBM, S.C_WLBM, ZD.C_QZ, ZD.C_QZ, PCZSJ.C_YSGYSBM) BACKWARD ON WHL.C_ZZBM = BACKWARD.C_ZZBM AND WHL.C_WLBM = BACKWARD.C_WLBM AND WHL.C_GYSBM = BACKWARD.C_GYSBM AND WHL.C_KCZT = BACKWARD.C_KCZT LEFT JOIN (SELECT L.C_ZZBM, L.C_WLBM, L.C_RKPZH, L.C_RKRQ, L.C_RKLB, SUM(L.C_RKSL) C_RKSL, L.C_CKPZH, L.C_CKRQ, L.C_CKLB, L.C_WLDWBM, SUM(L.C_CKSL) C_CKSL, L.C_JZRQ, L.C_KCZT, L.C_GYSBM, MAX(L.SCFWLYDPZHH) SCFWLYDPZHH, MAX(C_WLCKBM) C_WLCKBM FROM (SELECT M.C_ZZBM, S.C_WLBM, S.C_PC, CASE WHEN REGEXP_LIKE(:B5 , B.C_YWLBBM) THEN M.C_PZH ELSE '' END C_RKPZH, CASE WHEN REGEXP_LIKE(:B5 , B.C_YWLBBM) THEN TO_CHAR(M.C_JZRQ, 'yyyy-mm-dd hh24:mi') ELSE NULL END C_RKRQ, CASE WHEN REGEXP_LIKE(:B5 , B.C_YWLBBM) THEN B.C_YWLBMC ELSE NULL END C_RKLB, CASE WHEN REGEXP_LIKE(:B5 , B.C_YWLBBM) THEN CASE B.C_JZFX WHEN '+' THEN C_SL ELSE C_SL * -1 END ELSE 0 END C_RKSL, CASE WHEN REGEXP_LIKE(:B4 , B.C_YWLBBM) THEN M.C_PZH ELSE '' END C_CKPZH, CASE WHEN REGEXP_LIKE(:B4 , B.C_YWLBBM) THEN TO_CHAR(M.C_CJSJ, 'yyyy-mm-dd hh24:mi') ELSE NULL END C_CKRQ, CASE WHEN REGEXP_LIKE(:B4 , B.C_YWLBBM) THEN B.C_YWLBMC ELSE NULL END C_CKLB, M.C_WLDWBM, S.C_WLCKBM, CASE WHEN REGEXP_LIKE(:B4 , B.C_YWLBBM) THEN CASE B.C_JZFX WHEN '-' THEN C_SL ELSE C_SL * -1 END ELSE 0 END C_CKSL, M.C_JZRQ, ZD.C_QZ C_KCZT, PCZSJ.C_YSGYSBM C_GYSBM, DY.SCFWLYDPZHH FROM TW_WLYDPZ M INNER JOIN TW_WLYDPZMX S ON M.C_PZH = S.C_PZH INNER JOIN TW_YWLBZSJ B ON M.C_YWLBBM = B.C_YWLBBM LEFT JOIN T_SJZD ZD ON S.C_KCZT = ZD.C_CLBM LEFT JOIN TW_PCZSJ PCZSJ ON M.C_ZZBM = PCZSJ.C_ZZBM AND S.C_WLBM = PCZSJ.C_WLBM AND S.C_PC = PCZSJ.C_PC LEFT JOIN TW_PZDYGXHXM DY ON S.C_PZH = DY.SCFWLYDPZH AND S.C_PZHH = DY.WLYDPZHH WHERE M.C_JZRQ >= :B3 AND M.C_JZRQ <= :B2 AND (:B1 = 0 OR S.C_CKBM IN (SELECT * FROM TABLE(:B6 )))) L GROUP BY L.C_ZZBM, L.C_WLBM, L.C_RKPZH, L.C_RKRQ, L.C_RKLB, L.C_CKPZH, L.C_CKRQ, L.C_CKLB, L.C_WLDWBM, L.C_JZRQ, L.C_KCZT, L.C_GYSBM) BWBILL ON BWBILL.C_ZZBM = WHL.C_ZZBM AND BWBILL.C_WLBM = WHL.C_WLBM AND BWBILL.C_GYSBM = WHL.C_GYSBM AND BWBILL.C_KCZT = WHL.C_KCZT LEFT JOIN T_GYSZSJ GYS ON WHL.C_GYSBM = GYS.C_GYSBM LEFT JOIN TW_CKZSJ CK ON BWBILL.C_WLDWBM = CK.C_ZZBM AND BWBILL.C_WLCKBM = CK.C_CKBM) SQ LEFT JOIN T_ZZZSJ ZZ ON SQ.C_WLDWBM = ZZ.C_ZZBM LEFT JOIN T_YSQD YS ON SQ.C_WLYSBM = YS.C_YSBM LEFT JOIN TW_PZDYGX DY ON SQ.C_CKPZH = DY.SCFWLYDPZH AND SQ.SCFWLYDPZHH = DY.SCFWLYDPZHH LEFT JOIN T_WLZSJ WL ON SQ.C_WLBM = WL.C_WLBM ORDER BY SQ.C_ZZBM, SQ.C_GYSBM, SQ.C_WLBM, SQ.C_KCZT, SQ.C_JZRQ
0km2mucn8vsau INSERT INTO TCGBJDWLCBMX (gysbm, DYSDJK , SMBZYSDJK , FMBZYSDJK , DHBZ, BZLX, BJDBH, DL, DW, DH, DYBZTJ, DBZZZL, DYBZMZL, DZCZL, DZCDJ, DYSJL, DYSDJ, DSYSM, DSNP, DYSFY, DBZFY, DFYXJ, CL, CW, CH, CRQDMJ, CKDTCS, CSNP, CZDKCL, CMPFMJG, CKCTS, CLJRXQL, CZBZF, CCKFY, CFYXJ, SL, SW, SH, SYBZTJ, SBZZZL, SYBZMZ, SZCZL, SZCDJ, SJL, SMBZYSDJ, SSYSM, SSCN, SPSF, SBZF, SFYXJ, FL, FW, FH, FKRQTJ, FKRQZL, FZBZZL, FJL, FMBZYSDJ, FYF, FFYXJ, WLZFY, FSNP)VALUES(:"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11", :"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16", :"SYS_B_17", :"SYS_B_18", :"SYS_B_19", :"SYS_B_20", :"SYS_B_21", :"SYS_B_22", :"SYS_B_23", :"SYS_B_24", :"SYS_B_25", :"SYS_B_26", :"SYS_B_27", :"SYS_B_28", :"SYS_B_29", :"SYS_B_30", :"SYS_B_31", :"SYS_B_32", :"SYS_B_33", :"SYS_B_34", :"SYS_B_35", :"SYS_B_36", :"SYS_B_37", :"SYS_B_38", :"SYS_B_39", :"SYS_B_40", :"SYS_B_41", :"SYS_B _42", :"SYS_B_43", :"SYS_B_44", :"SYS_B_45", :"SYS_B_46", :"SYS_B_47", :"SYS_B_48", :"SYS_B_49", :"SYS_B_50", :"SYS_B_51", :"SYS_B_52", :"SYS_B_53", :"SYS_B_54", :"SYS_B_55", :"SYS_B_56", :"SYS_B_57", :"SYS_B_58", :"SYS_B_59", :"SYS_B_60", :"SYS_B_61")
0pxsqp3jpy0knselect c.nyr, c.dd, nyrview from (SELECT distinct to_char(A.XQRQ, :"SYS_B_00") AS nyr, :"SYS_B_01" || to_char(A.XQRQ, :"SYS_B_02") || :"SYS_B_03" || to_char(A.XQRQ, :"SYS_B_04") nyrview, to_char(A.XQRQ, :"SYS_B_05") dd, A.XQRQ FROM TMRPRDXQHZ A where :"SYS_B_06"=:"SYS_B_07" and a.ny =:"SYS_B_08" and (:"SYS_B_09"=:"SYS_B_10") and upper(a.wlbm)=:"SYS_B_11" and a.cgzbm=:"SYS_B_12" and a.ny =:"SYS_B_13" and (:"SYS_B_14"=:"SYS_B_15") and upper(a.wlbm)=:"SYS_B_16" and a.cgzbm=:"SYS_B_17" GROUP BY A.XQRQ, a.gysbm) c order by c.XQRQ
0s90x7g3jd9sk SELECT INN.*, YG.C_YGMC C_BGYXM, YS.C_YSMC C_WLYSMC, GYS.C_MC C_GYSMC FROM (SELECT T.C_KJZQ, T.C_ZZBM, T.C_CKBM, T.C_QWBM, T.C_CWBM, T.C_WLBM, T.C_PC, FW_CONVERT_XLHTOFLAT(CAST(COLLECT(T.C_XLH) AS TPW_XLH)) C_XLH, T.C_KCLX, T.C_KCZT, T.C_JLDW, NVL(SUM(T.C_ZMSL), 0) C_ZMSL, CASE T.C_PC WHEN '*' THEN DECODE(T.C_KCLX, '1402', '*', T.C_WLDW) ELSE MIN(PCZSJ.C_YSGYSBM) END C_WLDW, PCZSJ.C_YSGYSBM C_GYSBM, FW_GET_BGYBM(:B2 , :B12 , T.C_WLBM, T.C_QWBM, T.C_CWBM, PCZSJ.C_YSGYSBM) C_BGYBM, PCZSJ.C_WLTSYT, :B14 C_WLYSBM FROM TW_XLHZ T LEFT JOIN TW_PCZSJ PCZSJ ON T.C_PC = PCZSJ.C_PC AND PCZSJ.C_ZZBM = :B2 AND PCZSJ.C_WLBM = :B1 WHERE T.C_KJZQ = :B13 AND T.C_ZZBM = :B2 AND T.C_CKBM = :B12 AND T.C_WLBM = :B1 AND (:B11 IS NULL OR T.C_PC IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B11 )))) AND (:B10 IS NULL OR T.C_XLH IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B10 )))) AND (:B9 IS NULL OR T.C_QWBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B9 )))) AND (:B8 IS NULL OR T.C_CWBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B8 )))) AND (:B7 IS NULL OR T.C_KCLX IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B7 )))) AND (:B6 IS NULL OR T.C_KCZT IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B6 )))) AND (:B5 IS NULL OR T.C_WLDW IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B5 )))) AND (:B4 IS NULL OR PCZSJ.C_WLTSYT IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B4 )))) AND T.C_ZMSL >= :B3 GROUP BY T.C_KJZQ, T.C_ZZBM, T.C_CKBM, T.C_QWBM, T.C_CWBM, T.C_WLBM, T.C_PC, T.C_KCLX, T.C_KCZT, T.C_JLDW, T.C_WLDW, PCZSJ.C_YSGYSBM, PCZSJ.C_WLTSYT, PCZSJ.C_WLYSBM) INN LEFT JOIN T_YGZSJ YG ON INN.C_ZZBM = YG.C_ZZBM AND INN.C_BGYBM = YG.C_YGBM LEFT JOIN T_YSQD YS ON INN.C_WLYSBM = YS.C_YSBM LEFT JOIN T_GYSZSJ GYS ON INN.C_GYSBM = GYS.C_GYSBM
0sv6rmy7ys3mnSELECT T.* FROM TW_YWLBZSJ T WHERE T.C_YWLBBM = :B1
0v3dvmc22qnaminsert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
15z9yzrsff0p6SELECT DISTINCT CUR.MBLNR FROM SAP2SCF_SF03_EXPORT_MSEG CUR WHERE CUR.SESSIONID = :B1 AND CUR.STATUS = '0'
1bsp1wphh5m3r SELECT ZS.C_ZSH, HXM.C_XMH, HXM.C_GYSBM, GYS.C_MC C_GYSMC, HXM.C_WLCKBM, (SELECT C_CKMC FROM TW_CKZSJ WHERE C_CKBM = HXM.C_WLCKBM) C_WLCKMC, ZS.C_WLDWBM, ZZ.C_MC C_WLDWMC, HXM.C_WLBM, WL.C_WLMC, HXM.C_PLX, HXM.C_SL C_JHJHSL, HXM.C_ZXSL C_SJSHSL, HXM.C_JHSFSJ C_JHJHSJ, (SELECT MAX(T2.C_JZRQ) C_JZRQ FROM TW_WLYDPZ T2 WHERE EXISTS (SELECT 1 FROM TW_WLYDPZMX T1 WHERE T1.C_PZH = T2.C_PZH AND T1.C_ZSH = ZS.C_ZSH AND T1.C_ZSXMH = HXM.C_XMH AND T1.C_CXBJ = '0') AND (T2.C_YWLBBM = '52T5' OR T2.C_YWLBBM = '52T7')) C_SJSHSJ, HXM.C_ZXZT, YW.C_YWLBMC, (CASE HXM.C_LLLX WHEN '0' THEN '¿´°å' WHEN '1' THEN 'À­ÁÏ' ELSE '' END) AS C_LLLX, COLOR.YSMC C_WLYSMC, ZS.C_QXBJ, ZS.C_GBBJ, HXM.C_GCBGY, HXM.C_GCBGYMC FROM TW_WLYDZS ZS LEFT JOIN TW_WLYDZSHXM HXM ON HXM.C_ZSH = ZS.C_ZSH LEFT JOIN T_WLZSJ WL ON WL.C_WLBM = HXM.C_WLBM LEFT JOIN T_ZZZSJ ZZ ON ZS.C_WLDWBM = ZZ.C_ZZBM LEFT JOIN T_GYSZSJ GYS ON HXM.C_GYSBM = GYS.C_GYSBM LEFT JOIN TW_YWLBZSJ YW ON ZS.C_YWLBBM = YW.C_YWLBBM LEFT JOIN TBASCOLOR COLOR ON HXM.C_WLYSBM = COLOR.YSBM WHERE (ZS.C_YWLBBM = '52T5' OR ZS.C_YWLBBM = '52T7') AND ZS.C_ZZBM = :B10 AND ((:B9 IS NULL) OR (HXM.C_GYSBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B9 )))))) AND ((:B8 IS NULL) OR (ZS.C_WLDWBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B8 )))))) AND ((:B7 IS NULL) OR (HXM.C_CKBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B7 )))))) AND ((:B6 IS NULL) OR (HXM.C_WLBM IN (SELECT * FROM TABL E(CO LLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B6 )))))) AND ((:B5 IS NULL) OR (ZS.C_ZXZT IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B5 )))))) AND NVL(ZS.C_QXBJ, '0') IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B11 )))) AND NVL(ZS.C_GBBJ, '0') IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B12 )))) AND ((:B4 IS NULL) OR ZS.C_YWLBBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B4 ))))) AND ((:B3 IS NULL) OR HXM.C_LLLX IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B3 ))))) AND HXM.C_JHSFSJ >= TO_DATE(:B2 , 'YYYY-MM-DD HH24:MI:SS') AND HXM.C_JHSFSJ <= (TO_DATE(:B1 , 'YYYY-MM-DD HH24:MI:SS') + 1)
1cjy8v3c0agnyselect sys_nc_oid$ from xdb.xdb$resource where rowid = :1
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1xybtqw3288awSELECT * FROM SAP2SCF_SF03_EXPORT_MSEG DOC WHERE DOC.SESSIONID = :B2 AND DOC.MBLNR = :B1 AND DOC.SGTXT IS NOT NULL
1ykxq1vvu3pw5BEGIN Prc_Mps_Gyscgbljc(:1, :2, :3, :4, :5); END;
255j544nntz6k SELECT jhd.gysbm zzbm, (SELECT zz.zzmc FROM tprizzjg zz WHERE jhd.gysbm=zz.zzbm) Zzmc, Jhd.Wlgs, Jhd.Jhqdh, To_Char(Jhd.Jhrq, :"SYS_B_00") JHRQ, (SELECT dhd FROM TLOGICJHDMX MX WHERE Mx.Jhqdh = :"SYS_B_01" AND RowNum=:"SYS_B_02") DHD, (select case when lld.xqlx = :"SYS_B_03" then to_char(to_date(substr(jk.yjdhsj, :"SYS_B_04", :"SYS_B_05"), :"SYS_B_06"), :"SYS_B_07") || :"SYS_B_08" || to_char(to_date(substr(jk.yjdhsj, :"SYS_B_09", :"SYS_B_10"), :"SYS_B_11"), :"SYS_B_12") else to_char(to_date(substr(jk.yjdhsj, :"SYS_B_13", :"SYS_B_14"), :"SYS_B_15"), :"SYS_B_16") end dhrq from tlogicjhdmx jhdmx inner join tmeslldmx lldmx on lldmx.djh = jhdmx.djh and lldmx.djhh = jhdmx.djhh inner join tmeslld lld on lld.djh = lldmx.djh inner join mes2scf_mf05 jk on jk.djbh = lldmx.meslldh and jk.xqsbh = lldmx.meslldhh where jhdmx.jhqdh = :"SYS_B_17" and rownum = :"SYS_B_18" ) Dhsj, (SELECT lldmx.xggys FROM Tlogicjhdmx Jhdmx INNER JOIN tmeslldmx lldmx ON lldmx.djh =jhdmx.djh AND lldmx.djhh =jhdmx.djhh WHERE Jhdmx.Jhqdh=:"SYS_B_19" AND rownum = :"SYS_B_20" ) Gys, CASE WHEN (SELECT Lld.Xqlx FROM Tlogicjhdmx Jhdmx INNER JOIN Tmeslld Lld ON Lld.Djh = Jhdmx.Djh WHERE Jhdmx.Jhqdh = :"SYS_B_21" AND Rownum = :"SYS_B_22")=:"SYS_B _23" THEN :"SYS_B_24" ELSE :"SYS_B_25" END AS YWFS FROM Tlogicjhd Jhd WHERE Jhqdh=:"SYS_B_26"
2baqvamkstzv2begin pw_add_yjzsscpz(:1, :2, :3); end;
2ghbsfvq9mn3vINSERT /*+ NO_PARTIAL_COMMIT REF_CASCADE_CURSOR */ INTO "SCF2"."TW_WLYDPZMX_XLH" ("NESTED_TABLE_ID", "COLUMN_VALUE") VALUES(:1, :2)
2tq3dknsjum6dSELECT :"SYS_B_0" FROM DUAL
2v4q7k45ffnwt SELECT MX.C_PZH, MX.C_PZHH, MX.C_CKBM, MX.C_QWBM, MX.C_CWBM, MX.C_PC, MX.C_WLBM, MX.C_WLTSYT, MX.C_WLYSBM, (SELECT QD.C_YSMC FROM T_YSQD QD WHERE QD.C_YSBM = MX.C_WLYSBM) C_WLYSMC, MX.C_KCLX, MX.C_KCZT, MX.C_JLDW, MX.C_SL, MX.C_GYSPC, MX.C_WLCKBM, MX.C_WLQWBM, MX.C_WLCWBM, MX.C_SFWLBM, MX.C_SFPC, MX.C_CKPZH, MX.C_CKPZHH, MX.C_ZSH, MX.C_ZSXMH, MX.C_ZSHH, DECODE(YWLB.C_DYMBDDHQZFS, '1', SAP.DDH, MX.C_DDH) C_CGDDH, DECODE(YWLB.C_DYMBDDHQZFS, '1', SAP.DDHH, MX.C_DDHH) C_DDHH, MX.C_CXPZH, MX.C_CXPZHH, MX.C_WLYDYYBM, MX.C_GYSBM, MX.C_BZ, (SELECT WL.C_WLMC FROM T_WLZSJ WL WHERE WL.C_WLBM = MX.C_WLBM AND ROWNUM = 1) C_WLMC, CK.C_CKMC, ZD1.C_MC C_TSYT, YS.C_YSMC, ZD2.C_MC C_XSQY, ZD3.C_MC C_KCLXMC, ZD4.C_MC C_KCZTMC, CK2.C_CKMC C_WLCKMC, (SELECT YY.C_WLYDYYMC FROM TW_WLYDYY YY WHERE YY.C_YWLBBM = PZ.C_YWLBBM AND YY.C_WLYDYYBM = MX.C_WLYDYYBM AND ROWNUM = 1) C_WLYDYYMC, WLDW.C_WLDWMC C_GYSMC, (SELECT BZ.C_SNP FROM T_WLBZ BZ WHERE BZ.C_ZZBM = PZ.C_ZZBM AND BZ.C_WLBM = MX.C_WLBM AND BZ.C_GYS = MX.C_GYSBM AND ROWNUM = 1) C_SNP, NULL C_JHY, YG2.C_YGMC C_BGY, 0 C_BZJG, 1 C_JGDW, DECODE(MX.C_WLBB, 'HX', '', (SELECT HXM.C_PLX FROM TW_WLYDZSHXM HXM WHERE HXM.C_ZSH = MX.C_ZSH AND HXM.C_XMH = MX.C_ZSXMH AND ROWNUM = 1)) C_PLX, (SELECT HXM.C_SL FROM TW_WLYDZSHXM HXM WHERE HXM.C_ZSH = MX.C_ZSH AND HXM.C_XMH = MX.C_ZSXMH AND ROWNUM = 1) C_ZSSL, (SELECT HXM.C_GCBGY FROM TW_WLYDZSHXM HXM WHERE HXM.C_ZSH = MX.C_ZSH AND HXM.C_XMH = MX.C_ZSXMH AN D ROWNUM = 1) C_WLBGYBM, (SELECT HXM.C_GCBGYMC FROM TW_WLYDZSHXM HXM WHERE HXM.C_ZSH = MX.C_ZSH AND HXM.C_XMH = MX.C_ZSXMH AND ROWNUM = 1) C_WLBGYMC, (SELECT TO_CHAR(S.C_DHSJ, 'yyyy-mm-dd HH24:MI') C_JHSFSJ FROM TW_WLYDZSHXM S WHERE S.C_ZSH = MX.C_ZSH AND S.C_XMH = MX.C_ZSXMH AND ROWNUM = 1) C_JHSFSJ FROM TW_WLYDPZMX MX INNER JOIN TW_WLYDPZ PZ ON PZ.C_PZH = MX.C_PZH INNER JOIN TW_CKZSJ CK ON CK.C_CKBM = MX.C_CKBM LEFT JOIN TW_CKZSJ CK2 ON CK2.C_CKBM = MX.C_WLCKBM LEFT JOIN T_YSQD YS ON YS.C_YSBM = MX.C_WLYSBM LEFT JOIN T_SJZD ZD1 ON ZD1.C_CLBM = MX.C_WLTSYT LEFT JOIN T_SJZD ZD2 ON ZD2.C_CLBM = MX.C_XSQY LEFT JOIN T_SJZD ZD3 ON ZD3.C_CLBM = MX.C_KCLX LEFT JOIN T_SJZD ZD4 ON ZD4.C_CLBM = MX.C_KCZT LEFT JOIN (SELECT C_GYSBM C_WLDWBM, C_MC C_WLDWMC FROM T_GYSZSJ UNION SELECT C_KHBM C_WLDWBM, C_MC C_WLDWMC FROM T_KHZSJ) WLDW ON WLDW.C_WLDWMC = MX.C_GYSBM LEFT JOIN TW_CKQWZSJ CKQW ON MX.C_CKBM = CKQW.C_CKBM AND MX.C_QWBM = CKQW.C_QWBM LEFT JOIN T_YGZSJ YG2 ON YG2.C_YGBM = CKQW.C_BGYBM1 LEFT JOIN TW_YWLBZSJ YWLB ON YWLB.C_YWLBBM = PZ.C_YWLBBM LEFT JOIN TW_SAPWLPZ SAP ON SAP.SGWLPZH = PZ.C_PZH AND GCBH = PZ.C_ZZBM WHERE 1 = 1 AND EXISTS (SELECT 1 FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B1 ))) FF WHERE FF.COLUMN_VALUE = MX.C_PZH) ORDER BY MX.C_PZH, MX.C_PZHH
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
2z80gcnamvmu9 select c.sfjj, c.djh, c.djhh, c.zdgys as gysbm, c.wlbm, c.wltsyt, c.wlys, c.snp, c.qdsl, c.yghsl, c.yzxsl, c.jhymc, c.bgymc, (select zzmc from tprizzjg tp where tp.zzbm = c.fhdw)fhdw, c.dhdw, c.dhd, c.dhrq, c.xqrq, c.lllx, c.gysmc, c.wlmc, c.meslldh, c.meslldhh from (select :"SYS_B_00" SFJJ, a.djh, a.djhh, a.zdgys, a.wlbm, (select mc from tprisjzd p where p.clbm = a.wltsyt) as wltsyt, (select ygmc from tpriygzsj where ygbm = (select ygbm from tsysyhsjqx q where q.fl = a.wlbm and a.djh = b.djh and q.zzbm = b.cgzbm and q.YWLX = :"SYS_B_01")) jhymc, a.bgymc, (select ysmc from tbascolor t where t.ysbm = a.wlys) as wlys, a.snp, a.qdsl, a.yghsl, a.yzxsl, b.gysbm fhdw, (select zzmc from tprizzzsj jp where jp.zzbm = b.dhdwbm) as dhdw, (select ckmc from tprickzsj j where j.ckbm = a.dhd) as dhd, b.dhrq, a.xqrq, (select mc from TPRISJZD d where d.sjfl = :"SYS_B_02" and d.clbm = b.xqlx) as lllx, a.meslldh, a.meslldhh, (select ygmc from tpriygzsj where tpriygzsj.ygbm = a.xggys) gysmc, (select wlmc from TPRIWLZSJ where TPRIWLZSJ.wlbm = a.wlbm) wlmc from tmeslld b, tmeslldmx a where a.djh = b.djh and b.dhrq >=to_date(:"SYS_B_03", :"SYS_B_04") and b.dhrq<=to_date(:"SYS_B_05", :"SYS_B_06") union select :"SYS_B_07" SFJJ, djbh, null djhh, t.gysbm, t.wlh wlbm, (select mc from tprisjzd p where p.clbm = tsyt) wltsyt, (select ygmc from tpriygzsj where ygbm = t.jhybm) jhymc, t.bgymc, (select ysmc from tbascolor t where t.ysbm = ys) wlys, to_number(snp) snp, to_number(yhsl) qdsl, null yzxsl, null yghsl, (case when cs.c_wmsglbj = :"SYS_B_08" then (select max(g.c_zzbm) from tw_ckygysdygx g where g.c_gysbm = t.gysbm) else t.gysbm end) fhdw, (select zzmc from tprizzzsj jp where jp.zzbm = t.zzbm) dhdw, (select ckmc from tprickzsj j where j.ckbm = t.shck) dhd, to_date(substr(yjdhsj, :"SYS_B_09", :"SYS_B_10"), :"SYS_B_11") dhrq, to_date(substr(jhrq, :"SYS_B_12", :"SYS_B_13"), :"SYS_B_14") xqrq, (case when t.lllx = :"SYS_B_15" then :"SYS_B_16" else :"SYS_B_17" end) lllx, null meslldh, null meslldhh, (select ygmc from tpriygzsj where tpriygzsj.ygbm = t.gysbm) gysmc, (select wlmc from TPRIWLZSJ where TPRIWLZSJ.wlbm = t.wlh) wlmc from tmesjjlld t LEFT JOIN tpriwlgsfw fw ON t.gysbm = fw.gysbm LEFT JOIN tw_zzjbyycs cs ON fw.wlgsbm = cs.c_zzbm where :"SYS_B_18" = :"SYS_B_19" and clzt = :"SYS_B_20" and to_date(substr(t.yjdhsj, :"SYS_B_21", :"SYS_B_22"), :"SYS_B_23")>=to_date(:"SYS_B_24", :"SYS_B_25") and to_date(substr(yjdhsj, :"SYS_B_26", :"SYS_B_27"), :"SYS_B_28")<=to_date(:"SYS_B_29", :"SYS_B_30")) c where :"SYS_B_31"=:"SYS_B_32"
32b5nn8haqrnfUPDATE monitertab SET OUTTIME=null, TRANSTIME=sysdate WHERE ID=:"SYS_B_0"
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
393drhftjj4dtBEGIN Pw_Add_Impmmdsap(:1, :2, :3); END;
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3m8smr0v7v1m6INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
3utzy3g1xn2g3 SELECT HXM.C_ZSH, ZS.C_ZSLY, HXM.C_XMH, HXM.C_CKBM, CKZSJ.C_CKMC, HXM.C_WLBM, (SELECT WL.C_WLMC FROM T_WLZSJ WL WHERE WL.C_WLBM = HXM.C_WLBM AND ROWNUM = 1) C_WLMC, HXM.C_GYSBM C_ZSGYSBM, GYSZSJ.C_MC C_ZSGYSMC, HXM.C_WLTSYT, HXM.C_WLYSBM, (SELECT YSQD.C_YSMC FROM T_YSQD YSQD WHERE YSQD.C_YSBM = HXM.C_WLYSBM AND ROWNUM = 1) C_WLYSMC, HXM.C_WLBB, HXM.C_JLDW, HXM.C_SL, NVL(HXM.C_ZXSL, 0) C_ZXSL, HXM.C_GYSPC, HXM.C_DDH, HXM.C_DDHH, HXM.C_CKPZH, HXM.C_CKPZHH, HXM.C_SNP, HXM.C_XSQY, HXM.C_YDYY, (SELECT YDYY.C_WLYDYYMC FROM T_WLYDYY YDYY WHERE YDYY.C_WLYDYYBM = HXM.C_YDYY AND ROWNUM = 1) C_YDYYMC, HXM.C_WLCKBM, CKZSJ2.C_CKMC C_WLCKMC, HXM.C_CJR, HXM.C_CJSJ, HXM.C_XGR, HXM.C_XGSJ, NVL(HXM.C_QXBJ, '0') C_QXBJ, NVL(HXM.C_GBBJ, '0') C_GBBJ, HXM.C_ZXZT, NVL(DDMX.C_DGSL, 0) C_DGSL, NVL(ZT.C_ZTSL, 0) C_ZTSL, NVL(ZT.C_SRSL, 0) C_DHSL, WLMX.C_ZSH MXC_ZSH, WLMX.C_ZSXMH MXC_ZSXMH, WLMX.C_ZSHH MXC_ZSHH, WLMX.C_QWBM MXC_QWBM, WLMX.C_CWBM MXC_CWBM, WLMX.C_PC MXC_PC, FW_CONVERT_XLHTOFLAT(WLMX.C_XLH) MXC_XLH, WLMX.C_SL MXC_SL, WLMX.C_SJSL MXC_SJSL, WLMX.C_KCLX MXC_KCLX, WLMX.C_KCZT MXC_KCZT, WLMX.C_WLQWBM MXC_WLQWBM, WLMX.C_WLCWBM MXC_WLCWBM, WLMX.C_SFWLBM MXC_SFWLBM, WLMX.C_SFPC MXC_SFPC, WLMX.C_CJR MXC_CJR, WLMX.C_CJSJ MXC_CJSJ, WLMX.C_XGR MXC_XGR, WLMX.C_XGSJ MXC_MXXGSJ, WLMX.C_SCR MXC_SCR, WLMX.C_SCSJ MXC_SCSJ, WLMX.C_QRR MXC_QRR, WLMX.C_QRSJ MXC_QRSJ, WLMX.C_ZXZT MXC_ZXZT, PZZT.C_FCSL PZZTC_FCSL, PZZT.C_SRSL PZZTC_SRSL, PZZT. C_ZTSL PZZTC_ZTSL, DDZT.C_SRSL DDZTC_SRSL, DDZT.C_FCSL DDZTC_FCSL, DDZT.C_ZTSL DDZTC_ZTSL, CJZT.C_FCSL CJZTC_FCSL, CJZT.C_SRSL CJZTC_SRSL, CJZT.C_ZTSL CJZTC_ZTSL, CKZT.C_FCSL CKZTC_FCSL, CKZT.C_SRSL CKZTC_SRSL, CKZT.C_ZTSL CKZTC_ZTSL, CGDD.C_CGLX C_CGLX, CGDD.C_DDZT, DDMX.C_DDHZT, PZMX.C_KCLX CMXC_CKPZKCLX, PZMX.C_KCZT CMXC_CKPZKCZT, FW_GET_BGYBM(ZS.C_ZZBM, HXM.C_CKBM, HXM.C_WLBM, WLMX.C_QWBM, WLMX.C_CWBM, NVL(HXM.C_GYSBM, WLMX.C_GYSBM)) C_BGYBM, (SELECT T.YGMC FROM TPRIYGZSJ T WHERE T.ZZBM = ZS.C_ZZBM AND T.YGBM = FW_GET_BGYBM(ZS.C_ZZBM, HXM.C_CKBM, HXM.C_WLBM, WLMX.C_QWBM, WLMX.C_CWBM, NVL(HXM.C_GYSBM, WLMX.C_GYSBM))) MXC_BGYXM, WLMX.C_GYSBM, MXGYS.C_MC C_GYSMC, HXM.C_BZ, HXM.C_PLX, TO_CHAR(HXM.C_DHSJ, 'yyyy-mm-dd hh24:mi:ss') C_DHSJ, HXM.C_LLLX, HXM.C_GCBGY, HXM.C_GCBGYMC, HXM.C_ZJHGXX, HXM.C_SAPPZXX, HXM.C_KCZT C_ZSKCZT, (SELECT ZD.C_MC FROM T_SJZD ZD WHERE ZD.C_CLBM = HXM.C_KCZT) C_ZSKCZTMC, TO_CHAR(HXM.C_JHSFSJ, 'yyyy-mm-dd hh24:mi:ss') C_JHSFSJ FROM TW_WLYDZSHXM HXM LEFT JOIN TW_WLYDZSWLMX WLMX ON HXM.C_ZSH = WLMX.C_ZSH AND HXM.C_XMH = WLMX.C_ZSXMH LEFT JOIN T_GYSZSJ MXGYS ON WLMX.C_GYSBM = MXGYS.C_GYSBM LEFT JOIN TW_WLYDZS ZS ON HXM.C_ZSH = ZS.C_ZSH LEFT JOIN T_GYSZSJ GYSZSJ ON HXM.C_GYSBM = GYSZSJ.C_GYSBM LEFT JOIN TW_CKZSJ CKZSJ ON HXM.C_CKBM = CKZSJ.C_CKBM LEFT JOIN TW_CKZSJ CKZSJ2 ON HXM.C_WLCKBM = CKZSJ2.C_CKBM LEFT JOIN TW_CJPZZT ZT ON HXM.C_DDH = ZT.C_PZH AND HXM.C_DDHH = ZT.C_PZHH LEFT JOIN T_CGDDMX DDMX ON HXM.C_DDH = DDMX.C_CGDDH AND HXM.C_DDHH = DDMX.C_CGDDHH LEFT JOIN T_CGDD CGDD ON DDMX.C_CGDDH = CGDD.C_CGDDH LEFT JOIN TW_CJPZZT PZZT ON HXM.C_ZSH = PZZT.C_PZH AND HXM.C_XMH = PZZT.C_PZHH LEFT JOIN TW_CJPZZT DDZT ON HXM.C_DDH = DDZT.C_PZH AND HXM.C_DDHH = DDZT.C_PZHH LEFT JOIN TW_YWLBZSJ YWLB ON ZS.C_YWLBBM = YWLB.C_YWLBBM LEFT JOIN TW_CJZT CJZT ON DECODE(YWLB.C_JZFX, '-', CJZT.C_FHDWBM, '+', CJZT.C_SHDWBM) = ZS.C_ZZBM LEFT JOIN TW_CJZT CKZT ON DECODE(YWLB.C_JZFX, '-', CJZT.C_FHDWBM, '+', CJZT.C_SHDWBM) = HXM.C_CKBM LEFT JOIN TW_WLYDPZMX PZMX ON HXM.C_CKPZH = PZMX.C_PZH AND HXM.C_CKPZHH = PZMX.C_PZHH LEFT JOIN TW_WLYDPZ PZ ON HXM.C_CKPZH = PZ.C_PZH WHERE HXM.C_ZSH = :B1 ORDER BY HXM.C_WLBM ASC
3uvgj2xtjzbpxUPDATE SAP2SCF_SF03_EXPORT_MSEG T4 SET T4.STATUS = 1 WHERE SESSIONID = :B2 AND T4.MBLNR = :B1
44m843r687ymtBEGIN pkg_ifc_mes.IFC_MES_SCF_SCSJ(:1, :2); END;
451q2032pshqmselect owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4tanzh2jp8tsnselect BO from SYSTASKBO where TASKID=:"SYS_B_0"
4wmmawv1xc9nainsert into tw_pzdygx(scfwlydpzh, scfwlydpzhh, sjly, cjsj) select :"SYS_B_00", :"SYS_B_01", (select Decode(count(:"SYS_B_02"), :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06") Sjly from Tw_Wlydpz Pz where pz.c_ywlbbm in (:"SYS_B_07", :"SYS_B_08") and exists (select :"SYS_B_09" from Tw_Pzb Pzb where Pzb.Lx = :"SYS_B_10" and Pzb.Bm = Pz.C_Wldwbm) and Pz.C_Pzh = :"SYS_B_11"), sysdate from dual where not exists (select :"SYS_B_12" from tw_pzdygx gx where gx.scfwlydpzh=:"SYS_B_13" and gx.scfwlydpzhh=:"SYS_B_14")
546whxffw127p SELECT WLBM, WLMC, TSYT, TSYTMC, WLYS, YSMC, AQKC, DQKC, TO_CHAR(XQRQ, 'yyyy-MM-dd') XQRQ, XQSL, (DECODE(:B11 , '1', (DQKC - AQKC - XQZL), (DQKC - XQZL))) XQCY FROM (SELECT WLBM, (SELECT WLMC FROM TPRIWLZSJ WLZSJ WHERE WLZSJ.WLBM = XQHZ.WLBM) WLMC, TSYT, (SELECT C_MC FROM T_SJZD SJZD WHERE SJZD.C_CLBM = XQHZ.TSYT) TSYTMC, WLYS, (SELECT YSMC FROM TBASCOLOR COLOR WHERE XQHZ.WLYS = COLOR.YSBM) YSMC, NVL((SELECT C_AQKCSL FROM TW_GYSAQKCCSWH AQKC WHERE AQKC.C_GYSBM = :B3 AND AQKC.C_ZZBM = '8000' AND AQKC.C_WLBM = XQHZ.WLBM), 0) AQKC, NVL((SELECT SUM(C_ZMSL) FROM TW_RJZZ RJZZ INNER JOIN TW_PCZSJ PCZSJ ON RJZZ.C_ZZBM = PCZSJ.C_ZZBM AND RJZZ.C_PC = PCZSJ.C_PC WHERE PCZSJ.C_YSGYSBM = :B3 AND RJZZ.C_ZZBM = :B10 AND RJZZ.C_WLBM = XQHZ.WLBM AND DECODE(PCZSJ.C_WLTSYT, :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B4 ) = NVL(XQHZ.TSYT, :B4 ) AND NVL(PCZSJ.C_WLYSBM, '-') = NVL(XQHZ.WLYS, '-') ), 0) DQKC, XQRQ, SUM(XQSL) XQSL, NVL((SELECT SUM(XQSL) XQLJ FROM TMRPRDXQHZ B WHERE B.GYSBM = :B3 AND B.XQDW <> '8918' AND B.WLBM = XQHZ.WLBM AND B.XQRQ >= TRUNC(SYSDATE) AND B.XQRQ <= XQHZ.XQRQ AND NVL(B.WLYS, '-') = NVL(XQHZ.WLYS, '-') AND NVL(B.TSYT, :B4 ) = NVL(XQHZ.TSYT, :B4 )), 0) XQZL FROM TMRPRDXQHZ XQHZ WHERE GYSBM = :B3 AND XQDW <> '8918' AND (WLBM = '' OR WLBM LIKE '%' || :B2 || '%') AND XQRQ >= TRUNC(SYSDATE) AND XQRQ < TRUNC(SYSDATE) + :B1 GROUP BY XQHZ.WLBM, XQHZ.XQRQ, XQHZ.TSYT, XQHZ.WLYS) WHERE XQSL <> 0 ORDER BY WLBM, T SYT, WLYS, XQRQ
61y0t64h2d92jBEGIN SAP2SCF_TOTABLE.Sap03(:1); END;
6r58mcgr1p2mjSELECT A.C_CWTS FROM TW_WLYDZSHXMTEMP A WHERE EXISTS (SELECT 1 FROM TW_WLYDZSHXM T WHERE T.C_CKBM = A.C_CKBM AND T.C_GYSBM = A.C_GYSBM AND T.C_WLBM = A.C_WLBM AND T.C_SL = A.C_SL AND T.C_LLLX = A.C_LLLX AND T.C_WLCKBM = A.C_WLCKBM AND TO_CHAR(T.C_CJSJ, 'yyyy-mm-dd') = TO_CHAR(A.C_CJSJ, 'yyyy-mm-dd') AND TO_CHAR(A.C_DHSJ, 'yyyy-mm-dd HH24:MI') = TO_CHAR(T.C_DHSJ, 'yyyy-mm-dd HH24:MI')) AND A.C_PH = :B1 FOR UPDATE OF A.C_CWTS
7b7676zfuur7tBEGIN PRC_MES_JHDDY(:1, :2, :3); END;
7ccj64p5ga76tINSERT INTO TEMP_CGBLJY (WLBM, WLMC, NCGBL, ZXRQ, JZRQ, FBRMC, CGBL) SELECT DISTINCT WLBM, WLMC, NCGBL, ZXRQ, JZRQ, FBRMC, CGBL FROM (SELECT X.C_WLBM WLBM, (SELECT WLMC FROM TPRIWLZSJ ZSJ WHERE ZSJ.WLBM = X.C_WLBM) WLMC, NVL(Z.NCGBL, 0) NCGBL, (SELECT NVL(SUM(NCGBL), 0) FROM TCGBLQD QD WHERE QD.ZZBM = Y.CGZZBM AND QD.WLBM = X.C_WLBM AND TO_CHAR(X.C_XQRQ, 'yyyymmdd') BETWEEN QD.ZXRQ AND QD.JZRQ) CGBL, Z.ZXRQ, Z.JZRQ, Z.FBRMC, Q.WLBM QXWLBM FROM (SELECT JG.C_WLBM, MX.C_XQRQ, MX.C_FLBM, MX.C_XQDW FROM T_CXBOMJGZB JG, TEMP_XQMX_L MX WHERE JG.C_CXH = MX.C_CXH AND JG.C_QYRQ = MX.C_TQSJ AND JG.C_SCSX = MX.C_SCSX AND JG.C_ZPLX <> 'JQ' AND JG.C_ZZLX = 'CK') X LEFT JOIN TPARXQKZCS P ON X.C_FLBM = P.ZZBM AND X.C_XQDW = P.XQDW LEFT JOIN TPRICGZFW Y ON P.SCDWBM = Y.XQDWBM LEFT JOIN (SELECT WLBM, ZZBM, SUM(NVL(NCGBL, 0)) NCGBL, ZXRQ, JZRQ, FBRMC FROM TCGBLQD GROUP BY WLBM, ZZBM, ZXRQ, JZRQ, FBRMC) Z ON X.C_WLBM = Z.WLBM AND Y.CGZZBM = Z.ZZBM AND TO_CHAR(X.C_XQRQ, 'yyyymmdd') BETWEEN Z.ZXRQ AND Z.JZRQ LEFT JOIN TWLZFQD Q ON Y.CGZBM = Q.CGZBM AND X.C_WLBM = Q.WLBM) WHERE QXWLBM IS NULL
7d6k1q0qwhnq2 SELECT x.*, y.c_llsxsj, y.c_llxxsj, y.c_zjsj, y.c_rksj FROM (SELECT :"SYS_B_0" c_bbh, Tclpxjhmx.C_CLZPJHMXXLH, Tclpxjhmx.C_CXH, Tclpxjhmx.c_dpch, Tclpxjhmx.C_DDH, Tclpxjhmx.C_JHKSRQ, Tclpxjhmx.C_DPH, mx.c_ysbm c_yysbm, (SELECT ys.c_ysjc FROM t_ysqd ys WHERE ys.c_ysbm = mx.C_YSBM) C_PCQYSMC, Tclpxjhmx.C_YSBM C_UPDATEYSBM, DECODE(TCLPXJHMX.c_ddh, NULL, NULL, (SELECT YS.C_YSJC FROM T_YSQD YS WHERE YS.C_YSBM = TCLPXJHMX.C_YSBM)) C_UPDATEYSMC, mx.C_TXM ytxm, Tclpxjhmx.C_TXM C_UPDATETXM, Tclpxjhmx.C_CLSX, (SELECT sj.C_MC FROM T_SJZD sj WHERE sj.C_CLBM = Tclpxjhmx.C_CLSX) c_clsxmc, Tclpxjhmx.C_SCSX, (SELECT sj.C_MC FROM T_SJZD sj WHERE sj.C_CLBM = Tclpxjhmx.C_SCSX) C_SCSXmc, Tclpxjhmx.C_XSQY, (SELECT sj.C_MC FROM T_SJZD sj WHERE sj.C_CLBM = Tclpxjhmx.C_XSQY) C_XSQYmc, Tclpxjhmx.C_DTSX, (SELECT zz.C_MC FROM T_ZZZSJ zz, t_scx scx WHERE zz.C_ZZBM = scx.c_zzbm and scx.c_scxbm = Tclpxjhmx.c_scxbm) c_gc, (SELECT scx.C_MC FROM t_scx scx WHERE scx.C_SCXBM = Tclpxjhmx.C_SCXBM) c_scxmc, Fun_Return_Xqdw(TCLPXJHMX.C_XQMXXLH) C_XQDWMC FROM T_L_CLZPJHMX Tclpxjhmx, T_CLZPJHMX mx WHERE Tclpxjhmx.C_YCLZPJHMXXLH = mx.C_CLZPJHMXXLH and Tclpxjhmx.c_jhzzbm = :"SYS_B_1" AND :"SYS_B_2" = :"SYS_B_3") x LEFT JOIN (SELECT zp.C_CLZPJHMXXLH, strcat(DECODE(pz.C_JCD, :"SYS_B_4", jc.C_LLSJ)) c_llsxsj, strcat(DECODE(pz.C_JCD, :"SYS_B_5", jc.C_LLSJ)) c_llxxsj, strcat(DECODE(pz.C_JCD, :"SYS_B_6", jc.C_LLSJ)) c_zjsj, strcat(DECODE(pz.C _JCD, :"SYS_B_7", jc.c_llsj)) c_rksj FROM T_l_CXJCDMX jc, t_l_clzpjhmx zp, T_CXSJJKDPZ pz WHERE jc.C_CLZPJHMXXLH = zp.C_CLZPJHMXXLH AND jc.C_CXSJJKDPZXLH = pz.C_CXSJJKDPZXLH and zp.c_jhzzbm = :"SYS_B_8" AND pz.c_scxbm = zp.c_scxbm GROUP BY zp.C_CLZPJHMXXLH) y ON x.c_clzpjhmxxlh = y.c_clzpjhmxxlh
7f039z54cu4rxSELECT * FROM TW_WLYDPZMX T WHERE T.C_PZH = :B2 AND T.C_PZHH = :B1
7t3bfw6kvdunq SELECT a.sessionid, decode(a.status, :"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07") status, a.material, m.c_wlmc, a.plant, (SELECT zzmc FROM scf2.tprizzzsj WHERE zzbm = a.plant) plantname, a.stge_loc, a.batch, a.move_type, a.entry_qnt, a.entry_uom, a.item_text, a.mvt_ind, b.pstng_date, b.doc_date, (SELECT c.message FROM scf2sap_sf17_export c WHERE a.sessionid = c.sessionid AND regexp_like(a.item_text, :"SYS_B_08" || c.s_row || :"SYS_B_09") AND rownum = :"SYS_B_10") message, b.gr_gi_slip_no pzh, d.wlpzbh sappzh, e.c_cjr, (SELECT ygmc FROM tpriygzsj WHERE ygbm = e.c_cjr) cjr, a.vendor gysbm, (SELECT q.zzmc FROM scf2.tprizzjg q WHERE q.zzlx = :"SYS_B_11" AND q.zzbm = a.vendor AND rownum = :"SYS_B_12") gysmc FROM scf2.scf2sap_sf17_goodsmvt_item a INNER JOIN scf2.scf2sap_sf17_import b ON b.sessionid = a.sessionid LEFT JOIN scf2.tw_sapwlpz d ON d.sgwlpzh || :"SYS_B_13" || d.sgpzhh = a.item_text AND d.gcbh = a.plant LEFT JOIN scf2.tw_wlydpz e ON e.c_pzh = :"SYS_B_14" || b.gr_gi_slip_no LEFT JOIN t_wlzsj m ON a.material = m.c_wlbm WHERE :"SYS_B_15"=:"SYS_B_16" AND PLANT = :"SYS_B_17" AND B.PSTNG_DATE >= :"SYS_B_18" AND B.PSTNG_DATE <= :"SYS_B_19" AND B.doc_date >= :"SYS_B_20" AND B.doc_date <= :"SYS_B_21"AND a.status IN (select column_value from table(collection_wrapper(fw_split_into_vc100(:"SYS_B_22")))) AND e.c_cjr in (select * from table(collection_wrapper(fw_split_into_vc100(:"SYS_B_23"))))
85np1pfuxhgy6UPDATE TWLXQZKQD_HIS SET XQLX='2503' WHERE XQLX IS NULL
8sdq50a3vjgbnselect c.nyr, c.dd, nyrview from (SELECT distinct to_char(A.XQRQ, :"SYS_B_0") AS nyr, :"SYS_B_1" || to_char(A.XQRQ, :"SYS_B_2") || :"SYS_B_3" || to_char(A.XQRQ, :"SYS_B_4") nyrview, to_char(A.XQRQ, :"SYS_B_5") dd, A.XQRQ FROM TMRPRDXQHZ A where :"SYS_B_6"=:"SYS_B_7" and a.ny=:"SYS_B_8" and a.GYSBM = :"SYS_B_9" GROUP BY A.XQRQ, a.gysbm) c order by c.XQRQ
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
8x2vjs56gj3a6BEGIN PRC_MPS_problemDeliveryDate(:1, :2, :3, :4); END;
92kcbw0qn13zaselect distinct t.ny jhny from Tmrprdxqhz t where t.ny is not null order by t.ny desc
95jdqszh5gv9sSELECT MX.C_CXH, MX.C_SCJHCXH, MX.C_CLYS, MX.C_SCSX, MX.C_CLSX, MX.C_XSQY, MX.C_TQSJ, QD.C_XQDW, (SELECT C_NY FROM T_ZYRL WHERE QD.C_KSSJ BETWEEN C_QSRQ AND C_ZZRQ AND C_JHZZBM = :B2 ) C_NY, MX.C_DZL + NVL(ZX.C_WZXZL, 0) C_SL, MX.C_DDH, MX.C_XQMXXLH, MX.C_BZ, MX.C_BZ2, MX.C_BZ3 FROM T_XQQD QD, T_XQMX MX LEFT JOIN T_ZXXQMX ZX ON MX.C_XQMXXLH = ZX.C_XQMXXLH WHERE MX.C_XQQDXLH = :B1 AND QD.C_XQQDXLH = MX.C_XQQDXLH AND MX.C_XQLB IN ('0704', '0705') AND (MX.C_SCSX <> '0403' OR MX.C_SCSX = '0403' AND ((SELECT SUBSTR(MIN(SOPTAG), 0, 3) FROM T_KPCCXQD WHERE SCJHCX = MX.C_SCJHCXH AND MSOP = '0403')) NOT IN ('111')) AND ((QD.C_XQLX || QD.C_XQBBH = 'NO23401') OR INSTR((SELECT ', ' || STRCAT(NVL(C_MC, '-')) || ', ' FROM T_SJZD WHERE UPPER(C_QZ) = 'FLCC' AND C_CLBM LIKE '53%'), ', ' || MX.T_TBDW || ', ') = 0) AND MX.C_DZL + NVL(ZX.C_WZXZL, 0) > 0
98jypbmtc6sgcDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN prc_CGDDJK_SS; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
9h4fy0p489gu3update TASKGROUPSTATES set STATES=:"SYS_B_0" where groupid= :"SYS_B_1" and STATES=:"SYS_B_2"
9qfvjprb5psvp SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS.C_YWLBBM, YWLB.C_YWLBMC, YWLB.C_WLYDLXBM, ZS.C_ZZBM, ZZ.C_MC C_ZZMC, ZS.C_WLDWBM, DECODE(YWLB.C_WLDWLX, '1601', GYS.C_MC, '1602', KH.C_MC, '1603', WLDW.C_MC, '1604', CBZX.C_CBZXMC, '') C_WLDWMC, (SELECT TO_CHAR(MIN(H.C_JHSFSJ), 'YYYY-MM-DD') FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_JHSFSJ, (SELECT TO_CHAR(MAX(H.C_JHSFSJ), 'YYYY-MM-DD') FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_JHJSSJ, ZS.C_ZSLY, NVL(ZS.C_QXBJ, '0') C_QXBJ, NVL(ZS.C_GBBJ, '0') C_GBBJ, ZS.C_ZXZT, ZS.C_CJR, (SELECT YG.YGMC FROM TPRIYGZSJ YG WHERE YG.YGBM = ZS.C_CJR) C_CJRMC, TO_CHAR(ZS.C_CJSJ, 'yyyy-mm-dd hh24:mi:ss') C_CJSJ, ZS.C_XGR, (SELECT YG.YGMC FROM TPRIYGZSJ YG WHERE YG.YGBM = ZS.C_CJR) C_XGRMC, TO_CHAR(ZS.C_XGSJ, 'yyyy-mm-dd hh24:mi:ss') C_XGSJ FROM TW_WLYDZS ZS INNER JOIN TW_YWLBZSJ YWLB ON ZS.C_YWLBBM = YWLB.C_YWLBBM INNER JOIN T_ZZZSJ ZZ ON ZS.C_ZZBM = ZZ.C_ZZBM LEFT JOIN T_ZZZSJ WLDW ON ZS.C_WLDWBM = WLDW.C_ZZBM LEFT JOIN T_GYSZSJ GYS ON ZS.C_WLDWBM = GYS.C_GYSBM LEFT JOIN T_KHZSJ KH ON ZS.C_WLDWBM = KH.C_KHBM LEFT JOIN T_CBZXZSJ CBZX ON ZS.C_WLDWBM = CBZX.C_CBZXBH WHERE ZS.C_ZZBM = :B6 AND ZS.C_YWLBBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B7 ))) AND (:B2 IS NOT NULL OR :B5 = '1' OR (:B5 = '2' AND (ZS.C_CJSJ BETWEEN TO_DATE(:B4 || ' 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND TO_DATE(:B3 || ' 23:59:59', 'yyyy-mm-dd hh24:mi:ss')))) AND (:B2 IS NULL OR INSTR(:B2 , ZS.C_ZSH) > 0) AND (:B1 IS NULL OR ZS.C_WLDWBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B1 )))) AND ZS.C_ZXZT IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B8 ))) AND NVL(ZS.C_QXBJ, '0') IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B9 ))) AND NVL(ZS.C_GBBJ, '0') IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B10 ))) AND EXISTS (SELECT 1 FROM TW_WLYDZSHXM HXM LEFT JOIN TM_ZZWLCS CS ON HXM.C_CKBM = CS.C_DHDBM LEFT JOIN TW_WLYDZSWLMX WLMX ON WLMX.C_ZSH = HXM.C_ZSH AND WLMX.C_ZSXMH = HXM.C_XMH WHERE HXM.C_ZSH = ZS.C_ZSH AND HXM.C_CKBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B15 ))) AND ((:B14 IS NULL) OR (HXM.C_DDH = :B14 )) AND (CS.C_ZZBM = ZS.C_ZZBM OR CS.C_ZZBM IS NULL) AND ((:B13 IS NULL) OR (FW_GET_BGYBM(ZS.C_ZZBM, HXM.C_CKBM, HXM.C_WLBM, WLMX.C_QWBM, WLMX.C_CWBM, NVL(HXM.C_GYSBM, HXM.C_GYSBM))) IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B13 )))) AND (:B2 IS NOT NULL OR :B5 = '2' OR (:B5 = '1' AND (HXM.C_JHSFSJ BETWEEN TO_DATE(:B4 || ' 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND TO_DATE(:B3 || ' 23:59:59', 'yyyy-mm-dd hh24:mi:ss')))) AND (:B12 IS NULL OR (CS.C_ABCDFL IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B12 ))) OR CS.C_ABCDFL IS NULL)) AND (:B11 IS NULL OR HXM.C_WLBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B11 )))))
9qmza4gnx5rj6insert into tw_pzdygxhxm(scfwlydpzh, scfwlydpzhh, wlydpzhh, cksl) select :"SYS_B_00", :"SYS_B_01", :"SYS_B_02", (select mx.c_sl from tw_wlydpzmx mx where mx.c_pzh=:"SYS_B_03" and mx.c_pzhh=:"SYS_B_04") cksl from tw_wlydpzmx t where t.c_pzh=:"SYS_B_05" and t.c_pzhh=:"SYS_B_06" and not exists (select :"SYS_B_07" from tw_pzdygxhxm gx where gx.scfwlydpzh=t.c_pzh and gx.scfwlydpzhh=:"SYS_B_08" and gx.wlydpzhh=:"SYS_B_09") and exists (select :"SYS_B_10" from tw_wlydpz pz where pz.c_pzh=t.c_pzh and pz.c_ywlbbm in (:"SYS_B_11", :"SYS_B_12"))
a08ad1gmt11q9SELECT * FROM TW_WLYDPZMX WHERE C_PZH = :B1
a49buuashyhmn explain plan set statement_id = 'SCF2' for SELECT a.sessionid, DECODE (a.status, :"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07" ) status, a.material, m.c_wlmc, a.plant, (SELECT zzmc FROM scf2.tprizzzsj WHERE zzbm = a.plant) plantname, a.stge_loc, a.batch, a.move_type, a.entry_qnt, a.entry_uom, a.item_text, a.mvt_ind, b.pstng_date, b.doc_date, (SELECT c.MESSAGE FROM scf2sap_sf17_export c WHERE a.sessionid = c.sessionid AND REGEXP_LIKE (a.item_text, :"SYS_B_08" || c.s_row || :"SYS_B_09") AND ROWNUM = :"SYS_B_10") MESSAGE, b.gr_gi_slip_no pzh, d.wlpzbh sappzh, e.c_cjr, (SELECT ygmc FROM tpriygzsj WHERE ygbm = e.c_cjr) cjr, a.vendor gysbm, (SELECT q.zzmc FROM scf2.tprizzjg q WHERE q.zzlx = :"SYS_B_11" AND q.zzbm = a.vendor AND ROWNUM = :"SYS_B_12") gysmc FROM scf2.scf2sap_sf17_goodsmvt_item a INNER JOIN scf2.scf2sap_sf17_import b ON b.sessionid = a.sessionid LEFT JOIN scf2.tw_sapwlpz d ON d.sgwlpzh || :"SYS_B_13" || d.sgpzhh = a .item_text AND d.gcbh = a.plant LEFT JOIN scf2.tw_wlydpz e ON e.c_pzh = :"SYS_B_14" || b.gr_gi_slip_no LEFT JOIN t_wlzsj m ON a.material = m.c_wlbm WHERE :"SYS_B_15" = :"SYS_B_16" AND plant = :"SYS_B_17" AND b.pstng_date >= :"SYS_B_18" AND b.pstng_date <= :"SYS_B_19" AND b.doc_date >= :"SYS_B_20" AND b.doc_date <= :"SYS_B_21" AND a.status IN ( SELECT COLUMN_VALUE FROM TABLE (collection_wrapper (fw_split_into_vc100 (:"SYS_B_22")) )) AND e.c_cjr IN ( SELECT * FROM TABLE (collection_wrapper (fw_split_into_vc100 (:"SYS_B_23")) ))
ayv0vhg5vbcg1 SELECT SQ.*, (SELECT ZZ.CKMC FROM TPRICKZSJ ZZ WHERE ZZ.CKBM = SQ.C_WLDWBM) C_SHDW, (SELECT YS.YSMC FROM TBASCOLOR YS WHERE YS.YSBM = SQ.C_WLYSBM) C_WLYSMC, (SELECT WL.C_WLMC FROM T_WLZSJ WL WHERE WL.C_WLBM = SQ.C_WLBM) C_WLMC FROM (SELECT KCZ.C_KJZQ, KCZ.C_ZZBM, KCZ.C_CKBM, KCZ.C_WLBM, KCZ.C_GYSBM, KCZ.C_WLYSBM, KCZ.C_KCZT, (SELECT ZD.MC FROM TPRISJZD ZD WHERE ZD.CLBM = KCZ.C_WLTSYT) C_WLTSYT, KCZ.C_QC, KCZ.C_BHGQC, BWBILL.C_RKPZH, BWBILL.C_RKSL, BWBILL.C_RKLB, BWBILL.C_RKRQ, BWBILL.C_CKPZH, BWBILL.C_CKSL, BWBILL.C_CKLB, BWBILL.C_CKRQ, BWBILL.C_WLDWBM, NVL(BWBILL.C_RKRQ, BWBILL.C_CKRQ) C_JZRQ FROM (SELECT T.C_KJZQ, T.C_ZZBM, T.C_CKBM, T.C_WLBM, T.C_KCZT, PCZSJ.C_YSGYSBM C_GYSBM, PCZSJ.C_WLYSBM, NVL(PCZSJ.C_WLTSYT, :B6 ) C_WLTSYT, (SELECT SUM(QC.C_QC) C_QC FROM TW_XLHZ QC LEFT JOIN TW_PCZSJ PC ON QC.C_ZZBM = PC.C_ZZBM AND QC.C_WLBM = PC.C_WLBM AND QC.C_PC = PC.C_PC WHERE QC.C_KJZQ = T.C_KJZQ AND QC.C_WLBM = T.C_WLBM AND QC.C_CKBM = T.C_CKBM AND QC.C_ZZBM = T.C_ZZBM AND PC.C_YSGYSBM = PCZSJ.C_YSGYSBM AND REGEXP_LIKE(:B9 , QC.C_KCZT) AND NVL(PC.C_WLTSYT, :B6 ) = NVL(PCZSJ.C_WLTSYT, :B6 ) AND NVL(PC.C_WLYSBM, '1') = NVL(PCZSJ.C_WLYSBM, '1')) C_QC, (SELECT SUM(QC.C_QC) C_QC FROM TW_XLHZ QC LEFT JOIN TW_PCZSJ PC ON QC.C_ZZBM = PC.C_ZZBM AND QC.C_WLBM = PC.C_WLBM AND QC.C_PC = PC.C_PC WHERE QC.C_KJZQ = T.C_KJZQ AND QC.C_WLBM = T.C_WLBM AND QC.C_CKBM = T.C_CKBM AND QC.C_ZZBM = T.C_ZZBM AND PC.C_YSGYSBM = PCZSJ.C_YSGYSBM AND REGEXP_LIKE(:B10 , Q C.C_KCZT) AND NVL(PC.C_WLTSYT, :B6 ) = NVL(PCZSJ.C_WLTSYT, :B6 ) AND NVL(PC.C_WLYSBM, '1') = NVL(PCZSJ.C_WLYSBM, '1')) C_BHGQC FROM TW_XLHZ T LEFT JOIN TW_PCZSJ PCZSJ ON T.C_ZZBM = PCZSJ.C_ZZBM AND T.C_WLBM = PCZSJ.C_WLBM AND T.C_PC = PCZSJ.C_PC WHERE PCZSJ.C_YSGYSBM = :B2 AND T.C_KJZQ = :B5 AND T.C_ZZBM = :B4 AND T.C_CKBM = :B3 AND (:B1 IS NULL OR T.C_WLBM LIKE '%' || :B1 || '%') GROUP BY T.C_KJZQ, T.C_ZZBM, T.C_CKBM, T.C_WLBM, T.C_KCZT, PCZSJ.C_YSGYSBM, PCZSJ.C_WLYSBM, PCZSJ.C_WLTSYT) KCZ LEFT JOIN (SELECT M.C_KJZQ, M.C_ZZBM, S.C_CKBM, S.C_WLBM, S.C_KCZT, CASE WHEN REGEXP_LIKE(:B8 , B.C_YWLBBM) THEN M.C_PZH ELSE '' END C_RKPZH, CASE WHEN REGEXP_LIKE(:B8 , B.C_YWLBBM) THEN S.C_PZHH ELSE NULL END C_RKPZHH, CASE WHEN REGEXP_LIKE(:B8 , B.C_YWLBBM) THEN TO_CHAR(M.C_JZRQ, 'yyyy-mm-dd hh24:mi') ELSE NULL END C_RKRQ, CASE WHEN REGEXP_LIKE(:B8 , B.C_YWLBBM) THEN B.C_YWLBMC ELSE NULL END C_RKLB, CASE WHEN REGEXP_LIKE(:B8 , B.C_YWLBBM) THEN CASE B.C_JZFX WHEN '+' THEN C_SL ELSE C_SL * -1 END ELSE 0 END C_RKSL, CASE WHEN REGEXP_LIKE(:B7 , B.C_YWLBBM) THEN M.C_PZH ELSE '' END C_CKPZH, CASE WHEN REGEXP_LIKE(:B7 , B.C_YWLBBM) THEN S.C_PZHH ELSE NULL END C_CKPZHH, CASE WHEN REGEXP_LIKE(:B7 , B.C_YWLBBM) THEN TO_CHAR(M.C_JZRQ, 'yyyy-mm-dd hh24:mi') ELSE NULL END C_CKRQ, CASE WHEN REGEXP_LIKE(:B7 , B.C_YWLBBM) THEN B.C_YWLBMC ELSE NULL END C_CKLB, CASE WHEN REGEXP_LIKE(:B7 , B.C_YWLBBM) THEN S.C_WLCKBM ELSE NULL END C_WLDWBM, CASE WHEN REGEXP_LIKE(:B7 , B.C_YWLBBM) THEN CASE B.C_JZFX WHEN '-' THEN C_SL ELSE C_SL * -1 END ELSE 0 END C_CKSL, M.C_JZRQ, NVL(S.C_WLTSYT, :B6 ) C_WLTSYT, S.C_WLYSBM FROM TW_WLYDPZ M INNER JOIN TW_WLYDPZMX S ON M.C_PZH = S.C_PZH INNER JOIN TW_YWLBZSJ B ON M.C_YWLBBM = B.C_YWLBBM WHERE M.C_KJZQ = :B5 AND M.C_ZZBM = :B4 AND S.C_CKBM = :B3 AND S.C_GYSBM = :B2 AND (:B1 IS NULL OR S.C_WLBM LIKE '%' || :B1 || '%')) BWBILL ON BWBILL.C_KJZQ = KCZ.C_KJZQ AND BWBILL.C_ZZBM = KCZ.C_ZZBM AND BWBILL.C_CKBM = KCZ.C_CKBM AND BWBILL.C_WLBM = KCZ.C_WLBM AND BWBILL.C_KCZT = KCZ.C_KCZT AND BWBILL.C_WLTSYT = KCZ.C_WLTSYT ) SQ WHERE SQ.C_KJZQ = :B5 AND SQ.C_GYSBM = :B2 AND SQ.C_ZZBM = :B4 AND SQ.C_CKBM = :B3 AND (:B1 IS NULL OR SQ.C_WLBM LIKE '%' || :B1 || '%') ORDER BY SQ.C_ZZBM, SQ.C_GYSBM, SQ.C_WLBM, SQ.C_WLYSBM, SQ.C_WLTSYT, SQ.C_JZRQ
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
b2qkbbfj29xxnselect monitertab.interfaceid, monitertab.transjobid, monitertab.TRANSTIME from monitertab, taskgroupscheduler where monitertab.interfaceid = taskgroupscheduler.interfaceid and monitertab.STATUS = :"SYS_B_0" and taskgroupscheduler.groupid = :"SYS_B_1" and monitertab.interfaceid not in (select interfaceid from interfaceconf where rs_status = :"SYS_B_2") order by TRANSTIME asc
b6cmfd9gfjmqd SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS.C_YWLBBM, YWLB.C_YWLBMC, YWLB.C_WLYDLXBM, ZS.C_ZZBM, ZZ.C_MC C_ZZMC, ZS.C_WLDWBM, (SELECT WLCK.C_WLCKBM FROM (SELECT DISTINCT X.C_ZSH, X.C_WLCKBM, (SELECT C.C_CKMC FROM TW_CKZSJ C WHERE C.C_CKBM = X.C_WLCKBM) C_WLCKMC FROM TW_WLYDZSHXM X) WLCK WHERE WLCK.C_ZSH = ZS.C_ZSH) C_WLCKBM, (SELECT WLCK.C_WLCKMC FROM (SELECT DISTINCT X.C_ZSH, X.C_WLCKBM, (SELECT C.C_CKMC FROM TW_CKZSJ C WHERE C.C_CKBM = X.C_WLCKBM) C_WLCKMC FROM TW_WLYDZSHXM X) WLCK WHERE WLCK.C_ZSH = ZS.C_ZSH) C_WLCKMC, DECODE(YWLB.C_WLDWLX, '1601', GYS.C_MC, '1602', KH.C_MC, '1603', WLDW.C_MC, '1604', CBZX.C_CBZXMC, '') C_WLDWMC, (SELECT TO_CHAR(MIN(H.C_JHSFSJ), 'YYYY-MM-DD') FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_JHSFSJ, (SELECT TO_CHAR(MAX(H.C_JHSFSJ), 'YYYY-MM-DD') FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_JHJSSJ, ZS.C_ZSLY, NVL(ZS.C_QXBJ, '0') C_QXBJ, NVL(ZS.C_GBBJ, '0') C_GBBJ, ZS.C_ZXZT, ZS.C_CJR, (SELECT YG.YGMC FROM TPRIYGZSJ YG WHERE YG.YGBM = ZS.C_CJR) C_CJRMC, TO_CHAR(ZS.C_CJSJ, 'yyyy-mm-dd hh24:mi:ss') C_CJSJ, ZS.C_XGR, (SELECT YG.YGMC FROM TPRIYGZSJ YG WHERE YG.YGBM = ZS.C_CJR) C_XGRMC, TO_CHAR(ZS.C_XGSJ, 'yyyy-mm-dd hh24:mi:ss') C_XGSJ, (SELECT HXM.C_LLLX FROM TW_WLYDZSHXM HXM WHERE HXM.C_ZSH = ZS.C_ZSH AND ROWNUM = 1) C_LLLX FROM TW_WLYDZS ZS INNER JOIN TW_YWLBZSJ YWLB ON ZS.C_YWLBBM = YWLB.C_YWLBBM INNER JOIN T_ZZZSJ ZZ ON ZS.C_ZZBM = ZZ.C_ZZBM LEFT JOIN T_ZZZSJ WLDW ON ZS.C_WLDWBM = WLDW.C_ZZBM LEFT JOIN T_GYSZSJ GYS ON ZS.C_WLDWBM = GYS.C_GYSBM LEFT JOIN T_KHZSJ KH ON ZS.C_WLDWBM = KH.C_KHBM LEFT JOIN T_CBZXZSJ CBZX ON ZS.C_WLDWBM = CBZX.C_CBZXBH WHERE ZS.C_ZZBM = :B6 AND ZS.C_YWLBBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B7 )))) AND (:B2 IS NOT NULL OR :B5 = '1' OR (:B5 = '2' AND (ZS.C_CJSJ BETWEEN TO_DATE(:B4 || ' 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND TO_DATE(:B3 || ' 23:59:59', 'yyyy-mm-dd hh24:mi:ss')))) AND (:B2 IS NULL OR INSTR(:B2 , ZS.C_ZSH) > 0) AND (:B1 IS NULL OR ZS.C_WLDWBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B1 ))))) AND ZS.C_ZXZT IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B8 )))) AND NVL(ZS.C_QXBJ, '0') IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B9 )))) AND NVL(ZS.C_GBBJ, '0') IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B10 )))) AND EXISTS (SELECT 1 FROM TW_WLYDZSHXM HXM WHERE HXM.C_ZSH = ZS.C_ZSH AND ((:B11 IS NULL) OR HXM.C_LLLX IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B11 )))))) AND EXISTS (SELECT 1 FROM TW_WLYDZSHXM HXM LEFT JOIN TM_ZZWLCS CS ON HXM.C_CKBM = CS.C_DHDBM LEFT JOIN TW_WLYDZSWLMX WLMX ON WLMX.C_ZSH = HXM.C_ZSH AND WLMX.C_ZSXMH = HXM.C_XMH WHERE HXM.C_ZSH = ZS.C_ZSH AND HXM.C_CKBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B16 )))) AND ((:B15 IS NULL) OR (HXM.C_DDH = :B15 )) AND (CS.C_ZZBM = ZS.C_ZZBM OR CS.C_ZZBM IS NULL) AND ((:B14 IS NULL) OR (FW_GET_BGYBM(ZS.C_ZZBM, HXM.C_CKBM, HXM .C_WLBM, WLMX.C_QWBM, WLMX.C_CWBM, NVL(HXM.C_GYSBM, HXM.C_GYSBM))) IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B14 ))))) AND (:B2 IS NOT NULL OR :B5 = '2' OR (:B5 = '1' AND (HXM.C_JHSFSJ BETWEEN TO_DATE(:B4 || ' 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND TO_DATE(:B3 || ' 23:59:59', 'yyyy-mm-dd hh24:mi:ss')))) AND (:B13 IS NULL OR (CS.C_ABCDFL IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B13 )))) OR CS.C_ABCDFL IS NULL)) AND (:B12 IS NULL OR HXM.C_WLBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B12 ))))))
bs8uw9gjz14tsSELECT C_MC FROM T_ZZZSJ X, T_XQQD Y, T_XQMX Z WHERE Y.C_XQQDXLH = Z.C_XQQDXLH AND Z.C_XQMXXLH = :B1 AND X.C_ZZBM = Y.C_XQDW AND ROWNUM = 1
buzx5wrw4dfgwselect * from gzlctree where dbjobbm = :"SYS_B_0"
cf0wmg632udvhbegin pw_add_wlydpzs(:1, :2, :3, :4, :5); end;
crvmbwtcbfb2dBEGIN PKG_ZZKKC_SUBMIT.PRC_WLYDZSHXM_JY(:1, :2, :3); END;
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d80h6a7665f79 SELECT PZ.C_PZH, PZ.C_ZZBM, PZ.C_YWLBBM, PZ.C_WLYDLXBM C_YDLXBM, PZ.C_PZLB, PZ.C_WLDWBM, PZ.C_KJZQ, TO_CHAR(C_JZRQ, 'YYYY-MM-DD') C_PZRQ, PZ.C_CJR, PZ.C_CJSJ, PZ.C_ZDSCBJ, PZ.C_BZ, ZZ.C_MC C_ZZMC, WLDW.C_WLDWMC, YW.C_YWLBMC, YW.C_DYMBBM, YG.C_YGMC C_ZDR, (SELECT WLPZBH FROM TW_SAPWLPZ WHERE SGWLPZH = PZ.C_PZH AND ROWNUM = 1) C_SAPPZH, BGY.C_BGY, (SELECT DECODE(NVL(DY.C_DYCS, '0'), '0', '', 'R') C_DYZT FROM TW_DYJL DY WHERE DY.C_PZH = PZ.C_PZH AND DY.C_PZLX = '1') C_DYZT, (SELECT YW.C_JZFX FROM TW_YWLBZSJ YW WHERE YW.C_YWLBBM = PZ.C_YWLBBM) C_JZFX FROM TW_WLYDPZ PZ LEFT JOIN T_ZZZSJ ZZ ON ZZ.C_ZZBM = PZ.C_ZZBM LEFT JOIN TW_YWLBZSJ YW ON YW.C_YWLBBM = PZ.C_YWLBBM LEFT JOIN T_YGZSJ YG ON YG.C_YGBM = PZ.C_CJR LEFT JOIN (SELECT C_GYSBM C_WLDWBM, C_MC C_WLDWMC FROM T_GYSZSJ GYS WHERE NOT EXISTS (SELECT 1 FROM T_ZZZSJ WHERE C_ZZBM = GYS.C_GYSBM) UNION SELECT C_KHBM C_WLDWBM, C_MC C_WLDWMC FROM T_KHZSJ UNION SELECT C_ZZBM C_WLDWBM, C_MC C_WLDWMC FROM T_ZZZSJ UNION SELECT C_CBZXBH C_WLDWBM, C_CBZXMC C_WLDWMC FROM T_CBZXZSJ) WLDW ON WLDW.C_WLDWBM = PZ.C_WLDWBM LEFT JOIN (SELECT DISTINCT T1.C_PZH, YG.C_YGMC C_BGY FROM TW_WLYDPZMX T1 LEFT JOIN TW_CKQWZSJ CKQW ON T1.C_CKBM = CKQW.C_CKBM AND T1.C_QWBM = CKQW.C_QWBM LEFT JOIN T_YGZSJ YG ON YG.C_YGBM = CKQW.C_BGYBM1 WHERE EXISTS (SELECT 1 FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B1 ))) FF WHERE FF.COLUMN_VALUE = T1.C_PZH)) BGY ON PZ.C_PZH = BGY.C_PZH WHERE PZ.C_ZZBM = :B2 AND PZ.C_PZH IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B1 )))) ORDER BY C_PZH
d8kbp93qjp4upDELETE /*+ REF_CASCADE_CURSOR */ FROM "SCF2"."TW_WLYDPZMXTEMP_XLH" WHERE "NESTED_TABLE_ID" = :1
dc1gr75uzn5z8SELECT mx.* FROM tw_wlydpzmxtemp mx LEFT JOIN tw_wlydzshxm zs ON mx.c_zsh = zs.c_zsh AND mx.c_zsxmh = zs.c_xmh WHERE mx.c_pzh = :"SYS_B_00" AND mx.c_ckbm = :"SYS_B_01" AND mx.c_wlbm = :"SYS_B_02" AND nvl(mx.c_wltsyt, :"SYS_B_03") = nvl(:"SYS_B_04", :"SYS_B_05") AND NVL(mx.c_gysbm, :"SYS_B_06") = NVL(:"SYS_B_07", :"SYS_B_08") AND NVL(zs.c_gcbgy, :"SYS_B_09") = NVL(:"SYS_B_10", :"SYS_B_11") AND NVL(zs.c_lllx, :"SYS_B_12") = NVL(:"SYS_B_13", :"SYS_B_14") AND :"SYS_B_15" = :"SYS_B_16" ORDER BY mx.c_kczt, mx.c_pc
dgh4xu8hcq1ccSELECT mx.* FROM tw_wlydpzmxtemp mx LEFT JOIN tw_wlydzshxm zs ON mx.c_zsh = zs.c_zsh AND mx.c_zsxmh = zs.c_xmh WHERE mx.c_pzh = :"SYS_B_0" AND mx.c_ckbm = :"SYS_B_1" AND mx.c_wlbm = :"SYS_B_2" AND nvl(mx.c_wltsyt, :"SYS_B_3") = nvl(:"SYS_B_4", :"SYS_B_5") AND :"SYS_B_6" = :"SYS_B_7" ORDER BY mx.c_kczt, mx.c_pc
dn8fxy9kcv288SELECT COUNT(1) FROM TW_PZDYGXHXM A INNER JOIN TW_WLYDPZ B ON A.SCFWLYDPZH = B.C_PZH INNER JOIN TW_YWLBZSJ C ON B.C_YWLBBM = C.C_YWLBBM INNER JOIN TW_WLYDPZMX S ON A.SCFWLYDPZH = S.C_PZH AND A.WLYDPZHH = S.C_PZHH LEFT JOIN TW_ZZJBYYCS P ON B.C_WLDWBM = P.C_ZZBM LEFT JOIN TW_CKZSJ T ON B.C_WLDWBM = T.C_ZZBM AND S.C_WLCKBM = T.C_CKBM WHERE A.SCFWLYDPZH = :B2 AND REGEXP_LIKE(:B1 , B.C_YWLBBM) AND EXISTS (SELECT 1 FROM TW_PZB PZB WHERE PZB.LX = 'A001' AND PZB.BM = B.C_WLDWBM) AND (NVL(P.C_WMSGLBJ, '0') = '0' OR NVL(T.C_WMSGLBJ, '0') = '0') AND NOT EXISTS (SELECT 1 FROM SCF2SAP_SF02_IMPORT ZB, SCF2SAP_SF02_T_MOVEDATA MX WHERE ZB.SESSIONID = MX.SESSIONID AND MX.DOCNR = :B3 )
dps90d8mpnuzvSELECT YGH, CGZXLH, CGZBM, WLBM, WLMC, WLTSYT, WLTSYTMC, WLYS, WLYSMC, XQDW, XQDWMC, NVL(TO_CHAR(XQRQ, 'yyyy-MM-dd'), JHNY || 'TOTAL') XQRQ, JHNY, JHYBM, ( SELECT YGMC FROM TPRIYGZSJ YGZSJ WHERE YGZSJ.YGBM = JHYBM ) JHYMC, SUM(DGSL) DGSL FROM (SELECT '' YGH, CGZXLH, CGZBM, WLBM, (SELECT WLMC FROM TPRIWLZSJ WLZSJ WHERE WLZSJ.WLBM = MX.WLBM ) WLMC, WLYS, (SELECT COLOR.YSMC FROM TBASCOLOR COLOR WHERE COLOR.YSBM = MX.WLYS ) WLYSMC, TSYT WLTSYT, (SELECT C_MC FROM T_SJZD SJZD WHERE SJZD.C_CLBM = MX.TSYT ) WLTSYTMC, XQDW, (SELECT ZZMC FROM TPRIZZZSJ ZZZSJ WHERE ZZZSJ.ZZBM = MX.XQDW ) XQDWMC, XQSL DGSL, XQRQ, NY JHNY, (SELECT YGBM FROM TSYSYHSJQX WHERE FL = WLBM AND YWLX = '18' AND ZZBM = CGZBM ) JHYBM FROM TMRPRDYGXQHZ MX WHERE NY BETWEEN (:B6 ) AND (:B5 ) AND GYSBM = :B4 AND ZSLX = :B3 AND (:B2 = '-1' OR XQDW = :B2 ) AND (MX.WLBM = '' OR MX.WLBM LIKE '%' || :B1 || '%') ) GROUP BY GROUPING SETS((YGH, CGZXLH, CGZBM, XQRQ, WLBM, WLMC, WLTSYT, WLTSYTMC, WLYS, WLYSMC, XQDW, XQDWMC, JHNY, JHYBM), (WLBM, WLTSYT, WLYS, JHNY)) ORDER BY WLBM, XQRQ
f77qar2jsz9fx SELECT NY, TO_CHAR(XQRQ, 'yyyy-mm-dd') XQRQ, CGZBM, XQDW, DHDW, DHD, GYSBM, (SELECT C_MC FROM T_GYSZSJ WHERE C_GYSBM = BZJ.GYSBM) GYSMC, WLBM, (SELECT WL.C_WLMC FROM T_WLZSJ WL WHERE WL.C_WLBM = WLBM) WLMC, XQSL, TSYT, (SELECT ZD.MC FROM TPRISJZD ZD WHERE ZD.CLBM = TSYT) TSYTMC, WLYS, (SELECT YS.YSJC FROM TBASCOLOR YS WHERE YS.YSBM = WLYS) WLYSMC, DQKC, (SYKC - XQSL) SYKC, ZZBM, (SELECT JG.ZZMC FROM TPRIZZJG JG WHERE JG.ZZBM = BZJ.ZZBM) ZZMC, CKBM, (SELECT C_CKMC FROM TW_CKZSJ WHERE C_CKBM = BZJ.CKBM) CKMC, AQKC FROM (SELECT T.NY, T.XQRQ, T.CGZBM, T.XQDW, T.DHDW, T.DHD, T.GYSBM, T.WLBM, T.XQSL, T.TSYT, T.WLYS, (SELECT SUM(ZZ.C_ZMSL) FROM TW_RJZZ ZZ WHERE ZZ.C_ZZBM = ZZK.C_ZZBM AND ZZ.C_CKBM = ZZK.C_CKBM AND ZZ.C_WLBM = T.WLBM AND EXISTS (SELECT 1 FROM TW_PCZSJ PC WHERE PC.C_PC = ZZ.C_PC AND PC.C_ZZBM = ZZ.C_ZZBM AND PC.C_YSGYSBM = T.GYSBM)) DQKC, FW_QRY_SYKC(ZZK.C_ZZBM, ZZK.C_CKBM, T.XQDW, T.WLBM, T.GYSBM, TO_CHAR(T.XQRQ, 'yyyy-mm-dd'), T.NY, 'wms') SYKC, ZZK.C_ZZBM ZZBM, ZZK.C_CKBM CKBM, (SELECT KC.C_AQKCSL FROM TW_GYSAQKCCSWH KC WHERE KC.C_ZZBM = ZZK.C_ZZBM AND ZZK.C_GYSBM = KC.C_GYSBM AND KC.C_GYSBM = T.GYSBM AND KC.C_WLBM = T.WLBM AND ROWNUM = 1) AQKC FROM TMRPRDXQHZ T, TW_CKYGYSDYGX ZZK WHERE 1 = 1 AND EXISTS (SELECT 1 FROM TW_RJZZ RZZ WHERE RZZ.C_ZZBM = ZZK.C_ZZBM AND ZZK.C_CKBM = RZZ.C_CKBM AND EXISTS (SELECT 1 FROM TW_PCZSJ PC WHERE PC.C_PC = RZZ.C_PC AND PC.C_ZZBM = RZZ.C_ZZBM AND PC.C_YSGYSBM = ZZK.C_GYSBM)) AND T.GYSBM = ZZK.C_GYSBM AND T.XQRQ IN (SELECT XQRQ FROM (SELECT HZ.XQRQ FROM TMRPRDXQHZ HZ WHERE TO_CHAR(HZ.XQRQ, 'yyyy-mm-dd') >= TO_CHAR(SYSDATE, 'yyyy-mm-dd') GROUP BY HZ.XQRQ ORDER BY HZ.XQRQ ASC) WHERE ROWNUM <= :B5 ) AND ((:B4 IS NULL) OR ZZK.C_ZZBM = :B4 ) AND ((:B3 IS NULL) OR (ZZK.C_CKBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B3 ))))) AND ((:B2 IS NULL) OR (T.GYSBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B2 ))))) AND ((:B1 IS NULL) OR (T.WLBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B1 )))))) BZJ WHERE BZJ.DQKC IS NOT NULL ORDER BY BZJ.ZZBM ASC, BZJ.CKBM ASC, BZJ.GYSBM ASC, BZJ.WLBM ASC
f8gnxvnu28cqf Select :"SYS_B_000" Lx, :"SYS_B_001" LXMC, Wlbm, (Select Wl.Wlmc From Tpriwlzsj Wl Where Wl.Wlbm = T.Wlbm) Wlmc, Gysbm, (Select Jg.Zzmc From Tprizzjg Jg Where Jg.Zzbm = T.Gysbm) Gysmc, Tsyt, (Select Zd.Mc From Tprisjzd Zd Where Zd.Clbm = T.Tsyt) Tsytmc, Wlys, (Select Color.Ysmc From Tbascolor Color Where Color.Ysbm = T.Wlys) Wlysmc, Xqdw, (Select Jg.Zzmc From Tprizzjg Jg Where Jg.Zzbm = T.Xqdw) Xqdwmc, Gyskc, SNP , sum(nvl(t.Y201306D13, :"SYS_B_002")) as Y201306D13, sum(nvl(t.Y201306D14, :"SYS_B_003")) as Y201306D14, sum(nvl(t.Y201306D15, :"SYS_B_004")) as Y201306D15, sum(nvl(t.Y201306D16, :"SYS_B_005")) as Y201306D16, sum(nvl(t.Y201306D17, :"SYS_B_006")) as Y201306D17, sum(nvl(t.Y201306D18, :"SYS_B_007")) as Y201306D18, sum(nvl(t.Y201306D19, :"SYS_B_008")) as Y201306D19, sum(nvl(t.Y201306D20, :"SYS_B_009")) as Y201306D20, sum(nvl(t.Y201306D21, :"SYS_B_010")) as Y201306D21, sum(nvl(t.Y201306D22, :"SYS_B_011")) as Y201306D22, sum(nvl(t.Y201306D23, :"SYS_B_012")) as Y201306D23, sum(nvl(t.Y201306D24, :"SYS_B_013")) as Y201306D24, sum(nvl(t.Y201306D25, :"SYS_B_014")) as Y201306D25, sum(nvl(t.Y201306D26, :"SYS_B_015")) as Y201306D26, sum(nvl(t.Y201307D01, :"SYS_B_016")) as Y201307D01, sum(nvl(t.Y201307D03, :"SYS_B_017")) as Y201307D03, sum(nvl(t.Y201307D06, :"SYS_B_018&qu ot;)) as Y201307D06 From (Select Hz.Wlbm, Hz.Gysbm , decode(to_char(Hz.Xqrq, :"SYS_B_019"), :"SYS_B_020", SUM(Hz.Xqsl), :"SYS_B_021") Y201306D13, decode(to_char(Hz.Xqrq, :"SYS_B_022"), :"SYS_B_023", SUM(Hz.Xqsl), :"SYS_B_024") Y201306D14, decode(to_char(Hz.Xqrq, :"SYS_B_025"), :"SYS_B_026", SUM(Hz.Xqsl), :"SYS_B_027") Y201306D15, decode(to_char(Hz.Xqrq, :"SYS_B_028"), :"SYS_B_029", SUM(Hz.Xqsl), :"SYS_B_030") Y201306D16, decode(to_char(Hz.Xqrq, :"SYS_B_031"), :"SYS_B_032", SUM(Hz.Xqsl), :"SYS_B_033") Y201306D17, decode(to_char(Hz.Xqrq, :"SYS_B_034"), :"SYS_B_035", SUM(Hz.Xqsl), :"SYS_B_036") Y201306D18, decode(to_char(Hz.Xqrq, :"SYS_B_037"), :"SYS_B_038", SUM(Hz.Xqsl), :"SYS_B_039") Y201306D19, decode(to_char(Hz.Xqrq, :"SYS_B_040"), :"SYS_B_041", SUM(Hz.Xqsl), :"SYS_B_042") Y201306D20, decode(to_char(Hz.Xqrq, :"SYS_B_043"), :"SYS_B_044", SUM(Hz.Xqsl), :"SYS_B_045") Y201306D21, decode(to_char(Hz.Xqrq, :"SYS_B_046"), :"SYS_B_047", SUM(Hz.Xqsl), :"SYS_B_048") Y201306D22, decode(to_char(Hz.Xqrq, :"SYS_B_049"), :"SYS_B_050", SUM(Hz.Xqsl), :"SYS_B_051") Y201306D23, decode(to_char(Hz.Xqrq, :"SYS_B_052"), :"SYS_B_053", SUM(Hz.Xqsl), :&quo t;SYS_B_054") Y201306D24, decode(to_char(Hz.Xqrq, :"SYS_B_055"), :"SYS_B_056", SUM(Hz.Xqsl), :"SYS_B_057") Y201306D25, decode(to_char(Hz.Xqrq, :"SYS_B_058"), :"SYS_B_059", SUM(Hz.Xqsl), :"SYS_B_060") Y201306D26, decode(to_char(Hz.Xqrq, :"SYS_B_061"), :"SYS_B_062", SUM(Hz.Xqsl), :"SYS_B_063") Y201307D01, decode(to_char(Hz.Xqrq, :"SYS_B_064"), :"SYS_B_065", SUM(Hz.Xqsl), :"SYS_B_066") Y201307D03, decode(to_char(Hz.Xqrq, :"SYS_B_067"), :"SYS_B_068", SUM(Hz.Xqsl), :"SYS_B_069") Y201307D06 , Nvl((Select Sum(C_Zmsl) From Tw_Rjzz Rjzz Inner Join Tw_Pczsj Pczsj On Rjzz.C_Zzbm = Pczsj.C_Zzbm And Rjzz.C_Pc = Pczsj.C_Pc Where Pczsj.C_Ysgysbm = Hz.Gysbm And Rjzz.C_Zzbm In (Select Fw.Wlgsbm From Tpriwlgsfw Fw Where Fw.Gysbm = Hz.Gysbm) And Rjzz.C_Wlbm = Hz.Wlbm), :"SYS_B_070") Gyskc, (Select Bz.C_Snp From T_Wlbz Bz Where Bz.C_Zzbm = hz.Xqdw And Bz.C_Wlbm = hz.Wlbm And Bz.C_Gys = hz.Gysbm And Rownum = :"SYS_B_071") Snp, Hz.Tsyt, Hz.Wlys, Hz.Xqdw, Nvl((Select Sum(Xqsl) Xqsl From Tmrpydxqhz b Where B.Ny = :"SYS_B_072" And B.Gysb m = :"SYS_B_073" And B.Xqdw = Hz.Xqdw And B.Wlbm = Hz.Wlbm And B.Cgzxz = Hz.Cgzbm And Nvl(B.Wlys, :"SYS_B_074") = Nvl(Hz.Wlys, :"SYS_B_075") And Nvl(B.Tsyt, :"SYS_B_076") = Nvl(Hz.Tsyt, :"SYS_B_077")), :"SYS_B_078") Dhsl From Tmrprdxqhz Hz Where ((Trim(:"SYS_B_079") Is Null) Or Hz.Xqdw = :"SYS_B_080") And Hz.Ny = :"SYS_B_081" And ((:"SYS_B_082" Is Null) Or hz.Gysbm = :"SYS_B_083") And ((Trim(:"SYS_B_084") Is Null) Or hz.Wlbm In (Select * From Table(Fw_Split_Into_Vc100(:"SYS_B_085")))) And hz.xqrq Is Not Null Group By Wlbm, Gysbm, Xqrq, Tsyt, Wlys, Xqdw, Cgzbm) t Group By Wlbm, Gysbm, Tsyt, Wlys, Xqdw, GYSKC, SNP Union All Select :"SYS_B_086" Lx, :"SYS_B_087" LXMC, Wlbm, (Select Wl.Wlmc From Tpriwlzsj Wl Where Wl.Wlbm = T1.Wlbm) Wlmc, Gysbm, (Select Jg.Zzmc From Tprizzjg Jg Where Jg.Zzbm = T1.Gysbm) Gysmc, Tsyt, (Select Zd.Mc From Tprisjzd Zd Where Zd.Clbm = T1.Tsyt) Tsytmc, Wlys, (Select Color.Ysmc From Tbascolor Color Where Color.Ysbm = T1.Wlys) Wlysmc, Xqdw, (Select Jg.Zzmc From Tprizzjg Jg Where Jg.Zzbm = T1.Xqdw) Xqdwmc, Gyskc, SNP , sum(nvl(t1.Y201306D13, :"SYS_B_088")) as Y201306D13, sum(nvl(t1.Y201306D14, :"SYS_B_089")) as Y201306D14, sum(nvl(t1. Y201306D15, :"SYS_B_090")) as Y201306D15, sum(nvl(t1.Y201306D16, :"SYS_B_091")) as Y201306D16, sum(nvl(t1.Y201306D17, :"SYS_B_092")) as Y201306D17, sum(nvl(t1.Y201306D18, :"SYS_B_093")) as Y201306D18, sum(nvl(t1.Y201306D19, :"SYS_B_094")) as Y201306D19, sum(nvl(t1.Y201306D20, :"SYS_B_095")) as Y201306D20, sum(nvl(t1.Y201306D21, :"SYS_B_096")) as Y201306D21, sum(nvl(t1.Y201306D22, :"SYS_B_097")) as Y201306D22, sum(nvl(t1.Y201306D23, :"SYS_B_098")) as Y201306D23, sum(nvl(t1.Y201306D24, :"SYS_B_099")) as Y201306D24, sum(nvl(t1.Y201306D25, :"SYS_B_100")) as Y201306D25, sum(nvl(t1.Y201306D26, :"SYS_B_101")) as Y201306D26, sum(nvl(t1.Y201307D01, :"SYS_B_102")) as Y201307D01, sum(nvl(t1.Y201307D03, :"SYS_B_103")) as Y201307D03, sum(nvl(t1.Y201307D06, :"SYS_B_104")) as Y201307D06 From (Select Wlbm, Gysbm , decode(to_char(yfhz.Dhrq, :"SYS_B_105"), :"SYS_B_106", SUM(yfhz.qdsl), :"SYS_B_107") Y201306D13, decode(to_char(yfhz.Dhrq, :"SYS_B_108"), :"SYS_B_109", SUM(yfhz.qdsl), :"SYS_B_110") Y201306D14, decode(to_char(yfhz.Dhrq, :"SYS_B_111"), :"SYS_B_112", SUM(yfhz.qdsl), :"SYS_B_113") Y201306D15, decode(to_char(yfhz.Dhrq, :"SYS_B_114"), :"SYS_B_115", SUM(yfhz.qdsl), :"SYS_B_116") Y201306D16, decode(to_char(yf hz.Dhrq, :"SYS_B_117"), :"SYS_B_118", SUM(yfhz.qdsl), :"SYS_B_119") Y201306D17, decode(to_char(yfhz.Dhrq, :"SYS_B_120"), :"SYS_B_121", SUM(yfhz.qdsl), :"SYS_B_122") Y201306D18, decode(to_char(yfhz.Dhrq, :"SYS_B_123"), :"SYS_B_124", SUM(yfhz.qdsl), :"SYS_B_125") Y201306D19, decode(to_char(yfhz.Dhrq, :"SYS_B_126"), :"SYS_B_127", SUM(yfhz.qdsl), :"SYS_B_128") Y201306D20, decode(to_char(yfhz.Dhrq, :"SYS_B_129"), :"SYS_B_130", SUM(yfhz.qdsl), :"SYS_B_131") Y201306D21, decode(to_char(yfhz.Dhrq, :"SYS_B_132"), :"SYS_B_133", SUM(yfhz.qdsl), :"SYS_B_134") Y201306D22, decode(to_char(yfhz.Dhrq, :"SYS_B_135"), :"SYS_B_136", SUM(yfhz.qdsl), :"SYS_B_137") Y201306D23, decode(to_char(yfhz.Dhrq, :"SYS_B_138"), :"SYS_B_139", SUM(yfhz.qdsl), :"SYS_B_140") Y201306D24, decode(to_char(yfhz.Dhrq, :"SYS_B_141"), :"SYS_B_142", SUM(yfhz.qdsl), :"SYS_B_143") Y201306D25, decode(to_char(yfhz.Dhrq, :"SYS_B_144"), :"SYS_B_145", SUM(yfhz.qdsl), :"SYS_B_146") Y201306D26, decode(to_char(yfhz.Dhrq, :"SYS_B_147"), :"SYS_B_148", SUM(yfhz.qdsl), :"SYS_B_149") Y201307D01, decode(to_char(yfhz.Dhrq, :"SYS_B_150"), :"SYS_B_151", SUM(yfhz.qdsl), :"SYS_B_152") Y2013 07D03, decode(to_char(yfhz.Dhrq, :"SYS_B_153"), :"SYS_B_154", SUM(yfhz.qdsl), :"SYS_B_155") Y201307D06, Nvl((Select Sum(C_Zmsl) From Tw_Rjzz Rjzz Inner Join Tw_Pczsj Pczsj On Rjzz.C_Zzbm = Pczsj.C_Zzbm And Rjzz.C_Pc = Pczsj.C_Pc Where Pczsj.C_Ysgysbm = yfhz.Gysbm And Rjzz.C_Zzbm In (Select Fw.Wlgsbm From Tpriwlgsfw Fw Where Fw.Gysbm = yfhz.Gysbm) And Rjzz.C_Wlbm = yfhz.Wlbm), :"SYS_B_156") Gyskc, (Select Bz.C_Snp From T_Wlbz Bz Where Bz.C_Zzbm = yfhz.Xqdwbm And Bz.C_Wlbm = yfhz.Wlbm And Bz.C_Gys = yfhz.Gysbm And Rownum = :"SYS_B_157") Snp , yfhz.Wltsyt Tsyt, yfhz.Wlys, yfhz.Xqdwbm Xqdw, Null Dhsl From tmrpfjjhrdhz yfhz Where ((Trim(:"SYS_B_158") Is Null) Or yfhz.Xqdwbm = :"SYS_B_159") And yfhz.jhny = :"SYS_B_160" And ((:"SYS_B_161" Is Null) Or yfhz.Gysbm = :"SYS_B_162") And ((Trim(:"SYS_B_163") Is Null) Or yfhz.Wlbm In (Select * From Table(Fw_Split_Into_Vc100(:"SYS_B_164")))) And yfhz.dhrq Is Not Null Group By Wlbm, Gysbm, dhrq, wlTsyt, Wlys, Xqdwbm, Cgzbm) t1 Group By Wlbm, Gysbm, Tsyt, Wlys, Xqdw, GYSKC, SNP Union All Select :"SYS_B_165" Lx, :"SYS_B_166" LXMC, Wlbm, (Select Wl.Wlmc From Tpriwlzsj Wl Where Wl.Wlbm = T2.Wlbm) Wlmc, Gysbm, (Select Jg.Zzmc From Tprizzjg Jg Where Jg.Zzbm = T2.Gysbm) Gysmc, Tsyt, (Select Zd.Mc From Tprisjzd Zd Where Zd.Clbm = T2.Tsyt) Tsytmc, Wlys, (Select Color.Ysmc From Tbascolor Color Where Color.Ysbm = T2.Wlys) Wlysmc, Xqdw, (Select Jg.Zzmc From Tprizzjg Jg Where Jg.Zzbm = T2.Xqdw) Xqdwmc, Gyskc, SNP , sum(nvl(t2.Y201306D13, :"SYS_B_167")) as Y201306D13, sum(nvl(t2.Y201306D14, :"SYS_B_168")) as Y201306D14, sum(nvl(t2.Y201306D15, :"SYS_B_169")) as Y201306D15, sum(nvl(t2.Y201306D16, :"SYS_B_170")) as Y201306D16, sum(nvl(t2.Y201306D17, :"SYS_B_171")) as Y201306D17, sum(nvl(t2.Y201306D18, :"SYS_B_172")) as Y201306D18, sum(nvl(t2.Y201306D19, :"SYS_B_173")) as Y201306D19, sum(nvl(t2.Y201306D20, :"SYS_B_174")) as Y201306D20, sum(nvl(t2.Y201306D21, :"SYS_B_175")) as Y201306D21, sum(nvl(t2.Y201306D22, :"SYS_B_176")) as Y201306D22, sum(nvl(t2.Y201306D23, :"SYS_B_177")) as Y201306D23, sum(nvl(t2.Y201306D24, :"SYS_B_178")) as Y201306D24, sum(nvl(t2.Y201306D25, :"SYS_B_179")) as Y201306D25, sum(nvl(t2.Y201306D26, :"SYS_B_180")) as Y201306D26, sum(nvl(t2.Y201307D01, :"SYS_B_181")) as Y201307D01, sum(nvl(t2.Y201307D03, :"SYS_B_182")) as Y201307D03, sum(nvl(t2.Y201307D06, :"SYS_B_183")) as Y201307D06 From (Select Wlbm, Gysbm , decode(to_char(mx.Dhrq, :"SYS_B_184"), :"SYS_B_185", SUM(mx.qdsl), :"SYS_B_186") Y201306D13, decode(to_char(mx.Dhrq, :"SY S_B_187"), :"SYS_B_188", SUM(mx.qdsl), :"SYS_B_189") Y201306D14, decode(to_char(mx.Dhrq, :"SYS_B_190"), :"SYS_B_191", SUM(mx.qdsl), :"SYS_B_192") Y201306D15, decode(to_char(mx.Dhrq, :"SYS_B_193"), :"SYS_B_194", SUM(mx.qdsl), :"SYS_B_195") Y201306D16, decode(to_char(mx.Dhrq, :"SYS_B_196"), :"SYS_B_197", SUM(mx.qdsl), :"SYS_B_198") Y201306D17, decode(to_char(mx.Dhrq, :"SYS_B_199"), :"SYS_B_200", SUM(mx.qdsl), :"SYS_B_201") Y201306D18, decode(to_char(mx.Dhrq, :"SYS_B_202"), :"SYS_B_203", SUM(mx.qdsl), :"SYS_B_204") Y201306D19, decode(to_char(mx.Dhrq, :"SYS_B_205"), :"SYS_B_206", SUM(mx.qdsl), :"SYS_B_207") Y201306D20, decode(to_char(mx.Dhrq, :"SYS_B_208"), :"SYS_B_209", SUM(mx.qdsl), :"SYS_B_210") Y201306D21, decode(to_char(mx.Dhrq, :"SYS_B_211"), :"SYS_B_212", SUM(mx.qdsl), :"SYS_B_213") Y201306D22, decode(to_char(mx.Dhrq, :"SYS_B_214"), :"SYS_B_215", SUM(mx.qdsl), :"SYS_B_216") Y201306D23, decode(to_char(mx.Dhrq, :"SYS_B_217"), :"SYS_B_218", SUM(mx.qdsl), :"SYS_B_219") Y201306D24, decode(to_char(mx.Dhrq, :"SYS_B_220"), :"SYS_B_221", SUM(mx.qdsl), :"SYS_B_222") Y201306D25, decode(to_char(mx.Dhrq, :"SYS_B_223"), :"S YS_B_224", SUM(mx.qdsl), :"SYS_B_225") Y201306D26, decode(to_char(mx.Dhrq, :"SYS_B_226"), :"SYS_B_227", SUM(mx.qdsl), :"SYS_B_228") Y201307D01, decode(to_char(mx.Dhrq, :"SYS_B_229"), :"SYS_B_230", SUM(mx.qdsl), :"SYS_B_231") Y201307D03, decode(to_char(mx.Dhrq, :"SYS_B_232"), :"SYS_B_233", SUM(mx.qdsl), :"SYS_B_234") Y201307D06, Nvl((Select Sum(C_Zmsl) From Tw_Rjzz Rjzz Inner Join Tw_Pczsj Pczsj On Rjzz.C_Zzbm = Pczsj.C_Zzbm And Rjzz.C_Pc = Pczsj.C_Pc Where Pczsj.C_Ysgysbm = qd.Gysbm And Rjzz.C_Zzbm In (Select Fw.Wlgsbm From Tpriwlgsfw Fw Where Fw.Gysbm = qd.Gysbm) And Rjzz.C_Wlbm = Mx.Wlbm), :"SYS_B_235") Gyskc, (Select Bz.C_Snp From T_Wlbz Bz Where Bz.C_Zzbm = mx.Xqdwbm And Bz.C_Wlbm = mx.Wlbm And Bz.C_Gys = qd.Gysbm And Rownum = :"SYS_B_236") Snp , mx.Wltsyt Tsyt, mx.Wlys, mx.Xqdwbm Xqdw, Null Dhsl From tmrpfjjhqd qd, tmrpfjjhmx mx where qd.cgjhh=mx.cgjhh and qd.jhy=mx.jhy and qd.zt=:"SYS_B_237" and mx.cgjhh=:"SYS_B_238" and ((Trim(:"SYS_B_239") Is Null) Or mx.Xqdwbm = :"SYS_B_240") and ((Trim(:"SYS_B_241") Is Null) Or mx.jhy = :"SYS_B_242") And qd.jhny = :"SYS_B_243" And ((:"SYS_B_244" Is Null) Or qd.Gysbm = :"SYS_B_245") And ((Trim(:"SYS_B_246") Is Null) Or mx.Wlbm In (Select * From Table(Fw_Split_Into_Vc100(:"SYS_B_247")))) And mx.dhrq Is Not Null Group By Wlbm, Gysbm, dhrq, wlTsyt, Wlys, Xqdwbm, Cgzbm) t2 Group By Wlbm, Gysbm, Tsyt, Wlys, Xqdw, GYSKC, SNP order by wlbm
fby16d9fz7k72BEGIN PKG_MPS_CHECKREQUIREMENT.PRC_MPS_FLCCCL(:1, :2, :3, :4); END;
fhy8k6wf4unkp SELECT pz.c_zzbm, pz.c_ywlbbm, yw.c_ywlbmc, pz.c_wlydlxbm, pz.c_pzlb, pz.c_wldwbm, pz.c_kjzq, to_char(pz.c_jzrq, :"SYS_B_00") c_jzrq, :"SYS_B_01" c_xlh, mx.c_pzh, mx.c_pzhh, mx.c_ckbm, mx.c_qwbm, mx.c_cwbm, mx.c_pc, mx.c_wlbm, mx.c_kclx, mx.c_kczt, mx.c_jldw, DECODE(C_PZLB, :"SYS_B_02", mx.c_sl, :"SYS_B_03", :"SYS_B_04" - mx.c_sl, :"SYS_B_05") c_sl, mx.c_gyspc, mx.c_wlckbm, mx.c_wlqwbm, mx.c_wlcwbm, mx.c_sfwlbm, mx.c_sfpc, mx.c_ckpzh, mx.c_ckpzhh, mx.c_zsh, mx.c_zsxmh, mx.c_zshh, mx.c_ddh, mx.c_ddhh, mx.c_cxpzh, mx.c_cxpzhh, mx.c_wlydyybm, mx.c_gysbm, G.C_MC c_gysmc, wldw.c_wldwmc, wl.c_wlmc, ck.c_ckmc, yy.c_wlydyymc, zd1.c_mc c_tsyt, zd2.c_mc c_xsqy, ys.c_ysmc, yg.c_ygmc c_cjrxm, bz.c_snp, (Select Hxm.C_Plx From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_Plx, (Select To_Char(Hxm.C_Dhsj, :"SYS_B_06") C_Dhsj From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_Dhsj, (Select Hxm.C_Lllx From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_Lllx, (Select Hxm.C_ZJHGXX From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_ZJHGXX, (Select Hxm.C_SAPPZXX From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_SAPPZXX, (select c_ckmc from tw_ckzsj where c_ckbm=:"SYS_B_07" ) c_wlckmc, pz.c_Bz, to_char(pz.c_cjsj, :"SYS_B_0 8") c_cjsj , dc.wlpzbh C_SAPPZH, MX.C_BZ C_MXBZ FROM TW_WLYDPZMX mx LEFT JOIN TW_WLYDPZ pz ON pz.c_pzh=mx.c_pzh LEFT JOIN T_GYSZSJ G ON G.C_GYSBM = MX.C_GYSBM LEFT JOIN TW_YWLBZSJ yw ON yw.c_ywlbbm=pz.c_ywlbbm LEFT JOIN T_WLZSJ wl on wl.c_wlbm=mx.c_wlbm LEFT JOIN TW_CKZSJ ck on ck.c_ckbm=mx.c_ckbm LEFT JOIN ( select c_gysbm c_wldwbm, c_mc c_wldwmc from t_gyszsj gys where not exists (select * from t_zzzsj where c_zzbm=gys.c_gysbm) union select c_khbm c_wldwbm, c_mc c_wldwmc from t_khzsj union select c_zzbm c_wldwbm, c_mc c_wldwmc from t_zzzsj union select c_cbzxbh c_wldwbm, c_cbzxmc c_wldwmc from t_cbzxzsj ) wldw on wldw.c_wldwbm=pz.c_wldwbm LEFT JOIN TW_WLYDYY yy on yy.c_wlydyybm=mx.c_wlydyybm and yy.c_ywlbbm=pz.c_ywlbbm LEFT JOIN T_SJZD zd1 on zd1.c_clbm=mx.c_wltsyt LEFT JOIN T_SJZD zd2 on zd2.c_clbm=mx.c_xsqy LEFT JOIN T_YSQD ys on ys.c_ysbm=mx.c_wlysbm left join t_ygzsj yg on yg.c_ygbm=pz.c_cjr left join t_wlbz bz on bz.c_zzbm= pz.c_zzbm and bz.c_wlbm=mx.c_wlbm and bz.c_gys = mx.c_gysbm LEFT JOIN tw_sapwlpz dc ON dc.gcbh = pz.c_zzbm AND mx.c_pzhh = dc.sgpzhh AND lpad(dc.sgwlpzh, :"SYS_B_09", :"SYS_B_10") = pz.c_pzh where :"SYS_B_11"=:"SYS_B_12" and pz.c_zzbm=:"SYS_B_13" and mx.c_ckbm in (select * from table(fw_split_into_vc100(:"SYS_B_14"))) and pz.c_ywlbbm in (select * from table(fw_split_into_vc100(:"SYS_B_15"))) and ( :"SYS_B_16"=:" SYS_B_17" ) and pz.c_jzrq between to_date(:"SYS_B_18", :"SYS_B_19") and to_date(:"SYS_B_20", :"SYS_B_21") and pz.c_Cjsj between to_date(:"SYS_B_22", :"SYS_B_23") and to_date(:"SYS_B_24", :"SYS_B_25") Order By Mx.C_Pzh Desc, Mx.C_Pzhh Asc
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g20awzjss95wu SELECT pz.c_zzbm, pz.c_ywlbbm, yw.c_ywlbmc, pz.c_wlydlxbm, pz.c_pzlb, pz.c_wldwbm, pz.c_kjzq, to_char(pz.c_jzrq, :"SYS_B_00") c_jzrq, :"SYS_B_01" c_xlh, mx.c_pzh, mx.c_pzhh, mx.c_ckbm, mx.c_qwbm, mx.c_cwbm, mx.c_pc, mx.c_wlbm, mx.c_kclx, mx.c_kczt, mx.c_jldw, DECODE(C_PZLB, :"SYS_B_02", mx.c_sl, :"SYS_B_03", :"SYS_B_04" - mx.c_sl, :"SYS_B_05") c_sl, mx.c_gyspc, mx.c_wlckbm, mx.c_wlqwbm, mx.c_wlcwbm, mx.c_sfwlbm, mx.c_sfpc, mx.c_ckpzh, mx.c_ckpzhh, mx.c_zsh, mx.c_zsxmh, mx.c_zshh, mx.c_ddh, mx.c_ddhh, mx.c_cxpzh, mx.c_cxpzhh, mx.c_wlydyybm, mx.c_gysbm, G.C_MC c_gysmc, wldw.c_wldwmc, wl.c_wlmc, ck.c_ckmc, yy.c_wlydyymc, zd1.c_mc c_tsyt, zd2.c_mc c_xsqy, ys.c_ysmc, yg.c_ygmc c_cjrxm, bz.c_snp, (Select Hxm.C_Plx From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_Plx, (Select To_Char(Hxm.C_Dhsj, :"SYS_B_06") C_Dhsj From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_Dhsj, (Select Hxm.C_Lllx From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_Lllx, (Select Hxm.C_ZJHGXX From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_ZJHGXX, (Select Hxm.C_SAPPZXX From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_SAPPZXX, (select c_ckmc from tw_ckzsj where c_ckbm=:"SYS_B_07" ) c_wlckmc, pz.c_Bz, to_char(pz.c_cjsj, :"SYS_B_0 8") c_cjsj , dc.wlpzbh C_SAPPZH, MX.C_BZ C_MXBZ FROM TW_WLYDPZMX mx LEFT JOIN TW_WLYDPZ pz ON pz.c_pzh=mx.c_pzh LEFT JOIN T_GYSZSJ G ON G.C_GYSBM = MX.C_GYSBM LEFT JOIN TW_YWLBZSJ yw ON yw.c_ywlbbm=pz.c_ywlbbm LEFT JOIN T_WLZSJ wl on wl.c_wlbm=mx.c_wlbm LEFT JOIN TW_CKZSJ ck on ck.c_ckbm=mx.c_ckbm LEFT JOIN ( select c_gysbm c_wldwbm, c_mc c_wldwmc from t_gyszsj gys where not exists (select * from t_zzzsj where c_zzbm=gys.c_gysbm) union select c_khbm c_wldwbm, c_mc c_wldwmc from t_khzsj union select c_zzbm c_wldwbm, c_mc c_wldwmc from t_zzzsj union select c_cbzxbh c_wldwbm, c_cbzxmc c_wldwmc from t_cbzxzsj ) wldw on wldw.c_wldwbm=pz.c_wldwbm LEFT JOIN TW_WLYDYY yy on yy.c_wlydyybm=mx.c_wlydyybm and yy.c_ywlbbm=pz.c_ywlbbm LEFT JOIN T_SJZD zd1 on zd1.c_clbm=mx.c_wltsyt LEFT JOIN T_SJZD zd2 on zd2.c_clbm=mx.c_xsqy LEFT JOIN T_YSQD ys on ys.c_ysbm=mx.c_wlysbm left join t_ygzsj yg on yg.c_ygbm=pz.c_cjr left join t_wlbz bz on bz.c_zzbm= pz.c_zzbm and bz.c_wlbm=mx.c_wlbm and bz.c_gys = mx.c_gysbm LEFT JOIN tw_sapwlpz dc ON dc.gcbh = pz.c_zzbm AND mx.c_pzhh = dc.sgpzhh AND lpad(dc.sgwlpzh, :"SYS_B_09", :"SYS_B_10") = pz.c_pzh where :"SYS_B_11"=:"SYS_B_12" and pz.c_zzbm=:"SYS_B_13" and mx.c_ckbm in (select * from table(fw_split_into_vc100(:"SYS_B_14"))) and mx.c_wlbm in (select * from table(fw_split_into_vc100(:"SYS_B_15"))) and ( :"SYS_B_16"=:"SY S_B_17" ) and pz.c_jzrq between to_date(:"SYS_B_18", :"SYS_B_19") and to_date(:"SYS_B_20", :"SYS_B_21") and pz.c_Cjsj between to_date(:"SYS_B_22", :"SYS_B_23") and to_date(:"SYS_B_24", :"SYS_B_25") Order By Mx.C_Pzh Desc, Mx.C_Pzhh Asc
gf4thkbsgfd45 SELECT C_CXH, C_CLYS, C_SCSX, C_CLSX, C_XSQY, C_TQSJ, C_NY, C_ZXZL C_DZL, C_DDH, C_SOP, C_TSXX, C_BZ, (SELECT C_MC FROM T_SJZD WHERE C_CLBM = DECODE(C_YWM, 'NO1', C_ZXSCSX, DECODE(C_ZXSCSX || SUBSTR(C_SOP, 0, 3), '0403111', '0403', '0402'))) C_ZXSCSX, DECODE(SUBSTR(C_SOP, 6, 1), '1', 0, (SELECT COUNT(1) FROM T_CLRKSJ A WHERE A.C_CXH = B.C_DPCH AND A.C_YSBM=B.C_CLYSA AND C_RKSL = 1 AND TRUNC(A.C_RQ) BETWEEN (SELECT MIN(C_QSRQ) FROM T_ZYRL WHERE C_NY >= TO_CHAR(ADD_MONTHS(TO_DATE(B.C_NY, 'yyyymm'), -13), 'yyyymm') AND C_JHZZBM = :B4 ) AND (SELECT MAX(C_ZZRQ) FROM T_ZYRL WHERE C_JHZZBM=:B4 AND C_NY = TO_CHAR(ADD_MONTHS(TO_DATE(B.C_NY, 'yyyymm'), -1), 'yyyymm')))) C_SL FROM (SELECT C_CXH, (SELECT YS.C_YSJC FROM T_YSQD YS WHERE C_YSBM = C_CLYS) C_CLYS, C_CLYS C_CLYSA, (SELECT C_MC FROM T_SJZD WHERE C_CLBM = C_SCSX) C_SCSX, (SELECT C_MC FROM T_SJZD WHERE C_CLBM = C_CLSX) C_CLSX, (SELECT C_MC FROM T_SJZD WHERE C_CLBM = C_XSQY) C_XSQY, C_TQSJ, TO_CHAR(P.C_JSSJ - 7, 'yyyymm') C_NY, C_ZXZL, 'c_Tsxx' C_BKPCYY, C_DDH, QD.SOPTAG C_SOP, QD.QYRQ C_TSXX, C_BZ, C_BZ2, C_BZ3, C_SCSX C_ZXSCSX, SUBSTR(:B1 , 0, 3) C_YWM, C_DPCH FROM T_XQMX T, T_XQQD P, (SELECT DISTINCT QYRQ, SCJHCX, SOPTAG FROM T_KPCCXQD) QD WHERE P.C_JHZZBM = :B4 AND ((:B2 <> 0 AND P.C_XQDW = :B3 ) OR :B2 =0) AND T.C_XQQDXLH = P.C_XQQDXLH AND P.C_XQH = :B1 AND T.C_SCJHCXH = QD.SCJHCX AND INSTR(QD.SOPTAG, '0') > 0) B
gj73u9azpmf9t select :"SYS_B_00" Lx, count(:"SYS_B_01") JLS from Tgysjfnltc t where (T.Zt = :"SYS_B_02" or T.Zt = :"SYS_B_03") and exists (select :"SYS_B_04" from Tsysyhsjqx Qx where Qx.Ywlx = :"SYS_B_05" and Qx.Fl = T.Wlbm and Qx.Zzbm = T.Cgzbm and Qx.Ygbm = :"SYS_B_06" and Rownum = :"SYS_B_07") union all select :"SYS_B_08" Lx, count(:"SYS_B_09") JLS from tmrpddfk zb where zb.zt=:"SYS_B_10" and zb.jhy=:"SYS_B_11" union all select :"SYS_B_12" Lx, count(:"SYS_B_13") JLS from tmrpfjjhqd zb where zb.zt=:"SYS_B_14" and zb.jhy=:"SYS_B_15" union all select :"SYS_B_16" Lx, count(:"SYS_B_17") JLS from tmesjjlld zb where zb.clzt = :"SYS_B_18" and zb.jhybm=:"SYS_B_19" union all SELECT :"SYS_B_20" lx, COUNT(:"SYS_B_21") jls FROM tw_wlydzs zs WHERE zs.c_zzbm = :"SYS_B_22" AND EXISTS (SELECT :"SYS_B_23" FROM tw_wlydzshxm hxm WHERE hxm.c_zsh = zs.c_zsh AND (hxm.c_zxzt = :"SYS_B_24" OR hxm.c_zxzt = :"SYS_B_25") AND hxm.c_qxbj = :"SYS_B_26" AND hxm .c_gbbj = :"SYS_B_27" AND hxm.c_lllx = :"SYS_B_28" AND trunc(hxm.c_jhsfsj) >= (trunc(SYSDATE) - :"SYS_B_29") AND trunc(hxm.c_jhsfsj) <= (trunc(SYSDATE) + :"SYS_B_30")) AND zs.c_qxbj = :"SYS_B_31" AND zs.c_gbbj = :"SYS_B_32" AND zs.c_zxzt < :"SYS_B_33" AND zs.c_ywlbbm IN (:"SYS_B_34", :"SYS_B_35") UNION ALL SELECT :"SYS_B_36" lx, COUNT(:"SYS_B_37") jls FROM tw_wlydzs zs WHERE zs.c_zzbm = :"SYS_B_38" AND EXISTS (SELECT :"SYS_B_39" FROM tw_wlydzshxm hxm WHERE hxm.c_zsh = zs.c_zsh AND (hxm.c_zxzt = :"SYS_B_40" OR hxm.c_zxzt = :"SYS_B_41") AND hxm.c_qxbj = :"SYS_B_42" AND hxm.c_gbbj = :"SYS_B_43" AND nvl(hxm.c_lllx, :"SYS_B_44") = :"SYS_B_45" AND trunc(hxm.c_jhs fsj) >= (trunc(SYSDATE) - :"SYS_B_46") AND trunc(hxm.c_jhsfsj) <= (trunc(SYSDATE) + :"SYS_B_47")) AND zs.c_qxbj = :"SYS_B_48" AND zs.c_gbbj = :"SYS_B_49" AND zs.c_zxzt < :"SYS_B_50" AND zs.c_ywlbbm IN (:"SYS_B_51", :"SYS_B_52") UNION ALL SELECT :"SYS_B_53" lx, COUNT(:"SYS_B_54") jls FROM tw_wlydzs zs WHERE zs.c_zzbm = :"SYS_B_55" AND EXISTS (SELECT :"SYS_B_56" FROM tw_wlydzshxm hxm WHERE hxm.c_zsh = zs.c_zsh AND (hxm.c_zxzt = :"SYS_B_57" OR hxm.c_zxzt = :"SYS_B_58") AND hxm.c_qxbj = :"SYS_B_59" AND hxm.c_gbbj = :"SYS_B_60" AND hxm.c_lllx IN (:"SYS_B_61", :"SYS_B_62") AND trunc(hxm.c_jhsfsj) >= (trunc(SYSDATE) - :"SYS_B_63") AND trunc(hxm.c_jhsfsj) <= (trunc(SYSDATE) + :"SYS_B_64")) AND zs.c_qxbj = :"SYS_B_65 " AND zs.c_gbbj = :"SYS_B_66" AND zs.c_zxzt < :"SYS_B_67" AND zs.c_ywlbbm = :"SYS_B_68" UNION ALL SELECT :"SYS_B_69" lx, COUNT(:"SYS_B_70") jls FROM tw_wlydzs zs WHERE zs.c_zzbm = :"SYS_B_71" AND EXISTS (SELECT :"SYS_B_72" FROM tw_wlydzshxm hxm WHERE hxm.c_zsh = zs.c_zsh AND (hxm.c_zxzt = :"SYS_B_73" OR hxm.c_zxzt = :"SYS_B_74") AND hxm.c_qxbj = :"SYS_B_75" AND hxm.c_gbbj = :"SYS_B_76" AND hxm.c_lllx = :"SYS_B_77" AND trunc(hxm.c_jhsfsj) >= (trunc(SYSDATE) - :"SYS_B_78") AND trunc(hxm.c_jhsfsj) <= (trunc(SYSDATE) + :"SYS_B_79")) AND zs.c_qxbj = :"SYS_B_80" AND zs.c_gbbj = :"SYS_B_81" AND zs.c_zxzt < :"SYS_B_82" AND zs.c_ywlbbm = :"SYS_B_83"
gmzva85wy3h8nSELECT COUNT(:"SYS_B_0") c_hs, substr(c_xlh, :"SYS_B_1", :"SYS_B_2") c_wlqz, :"SYS_B_3" c_sftq, :"SYS_B_4" c_tqsj FROM tw_xlhz wl GROUP BY substr(c_xlh, :"SYS_B_5", :"SYS_B_6") ORDER BY c_hs
gp2srf6v3th3rselect s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in (:"SYS_B_0", :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in (:"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5", :"SYS_B_6", :"SYS_B_7")
grwydz59pu6mcselect text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 528,819 113.18 214.44
CPU used when call started 521,811 111.68 211.60
CR blocks created 1,071 0.23 0.43
Cached Commit SCN referenced 3,028 0.65 1.23
Commit SCN cached 4 0.00 0.00
DB time 795,816 170.32 322.72
DBWR checkpoint buffers written 10,648 2.28 4.32
DBWR checkpoints 0 0.00 0.00
DBWR fusion writes 1,506 0.32 0.61
DBWR object drop buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 143 0.03 0.06
DBWR undo block writes 2,186 0.47 0.89
DFO trees parallelized 96 0.02 0.04
Misses for writing mapping 1 0.00 0.00
PX local messages recv'd 520 0.11 0.21
PX local messages sent 520 0.11 0.21
PX remote messages recv'd 252 0.05 0.10
PX remote messages sent 410 0.09 0.17
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 96 0.02 0.04
RowCR - row contention 13 0.00 0.01
RowCR attempts 4,334 0.93 1.76
RowCR hits 10,387 2.22 4.21
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 3 0.00 0.00
SQL*Net roundtrips to/from client 66,135 14.15 26.82
SQL*Net roundtrips to/from dblink 12 0.00 0.00
active txn count during cleanout 1,898 0.41 0.77
application wait time 354 0.08 0.14
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 57,764 12.36 23.42
branch node splits 0 0.00 0.00
buffer is not pinned count 47,941,282 10,260.41 19,440.91
buffer is pinned count 97,887,544 20,949.92 39,694.87
bytes received via SQL*Net from client 8,594,145 1,839.32 3,485.05
bytes received via SQL*Net from dblink 3,236 0.69 1.31
bytes sent via SQL*Net to client 30,634,201 6,556.34 12,422.63
bytes sent via SQL*Net to dblink 2,775 0.59 1.13
calls to get snapshot scn: kcmgss 17,979,510 3,847.98 7,290.96
calls to kcmgas 51,826 11.09 21.02
calls to kcmgcs 878 0.19 0.36
change write time 104 0.02 0.04
cleanout - number of ktugct calls 2,570 0.55 1.04
cleanouts and rollbacks - consistent read gets 838 0.18 0.34
cleanouts only - consistent read gets 766 0.16 0.31
cluster key scan block gets 10,216 2.19 4.14
cluster key scans 2,933 0.63 1.19
cluster wait time 18,092 3.87 7.34
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 1 0.00 0.00
commit batch/immediate requested 1 0.00 0.00
commit cleanout failures: block lost 372 0.08 0.15
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 36 0.01 0.01
commit cleanout failures: cannot pin 5 0.00 0.00
commit cleanouts 18,305 3.92 7.42
commit cleanouts successfully completed 17,892 3.83 7.26
commit immediate performed 1 0.00 0.00
commit immediate requested 1 0.00 0.00
commit txn count during cleanout 1,330 0.28 0.54
concurrency wait time 274 0.06 0.11
consistent changes 172,553 36.93 69.97
consistent gets 322,187,297 68,954.62 130,651.78
consistent gets - examination 34,723,367 7,431.51 14,080.85
consistent gets direct 37 0.01 0.02
consistent gets from cache 322,187,260 68,954.61 130,651.77
current blocks converted for CR 0 0.00 0.00
cursor authentications 434 0.09 0.18
data blocks consistent reads - undo records applied 17,047 3.65 6.91
db block changes 347,054 74.28 140.74
db block gets 474,292 101.51 192.33
db block gets direct 55 0.01 0.02
db block gets from cache 474,237 101.50 192.31
deferred (CURRENT) block cleanout applications 11,171 2.39 4.53
dirty buffers inspected 56 0.01 0.02
enqueue conversions 44,890 9.61 18.20
enqueue releases 1,594,853 341.33 646.74
enqueue requests 1,594,868 341.33 646.74
enqueue timeouts 8 0.00 0.00
enqueue waits 736 0.16 0.30
exchange deadlocks 0 0.00 0.00
execute count 548,921 117.48 222.60
failed probes on index block reclamation 0 0.00 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 1,571,491 336.33 637.26
free buffer requested 1,493,088 319.55 605.47
gc CPU used by this session 5,609 1.20 2.27
gc blocks lost 0 0.00 0.00
gc cr block build time 16 0.00 0.01
gc cr block flush time 15 0.00 0.01
gc cr block receive time 2,039 0.44 0.83
gc cr block send time 56 0.01 0.02
gc cr blocks received 11,931 2.55 4.84
gc cr blocks served 18,775 4.02 7.61
gc current block flush time 5 0.00 0.00
gc current block pin time 12 0.00 0.00
gc current block receive time 88,958 19.04 36.07
gc current block send time 70 0.01 0.03
gc current blocks received 196,712 42.10 79.77
gc current blocks served 24,247 5.19 9.83
gc local grants 1,250,151 267.56 506.95
gc remote grants 16,690 3.57 6.77
gcs messages sent 332,217 71.10 134.72
ges messages sent 7,034 1.51 2.85
global enqueue get time 501 0.11 0.20
global enqueue gets async 2,367 0.51 0.96
global enqueue gets sync 62,667 13.41 25.41
global enqueue releases 60,765 13.00 24.64
heap block compress 964 0.21 0.39
hot buffers moved to head of LRU 346,794 74.22 140.63
immediate (CR) block cleanout applications 1,604 0.34 0.65
immediate (CURRENT) block cleanout applications 677 0.14 0.27
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 4,370 0.94 1.77
index fast full scans (full) 758 0.16 0.31
index fetch by key 23,140,342 4,952.50 9,383.76
index scans kdiixs1 23,218,327 4,969.19 9,415.38
leaf node 90-10 splits 98 0.02 0.04
leaf node splits 183 0.04 0.07
lob reads 29 0.01 0.01
lob writes 101,855 21.80 41.30
lob writes unaligned 101,854 21.80 41.30
logons cumulative 191 0.04 0.08
messages received 11,686 2.50 4.74
messages sent 11,686 2.50 4.74
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 270,143,734 57,816.24 109,547.34
opened cursors cumulative 28,307 6.06 11.48
parse count (failures) 14 0.00 0.01
parse count (hard) 797 0.17 0.32
parse count (total) 29,157 6.24 11.82
parse time cpu 89 0.02 0.04
parse time elapsed 438 0.09 0.18
physical read IO requests 16,705 3.58 6.77
physical read bytes 10,351,607,808 2,215,454.19 4,197,732.28
physical read total IO requests 36,299 7.77 14.72
physical read total bytes 10,671,480,832 2,283,913.51 4,327,445.59
physical read total multi block requests 10,188 2.18 4.13
physical reads 1,263,624 270.44 512.42
physical reads cache 1,262,147 270.13 511.82
physical reads cache prefetch 1,248,011 267.10 506.09
physical reads direct 1,477 0.32 0.60
physical reads direct (lob) 12 0.00 0.00
physical reads direct temporary tablespace 1,440 0.31 0.58
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 6,936 1.48 2.81
physical write bytes 109,346,816 23,402.44 44,341.77
physical write total IO requests 15,705 3.36 6.37
physical write total bytes 233,084,416 49,884.80 94,519.23
physical write total multi block requests 4,625 0.99 1.88
physical writes 13,348 2.86 5.41
physical writes direct 1,495 0.32 0.61
physical writes direct (lob) 29 0.01 0.01
physical writes direct temporary tablespace 1,449 0.31 0.59
physical writes from cache 11,853 2.54 4.81
physical writes non checkpoint 7,090 1.52 2.88
pinned buffers inspected 24 0.01 0.01
pinned cursors current 8 0.00 0.00
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 8,257 1.77 3.35
process last non-idle time 4,679 1.00 1.90
queries parallelized 96 0.02 0.04
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 731,198 156.49 296.51
recursive cpu usage 57,704 12.35 23.40
redo blocks read for recovery 0 0.00 0.00
redo blocks written 75,883 16.24 30.77
redo buffer allocation retries 0 0.00 0.00
redo entries 112,449 24.07 45.60
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,988 0.43 0.81
redo size 36,967,008 7,911.69 14,990.68
redo subscn max counts 1,549 0.33 0.63
redo synch time 220 0.05 0.09
redo synch writes 1,599 0.34 0.65
redo wastage 987,896 211.43 400.61
redo write broadcast ack time 56 0.01 0.02
redo write time 367 0.08 0.15
redo writer latching time 0 0.00 0.00
redo writes 3,585 0.77 1.45
rollback changes - undo records applied 3 0.00 0.00
rollbacks only - consistent read gets 141 0.03 0.06
root node splits 0 0.00 0.00
rows fetched via callback 12,787,004 2,736.68 5,185.32
session connect time 0 0.00 0.00
session cursor cache hits 19,865 4.25 8.06
session logical reads 322,661,583 69,056.13 130,844.11
shared hash latch upgrades - no wait 21,262 4.55 8.62
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 51,424 11.01 20.85
sorts (rows) 34,013,291 7,279.53 13,792.90
sql area evicted 67 0.01 0.03
sql area purged 15 0.00 0.01
summed dirty queue length 58 0.01 0.02
switch current to new buffer 9,393 2.01 3.81
table fetch by rowid 34,024,422 7,281.92 13,797.41
table fetch continued row 6,982 1.49 2.83
table scan blocks gotten 210,998,367 45,157.93 85,563.00
table scan rows gotten 11,023,377,721 2,359,226.59 4,470,145.06
table scans (direct read) 0 0.00 0.00
table scans (long tables) 9 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 5,707,966 1,221.62 2,314.67
total number of times SMON posted 3 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 1 0.00 0.00
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 14,982,684 3,206.60 6,075.70
user I/O wait time 5,201 1.11 2.11
user calls 78,528 16.81 31.84
user commits 2,379 0.51 0.96
user rollbacks 87 0.02 0.04
workarea executions - onepass 1 0.00 0.00
workarea executions - optimal 68,591 14.68 27.81
write clones created in background 0 0.00 0.00
write clones created in foreground 1 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 1.1E+12 1.1E+12
session cursor cache count 1,193,486 1,195,455
session uga memory 1.5E+14 1.5E+14
opened cursors current 978 1,136
workarea memory allocated 0 4,873
logons current 53 53
session uga memory max 3.1E+11 3.1E+11
session pga memory 4.1E+11 4.1E+11

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
PUB_HIS_DATA_01 9,808 2 3.39 125.82 0 0 0 0.00
WMS_DATA_01 1,625 0 18.65 2.92 1,125 0 1 0.00
LOGIC_INDX_01 1,420 0 7.49 11.47 113 0 0 0.00
MRP_DATA_01 311 0 4.66 1.08 980 0 0 0.00
BAS_DATA 51 0 6.47 1.59 1,058 0 23 0.87
MPS_DATA_01 444 0 7.59 8.53 635 0 0 0.00
BAS_INDX_01 800 0 3.25 1.00 158 0 0 0.00
USERS 325 0 5.32 1.00 503 0 0 0.00
SYSAUX 139 0 3.31 1.00 630 0 0 0.00
SYSTEM 390 0 4.18 1.00 237 0 2 0.00
PMS_INDX_01 559 0 1.11 1.00 52 0 0 0.00
WMS_INDEX_01 335 0 4.90 1.00 254 0 0 0.00
PMS_DATA_01 33 0 3.03 1.00 472 0 0 0.00
UNDOTBS2 3 0 3.33 1.00 432 0 2 0.00
TEMP 110 0 18.64 13.25 103 0 0 0.00
MPS_INDX_01 103 0 4.08 1.00 91 0 0 0.00
LOGIC_DATA_01 98 0 2.35 1.00 73 0 0 0.00
MRP_INDX_01 140 0 5.86 1.00 20 0 0 0.00
UNDOTBS1 1 0 0.00 1.00 0 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
BAS_DATA /oracle/oradata/DFACSCF/BAS_DATA_01.dbf 8 0 6.25 1.00 172 0 0 0.00
BAS_DATA /oracle/oradata/DFACSCF/BAS_DATA_02.dbf 6 0 3.33 2.17 136 0 0 0.00
BAS_DATA /oracle/oradata/DFACSCF/BAS_DATA_03.dbf 3 0 13.33 3.00 104 0 0 0.00
BAS_DATA /oracle/oradata/DFACSCF/BAS_DATA_04.dbf 15 0 8.67 1.87 175 0 3 0.00
BAS_DATA /oracle/oradata/DFACSCF/BAS_DATA_05.dbf 18 0 4.44 1.22 133 0 0 0.00
BAS_DATA /oracle/oradata/DFACSCF/BAS_DATA_06.dbf 1 0 10.00 1.00 338 0 20 1.00
BAS_INDX_01 /oracle/oradata/DFACSCF/BAS_INDX_01_P01.dbf 378 0 3.31 1.00 50 0 0 0.00
BAS_INDX_01 /oracle/oradata/DFACSCF/BAS_INDX_01_P02.dbf 422 0 3.20 1.00 108 0 0 0.00
LOGIC_DATA_01 /oracle/oradata/DFACSCF/LOGIC_DATA_01_P01.dbf 37 0 0.81 1.00 44 0 0 0.00
LOGIC_DATA_01 /oracle/oradata/DFACSCF/LOGIC_DATA_01_P02.dbf 61 0 3.28 1.00 29 0 0 0.00
LOGIC_INDX_01 /oracle/oradata/DFACSCF/LOGIC_INDX_01_P01.dbf 1,404 0 7.49 11.59 66 0 0 0.00
LOGIC_INDX_01 /oracle/oradata/DFACSCF/LOGIC_INDX_01_P03.dbf 16 0 7.50 1.00 47 0 0 0.00
MPS_DATA_01 /oracle/oradata/DFACSCF/MPS_DATA_01_P01.dbf 42 0 4.52 17.24 338 0 0 0.00
MPS_DATA_01 /oracle/oradata/DFACSCF/MPS_DATA_01_P02.dbf 196 0 6.17 3.62 80 0 0 0.00
MPS_DATA_01 /oracle/oradata/DFACSCF/MPS_DATA_01_P03.dbf 20 0 5.00 38.20 89 0 0 0.00
MPS_DATA_01 /oracle/oradata/DFACSCF/MPS_DATA_01_P04.dbf 186 0 10.05 8.54 128 0 0 0.00
MPS_INDX_01 /oracle/oradata/DFACSCF/MPS_INDX_01_P01.dbf 78 0 3.85 1.00 82 0 0 0.00
MPS_INDX_01 /oracle/oradata/DFACSCF/MPS_INDX_01_P02.dbf 25 0 4.80 1.00 9 0 0 0.00
MRP_DATA_01 /oracle/oradata/DFACSCF/MRP_DATA_01_P01.dbf 39 0 3.85 1.15 161 0 0 0.00
MRP_DATA_01 /oracle/oradata/DFACSCF/MRP_DATA_01_P02.dbf 46 0 5.43 1.00 222 0 0 0.00
MRP_DATA_01 /oracle/oradata/DFACSCF/MRP_DATA_01_P03.dbf 19 0 3.16 1.00 123 0 0 0.00
MRP_DATA_01 /oracle/oradata/DFACSCF/MRP_DATA_01_P04.dbf 106 0 5.09 1.19 328 0 0 0.00
MRP_DATA_01 /oracle/oradata/DFACSCF/MRP_DATA_01_P05.dbf 101 0 4.46 1.00 146 0 0 0.00
MRP_INDX_01 /oracle/oradata/DFACSCF/MRP_INDX_01_P01.dbf 61 0 5.74 1.00 8 0 0 0.00
MRP_INDX_01 /oracle/oradata/DFACSCF/MRP_INDX_01_P02.dbf 79 0 5.95 1.00 12 0 0 0.00
PMS_DATA_01 /oracle/oradata/DFACSCF/PMS_DATA_01_P01.dbf 5 0 6.00 1.00 132 0 0 0.00
PMS_DATA_01 /oracle/oradata/DFACSCF/PMS_DATA_01_P02.dbf 8 0 3.75 1.00 115 0 0 0.00
PMS_DATA_01 /oracle/oradata/DFACSCF/PMS_DATA_01_P03.dbf 6 0 1.67 1.00 0 0 0 0.00
PMS_DATA_01 /oracle/oradata/DFACSCF/PMS_DATA_01_P04.dbf 10 0 3.00 1.00 160 0 0 0.00
PMS_DATA_01 /oracle/oradata/DFACSCF/PMS_DATA_01_P05.dbf 4 0 0.00 1.00 65 0 0 0.00
PMS_INDX_01 /oracle/oradata/DFACSCF/PMS_INDX_01_P01.dbf 281 0 1.03 1.00 30 0 0 0.00
PMS_INDX_01 /oracle/oradata/DFACSCF/PMS_INDX_01_P02.dbf 278 0 1.19 1.00 22 0 0 0.00
PUB_HIS_DATA_01 /oracle/oradata/DFACSCF/PUB_HIS_DATA_01_P01.dbf 2,110 0 3.59 122.71 0 0 0 0.00
PUB_HIS_DATA_01 /oracle/oradata/DFACSCF/PUB_HIS_DATA_01_P02.dbf 1,962 0 3.57 126.78 0 0 0 0.00
PUB_HIS_DATA_01 /oracle/oradata/DFACSCF/PUB_HIS_DATA_01_P03.dbf 1,956 0 3.40 125.64 0 0 0 0.00
PUB_HIS_DATA_01 /oracle/oradata/DFACSCF/PUB_HIS_DATA_01_P04.dbf 1,818 0 3.22 127.64 0 0 0 0.00
PUB_HIS_DATA_01 /oracle/oradata/DFACSCF/PUB_HIS_DATA_01_P05.dbf 1,962 0 3.14 126.67 0 0 0 0.00
SYSAUX /oracle/oradata/DFACSCF/sysaux01.dbf 139 0 3.31 1.00 630 0 0 0.00
SYSTEM /oracle/oradata/DFACSCF/system01.dbf 390 0 4.18 1.00 237 0 2 0.00
TEMP /oracle/oradata/DFACSCF/temp01.dbf 110 0 18.64 13.25 103 0 0  
UNDOTBS1 /oracle/oradata/DFACSCF/undotbs01.dbf 1 0 0.00 1.00 0 0 0 0.00
UNDOTBS2 /oracle/oradata/DFACSCF/undotbs02.dbf 3 0 3.33 1.00 432 0 2 0.00
USERS /oracle/oradata/DFACSCF/users01.dbf 325 0 5.32 1.00 503 0 0 0.00
WMS_DATA_01 /oracle/oradata/DFACSCF/WMS_DATA_01.dbf 926 0 19.41 2.62 472 0 1 0.00
WMS_DATA_01 /oracle/oradata/DFACSCF/WMS_DATA_02.dbf 699 0 17.65 3.32 653 0 0 0.00
WMS_INDEX_01 /oracle/oradata/DFACSCF/WMS_INDEX _02.dbf 177 0 3.79 1.00 103 0 0 0.00
WMS_INDEX_01 /oracle/oradata/DFACSCF/WMS_INDEX.dbf 158 0 6.14 1.00 151 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 838,621 100 322,616,158 1,262,144 11,853 0 0 28


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 0 343 1853 2661 943650 2661  
E 0 0 375 1276 28139 943650 28139  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 688 0.10 82,431 2.38 4,052,486,126
D 1,376 0.20 164,862 1.85 3,154,407,833
D 2,064 0.29 247,293 1.51 2,566,058,567
D 2,752 0.39 329,724 1.30 2,211,808,365
D 3,440 0.49 412,155 1.17 2,002,062,452
D 4,128 0.59 494,586 1.10 1,876,281,492
D 4,816 0.69 577,017 1.06 1,800,320,743
D 5,504 0.78 659,448 1.03 1,754,095,721
D 6,192 0.88 741,879 1.01 1,725,348,688
D 6,880 0.98 824,310 1.00 1,706,741,844
D 7,024 1.00 841,563 1.00 1,704,003,789
D 7,568 1.08 906,741 0.99 1,693,643,030
D 8,256 1.18 989,172 0.99 1,683,492,590
D 8,944 1.27 1,071,603 0.98 1,674,991,541
D 9,632 1.37 1,154,034 0.98 1,667,075,961
D 10,320 1.47 1,236,465 0.97 1,658,957,750
D 11,008 1.57 1,318,896 0.97 1,650,175,697
D 11,696 1.67 1,401,327 0.96 1,640,426,019
D 12,384 1.76 1,483,758 0.96 1,629,442,220
D 13,072 1.86 1,566,189 0.95 1,616,932,691
D 13,760 1.96 1,648,620 0.94 1,602,751,932

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
99.79 17,847 38

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)
B 1,024 828 188.75 0.00 0.00 0.00 0.00 104,850
E 1,024 821 204.57 4.76 2.33 100.00 0.00 104,850

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 50,979 50,979 0 0
64K 128K 1,074 1,074 0 0
128K 256K 4,116 4,116 0 0
256K 512K 100 100 0 0
512K 1024K 7,794 7,794 0 0
1M 2M 4,131 4,131 0 0
2M 4M 89 89 0 0
4M 8M 29 29 0 0
8M 16M 148 148 0 0
16M 32M 127 127 0 0
32M 64M 5 4 1 0

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 Count
128 0.13 7,646,710.85 3,686,582.33 67.00 59,178
256 0.25 7,646,710.85 221,378.14 97.00 9
512 0.50 7,646,710.85 67,080.83 99.00 0
768 0.75 7,646,710.85 67,080.83 99.00 0
1,024 1.00 7,646,710.85 54,620.08 99.00 0
1,229 1.20 7,646,710.85 18,644.41 100.00 0
1,434 1.40 7,646,710.85 18,644.41 100.00 0
1,638 1.60 7,646,710.85 18,644.41 100.00 0
1,843 1.80 7,646,710.85 18,644.41 100.00 0
2,048 2.00 7,646,710.85 18,644.41 100.00 0
3,072 3.00 7,646,710.85 18,644.41 100.00 0
4,096 4.00 7,646,710.85 18,644.41 100.00 0
6,144 6.00 7,646,710.85 18,644.41 100.00 0
8,192 8.00 7,646,710.85 18,644.41 100.00 0

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)
656 0.59 119 6,193 5,464,657 1.00 25,209 2.04 440,623
768 0.70 228 9,211 5,468,468 1.00 21,398 1.73 440,888
880 0.80 339 12,479 5,472,009 1.00 17,857 1.44 441,133
992 0.90 448 19,109 5,475,045 1.00 14,821 1.20 441,344
1,104 1.00 559 25,887 5,477,492 1.00 12,374 1.00 441,520
1,216 1.10 670 30,536 5,479,364 1.00 10,502 0.85 441,661
1,328 1.20 781 36,201 5,480,754 1.00 9,112 0.74 441,772
1,440 1.30 892 40,802 5,481,808 1.00 8,058 0.65 441,861
1,552 1.41 1,003 44,459 5,482,636 1.00 7,230 0.58 441,934
1,664 1.51 1,113 48,297 5,483,293 1.00 6,573 0.53 441,996
1,776 1.61 1,222 51,345 5,483,809 1.00 6,057 0.49 442,046
1,888 1.71 1,332 53,973 5,484,212 1.00 5,654 0.46 442,087
2,000 1.81 1,443 56,053 5,484,534 1.00 5,332 0.43 442,122
2,112 1.91 1,553 58,134 5,484,807 1.00 5,059 0.41 442,152
2,224 2.01 1,663 61,140 5,485,050 1.00 4,816 0.39 442,179

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2,048 0.25 4,620,983 3,173,707,037
4,096 0.50 3,371,224 2,014,302,866
6,144 0.75 3,103,007 1,764,836,713
8,192 1.00 3,034,132 1,704,003,778
10,240 1.25 3,002,274 1,677,250,919
12,288 1.50 2,973,449 1,650,498,059
14,336 1.75 2,950,087 1,626,812,407
16,384 2.00 2,948,569 1,612,498,775

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)
16 0.50 0 0 0 0
32 1.00 0 0 0 0
48 1.50 0 0 0 0
64 2.00 0 0 0 0
80 2.50 0 0 0 0
96 3.00 0 0 0 0
112 3.50 0 0 0 0
128 4.00 0 0 0 0
144 4.50 0 0 0 0
160 5.00 0 0 0 0
176 5.50 0 0 0 0
192 6.00 0 0 0 0
208 6.50 0 0 0 0
224 7.00 0 0 0 0
240 7.50 0 0 0 0
256 8.00 0 0 0 0
272 8.50 0 0 0 0
288 9.00 0 0 0 0
304 9.50 0 0 0 0
320 10.00 0 0 0 0

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 block 26 0 1
undo header 2 0 0

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) 1 1 0 1 3 3,469.00
TM-DML 6,421 6,421 0 378 0 0.44
PS-PX Process Reservation 657 657 0 201 0 0.67
TT-Tablespace 244 244 0 60 0 0.58
CF-Controlfile Transaction 10,329 10,329 0 14 0 0.64
WF-AWR Flush 39 39 0 21 0 0.38
HW-Segment High Water Mark 189 188 1 18 0 0.39
FB-Format Block 27 27 0 15 0 0.47
TA-Instance Undo 16 16 0 16 0 0.38
JQ-Job Queue 41 34 7 2 0 1.00
UL-User-defined 4 4 0 2 0 1.00
FU-DBFUS 1 1 0 1 0 2.00
TO-Temp Object 13 13 0 4 0 0.25
JS-Job Scheduler (job run lock - synchronize) 4 4 0 2 0 0.50
PW-Buffer Cache PreWarm (flush prewarm buffers) 2 2 0 2 0 0.50
US-Undo Segment 3 3 0 1 0 1.00
IR-Instance Recovery 11 11 0 2 0 0.00
AF-Advisor Framework (task serialization) 14 14 0 1 0 0.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
4 2.15 4,980 1,944 5 26.4/56.1 0/0 0/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
13-6ÔÂ 09:26 111 514 1,155 3 42 0/0 0/0/0/0/0/0
13-6ÔÂ 09:16 253 173 1,944 3 46 0/0 0/0/0/0/0/0
13-6ÔÂ 09:06 478 653 1,344 3 36 0/0 0/0/0/0/0/0
13-6ÔÂ 08:56 102 333 744 2 26 0/0 0/0/0/0/0/0
13-6ÔÂ 08:46 122 780 144 3 42 0/0 0/0/0/0/0/0
13-6ÔÂ 08:36 70 169 0 2 56 0/0 0/0/0/0/0/0
13-6ÔÂ 08:26 71 366 0 2 46 0/0 0/0/0/0/0/0
13-6ÔÂ 08:16 799 1,663 0 5 36 0/0 0/0/0/0/0/0
13-6ÔÂ 08:06 145 329 0 3 39 0/0 0/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
ASM db client latch 3,158 0.00   0 0  
ASM network background latch 2 0.00   0 0  
AWR Alerted Metric Element list 20,864 0.00   0 0  
Consistent RBA 3,588 0.00   0 0  
FOB s.o list latch 1,493 0.00   0 0  
JS broadcast add buf latch 42,426 0.00   0 0  
JS broadcast drop buf latch 42,428 0.00   0 0  
JS broadcast load blnc latch 42,291 0.00   0 0  
JS mem alloc latch 11 0.00   0 0  
JS queue access latch 11 0.00   0 0  
JS queue state obj latch 1,522,428 0.00   0 0  
KCL gc element parent latch 903,766 0.02 0.01 0 772 0.13
KJC message pool free list 17,719 0.04 0.00 0 6,455 0.02
KJCT flow control latch 234,556 0.01 0.00 0 0  
KMG MMAN ready and startup request latch 1,557 0.00   0 0  
KSXR large replies 4 0.00   0 0  
KTF sga latch 4,626 0.00   0 1,294 0.08
KWQMN job cache list latch 360 0.00   0 0  
KWQP Prop Status 4 0.00   0 0  
MQL Tracking Latch 0     0 93 0.00
Memory Management Latch 0     0 1,557 0.00
OS process 393 0.00   0 0  
OS process allocation 1,820 0.00   0 0  
OS process: request allocation 98 0.00   0 0  
PL/SQL warning settings 1,240 0.00   0 0  
SGA IO buffer pool latch 309 0.00   0 9,981 0.00
SQL memory manager latch 10 0.00   0 1,555 0.00
SQL memory manager workarea list latch 1,508,399 0.00 0.00 0 0  
Shared B-Tree 171 0.00   0 0  
active checkpoint queue latch 5,089 0.00   0 0  
active service list 341,306 0.00   0 46,232 0.00
archive control 106 0.00   0 0  
begin backup scn array 32 0.00   0 0  
business card 192 0.00   0 0  
cache buffer handles 10,110 0.00   0 0  
cache buffers chains 614,453,338 0.17 0.00 0 5,060,888 0.00
cache buffers lru chain 198,939 0.01 0.00 0 5,079,074 0.01
cache table scan latch 0     0 10,092 0.00
channel handle pool latch 120 0.00   0 0  
channel operations parent latch 686,019 0.00 0.00 0 0  
checkpoint queue latch 205,790 0.02 0.00 0 15,317 0.00
client/application info 719 0.00   0 0  
compile environment latch 191 0.00   0 0  
dictionary lookup 1 0.00   0 0  
dml lock allocation 12,859 0.02 0.00 0 0  
dummy allocation 382 0.00   0 0  
enqueue hash chains 3,249,775 0.00 0.00 0 205 0.00
enqueues 3,169,314 0.00 0.00 0 0  
error message lists 464 0.00   0 0  
event group latch 49 0.00   0 0  
file cache latch 1,302 0.00   0 0  
gcs opaque info freelist 201,814 0.00 0.00 0 0  
gcs partitioned table hash 2,649,755 0.00   0 1,236,217 0.00
gcs remastering latch 53,371 0.00   0 0  
gcs resource freelist 42,210 0.00 0.00 0 17,131 0.00
gcs resource hash 2,045,965 0.01 0.01 0 4 0.00
gcs resource scan list 8 0.00   0 0  
gcs shadows freelist 3,470 0.00   0 30,130 0.00
ges caches resource lists 11,708 0.00   0 59,943 0.00
ges deadlock list 1,464 0.00   0 0  
ges domain table 116,721 0.00   0 0  
ges enqueue table freelist 125,970 0.00 0.00 0 0  
ges group table 173,246 0.00   0 0  
ges process hash list 3,419 0.00   0 0  
ges process parent latch 253,594 0.00   0 0  
ges process table freelist 98 0.00   0 0  
ges resource hash list 197,593 0.01 0.14 0 4,231 0.02
ges resource scan list 35 0.00   0 0  
ges resource table freelist 7,077 0.00   0 0  
ges timeout list 1,436 0.00   0 965 0.00
global KZLD latch for mem in SGA 8 0.00   0 0  
global tx hash mapping 6,561 0.00   0 0  
hash table column usage latch 484 0.00   0 228,733 0.00
hash table modification latch 193 0.00   0 0  
internal temp table object number allocation latc 4 0.00   0 0  
interrupt manipulation 807 0.00   0 0  
job workq parent latch 0     0 74 0.00
job_queue_processes parameter latch 112 0.00   0 0  
kks stats 1,661 0.00   0 0  
kokc descriptor allocation latch 5,494 0.00   0 0  
ksuosstats global area 331 0.00   0 0  
ktm global data 25 0.00   0 0  
kwqbsn:qsga 169 0.00   0 0  
lgwr LWN SCN 4,125 0.10 0.00 0 0  
library cache 370,310 0.00 0.00 0 289 0.00
library cache load lock 1,620 0.00   0 0  
library cache lock 1,316,385 0.00 0.00 0 0  
library cache lock allocation 1,692 0.00   0 0  
library cache pin 186,087 0.00 0.00 0 0  
library cache pin allocation 1,564 0.00   0 0  
list of block allocation 951 0.00   0 0  
loader state object freelist 158 0.00   0 0  
logminer context allocation 2 0.00   0 0  
longop free list parent 9 0.00   0 9 0.00
message pool operations parent latch 1,392 0.00   0 0  
messages 186,424 0.01 0.00 0 0  
mostly latch-free SCN 4,159 0.79 0.00 0 0  
multiblock read objects 57,328 0.00   0 0  
name-service memory objects 14,598 0.00   0 0  
name-service namespace bucket 56,117 0.00   0 0  
name-service pending queue 6,714 0.00   0 0  
name-service request queue 60,021 0.00   0 0  
ncodef allocation latch 75 0.00   0 0  
object queue header heap 1,345 0.00   0 5,995 0.00
object queue header operation 3,032,604 0.00 0.00 0 0  
object stats modification 10 0.00   0 0  
parallel query alloc buffer 2,552 0.00   0 0  
parallel query stats 393 0.00   0 0  
parallel txn reco latch 688 0.00   0 0  
parameter list 82 0.00   0 0  
parameter table management 396 0.00   0 0  
post/wait queue 3,138 0.00   0 1,849 0.22
process allocation 48,151 0.00   0 49 0.00
process group creation 98 0.00   0 0  
process queue 1,043 0.00   0 0  
process queue reference 18,559 0.00   0 1,702 0.00
qmn task queue latch 1,005 0.60 0.00 0 0  
query server freelists 866 0.00   0 0  
queued dump request 23,361 0.00   0 0  
redo allocation 11,839 0.03 0.00 0 112,460 0.01
redo copy 0     0 112,464 0.02
redo writing 19,136 0.00   0 0  
resmgr group change latch 238 0.00   0 0  
resmgr:active threads 366 0.00   0 0  
resmgr:actses change group 150 0.00   0 0  
resmgr:free threads list 356 0.00   0 0  
resmgr:resource group CPU method 149 0.00   0 0  
resmgr:schema config 10 0.00   0 0  
row cache objects 5,130,332 0.03 0.00 0 3 0.00
rules engine rule set statistics 200 0.00   0 0  
sequence cache 50,315 0.00   0 0  
session allocation 9,428 0.00   0 0  
session idle bit 160,053 0.00   0 0  
session state list latch 416 0.00   0 0  
session switching 320 0.00   0 0  
session timer 1,586 0.00   0 0  
shared pool 89,132 0.00 0.00 0 0  
shared pool sim alloc 1 0.00   0 0  
shared pool simulator 3,364 0.00   0 0  
simulator hash latch 38,260,133 0.00 0.00 0 0  
simulator lru latch 0     0 38,091,751 0.31
slave class 13 0.00   0 0  
slave class create 52 3.85 1.00 0 0  
sort extent pool 238 0.00   0 0  
state object free list 4 0.00   0 0  
statistics aggregation 20,832 0.00   0 0  
temp lob duration state obj allocation 3 0.00   0 0  
temporary table state object allocation 7 0.00   0 0  
threshold alerts latch 425 0.00   0 0  
transaction allocation 1,625 0.00   0 0  
transaction branch allocation 7,412 0.00   0 0  
undo global data 19,746 0.00   0 0  
user lock 108 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 614,453,338 1,067,086 428 1,066,695 0 0 0
gcs resource hash 2,045,965 276 2 274 0 0 0
KCL gc element parent latch 903,766 192 2 190 0 0 0
ges resource hash list 197,593 14 2 12 0 0 0
slave class create 52 2 2 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclrwrite 0 2 1
KCL gc element parent latch kclwrt 0 1 0
KCL gc element parent latch kclzcl 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 592 500
cache buffers chains kcbrls: kslbegin 0 158 253
cache buffers chains kclwrt 0 6 0
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 2 2
cache buffers chains kcbgcur: kslbegin 0 2 1
cache buffers chains kcbzib: multi-block read: nowait 0 1 0
cache buffers chains kcbzwb 0 1 0
cache buffers chains kclbla 0 1 0
cache buffers chains kclcls_3 0 1 0
gcs resource hash kjblocalfile_nolock 0 2 0
ges resource hash list kjrmas1: lookup master node 0 2 0
slave class create ksvcreate 0 2 0

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
SCF2 BAS_DATA TPRIZZJG   TABLE 175,216,032 54.30
SCF2 LOGIC_DATA_01 IDX_TW_MOVEDATA_001   INDEX 29,302,048 9.08
SCF2 USERS IDX_TW_SAPWLPZ_001   INDEX 28,319,888 8.78
SCF2 WMS_DATA_01 SYSTASKBO   TABLE 14,052,768 4.36
SCF2 BAS_DATA SAP2SCF_SF03_EXPORT_MSEG   TABLE 6,577,504 2.04

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 1,233,990 97.65
SCF2 WMS_DATA_01 SYSFLOWSTATUS   TABLE 4,569 0.36
SCF2 MPS_DATA_01 T_CLRKSJ   TABLE 2,740 0.22
SCF2 MPS_DATA_01 T_XQMX   TABLE 842 0.07
SCF2 WMS_INDEX_01 IDX_TW_WLYDZSHXM_001   INDEX 211 0.02

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SCF2 WMS_DATA_01 TW_XLHZ   TABLE 2 50.00
SYS SYSAUX WRH$_SYSSTAT_PK 2775_22123 INDEX PARTITION 2 50.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
SCF2 BAS_DATA MONITERTAB   TABLE 20 95.24
SCF2 WMS_DATA_01 TW_WLYDZS   TABLE 1 4.76

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
SCF2 BAS_DATA TNOTEMONITOR   TABLE 1,386 11.62
SCF2 WMS_DATA_01 TW_XLHZ   TABLE 667 5.59
SCF2 WMS_DATA_01 TW_WLYDZS   TABLE 585 4.90
SCF2 BAS_DATA MONITERTAB   TABLE 405 3.39
SCF2 MPS_DATA_01 T_L_CXJCDMX   TABLE 400 3.35

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
SCF2 BAS_DATA SAP2SCF_SF03_EXPORT_MSEG   TABLE 31,403 15.96
SCF2 WMS_DATA_01 SYSTASKBO   TABLE 27,188 13.82
SCF2 USERS TMRPRDYGXQHZ   TABLE 25,808 13.12
SCF2 WMS_DATA_01 TW_WLYDPZMX   TABLE 25,661 13.04
SCF2 MRP_INDX_01 INDX_RDXQHZ_002   INDEX 9,055 4.60

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 83 1.20 0   3 1
dc_database_links 27 0.00 0   0 3
dc_files 423 0.00 0   0 47
dc_global_oids 4,366 0.27 0   1 317
dc_histogram_data 47,462 0.08 0   0 18,380
dc_histogram_defs 13,363 2.42 0   0 12,892
dc_object_grants 48 43.75 0   0 332
dc_object_ids 21,379 0.38 0   1 2,869
dc_objects 5,095 5.95 0   12 2,587
dc_profiles 49 0.00 0   0 1
dc_rollback_segments 1,958 0.00 0   0 45
dc_segments 5,826 0.55 0   6 2,961
dc_sequences 1,084 5.35 0   1,084 27
dc_tablespace_quotas 2 100.00 0   2 4
dc_tablespaces 810,735 0.00 0   0 21
dc_usernames 1,626 0.06 0   0 48
dc_users 822,385 0.00 0   0 81
outstanding_alerts 158 91.14 0   0 19

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 7 1 0
dc_global_oids 13 0 0
dc_histogram_defs 324 0 0
dc_object_ids 83 0 0
dc_objects 327 0 0
dc_segments 42 9 0
dc_sequences 2,168 47 0
dc_tablespace_quotas 4 1 0
dc_tablespaces 1 0 0
dc_usernames 1 0 0
outstanding_alerts 310 144 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 84 9.52 2,795 0.54 6 0
CLUSTER 30 0.00 55 0.00 0 0
INDEX 7 0.00 38 0.00 0 0
SQL AREA 17,284 63.18 558,762 0.42 381 100
TABLE/PROCEDURE 2,778 10.26 50,547 1.59 218 0
TRIGGER 5 0.00 5 0.00 0 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 55 0 0 0 0
INDEX 38 0 0 0 0
TABLE/PROCEDURE 7,716 296 4 154 0

Back to Library Cache Statistics
Back to Top

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
B Other 108.25   1.97 2.83 11 11 55 55
  Freeable 72.25 0.00 2.49 7.03 39   29 29
  PL/SQL 13.85 2.04 0.26 1.77 13 13 54 54
  SQL 7.01 4.20 0.17 0.23 1 40 42 25
E Other 115.77   2.10 2.85 11 11 55 55
  Freeable 74.88 0.00 2.34 6.70 39   32 32
  PL/SQL 13.98 2.14 0.26 1.77 13 13 54 54
  SQL 12.55 9.35 0.30 0.83 5 90 42 29

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 7,348,420,608  
Fixed Size 2,114,248  
Redo Buffers 14,659,584  
Variable Size 3,372,223,800  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared ASH buffers 15.50 15.50 0.00
shared CCursor 36.24 40.39 11.46
shared KGH: NO ACCESS 55.93 55.93 0.00
shared KGLS heap 12.27 13.23 7.84
shared KQR L PO 20.30 20.99 3.42
shared PCursor 19.66 21.77 10.73
shared db_block_hash_buckets 45.00 45.00 0.00
shared free memory 361.05 316.99 -12.20
shared gcs resources 144.65 144.65 0.00
shared gcs shadows 86.61 86.61 0.00
shared ges big msg buffers 14.72 14.72 0.00
shared ges enqueues 13.71 13.71 0.00
shared library cache 30.99 31.90 2.94
shared sql area 118.25 150.10 26.93
streams Sender info 0.97 0.97 0.00
streams free memory 31.83 31.83 0.00
  buffer_cache 7,008.00 7,008.00 0.00
  fixed_sga 2.02 2.02 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Coordinator 80,000 0 0
QMON Slaves 10,000 0 0

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 Apply

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 Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 0 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 391,481 808,911 936114 936114


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /oracle/orabase/admin/DFACSCF/adump   
background_dump_dest /oracle/orabase/admin/DFACSCF/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.5.0   
control_files /oracle/oradata/DFACSCF/control01.ctl, /oracle/oradata/DFACSCF/control02.ctl, /oracle/oradata/DFACSCF/control03.ctl   
core_dump_dest /oracle/orabase/admin/DFACSCF/cdump   
cursor_sharing FORCE   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 128   
db_name DFACSCF   
dispatchers (PROTOCOL=TCP) (SERVICE=DFACSCFXDB)   
instance_number 2   
job_queue_processes 10   
log_archive_dest_state_1 ENABLE   
nls_language SIMPLIFIED CHINESE   
nls_territory CHINA   
open_cursors 1000   
optimizer_index_caching 75   
optimizer_index_cost_adj 25   
pga_aggregate_target 1073741824   
processes 1000   
remote_listener LISTENERS_DFACSCF   
remote_login_passwordfile EXCLUSIVE   
service_names DFACSCF   
session_cached_cursors 100   
sessions 1105   
sga_max_size 10737418240   
sga_target 8589934592   
shared_pool_reserved_size 104857600   
spfile /oracle/oradata/DFACSCF/spfileDFACSCF.ora   
thread 2   
undo_management AUTO   
undo_tablespace UNDOTBS2   
user_dump_dest /oracle/orabase/admin/DFACSCF/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 3,193 0.68 1.29
acks for commit broadcast(logical) 3,337 0.71 1.35
broadcast msgs on commit(actual) 3,580 0.77 1.45
broadcast msgs on commit(logical) 3,582 0.77 1.45
broadcast msgs on commit(wasted) 116 0.02 0.05
broadcast on commit wait time(ms) 713 0.15 0.29
broadcast on commit waits 1,006 0.22 0.41
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 13,454 2.88 5.46
gcs ast xid 0 0.00 0.00
gcs blocked converts 5,882 1.26 2.39
gcs blocked cr converts 15,503 3.32 6.29
gcs compatible basts 35 0.01 0.01
gcs compatible cr basts (global) 889 0.19 0.36
gcs compatible cr basts (local) 96,162 20.58 39.00
gcs cr basts to PIs 0 0.00 0.00
gcs cr serve without current lock 0 0.00 0.00
gcs dbwr flush pi msgs 1,155 0.25 0.47
gcs dbwr write request msgs 2,285 0.49 0.93
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 663 0.14 0.27
gcs immediate (null) converts 3,090 0.66 1.25
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 30,007 6.42 12.17
gcs indirect ast 12,840 2.75 5.21
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 355 0.08 0.14
gcs msgs process time(ms) 2,661 0.57 1.08
gcs msgs received 94,467 20.22 38.31
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 3 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 1 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 0 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 5,502 1.18 2.23
gcs side channel msgs logical 213,363 45.66 86.52
gcs stale cr 0 0.00 0.00
gcs undo cr 60 0.01 0.02
gcs write notification msgs 80 0.02 0.03
gcs writes refused 6 0.00 0.00
ges msgs process time(ms) 72 0.02 0.03
ges msgs received 7,038 1.51 2.85
global posts dropped 0 0.00 0.00
global posts queue time 0 0.00 0.00
global posts queued 0 0.00 0.00
global posts requested 0 0.00 0.00
global posts sent 0 0.00 0.00
implicit batch messages received 2,304 0.49 0.93
implicit batch messages sent 5,240 1.12 2.12
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 5,422 1.16 2.20
messages queue sent actual 21,702 4.64 8.80
messages queue sent logical 101,141 21.65 41.01
messages received actual 66,973 14.33 27.16
messages received logical 101,504 21.72 41.16
messages sent directly 76,341 16.34 30.96
messages sent indirectly 93,245 19.96 37.81
messages sent not implicit batched 16,461 3.52 6.68
messages sent pbatched 167,216 35.79 67.81
msgs causing lmd to send msgs 2,697 0.58 1.09
msgs causing lms(s) to send msgs 3,763 0.81 1.53
msgs received queue time (ms) 322 0.07 0.13
msgs received queued 101,504 21.72 41.16
msgs sent queue time (ms) 27,798 5.95 11.27
msgs sent queue time on ksxp (ms) 57,503 12.31 23.32
msgs sent queued 100,969 21.61 40.94
msgs sent queued on ksxp 121,736 26.05 49.37
number of ges deadlock detected 0 0.00 0.00
process batch messages received 12,686 2.72 5.14
process batch messages sent 28,925 6.19 11.73


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 17,804
CURRENT Block Requests 962
Data Block Requests 17,804
Undo Block Requests 60
TX Block Requests 196
Current Results 18,566
Private results 78
Zero Results 122
Disk Read Results 0
Fail Results 0
Fairness Down Converts 3,005
Fairness Clears 0
Free GC Elements 0
Flushes 81
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 37
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 24,227 100.00 0.00 0.00 0.00 0.00
Flushes 28 64.29 32.14 3.57 0.00 0.00
Writes 1,506 15.67 80.88 3.45 0.00 0.00


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 11,015 99.40 0.60 0.00 196,283 99.92 0.01 0.06
1 Others 545 99.45 0.55 0.00 432 100.00 0.00 0.00
1 undo header 347 97.98 2.02 0.00 8 100.00 0.00 0.00
1 undo block 39 89.74 10.26 0.00 0      


Back to Top

End of Report