WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
DFACSCF1001502775DFACSCF1110.2.0.5.0YESDFAC-550B

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2212913-6ÔÂ -13 07:59:5773 13.7
End Snap:2213113-6ÔÂ -13 09:17:4977 14.9
Elapsed:  77.87 (mins)  
DB Time:  121.03 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 6,528M 6,528MStd Block Size: 8K
Shared Pool Size: 1,616M 1,616MLog Buffer: 14,316K

Load Profile

Per SecondPer Transaction
Redo size: 7,978.58 16,186.96
Logical reads: 55,277.09 112,146.25
Block changes: 61.94 125.66
Physical reads: 7.24 14.70
Physical writes: 2.53 5.12
User calls: 26.46 53.67
Parses: 6.81 13.81
Hard parses: 0.08 0.16
Sorts: 14.42 29.25
Logons: 0.04 0.07
Executes: 82.52 167.41
Transactions: 0.49 

% Blocks changed per Read: 0.11Recursive Call %: 80.56
Rollback per transaction %: 3.78Rows per Sort: 403.10

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.99In-memory Sort %: 100.00
Library Hit %: 99.69Soft Parse %: 98.82
Execute to Parse %: 91.75Latch Hit %: 99.96
Parse CPU to Parse Elapsd %: 22.68% Non-Parse CPU: 99.98

Shared Pool Statistics

BeginEnd
Memory Usage %: 73.64 74.13
% SQL with executions>1: 96.34 95.35
% Memory for SQL w/exec>1: 94.68 92.97

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  5,808  80.0 
db file sequential read 22,102 37 2 .5User I/O
gc cr multi block request 19,314 16 1 .2Cluster
gc cr block 2-way 12,445 15 1 .2Cluster
gc current block 2-way 12,292 14 1 .2Cluster

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 9.20 18.66
Global Cache blocks served: 44.63 90.55
GCS/GES messages received: 72.57 147.24
GCS/GES messages sent: 21.70 44.02
DBWR Fusion writes: 0.68 1.38
Estd Interconnect traffic (KB) 449.07 

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

Buffer access - local cache %: 99.97
Buffer access - remote cache %: 0.02
Buffer access - disk %: 0.01

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0
Avg global cache cr block receive time (ms): 2.3
Avg global cache current block receive time (ms): 3.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.7
Avg global cache cr block flush time (ms): 1.0
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.0
Avg global cache current block flush time (ms): 1.4

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
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: 66.81
% of indirect sent messages: 24.61
% of flow controlled messages: 8.58


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 7,246.97 99.79
DB CPU 5,807.53 79.97
PL/SQL execution elapsed time 15.79 0.22
parse time elapsed 10.93 0.15
hard parse elapsed time 6.28 0.09
hard parse (sharing criteria) elapsed time 2.86 0.04
hard parse (bind mismatch) elapsed time 1.00 0.01
sequence load elapsed time 0.64 0.01
PL/SQL compilation elapsed time 0.57 0.01
repeated bind elapsed time 0.25 0.00
connection management call elapsed time 0.11 0.00
failed parse elapsed time 0.03 0.00
DB time 7,261.89  
background elapsed time 71.99  
background cpu time 37.51  

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,808   79.97
Cluster 57,827 0 50 1 0.69
User I/O 23,453   40 2 0.55
Other 57,405 93 14 0 0.20
System I/O 23,785   12 0 0.16
Commit 1,554   3 2 0.04
Concurrency 3,083   2 1 0.03
Network 122,472   2 0 0.03
Application 1,230   0 0 0.00
Configuration 15   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
db file sequential read 22,102   37 2 9.60
gc cr multi block request 19,314   16 1 8.39
gc cr block 2-way 12,445   15 1 5.40
gc current block 2-way 12,292   14 1 5.34
reliable message 363 2 12 34 0.16
control file parallel write 1,679   4 3 0.73
log file parallel write 3,336   4 1 1.45
gc cr grant 2-way 10,900 0 3 0 4.73
control file sequential read 18,770   3 0 8.15
log file sync 1,554   3 2 0.67
db file scattered read 1,187   2 2 0.52
SQL*Net more data from client 2,538   1 0 1.10
gc current grant busy 1,912   1 0 0.83
row cache lock 2,078   1 0 0.90
os thread startup 25   1 34 0.01
gc current grant 2-way 699   1 1 0.30
enq: WF - contention 18   1 44 0.01
SQL*Net more data to client 15,301   1 0 6.64
CGS wait for IPC msg 44,027 100 0 0 19.12
library cache lock 781   0 0 0.34
db file parallel read 29   0 10 0.01
gc cr block busy 84   0 3 0.04
IPC send completion sync 280 100 0 1 0.12
gcs log flush sync 215   0 1 0.09
enq: TM - contention 284   0 0 0.12
enq: PS - contention 124   0 1 0.05
SQL*Net break/reset to client 946   0 0 0.41
SQL*Net message to client 104,633   0 0 45.43
CSS initialization 12   0 8 0.01
direct path read temp 24   0 4 0.01
gc current block busy 29   0 3 0.01
direct path sync 34   0 3 0.01
ksxr poll remote instances 7,964 67 0 0 3.46
DFS lock handle 232   0 0 0.10
latch free 4   0 16 0.00
direct path read 17   0 3 0.01
PX Deq: reap credit 3,688 99 0 0 1.60
gc current multi block request 143   0 0 0.06
rdbms ipc reply 177   0 0 0.08
direct path write temp 28   0 1 0.01
library cache pin 49   0 1 0.02
direct path write 32   0 1 0.01
enq: TT - contention 73   0 0 0.03
enq: CF - contention 15   0 1 0.01
enq: FB - contention 19   0 1 0.01
PX Deq Credit: send blkd 35 69 0 0 0.02
gc buffer busy 8   0 1 0.00
LGWR wait for redo copy 47   0 0 0.02
KJC: Wait for msg sends to complete 1   0 8 0.00
latch: cache buffers chains 148   0 0 0.06
CSS operation: query 6   0 1 0.00
PX Deq: Signal ACK 33 27 0 0 0.01
CSS operation: action 25   0 0 0.01
enq: HW - contention 15   0 0 0.01
enq: TA - contention 15   0 0 0.01
enq: TO - contention 5   0 1 0.00
enq: JS - job run lock - synchronize 4   0 1 0.00
enq: TD - KTF dump entries 8   0 0 0.00
wait for scn ack 2   0 1 0.00
enq: DR - contention 4   0 0 0.00
gc current block unknown 1   0 1 0.00
latch: library cache 1   0 1 0.00
enq: MW - contention 3   0 0 0.00
enq: AF - task serialization 1   0 0 0.00
enq: TX - index contention 1   0 0 0.00
CSS group membership query 2   0 0 0.00
latch: ges resource hash list 1   0 0 0.00
PX qref latch 2 100 0 0 0.00
SQL*Net message from client 104,651   161,037 1539 45.44
gcs remote message 404,726 70 9,109 23 175.74
DIAG idle wait 23,282   4,562 196 10.11
ges remote message 65,315 88 4,562 70 28.36
PX Idle Wait 1,924 93 4,561 2371 0.84
virtual circuit status 156 100 4,558 29218 0.07
Streams AQ: waiting for messages in the queue 483 100 4,553 9426 0.21
Streams AQ: qmn slave idle wait 165   4,536 27489 0.07
Streams AQ: qmn coordinator idle wait 356 47 4,536 12740 0.15
Streams AQ: waiting for time management or cleanup tasks 16 100 4,493 280794 0.01
jobq slave wait 304 98 885 2911 0.13
PX Deq: Execution Msg 610 31 0 1 0.26
i/o slave wait 41   0 3 0.02
PX Deq: Msg Fragment 350 50 0 0 0.15
PX Deq: Parse Reply 42 40 0 1 0.02
PX Deq: Join ACK 42 40 0 1 0.02
PX Deq: Execute Reply 41 39 0 0 0.02
class slave wait 10   0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 356 100 0 0 0.15

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 52,965 93 9 0 23.00
control file parallel write 1,679   4 3 0.73
log file parallel write 3,336   4 1 1.45
control file sequential read 10,357   3 0 4.50
os thread startup 25   1 34 0.01
gc cr block 2-way 213   0 1 0.09
gc current block 2-way 134   0 1 0.06
enq: TM - contention 264   0 0 0.11
library cache lock 15   0 0 0.01
row cache lock 5   0 1 0.00
latch: cache buffers chains 2   0 0 0.00
rdbms ipc message 81,193 76 49,812 613 35.26
gcs remote message 404,710 70 9,109 23 175.73
DIAG idle wait 23,282   4,562 196 10.11
ges remote message 65,326 88 4,562 70 28.37
pmon timer 1,571 100 4,558 2901 0.68
Streams AQ: qmn slave idle wait 165   4,536 27489 0.07
Streams AQ: qmn coordinator idle wait 356 47 4,536 12740 0.15
Streams AQ: waiting for time management or cleanup tasks 16 100 4,493 280794 0.01
smon timer 16 100 4,483 280203 0.01
Streams AQ: RAC qmn coordinator idle wait 356 100 0 0 0.15

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 104,523
AVG_IDLE_TIME 362,319
AVG_IOWAIT_TIME 489
AVG_SYS_TIME 11,694
AVG_USER_TIME 92,686
BUSY_TIME 837,322
IDLE_TIME 2,899,684
IOWAIT_TIME 4,953
SYS_TIME 94,722
USER_TIME 742,600
LOAD 4
OS_CPU_WAIT_TIME 969,600
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 517,705,728
VM_OUT_BYTES 708,030,464
PHYSICAL_MEMORY_BYTES 16,139,681,792
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 7,068.30 5,658.40 31,717 252,454,130
SYS$USERS 192.40 148.30 2,031 5,849,241
SYS$BACKGROUND 0.10 0.10 93 50,280
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 22816 38 1917 1 0 0 65537 0
SYS$USERS 407 1 868 0 0 0 56848 1
SYS$BACKGROUND 230 0 297 1 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
4,807 3,873 8 600.90 66.20 7t3bfw6kvdunq JDBC Thin Client SELECT a.sessionid, decode(a.s...
796 653 92 8.66 10.97 b6cmfd9gfjmqd JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
284 227 17 16.72 3.91 0gshzbuaxq8pz JDBC Thin Client SELECT SQ.*, ZZ.C_MC C_SHDW, Y...
184 149 95 1.93 2.53 2baqvamkstzv2 JDBC Thin Client begin pw_add_yjzsscpz(:1, :2, ...
133 109 94 1.41 1.83 5wssrc6y3ypuf JDBC Thin Client update SCF2SAP_SF17_GOODSMVT_I...
106 91 6 17.69 1.46 5utqvfqf8513d JDBC Thin Client BEGIN pkg_ifc_mes.prc_ifc_zsll...
90 74 524 0.17 1.24 7f039z54cu4rx JDBC Thin Client SELECT * FROM TW_WLYDPZMX T WH...
71 56 592 0.12 0.97 4tanzh2jp8tsn JDBC Thin Client select BO from SYSTASKBO where...
65 52 22 2.95 0.89 546whxffw127p JDBC Thin Client SELECT WLBM, WLMC, TSYT, TSYTM...
64 53 61 1.04 0.88 a08ad1gmt11q9 JDBC Thin Client SELECT * FROM TW_WLYDPZMX WHER...

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,873 4,807 8 484.18 66.70 66.20 7t3bfw6kvdunq JDBC Thin Client SELECT a.sessionid, decode(a.s...
653 796 92 7.10 11.25 10.97 b6cmfd9gfjmqd JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
227 284 17 13.38 3.92 3.91 0gshzbuaxq8pz JDBC Thin Client SELECT SQ.*, ZZ.C_MC C_SHDW, Y...
149 184 95 1.56 2.56 2.53 2baqvamkstzv2 JDBC Thin Client begin pw_add_yjzsscpz(:1, :2, ...
109 133 94 1.16 1.88 1.83 5wssrc6y3ypuf JDBC Thin Client update SCF2SAP_SF17_GOODSMVT_I...
91 106 6 15.14 1.56 1.46 5utqvfqf8513d JDBC Thin Client BEGIN pkg_ifc_mes.prc_ifc_zsll...
74 90 524 0.14 1.27 1.24 7f039z54cu4rx JDBC Thin Client SELECT * FROM TW_WLYDPZMX T WH...
56 71 592 0.09 0.96 0.97 4tanzh2jp8tsn JDBC Thin Client select BO from SYSTASKBO where...
53 64 61 0.86 0.91 0.88 a08ad1gmt11q9 JDBC Thin Client SELECT * FROM TW_WLYDPZMX WHER...
52 65 22 2.38 0.90 0.89 546whxffw127p JDBC Thin Client SELECT WLBM, WLMC, TSYT, TSYTM...

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
113,236,084 92 1,230,827.00 43.84 653.45 796.35 b6cmfd9gfjmqd JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
38,185,266 8 4,773,158.25 14.78 3873.40 4807.21 7t3bfw6kvdunq JDBC Thin Client SELECT a.sessionid, decode(a.s...
19,428,853 36 539,690.36 7.52 48.95 59.75 393drhftjj4dt JDBC Thin Client BEGIN Pw_Add_Impmmdsap(:1, :2,...
19,421,045 47 413,213.72 7.52 48.79 59.38 dn8fxy9kcv288 JDBC Thin Client SELECT COUNT(1) FROM TW_PZDYGX...
16,185,280 592 27,340.00 6.27 55.90 70.74 4tanzh2jp8tsn JDBC Thin Client select BO from SYSTASKBO where...
7,251,277 6 1,208,546.17 2.81 90.84 106.15 5utqvfqf8513d JDBC Thin Client BEGIN pkg_ifc_mes.prc_ifc_zsll...
6,848,703 58 118,081.09 2.65 22.20 28.22 ayv0vhg5vbcg1 JDBC Thin Client SELECT SQ.*, (SELECT ZZ.CKMC F...
4,572,035 95 48,126.68 1.77 148.62 183.76 2baqvamkstzv2 JDBC Thin Client begin pw_add_yjzsscpz(:1, :2, ...
3,948,872 1 3,948,872.00 1.53 49.15 58.25 7rppp6v5grwqg JDBC Thin Client BEGIN PRC_MPS_IN_NO4STORAGE(:1...
3,842,684 22 174,667.45 1.49 52.27 64.99 546whxffw127p JDBC Thin Client SELECT WLBM, WLMC, TSYT, TSYTM...
3,794,197 1 3,794,197.00 1.47 11.59 24.57 03y9rpv36g51k JDBC Thin Client SELECT T1.C_PZH SCFWLYDPZH, T1...
3,625,684 17 213,275.53 1.40 227.39 284.26 0gshzbuaxq8pz JDBC Thin Client SELECT SQ.*, ZZ.C_MC C_SHDW, Y...
3,139,354 1 3,139,354.00 1.22 10.40 12.14 66txdn782z8c4 JDBC Thin Client INSERT INTO T_CLRKJHMX (C_CLRK...
3,128,208 94 33,278.81 1.21 108.97 132.88 5wssrc6y3ypuf JDBC Thin Client update SCF2SAP_SF17_GOODSMVT_I...

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
5,681 1 5,681.00 16.78 11.59 24.57 03y9rpv36g51k JDBC Thin Client SELECT T1.C_PZH SCFWLYDPZH, T1...
1,601 92 17.40 4.73 653.45 796.35 b6cmfd9gfjmqd JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
1,105 1 1,105.00 3.26 49.15 58.25 7rppp6v5grwqg JDBC Thin Client BEGIN PRC_MPS_IN_NO4STORAGE(:1...
939 17 55.24 2.77 227.39 284.26 0gshzbuaxq8pz JDBC Thin Client SELECT SQ.*, ZZ.C_MC C_SHDW, Y...
845 22 38.41 2.50 52.27 64.99 546whxffw127p JDBC Thin Client SELECT WLBM, WLMC, TSYT, TSYTM...
247 8 30.88 0.73 3873.40 4807.21 7t3bfw6kvdunq JDBC Thin Client SELECT a.sessionid, decode(a.s...
215 1 215.00 0.64 10.40 12.14 66txdn782z8c4 JDBC Thin Client INSERT INTO T_CLRKJHMX (C_CLRK...
164 1 164.00 0.48 17.30 20.86 36xv24xb072uq JDBC Thin Client BEGIN pkg_ifc_mes.prc_ifc_rxjh...
66 95 0.69 0.19 148.62 183.76 2baqvamkstzv2 JDBC Thin Client begin pw_add_yjzsscpz(:1, :2, ...
64 35 1.83 0.19 14.03 18.39 44m843r687ymt JDBC Thin Client BEGIN pkg_ifc_mes.IFC_MES_SCF_...

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 dv30311zhn1b4 JDBC Thin Client SELECT MAX(C_JSSJ), MAX(XS.C_B...
1,152 1,152 1.00 0.00 0.00 1cjy8v3c0agny   select sys_nc_oid$ from xdb.xd...
1,049 1,049 1.00 0.00 0.00 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
935 0 0.00 0.00 0.00 akq326dzntuj6 JDBC Thin Client select distinct sessionid from...
935 0 0.00 0.00 0.00 bm2vxqs97nq4d JDBC Thin Client select distinct sessionid from...
934 88 0.09 0.00 0.01 c4y84wmu5yjph JDBC Thin Client select distinct sessionid from...
752 752 1.00 0.00 0.00 3c1kubcdjnppq   update sys.col_usage$ set equa...
718 718 1.00 0.00 0.00 4tw9rjrv9rusc JDBC Thin Client insert into MES2SCF_MF05_HIS (...
718 718 1.00 0.00 0.00 c1289gydrn00t JDBC Thin Client insert into MES2SCF_MF05 (id, ...
670 670 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.62 1cjy8v3c0agny   select sys_nc_oid$ from xdb.xd...
1,049 1,049 3.30 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
935 935 2.94 akq326dzntuj6 JDBC Thin Client select distinct sessionid from...
935 935 2.94 bm2vxqs97nq4d JDBC Thin Client select distinct sessionid from...
934 934 2.94 c4y84wmu5yjph JDBC Thin Client select distinct sessionid from...
718 718 2.26 4tw9rjrv9rusc JDBC Thin Client insert into MES2SCF_MF05_HIS (...
718 718 2.26 c1289gydrn00t JDBC Thin Client insert into MES2SCF_MF05 (id, ...
670 670 2.11 2tq3dknsjum6d JDBC Thin Client SELECT :"SYS_B_0" FROM DUAL...
592 592 1.86 4tanzh2jp8tsn JDBC Thin Client select BO from SYSTASKBO where...
588 588 1.85 buzx5wrw4dfgw JDBC Thin Client select * from gzlctree where d...
524 524 1.65 2ghbsfvq9mn3v   INSERT /*+ NO_PARTIAL_COMMIT R...
524 524 1.65 d8kbp93qjp4up   DELETE /*+ REF_CASCADE_CURSOR ...
444 444 1.40 0s90x7g3jd9sk JDBC Thin Client SELECT INN.*, YG.C_YGMC C_BGYX...
383 383 1.20 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
383 383 1.20 g00cj285jmgsw   update sys.mon_mods$ set inser...
329 329 1.03 4spc68yrsgfnw JDBC Thin Client INSERT INTO tw_sapwlpz (jkbh, ...
321 321 1.01 9qmza4gnx5rj6 JDBC Thin Client insert into tw_pzdygxhxm(scfwl...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
94,641,648   5.59 00m9b8xca8hvp   SELECT file_type, ROUND (mb_us...
12,249,998 4 0.72 0km2mucn8vsau JDBC Thin Client INSERT INTO TCGBJDWLCBMX (gysb...
4,327,495 8 0.26 5jxwda6s8nvc7 MMON_SLAVE select tablespace_id, rfno, al...
2,311,933 196 0.14 3utzy3g1xn2g3 JDBC Thin Client SELECT HXM.C_ZSH, ZS.C_ZSLY, H...
2,280,420 51 0.13 d80h6a7665f79 JDBC Thin Client SELECT PZ.C_PZH, PZ.C_ZZBM, PZ...
1,582,528 94 0.09 5wssrc6y3ypuf JDBC Thin Client update SCF2SAP_SF17_GOODSMVT_I...
1,547,512 4 0.09 10xj8nynmpqtq   SELECT dbin.db_name, dbin.inst...
1,483,497 9 0.09 0dmptzyb086u6 JDBC Thin Client SELECT DISTINCT ZS.C_ZSH, ZS.C...
1,446,277 1 0.09 03y9rpv36g51k JDBC Thin Client SELECT T1.C_PZH SCFWLYDPZH, T1...
1,241,955 92 0.07 b6cmfd9gfjmqd JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
1,075,900 2 0.06 0vwa9n600yvgm   SELECT sum(delta_cpu_time) as ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
557   00m9b8xca8hvp   SELECT file_type, ROUND (mb_us...
249 4 0km2mucn8vsau JDBC Thin Client INSERT INTO TCGBJDWLCBMX (gysb...
173 8 5jxwda6s8nvc7 MMON_SLAVE select tablespace_id, rfno, al...
36 4 10xj8nynmpqtq   SELECT dbin.db_name, dbin.inst...
30 2 0vwa9n600yvgm   SELECT sum(delta_cpu_time) as ...
30 16 5ur69atw3vfhj   select decode(failover_method,...
30 2 b5yyh2vc9g8tm   SELECT sx.id, sum(decode(e.sna...
24 2 14566d856s6hs   SELECT owner# FROM sys.wri$_ad...
24 2 14566d856s6hs   SELECT owner# FROM sys.wri$_ad...
24 2 5an8d9ctcysja   SELECT (case when snap_id = :s...
24 2 gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...

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
3.64 1.98 183.76 148.62 95 2baqvamkstzv2 JDBC Thin Client begin pw_add_yjzsscpz(:1, :2, ...
3.50 52.89 6.61 1.92 171 08td029f3abyz JDBC Thin Client select STATUS, CJR, CJSJ, ORG ...
3.20 59.69 5.36 1.46 2 1ykxq1vvu3pw5 JDBC Thin Client BEGIN Prc_Mps_Gyscgbljc(:1, :2...
3.15 60.27 5.23 1.40 2 7ccj64p5ga76t JDBC Thin Client INSERT INTO TEMP_CGBLJY (WLBM,...
1.12 3.33 33.71 25.55 47 gmzva85wy3h8n JDBC Thin Client SELECT COUNT(:"SYS_B_0") c_hs,...
0.94 2.24 42.19 30.59 117 9qfvjprb5psvp JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
0.84 27.99 3.01 0.99 2 8x2vjs56gj3a6 JDBC Thin Client BEGIN PRC_MPS_problemDeliveryD...
0.82 3.35 24.57 11.59 1 03y9rpv36g51k JDBC Thin Client SELECT T1.C_PZH SCFWLYDPZH, T1...
0.74 0.02 4,807.21 3,873.40 8 7t3bfw6kvdunq JDBC Thin Client SELECT a.sessionid, decode(a.s...
0.73 3.52 20.86 17.30 1 36xv24xb072uq JDBC Thin Client BEGIN pkg_ifc_mes.prc_ifc_rxjh...
0.73 3.96 18.39 14.03 35 44m843r687ymt JDBC Thin Client BEGIN pkg_ifc_mes.IFC_MES_SCF_...
0.64 1.10 58.25 49.15 1 7rppp6v5grwqg JDBC Thin Client BEGIN PRC_MPS_IN_NO4STORAGE(:1...
0.61 0.08 796.35 653.45 92 b6cmfd9gfjmqd JDBC Thin Client SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS...
0.50 1.76 28.22 22.20 58 ayv0vhg5vbcg1 JDBC Thin Client SELECT SQ.*, (SELECT ZZ.CKMC F...
0.43 0.33 132.88 108.97 94 5wssrc6y3ypuf JDBC Thin Client update SCF2SAP_SF17_GOODSMVT_I...
0.42 3.81 11.11 8.28 27 2f8gjukz261fc JDBC Thin Client select distinct t.c_kjzq jhny ...
0.42 0.46 89.71 73.75 524 7f039z54cu4rx JDBC Thin Client SELECT * FROM TW_WLYDPZMX T WH...
0.36 7.31 4.99 2.95 2 fby16d9fz7k72 JDBC Thin Client BEGIN PKG_MPS_CHECKREQUIREMENT...
0.32 0.11 284.26 227.39 17 0gshzbuaxq8pz JDBC Thin Client SELECT SQ.*, ZZ.C_MC C_SHDW, Y...
0.25 2.99 8.50 2.43 934 c4y84wmu5yjph JDBC Thin Client select distinct sessionid from...
0.25 8.42 2.95 1.79 36 95jdqszh5gv9s JDBC Thin Client SELECT MX.C_CXH, MX.C_SCJHCXH,...
0.25 1.60 15.44 12.08 71 gj73u9azpmf9t JDBC Thin Client select :"SYS_B_00" Lx, count(:...
0.21 6.02 3.51 2.27 444 0s90x7g3jd9sk JDBC Thin Client SELECT INN.*, YG.C_YGMC C_BGYX...
0.20 0.34 59.75 48.95 36 393drhftjj4dt JDBC Thin Client BEGIN Pw_Add_Impmmdsap(:1, :2,...
0.20 4.93 4.11 2.44 196 3utzy3g1xn2g3 JDBC Thin Client SELECT HXM.C_ZSH, ZS.C_ZSLY, H...
0.19 49.96 0.37 0.04 321 9qmza4gnx5rj6 JDBC Thin Client insert into tw_pzdygxhxm(scfwl...
0.17 1.15 14.78 9.81 9 0dmptzyb086u6 JDBC Thin Client SELECT DISTINCT ZS.C_ZSH, ZS.C...
0.16 0.24 64.99 52.27 22 546whxffw127p JDBC Thin Client SELECT WLBM, WLMC, TSYT, TSYTM...
0.12 0.51 24.18 17.31 6 crvmbwtcbfb2d JDBC Thin Client BEGIN PKG_ZZKKC_SUBMIT.PRC_WLY...
0.12 47.11 0.24 0.05 752 3c1kubcdjnppq   update sys.col_usage$ set equa...
0.11 0.91 12.14 10.40 1 66txdn782z8c4 JDBC Thin Client INSERT INTO T_CLRKJHMX (C_CLRK...
0.11 8.68 1.26 0.83 51 d80h6a7665f79 JDBC Thin Client SELECT PZ.C_PZH, PZ.C_ZZBM, PZ...
0.09 0.89 10.30 8.32 54 53bcag0kh0k2y JDBC Thin Client select distinct t1.wlbm c_wlbm...
0.08 0.08 106.15 90.84 6 5utqvfqf8513d JDBC Thin Client BEGIN pkg_ifc_mes.prc_ifc_zsll...
0.06 0.24 26.73 21.11 74 b2qkbbfj29xxn JDBC Thin Client select monitertab.interfaceid,...
0.06 0.45 12.89 10.10 30 255j544nntz6k JDBC Thin Client SELECT jhd.gysbm zzbm, (SELECT...
0.05 0.38 13.70 8.67 3 6r58mcgr1p2mj JDBC Thin Client SELECT A.C_CWTS FROM TW_WLYDZS...
0.05 44.55 0.10 0.00 101 54aydkdm8fvdd JDBC Thin Client update TW_WLYDZSHXMTEMP t set ...
0.04 17.47 0.23 0.05 1,049 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
0.04 0.06 63.56 52.71 61 a08ad1gmt11q9 JDBC Thin Client SELECT * FROM TW_WLYDPZMX WHER...
0.04 0.06 70.74 55.90 592 4tanzh2jp8tsn JDBC Thin Client select BO from SYSTASKBO where...
0.04 32.22 0.11 0.03 383 g00cj285jmgsw   update sys.mon_mods$ set inser...
0.03 9.58 0.36 0.04 214 ff0vbqq869ycu JDBC Thin Client select Count(*) NewMessage fro...
0.03 85.81 0.03 0.01 4 8dqa7bn175qhu   UPDATE WRH$_SQLTEXT SET snap_i...
0.02 0.18 11.93 9.62 25 cjsk3n312wbm0 JDBC Thin Client SELECT X.*, S.C_SAPCKBM FROM T...
0.02 77.37 0.03 0.00 57 3m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
0.02 0.59 3.35 1.92 12 32b5nn8haqrnf JDBC Thin Client UPDATE monitertab SET OUTTIME=...
0.02 21.58 0.07 0.03 524 2ghbsfvq9mn3v   INSERT /*+ NO_PARTIAL_COMMIT R...
0.01 6.37 0.19 0.01 99 451q2032pshqm   select owner#, name, namespace...
0.01 0.34 3.33 2.21 12 ga3b3mvp75u5r JDBC Thin Client UPDATE monitertab SET status=:...
0.01 0.42 2.51 1.85 12 7a14h94mg3817 JDBC Thin Client UPDATE MONITERTAB SET tradecou...
0.01 3.18 0.33 0.16 1 1bsp1wphh5m3r JDBC Thin Client SELECT ZS.C_ZSH, HXM.C_XMH, HX...
0.01 22.46 0.04 0.01 177 grwydz59pu6mc   select text from view$ where r...
0.01 0.34 2.77 1.94 11 2g7sybaxj1fk0 JDBC Thin Client UPDATE MONITERTAB m SET m.DATA...
0.01 4.02 0.23 0.02 718 c1289gydrn00t JDBC Thin Client insert into MES2SCF_MF05 (id, ...
0.01 9.98 0.09 0.06 170 2qd9gma0nnm1r JDBC Thin Client INSERT INTO TNOTEMONITOR (RWBH...
0.01 3.79 0.24 0.02 308 0fx4sd9cd265g JDBC Thin Client insert into SAP2SCF_SF03_EXPOR...
0.01 0.03 34.23 29.52 102 gbx9vh9y655p6 JDBC Thin Client INSERT INTO TW_WLYDZSHXM (C_ZS...
0.01 0.86 0.97 0.82 2 d2bxhdz2kcy7v JDBC Thin Client select hxm.c_zsh, HXM.C_PLX, h...
0.01 17.44 0.04 0.03 2 bqnn4c3gjtmgu   insert into wrh$_bg_event_summ...
0.01 10.28 0.07 0.03 99 8swypbbr0m372   select order#, columns, types ...
0.01 0.01 59.38 48.79 47 dn8fxy9kcv288 JDBC Thin Client SELECT COUNT(1) FROM TW_PZDYGX...
0.01 0.17 3.84 2.63 2 b6zt3cfrux8x1 JDBC Thin Client Select :"SYS_B_000" Lx, :"SYS_...
0.01 4.74 0.13 0.02 329 4spc68yrsgfnw JDBC Thin Client INSERT INTO tw_sapwlpz (jkbh, ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
00m9b8xca8hvp SELECT file_type, ROUND (mb_used, :"SYS_B_00") mb_used, ROUND (mb_reclaimable, :"SYS_B_01") mb_reclaimable, DECODE(total_mb, :"SYS_B_02", :"SYS_B_03", ROUND (mb_used * :"SYS_B_04" / total_mb, :"SYS_B_05")) percent_space_used, DECODE(total_mb, :"SYS_B_06", :"SYS_B_07", ROUND (mb_reclaimable * :"SYS_B_08" / total_mb, :"SYS_B_09")) percent_space_reclaimable, number_of_files, total_mb db_recovery_file_dest_mb, flashback_retention_target, oldest_record, ROUND((sysdate-oldest_record)*:"SYS_B_10"*:"SYS_B_11", :"SYS_B_12") oldest_record_age_sec FROM (SELECT SUM (DECODE (NAME, :"SYS_B_13", VALUE / :"SYS_B_14", :"SYS_B_15" ) ) total_mb, SUM (DECODE (NAME, :"SYS_B_16", VALUE, :"SYS_B_17") ) flashback_retention_target FROM v$parameter WHERE NAME IN (:"SYS_B_18", :"SYS_B_19" )), (SELECT :"SYS_B_20" file_type, NVL (SUM (BYTES) / :"SYS_B_21", :"SYS_B_22") mb_used, sum(CASE WHEN first_time <= (sysdate - (tgt.value /:"SYS_B_23")) THEN bytes / :"SYS_B_24" ELSE :"SYS_B_25" END ) mb_reclaimable, COUNT (*) number_of_files, MIN (first_time) oldest_record FROM v$flashback_database_logfile fla_log, (SELECT quest_soo_pkg.stringToDigit(value) value FROM v$parameter WHERE name = :"SYS_B_26") tgt UNION SELECT :"SYS_B_27" file_type, NVL (SUM (BYTES / :"SYS_B_28"), :"SYS_B_29") mb, SUM (CASE WHEN dl.rectype = :"SYS_B_30" THEN (BYTES / :"SYS_B_31") ELSE :"SYS_B_32" END ) reclaimable_mb, COUNT (*) no_of_files, MIN (start_time) oldest_record FROM v$backup_piece bp, x$kccagf dl WHERE is_recovery_dest_file = :"SYS_B_33" AND deleted = :"SYS_B_34" AND bp.recid = dl.recid(+) AND dl.rectype(+) = :"SYS_B_35" UNION SELECT :"SYS_B_36" file_type, NVL (SUM (blocks * block_size) / :"SYS_B_37", :"SYS_B_38") mb, SUM (CASE WHEN dl.rectype = :"SYS_B_39" THEN (LOG.blocks * LOG.block_size / :"SYS_B_40") ELSE :"SYS_B_41" END ) reclaimable_mb, COUNT (*) no_of_files, MIN (first_time) oldest_record FROM v$archived_log log, x$kccagf dl WHERE deleted = :"SYS_B_42" AND is_recovery_dest_file = :"SYS_B_43" AND dl.recid(+) = log.recid AND dl.rectype(+) = :"SYS_B_44" UNION SELECT :"SYS_B_45" file_type, SUM (BYTES / :"SYS_B_46") mb, :"SYS_B_47" reclaimable, COUNT (*) no_of_files, MIN (first_time) oldest_record FROM v$logfile lf JOIN (SELECT group#, BYTES, first_time FROM v$standby_log UNION SELECT group#, BYTES, first_time FROM v$log) USING (group#) WHERE lf.is_recovery_dest_file = :"SYS_B_48" UNION SELECT :"SYS_B_49", NVL (SUM (blocks * (block_size /:"SYS_B_50" )), :"SYS_B_51") mb, :"SYS_B_52" reclaimable_mb, COUNT (*) no_of_files, MIN (creation_time) oldest_record FROM v$datafile_copy WHERE deleted = :"SYS_B_53" AND is_recovery_dest_file = :"SYS_B_54" UNION SELECT :"SYS_B_55", NVL (SUM (block_size * file_size_blks) / :"SYS_B_56", :"SYS_B_57") mb, :"SYS_B_58" reclaimable, COUNT (*) no_of_files, NULL oldest_record FROM v$controlfile WHERE is_recovery_dest_file = :"SYS_B_59")
03y9rpv36g51k SELECT T1.C_PZH SCFWLYDPZH, T1.C_PZHH SCFWLYDPZHH, T1.C_GYSBM, (SELECT GYS.C_MC FROM SCF2.T_GYSZSJ GYS WHERE GYS.C_GYSBM = T1.C_GYSBM) C_GYSMC, T1.BACKSL, NULL C_CYSL, (SELECT TO_CHAR(PZ.C_JZRQ, 'yyyy-mm-dd hh24:mi:ss') FROM SCF2.TW_WLYDPZ PZ WHERE PZ.C_PZH = T1.C_PZH) C_JZRQ, T1.C_WLBM, (SELECT WL.C_WLMC FROM SCF2.T_WLZSJ WL WHERE WL.C_WLBM = T1.C_WLBM) C_WLMC, T1.C_SL, TO_CHAR(NVL(T1.BACKDATE, SYSDATE), 'yyyy-mm-dd hh24:mi:ss') BACKDATE, T1.SAPWLYDPZH, T1. SJLY, T1.SAPWLYDPZHH, T1.CGWLYDPZH, T1.CGWLYDPZHH, (SELECT PZ.C_WLDWBM FROM SCF2.TW_WLYDPZ PZ WHERE PZ.C_PZH = T1.C_PZH) C_WLDWBM, (SELECT ZZMC FROM SCF2.TPRIZZJG WHERE ZZBM = (SELECT PZ.C_WLDWBM FROM SCF2.TW_WLYDPZ PZ WHERE PZ.C_PZH = T1.C_PZH)) C_WLDWMC, T1.C_WLCKBM, (SELECT CK.C_CKMC FROM SCF2.TW_CKZSJ CK WHERE CK.C_CKBM = T1.C_WLCKBM) C_WLCKMC, (SELECT TO_CHAR(ZS.C_JHSFSJ, 'yyyy-mm-dd hh24:mi:ss') C_JHSFSJ FROM SCF2.TW_WLYDZS ZS WHERE ZS.C_ZSH = T1.C_ZSH AND ROWNUM = 1) C_JHSFSJ FROM (SELECT A.SCFWLYDPZH C_PZH, A.SCFWLYDPZHH C_PZHH, MIN(M.C_CKBM) C_CKBM, MIN(M.C_QWBM) C_QWBM, MIN(M.C_CWBM) C_CWBM, MIN(M.C_WLBM) C_WLBM, MIN(M.C_WLBB) C_WLBB, MIN(M.C_WLTSYT) C_WLTSYT, MIN(M.C_WLYSBM) C_WLYSBM, MIN(M.C_XSQY) C_XSQY, MIN(M.C_KCLX) C_KCLX, MIN(M.C_KCZT) C_KCZT, MIN(M.C_JLDW) C_JLDW, MIN(M.C_WLCKBM) C_WLCKBM, MIN(M.C_WLQWBM) C_WLQWBM, MIN(M.C_WLCWBM) C_WLCWBM, MIN(M.C_SFWLBM) C_SFWLBM, MIN(M.C_ZSH) C_ZSH, MIN(M.C_GYSBM) C_GYSBM, MIN(M.C_DDH) C_DDH, MIN(M.C_DDHH) C_DDHH, SUM(M.C_S L) C_SL, NVL(MIN(G.BACKSL), SUM(M.C_SL)) BACKSL, MIN(G.SAPWLYDPZH) SAPWLYDPZH, MIN(G.SJLY) SJLY, MIN(G.SAPWLYDPZHH) SAPWLYDPZHH, MIN(G.CGWLYDPZH) CGWLYDPZH, NVL(MIN(G.CGWLYDPZHH), A.SCFWLYDPZHH) CGWLYDPZHH, MIN(G.BACKDATE) BACKDATE FROM TW_PZDYGXHXM A INNER JOIN TW_WLYDPZMX M ON A.SCFWLYDPZH = M.C_PZH AND A.WLYDPZHH = M.C_PZHH AND (M.C_CXBJ IS NULL OR M.C_CXBJ = '0') INNER JOIN TW_PZDYGX G ON G.SCFWLYDPZH = A.SCFWLYDPZH AND G.SCFWLYDPZHH = A.SCFWLYDPZHH AND (:B1 IS NULL OR G.CGWLYDPZH IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B1 )))) WHERE EXISTS (SELECT 1 FROM TW_DYJL DY WHERE DY.C_PZH = A.SCFWLYDPZH AND DY.C_PZLX = '1') AND EXISTS (SELECT 1 FROM TW_WLYDPZ PZ WHERE A.SCFWLYDPZH = PZ.C_PZH AND PZ.C_ZZBM = :B5 AND (PZ.C_YWLBBM = '52T5' OR PZ.C_YWLBBM = '52T7') AND TO_CHAR(PZ.C_JZRQ, 'yyyy-mm-dd') >= :B4 AND TO_CHAR(PZ.C_JZRQ, 'yyyy-mm-dd') <= :B3 AND (:B2 IS NULL OR PZ.C_WLDWBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B2 ))))) AND NOT EXISTS (SELECT 1 FROM TW_PZDYGX GX WHERE (GX.HPZT = '1' AND GX.SCFWLYDPZH = A.SCFWLYDPZH AND GX.SCFWLYDPZHH = A.SCFWLYDPZHH)) GROUP BY A.SCFWLYDPZH, A.SCFWLYDPZHH ) T1 WHERE (:B9 IS NULL OR T1.C_GYSBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B9 )))) AND (:B8 IS NULL OR T1.C_PZH IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B8 )))) AND (:B7 IS NULL OR T1.C_PZHH = :B7 ) AND (:B6 IS NULL OR T1.C_WLCKBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B6 ))))
08td029f3abyzselect STATUS, CJR, CJSJ, ORG from sysflowstatus where dbjobbm = :"SYS_B_0"
0dmptzyb086u6 SELECT DISTINCT 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 DISTINCT CASE WHEN H.C_LLLX = '0' THEN '¿´°å' WHEN H.C_LLLX = '1' THEN 'À­ÁÏ' ELSE '' END FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_LLLX, (SELECT DISTINCT H.C_WLCKBM FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_WLCKBM, (SELECT DISTINCT WLCK.C_CKMC FROM TW_WLYDZSHXM H LEFT JOIN TW_CKZSJ WLCK ON WLCK.C_CKBM=H.C_WLCKBM WHERE H.C_ZSH = ZS.C_ZSH) C_WLCKMC, (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_XGR) C_XGRMC, TO_CHAR(ZS.C_XGSJ, 'yyyy-mm-dd hh24:mi:ss') C_XGSJ, ZS.C_BZ 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 ((:B16 IS NULL) OR (HXM.C_LLLX = :B16 )) AND HXM.C_CKBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B17 ))) 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(FW_CONVERT_FLATTOXLH(: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(FW_CONVERT_FLATTOXLH(:B13 ))) OR CS.C_ABCDFL IS NULL)) AND (:B12 IS NULL OR HXM.C_WLCKBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B12 )))) AND (:B11 IS NULL OR HXM.C_WLBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B11 )))))
0fx4sd9cd265ginsert into SAP2SCF_SF03_EXPORT_MSEG (id, sessionid, mBLNR, mJAHR, zEILE, bUDAT, bLDAT, cPUDT, cPUTM, uSNAM, xBLNR, xABLN, bKTXT, bWART, mATNR, wERKS, lGORT, cHARG, sOBKZ, sHKZG, mENGE, mEINS, sGTXT, lIFNR, kUNNR, kOSTL, eBELN, eBELP, aUFNR, rSNUM, rSPOS, lFBJA, lFBNR, lFPOS) values (seq_payment.nextval, :"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")
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")
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
0vwa9n600yvgm SELECT sum(delta_cpu_time) as total_cpu, sum(case when session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' ) then delta_cpu_time else 0 end) as logmr_cpu, sum(case when session_type in ( 'STREAMS Capture' ) then delta_cpu_time else 0 end) as captr_cpu, sum(case when session_type in ( 'Propagation Sender' , 'Propagation Receiver' ) then delta_cpu_time else 0 end) as prpgt_cpu, sum(case when session_type in ( 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' ) then delta_cpu_time else 0 end) as apply_cpu, sum(case when session_type in ( 'QMON Slaves' , 'QMON Coordinator' ) then delta_cpu_time else 0 end) as qmon_cpu FROM ( SELECT b.session_type, (case when b.min_logon_time = e.min_logon_time then e.sum_cpu_time - b.sum_cpu_time else e.sum_cpu_time end) as delta_cpu_time FROM wrh$_sess_time_stats b, wrh$_sess_time_stats e WHERE b.dbid = :dbid AND b.instance_number = :instance_number AND b.snap_id = :startsn AND e.dbid = :dbid AND e.instance_number = :instance_number AND e.snap_id = :endsn AND e.se ssion_type = b.session_type AND e.session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' , 'STREAMS Capture' , 'Propagation Sender' , 'Propagation Receiver' , 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' , 'QMON Slaves' , 'QMON Coordinator' ) ) all_types
10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
14566d856s6hsSELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
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
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;
2f8gjukz261fcselect distinct t.c_kjzq jhny from tw_xlhz t order by t.c_kjzq desc
2g7sybaxj1fk0UPDATE MONITERTAB m SET m.DATACOUNT=(SELECT COUNT(:"SYS_B_0") FROM Mes2scf_Mf03 WHERE TRANSJOBID=:"SYS_B_1") WHERE m.TRANSJOBID=:"SYS_B_2"
2ghbsfvq9mn3vINSERT /*+ NO_PARTIAL_COMMIT REF_CASCADE_CURSOR */ INTO "SCF2"."TW_WLYDPZMX_XLH" ("NESTED_TABLE_ID", "COLUMN_VALUE") VALUES(:1, :2)
2qd9gma0nnm1rINSERT INTO TNOTEMONITOR (RWBH, BZR, BZRQ, JSR, JSDW, YWM, YWLX, RWZT, CLRQ) VALUES (SEQ_NOTEMONITOR.NEXTVAL, 'sys', SYSDATE, NVL(:B3 , :B2 ), NVL(:B3 , :B2 ), :B1 , '7010', '0', NULL)
2tq3dknsjum6dSELECT :"SYS_B_0" FROM DUAL
32b5nn8haqrnfUPDATE monitertab SET OUTTIME=null, TRANSTIME=sysdate WHERE ID=:"SYS_B_0"
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
36xv24xb072uqBEGIN pkg_ifc_mes.prc_ifc_rxjhdd(:1, :2, :3, :4); END;
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
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
4spc68yrsgfnwINSERT INTO tw_sapwlpz (jkbh, sgwlpzh, sgpzhh, gcbh, wlpzbh, cgbs) VALUES (:"SYS_B_0", :"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5")
4tanzh2jp8tsnselect BO from SYSTASKBO where TASKID=:"SYS_B_0"
4tw9rjrv9ruscinsert into MES2SCF_MF05_HIS (id, sessionid, DJBH, JHRQ, JHX, XQSBH, WLH, LBJMC, YS, JLDW, YHSL, SNP, BGYBM, BGYMC, SHCK, YJDHSJ, ZWDHSJ, GYSBM, TSYT, LLLX, BZ, SCX, GW, WLXHD, ZZBM, JJBJ, JJYY, CXH, FBSJ) values (seq_payment.nextval, :"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")
53bcag0kh0k2yselect distinct t1.wlbm c_wlbm, t2.C_WLMC, t2.C_JLDW, t1.gysbm c_gysbm, t1.gysmc c_gysmc, t3.ygbm as c_ygbm, t3.ygmc as c_ygmc, (Select C_Snp From T_Wlbz Bz Where Bz.C_Zzbm = :"SYS_B_0" And Bz.C_Gys = T1.Gysbm And Bz.C_Wlbm = T1.Wlbm and rownum=:"SYS_B_1") c_snp from tw_gysghcp t1 left join t_wlzsj t2 on t1.wlbm = t2.C_WLBM left join tpriygzsj t3 on fw_get_bgybm(:"SYS_B_2", :"SYS_B_3", t1.wlbm, :"SYS_B_4", :"SYS_B_5", t1.gysbm) = t3.ygbm where t1.gysbm in (:"SYS_B_6")
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
54aydkdm8fvddupdate TW_WLYDZSHXMTEMP t set t.c_dhsj=to_date(:"SYS_B_0", :"SYS_B_1") where t.c_ph=:"SYS_B_2" and t.c_xmh=:"SYS_B_3"
5an8d9ctcysjaSELECT (case when snap_id = :startsn then 1 else 0 end) as start_snap, (case when name = 'maximum PGA allocated' then 1 when name = 'total PGA allocated' then 2 when name = 'over allocation count' then 3 when name = 'recompute count (total)' then 4 else 0 end) as stat_id, value FROM WRH$_PGASTAT pga WHERE pga.dbid = :dbid AND pga.instance_number = :instance_number AND (pga.snap_id = :startsn OR pga.snap_id = :endsn) AND pga.name IN ( 'maximum PGA allocated' , 'total PGA allocated' , 'over allocation count' , 'recompute count (total)' ) ORDER BY snap_id, stat_id
5jxwda6s8nvc7select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :w or (changescn_wrap = :w and changescn_base >= :b))
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5utqvfqf8513dBEGIN pkg_ifc_mes.prc_ifc_zsllkb(:1, :2); END;
5wssrc6y3ypuf update SCF2SAP_SF17_GOODSMVT_ITEM set ACTIVITY=:1, ACTTYPE=:2, AMOUNT_LC=:3, AMOUNT_SV=:4, ASSET_NO=:5, BASE_UOM=:6, BATCH=:7, CALC_MOTIVE=:8, CMMT_ITEM=:9, CMMT_ITEM_LONG=:10, COMP_SHIP=:11, COSTCENTER=:12, COST_OBJ=:13, CO_BUSPROC=:14, CREATEDATE=:15, CUSTOMER=:16, DELIV_ITEM=:17, DELIV_ITEM_TO_SEARCH=:18, DELIV_NUMB=:19, DELIV_NUMB_TO_SEARCH=:20, EAN_UPC=:21, ENTRY_QNT=:22, ENTRY_UOM=:23, ENTRY_UOM_ISO=:24, EXPIRYDATE=:25, FUNC_AREA=:26, FUNC_AREA_LONG=:27, FUND=:28, FUNDS_CTR=:29, GL_ACCOUNT=:30, GRANT_NBR=:31, GR_NUMBER=:32, GR_RCPT=:33, GR_RCPTX=:34, IND_PROPOSE_QUANX=:35, ITEM_TEXT=:36, LINE_DEPTH=:37, LINE_ID=:38, MATDOC_TR_CANCEL=:39, MATERIAL=:40, MATERIAL_EXTERNAL=:41, MATERIAL_GUID=:42, MATERIAL_VERSION=:43, MATITEM_TR_CANCEL=:44, MATYEAR_TR_CANCEL=:45, MOVE_BATCH=:46, MOVE_MAT=:47, MOVE_MAT_EXTERNAL=:48, MOVE_MAT_GUID=:49, MOVE_MAT_VERSION=:50, MOVE_PLANT=:51, MOVE_REAS=:52, MOVE_STLOC=:53, MOVE_TYPE=:54, MOVE_VAL_TYPE=:55, MVT_IND=:56, NB_SLIPS=:57, NB_SLIPSX=:58, NETWORK=:59, NO_MORE_GR=:60, NO_PST_CHGNT=:61, NO_TRANSFER_REQ=:62, ORDERID=:63, ORDERPR_UN=:64, ORDERPR_UN_ISO=:65, ORDER_ITNO=:66, PARENT_ID=:67, PART_ACCT=:68, PAR_COMPCO=:69, PLANT=:70, PO_ITEM=:71, PO_NUMBER=:72, PO_PR_QNT=:73, PROD_DATE=:74, PROFIT_CTR=:75, PROFIT_SEGM_NO=:76, QUANTITY=:77, REF_DATE=:78, REF_DOC=:79, REF_DOC_IT=:80, REF_DOC_YR=:81, RESERV_NO=:82, RES_ITEM=:83, RES_TYPE=:84, RL_EST_KEY=:85, SALES_ ORD=:86, SCHED_LINE=:87, SERIALNO_AUTO_NUMBERASSIGNMENT=:88, SESSIONID=:89, SHIPPING=:90, SPEC_MVMT=:91, SPEC_STOCK=:92, STATUS=:93, STCK_TYPE=:94, STGE_BIN=:95, STGE_BIN_PC=:96, STGE_BIN_ST=:97, STGE_LOC=:98, STGE_TYPE=:99, STGE_TYPE_PC=:100, STGE_TYPE_ST=:101, ST_UN_QTYY_1=:102, ST_UN_QTYY_1_ISO=:103, ST_UN_QTYY_2=:104, ST_UN_QTYY_2_ISO=:105, SUB_NUMBER=:106, SUPPL_VEND=:107, SU_PL_STCK_1=:108, SU_PL_STCK_2=:109, S_ORD_ITEM=:110, TR_PART_BA=:111, UNITTYPE_1=:112, UNITTYPE_2=:113, UNLOAD_PT=:114, UNLOAD_PTX=:115, VAL_SALES_ORD=:116, VAL_S_ORD_ITEM=:117, VAL_TYPE=:118, VAL_WBS_ELEM=:119, VENDOR=:120, VENDRBATCH=:121, WBS_ELEM=:122, WITHDRAWN=:123, XSTOB=:124 where id=:125
66txdn782z8c4INSERT INTO T_CLRKJHMX (C_CLRKJHMXXLH, C_BBH, C_CLRKJHQDXLH, C_SCXBM, C_CXH, C_DPCH, C_SCJHCXH, C_XQMXXLH, C_BC, C_YSBM, C_DDH, C_CLSX, C_SCSX, C_QYSX, C_TXM, C_RKRQ, C_RKSL, C_RKDW, C_RKDD, C_RKPZFL, C_TQSJ, C_DPH) SELECT T_CLRKJHMX_SEQ.NEXTVAL, 0, :B3 , V.C_SCXBM, V.C_CXH, V.C_DPCH, V.C_SCJHCXH, V.C_XQMXXLH, '3501', V.C_YSBM, V.C_DDH, V.C_CLSX, V.C_SCSX, V.C_QYSX, V.C_TXM, (SELECT MIN(C.C_RQ) FROM T_YDZGZTZ A, T_YDZGZTZMX B, T_RDGZTZMX C WHERE A.C_SCXBM = V.C_SCXBM AND A.C_YDZGZTZXLH = B.C_YDZGZTZXLH AND B.C_YDZGZTZMXXLH = C.C_YDZGZTZMXXLH AND C.C_RQ >= V.C_RKRQ AND EXISTS (SELECT NULL FROM T_SCX SCX WHERE SCX.C_JHZZBM = :B4 AND SCX.C_SCXBM = A.C_SCXBM) AND C.C_KDXS <> '0') C_RKRQ, V.C_BYJC, V.C_RKDW, V.C_RKDD, '0704', V.C_TQSJ, V.C_DPH FROM T_YJCSJ V WHERE V.C_DPH NOT IN (SELECT NVL(MX.C_DPH, 'no_dph') FROM T_CLRKJHMX MX WHERE MX.C_CLRKJHQDXLH = :B3 AND MX.C_RKPZFL = '0704') AND C_RKRQ >= :B2 AND C_RKRQ <= :B1 AND EXISTS (SELECT NULL FROM T_SCX SCX WHERE V.C_SCXBM = SCX.C_SCXBM AND C_JHZZBM = :B4 )
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
7a14h94mg3817UPDATE MONITERTAB SET tradecount=tradecount+:"SYS_B_0" WHERE transjobid=:"SYS_B_1"
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
7f039z54cu4rxSELECT * FROM TW_WLYDPZMX T WHERE T.C_PZH = :B2 AND T.C_PZHH = :B1
7rppp6v5grwqgBEGIN PRC_MPS_IN_NO4STORAGE(:1, :2); END;
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"))))
8dqa7bn175qhuUPDATE WRH$_SQLTEXT SET snap_id = :lah_snap_id WHERE dbid = :dbid AND (SQL_ID) IN (SELECT STR1_KEWRATTR FROM X$KEWRATTRSTALE)
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
8x2vjs56gj3a6BEGIN PRC_MPS_problemDeliveryDate(:1, :2, :3, :4); END;
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
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
akq326dzntuj6select distinct sessionid from SAP_06_REQUEST where STATUS=:"SYS_B_0"
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
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
b5yyh2vc9g8tmSELECT sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst_num AND s.snap_id between :bid and :eid AND s.status = 0 AND x.ver_type = :exists_type ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = :inst_num AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.id
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 ))))))
b6zt3cfrux8x1 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 From (Select Hz.Wlbm, Hz.Gysbm , decode(to_char(Hz.Xqrq, :"SYS_B_016"), :"SYS_B_017", SUM(Hz.Xqsl), :"SYS_B_018") Y201306D13, decode(to_c har(Hz.Xqrq, :"SYS_B_019"), :"SYS_B_020", SUM(Hz.Xqsl), :"SYS_B_021") Y201306D14, decode(to_char(Hz.Xqrq, :"SYS_B_022"), :"SYS_B_023", SUM(Hz.Xqsl), :"SYS_B_024") Y201306D15, decode(to_char(Hz.Xqrq, :"SYS_B_025"), :"SYS_B_026", SUM(Hz.Xqsl), :"SYS_B_027") Y201306D16, decode(to_char(Hz.Xqrq, :"SYS_B_028"), :"SYS_B_029", SUM(Hz.Xqsl), :"SYS_B_030") Y201306D17, decode(to_char(Hz.Xqrq, :"SYS_B_031"), :"SYS_B_032", SUM(Hz.Xqsl), :"SYS_B_033") Y201306D18, decode(to_char(Hz.Xqrq, :"SYS_B_034"), :"SYS_B_035", SUM(Hz.Xqsl), :"SYS_B_036") Y201306D19, decode(to_char(Hz.Xqrq, :"SYS_B_037"), :"SYS_B_038", SUM(Hz.Xqsl), :"SYS_B_039") Y201306D20, decode(to_char(Hz.Xqrq, :"SYS_B_040"), :"SYS_B_041", SUM(Hz.Xqsl), :"SYS_B_042") Y201306D21, decode(to_char(Hz.Xqrq, :"SYS_B_043"), :"SYS_B_044", SUM(Hz.Xqsl), :"SYS_B_045") Y201306D22, decode(to_char(Hz.Xqrq, :"SYS_B_046"), :"SYS_B_047", SUM(Hz.Xqsl), :"SYS_B_048") Y201306D23, decode(to_char(Hz.Xqrq, :"SYS_B_049"), :"SYS_B_050", SUM(Hz.Xqsl), :"SYS_B_051") Y201306D24, decode(to_char(Hz.Xqrq, :"SYS_B_052"), :"SYS_B_053", SUM(Hz.Xqsl), :"SYS_B_054") Y201306D25, decode(to_char(Hz.Xqrq, :"SYS_ B_055"), :"SYS_B_056", SUM(Hz.Xqsl), :"SYS_B_057") Y201306D26 , 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_058") 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_059") Snp, Hz.Tsyt, Hz.Wlys, Hz.Xqdw, Nvl((Select Sum(Xqsl) Xqsl From Tmrpydxqhz b Where B.Ny = :"SYS_B_060" And B.Gysbm = :"SYS_B_061" And B.Xqdw = Hz.Xqdw And B.Wlbm = Hz.Wlbm And B.Cgzxz = Hz.Cgzbm And Nvl(B.Wlys, :"SYS_B_062") = Nvl(Hz.Wlys, :"SYS_B_063") And Nvl(B.Tsyt, :"SYS_B_064") = Nvl(Hz.Tsyt, :"SYS_B_065")), :"SYS_B_066") Dhsl From Tmrprdxqhz Hz Where ((Trim(:"SYS_B_067") Is Null) Or Hz.Xqdw = :"SYS_B_068") And Hz.Ny = :"SYS_B_069" And ((:"SYS _B_070" Is Null) Or hz.Gysbm = :"SYS_B_071") And ((Trim(:"SYS_B_072") Is Null) Or hz.Wlbm In (Select * From Table(Fw_Split_Into_Vc100(:"SYS_B_073")))) 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_074" Lx, :"SYS_B_075" 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_076")) as Y201306D13, sum(nvl(t1.Y201306D14, :"SYS_B_077")) as Y201306D14, sum(nvl(t1.Y201306D15, :"SYS_B_078")) as Y201306D15, sum(nvl(t1.Y201306D16, :"SYS_B_079")) as Y201306D16, sum(nvl(t1.Y201306D17, :"SYS_B_080")) as Y201306D17, sum(nvl(t1.Y201306D18, :"SYS_B_081")) as Y201306D18, sum(nvl(t1.Y201306D19, :"SYS_B_082")) as Y201306D19, sum(nvl(t1.Y201306D20, :"SYS_B_083")) as Y201306D20, sum(nvl(t1.Y201306D21, :"SYS_B_084")) as Y201306D21, sum(nvl(t1.Y201306D22, :"SYS_B_085")) as Y201306D22, sum(nvl(t1.Y201306D23, :"SYS_B_086")) as Y20130 6D23, sum(nvl(t1.Y201306D24, :"SYS_B_087")) as Y201306D24, sum(nvl(t1.Y201306D25, :"SYS_B_088")) as Y201306D25, sum(nvl(t1.Y201306D26, :"SYS_B_089")) as Y201306D26 From (Select Wlbm, Gysbm , decode(to_char(yfhz.Dhrq, :"SYS_B_090"), :"SYS_B_091", SUM(yfhz.qdsl), :"SYS_B_092") Y201306D13, decode(to_char(yfhz.Dhrq, :"SYS_B_093"), :"SYS_B_094", SUM(yfhz.qdsl), :"SYS_B_095") Y201306D14, decode(to_char(yfhz.Dhrq, :"SYS_B_096"), :"SYS_B_097", SUM(yfhz.qdsl), :"SYS_B_098") Y201306D15, decode(to_char(yfhz.Dhrq, :"SYS_B_099"), :"SYS_B_100", SUM(yfhz.qdsl), :"SYS_B_101") Y201306D16, decode(to_char(yfhz.Dhrq, :"SYS_B_102"), :"SYS_B_103", SUM(yfhz.qdsl), :"SYS_B_104") Y201306D17, decode(to_char(yfhz.Dhrq, :"SYS_B_105"), :"SYS_B_106", SUM(yfhz.qdsl), :"SYS_B_107") Y201306D18, decode(to_char(yfhz.Dhrq, :"SYS_B_108"), :"SYS_B_109", SUM(yfhz.qdsl), :"SYS_B_110") Y201306D19, decode(to_char(yfhz.Dhrq, :"SYS_B_111"), :"SYS_B_112", SUM(yfhz.qdsl), :"SYS_B_113") Y201306D20, decode(to_char(yfhz.Dhrq, :"SYS_B_114"), :"SYS_B_115", SUM(yfhz.qdsl), :"SYS_B_116") Y201306D21, decode(to_char(yfhz.Dhrq, :"SYS_B_117"), :"SYS_B_118", SUM(yfhz.qdsl), :"SYS_B_119") Y201306D22, decod e(to_char(yfhz.Dhrq, :"SYS_B_120"), :"SYS_B_121", SUM(yfhz.qdsl), :"SYS_B_122") Y201306D23, decode(to_char(yfhz.Dhrq, :"SYS_B_123"), :"SYS_B_124", SUM(yfhz.qdsl), :"SYS_B_125") Y201306D24, decode(to_char(yfhz.Dhrq, :"SYS_B_126"), :"SYS_B_127", SUM(yfhz.qdsl), :"SYS_B_128") Y201306D25, decode(to_char(yfhz.Dhrq, :"SYS_B_129"), :"SYS_B_130", SUM(yfhz.qdsl), :"SYS_B_131") Y201306D26, 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_132") 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_133") Snp , yfhz.Wltsyt Tsyt, yfhz.Wlys, yfhz.Xqdwbm Xqdw, Null Dhsl From tmrpfjjhrdhz yfhz Where ((Trim(:"SYS_B_134") Is Null) Or yfhz.Xqdwbm = :"SYS_B_135") And yfhz.jhny = :"SYS_B_136" And ((:"SYS_B_137" Is Null) Or yfhz.Gysbm = :"SYS_B_138") And ((Trim(:"SYS_B_139") Is Null) Or yfhz.Wlbm In (Select * From Table(Fw_Split_Into_Vc100(:"SYS_B_140")))) 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_141" Lx, :"SYS_B_142" 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_143")) as Y201306D13, sum(nvl(t2.Y201306D14, :"SYS_B_144")) as Y201306D14, sum(nvl(t2.Y201306D15, :"SYS_B_145")) as Y201306D15, sum(nvl(t2.Y201306D16, :"SYS_B_146")) as Y201306D16, sum(nvl(t2.Y201306D17, :"SYS_B_147")) as Y201306D17, sum(nvl(t2.Y201306D18, :"SYS_B_148")) as Y201306D18, sum(nvl(t2.Y201306D19, :"SYS_B_149")) as Y201306D19, sum(nvl(t2.Y201306D20, :"SYS_B_150")) as Y201306D20, sum(nvl(t2.Y201306D21, :"SYS_B_151")) as Y201306D21, sum(nvl(t2.Y201306D22, :"SYS_B_152")) as Y201306D22, sum(nvl(t2.Y201306D23, :"SYS_B_153")) as Y201306D23, sum(nvl(t2.Y201306D24, :"SYS_B_154")) as Y201306D24, sum(nvl(t2.Y201306D25, :"SYS_B_155")) as Y201306D25, sum(nvl(t2.Y201306D26, :"SYS_B_156")) as Y201306D26 From (S elect Wlbm, Gysbm , decode(to_char(mx.Dhrq, :"SYS_B_157"), :"SYS_B_158", SUM(mx.qdsl), :"SYS_B_159") Y201306D13, decode(to_char(mx.Dhrq, :"SYS_B_160"), :"SYS_B_161", SUM(mx.qdsl), :"SYS_B_162") Y201306D14, decode(to_char(mx.Dhrq, :"SYS_B_163"), :"SYS_B_164", SUM(mx.qdsl), :"SYS_B_165") Y201306D15, decode(to_char(mx.Dhrq, :"SYS_B_166"), :"SYS_B_167", SUM(mx.qdsl), :"SYS_B_168") Y201306D16, decode(to_char(mx.Dhrq, :"SYS_B_169"), :"SYS_B_170", SUM(mx.qdsl), :"SYS_B_171") Y201306D17, decode(to_char(mx.Dhrq, :"SYS_B_172"), :"SYS_B_173", SUM(mx.qdsl), :"SYS_B_174") Y201306D18, decode(to_char(mx.Dhrq, :"SYS_B_175"), :"SYS_B_176", SUM(mx.qdsl), :"SYS_B_177") Y201306D19, decode(to_char(mx.Dhrq, :"SYS_B_178"), :"SYS_B_179", SUM(mx.qdsl), :"SYS_B_180") Y201306D20, decode(to_char(mx.Dhrq, :"SYS_B_181"), :"SYS_B_182", SUM(mx.qdsl), :"SYS_B_183") Y201306D21, decode(to_char(mx.Dhrq, :"SYS_B_184"), :"SYS_B_185", SUM(mx.qdsl), :"SYS_B_186") Y201306D22, decode(to_char(mx.Dhrq, :"SYS_B_187"), :"SYS_B_188", SUM(mx.qdsl), :"SYS_B_189") Y201306D23, decode(to_char(mx.Dhrq, :"SYS_B_190"), :"SYS_B_191", SUM(mx.qdsl), :"SYS_B_192") Y201306D24, dec ode(to_char(mx.Dhrq, :"SYS_B_193"), :"SYS_B_194", SUM(mx.qdsl), :"SYS_B_195") Y201306D25, decode(to_char(mx.Dhrq, :"SYS_B_196"), :"SYS_B_197", SUM(mx.qdsl), :"SYS_B_198") Y201306D26, 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_199") 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_200") 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_201" and mx.cgjhh=:"SYS_B_202" and ((Trim(:"SYS_B_203") Is Null) Or mx.Xqdwbm = :"SYS_B_204") and ((Trim(:"SYS_B_205") Is Null) Or mx.jhy = :"SYS_B_206") And qd.jhny = :"SYS_B_207" And ((:"SYS_B_208" Is Null) Or qd.Gysbm = :"SYS_B_209") And ((Trim(:"SYS_B_210") Is Null) Or mx.Wlbm In (Select * From Table(Fw_Split_Into_Vc100(:"SYS_B_211")))) And mx.dhrq Is Not Null Group By Wlbm, Gysbm, dhrq, wlTsyt, Wlys, Xqdwbm, Cgzbm) t2 Group By Wlb m, Gysbm, Tsyt, Wlys, Xqdw, GYSKC, SNP order by wlbm
bm2vxqs97nq4dselect distinct sessionid from SCF2SAP_SF01_IMPORT where STATUS=:"SYS_B_0"
bqnn4c3gjtmguinsert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select /*+ ordered use_nl(e) */ :snap_id, :dbid, :instance_number, e.event_id, sum(e.total_waits), sum(e.total_timeouts), sum(e.time_waited_micro) from v$session bgsids, v$session_event e where bgsids.type = 'BACKGROUND' and bgsids.sid = e.sid group by e.event_id
buzx5wrw4dfgwselect * from gzlctree where dbjobbm = :"SYS_B_0"
c1289gydrn00tinsert into MES2SCF_MF05 (id, sessionid, DJBH, JHRQ, JHX, XQSBH, WLH, LBJMC, YS, JLDW, YHSL, SNP, BGYBM, BGYMC, SHCK, YJDHSJ, ZWDHSJ, GYSBM, TSYT, LLLX, BZ, SCX, GW, WLXHD, ZZBM, JJBJ, JJYY, CXH, FBSJ) values (seq_payment.nextval, :"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")
c4y84wmu5yjphselect distinct sessionid from SCF2SAP_SF17_IMPORT where STATUS=:"SYS_B_0"
cjsk3n312wbm0SELECT X.*, S.C_SAPCKBM FROM TW_WLYDPZMX X INNER JOIN TW_WLYDPZ M ON M.C_PZH = X.C_PZH INNER JOIN TW_CKZSJ S ON S.C_ZZBM = M.C_ZZBM AND S.C_CKBM = X.C_CKBM WHERE M.C_PZH = :B1 AND S.C_CKLB IN ('0', '1') AND S.C_SAPCKBM IS NOT NULL
crvmbwtcbfb2dBEGIN PKG_ZZKKC_SUBMIT.PRC_WLYDZSHXM_JY(:1, :2, :3); END;
d2bxhdz2kcy7v select hxm.c_zsh, HXM.C_PLX, hxm.c_xmh, hxm.c_ckbm, hxm.c_wlbm, hxm.c_gysbm, hxm.c_wlbb, hxm.c_jldw, hxm.c_sl, nvl(hxm.c_zxsl, :"SYS_B_00") c_zxsl, nvl((hxm.c_sl-NvL(hxm.c_zxsl, :"SYS_B_01")), :"SYS_B_02") c_wzxsl, hxm.c_ddh, hxm.c_ddhh, hxm.c_ckpzh, hxm.c_ckpzhh, hxm.c_snp, hxm.c_ydyy, hxm.c_wlckbm, hxm.c_qxbj mxc_qxbj, hxm.c_gbbj mxc_gbbj, hxm.c_zxzt mxc_zxzt, hxm.c_jhsfsj mxc_jhsfsj, hxm.c_bz, zs.c_ywlbbm, zs.c_zslb, zs.c_zzbm, zs.c_wldwbm, decode(zs.c_qxbj, :"SYS_B_03", :"SYS_B_04", hxm.c_qxbj) c_qxbj, decode(zs.c_gbbj, :"SYS_B_05", :"SYS_B_06", hxm.c_gbbj) c_gbbj, zs.c_zxzt, TO_CHAR(zs.c_cjsj, :"SYS_B_07") C_CJSJ, zs.c_zsly, zz.c_mc c_zzmc, ck.c_ckmc, (select wl.C_WLMC from t_wlzsj wl where wl.C_WLBM = hxm.c_wlbm) C_Wlmc, gys.c_mc c_gysmc, zd1.c_mc c_tsyt, zd2.c_mc c_xsqy, ys.c_ysmc, (select c_ckmc from tw_ckzsj where c_ckbm = hxm.c_wlckbm) c_wlckmc, wldw.c_wldwmc, yw.c_ywlbmc, yw.c_wlydlxbm, case upper(zs.c_cjr) when :"SYS_B_08" then :"SYS_B_09" else (select yg.ygmc from tpriygzsj yg where yg.ygbm = zs.c_cjr) end C_Cjrxm , zs.C_CJR, (select c_wlydyymc from tw_wlydyy where c_wlydyybm=hxm.c_ydyy and rownum<=:"SYS_B_10") c_ydyymc from tw_wlydzshxm hxm left join tw_wlydzs zs on zs.c_zsh=hxm.c_zsh left join tw_ywlbzsj yw on yw.c_ywlbbm=zs.c_ywlbbm left join t_zzzsj zz on zz.c_zzbm=zs.c_zzbm left join tw_ckzsj c k on ck.c_ckbm=hxm.c_ckbm left join t_gyszsj gys on gys.c_gysbm=hxm.c_gysbm left join t_sjzd zd1 on zd1.c_clbm=hxm.c_wltsyt left join t_sjzd zd2 on zd2.c_clbm=hxm.c_xsqy left join t_ysqd ys on ys.c_ysbm=hxm.c_wlysbm left join tw_ckzsj wlck on wlck.c_ckbm=hxm.c_wlckbm 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=zs.c_wldwbm where :"SYS_B_11"=:"SYS_B_12" and zs.c_zzbm=:"SYS_B_13" and hxm.c_ckbm in (select * from table(fw_split_into_vc100(:"SYS_B_14"))) and zs.c_wldwbm in (select * from table(fw_split_into_vc100(:"SYS_B_15"))) and hxm.c_wlckbm in (select * from table(fw_split_into_vc100(:"SYS_B_16"))) and hxm.c_lllx in (select * from table(fw_split_into_vc100(:"SYS_B_17"))) and zs.c_zxzt IN (SELECT * FROM TABLE(fw_convert_flattoxlh(:"SYS_B_18"))) and nvl(zs.c_qxbj, :"SYS_B_19") in (select * from table(fw_convert_flattoxlh(:"SYS_B_20"))) and nvl(zs.c_gbbj, :"SYS_B_21") in (select * from table(fw_convert_flattoxlh(:"SYS_B_22"))) and hxm.c_jhsfsj between to_date(:"SYS_B_23", :"SYS_B_24") and to _date(:"SYS_B_25", :"SYS_B_26")
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
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 )
dv30311zhn1b4SELECT MAX(C_JSSJ), MAX(XS.C_BCLB) FROM T_YDZGZTZ YD, T_YDZGZTZMX MX, T_RDGZTZMX RD, T_KDXS XS WHERE YD.C_SCXBM = :B2 AND YD.C_YDZGZTZXLH = MX.C_YDZGZTZXLH AND MX.C_YDZGZTZMXXLH = RD.C_YDZGZTZMXXLH AND RD.C_RQ = TO_DATE(SUBSTR(:B1 , 1, 8), 'yyyy-mm-dd') AND RD.C_KDXS = XS.C_KDXSBM AND RD.C_KDXS <> '0'
fby16d9fz7k72BEGIN PKG_MPS_CHECKREQUIREMENT.PRC_MPS_FLCCCL(:1, :2, :3, :4); END;
ff0vbqq869ycuselect Count(*) NewMessage from tnotemonitor where :"SYS_B_0"=:"SYS_B_1" and RWZT=:"SYS_B_2" and jsr = :"SYS_B_3"
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
ga3b3mvp75u5rUPDATE monitertab SET status=:"SYS_B_0", comm=:"SYS_B_1", OUTTIME=sysdate WHERE ID=:"SYS_B_2"
gbx9vh9y655p6 INSERT INTO TW_WLYDZSHXM (C_ZSH, C_XMH, C_CKBM, C_WLBM, C_GYSBM, C_WLTSYT, C_WLYSBM, C_WLBB, C_JLDW, C_SL, C_ZXSL, C_GYSPC, C_DDH, C_DDHH, C_CKPZH, C_CKPZHH, C_SNP, C_XSQY, C_YDYY, C_WLCKBM, C_CJR, C_CJSJ, C_XGR, C_XGSJ, C_QXBJ, C_GBBJ, C_ZXZT, C_JHSFSJ, C_BZ, C_PLX, C_DHSJ, C_LLLX, C_GCBGY, C_GCBGYMC, C_ZJHGXX, C_SAPPZXX, C_KCZT) SELECT :B18 , ROWNUM, GX.C_CKBM, T.WLH, T.GYSBM, CASE WHEN REGEXP_LIKE('C', T.TSYT) THEN '5001' ELSE '' END, YS.C_YSBM, NULL, 'EA', T.YHSL, 0, NULL, NULL, NULL, T.DJBH, T.XQSBH, T.SNP, NULL, NULL, T.SHCK, 'sys', SYSDATE, NULL, NULL, '0', :B17 , '0', :B15 , NVL2(:B16 , :B16 || '/' || T.BZ, T.BZ), T.JHX, :B15 , :B14 , T.BGYBM, T.BGYMC, NULL, NULL, NULL FROM MES2SCF_MF05 T LEFT JOIN TPRIWLGSFW FW ON T.GYSBM = FW.GYSBM LEFT JOIN TW_ZZJBYYCS CS ON FW.WLGSBM = CS.C_ZZBM LEFT JOIN TW_CKYGYSDYGX GX ON GX.C_ZZBM = CS.C_ZZBM AND GX.C_GYSBM = T.GYSBM AND GX.C_ZT = '1' LEFT JOIN T_YSQD YS ON T.YS = YS.C_YSMC WHERE T.SESSIONID = :B13 AND T.LLLX = '1' AND T.ZZBM = :B12 AND T.GYSBM = :B11 AND CS.C_WMSGLBJ = '1' AND NVL(T.SCX, '*') = NVL(:B10 , '*') AND T.SHCK = :B9 AND NVL(T.BGYBM, '*') = NVL(:B8 , '*') AND NVL(T.BGYMC, '*') = NVL(:B7 , '*') AND NVL(FW.WLGSBM, '*') = NVL(:B6 , '*') AND NVL(GX.C_CKBM, '*') = NVL(:B5 , '*') AND T.LY = :B4 AND SUBSTR(T.YJDHSJ, 1, 12) = :B3 AND SUBSTR(T.FBSJ, 1, 12) = :B2 AND T.JJBJ = '0' AND NVL(T.JHRQ, '*') = NVL(:B1 , '*')
gdn3ysuyssf82SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
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
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 527,016 112.80 228.84
CPU used when call started 526,414 112.67 228.58
CR blocks created 671 0.14 0.29
Cached Commit SCN referenced 13,893 2.97 6.03
Commit SCN cached 5 0.00 0.00
DB time 1,233,166 263.93 535.46
DBWR checkpoint buffers written 8,117 1.74 3.52
DBWR checkpoints 0 0.00 0.00
DBWR fusion writes 3,175 0.68 1.38
DBWR object drop buffers written 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 158 0.03 0.07
DBWR undo block writes 2,304 0.49 1.00
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 17 0.00 0.01
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 46 0.01 0.02
PX local messages sent 46 0.01 0.02
PX remote messages recv'd 410 0.09 0.18
PX remote messages sent 252 0.05 0.11
Parallel operations not downgraded 17 0.00 0.01
RowCR - row contention 10 0.00 0.00
RowCR attempts 3,426 0.73 1.49
RowCR hits 3,834 0.82 1.66
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 104,577 22.38 45.41
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 1,616 0.35 0.70
application wait time 22 0.00 0.01
auto extends on undo tablespace 0 0.00 0.00
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 16,400 3.51 7.12
branch node splits 1 0.00 0.00
buffer is not pinned count 49,026,425 10,492.93 21,288.07
buffer is pinned count 90,991,449 19,474.53 39,509.96
bytes received via SQL*Net from client 17,568,280 3,760.07 7,628.43
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 62,461,047 13,368.29 27,121.60
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 11,042,818 2,363.45 4,794.97
calls to kcmgas 44,041 9.43 19.12
calls to kcmgcs 884 0.19 0.38
change write time 106 0.02 0.05
cleanout - number of ktugct calls 2,014 0.43 0.87
cleanouts and rollbacks - consistent read gets 462 0.10 0.20
cleanouts only - consistent read gets 382 0.08 0.17
cluster key scan block gets 10,284 2.20 4.47
cluster key scans 6,025 1.29 2.62
cluster wait time 5,018 1.07 2.18
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 5 0.00 0.00
commit batch/immediate requested 5 0.00 0.00
commit cleanout failures: block lost 178 0.04 0.08
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 68 0.01 0.03
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 14,771 3.16 6.41
commit cleanouts successfully completed 14,525 3.11 6.31
commit immediate performed 5 0.00 0.00
commit immediate requested 5 0.00 0.00
commit txn count during cleanout 1,299 0.28 0.56
concurrency wait time 207 0.04 0.09
consistent changes 104,611 22.39 45.42
consistent gets 257,888,250 55,194.79 111,979.27
consistent gets - examination 31,171,440 6,671.50 13,535.15
consistent gets direct 36 0.01 0.02
consistent gets from cache 257,888,211 55,194.78 111,979.25
current blocks converted for CR 0 0.00 0.00
cursor authentications 152 0.03 0.07
data blocks consistent reads - undo records applied 5,426 1.16 2.36
db block changes 289,400 61.94 125.66
db block gets 384,400 82.27 166.91
db block gets direct 56 0.01 0.02
db block gets from cache 384,344 82.26 166.89
deferred (CURRENT) block cleanout applications 9,010 1.93 3.91
dirty buffers inspected 0 0.00 0.00
enqueue conversions 24,214 5.18 10.51
enqueue deadlocks 0 0.00 0.00
enqueue releases 88,870 19.02 38.59
enqueue requests 88,876 19.02 38.59
enqueue timeouts 0 0.00 0.00
enqueue waits 576 0.12 0.25
exchange deadlocks 0 0.00 0.00
execute count 385,556 82.52 167.41
failed probes on index block reclamation 3 0.00 0.00
free buffer inspected 80,702 17.27 35.04
free buffer requested 92,395 19.77 40.12
gc CPU used by this session 3,739 0.80 1.62
gc blocks lost 0 0.00 0.00
gc cr block build time 13 0.00 0.01
gc cr block flush time 8 0.00 0.00
gc cr block receive time 4,262 0.91 1.85
gc cr block send time 43 0.01 0.02
gc cr blocks received 18,762 4.02 8.15
gc cr blocks served 11,898 2.55 5.17
gc current block flush time 4 0.00 0.00
gc current block pin time 103 0.02 0.04
gc current block receive time 8,460 1.81 3.67
gc current block send time 655 0.14 0.28
gc current blocks received 24,221 5.18 10.52
gc current blocks served 196,643 42.09 85.39
gc local grants 17,857 3.82 7.75
gc remote grants 18,297 3.92 7.94
gcs messages sent 94,422 20.21 41.00
ges messages sent 6,964 1.49 3.02
global enqueue get time 274 0.06 0.12
global enqueue gets async 2,241 0.48 0.97
global enqueue gets sync 68,754 14.72 29.85
global enqueue releases 67,501 14.45 29.31
heap block compress 897 0.19 0.39
hot buffers moved to head of LRU 81,216 17.38 35.27
immediate (CR) block cleanout applications 844 0.18 0.37
immediate (CURRENT) block cleanout applications 1,206 0.26 0.52
index crx upgrade (positioned) 5,251 1.12 2.28
index fast full scans (full) 1,725 0.37 0.75
index fetch by key 17,330,717 3,709.22 7,525.28
index scans kdiixs1 13,832,151 2,960.44 6,006.14
leaf node 90-10 splits 24 0.01 0.01
leaf node splits 267 0.06 0.12
lob reads 23 0.00 0.01
lob writes 70,373 15.06 30.56
lob writes unaligned 70,373 15.06 30.56
logons cumulative 168 0.04 0.07
messages received 13,708 2.93 5.95
messages sent 13,708 2.93 5.95
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 216,141,687 46,259.94 93,852.23
opened cursors cumulative 32,151 6.88 13.96
parse count (failures) 7 0.00 0.00
parse count (hard) 376 0.08 0.16
parse count (total) 31,813 6.81 13.81
parse time cpu 139 0.03 0.06
parse time elapsed 613 0.13 0.27
physical read IO requests 23,463 5.02 10.19
physical read bytes 277,274,624 59,343.97 120,397.14
physical read total IO requests 42,374 9.07 18.40
physical read total bytes 585,957,376 125,410.10 254,432.21
physical read total multi block requests 1,211 0.26 0.53
physical reads 33,847 7.24 14.70
physical reads cache 33,067 7.08 14.36
physical reads cache prefetch 9,903 2.12 4.30
physical reads direct 780 0.17 0.34
physical reads direct (lob) 17 0.00 0.01
physical reads direct temporary tablespace 744 0.16 0.32
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 7,606 1.63 3.30
physical write bytes 96,657,408 20,687.20 41,970.22
physical write total IO requests 15,930 3.41 6.92
physical write total bytes 218,853,376 46,840.31 95,029.69
physical write total multi block requests 3,769 0.81 1.64
physical writes 11,799 2.53 5.12
physical writes direct 800 0.17 0.35
physical writes direct (lob) 29 0.01 0.01
physical writes direct temporary tablespace 750 0.16 0.33
physical writes from cache 10,999 2.35 4.78
physical writes non checkpoint 7,590 1.62 3.30
pinned buffers inspected 16 0.00 0.01
pinned cursors current 17 0.00 0.01
prefetch clients - default 1 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 0 0.00 0.00
process last non-idle time 5,012 1.07 2.18
queries parallelized 17 0.00 0.01
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 512,395 109.67 222.49
recursive cpu usage 42,169 9.03 18.31
redo blocks written 77,480 16.58 33.64
redo buffer allocation retries 0 0.00 0.00
redo entries 107,504 23.01 46.68
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 2,041 0.44 0.89
redo size 37,278,568 7,978.58 16,186.96
redo subscn max counts 1,726 0.37 0.75
redo synch time 266 0.06 0.12
redo synch writes 1,549 0.33 0.67
redo wastage 929,108 198.85 403.43
redo write broadcast ack time 49 0.01 0.02
redo write time 445 0.10 0.19
redo writer latching time 2 0.00 0.00
redo writes 3,337 0.71 1.45
rollback changes - undo records applied 9 0.00 0.00
rollbacks only - consistent read gets 149 0.03 0.06
root node splits 0 0.00 0.00
rows fetched via callback 10,453,128 2,237.24 4,538.92
session connect time 68,955 14.76 29.94
session cursor cache hits 24,413 5.23 10.60
session logical reads 258,272,803 55,277.09 112,146.25
shared hash latch upgrades - no wait 13,144 2.81 5.71
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 67,353 14.42 29.25
sorts (rows) 27,149,928 5,810.79 11,788.94
sql area evicted 235 0.05 0.10
sql area purged 7 0.00 0.00
summed dirty queue length 0 0.00 0.00
switch current to new buffer 6,980 1.49 3.03
table fetch by rowid 34,919,620 7,473.71 15,162.67
table fetch continued row 5,918 1.27 2.57
table scan blocks gotten 154,559,773 33,079.81 67,112.36
table scan rows gotten 7,752,096,665 1,659,150.07 3,366,086.26
table scans (direct read) 0 0.00 0.00
table scans (long tables) 1 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 3,465,941 741.80 1,504.97
total number of times SMON posted 0 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction rollbacks 5 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,242,468 3,048.26 6,184.31
user I/O wait time 3,985 0.85 1.73
user calls 123,609 26.46 53.67
user commits 2,216 0.47 0.96
user rollbacks 87 0.02 0.04
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 73,356 15.70 31.85
write clones created in background 0 0.00 0.00
write clones created in foreground 0 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.0E+12 1.0E+12
session cursor cache count 1,668,295 1,669,977
session uga memory 5.8E+13 5.8E+13
opened cursors current 1,001 1,147
workarea memory allocated 9,800 13,317
logons current 73 77
session uga memory max 2.4E+11 2.4E+11
session pga memory 3.8E+11 3.8E+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)
MPS_INDX_01 9,045 2 0.68 1.00 104 0 0 0.00
BAS_DATA 1,404 0 0.76 1.70 2,717 1 1 0.00
WMS_DATA_01 2,934 1 2.61 1.39 952 0 0 0.00
USERS 1,684 0 3.70 1.01 470 0 0 0.00
MRP_DATA_01 1,910 0 3.14 1.00 169 0 0 0.00
WMS_INDEX_01 1,722 0 2.65 1.00 266 0 0 0.00
MPS_DATA_01 926 0 0.94 6.84 650 0 0 0.00
LOGIC_INDX_01 1,158 0 4.48 1.00 319 0 0 0.00
MRP_INDX_01 823 0 5.09 1.40 228 0 0 0.00
SYSAUX 94 0 4.36 1.00 752 0 0 0.00
PMS_DATA_01 710 0 0.69 1.10 64 0 0 0.00
LOGIC_DATA_01 335 0 1.85 6.05 192 0 0 0.00
UNDOTBS1 0 0 0.00 0.00 491 0 0 0.00
BAS_INDX_01 467 0 1.46 1.00 11 0 0 0.00
SYSTEM 193 0 4.35 1.00 98 0 0 0.00
PMS_INDX_01 8 0 6.25 1.00 95 0 0 0.00
TEMP 34 0 3.24 22.24 28 0 0 0.00
PUB_HIS_DATA_01 7 0 8.57 1.00 0 0 0 0.00
BEIFEN 3 0 6.67 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 206 0 0.83 2.21 401 0 0 0.00
BAS_DATA /oracle/oradata/DFACSCF/BAS_DATA_02.dbf 218 0 1.01 1.81 264 0 0 0.00
BAS_DATA /oracle/oradata/DFACSCF/BAS_DATA_03.dbf 164 0 0.12 1.95 320 0 0 0.00
BAS_DATA /oracle/oradata/DFACSCF/BAS_DATA_04.dbf 178 0 0.90 1.87 375 0 1 0.00
BAS_DATA /oracle/oradata/DFACSCF/BAS_DATA_05.dbf 228 0 0.70 1.83 367 0 0 0.00
BAS_DATA /oracle/oradata/DFACSCF/BAS_DATA_06.dbf 410 0 0.83 1.14 990 0 0 0.00
BAS_INDX_01 /oracle/oradata/DFACSCF/BAS_INDX_01_P01.dbf 212 0 1.60 1.00 1 0 0 0.00
BAS_INDX_01 /oracle/oradata/DFACSCF/BAS_INDX_01_P02.dbf 255 0 1.33 1.00 10 0 0 0.00
BEIFEN /oracle/oradata/DFACSCF/beifen.dbf 3 0 6.67 1.00 0 0 0 0.00
LOGIC_DATA_01 /oracle/oradata/DFACSCF/LOGIC_DATA_01_P01.dbf 170 0 1.00 6.19 171 0 0 0.00
LOGIC_DATA_01 /oracle/oradata/DFACSCF/LOGIC_DATA_01_P02.dbf 165 0 2.73 5.90 21 0 0 0.00
LOGIC_INDX_01 /oracle/oradata/DFACSCF/LOGIC_INDX_01_P01.dbf 1,106 0 4.48 1.00 199 0 0 0.00
LOGIC_INDX_01 /oracle/oradata/DFACSCF/LOGIC_INDX_01_P03.dbf 52 0 4.62 1.00 120 0 0 0.00
MPS_DATA_01 /oracle/oradata/DFACSCF/MPS_DATA_01_P01.dbf 599 0 0.60 2.84 285 0 0 0.00
MPS_DATA_01 /oracle/oradata/DFACSCF/MPS_DATA_01_P02.dbf 32 0 2.19 35.56 118 0 0 0.00
MPS_DATA_01 /oracle/oradata/DFACSCF/MPS_DATA_01_P03.dbf 66 0 1.52 16.26 127 0 0 0.00
MPS_DATA_01 /oracle/oradata/DFACSCF/MPS_DATA_01_P04.dbf 229 0 1.48 10.57 120 0 0 0.00
MPS_INDX_01 /oracle/oradata/DFACSCF/MPS_INDX_01_P01.dbf 4,067 1 0.64 1.00 55 0 0 0.00
MPS_INDX_01 /oracle/oradata/DFACSCF/MPS_INDX_01_P02.dbf 4,978 1 0.72 1.00 49 0 0 0.00
MRP_DATA_01 /oracle/oradata/DFACSCF/MRP_DATA_01_P01.dbf 164 0 2.74 1.00 1 0 0 0.00
MRP_DATA_01 /oracle/oradata/DFACSCF/MRP_DATA_01_P02.dbf 413 0 2.71 1.00 0 0 0 0.00
MRP_DATA_01 /oracle/oradata/DFACSCF/MRP_DATA_01_P03.dbf 218 0 1.65 1.00 4 0 0 0.00
MRP_DATA_01 /oracle/oradata/DFACSCF/MRP_DATA_01_P04.dbf 513 0 4.15 1.00 14 0 0 0.00
MRP_DATA_01 /oracle/oradata/DFACSCF/MRP_DATA_01_P05.dbf 602 0 3.22 1.00 150 0 0 0.00
MRP_INDX_01 /oracle/oradata/DFACSCF/MRP_INDX_01_P01.dbf 428 0 5.09 1.38 117 0 0 0.00
MRP_INDX_01 /oracle/oradata/DFACSCF/MRP_INDX_01_P02.dbf 395 0 5.09 1.42 111 0 0 0.00
PMS_DATA_01 /oracle/oradata/DFACSCF/PMS_DATA_01_P01.dbf 187 0 0.37 1.06 6 0 0 0.00
PMS_DATA_01 /oracle/oradata/DFACSCF/PMS_DATA_01_P02.dbf 137 0 1.53 1.26 1 0 0 0.00
PMS_DATA_01 /oracle/oradata/DFACSCF/PMS_DATA_01_P03.dbf 71 0 0.70 1.11 1 0 0 0.00
PMS_DATA_01 /oracle/oradata/DFACSCF/PMS_DATA_01_P04.dbf 176 0 0.74 1.06 28 0 0 0.00
PMS_DATA_01 /oracle/oradata/DFACSCF/PMS_DATA_01_P05.dbf 139 0 0.22 1.05 28 0 0 0.00
PMS_INDX_01 /oracle/oradata/DFACSCF/PMS_INDX_01_P01.dbf 1 0 10.00 1.00 38 0 0 0.00
PMS_INDX_01 /oracle/oradata/DFACSCF/PMS_INDX_01_P02.dbf 7 0 5.71 1.00 57 0 0 0.00
PUB_HIS_DATA_01 /oracle/oradata/DFACSCF/PUB_HIS_DATA_01_P01.dbf 1 0 0.00 1.00 0 0 0 0.00
PUB_HIS_DATA_01 /oracle/oradata/DFACSCF/PUB_HIS_DATA_01_P02.dbf 1 0 20.00 1.00 0 0 0 0.00
PUB_HIS_DATA_01 /oracle/oradata/DFACSCF/PUB_HIS_DATA_01_P03.dbf 2 0 10.00 1.00 0 0 0 0.00
PUB_HIS_DATA_01 /oracle/oradata/DFACSCF/PUB_HIS_DATA_01_P04.dbf 2 0 10.00 1.00 0 0 0 0.00
PUB_HIS_DATA_01 /oracle/oradata/DFACSCF/PUB_HIS_DATA_01_P05.dbf 1 0 0.00 1.00 0 0 0 0.00
SYSAUX /oracle/oradata/DFACSCF/sysaux01.dbf 94 0 4.36 1.00 752 0 0 0.00
SYSTEM /oracle/oradata/DFACSCF/system01.dbf 193 0 4.35 1.00 98 0 0 0.00
TEMP /oracle/oradata/DFACSCF/temp01.dbf 34 0 3.24 22.24 28 0 0  
UNDOTBS1 /oracle/oradata/DFACSCF/undotbs01.dbf 0 0     491 0 0 0.00
USERS /oracle/oradata/DFACSCF/users01.dbf 1,684 0 3.70 1.01 470 0 0 0.00
WMS_DATA_01 /oracle/oradata/DFACSCF/WMS_DATA_01.dbf 1,469 0 3.11 1.38 503 0 0 0.00
WMS_DATA_01 /oracle/oradata/DFACSCF/WMS_DATA_02.dbf 1,465 0 2.10 1.39 449 0 0 0.00
WMS_INDEX_01 /oracle/oradata/DFACSCF/WMS_INDEX _02.dbf 852 0 2.76 1.00 120 0 0 0.00
WMS_INDEX_01 /oracle/oradata/DFACSCF/WMS_INDEX.dbf 870 0 2.55 1.00 146 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 782,104 100 258,253,167 33,064 10,999 0 0 1


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 925 6507 12466 943650 12466  
E 0 0 399 2424 20322 943650 20322  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 640 0.10 76,680 13.71 1,763,626,586
D 1,280 0.20 153,360 5.86 754,266,870
D 1,920 0.29 230,040 2.94 378,436,048
D 2,560 0.39 306,720 1.83 235,869,836
D 3,200 0.49 383,400 1.40 179,737,969
D 3,840 0.59 460,080 1.20 154,489,343
D 4,480 0.69 536,760 1.10 142,145,118
D 5,120 0.78 613,440 1.05 135,606,858
D 5,760 0.88 690,120 1.02 131,764,291
D 6,400 0.98 766,800 1.00 129,140,886
D 6,528 1.00 782,136 1.00 128,684,772
D 7,040 1.08 843,480 0.99 127,264,900
D 7,680 1.18 920,160 0.98 125,924,341
D 8,320 1.27 996,840 0.97 124,818,182
D 8,960 1.37 1,073,520 0.96 123,898,892
D 9,600 1.47 1,150,200 0.96 123,090,706
D 10,240 1.57 1,226,880 0.95 122,427,728
D 10,880 1.67 1,303,560 0.95 121,890,980
D 11,520 1.76 1,380,240 0.94 121,372,888
D 12,160 1.86 1,456,920 0.94 120,502,239
D 12,800 1.96 1,533,600 0.92 118,288,526

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
99.84 10,033 16

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 822 208.31 9.23 4.43 100.00 0.00 104,850
E 1,024 815 221.75 12.67 5.71 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 63,565 63,565 0 0
64K 128K 1,006 1,006 0 0
128K 256K 2,564 2,564 0 0
256K 512K 113 113 0 0
512K 1024K 4,493 4,493 0 0
1M 2M 1,199 1,199 0 0
2M 4M 81 81 0 0
4M 8M 96 94 2 0
8M 16M 156 156 0 0
16M 32M 66 66 0 0
32M 64M 15 15 0 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 5,260,750.65 578,522.31 90.00 9,239
256 0.25 5,260,750.65 43,488.98 99.00 0
512 0.50 5,260,750.65 18,750.51 100.00 0
768 0.75 5,260,750.65 18,750.51 100.00 0
1,024 1.00 5,260,750.65 16,880.44 100.00 0
1,229 1.20 5,260,750.65 13,211.12 100.00 0
1,434 1.40 5,260,750.65 13,211.12 100.00 0
1,638 1.60 5,260,750.65 13,211.12 100.00 0
1,843 1.80 5,260,750.65 13,211.12 100.00 0
2,048 2.00 5,260,750.65 13,211.12 100.00 0
3,072 3.00 5,260,750.65 13,211.12 100.00 0
4,096 4.00 5,260,750.65 13,211.12 100.00 0
6,144 6.00 5,260,750.65 13,211.12 100.00 0
8,192 8.00 5,260,750.65 13,211.12 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)
736 0.46 188 7,847 1,563,404 0.95 96,280 13.23 209,776
912 0.56 360 13,236 1,627,226 0.98 32,458 4.46 212,088
1,088 0.67 533 18,778 1,648,252 1.00 11,432 1.57 212,879
1,264 0.78 706 22,514 1,651,783 1.00 7,901 1.09 213,018
1,440 0.89 883 27,060 1,652,273 1.00 7,411 1.02 213,042
1,616 1.00 1,059 29,158 1,652,408 1.00 7,276 1.00 213,051
1,792 1.11 1,235 31,231 1,652,494 1.00 7,190 0.99 213,057
1,968 1.22 1,410 32,646 1,652,559 1.00 7,125 0.98 213,062
2,144 1.33 1,585 33,466 1,652,622 1.00 7,062 0.97 213,067
2,320 1.44 1,764 35,550 1,652,670 1.00 7,014 0.96 213,070
2,496 1.54 1,939 37,878 1,652,705 1.00 6,979 0.96 213,073
2,672 1.65 2,113 39,100 1,652,733 1.00 6,951 0.96 213,076
2,848 1.76 2,287 40,917 1,652,756 1.00 6,928 0.95 213,078
3,024 1.87 2,463 42,036 1,652,779 1.00 6,905 0.95 213,079
3,200 1.98 2,638 42,390 1,652,805 1.00 6,879 0.95 213,081
3,376 2.09 2,812 42,805 1,652,831 1.00 6,853 0.94 213,083

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 3,354,562 762,675,961
4,096 0.50 2,475,522 181,741,485
6,144 0.75 2,391,872 137,113,611
8,192 1.00 2,376,425 128,684,759
10,240 1.25 2,370,959 125,287,481
12,288 1.50 2,368,108 122,726,655
14,336 1.75 2,362,879 119,612,483
16,384 2.00 2,362,642 119,612,483

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

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 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
WF-AWR Flush 39 39 0 18 1 44.67
TM-DML 10,037 10,037 0 280 0 0.55
PS-PX Process Reservation 183 183 0 122 0 1.02
TT-Tablespace 264 264 0 67 0 0.31
CF-Controlfile Transaction 10,240 10,240 0 15 0 1.27
FB-Format Block 55 55 0 19 0 0.63
HW-Segment High Water Mark 387 387 0 15 0 0.33
TO-Temp Object 15 15 0 5 0 1.00
JS-Job Scheduler (job run lock - synchronize) 4 4 0 4 0 1.25
TA-Instance Undo 16 16 0 15 0 0.27
TD-KTF map table enqueue (KTF dump entries) 8 8 0 8 0 0.25
DR-Distributed Recovery 3 3 0 3 0 0.67
MW-MWIN Schedule 3 3 0 3 0 0.33
AF-Advisor Framework (task serialization) 14 14 0 1 0 0.00
TX-Transaction (index contention) 2 2 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
1 2.06 4,383 2,527 4 26.4/57.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:16 72 480 1,101 3 46 0/0 0/0/0/0/0/0
13-6ÔÂ 09:06 270 296 498 3 36 0/0 0/0/0/0/0/0
13-6ÔÂ 08:56 208 875 27 3 26 0/0 0/0/0/0/0/0
13-6ÔÂ 08:46 119 499 1,676 3 43 0/0 0/0/0/0/0/0
13-6ÔÂ 08:36 260 579 2,527 3 57 0/0 0/0/0/0/0/0
13-6ÔÂ 08:26 834 771 1,927 4 47 0/0 0/0/0/0/0/0
13-6ÔÂ 08:16 95 459 1,326 2 37 0/0 0/0/0/0/0/0
13-6ÔÂ 08:06 203 424 1,501 3 40 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,181 0.00   0 0  
ASM network background latch 2 0.00   0 0  
AWR Alerted Metric Element list 22,560 0.00   0 0  
Consistent RBA 3,336 0.00   0 0  
FOB s.o list latch 1,511 0.00   0 0  
JS broadcast add buf latch 1,072 0.00   0 0  
JS broadcast drop buf latch 1,072 0.00   0 0  
JS broadcast load blnc latch 930 0.00   0 0  
JS mem alloc latch 8 0.00   0 0  
JS queue access latch 8 0.00   0 0  
JS queue state obj latch 33,872 0.00   0 0  
JS slv state obj latch 101,195 0.00 0.00 0 0  
KCL gc element parent latch 629,818 0.00 0.00 0 1,659 0.00
KJC message pool free list 10,780 0.05 0.00 0 1,918 0.00
KJCT flow control latch 100,114 0.02 0.00 0 0  
KMG MMAN ready and startup request latch 1,557 0.00   0 0  
KSXR large replies 310 0.00   0 0  
KTF sga latch 4,618 0.00   0 1,288 0.00
KWQMN job cache list latch 372 0.00   0 0  
MQL Tracking Latch 0     0 94 0.00
Memory Management Latch 0     0 1,557 0.00
OS process 282 0.00   0 0  
OS process allocation 1,749 0.00   0 0  
OS process: request allocation 92 0.00   0 0  
PL/SQL warning settings 1,041 0.00   0 0  
SGA IO buffer pool latch 132 0.00   0 132 0.00
SQL memory manager latch 10 0.00   0 1,555 0.00
SQL memory manager workarea list latch 733,912 0.00 0.00 0 0  
Shared B-Tree 165 0.00   0 0  
active checkpoint queue latch 7,933 0.00   0 0  
active service list 10,448 0.00   0 21,010 0.00
archive control 28 0.00   0 0  
begin backup scn array 33 0.00   0 0  
business card 34 0.00   0 0  
cache buffer handles 9,498 0.00   0 0  
cache buffers chains 486,593,323 0.04 0.00 0 1,793,800 0.00
cache buffers lru chain 57,160 0.01 0.00 0 1,668,776 0.00
cache table scan latch 0     0 1,187 0.00
channel handle pool latch 110 0.00   0 0  
channel operations parent latch 254,960 0.01 0.00 0 0  
checkpoint queue latch 222,421 0.00   0 12,079 0.00
client/application info 670 0.00   0 0  
commit callback allocation 4 0.00   0 0  
compile environment latch 168 0.00   0 0  
dml lock allocation 20,091 0.00   0 0  
dummy allocation 332 0.00   0 0  
enqueue hash chains 224,118 0.00   0 161 0.00
enqueues 161,349 0.02 0.00 0 0  
error message lists 69 0.00   0 0  
event group latch 48 0.00   0 0  
file cache latch 1,214 0.00   0 0  
gcs opaque info freelist 246,892 0.01 0.00 0 0  
gcs partitioned table hash 1,122,512 0.00   0 1,296 0.00
gcs remastering latch 7,348 0.00   0 0  
gcs resource freelist 41,061 0.00   0 13,637 0.00
gcs resource hash 610,084 0.01 0.00 0 6 0.00
gcs resource scan list 12 0.00   0 0  
gcs shadows freelist 82,307 0.00   0 123,149 0.00
ges caches resource lists 49,584 0.02 0.00 0 56,403 0.01
ges deadlock list 1,536 0.00   0 0  
ges domain table 128,562 0.00   0 0  
ges enqueue table freelist 138,836 0.00   0 0  
ges group table 190,574 0.00   0 0  
ges process hash list 3,377 0.00   0 0  
ges process parent latch 278,276 0.00   0 0  
ges process table freelist 92 0.00   0 0  
ges resource hash list 212,151 0.00 0.50 0 3,844 0.00
ges resource scan list 10 0.00   0 0  
ges resource table freelist 6,146 0.00   0 0  
ges timeout list 1,854 0.00   0 1,069 0.00
global KZLD latch for mem in SGA 22 0.00   0 0  
global tx hash mapping 27,612 0.00   0 0  
hash table column usage latch 413 0.00   0 39,851 0.00
hash table modification latch 164 0.00   0 0  
internal temp table object number allocation latc 3 0.00   0 0  
interrupt manipulation 728 0.00   0 0  
job workq parent latch 0     0 30 0.00
job_queue_processes parameter latch 92 0.00   0 0  
kks stats 1,621 0.00   0 0  
kokc descriptor allocation latch 5,598 0.00   0 0  
ksuosstats global area 331 0.00   0 0  
ktm global data 16 0.00   0 0  
kwqbsn:qsga 165 0.00   0 0  
lgwr LWN SCN 3,829 0.21 0.00 0 0  
library cache 462,340 0.01 0.02 0 377 0.00
library cache load lock 1,098 0.00   0 0  
library cache lock 1,059,193 0.00 0.00 0 0  
library cache lock allocation 1,462 0.00   0 0  
library cache pin 167,438 0.00   0 0  
library cache pin allocation 1,130 0.00   0 0  
list of block allocation 524 0.00   0 0  
loader state object freelist 180 0.00   0 0  
longop free list parent 15 0.00   0 15 0.00
message pool operations parent latch 1,393 0.00   0 0  
messages 182,476 0.00 0.00 0 0  
mostly latch-free SCN 3,866 1.03 0.00 0 0  
multiblock read objects 24,694 0.00   0 0  
name-service memory objects 14,596 0.00   0 0  
name-service namespace bucket 52,459 0.00   0 0  
name-service pending queue 7,882 0.00   0 0  
name-service request queue 57,547 0.00   0 0  
ncodef allocation latch 75 0.00   0 0  
object queue header heap 32,660 0.00   0 640 0.00
object queue header operation 200,492 0.00   0 0  
object stats modification 8 0.00   0 0  
parallel query alloc buffer 1,600 0.00   0 0  
parallel query stats 156 0.00   0 0  
parallel txn reco latch 688 0.00   0 0  
parameter list 108 0.00   0 0  
parameter table management 363 0.00   0 0  
post/wait queue 2,933 0.00   0 1,769 0.00
process allocation 44,802 0.00 1.00 0 48 0.00
process group creation 92 0.00   0 0  
process queue 411 0.00   0 0  
process queue reference 8,565 0.00   0 755 0.26
qmn task queue latch 660 0.00   0 0  
query server freelists 313 0.00   0 0  
queued dump request 23,283 0.00   0 0  
redo allocation 10,979 0.00   0 107,537 0.00
redo copy 0     0 107,538 0.05
redo writing 21,215 0.00   0 0  
resmgr group change latch 222 0.00   0 0  
resmgr:active threads 319 0.00   0 0  
resmgr:actses change group 139 0.00   0 0  
resmgr:free threads list 309 0.00   0 0  
resmgr:resource group CPU method 135 0.00   0 0  
resmgr:schema config 10 0.00   0 0  
row cache objects 2,362,300 0.09 0.00 0 199 0.00
sequence cache 35,487 0.00   0 0  
session allocation 29,395 0.32 0.00 0 0  
session idle bit 260,760 0.01 0.00 0 0  
session state list latch 345 0.00   0 0  
session switching 295 0.00   0 0  
session timer 1,572 0.00   0 0  
shared pool 81,345 0.00   0 0  
shared pool simulator 4,570 0.00   0 0  
simulator hash latch 27,192,179 0.00 0.00 0 0  
simulator lru latch 0     0 27,191,107 0.12
slave class 12 0.00   0 0  
slave class create 47 4.26 1.00 0 0  
sort extent pool 259 0.00   0 0  
state object free list 4 0.00   0 0  
statistics aggregation 1,120 0.00   0 0  
temp lob duration state obj allocation 1 0.00   0 0  
temporary table state object allocation 8 0.00   0 0  
threshold alerts latch 426 0.00   0 0  
transaction allocation 1,552 0.00   0 0  
transaction branch allocation 28,487 0.00   0 0  
undo global data 18,790 0.00   0 0  
user lock 105 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 486,593,323 197,929 148 197,796 0 0 0
simulator hash latch 27,192,179 241 1 240 0 0 0
library cache 462,340 50 1 49 0 0 0
ges resource hash list 212,151 2 1 1 0 0 0
slave class create 47 2 2 0 0 0 0
process allocation 44,802 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffers chains kcbgtcr: kslbegin excl 0 189 171
cache buffers chains kcbrls: kslbegin 0 48 65
cache buffers chains kclwrt 0 2 0
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1 2
cache buffers chains kcbgcur: kslbegin 0 1 0
cache buffers chains kcbgtcr: fast path 0 1 0
cache buffers chains kclbla 0 1 0
ges resource hash list kjrmas1: lookup master node 0 1 0
library cache kqlmbinv: parent 0 1 0
process allocation ksucrp 0 1 0
simulator hash latch kcbsacc: lookup dba 0 1 1
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 103,634,832 40.13
SCF2 USERS IDX_TW_SAPWLPZ_001   INDEX 36,904,864 14.29
SCF2 LOGIC_DATA_01 IDX_TW_MOVEDATA_001   INDEX 19,393,664 7.51
SCF2 WMS_DATA_01 SYSTASKBO   TABLE 16,568,176 6.41
SCF2 LOGIC_DATA_01 MES2SCF_MF05   TABLE 8,458,832 3.28

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SCF2 MPS_INDX_01 IND_CLRKJHMX_1   INDEX 8,893 26.27
SCF2 WMS_DATA_01 TW_PZDYGX   TABLE 3,773 11.15
SCF2 LOGIC_DATA_01 SCF2MES_MF02   TABLE 1,722 5.09
SCF2 WMS_INDEX_01 IDX_TW_WLYDZSHXM_001   INDEX 1,655 4.89
SCF2 USERS PK_TW_WLYDPZ   INDEX 981 2.90

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 SYS_C0060793   INDEX 2 100.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 TASKGROUPSTATES   TABLE 1 100.00

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
SCF2 PMS_DATA_01 TCGGYSGHCP   TABLE 4,180 22.28
SCF2 MRP_DATA_01 TMRPCGDDJKBB   TABLE 1,726 9.20
SCF2 BAS_DATA TBOMALLJG   TABLE 1,052 5.61
SCF2 WMS_DATA_01 TW_XLHZ   TABLE 978 5.21
SCF2 BAS_INDX_01 INDX_BOMALL_CO1   INDEX 968 5.16

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
SCF2 WMS_DATA_01 SYSFLOWSTATUS   TABLE 4,693 19.38
SCF2 MRP_INDX_01 INDX_TMRPCGDDMX_C03   INDEX 3,340 13.79
SCF2 MPS_DATA_01 T_CLRKSJ   TABLE 2,745 11.33
SCF2 BAS_DATA TNOTEMONITOR   TABLE 1,972 8.14
SCF2 MPS_DATA_01 T_XQMX   TABLE 977 4.03

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 3.61 0   1 1
dc_database_links 48 0.00 0   0 4
dc_files 423 0.00 0   0 47
dc_global_oids 3,550 0.03 0   0 85
dc_histogram_data 25,852 3.16 0   0 19,445
dc_histogram_defs 10,979 6.28 0   0 8,016
dc_object_grants 25 76.00 0   0 295
dc_object_ids 12,398 0.15 0   0 1,968
dc_objects 2,998 5.37 0   0 2,110
dc_profiles 33 0.00 0   0 1
dc_rollback_segments 1,946 0.00 0   0 45
dc_segments 3,123 0.38 0   19 1,605
dc_sequences 1,080 5.19 0   1,080 47
dc_tablespace_quotas 3 33.33 0   3 10
dc_tablespaces 328,381 0.00 0   0 21
dc_usernames 825 0.00 0   0 30
dc_users 441,494 0.00 0   0 54
outstanding_alerts 161 89.44 0   0 1

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 5 3 0
dc_global_oids 1 0 0
dc_histogram_defs 689 0 53
dc_object_ids 19 0 0
dc_objects 161 4 16
dc_segments 46 5 11
dc_sequences 2,155 53 0
dc_tablespace_quotas 6 2 0
outstanding_alerts 313 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 83 0.00 2,239 0.18 4 0
CLUSTER 21 0.00 28 0.00 0 0
INDEX 17 0.00 71 0.00 0 0
SQL AREA 22,497 75.13 399,701 0.25 203 52
TABLE/PROCEDURE 1,899 1.32 101,537 0.54 280 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 28 0 0 0 0
INDEX 71 0 0 0 0
TABLE/PROCEDURE 49,422 53 14 27 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 118.39   1.58 2.45 11 11 75 75
  Freeable 72.56 0.00 1.69 5.48 36   43 43
  SQL 15.61 13.01 0.25 1.14 9 80 62 43
  PL/SQL 14.35 2.49 0.19 1.51 13 13 74 74
E Other 127.03   1.61 2.40 11 11 79 79
  Freeable 72.88 0.00 1.62 5.36 36   45 45
  SQL 19.91 17.00 0.30 0.96 5 87 66 47
  PL/SQL 14.54 2.66 0.19 1.47 13 13 78 78

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 6,845,104,128  
Fixed Size 2,114,248  
Redo Buffers 14,659,584  
Variable Size 3,875,540,280  

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 CCursor 73.37 72.98 -0.53
shared PCursor 37.94 38.21 0.71
shared db_block_hash_buckets 45.00 45.00 0.00
shared free memory 426.00 418.08 -1.86
shared gcs resources 144.65 144.65 0.00
shared gcs shadows 86.61 86.61 0.00
shared library cache 39.25 39.48 0.60
shared sql area 506.65 511.41 0.94
  buffer_cache 6,528.00 6,528.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

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


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 1   
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   
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 1   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/orabase/admin/DFACSCF/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 3,427 0.73 1.49
acks for commit broadcast(logical) 3,579 0.77 1.55
broadcast msgs on commit(actual) 3,336 0.71 1.45
broadcast msgs on commit(logical) 3,338 0.71 1.45
broadcast msgs on commit(wasted) 86 0.02 0.04
broadcast on commit wait time(ms) 450 0.10 0.20
broadcast on commit waits 765 0.16 0.33
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 1 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 110,000 23.54 47.76
gcs ast xid 0 0.00 0.00
gcs blocked converts 7,939 1.70 3.45
gcs blocked cr converts 15,084 3.23 6.55
gcs compatible basts 101 0.02 0.04
gcs compatible cr basts (global) 1,251 0.27 0.54
gcs compatible cr basts (local) 115,172 24.65 50.01
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 2,817 0.60 1.22
gcs dbwr write request msgs 772 0.17 0.34
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 807 0.17 0.35
gcs immediate (null) converts 1,355 0.29 0.59
gcs immediate cr (compatible) converts 2 0.00 0.00
gcs immediate cr (null) converts 28,941 6.19 12.57
gcs indirect ast 5,336 1.14 2.32
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 543 0.12 0.24
gcs msgs process time(ms) 11,140 2.38 4.84
gcs msgs received 332,079 71.07 144.19
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 8 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 0 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 4,728 1.01 2.05
gcs side channel msgs logical 55,387 11.85 24.05
gcs stale cr 0 0.00 0.00
gcs undo cr 39 0.01 0.02
gcs write notification msgs 39 0.01 0.02
gcs writes refused 4 0.00 0.00
ges msgs process time(ms) 75 0.02 0.03
ges msgs received 7,015 1.50 3.05
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 5,240 1.12 2.28
implicit batch messages sent 2,304 0.49 1.00
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,091 1.09 2.21
messages queue sent actual 18,778 4.02 8.15
messages queue sent logical 21,796 4.66 9.46
messages received actual 121,541 26.01 52.78
messages received logical 339,094 72.57 147.24
messages sent directly 39,627 8.48 17.21
messages sent indirectly 14,597 3.12 6.34
messages sent not implicit batched 16,474 3.53 7.15
messages sent pbatched 44,588 9.54 19.36
msgs causing lmd to send msgs 2,522 0.54 1.10
msgs causing lms(s) to send msgs 4,589 0.98 1.99
msgs received queue time (ms) 582 0.12 0.25
msgs received queued 339,094 72.57 147.24
msgs sent queue time (ms) 816 0.17 0.35
msgs sent queue time on ksxp (ms) 32,709 7.00 14.20
msgs sent queued 21,676 4.64 9.41
msgs sent queued on ksxp 66,888 14.32 29.04
number of ges deadlock detected 0 0.00 0.00
process batch messages received 28,293 6.06 12.29
process batch messages sent 12,996 2.78 5.64


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 11,013
CURRENT Block Requests 885
Data Block Requests 11,013
Undo Block Requests 39
TX Block Requests 340
Current Results 11,702
Private results 93
Zero Results 103
Disk Read Results 0
Fail Results 0
Fairness Down Converts 2,110
Fairness Clears 0
Free GC Elements 0
Flushes 79
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 68
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 196,640 100.00 0.00 0.00 0.00 0.00
Flushes 28 82.14 14.29 3.57 0.00 0.00
Writes 3,175 9.70 87.84 2.46 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
2 data block 17,804 99.66 0.34 0.00 23,726 99.88 0.11 0.00
2 Others 706 99.29 0.71 0.00 480 100.00 0.00 0.00
2 undo header 190 93.16 6.84 0.00 4 100.00 0.00 0.00
2 undo block 60 96.67 3.33 0.00 0      


Back to Top

End of Report