WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
PMSSN1860190213pmssn1110.2.0.4.0YESpmsdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:3451530-Jun-14 00:00:03224 45.1
End Snap:3453130-Jun-14 16:00:26237 36.0
Elapsed:  960.39 (mins)  
DB Time:  1,273.12 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 9,088M 9,088MStd Block Size: 8K
Shared Pool Size: 5,792M 5,792MLog Buffer: 14,320K

Load Profile

Per SecondPer Transaction
Redo size: 37,226.92 6,250.86
Logical reads: 39,686.70 6,663.88
Block changes: 77.16 12.96
Physical reads: 902.81 151.59
Physical writes: 8.90 1.49
User calls: 2,485.00 417.26
Parses: 52.51 8.82
Hard parses: 7.88 1.32
Sorts: 501.64 84.23
Logons: 0.04 0.01
Executes: 151.81 25.49
Transactions: 5.96 

% Blocks changed per Read: 0.19Recursive Call %: 16.64
Rollback per transaction %: 17.01Rows per Sort: 53.77

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96Redo NoWait %: 100.00
Buffer Hit %: 97.98In-memory Sort %: 100.00
Library Hit %: 89.54Soft Parse %: 85.00
Execute to Parse %: 65.41Latch Hit %: 99.90
Parse CPU to Parse Elapsd %: 65.90% Non-Parse CPU: 95.39

Shared Pool Statistics

BeginEnd
Memory Usage %: 26.10 26.10
% SQL with executions>1: 74.62 67.44
% Memory for SQL w/exec>1: 70.93 57.08

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  53,992  70.7 
db file sequential read 3,243,902 7,303 2 9.6User I/O
db file scattered read 3,774,349 4,632 1 6.1User I/O
gc cr multi block request 32,250,048 4,571 0 6.0Cluster
direct path read 2,890,127 4,318 1 5.7User I/O

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 645.83 108.44
Global Cache blocks served: 689.59 115.79
GCS/GES messages received: 2,123.08 356.49
GCS/GES messages sent: 2,139.09 359.18
DBWR Fusion writes: 0.97 0.16
Estd Interconnect traffic (KB) 11,515.81 

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

Buffer access - local cache %: 96.36
Buffer access - remote cache %: 1.63
Buffer access - disk %: 2.02

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1
Avg global cache cr block receive time (ms): 0.5
Avg global cache current block receive time (ms): 0.9
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 %: 6.1
Avg global cache cr block flush time (ms): 0.7
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.7

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1
Avg message sent queue time on ksxp (ms): 0.3
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: 12.97
% of indirect sent messages: 85.42
% of flow controlled messages: 1.61

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 66,947.13 87.64
DB CPU 53,991.63 70.68
parse time elapsed 3,840.18 5.03
hard parse elapsed time 3,584.81 4.69
PL/SQL execution elapsed time 157.49 0.21
PL/SQL compilation elapsed time 45.69 0.06
sequence load elapsed time 16.01 0.02
repeated bind elapsed time 9.81 0.01
connection management call elapsed time 9.22 0.01
hard parse (sharing criteria) elapsed time 8.01 0.01
hard parse (bind mismatch) elapsed time 4.27 0.01
failed parse elapsed time 0.74 0.00
DB time 76,387.15  
background elapsed time 6,455.75  
background cpu time 5,419.09  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
User I/O 10,555,558 0.00 17,506 2 30.76
Cluster 38,774,384 0.05 7,348 0 112.99
System I/O 797,981 0.00 794 1 2.33
Network 177,175,145 0.00 667 0 516.28
Commit 287,198 0.00 485 2 0.84
Other 8,835,250 92.63 394 0 25.75
Concurrency 1,050,075 0.04 337 0 3.06
Application 31,065 0.00 11 0 0.09
Configuration 6,486 95.71 1 0 0.02

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 3,243,902 0.00 7,303 2 9.45
db file scattered read 3,774,349 0.00 4,632 1 11.00
gc cr multi block request 32,250,048 0.00 4,571 0 93.98
direct path read 2,890,127 0.00 4,318 1 8.42
gc current block 2-way 3,730,759 0.00 1,301 0 10.87
db file parallel read 516,729 0.00 1,121 2 1.51
gc buffer busy 703,343 0.00 823 1 2.05
log file sync 287,198 0.00 485 2 0.84
log file parallel write 322,534 0.00 466 1 0.94
gc cr grant 2-way 1,675,968 0.00 447 0 4.88
SQL*Net more data to client 26,860,527 0.00 424 0 78.27
library cache lock 510,835 0.00 154 0 1.49
control file sequential read 413,611 0.00 150 0 1.21
row cache lock 465,663 0.00 149 0 1.36
SQL*Net more data from client 9,101,626 0.00 137 0 26.52
read by other session 107,681 0.00 116 1 0.31
db file parallel write 34,673 0.00 112 3 0.10
reliable message 4,959 0.97 107 22 0.01
SQL*Net message to client 141,212,992 0.00 106 0 411.49
gc cr block 2-way 260,332 0.00 95 0 0.76
CGS wait for IPC msg 7,817,309 99.96 79 0 22.78
control file parallel write 23,064 0.00 52 2 0.07
gcs drm freeze in enter server mode 161 12.42 50 311 0.00
cr request retry 52 90.38 44 845 0.00
gc current block busy 3,864 0.00 30 8 0.01
enq: WF - contention 211 24.17 29 137 0.00
gc current grant busy 42,990 0.00 22 1 0.13
gcs log flush sync 28,362 23.66 20 1 0.08
gc remaster 233 0.00 17 72 0.00
gc cr block busy 16,648 0.00 17 1 0.05
gc current grant 2-way 60,292 0.00 16 0 0.18
kjbdrmcvtq lmon drm quiesce: ping completion 324 29.01 14 42 0.00
log file sequential read 2,056 0.00 10 5 0.01
ksxr poll remote instances 803,471 38.41 10 0 2.34
DFS lock handle 31,297 0.01 9 0 0.09
enq: TX - index contention 1,322 0.00 9 7 0.00
os thread startup 257 0.39 8 32 0.00
enq: TM - contention 17,711 0.00 7 0 0.05
direct path write 11,484 0.00 7 1 0.03
wait for scn ack 7,935 0.00 6 1 0.02
direct path write temp 5,805 0.00 6 1 0.02
enq: XR - database force logging 19,265 0.00 6 0 0.06
latch: shared pool 5,260 0.00 5 1 0.02
library cache pin 14,894 0.00 5 0 0.04
latch: object queue header operation 22,338 0.00 5 0 0.07
cursor: pin S wait on X 434 98.62 4 10 0.00
ges global resource directory to be frozen 324 99.38 3 10 0.00
Log archive I/O 2,011 0.00 3 2 0.01
SQL*Net break/reset to client 11,804 0.00 3 0 0.03
rdbms ipc reply 13,193 0.00 3 0 0.04
gc cr disk read 6,977 0.00 3 0 0.02
gc object scan 20,030 98.97 3 0 0.06
direct path read temp 5,481 0.00 2 0 0.02
latch free 3,225 0.00 2 1 0.01
gc current block congested 892 0.00 2 2 0.00
latch: cache buffers chains 49,686 0.00 2 0 0.14
name-service call wait 15 0.00 1 75 0.00
enq: TX - row lock contention 1,543 0.00 1 1 0.00
gc cr grant congested 513 0.00 1 2 0.00
IPC send completion sync 3,673 99.97 1 0 0.01
enq: CF - contention 2,682 0.00 1 0 0.01
kksfbc child completion 15 100.00 1 49 0.00
PX Deq: reap credit 51,812 95.10 1 0 0.15
enq: PS - contention 2,024 0.00 1 0 0.01
buffer busy waits 1,048 0.00 1 0 0.00
log file switch completion 22 0.00 1 23 0.00
enq: TT - contention 1,625 0.00 0 0 0.00
gc current split 183 0.00 0 2 0.00
PX Deq: Signal ACK 1,151 22.07 0 0 0.00
gc cr block congested 75 0.00 0 4 0.00
enq: US - contention 1,134 0.00 0 0 0.00
latch: KCL gc element parent latch 6,262 0.00 0 0 0.02
enq: HW - contention 173 0.00 0 1 0.00
latch: library cache 132 0.00 0 1 0.00
PX Deq Credit: send blkd 1,186 36.00 0 0 0.00
gc current multi block request 894 0.00 0 0 0.00
gc current block unknown 271 0.00 0 1 0.00
global enqueue expand wait 14 92.86 0 9 0.00
LGWR wait for redo copy 2,972 0.00 0 0 0.01
KJC: Wait for msg sends to complete 3,905 0.00 0 0 0.01
library cache load lock 48 0.00 0 2 0.00
latch: row cache objects 467 0.00 0 0 0.00
enq: SQ - contention 64 0.00 0 1 0.00
latch: gcs resource hash 1,387 0.00 0 0 0.00
gc current retry 21 0.00 0 4 0.00
latch: ges resource hash list 934 0.00 0 0 0.00
enq: TD - KTF dump entries 192 0.00 0 0 0.00
latch: cache buffers lru chain 666 0.00 0 0 0.00
enq: TO - contention 156 0.00 0 0 0.00
enq: FB - contention 120 0.00 0 0 0.00
enq: JQ - contention 104 0.00 0 0 0.00
log file single write 32 0.00 0 1 0.00
undo segment extension 6,217 99.86 0 0 0.02
gc current grant congested 11 0.00 0 2 0.00
ges2 LMON to wake up LMD - mrcvr 291 1.03 0 0 0.00
enq: DR - contention 32 0.00 0 0 0.00
gc cr failure 40 0.00 0 0 0.00
wait list latch free 1 0.00 0 10 0.00
enq: MW - contention 32 0.00 0 0 0.00
enq: TX - contention 2 0.00 0 4 0.00
enq: TX - allocate ITL entry 10 0.00 0 1 0.00
enq: JS - job run lock - synchronize 17 0.00 0 0 0.00
buffer deadlock 315 96.51 0 0 0.00
enq: PG - contention 14 0.00 0 0 0.00
enq: AF - task serialization 12 0.00 0 0 0.00
ges inquiry response 5 0.00 0 0 0.00
enq: RO - fast object reuse 7 0.00 0 0 0.00
enq: WL - contention 4 0.00 0 0 0.00
latch: session allocation 2 0.00 0 0 0.00
latch: redo allocation 2 0.00 0 0 0.00
latch: checkpoint queue latch 1 0.00 0 0 0.00
PX qref latch 12 91.67 0 0 0.00
cursor: pin S 44 0.00 0 0 0.00
latch: messages 1 0.00 0 0 0.00
lock escalate retry 7 100.00 0 0 0.00
cursor: mutex S 28 0.00 0 0 0.00
latch: library cache lock 1 0.00 0 0 0.00
lock deadlock retry 1 100.00 0 0 0.00
SQL*Net message from client 141,212,977 0.00 8,724,692 62 411.49
gcs remote message 28,313,061 98.49 220,596 8 82.50
PX Idle Wait 24,491 92.71 57,700 2356 0.07
DIAG idle wait 288,078 0.00 56,264 195 0.84
ges remote message 2,469,250 81.11 56,187 23 7.20
Streams AQ: waiting for messages in the queue 5,952 100.00 56,183 9439 0.02
Streams AQ: qmn slave idle wait 2,244 8.56 56,101 25001 0.01
Streams AQ: qmn coordinator idle wait 4,947 41.50 56,097 11340 0.01
virtual circuit status 1,921 100.00 56,061 29183 0.01
Streams AQ: waiting for time management or cleanup tasks 192 100.00 53,909 280775 0.00
jobq slave wait 18,185 99.21 53,014 2915 0.05
PX Deq: Execution Msg 8,599 27.88 13 2 0.03
PX Deq: Execute Reply 947 28.62 2 3 0.00
PX Deq: Parse Reply 1,095 38.72 2 2 0.00
PX Deq: Join ACK 1,125 37.60 1 0 0.00
PX Deq: Msg Fragment 1,555 9.71 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 4,955 96.17 0 0 0.01
class slave wait 32 0.00 0 1 0.00
PX Deq Credit: need buffer 2 50.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 322,539 0.00 466 1 0.94
events in waitclass Other 8,743,929 93.02 261 0 25.48
db file parallel write 34,673 0.00 112 3 0.10
control file sequential read 162,550 0.00 79 0 0.47
control file parallel write 23,064 0.00 52 2 0.07
db file sequential read 9,836 0.00 40 4 0.03
log file sequential read 2,056 0.00 10 5 0.01
os thread startup 257 0.39 8 32 0.00
enq: TM - contention 17,653 0.00 6 0 0.05
row cache lock 12,622 0.02 5 0 0.04
library cache lock 13,128 0.00 4 0 0.04
Log archive I/O 2,011 0.00 3 2 0.01
gc cr block 2-way 7,771 0.00 3 0 0.02
gc object scan 20,030 98.97 3 0 0.06
gc current block 2-way 7,148 0.00 2 0 0.02
db file scattered read 342 0.00 2 4 0.00
gc current grant 2-way 3,101 0.00 1 0 0.01
direct path read 2,412 0.00 1 0 0.01
gc cr grant 2-way 1,248 0.00 0 0 0.00
db file parallel read 35 0.00 0 7 0.00
gc cr multi block request 715 0.00 0 0 0.00
direct path write 1,143 0.00 0 0 0.00
gc current grant busy 420 0.00 0 0 0.00
latch: cache buffers chains 356 0.00 0 0 0.00
library cache pin 155 0.00 0 0 0.00
log file single write 32 0.00 0 1 0.00
latch: shared pool 104 0.00 0 0 0.00
latch: library cache 7 0.00 0 3 0.00
latch: row cache objects 168 0.00 0 0 0.00
gc cr block busy 15 0.00 0 1 0.00
buffer busy waits 63 0.00 0 0 0.00
gc current block congested 1 0.00 0 2 0.00
enq: RO - fast object reuse 7 0.00 0 0 0.00
gc current multi block request 7 0.00 0 0 0.00
gc buffer busy 1 0.00 0 0 0.00
rdbms ipc message 1,991,521 43.46 782,346 393 5.80
gcs remote message 28,313,136 98.49 220,596 8 82.50
DIAG idle wait 288,079 0.00 56,265 195 0.84
pmon timer 19,802 99.55 56,223 2839 0.06
ges remote message 2,469,274 81.11 56,187 23 7.20
smon timer 12,492 94.95 56,185 4498 0.04
Streams AQ: qmn slave idle wait 2,244 8.56 56,101 25001 0.01
Streams AQ: qmn coordinator idle wait 4,947 41.50 56,097 11340 0.01
Streams AQ: waiting for time management or cleanup tasks 192 100.00 53,909 280775 0.00
PX Deq: Parse Reply 444 43.02 1 1 0.00
PX Deq: Join ACK 467 40.90 0 1 0.00
PX Deq: Execute Reply 298 34.90 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 4,955 96.17 0 0 0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 707,055
AVG_IDLE_TIME 5,060,516
AVG_IOWAIT_TIME 61,482
AVG_SYS_TIME 357,359
AVG_USER_TIME 347,864
BUSY_TIME 11,341,796
IDLE_TIME 80,996,859
IOWAIT_TIME 1,012,966
SYS_TIME 5,747,180
USER_TIME 5,594,616
LOAD 0
OS_CPU_WAIT_TIME 8,684,600
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 32,614,907,904
NUM_CPUS 16
NUM_CPU_CORES 8

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 46,874.80 28,605.70 41,221,201 1,768,961,179
pmssn 29,506.90 25,381.50 10,765,292 516,332,480
SYS$BACKGROUND 0.00 0.00 22,292 1,457,183
pmssnXDB 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
SYS$USERS 6728332 1188416 845389 26716 0 0 16213396 3203
pmssn 3803628 553952 135855 3996 0 0 160960640 63451
SYS$BACKGROUND 23490 8204 68745 2967 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
2,409 1,986 782 3.08 3.15 bm9mh4ubm90jn   select atvi.atvi_id, atvi.atvi...
1,851 160 1,214 1.52 2.42 fk6d9rppc51v6   update mw_sys.mwt_is_ulog set ...
1,771 1,733 1 1771.27 2.32 06yjtfd9rtf9h   DECLARE job BINARY_INTEGER := ...
513 498 1 512.67 0.67 db43qjdrpc70q exp@pmsapp7 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
462 452 1 462.17 0.61 b3raptfj8k5jw   insert into MW_APP.MWT_UD_SBD_...
446 426 6,939 0.06 0.58 7hksrgghfa4a9   WITH BZLB AS (SELECT OBJ_ID FR...
445 425 6,939 0.06 0.58 1zzkb4mcqan29   WITH BZLB AS (SELECT OBJ_ID FR...
407 400 1 407.15 0.53 44dbzfckgm0nt   insert into MW_APP.MWT_UD_SBD_...
405 398 1 405.20 0.53 4v40np38m2wh0   insert into MW_APP.MWT_UD_SBD_...
404 398 1 404.20 0.53 80cxazh5ghzkr   insert into MW_APP.MWT_UD_SBD_...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
1,986 2,409 782 2.54 3.15 bm9mh4ubm90jn   select atvi.atvi_id, atvi.atvi...
1,733 1,771 1 1732.82 2.32 06yjtfd9rtf9h   DECLARE job BINARY_INTEGER := ...
498 513 1 498.08 0.67 db43qjdrpc70q exp@pmsapp7 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
452 462 1 451.54 0.61 b3raptfj8k5jw   insert into MW_APP.MWT_UD_SBD_...
426 446 6,939 0.06 0.58 7hksrgghfa4a9   WITH BZLB AS (SELECT OBJ_ID FR...
425 445 6,939 0.06 0.58 1zzkb4mcqan29   WITH BZLB AS (SELECT OBJ_ID FR...
400 407 1 399.92 0.53 44dbzfckgm0nt   insert into MW_APP.MWT_UD_SBD_...
398 405 1 398.37 0.53 4v40np38m2wh0   insert into MW_APP.MWT_UD_SBD_...
398 404 1 398.07 0.53 80cxazh5ghzkr   insert into MW_APP.MWT_UD_SBD_...
382 394 190 2.01 0.52 f676t7k7cxx0v   select count(distinct s.OBJ_ID...
160 1,851 1,214 0.13 2.42 fk6d9rppc51v6   update mw_sys.mwt_is_ulog set ...

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
179,579,998 1 179,579,998.00 7.85 1732.82 1771.27 06yjtfd9rtf9h   DECLARE job BINARY_INTEGER := ...
124,950,642 782 159,783.43 5.46 1986.24 2409.22 bm9mh4ubm90jn   select atvi.atvi_id, atvi.atvi...
48,337,367 1 48,337,367.00 2.11 451.54 462.17 b3raptfj8k5jw   insert into MW_APP.MWT_UD_SBD_...
40,825,545 6,939 5,883.49 1.79 425.19 444.53 1zzkb4mcqan29   WITH BZLB AS (SELECT OBJ_ID FR...
40,825,545 6,939 5,883.49 1.79 426.05 445.87 7hksrgghfa4a9   WITH BZLB AS (SELECT OBJ_ID FR...
40,656,225 1 40,656,225.00 1.78 399.92 407.15 44dbzfckgm0nt   insert into MW_APP.MWT_UD_SBD_...
40,124,431 1 40,124,431.00 1.75 398.37 405.20 4v40np38m2wh0   insert into MW_APP.MWT_UD_SBD_...
38,578,139 1 38,578,139.00 1.69 398.07 404.20 80cxazh5ghzkr   insert into MW_APP.MWT_UD_SBD_...
31,551,882 1 31,551,882.00 1.38 498.08 512.67 db43qjdrpc70q exp@pmsapp7 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
27,775,644 23,266 1,193.83 1.21 259.46 272.37 5juk8y3yda77s   WITH BZLB AS (SELECT OBJ_ID FR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
1,991,241 1 1,991,241.00 3.83 375.33 390.19 1qy1za93c0k6w exp@pmsapp7 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
613,800 1 613,800.00 1.18 498.08 512.67 db43qjdrpc70q exp@pmsapp7 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
446,052 1,214 367.42 0.86 160.43 1851.01 fk6d9rppc51v6   update mw_sys.mwt_is_ulog set ...
431,664 0   0.83 169.43 189.76 bu16uu25x699a exp@pmsapp7 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
231,335 94 2,461.01 0.44 102.29 267.28 au43pr9wqmtus   select count(distinct s.OBJ_ID...
152,989 1 152,989.00 0.29 125.86 130.85 5rpf36chbf3x0 exp@pmsapp7 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
151,778 4 37,944.50 0.29 18.22 34.45 6y310d5p7d3n2   select count(*) rowCount from ...
146,561 1 146,561.00 0.28 11.58 27.55 bs7pw0ux5z8p3   select MW_SYS.MWT_OM_OBJ.CLS_I...
140,918 2 70,459.00 0.27 5.87 19.86 gg86m3fv3r7gk   UPDATE MWT_UD_ZYWBGL_XSJL SET ...
124,189 1 124,189.00 0.24 32.80 70.40 5gvxt3thjpzg8   SELECT COUNT(*) total FROM ( W...

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,392,590 2,392,553 1.00 0.00 0.00 8kq099mqn2wvz   select * from MW_SYS.MWT_OM_AT...
768,612 768,605 1.00 0.00 0.00 fjnfur1a3p4kt   select * from MW_SYS.MWT_OM_CL...
305,010 5,285,003 17.33 0.00 0.00 db78fxqxwxt7r   select /*+ rule */ bucket, en...
278,274 278,261 1.00 0.00 0.00 520mkxqpf15q8   select 1 from dual
241,817 272,807 1.13 0.00 0.00 53saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
217,460 201,797 0.93 0.00 0.00 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
140,508 140,508 1.00 0.00 0.00 810d9pmxsqfh4   select MW_SYS.mwt_td_tasklock....
109,174 109,174 1.00 0.00 0.00 7h35uxf5uhmm1   select sysdate from dual
88,370 111,130 1.26 0.00 0.00 6769wyy3yf66f   select pos#, intcol#, col#, sp...
62,555 62,555 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
278,271 278,274 9.20 520mkxqpf15q8   select 1 from dual
109,174 109,174 3.61 7h35uxf5uhmm1   select sysdate from dual
62,555 62,555 2.07 2ym6hhaq30r73   select type#, blocks, extents,...
59,105 59,105 1.95 grwydz59pu6mc   select text from view$ where r...
58,948 58,948 1.95 9gucmzb2wt8jv   select dm1.dm, dm1.dmmc from m...
57,118 57,118 1.89 7bm198dnymcu2   select dm1.dm, dm1.dmmc from ...
56,702 56,702 1.87 f15qdw0bjsw6w   select dm1.bzdm, dm1.dmmc f...
54,764 54,764 1.81 49fq6jtv406dq   select app_id, attr_id, cls_id...
52,878 52,878 1.75 53ksqv91u8h4n   select dm1.dm, dm1.dmmc from ...
50,258 50,258 1.66 bvphnq5j5xqxf   select dm1.dm, dm1.dmmc from ...
32,459 140,508 1.07 810d9pmxsqfh4   select MW_SYS.mwt_td_tasklock....
31,455 40,475 1.04 2q93zsrvbdw48   select grantee#, privilege#, n...
31,182 40,125 1.03 6aq34nj2zb2n7   select col#, grantee#, privi...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
406 522 d68rk6bx0zj4m   INSERT INTO "GOLDENGATE" ."GGS...
121 80 15zytu14qzw6p   insert into sys.aud$( sessioni...
109 699 08p2v79004c3u   insert into mw_app.mwt_cbm_jkc...
109 699 cu9tu7fwvj56p   insert into mw_app.mwt_ud_jk_c...
108 699 1a2upppsh6kky   insert into mw_app.mwt_ud_sgci...
108 699 9q1vxb7mh5m9k   insert into mw_app.mwt_ud_zxjh...
83 1,214 fk6d9rppc51v6   update mw_sys.mwt_is_ulog set ...
82 210 fwfptqpw2yq4z   update mw_sys.mwt_is_ulog set ...
60 19,090 83taa7kaw59c1   select name, intcol#, segcol#,...
57 19,815 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
56 3 6wtwd2nssvk5g sqlplus@pmsdb1 (TNS V1-V3) INSERT INTO "GOLDENGATE" ."GGS...
54 3 21st5cd8vtbuc sqlplus@pmsdb1 (TNS V1-V3) INSERT INTO "GOLDENGATE" ."GGS...
48 225 1pgp558xspvaa   SELECT PROPERTY FROM SYS.TAB$ ...
47 240 1p46wvpp44zqy   UPDATE MW_APP.MWT_CBM_BDSBZXZT...
46 267 3g1ght60fnk5y sqlplus@pmsdb1 (TNS V1-V3) SELECT DECODE(:B1 , 'NEXT OBJ...
43 141 423vstdr8ta05   SELECT COUNT(SBTZ.OBJ_ID) FROM...
39 32,953 a73wbv1yu8x5c   select con#, type#, condlength...
35 62,555 2ym6hhaq30r73   select type#, blocks, extents,...
32 104 73ab3utas77gp   INSERT INTO MW_APP.MWT_CBM_ZXJ...
31 30 30ad14bvyhnfy   SELECT XQTS FROM MW_APP.MWT_UD...
31 59,105 grwydz59pu6mc   select text from view$ where r...
30 31,039 31s7zydyypuwd   insert into MW_APP.MWT_UD_KW_S...
30 230 5vc3m7jzy576w   SELECT OBJ_ID FROM MW_APP.MWT_...
27 17,126 1gu8t96d0bdmu   select t.ts#, t.file#, t.block...
27 217,460 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
26 33 9zb47ttz6apj8   SELECT ROUND(DECODE(XYXQ, 0, 0...
24 10 26mnxwtaa77cf   INSERT INTO MW_APP.MWT_UD_SBDY...
24 30 8vxpgv2yxf4hk   SELECT COUNT(QXXZ) FROM MW_APP...
24 33 cc21j2k7u66kc   SELECT COUNT(QXXZ) FROM MW_APP...
22 241,817 53saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
22 13 84k46a5ppzwxf   SELECT COUNT(*) FROM MW_APP.MW...
22 13 84k46a5ppzwxf   SELECT COUNT(*) FROM MW_APP.MW...
22 30 931v50y6ak8bx   SELECT COUNT(QXXZ) FROM MW_APP...
22 39,849 f8pavn1bvsj7t   select con#, obj#, rcon#, enab...
21 37,677 04xtrk7uyhknh   select obj#, type#, ctime, mti...
21 40,475 2q93zsrvbdw48   select grantee#, privilege#, n...
21 11 dz5zwsz7bh59f   SELECT MW_SYS.F_LINK(DWMC) FRO...
21 152 gz37s22zstzty   UPDATE MW_APP.MWT_CBM_SBCSTZ S...

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
294.79 15.93 1,851.01 160.43 1,214 fk6d9rppc51v6   update mw_sys.mwt_is_ulog set ...
43.13 16.14 267.28 102.29 94 au43pr9wqmtus   select count(distinct s.OBJ_ID...
32.38 1.34 2,409.22 1,986.24 782 bm9mh4ubm90jn   select atvi.atvi_id, atvi.atvi...
30.38 5.92 512.67 498.08 1 db43qjdrpc70q exp@pmsapp7 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
21.60 28.12 76.82 37.35 31,039 31s7zydyypuwd   insert into MW_APP.MWT_UD_KW_S...
19.44 9.35 207.80 62.01 70 dgwcaqu1u31dz   select atvi.*, t.wi_isreserve...
16.66 73.53 22.66 8.09 1 fc97ywxymnam9   select atvd_id, atvd_name, n...
15.23 65.72 23.17 10.72 5 bs715s323n25j   select /*first_row*/count(*) f...
14.47 19.20 75.33 13.77 2 acbpxc63165qb   select atvd_id, atvd_name, n...
12.75 55.92 22.81 15.58 1 51nza7zpx2xxt   select MW_SYS.MWT_OM_OBJ.OBJ_I...
12.20 17.33 70.40 32.80 1 5gvxt3thjpzg8   SELECT COUNT(*) total FROM ( W...
10.48 62.14 16.86 10.12 2 3a82xcdm6qv5b   select MW_APP.MWT_UD_PD_SB_RH_...
8.84 58.22 15.18 11.37 1 89qpbqqzcwmuk   UPDATE MW_APP.MWT_UD_XDCCLJG S...
8.67 20.67 41.97 32.72 24,444 g1fsfqkvpbpby   insert into mw_app.mwt_ud_perf...
8.26 24.04 34.35 7.49 1 g8s6jn7m2kjk6   ...
8.19 50.71 16.16 10.52 1 09m8bj7k31gga   select /*first_row*/count(*) f...
7.84 19.02 41.23 24.20 21 2ypv0n7sqs8hk   SELECT HC.OBJ_ID, TZ.PMSSBID ...
7.41 32.08 23.09 7.44 1 9bdj4vdvz7ftu   ...
7.36 38.98 18.88 9.60 1 c8yyzffr8f0dh   select /*first_row*/count(*) f...
7.34 77.59 9.45 2.72 1 48byddf6xuc3g   select atvd_id, atvd_name, n...
6.78 33.02 20.52 7.55 1 05rjwr2rd4t8j   select /*first_row*/count(*) f...
6.77 19.67 34.45 18.22 4 6y310d5p7d3n2   select count(*) rowCount from ...
6.42 31.84 20.17 7.29 1 2p5ksy9vvgca2   select /*first_rows*/* from (s...
6.04 7.21 83.75 72.96 305,010 db78fxqxwxt7r   select /*+ rule */ bucket, en...
5.97 29.21 20.45 7.35 2 g6dg7suqk2bvm   SELECT ZXMJG.SZXZ, SY.OBJ_ID ...
5.88 34.59 17.00 5.78 1 ddnwfwts0vu7w   select /*first_rows*/* from (s...
5.73 4.20 136.42 67.11 58,375 6kxnggat861ur   SELECT CLS_ID, OBJ_CAPTION, ...
5.65 23.31 24.26 7.15 1 gjc7jkjz3pfhg   ...
4.91 31.94 15.38 13.81 24,400 5u0svy650t5sb   update mw_app.mwt_ud_perf_para...
4.86 25.62 18.97 5.42 2 6d2c40znkdp05   SELECT ZXMJG.SZXZ, SY.OBJ_ID ...
4.69 6.72 69.80 38.82 14,907 5zxyswks44dc9   select PRCIV_MTIME, PRCI_ID, P...
4.55 16.50 27.55 11.58 1 bs7pw0ux5z8p3   select MW_SYS.MWT_OM_OBJ.CLS_I...
4.16 5.39 77.14 56.14 13,348 5bnhtpt3u4c9v   select WI_ISACCEPTED, WI_NAME,...
4.03 52.30 7.70 1.57 2 c3ytk3q6ga5xc   select MW_APP.MWT_UD_JXGG_RKJH...
3.93 9.32 42.17 33.72 29,864 d8kxaryk2kpna   select ATVI_NOTE, ATVI_NAME, A...
3.54 33.40 10.59 9.43 25,058 7bpw23cxdxrz2   select * from mw_app.mwt_ud_pe...
3.35 24.60 13.61 4.64 1 1wgptrurn6z4h   BEGIN MW_APP.BZHZY_ZYWBGL.getC...
3.34 25.09 13.32 4.40 1 7t9hbnppwafta   select count(obj_id) from MWT...
3.30 7.84 42.02 29.63 53,933 fg9uc1pwq9gbx   select state_id from MW_APP.MW...
3.24 67.96 4.77 2.54 1 21x75265h6xjs   select /*first_row*/count(*) f...
2.91 21.10 13.81 4.09 1 gd3rd1srjnfq4   select count(obj_id) from MWT...
2.61 37.58 6.96 4.24 3 0r80k1a0xkjvc   SELECT COUNT(*) total FROM (SE...
2.46 15.96 15.44 1.50 210 fwfptqpw2yq4z   update mw_sys.mwt_is_ulog set ...
2.30 2.38 96.80 38.36 10,282 4j7gs1dk0vmjv   select TRSI_WID, TRSI_DISPIDX,...
1.58 24.12 6.57 2.60 2 5gx655mjqk2x7   select MW_APP.MWT_UD_JXGG_RKJH...
1.55 18.56 8.33 1.32 311 6jphgrt9f79u6   select * from (SELECT * FROM M...
1.52 17.18 8.82 8.59 140,508 810d9pmxsqfh4   select MW_SYS.mwt_td_tasklock....
1.51 24.12 6.25 4.52 5 bj8xr519anj8w perl@AMS-210 (TNS V1-V3) SELECT ...
1.50 15.73 9.55 2.79 1 7zd58guf6qyc2   UPDATE MW_APP.MWT_UD_SY_MPWB S...
1.38 5.56 24.90 23.59 1 68bj0m1m467by exp@pmsapp7 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
1.19 8.20 14.50 4.96 1 f8wqd13mrm30c   select '63EBEC8E-E766-40D7-ACF...
1.02 4.17 24.45 5.54 2,213 0dguwgwhftxjk   insert into MW_SYS.MWT_WF_TASK...
1.00 68.09 1.47 0.66 1 23tfjxtjz8gx1   SELECT * FROM (SELECT t0.*, RO...
0.92 3.41 26.94 17.24 160 cfcddf7ftyfhw   select atvi.atvi_id, atvi.atvi...
0.68 0.04 1,771.27 1,732.82 1 06yjtfd9rtf9h   DECLARE job BINARY_INTEGER := ...
0.56 16.41 3.42 3.38 20,926 591qw5jhtkfp9   SELECT MW_SYS.MWQ_OBJ_DISPIDX....
0.49 3.63 13.51 12.40 217,460 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
0.48 30.42 1.59 1.59 3,393 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
0.46 0.23 199.34 188.63 156 db2bdrp7ch098   DELETE FROM MW_APP.MWT_CBM_BDS...
0.36 0.40 90.97 84.08 1 d1zu1pu74m6ts   insert into MW_APP.MWT_UD_SBD_...
0.35 4.52 7.67 3.53 1 0xq76ft828q5q   select /*+rule*/ '63EBEC8E-E76...
0.32 23.87 1.34 0.75 240 1p46wvpp44zqy   UPDATE MW_APP.MWT_CBM_BDSBZXZT...
0.29 3.64 7.89 0.35 1 3w2mq69uq2n1g   DELETE FROM MW_APP.MWT_UD_LP_R...
0.27 69.74 0.38 0.36 529 axmdf8vq7k1rh   select increment$, minvalue, m...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
05rjwr2rd4t8jselect /*first_row*/count(*) from MW_APP.MWT_UD_XDCCLJG where 1=1 AND ((( obj_id in (select obj_id from(select rownum rn, t.* from(select obj_id from mw_app.mwt_ud_xdccljg where cljlid='D85C4AE8-9143-43B7-A5DE-F47601F4820F-30489' order by bh) t) where rn between 27 and 52))))
06yjtfd9rtf9hDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN MW_APP.MWP_UD_SBD_XLCDTJ_BYLEVEL('WS'); MW_APP.MWP_UD_SBD_XLCDTJ_BYLEVEL('DS'); MW_APP.MWP_UD_SBD_XLCDTJ_BYLEVEL('XS'); MW_APP.MWP_UD_SBD_XLCDTJ_BYLEVEL('GQ'); MW_APP.MWP_UD_SBD_XLCDTJ_BYLEVEL('BZ'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
08p2v79004c3uinsert into mw_app.mwt_cbm_jkczjl (obj_id, obj_dispidx, obj_caption, czdx, dxlx, czsj, czlx, czjg)(select obj_id, obj_dispidx, obj_caption, czdx, dxlx, czsj, czlx, czjg from mw_app.mwt_ud_jk_jkczjl jl where jl.dxlx in (select lylx from mw_app.mwt_cbm_ztxxjkpz where sfqy = 'T' and sjly='00599') and jl.obj_id = :1)
09m8bj7k31ggaselect /*first_row*/count(*) from MW_APP.MWT_UD_XDCCLJG where 1=1 AND ((( obj_id in (select obj_id from(select rownum rn, t.* from(select obj_id from mw_app.mwt_ud_xdccljg where cljlid='36717248-6DA3-446E-B946-D2F4CC4688AD-62391' order by bh) t) where rn between 79 and 104))))
0dguwgwhftxjkinsert into MW_SYS.MWT_WF_TASKINTEGRATE (APPSENDUID, TASK_CTIME, TASK_SENDTIME, ATVI_ID, TASKNAME, TASKDESC, STATEID, APPTASKID, TASK_DISPIDX, URL, APPRECEIVEUID, PRIORITYID, TASK_MTIME) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
0r80k1a0xkjvcSELECT COUNT(*) total FROM (SELECT SHEETINDEX.OBJ_ID, SHEETID, PATTERNNAME, MACHINE, DEPTNAME, DRAFTNAME, LEADER, SIGNISSUE, SHEETNAME, PAGENUM, PERMITER, PERMITSTARTTIME, ENDTIME, STATUSNAME, SHEETTYPENAME FROM MW_APP.MWT_UD_LP_SHEETINDEX SHEETINDEX, MW_APP.MWT_UD_LP_PATTERNINFO, MW_APP.MWT_UD_LP_STATUSMSG WHERE SHEETINDEX.PATTERNID=MW_APP.MWT_UD_LP_PATTERNINFO.PATTERNID AND SHEETINDEX.SHEETSTATUSID=MW_APP.MWT_UD_LP_STATUSMSG.STATUSID AND MW_APP.MWT_UD_LP_PATTERNINFO.MODULETYPE=1 AND mw_app.mwt_ud_lp_PATTERNINFO.moduletype=1 and (SHEETSTATUSID=11 AND SHEETTYPE = 1 AND ISMAINSHEET=1 AND ((SHEETINDEX.STATIONID IN (SELECT DISTINCT T2.STATIONID FROM MW_APP.MWT_UD_SBD_BDZWHBZPZ T1, MW_APP.MWT_UD_LP_WD_STATIONINFO T2 WHERE T1.BDZ = T2.OBJ_ID AND T1.WHDW = (SELECT DEPID FROM MW_APP.MWV_UD_LP_BMRYGX WHERE USERID = '02C1208D-F5EB-4939-B84C-DD4416DCB3BE' AND ROWNUM = 1))) OR (SHEETINDEX.DEPTID =(SELECT DEPID FROM MW_APP.MWV_UD_LP_BMRYGX WHERE USERID = '02C1208D-F5EB-4939-B84C-DD4416DCB3BE' AND ROWNUM = 1)))) and (ELECGRIDTYPE= 0 or ELECGRIDTYPE=2) ORDER BY PLANSTARTTIME DESC ) t0
0xq76ft828q5q select /*+rule*/ '63EBEC8E-E766-40D7-ACF4-FEA945102112-00155' as WSBM, ZRWDSL.RWDSL, BZSL.ZYWBSL, ZRWDSL.ZYXZMC from (select count(bzrwd.obj_id) RWDSL, bzrwd.zy ZYXZMC from (select * from ( select distinct (jx.obj_id) obj_id, decode(rwc.zy, '00201', '??', '00202', '??', '00203', '??') zy from mw_app.MWT_UD_JXGG_GZRWD gzrwd, mw_app.MWT_UD_JXGG_BZRWD jx, mw_app.mwt_ud_gg_rwc rwc where gzrwd.obj_id = jx.ssrwd and substr(jx.slrwids, 0, 42) = rwc.obj_id and to_char(gzrwd.BZRQ, 'yyyy-mm-dd') >= to_char(add_months(sysdate, -3), 'yyyy-mm-dd') and jx.gzbz in (select obj_id from mw_sys.mwt_pd_deps deps start with obj_id = (select glbcfg_value from mw_sys.mwt_is_glbcfg where glbcfg_key = 'SYDW_OBJ_ID') connect by prior obj_id = sjbm) union all select distinct (bzzyrwd.obj_id) obj_id, decode(substr(decode(substr(bzzyrwd.zy, 0, 4), '9180', '19180', bzzyrwd.zy), 0, 5), '19180', '??', '00201', '??', '00202', '??', '00203', '??') zy from mw_app.MWT_UD_BZZY_BZRWD bzzyrwd where to_char(bzzyrwd.bzsj, 'yyyy-mm-dd') >= to_char(add_months(sysdate, -3), 'yyyy-mm-dd') and bzzyrwd.gzbz in (select obj_id from mw_sys.mwt_pd_deps deps start with obj_id = (select glbcfg_value from mw_sys.mwt_is_glbcfg where glbcfg_key = 'SYDW_OBJ_ID') connect by prior obj_id = sjbm) ) rwd where rwd.zy is not null ) bzrwd group by bzrwd.zy) ZRWDSL, (select count(bzrwd.obj_id) ZYWBSL, bzrwd.zy ZYXZMC from (select * from ( select distinct (jx.obj_id) obj_id, decode(rwc.zy, '00201', '??', '00202', '??', '00 203', '??') zy from mw_app.MWT_UD_JXGG_GZRWD gzrwd, mw_app.MWT_UD_JXGG_BZRWD jx, mw_app.mwt_ud_gg_rwc rwc, mw_app.MWT_UD_ZYWBGL_ZYWBSYXX syxx where gzrwd.obj_id = jx.ssrwd and jx.obj_id = syxx.gzrwdid and substr(jx.slrwids, 0, 42) = rwc.obj_id and to_char(gzrwd.BZRQ, 'yyyy-mm-dd') >= to_char(add_months(sysdate, -3), 'yyyy-mm-dd') and jx.gzbz in (select obj_id from mw_sys.mwt_pd_deps deps start with obj_id = (select glbcfg_value from mw_sys.mwt_is_glbcfg where glbcfg_key = 'SYDW_OBJ_ID') connect by prior obj_id = sjbm) union all select distinct (bzzyrwd.obj_id) obj_id, decode(substr(decode(substr(bzzyrwd.zy, 0, 4), '9180', '19180', bzzyrwd.zy), 0, 5), '19180', '??', '00201', '??', '00202', '??', '00203', '??') zy from mw_app.MWT_UD_BZZY_BZRWD bzzyrwd, mw_app.MWT_UD_ZYWBGL_ZYWBSYXX syxx where bzzyrwd.obj_id = syxx.gzrwdid and to_char(bzzyrwd.bzsj, 'yyyy-mm-dd') >= to_char(add_months(sysdate, -3), 'yyyy-mm-dd') and bzzyrwd.gzbz in (select obj_id from mw_sys.mwt_pd_deps deps start with obj_id = (select glbcfg_value from mw_sys.mwt_is_glbcfg where glbcfg_key = 'SYDW_OBJ_ID') connect by prior obj_id = sjbm) ) rwd where rwd.zy is not null ) bzrwd group by bzrwd.zy) BZSL where ZRWDSL.ZYXZMC = BZSL.ZYXZMC(+)
15zytu14qzw6pinsert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34)
1a2upppsh6kkyinsert into mw_app.mwt_ud_sgcim_jkczjl (obj_id, obj_dispidx, obj_caption, czdx, dxlx, czsj, czlx, czjg, cljgxx, cwxxxx, sjcljg, czkzxx) (select obj_id, obj_dispidx, obj_caption, czdx, dxlx, czsj, czlx, czjg, cljgxx, cwxxxx, sjcljg, czkzxx from mw_app.mwt_ud_jk_jkczjl jl where jl.obj_id = :1)
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1p46wvpp44zqyUPDATE MW_APP.MWT_CBM_BDSBZXZT SET DQPJJG = :B11 , DQPJJGDM = :B10 , ZXPJJG = :B9 , ZXPJJGDM = :B8 , KFZTLZTMS = :B7 , GDBZ = :B6 , DQPJBG = :B5 , ZXPJBG = :B4 , DQPJSJ = :B3 , ZXPJSJ = :B2 WHERE OBJ_ID = :B1
1pgp558xspvaaSELECT PROPERTY FROM SYS.TAB$ WHERE OBJ# = :B1
1qy1za93c0k6wSELECT /*+NESTED_TABLE_GET_REFS+*/ "MW_SYS"."MWT_IS_SQLPERF".* FROM "MW_SYS"."MWT_IS_SQLPERF"
1wgptrurn6z4hBEGIN MW_APP.BZHZY_ZYWBGL.getContentofBlank (:1, :2); END;
1zzkb4mcqan29WITH BZLB AS (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS WHERE NVL(SFDLDW, 'F')<>'T' CONNECT BY PRIOR OBJ_ID = SJBM START WITH OBJ_ID = :B1 ) SELECT SUM(NVL(DJ, 0))/1000 FROM MW_APP.MWT_UD_SBD_YXGT WHERE SSXL = :B3 AND NVL(SFXNT, '0') <> '1' AND YXZT=:B2 AND GTSXH<>999999 AND GTWHBZ IN (SELECT OBJ_ID FROM BZLB)
21st5cd8vtbucINSERT INTO "GOLDENGATE" ."GGS_STICK" (PROPERTY, VALUE) VALUES ('lv_compat', :B1 )
21x75265h6xjsselect /*first_row*/count(*) from MW_APP.MWT_UD_JXGG_RKJH where 1=1 AND (((to_char(GZRQ, 'yyyy-mm-dd') = '2014-07-02' AND BZR = '5B528D1F-701F-4D79-B5D2-FD992B4E523F-00006')))
23tfjxtjz8gx1 SELECT * FROM (SELECT t0.*, ROWNUM AS count_id FROM (SELECT S.SHEETID, p.PATTERNNAME, MACHINE, WORKCONTENT, LEADER, SIGNISSUE, PERMITER, PERMITSTARTTIME, SHEETNAME, INFOTEXT8, INFOTEXT9, MAKETIME, PERMITSTARTTIME AS BEGINTIME, ENDTIME, PAGENUM, NVL((SELECT CASE WHEN A.THIRAUDITRESULT IN ('0', '1') THEN '?????' WHEN A.SECAUDITRESULT IN ('0', '1') THEN '?????' WHEN A.FIRAUDITRESULT IN ('0', '1') THEN '?????' ELSE '???' END FROM MW_APP.MWT_UD_LP_AUDITING A WHERE A.SHEETID = S.SHEETID), '???') AS SHQK, (SELECT CASE WHEN AUD.THIRAUDITRESULT IN ('0', '1') THEN AUD.THIRAUDITNAME WHEN AUD.SECAUDITRESULT IN ('0', '1') THEN AUD.SECAUDITNAME WHEN AUD.FIRAUDITRESULT IN ('0', '1') THEN AUD.FIRAUDITNAME ELSE '' END FROM MW_APP.MWT_UD_LP_AUDITING AUD WHERE AUD.SHEETID = S.SHEETID) AS SHR FROM (SELECT DEPTID, DEPTNAME, PATTERNID, ENDTIME, MAKETIME, PLANSTARTTIME, SHEETTYPE, WORKCONTENT, MACHINE, SHEETNAME, LEADER, STATIONID, SIGNISSUE, PAGENUM, INFOTEXT8, INFOTEXT9, PERMITSTARTTIME, PERMITER, SHEETID, T.DEPTID AS OLDDEPTID, SHEETSTATUSID, ELECGRIDTYPE, LEADERID, SIGNISSUEID, PERMITERID, AUDITRESULT, SFWWP FROM MW_APP.MWT_UD_LP_SHEETINDEX T) S, MW_APP.MWT_UD_LP_PATTERNINFO P WHERE S.PATTERNID = P.PATTERNID AND EXISTS (SELECT DEPID FROM MW_APP.MWV_UD_LP_DEPARTMENT WHERE DEPID = S.DEPTID) and S.PATTERNID = P.PATTERNID AND MODULETYPE=1 AND (PATTERNTYPE=0 OR PATTERNTYPE=2) AND SHEETTYPE <> 2 AND SUBSTR(MAKETIME, 0, 10) >= '2014-01-01' AN D SUBSTR(MAKETIME, 0, 10) <= '2014-06-30' and (ELECGRIDTYPE= 0 or ELECGRIDTYPE=2) and (sheetstatusid = 11 or sheettype = 5 or sheettype = 8) AND (SFWWP = 'F' OR SFWWP IS NULL) AND (olddeptid in (SELECT DEPID FROM MW_APP.MWV_UD_LP_DEPARTMENT START WITH DEPID = 'A75B6776-8265-46A1-9776-35FA9DA0ED31-01933' CONNECT BY PRIOR DEPID = DEPENDCODE) or exists (select stationid from mw_app.mwt_ud_lp_wd_stationinfo station, mw_app.mwt_ud_sbd_bdz bdz where station.stationid = S.stationid and station.obj_id = bdz.obj_id and bdz.yxbm in (SELECT DEPID FROM MW_APP.MWV_UD_LP_DEPARTMENT START WITH DEPID = 'A75B6776-8265-46A1-9776-35FA9DA0ED31-01933' CONNECT BY PRIOR DEPID = DEPENDCODE)) or exists (select stationid from mw_app.mwt_ud_lp_wd_stationinfo station, mw_app.MWT_UD_SBD_XLXX xlxx, mw_app.mwt_ud_sbd_xlfdxx fdxx where station.stationid = S.stationid and fdxx.dqxlid = xlxx.obj_id and station.obj_id = xlxx.obj_id and (xlxx.sssj in (SELECT DEPID FROM MW_APP.MWV_UD_LP_DEPARTMENT START WITH DEPID = 'A75B6776-8265-46A1-9776-35FA9DA0ED31-01933' CONNECT BY PRIOR DEPID = DEPENDCODE)or fdxx.yxdw in (SELECT DEPID FROM MW_APP.MWV_UD_LP_DEPARTMENT START WITH DEPID = 'A75B6776-8265-46A1-9776-35FA9DA0ED31-01933' CONNECT BY PRIOR DEPID = DEPENDCODE))) or exists (select stationid from mw_app.mwt_ud_lp_wd_stationinfo station, MW_APP.MWT_UD_PD_SB_RH_YXWZ xl where station.stationid = S.stationid and station.obj_id = xl.obj_id and xl.yxdw in (SELECT DEPID FROM MW_APP.MWV_UD_LP_DEPARTMENT STA RT WITH DEPID = 'A75B6776-8265-46A1-9776-35FA9DA0ED31-01933' CONNECT BY PRIOR DEPID = DEPENDCODE)) ) AND p.PATTERNID= 1011 AND DEPTID IN (SELECT DEPID FROM MW_APP.MWV_UD_LP_DEPARTMENT START WITH DEPID = 'A75B6776-8265-46A1-9776-35FA9DA0ED31-00007' CONNECT BY PRIOR DEPID = DEPENDCODE) AND S.AUDITRESULT = 0 AND (SFWWP = 'F' OR SFWWP IS NULL)) t0) t1 WHERE count_id BETWEEN 0+1 AND 15
26mnxwtaa77cfINSERT INTO MW_APP.MWT_UD_SBDYX_BDSBLLTJ (BMMC, QXLB, QXLBMC, FXQS, XQQS, WXQQS, XQL, WJSXQ, JSL) VALUES(:B7 , '??', '??', :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
2p5ksy9vvgca2select /*first_rows*/* from (select t.*, rownum rn from (select MW_APP.MWT_UD_XDCCLJG.OBJ_ID, MW_APP.MWT_UD_XDCCLJG.CLJLID, MW_APP.MWT_UD_XDCCLJG.BH, MW_APP.MWT_UD_XDCCLJG.DY, MW_APP.MWT_UD_XDCCLJG.OBJ_DISPIDX from MW_APP.MWT_UD_XDCCLJG where 1=1 AND ((( obj_id in (select obj_id from(select rownum rn, t.* from(select obj_id from mw_app.mwt_ud_xdccljg where cljlid='D85C4AE8-9143-43B7-A5DE-F47601F4820F-30489' order by bh) t) where rn between 1 and 26)))) order by BH) t where rownum<=1000) where rn>=1
2q93zsrvbdw48select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
2ypv0n7sqs8hkSELECT HC.OBJ_ID, TZ.PMSSBID AS SSSB, GL.PMSSBLX AS SBLX, BG.BGSJ AS PJSJ, JG.PJJG AS PJJGBM, PJJG.DMMC AS PJJGMC, JG.KFMS AS KFZTLMS, JCJY.JYJXFL AS JXFLBM, JXFL.DMMC AS JXFLMC, JCJY.CLJY, BG.OBJ_ID AS SSPJBG, BG.PJRQM, BG.SHRQM, BG.PJBB, ZTPJJG.OBJ_ID AS SCPJBG, BG.PJLX, BG.PJFS, BG.PJJB, JCJY.JYJXSJ, JCJY.JYSYSJ FROM MW_APP.MWT_CBM_SBPJBG BG INNER JOIN MW_APP.MWT_CBM_SBPJJLHC HC ON BG.OBJ_ID = HC.SSPJBG INNER JOIN MW_APP.MWT_CBM_BDSBBGGL BGGL ON BG.OBJ_ID = BGGL.PJBG INNER JOIN MW_APP.MWT_CBM_BDSBPJJG JG ON BGGL.SSPJJL = JG.OBJ_ID INNER JOIN MW_APP.MWT_CBM_SBTZ TZ ON TZ.OBJ_ID = JG.SSSB INNER JOIN MW_APP.MWT_CBM_BDPJDX DX ON BG.PJDX = DX.OBJ_ID INNER JOIN MW_APP.MWT_CBM_SBLXYPJDZGL GL ON DX.DZGL = GL.OBJ_ID LEFT JOIN MW_APP.MWT_CBM_SBJCJY JCJY ON BG.OBJ_ID = JCJY.PJBG AND BG.PJDX = JCJY.PJDX LEFT JOIN MW_APP.MWT_PMSCBM_ZTPJJG ZTPJJG ON ZTPJJG.SSSB = JG.SSSB AND ZTPJJG.SSPJBG = BG.SCPJBG LEFT JOIN MW_APP.MWT_CBM_GGDM PJJG ON PJJG.DM = BG.PJJG AND PJJG.DMLB = '009' LEFT JOIN MW_APP.MWT_CBM_GGDM JXFL ON JXFL.DM = JCJY.JYJXFL AND JXFL.DMLB = '014' WHERE ROWNUM <100
30ad14bvyhnfySELECT XQTS FROM MW_APP.MWT_UD_SBDYX_BDQXXQSJ WHERE QXLB=:B1
31s7zydyypuwdinsert into MW_APP.MWT_UD_KW_SJBGJL t (obj_id, obj_dispidx, czdx, dxlx, czsj, czlx, czjg) values(:1, MW_SYS.MWQ_OBJ_DISPIDX.NEXTVAL, :2, :3, systimestamp(6), :4, :5)
3a82xcdm6qv5bselect MW_APP.MWT_UD_PD_SB_RH_YXWZ.CLS_ID, MW_APP.MWT_UD_PD_SB_RH_YXWZ.OBJ_ID, MW_APP.MWT_UD_PD_SB_RH_YXWZ.OBJ_CAPTION, MW_APP.MWT_UD_PD_SB_RH_YXWZ.STATE_ID, MW_APP.MWT_UD_PD_SB_RH_YXWZ.OBJ_DISPIDX from MW_APP.MWT_UD_PD_SB_RH_YXWZ where (YXWZLB='5F017131-22C2-48E5-9EA2-2897DB60FBB8-00797' and objid in (select obj_id from mw_app.MWT_UD_PD_SB_RH_XL where LX='38602' or LX='38603') and (YXDW='EF141250-B063-4B9A-B247-4B4BB27DF722-49414' OR INSTR(WHBZ, (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS WHERE MW_SYS.MWT_PD_DEPS.obj_id=(select emps.lsbm from mw_sys.mwt_pd_emps emps where emps.sysuserid='B5342BE0-A32E-4067-A1C0-EEEAD22AA5EF')))>0)) AND (YXWZLB='5F017131-22C2-48E5-9EA2-2897DB60FBB8-00797' and objid in (select obj_id from mw_app.MWT_UD_PD_SB_RH_XL where LX='38602' or LX='38603') and (YXDW='EF141250-B063-4B9A-B247-4B4BB27DF722-49414' OR INSTR(WHBZ, (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS WHERE MW_SYS.MWT_PD_DEPS.obj_id=(select emps.lsbm from mw_sys.mwt_pd_emps emps where emps.sysuserid='B5342BE0-A32E-4067-A1C0-EEEAD22AA5EF')))>0)) order by mc asc
3g1ght60fnk5ySELECT DECODE(:B1 , 'NEXT OBJECT', 0, 'INDEX', 1, 'TABLE', 2, 'CLUSTER', 3, 'VIEW', 4, 'SYNONYM', 5, 'SEQUENCE', 6, 'PROCEDURE', 7, 'FUNCTION', 8, 'PACKAGE', 9, 'PACKAGE BODY', 11, 'TRIGGER', 12, 'TYPE', 13, 'TYPE BODY', 14, 'TABLE PARTITION', 19, 'INDEX PARTITION', 20, 'LOB', 21, 'LIBRARY', 22, 'DIRECTORY', 23, 'QUEUE', 24, 'JAVA SOURCE', 28, 'JAVA CLASS', 29, 'JAVA RESOURCE', 30, 'INDEXTYPE', 32, 'OPERATOR', 33, 'TABLE SUBPARTITION', 34, 'INDEX SUBPARTITION', 35, 'LOB PARTITION', 40, 'LOB SUBPARTITION', 42, 'DIMENSION', 43, 'CONTEXT', 44, 'RULE SET', 46, 'RESOURCE PLAN', 47, 'CONSUMER GROUP', 48, 'SUBSCRIPTION', 51, 'LOCATION', 52, 'XML SCHEMA', 55, 'JAVA DATA', 56, 'EDITION', 57, 'RULE', 59, 'CAPTURE', 60, 'APPLY', 61, 'EVALUATION CONTEXT', 62, 'JOB', 66, 'PROGRAM', 67, 'JOB CLASS', 68, 'WINDOW', 69, 'SCHEDULER GROUP', 72, 'SCHEDULE', 74, 'CHAIN', 79, 'FILE GROUP', 81, 'MINING MODEL', 82, 'ASSEMBLY', 87, 'CREDENTIAL', 90, 'CUBE DIMENSION', 92, 'CUBE', 93, 'MEASURE FOLDER', 94, 'CUBE BUILD PROCESS', 95, 'FILE WATCHER', 100, 'DESTINATION', 101, 'SQL TRANSLATION PROFILE', 104, '-1') FROM DUAL
3w2mq69uq2n1gDELETE FROM MW_APP.MWT_UD_LP_REMIND WHERE SHEETID = 2236320
423vstdr8ta05SELECT COUNT(SBTZ.OBJ_ID) FROM MW_APP.MWT_CBM_SBTZ SBTZ INNER JOIN MW_APP.MWT_UD_SBD_SB SB ON SB.OBJ_ID = SBTZ.PMSSBID WHERE SBTZ.OBJ_ID = :B1 AND SB.ZCSSJB='00401'
44dbzfckgm0nt insert into MW_APP.MWT_UD_SBD_SDXLCD_FJTJ (OBJ_ID, OBJ_DISPIDX, TJJB, TJDW, XL_OBJ_ID, DYDJ, DYDJSX, XLMC, XLBH, ZCXZ, ZCBH, ZCDW, YXDWID, YXDWMC, WHBZ, WHBZMC, JSFS, SJDYDJMC, DLXZ, TYRQ, SBBZ, SSDD, DDDWMC, SFDW, SFSZX, SSXL, KQYLX, SFJDJ, QDLX, XLQD, ZDLX, XLZD, ZDYXDL, YXFHXE, JJDL, DAOXXH, DIXXH, GTJS, JKCD, DLCD, ZXCD, XLCD, YXZT, SBBM, ZCBZQC, ZCRQ, TJSJ, BZ, shzt) select mw_app.EMS_COMMON.GetGUIDByOracle, mw_sys.mwq_obj_dispidx.nextval, 'DS', t1.tjdw, t.obj_id, t.dydj, t.dydjpx, t.xlmc, t.xlbh, t.zcxz, t.zcbh, t.zcdw, mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'yxdwid'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'yxdwmc'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'whbzid'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'whbzmc'), t.jsfs, (select mc from mw_app.mwt_ud_gy_dydj where rownum=1 and dm=t.sjdydj), t.dlxz, t.tyrq, t.sbbz, t.ssdd, (select mc from mw_sys.mwt_pd_deps where obj_id=t.ssdddw), t.sfdw, t.sfszx, t.ssxl, t.sffd, t.sfjdj, t.qdlx, t.qdms, t.zdlx, t.zdms, t.zdyxdl, t.yxfhxe, t.jjdl, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DaoDiX(t.obj_i d, t1.tjdw, '??') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DaoDiX(t.obj_id, t1.tjdw, '??') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_GTJS(t.obj_id, t.yxzt, t1.tjdw, 'DS') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DTCD('DS', t1.tjdw, t.obj_id, t.yxzt, 'JKCD') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DTCD('DS', t1.tjdw, t.obj_id, t.yxzt, 'DLCD') else null end, mw_app.MWF_UD_SBD_XLCDTJ_DTCD('DS', t1.tjdw, t.obj_id, t.yxzt, 'ZXCD'), ROUND(t.xlcd, 4), t.yxzt, t.global_id, (select bmqc from mw_sys.mwt_pd_deps where obj_id=t.whbz), t.zcrq, current_timestamp(6), t.bz, t.shzt from mw_app.mwt_ud_sbd_xlxx t, (select * from (select dqxlid, (select obj_id from mw_sys.mwt_pd_deps where rownum=1 and dwjb ='4' connect by prior sjbm=obj_id start with obj_id=t.whbz) tjdw from mw_app.mwt_ud_sbd_xlfdxx t where t.whlb='??') group by dqxlid, tjdw) t1 where t.obj_id=t1.dqxlid and nvl(t.sfsc, '0')<>'1' and t1.tjdw is not null
48byddf6xuc3gselect atvd_id, atvd_name, num from (select distinct atvd.atvd_id, atvd.atvd_name, atvd.atvd_dispidx, (select count(1) from mw_sys.mwt_wf_wi wi, mw_sys.mwt_wf_atvi atvi where wi.atvi_id = atvi.atvi_id and wi.wi_status in('A', 'F') and (wi.user_id = ru.user_id or (wi.user_id is null and wi.role_id in(select role_id from mw_sys.mwt_sm_roleuser rus where rus.user_id = ru.user_id))) and atvi.atvd_id = atvd.atvd_id) num from mw_sys.mwt_wf_atvr atvr inner join mw_sys.mwt_sm_roleuser ru on ru.role_id = atvr.role_id inner join mw_sys.mwt_wf_atvd atvd on atvr.atvd_id = atvd.atvd_id where atvd.prcd_id = '053B4949-5B6C-4E2C-9011-218098B54DAC' and ru.user_id = 'D2963DEA-C776-4943-8FAD-E239921CA560') order by atvd_dispidx
49fq6jtv406dqselect app_id, attr_id, cls_id, appattr_extopt from mw_sys.mwt_am_appattr where app_id='5894B26E-340C-415E-A499-33000040A0B7' and cls_id='F288816B-A10E-4961-91B9-BF3D6B4153E3' and appattr_extopt is not null
4j7gs1dk0vmjvselect TRSI_WID, TRSI_DISPIDX, TRSI_ID, ATVI_SID, TRSI_CTIME, TRSD_ID, ATVI_TID, TRSI_DESC, TRSI_NAME, TRSI_NOTE, TRSI_MTIME from MW_SYS.MWT_WF_TRSI where atvi_tid = :1 order by TRSI_DISPIDX desc
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4v40np38m2wh0 insert into MW_APP.MWT_UD_SBD_SDXLCD_FJTJ (OBJ_ID, OBJ_DISPIDX, TJJB, TJDW, XL_OBJ_ID, DYDJ, DYDJSX, XLMC, XLBH, ZCXZ, ZCBH, ZCDW, YXDWID, YXDWMC, WHBZ, WHBZMC, JSFS, SJDYDJMC, DLXZ, TYRQ, SBBZ, SSDD, DDDWMC, SFDW, SFSZX, SSXL, KQYLX, SFJDJ, QDLX, XLQD, ZDLX, XLZD, ZDYXDL, YXFHXE, JJDL, DAOXXH, DIXXH, GTJS, JKCD, DLCD, ZXCD, XLCD, YXZT, SBBM, ZCBZQC, ZCRQ, TJSJ, BZ, shzt) select mw_app.EMS_COMMON.GetGUIDByOracle, mw_sys.mwq_obj_dispidx.nextval, 'GQ', t1.tjdw, t.obj_id, t.dydj, t.dydjpx, t.xlmc, t.xlbh, t.zcxz, t.zcbh, t.zcdw, mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'yxdwid'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'yxdwmc'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'whbzid'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'whbzmc'), t.jsfs, (select mc from mw_app.mwt_ud_gy_dydj where rownum=1 and dm=t.sjdydj), t.dlxz, t.tyrq, t.sbbz, t.ssdd, (select mc from mw_sys.mwt_pd_deps where obj_id=t.ssdddw), t.sfdw, t.sfszx, t.ssxl, t.sffd, t.sfjdj, t.qdlx, t.qdms, t.zdlx, t.zdms, t.zdyxdl, t.yxfhxe, t.jjdl, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DaoDiX(t.obj_i d, t1.tjdw, '??') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DaoDiX(t.obj_id, t1.tjdw, '??') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_GTJS(t.obj_id, t.yxzt, t1.tjdw, 'GQ') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DTCD('GQ', t1.tjdw, t.obj_id, t.yxzt, 'JKCD') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DTCD('GQ', t1.tjdw, t.obj_id, t.yxzt, 'DLCD') else null end, mw_app.MWF_UD_SBD_XLCDTJ_DTCD('GQ', t1.tjdw, t.obj_id, t.yxzt, 'ZXCD'), ROUND(t.xlcd, 4), t.yxzt, t.global_id, (select bmqc from mw_sys.mwt_pd_deps where obj_id=t.whbz), t.zcrq, current_timestamp(6), t.bz, t.shzt from mw_app.mwt_ud_sbd_xlxx t, (select * from (select dqxlid, (select obj_id from mw_sys.mwt_pd_deps where rownum=1 and dwjb in ('5', '6', '7') connect by prior sjbm=obj_id start with obj_id=t.whbz) tjdw from mw_app.mwt_ud_sbd_xlfdxx t where t.whlb='??') group by dqxlid, tjdw) t1 where t.obj_id=t1.dqxlid and nvl(t.sfsc, '0')<>'1' and t1.tjdw is not null
51nza7zpx2xxtselect MW_SYS.MWT_OM_OBJ.OBJ_ID, MW_SYS.MWT_OM_OBJ.STATE_ID, MW_APP.MWT_UD_SBD_YXWZ.OBJ_DISPIDX from MW_SYS.MWT_OM_OBJ, MW_APP.MWT_UD_SBD_YXWZ where MW_APP.MWT_UD_SBD_YXWZ.OBJ_ID=MW_SYS.MWT_OM_OBJ.OBJ_ID and JGDY='A0EBBF86-631D-4F4D-AE94-3769C4125F1B-01162' and ((yxzt='20501')) order by SBLX, YXBH
520mkxqpf15q8select 1 from dual
53ksqv91u8h4nselect dm1.dm, dm1.dmmc from mw_app.mwt_ud_gg_dm dm1 where dm1.dmlb='894' and DM1.DM in ('89402') order by dm1.dm
53saa2zkr6wc3select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
591qw5jhtkfp9SELECT MW_SYS.MWQ_OBJ_DISPIDX.NEXTVAL FROM DUAL
5bnhtpt3u4c9vselect WI_ISACCEPTED, WI_NAME, ROLE_ID, WI_STATUS, ATVI_ID, WI_ISRESERVED, DEPT_ID, WI_ID, WI_MTIME, WI_CTIME, USER_ID, WI_WID, WI_DESC, WI_SCTIME, WI_DISPIDX, WI_AKIND, WI_ATIME, WI_NOTE from MW_SYS.MWT_WF_WI where atvi_id = :1 order by WI_DISPIDX asc
5gvxt3thjpzg8SELECT COUNT(*) total FROM ( WITH TMPTABLE AS ( (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS WHERE ZYXZ IN ('20805', '20807', '20806', '20814') AND SFCX = '63785359-B0D9-4548-8F18-4F8FD682D684' START WITH OBJ_ID='22F14364-ADB1-4AA5-B7F5-A9D56A57820B-04751' CONNECT BY PRIOR OBJ_ID=SJBM)) SELECT /*+ INDEX(YXRZJL INDEX_MWT_UD_SBDYX_YXRZJL_FSSJ)*/YXRZJL.OBJ_ID AS OBJID, YXRZJL.DWHBDZ AS DWHBDZ, TO_CHAR(FSSJ, 'YYYY-MM-DD HH24:MI') AS FSSJ , TO_CHAR(JLRQ, 'YYYY-MM-DD HH24:MI') AS JLRQ, YXRZJL.JLNR AS JLNR, EMPS.MC AS JLR, CASE WHEN (SELECT COUNT(D.BMQC) FROM MW_SYS.MWT_PD_DEPS D WHERE D.OBJ_ID= YXRZJL.DWHBDZ)>0 THEN (SELECT D.BMQC FROM MW_SYS.MWT_PD_DEPS D WHERE D.OBJ_ID= YXRZJL.DWHBDZ AND ROWNUM=1) ELSE YXRZJL.DWHBDZMC END DWHBDZMC FROM MW_APP.MWT_UD_SBDYX_YXRZJL YXRZJL, MW_SYS.MWT_PD_EMPS EMPS WHERE YXRZJL.SFJS='T' AND EMPS.OBJ_ID=YXRZJL.JLR AND YXRZJL.JLDW IN (SELECT * FROM TMPTABLE ) AND TO_CHAR(YXRZJL.FSSJ, 'YYYY-MM-DD HH24:MI:SS') BETWEEN '2014-06-01 00:00:00' AND '2014-06-30 23:59:59' AND DWHBDZ LIKE '%984ABF02-256F-4345-82C4-A1FE19788C9A-00002%' AND DWHBDZ LIKE '%984ABF02-256F-4345-82C4-A1FE19788C9A-00002%' AND XGJLPZBS IN (SELECT OBJ_ID FROM MW_APP.MWT_UD_SBDYX_YXJLPZ WHERE DYKB='MW_APP.MWT_UD_SBDYX_DDLJL' AND SFQY='T') ORDER BY YXRZJL.FSSJ) t0
5gx655mjqk2x7select MW_APP.MWT_UD_JXGG_RKJH.OBJ_ID, MW_APP.MWT_UD_JXGG_RKJH.OBJ_DISPIDX from MW_APP.MWT_UD_JXGG_RKJH where (((jhzt <> '1DD6F05F-CD98-4B2A-9902-5AE4BEB3E3B3' and jhzt <> '3475D6B3-C332-4C48-81B1-5B0C503F3B66') and (gzdd <> '?' and gznr <> '???')) and (ssds='A75B6776-8265-46A1-9776-35FA9DA0ED31-00011' and jhzt='CD9A8CA7-A5D0-4174-AB41-AF41402D7742' and gzrq = to_date('2014-07-01', 'yyyy-mm-dd') AND BZDW IN (SELECT D.OBJ_ID FROM MW_SYS.MWT_PD_DEPS D START WITH D.OBJ_ID='A75B6776-8265-46A1-9776-35FA9DA0ED31-00011' CONNECT BY PRIOR D.OBJ_ID=D.SJBM))) order by OBJ_DISPIDX
5juk8y3yda77sWITH BZLB AS (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS WHERE NVL(SFDLDW, 'F')<>'T' CONNECT BY PRIOR OBJ_ID = SJBM START WITH OBJ_ID = :B1 ) SELECT DISTINCT DDX.XH FROM MW_APP.MWT_UD_SBD_BLXTZ DDX, MW_APP.MWT_UD_SBD_YXGT GT WHERE DDX.SSXL=:B3 AND (DDX.QSGT=GT.OBJ_ID OR DDX.ZZGT = GT.OBJ_ID) AND DDX.XH IS NOT NULL AND GT.GTWHBZ IN (SELECT OBJ_ID FROM BZLB) AND DDX.LB = :B2
5rpf36chbf3x0SELECT /*+NESTED_TABLE_GET_REFS+*/ "MW_SYS"."MWT_IS_AUDITHIS".* FROM "MW_SYS"."MWT_IS_AUDITHIS" PARTITION ("P4")
5u0svy650t5sbupdate mw_app.mwt_ud_perf_param set KPINAME = :1, KPIVALUE = :2, DEPART_ID = :3, FREQUENCY = :4, OPERATETIME = :5, Note = :6, DESCRIPTION = :7 where KPINAME = :8 and DEPART_ID = :9
5vc3m7jzy576wSELECT OBJ_ID FROM MW_APP.MWT_CBM_BDSBZXZT WHERE SSSB =:B1 AND ROWNUM=1
5zxyswks44dc9select PRCIV_MTIME, PRCI_ID, PRCIV_ID, PRCIV_CTIME, PRCIV_VALUE, PRCIV_NAME from MW_SYS.MWT_WF_PRCIV where prci_id = :1
6769wyy3yf66fselect pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
68bj0m1m467bySELECT /*+NESTED_TABLE_GET_REFS+*/ "MW_APP"."MWT_UD_SBDYX_JJBXJNR".* FROM "MW_APP"."MWT_UD_SBDYX_JJBXJNR"
6aq34nj2zb2n7select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6d2c40znkdp05SELECT ZXMJG.SZXZ, SY.OBJ_ID FROM MW_APP.MWT_UD_SY_ZXMJG ZXMJG INNER JOIN MW_APP.MWT_UD_SY_SYSJZ SJZ ON SJZ.OBJ_ID = ZXMJG.SJZID INNER JOIN MW_APP.MWT_UD_SY_SYSBXM SYSBXM ON SYSBXM.OBJ_ID = SJZ.SYSBXMID INNER JOIN MW_APP.MWT_UD_SY_SYSB SYSB ON SYSB.OBJ_ID = SYSBXM.SYSBID INNER JOIN MW_APP.MWT_UD_SY_SY SY ON SY.OBJ_ID = SYSB.SYID WHERE SYSB.SBID = 'FF0B80F6-4E2D-4EDF-A885-5B3CFA201DB2-00161' AND SYSBXM.SYXMID = 'E601EE2D-9B93-465B-948C-408C3128700F-05717' AND ZXMJG.ZXMID = 'E601EE2D-9B93-465B-948C-408C3128700F-04508' AND ZXMJG.SYXB = '/' AND ZXMJG.SYBWID = 'E601EE2D-9B93-465B-948C-408C3128700F-04134' AND SY.KSSJ<(SELECT KSSJ FROM MW_APP.MWT_UD_SY_SY WHERE OBJ_ID='FCCF1793-3E12-203B-EE04-30AD00F0E03B-12345') ORDER BY SY.KSSJ DESC
6jphgrt9f79u6select * from (SELECT * FROM MW_SYS.MWT_AM_HISMENU WHERE USER_ID = :1 ORDER BY hismenu_count DESC) where rownum<10
6kxnggat861urSELECT CLS_ID, OBJ_CAPTION, SDOBJ_ID, OBJ_WID, CUSER_ID, MUSER_ID, OBJ_CTIME, OBJ_MTIME, STATE_ID, OBJ_LOCALID FROM MW_SYS.MWV_OM_OBJ WHERE OBJ_ID = :1
6wtwd2nssvk5gINSERT INTO "GOLDENGATE" ."GGS_STICK" (PROPERTY, VALUE) VALUES ('lv_version', :B1 )
6y310d5p7d3n2select count(*) rowCount from mw_app.MWT_UD_XDCCLJG where cljlid='36717248-6DA3-446E-B946-D2F4CC4688AD-62391'
73ab3utas77gpINSERT INTO MW_APP.MWT_CBM_ZXJKCZJL JL (OBJ_ID, OBJ_DISPIDX, CZSJ, CZLX, CZJG, CZDX, DXLX) VALUES(MW_SYS.NEWGUID ||'-'||TRUNC(DBMS_RANDOM.VALUE(10000, 99999)), MW_SYS.MWQ_OBJ_DISPIDX.NEXTVAL, SYSTIMESTAMP(6), :B3 , '0', :B2 , :B1 )
7bm198dnymcu2select dm1.dm, dm1.dmmc from mw_app.mwt_ud_gg_dm dm1 where dm1.dmlb='895' and DM1.DM in ('89501') order by dm1.dm
7bpw23cxdxrz2select * from mw_app.mwt_ud_perf_param where KPINAME = :1 and DEPART_ID = :2
7h35uxf5uhmm1select sysdate from dual
7hksrgghfa4a9WITH BZLB AS (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS WHERE NVL(SFDLDW, 'F')<>'T' CONNECT BY PRIOR OBJ_ID = SJBM START WITH OBJ_ID = :B1 ) SELECT COUNT(*) FROM MW_APP.MWT_UD_SBD_YXGT WHERE SSXL = :B3 AND NVL(SFXNT, '0') <> '1' AND YXZT=:B2 AND GTSXH<>0 AND GTSXH<>999999 AND GTWHBZ IN (SELECT OBJ_ID FROM BZLB)
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7t9hbnppwaftaselect count(obj_id) from MWT_UD_ZYWBGL_XSJL where ZYWBID='4918A3E3-00E2-4E0A-9D44-0932517038C2-00001' and WBXSID='6'
7zd58guf6qyc2UPDATE MW_APP.MWT_UD_SY_MPWB SET TEXT='59' WHERE SYID='FC7D20A2-25F3-8E14-8E04-30AD00F0DE14-12345' AND MPID='A1F43772-2FD9-4724-8236-B61E7D2FEDDB-00072' AND CELLID='BBDE9744-47F2-8424-9A77-EFA8126FCC43-12345'
80cxazh5ghzkr insert into MW_APP.MWT_UD_SBD_SDXLCD_FJTJ (OBJ_ID, OBJ_DISPIDX, TJJB, TJDW, XL_OBJ_ID, DYDJ, DYDJSX, XLMC, XLBH, ZCXZ, ZCBH, ZCDW, YXDWID, YXDWMC, WHBZ, WHBZMC, JSFS, SJDYDJMC, DLXZ, TYRQ, SBBZ, SSDD, DDDWMC, SFDW, SFSZX, SSXL, KQYLX, SFJDJ, QDLX, XLQD, ZDLX, XLZD, ZDYXDL, YXFHXE, JJDL, DAOXXH, DIXXH, GTJS, JKCD, DLCD, ZXCD, XLCD, YXZT, SBBM, ZCBZQC, ZCRQ, TJSJ, BZ, shzt) select mw_app.EMS_COMMON.GetGUIDByOracle, mw_sys.mwq_obj_dispidx.nextval, 'XS', t1.tjdw, t.obj_id, t.dydj, t.dydjpx, t.xlmc, t.xlbh, t.zcxz, t.zcbh, t.zcdw, mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'yxdwid'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'yxdwmc'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'whbzid'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'whbzmc'), t.jsfs, (select mc from mw_app.mwt_ud_gy_dydj where rownum=1 and dm=t.sjdydj), t.dlxz, t.tyrq, t.sbbz, t.ssdd, (select mc from mw_sys.mwt_pd_deps where obj_id=t.ssdddw), t.sfdw, t.sfszx, t.ssxl, t.sffd, t.sfjdj, t.qdlx, t.qdms, t.zdlx, t.zdms, t.zdyxdl, t.yxfhxe, t.jjdl, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DaoDiX(t.obj_i d, t1.tjdw, '??') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DaoDiX(t.obj_id, t1.tjdw, '??') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_GTJS(t.obj_id, t.yxzt, t1.tjdw, 'XS') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DTCD('XS', t1.tjdw, t.obj_id, t.yxzt, 'JKCD') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DTCD('XS', t1.tjdw, t.obj_id, t.yxzt, 'DLCD') else null end, mw_app.MWF_UD_SBD_XLCDTJ_DTCD('XS', t1.tjdw, t.obj_id, t.yxzt, 'ZXCD'), ROUND(t.xlcd, 4), t.yxzt, t.global_id, (select bmqc from mw_sys.mwt_pd_deps where obj_id=t.whbz), t.zcrq, current_timestamp(6), t.bz, t.shzt from mw_app.mwt_ud_sbd_xlxx t, (select * from (select dqxlid, (select obj_id from mw_sys.mwt_pd_deps where rownum=1 and dwjb in ('5', '6') connect by prior sjbm=obj_id start with obj_id=t.whbz) tjdw from mw_app.mwt_ud_sbd_xlfdxx t where t.whlb='??') group by dqxlid, tjdw) t1 where t.obj_id=t1.dqxlid and nvl(t.sfsc, '0')<>'1' and t1.tjdw is not null
810d9pmxsqfh4select MW_SYS.mwt_td_tasklock.*, sysdate as now_time from MW_SYS.mwt_td_tasklock where lock_id=:1
83taa7kaw59c1select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
84k46a5ppzwxfSELECT COUNT(*) FROM MW_APP.MWT_UD_SBD_YXGT WHERE YXZT = '10801' AND GTSXH >0 AND GTSXH < 999999 AND SSXL = :B1
89qpbqqzcwmuk UPDATE MW_APP.MWT_UD_XDCCLJG SET DY=(CASE WHEN BH=1 THEN '2.21' WHEN BH=2 THEN '2.24' WHEN BH=3 THEN '2.22' WHEN BH=4 THEN '2.24' WHEN BH=5 THEN '2.24' WHEN BH=6 THEN '2.25' WHEN BH=7 THEN '2.23' WHEN BH=8 THEN '2.24' WHEN BH=9 THEN '2.2' WHEN BH=10 THEN '2.24' WHEN BH=11 THEN '2.21' WHEN BH=12 THEN '2.24' WHEN BH=13 THEN '2.24' WHEN BH=14 THEN '2.21' WHEN BH=15 THEN '2.2' WHEN BH=16 THEN '2.24' WHEN BH=17 THEN '2.24' WHEN BH=18 THEN '2.24' WHEN BH=19 THEN '2.22' WHEN BH=20 THEN '2.22' WHEN BH=21 THEN '2.21' WHEN BH=22 THEN '2.22' WHEN BH=23 THEN '2.22' WHEN BH=24 THEN '2.24' WHEN BH=25 THEN '2.23' WHEN BH=26 THEN '2.24' WHEN BH=27 THEN '2.21' WHEN BH=28 THEN '2.22' WHEN BH=29 THEN '2.23' WHEN BH=30 THEN '2.23' WHEN BH=31 THEN '2.24' WHEN BH=32 THEN '2.2' WHEN BH=33 THEN '2.27' WHEN BH=34 THEN '2.22' WHEN BH=35 THEN '2.23' WHEN BH=36 THEN '2.24' WHEN BH=37 THEN '2.22' WHEN BH=38 THEN '2.24' WHEN BH=39 THEN '2.2' WHEN BH=40 THEN '2.22' WHEN BH=41 THEN '2.23' WHEN BH=42 THEN '2.21' WHEN BH=43 THEN '2.22' WHEN BH=44 THEN '2.25' WHEN BH=45 THEN '2.21' WHEN BH=46 THEN '2.21' WHEN BH=47 THEN '2.25' WHEN BH=48 THEN '2.23' WHEN BH=49 THEN '2.24' WHEN BH=50 THEN '2.24' WHEN BH=51 THEN '2.24' WHEN BH=52 THEN '2.23' WHEN BH=53 THEN '2.24' WHEN BH=54 THEN '2.25' WHEN BH=55 THEN '2.09' WHEN BH=56 THEN '2.23' WHEN BH=57 THEN '2.21' WHEN BH=58 THEN '2.24' WHEN BH=59 THEN '2.24' WHEN BH=60 THEN '2.23' WHEN BH=61 THEN '2.24' WHEN BH=62 THEN '2.21' WHEN BH=63 THEN '2.24' WHEN BH=64 THEN '2.23' WHEN BH=65 THEN '2.24' WHEN BH=66 THEN '2.22' WHEN BH=67 THEN '2.21' WHEN BH=68 THEN '2.23' WHEN BH=69 THEN '2.24' WHEN BH=70 THEN '2.24' WHEN BH=71 THEN '2.19' WHEN BH=72 THEN '2.24' WHEN BH=73 THEN '2.23' WHEN BH=74 THEN '2.23' WHEN BH=75 THEN '2.21' WHEN BH=76 THEN '2.21' WHEN BH=77 THEN '2.23' WHEN BH=78 THEN '2.23' WHEN BH=79 THEN '2.23' WHEN BH=80 THEN '2.09' WHEN BH=81 THEN '2.19' WHEN BH=82 THEN '2.24' WHEN BH=83 THEN '2.23' WHEN BH=84 THEN '2.24' WHEN BH=85 THEN '2.22' WHEN BH=86 THEN '2.24' WHEN BH=87 THEN '2.24' WHEN BH=88 THEN '2.24' WHEN BH=89 THEN '2.25' WHEN BH=90 THEN '2.22' WHEN BH=91 THEN '2.25' WHEN BH=92 THEN '2.23' WHEN BH=93 THEN '2.25' WHEN BH=94 THEN '2.24' WHEN BH=95 THEN '2.19' WHEN BH=96 THEN '2.21' WHEN BH=97 THEN '2.22' WHEN BH=98 THEN '2.23' WHEN BH=99 THEN '2.23' WHEN BH=100 THEN '2.23' WHEN BH=101 THEN '2.24' WHEN BH=102 THEN '2.23' WHEN BH=103 THEN '2.25' WHEN BH=104 THEN '2.24' WHEN BH=105 THEN '2.23' WHEN BH=106 THEN '2.24' WHEN BH=107 THEN '2.21' ELSE '2.24' END) WHERE BH IN(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108) AND CLJLID='F2E9FA47-A276-4807-A610-404E0 5726608-13535'
8kq099mqn2wvzselect * from MW_SYS.MWT_OM_ATTR where ATTR_ID = :1
8vxpgv2yxf4hkSELECT COUNT(QXXZ) FROM MW_APP.MWV_UD_SBDYX_BDQXJL WHERE YXBZ IN (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS START WITH OBJ_ID=:B4 CONNECT BY PRIOR OBJ_ID=SJBM) AND TO_CHAR(FXRQ, 'YYYY-MM-DD') BETWEEN :B3 AND :B2 AND YSSFHG='T' AND QXXZ=:B1 AND (SFSWT='F' OR SFSWT IS NULL) AND BDZ IN(SELECT DISTINCT PZ.BDZ FROM MW_APP.MWT_UD_SBD_BDZWHBZPZ PZ WHERE WHDW IN (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS START WITH OBJ_ID=:B5 CONNECT BY PRIOR OBJ_ID = SJBM))
931v50y6ak8bxSELECT COUNT(QXXZ) FROM MW_APP.MWV_UD_SBDYX_BDQXJL WHERE YXBZ IN (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS START WITH OBJ_ID=:B4 CONNECT BY PRIOR OBJ_ID=SJBM) AND TO_CHAR(FXRQ, 'YYYY-MM-DD') BETWEEN :B3 AND :B2 AND DECODE(YSSFHG, NULL, 'F', YSSFHG)='F' AND QXXZ=:B1 AND (SFSWT='F' OR SFSWT IS NULL) AND BDZ IN(SELECT DISTINCT PZ.BDZ FROM MW_APP.MWT_UD_SBD_BDZWHBZPZ PZ WHERE WHDW IN (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS START WITH OBJ_ID=:B5 CONNECT BY PRIOR OBJ_ID = SJBM))
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9bdj4vdvz7ftu select t2.obj_id, t2.bdzzj mc from (select distinct ssbdz from mw_app.MWT_UD_PD_SB_RH_YXWZ where yxwzlb = '5F017131-22C2-48E5-9EA2-2897DB60FBB8-00797' and (yxdw = 'A75B6776-8265-46A1-9776-35FA9DA0ED31-02001' or INSTR(WHBZ, (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS WHERE MW_SYS.MWT_PD_DEPS.obj_id = (select deptid from mw_app.mwv_om_userinfo where user_id = '07BB0625-5BC1-4AF1-8061-530BF0CC7F96'))) > 0 ) ) t1, mw_app.MWT_UD_SBD_BDZ t2 where t1.ssbdz = t2.obj_id order by mc
9gucmzb2wt8jvselect dm1.dm, dm1.dmmc from mw_app.mwt_ud_gg_dm dm1 where dm1.dmlb = '315' and DM1.DM in ('31501') order by dm1.dm
9q1vxb7mh5m9kinsert into mw_app.mwt_ud_zxjh_tzgx (obj_id, obj_dispidx, cls_id, tzdxid, czlx, czsj) (select obj_id, obj_dispidx, dxlx, czdx, czlx, czsj from mw_app.mwt_ud_jk_jkczjl jl where jl.dxlx='D13303DC-0C88-4988-86D6-A04BCCD1E42A' and jl.obj_id = :1)
9zb47ttz6apj8SELECT ROUND(DECODE(XYXQ, 0, 0, JSXQ*100*100/XYXQ), 1)/100 || '%' AS JSL , JSXQ , XYXQ, (XYXQ-JSXQ) WJSXQ FROM (SELECT COUNT(*) AS JSXQ FROM MW_APP.MWV_UD_SBDYX_BDQXJL WHERE YXBZ IN (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS START WITH OBJ_ID=:B5 CONNECT BY PRIOR OBJ_ID=SJBM) AND BDZ IN(SELECT DISTINCT PZ.BDZ FROM MW_APP.MWT_UD_SBD_BDZWHBZPZ PZ WHERE WHDW IN (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS START WITH OBJ_ID=:B6 CONNECT BY PRIOR OBJ_ID = SJBM)) AND TO_CHAR(FXRQ, 'YYYY-MM-DD') BETWEEN :B4 AND :B3 AND QXXZ=:B2 AND YSSFHG='T' AND (SFSWT='F' OR SFSWT IS NULL) AND XQRQ<=FXRQ+:B1 ) T1, (SELECT COUNT(*) AS XYXQ FROM MW_APP.MWV_UD_SBDYX_BDQXJL WHERE YXBZ IN (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS START WITH OBJ_ID=:B5 CONNECT BY PRIOR OBJ_ID=SJBM) AND BDZ IN(SELECT DISTINCT PZ.BDZ FROM MW_APP.MWT_UD_SBD_BDZWHBZPZ PZ WHERE WHDW IN (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS START WITH OBJ_ID=:B6 CONNECT BY PRIOR OBJ_ID = SJBM)) AND TO_CHAR(FXRQ, 'YYYY-MM-DD') BETWEEN :B4 AND :B3 AND QXXZ=:B2 AND YSSFHG='T' AND (SFSWT='F' OR SFSWT IS NULL) AND (DECODE(XQRQ, NULL, SYSDATE, XQRQ)>=FXRQ+:B1 OR XQRQ IS NOT NULL)) T2
a73wbv1yu8x5cselect con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1
acbpxc63165qbselect atvd_id, atvd_name, num from (select distinct atvd.atvd_id, atvd.atvd_name, atvd.atvd_dispidx, (select count(1) from mw_sys.mwt_wf_wi wi, mw_sys.mwt_wf_atvi atvi where wi.atvi_id = atvi.atvi_id and wi.wi_status in('A', 'F') and (wi.user_id = ru.user_id or (wi.user_id is null and wi.role_id in(select role_id from mw_sys.mwt_sm_roleuser rus where rus.user_id = ru.user_id))) and atvi.atvd_id = atvd.atvd_id) num from mw_sys.mwt_wf_atvr atvr inner join mw_sys.mwt_sm_roleuser ru on ru.role_id = atvr.role_id inner join mw_sys.mwt_wf_atvd atvd on atvr.atvd_id = atvd.atvd_id where atvd.prcd_id = 'B65F15BE-9DF5-452D-81FE-B3DF762D79AF' and ru.user_id = '8636693A-CD54-422A-9182-E868D1791056') order by atvd_dispidx
au43pr9wqmtusselect count(distinct s.OBJ_ID) as num from mw_app.mwt_ud_lp_sheetindex s, mw_app.mwt_ud_lp_PATTERNINFO p, mw_sys.mwt_pd_deps deps where s.PATTERNID = p.PATTERNID and p.moduletype = 1 and sheettype <> 2 and sheettype <> 7 and ismainsheet = 1 and s.sheetstatusid not in (1, 4, 11) and to_number(sysdate - to_date(s.maketime, 'yyyy-mm-dd hh24:mi:ss'))*24*60 <= 5 AND deps.obj_id = s.deptid and deps.dept_path LIKE '%A75B6776-8265-46A1-9776-35FA9DA0ED31-02167%'
axmdf8vq7k1rhselect increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
b3raptfj8k5jw insert into MW_APP.MWT_UD_SBD_SDXLCD_FJTJ (OBJ_ID, OBJ_DISPIDX, TJJB, TJDW, XL_OBJ_ID, DYDJ, DYDJSX, XLMC, XLBH, ZCXZ, ZCBH, ZCDW, YXDWID, YXDWMC, WHBZ, WHBZMC, JSFS, SJDYDJMC, DLXZ, TYRQ, SBBZ, SSDD, DDDWMC, SFDW, SFSZX, SSXL, KQYLX, SFJDJ, QDLX, XLQD, ZDLX, XLZD, ZDYXDL, YXFHXE, JJDL, DAOXXH, DIXXH, GTJS, JKCD, DLCD, ZXCD, XLCD, YXZT, SBBM, ZCBZQC, ZCRQ, TJSJ, BZ, shzt) select mw_app.EMS_COMMON.GetGUIDByOracle, mw_sys.mwq_obj_dispidx.nextval, 'WS', t1.tjdw, t.obj_id, t.dydj, t.dydjpx, t.xlmc, t.xlbh, t.zcxz, t.zcbh, t.zcdw, mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'yxdwid'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'yxdwmc'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'whbzid'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'whbzmc'), t.jsfs, (select mc from mw_app.mwt_ud_gy_dydj where rownum=1 and dm=t.sjdydj), t.dlxz, t.tyrq, t.sbbz, t.ssdd, (select mc from mw_sys.mwt_pd_deps where obj_id=t.ssdddw), t.sfdw, t.sfszx, t.ssxl, t.sffd, t.sfjdj, t.qdlx, t.qdms, t.zdlx, t.zdms, t.zdyxdl, t.yxfhxe, t.jjdl, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DaoDiX(t.obj_i d, t1.tjdw, '??') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DaoDiX(t.obj_id, t1.tjdw, '??') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_GTJS(t.obj_id, t.yxzt, t1.tjdw, 'WS') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DTCD('WS', t1.tjdw, t.obj_id, t.yxzt, 'JKCD') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DTCD('WS', t1.tjdw, t.obj_id, t.yxzt, 'DLCD') else null end, mw_app.MWF_UD_SBD_XLCDTJ_DTCD('WS', t1.tjdw, t.obj_id, t.yxzt, 'ZXCD'), ROUND(t.xlcd, 4), t.yxzt, t.global_id, (select bmqc from mw_sys.mwt_pd_deps where obj_id=t.whbz), t.zcrq, current_timestamp(6), t.bz, t.shzt from mw_app.mwt_ud_sbd_xlxx t, (select * from (select dqxlid, (select obj_id from mw_sys.mwt_pd_deps where rownum=1 and dwjb in ('2', '3') connect by prior sjbm=obj_id start with obj_id=t.yxdw) tjdw from mw_app.mwt_ud_sbd_xlfdxx t where t.whlb='??') group by dqxlid, tjdw) t1 where t.obj_id=t1.dqxlid and nvl(t.sfsc, '0')<>'1' and t1.tjdw is not null
bj8xr519anj8w SELECT a.tablespace_name "Tablespace", b.status "Status", b.contents "Type", b.extent_management "Extent Mgmt", a.bytes bytes, a.maxbytes bytes_max, c.bytes_free + NVL(d.bytes_expired, 0) bytes_free FROM ( -- belegter und maximal verfuegbarer platz pro datafile -- nach tablespacenamen zusammengefasst -- => bytes -- => maxbytes SELECT a.tablespace_name, SUM(a.bytes) bytes, SUM(DECODE(a.autoextensible, 'YES', a.maxbytes, 'NO', a.bytes)) maxbytes FROM dba_data_files a GROUP BY tablespace_name ) a, sys.dba_tablespaces b, ( -- freier platz pro tablespace -- => bytes_free SELECT a.tablespace_name, SUM(a.bytes) bytes_free FROM dba_free_space a GROUP BY tablespace_name ) c, ( -- freier platz durch expired extents -- speziell fuer undo tablespaces -- => bytes_expired SELECT a.tablespace_name, SUM(a.bytes) bytes_expired FROM dba_undo_extents a WHERE status = 'EXPIRED' GROUP BY tablespace_name ) d WHERE a.tablespace_name = c.tablespace_name (+) AND a.tablespace_name = b.tablespace_name AND a.tablespace_name = d.tablespace_name (+) UNION ALL SELECT d.tablespace_name "Tablespace", b.status "Status", b.contents "Type", b.extent_management "Extent Mgmt", sum(a.bytes_free + a.bytes_used) bytes, -- allocated SUM(DECODE(d.autoextensible, 'YES', d.maxbytes, 'NO', d.bytes)) bytes_max, SUM(a.bytes_free + a.bytes_used - NVL(c.bytes_used, 0)) bytes_free FROM sys.v_$TEMP_SPACE_HEADER a, sys.dba_tablespaces b, sys.v_$Temp_extent_pool c, dba_temp_files d WHERE c.file_id(+) = a.file_id and c.tablespace_name(+) = a.tablespace_name and d.file_id = a.file_id and d.tablespace_name = a.tablespace_name and b.tablespace_name = a.tablespace_name GROUP BY b.status, b.contents, b.extent_management, d.tablespace_name ORDER BY 1
bm9mh4ubm90jnselect atvi.atvi_id, atvi.atvi_sctime, (prcd.prcd_prior+prci.prci_prior) as prior1, (atvd.atvd_priority+atvi.atvi_prior) as prior2 from mw_sys.mwt_wf_atvi atvi, mw_sys.mwt_wf_atvd atvd, mw_sys.mwt_wf_prci prci, mw_sys.mwt_wf_prcd prcd, (select ai.atvi_id from mw_sys.mwt_wf_atvi ai, mw_sys.mwt_wf_wi wi where ai.atvi_id=wi.atvi_id and decode(wi.wi_status, 'A', 'A', 'F', 'A', null)='A' and wi.user_id=:1 and wi.wi_sctime>:2 and wi.wi_isreserved='F' union select ai.atvi_id from mw_sys.mwt_wf_atvi ai, mw_sys.mwt_wf_wi wi, mw_sys.mwt_sm_roleuser ru where ai.atvi_id=wi.atvi_id and decode(wi.wi_status, 'A', 'A', 'F', 'A', null)='A' and wi.user_id is null and wi.role_id=ru.role_id and ru.user_id=:3 and wi.wi_sctime>:4 and wi.wi_isreserved='F' ) t where atvi.atvi_id=t.atvi_id and atvi.atvd_id=atvd.atvd_id and atvi.prci_id=prci.prci_id and prci.prcd_id=prcd.prcd_id and atvd.atvd_curtask='T' and exists (select * from mw_sys.mwt_wf_prciv where prci_id=prci.prci_id)
bs715s323n25jselect /*first_row*/count(*) from MW_APP.MWT_UD_JXGG_RKJH where 1=1 AND (((to_char(GZRQ, 'yyyy-mm-dd') between '2014-06-01' and '2014-07-17' AND BZR = 'F908F46A-08B4-4269-97DF-3D8F27360B0E-00406' AND GZDD LIKE '%???%')))
bs7pw0ux5z8p3select MW_SYS.MWT_OM_OBJ.CLS_ID, MW_SYS.MWT_OM_OBJ.OBJ_ID, MW_SYS.MWT_OM_OBJ.OBJ_CAPTION, MW_SYS.MWT_OM_OBJ.STATE_ID, MW_APP.MWT_UD_SBD_YXWZ.OBJ_DISPIDX from MW_SYS.MWT_OM_OBJ, MW_APP.MWT_UD_SBD_YXWZ where MW_APP.MWT_UD_SBD_YXWZ.OBJ_ID=MW_SYS.MWT_OM_OBJ.OBJ_ID and JGDY='A0EBBF86-631D-4F4D-AE94-3769C4125F1B-01454' and ((yxzt='20501')) order by decode(sblx, '0321', '00', sblx), YXBH
bu16uu25x699aSELECT /*+NESTED_TABLE_GET_REFS+*/ "MW_SYS"."MWT_IS_AUDITHIS_TMP2".* FROM "MW_SYS"."MWT_IS_AUDITHIS_TMP2"
bvphnq5j5xqxfselect dm1.dm, dm1.dmmc from mw_app.mwt_ud_gg_dm dm1 where dm1.dmlb='896' and DM1.DM in ('89604') order by dm1.dm
c3ytk3q6ga5xcselect MW_APP.MWT_UD_JXGG_RKJH.OBJ_ID, MW_APP.MWT_UD_JXGG_RKJH.OBJ_DISPIDX from MW_APP.MWT_UD_JXGG_RKJH where (((jhzt <> '1DD6F05F-CD98-4B2A-9902-5AE4BEB3E3B3' and jhzt <> '3475D6B3-C332-4C48-81B1-5B0C503F3B66') and (gzdd <> '?' and gznr <> '???')) and (ssds='A75B6776-8265-46A1-9776-35FA9DA0ED31-00009' and jhzt='CD9A8CA7-A5D0-4174-AB41-AF41402D7742' and gzrq = to_date('2014-03-03', 'yyyy-mm-dd') AND BZDW IN (SELECT D.OBJ_ID FROM MW_SYS.MWT_PD_DEPS D START WITH D.OBJ_ID='A75B6776-8265-46A1-9776-35FA9DA0ED31-00009' CONNECT BY PRIOR D.OBJ_ID=D.SJBM))) order by OBJ_DISPIDX
c8yyzffr8f0dhselect /*first_row*/count(*) from MW_APP.MWT_UD_XDCCLJG where 1=1 AND ((( obj_id in (select obj_id from(select rownum rn, t.* from(select obj_id from mw_app.mwt_ud_xdccljg where cljlid='0619205E-197B-4DAE-80A0-F6F158AD0095-43743' order by bh) t) where rn between 16 and 20))))
cc21j2k7u66kcSELECT COUNT(QXXZ) FROM MW_APP.MWV_UD_SBDYX_BDQXJL WHERE YXBZ IN (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS START WITH OBJ_ID=:B4 CONNECT BY PRIOR OBJ_ID=SJBM) AND TO_CHAR(FXRQ, 'YYYY-MM-DD') BETWEEN :B3 AND :B2 AND QXXZ=:B1 AND BDZ IN(SELECT DISTINCT PZ.BDZ FROM MW_APP.MWT_UD_SBD_BDZWHBZPZ PZ WHERE WHDW IN (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS START WITH OBJ_ID= :B5 CONNECT BY PRIOR OBJ_ID = SJBM)) AND (SFSWT='F' OR SFSWT IS NULL)
cfcddf7ftyfhwselect atvi.atvi_id, atvi.atvi_sctime, (prcd.prcd_prior+prci.prci_prior) as prior1, (atvd.atvd_priority+atvi.atvi_prior) as prior2 from mw_sys.mwt_wf_atvi atvi, mw_sys.mwt_wf_atvd atvd, mw_sys.mwt_wf_prci prci, mw_sys.mwt_wf_prcd prcd, (select ai.atvi_id from mw_sys.mwt_wf_atvi ai, mw_sys.mwt_wf_wi wi where ai.atvi_id=wi.atvi_id and decode(wi.wi_status, 'A', 'A', 'F', 'A', null)='A' and wi.user_id=:1 and wi.wi_isreserved='F' union select ai.atvi_id from mw_sys.mwt_wf_atvi ai, mw_sys.mwt_wf_wi wi, mw_sys.mwt_sm_roleuser ru where ai.atvi_id=wi.atvi_id and decode(wi.wi_status, 'A', 'A', 'F', 'A', null)='A' and wi.user_id is null and wi.role_id=ru.role_id and ru.user_id=:2 and wi.wi_isreserved='F' ) t where atvi.atvi_id=t.atvi_id and atvi.atvd_id=atvd.atvd_id and atvi.prci_id=prci.prci_id and prci.prcd_id=prcd.prcd_id and atvd.atvd_curtask='T' and exists (select * from mw_sys.mwt_wf_prciv where prci_id=prci.prci_id)
cu9tu7fwvj56pinsert into mw_app.mwt_ud_jk_czbuffer (select * from mw_app.mwt_ud_jk_jkczjl jl where jl.obj_id = :1)
d1zu1pu74m6ts insert into MW_APP.MWT_UD_SBD_SDXLCD_FJTJ (OBJ_ID, OBJ_DISPIDX, TJJB, TJDW, XL_OBJ_ID, DYDJ, DYDJSX, XLMC, XLBH, ZCXZ, ZCBH, ZCDW, YXDWID, YXDWMC, WHBZ, WHBZMC, JSFS, SJDYDJMC, DLXZ, TYRQ, SBBZ, SSDD, DDDWMC, SFDW, SFSZX, SSXL, KQYLX, SFJDJ, QDLX, XLQD, ZDLX, XLZD, ZDYXDL, YXFHXE, JJDL, DAOXXH, DIXXH, GTJS, JKCD, DLCD, ZXCD, XLCD, YXZT, SBBM, ZCBZQC, ZCRQ, TJSJ, BZ, shzt) select mw_app.EMS_COMMON.GetGUIDByOracle, mw_sys.mwq_obj_dispidx.nextval, 'BZ', t1.tjdw, t.obj_id, t.dydj, t.dydjpx, t.xlmc, t.xlbh, t.zcxz, t.zcbh, t.zcdw, mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'yxdwid'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'yxdwmc'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'whbzid'), mw_app.MWF_UD_SBD_XLCDTJ_Whdw(t.obj_id, 'whbzmc'), t.jsfs, (select mc from mw_app.mwt_ud_gy_dydj where rownum=1 and dm=t.sjdydj), t.dlxz, t.tyrq, t.sbbz, t.ssdd, (select mc from mw_sys.mwt_pd_deps where obj_id=t.ssdddw), t.sfdw, t.sfszx, t.ssxl, t.sffd, t.sfjdj, t.qdlx, t.qdms, t.zdlx, t.zdms, t.zdyxdl, t.yxfhxe, t.jjdl, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DaoDiX(t.obj_i d, t1.tjdw, '??') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DaoDiX(t.obj_id, t1.tjdw, '??') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_GTJS(t.obj_id, t.yxzt, t1.tjdw, 'BZ') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DTCD('BZ', t1.tjdw, t.obj_id, t.yxzt, 'JKCD') else null end, case when jsfs in ('??', '??') then mw_app.MWF_UD_SBD_XLCDTJ_DTCD('BZ', t1.tjdw, t.obj_id, t.yxzt, 'DLCD') else null end, mw_app.MWF_UD_SBD_XLCDTJ_DTCD('BZ', t1.tjdw, t.obj_id, t.yxzt, 'ZXCD'), ROUND(t.xlcd, 4), t.yxzt, t.global_id, (select bmqc from mw_sys.mwt_pd_deps where obj_id=t.whbz), t.zcrq, current_timestamp(6), t.bz, t.shzt from mw_app.mwt_ud_sbd_xlxx t, (select * from (select dqxlid, t.whbz tjdw from mw_app.mwt_ud_sbd_xlfdxx t where t.whlb='??') group by dqxlid, tjdw) t1 where t.obj_id=t1.dqxlid and nvl(t.sfsc, '0')<>'1' and t1.tjdw is not null
d68rk6bx0zj4mINSERT INTO "GOLDENGATE" ."GGS_MARKER" ( SEQNO, FRAGMENTNO, OPTIME, TYPE, SUBTYPE, MARKER_TEXT ) VALUES ( :B5 , :B4 , TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'), :B3 , :B2 , :B1 )
d8kxaryk2kpnaselect ATVI_NOTE, ATVI_NAME, ATVI_STATUS, ATVD_ID, ATVI_CTIME, ATVI_TL, ATVI_SCTIME, PRCI_ID, ATVI_ID, ATVI_DISPIDX, ATVI_WID, ATVI_INSTIDX, ATVI_PRIOR, ATVI_DESC, ATVI_MTIME from MW_SYS.MWT_WF_ATVI where ATVI_ID = :1
db2bdrp7ch098DELETE FROM MW_APP.MWT_CBM_BDSBZXZT ZXS WHERE NOT EXISTS (SELECT 1 FROM (SELECT * FROM (SELECT ZX.*, ROW_NUMBER() OVER(PARTITION BY SSSB ORDER BY ZXPJSJ DESC) RN FROM MW_APP.MWT_CBM_BDSBZXZT ZX) WHERE RN = 1) AAB WHERE AAB.OBJ_ID = ZXS.OBJ_ID)
db43qjdrpc70qSELECT /*+NESTED_TABLE_GET_REFS+*/ "MW_SYS"."MWT_IS_AUDIT".* FROM "MW_SYS"."MWT_IS_AUDIT"
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
ddnwfwts0vu7wselect /*first_rows*/* from (select t.*, rownum rn from (select MW_APP.MWT_UD_XDCCLJG.OBJ_ID, MW_APP.MWT_UD_XDCCLJG.CLJLID, MW_APP.MWT_UD_XDCCLJG.BH, MW_APP.MWT_UD_XDCCLJG.DY, MW_APP.MWT_UD_XDCCLJG.OBJ_DISPIDX from MW_APP.MWT_UD_XDCCLJG where 1=1 AND ((( obj_id in (select obj_id from(select rownum rn, t.* from(select obj_id from mw_app.mwt_ud_xdccljg where cljlid='D85C4AE8-9143-43B7-A5DE-F47601F4820F-30489' order by bh) t) where rn between 27 and 52)))) order by BH) t where rownum<=1000) where rn>=1
dgwcaqu1u31dzselect atvi.*, t.wi_isreserved as atvi_isreserved, t.wi_akind as atvi_akind from mw_sys.mwt_wf_atvi atvi, mw_sys.mwt_wf_prci prci, (select ai.atvi_id, wi.wi_isreserved, wi.wi_akind, wi.wi_dispidx, wi.user_id, wi.role_id from mw_sys.mwt_wf_atvi ai, mw_sys.mwt_wf_wi wi where ai.atvi_id = wi.atvi_id and decode(wi_status, 'A', 'A', 'F', 'A', null)='A' and wi.user_id=:1 and wi.wi_sctime>:2 union select ai.atvi_id, wi.wi_isreserved, wi.wi_akind, wi.wi_dispidx, wi.user_id, wi.role_id from mw_sys.mwt_wf_atvi ai, mw_sys.mwt_wf_wi wi, mw_sys.mwt_sm_roleuser ru where ai.atvi_id = wi.atvi_id and decode(wi_status, 'A', 'A', 'F', 'A', null)='A' and wi.user_id is null and wi.role_id = ru.role_id and ru.user_id=:3 and wi.wi_sctime>:4 ) t where atvi.atvi_id = t.atvi_id and atvi.prci_id = prci.prci_id and prci.prcd_id = :5 and not exists (select 1 from mw_sys.mwt_wf_wi ww where atvi_id = t.atvi_id and wi_dispidx > t.wi_dispidx and decode(wi_status, 'A', 'A', 'F', 'A', null)='A' and (user_id = :6 or (user_id is null and exists (select 1 from mw_sys.mwt_sm_roleuser where ww.role_id = role_id and user_id = :7)))) order by atvi.atvi_ctime desc
dz5zwsz7bh59fSELECT MW_SYS.F_LINK(DWMC) FROM MW_APP.MWT_UD_SBD_SDXLSJSGJLDW WHERE DWLX = '15902' AND XLID = :B1
f15qdw0bjsw6wselect dm1.bzdm, dm1.dmmc from mw_app.mwt_ud_gg_dm dm1 where dm1.dmlb = '001' and (dm1.dmbs = 9 or dm1.dmbs = 8 or dm1.dmbs=10 or dm1.dmbs=6 or dm1.dmbs=3 or dm1.dmbs=7 or dm1.dmbs=5 or dm1.dmbs=11 or dm1.dmbs= 13 or dm1.dmbs = 14) and DM1.BZDM in ('22')
f676t7k7cxx0vselect count(distinct s.OBJ_ID) as num from mw_app.mwt_ud_lp_sheetindex s, mw_app.mwt_ud_lp_PATTERNINFO p, mw_sys.mwt_pd_deps deps where s.PATTERNID = p.PATTERNID and p.moduletype = 2 and sheettype <> 2 and sheettype <> 7 and ismainsheet = 1 and s.sheetstatusid not in (1, 4, 11) and to_number(sysdate - to_date(s.maketime, 'yyyy-mm-dd hh24:mi:ss'))*24*60 <= 5 AND deps.obj_id = s.deptid and deps.dept_path LIKE '%A75B6776-8265-46A1-9776-35FA9DA0ED31-01573%'
f8pavn1bvsj7tselect con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1
f8wqd13mrm30cselect '63EBEC8E-E766-40D7-ACF4-FEA945102112-00155'as dwbm , DYDJ, SUM(COLA) COLA, SUM(COLB) COLB, SUM(COLC) COLC, SUM(COLD) COLD, SUM(COLE) COLE FROM (SELECT DYDJ, DECODE(JYJXFL, 'A???', COUNT(*), 0) COLA, DECODE(JYJXFL, 'B???', COUNT(*), 0) COLB, DECODE(JYJXFL, 'C???', COUNT(*), 0) COLC, DECODE(JYJXFL, 'D???', COUNT(*), 0) COLD, DECODE(JYJXFL, 'E???', COUNT(*), 0) COLE FROM MW_APP.MWV_CBM_BDJCJY WHERE DYDJ IS NOT NULL AND GDBZ = 'T' GROUP BY JYJXFL, DYDJ)GROUP BY DYDJ
fc97ywxymnam9select atvd_id, atvd_name, num from (select distinct atvd.atvd_id, atvd.atvd_name, atvd.atvd_dispidx, (select count(1) from mw_sys.mwt_wf_wi wi, mw_sys.mwt_wf_atvi atvi where wi.atvi_id = atvi.atvi_id and wi.wi_status in('A', 'F') and (wi.user_id = ru.user_id or (wi.user_id is null and wi.role_id in(select role_id from mw_sys.mwt_sm_roleuser rus where rus.user_id = ru.user_id))) and atvi.atvd_id = atvd.atvd_id) num from mw_sys.mwt_wf_atvr atvr inner join mw_sys.mwt_sm_roleuser ru on ru.role_id = atvr.role_id inner join mw_sys.mwt_wf_atvd atvd on atvr.atvd_id = atvd.atvd_id where atvd.prcd_id = 'B65F15BE-9DF5-452D-81FE-B3DF762D79AF' and ru.user_id = 'D2963DEA-C776-4943-8FAD-E239921CA560') order by atvd_dispidx
fg9uc1pwq9gbxselect state_id from MW_APP.MWT_UD_PD_SB_RH_YXWZ where obj_id =:1
fjnfur1a3p4ktselect * from MW_SYS.MWT_OM_CLS where CLS_ID = :1
fk6d9rppc51v6update mw_sys.mwt_is_ulog set ulog_optime=:1 where id=(select max(id) from mw_sys.mwt_is_ulog where user_id=:2 and ulog_ip=:3 and ulog_type=:4)
fwfptqpw2yq4zupdate mw_sys.mwt_is_ulog set ulog_offtime=:1 where id=(select max(id) from mw_sys.mwt_is_ulog where user_id=:2 and ulog_ip=:3 and ulog_type=:4)
g1fsfqkvpbpbyinsert into mw_app.mwt_ud_perf_param_history(KPINAME, KPIVALUE, DEPART_ID, FREQUENCY, OPERATETIME, Note, DESCRIPTION, obj_id) values (:1, :2, :3, :4, :5, :6, :7, :8)
g6dg7suqk2bvmSELECT ZXMJG.SZXZ, SY.OBJ_ID FROM MW_APP.MWT_UD_SY_ZXMJG ZXMJG INNER JOIN MW_APP.MWT_UD_SY_SYSJZ SJZ ON SJZ.OBJ_ID = ZXMJG.SJZID INNER JOIN MW_APP.MWT_UD_SY_SYSBXM SYSBXM ON SYSBXM.OBJ_ID = SJZ.SYSBXMID INNER JOIN MW_APP.MWT_UD_SY_SYSB SYSB ON SYSB.OBJ_ID = SYSBXM.SYSBID INNER JOIN MW_APP.MWT_UD_SY_SY SY ON SY.OBJ_ID = SYSB.SYID WHERE SYSB.SBID = 'FF0B80F6-4E2D-4EDF-A885-5B3CFA201DB2-00132' AND SYSBXM.SYXMID = 'E601EE2D-9B93-465B-948C-408C3128700F-05717' AND ZXMJG.ZXMID = 'E601EE2D-9B93-465B-948C-408C3128700F-04508' AND ZXMJG.SYXB = '/' AND ZXMJG.SYBWID = 'E601EE2D-9B93-465B-948C-408C3128700F-04134' AND SY.KSSJ<(SELECT KSSJ FROM MW_APP.MWT_UD_SY_SY WHERE OBJ_ID='FC7D20A2-25F3-8E14-8E04-30AD00F0DE14-12345') ORDER BY SY.KSSJ DESC
g8s6jn7m2kjk6 select t2.obj_id, t2.bdzzj mc from (select distinct ssbdz from mw_app.MWT_UD_PD_SB_RH_YXWZ where yxwzlb = '5F017131-22C2-48E5-9EA2-2897DB60FBB8-00797' and (yxdw = 'A75B6776-8265-46A1-9776-35FA9DA0ED31-02001' or INSTR(WHBZ, (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS WHERE MW_SYS.MWT_PD_DEPS.obj_id = (select deptid from mw_app.mwv_om_userinfo where user_id = '9D44F01D-9FD5-4EF4-A3C5-A8A5E5293F3C'))) > 0 ) ) t1, mw_app.MWT_UD_SBD_BDZ t2 where t1.ssbdz = t2.obj_id order by mc
gd3rd1srjnfq4select count(obj_id) from MWT_UD_ZYWBGL_XSJL where ZYWBID='524E148B-01C9-4FDB-AE30-EC565096EDA9-00001' and WBXSID='6'
gg86m3fv3r7gkUPDATE MWT_UD_ZYWBGL_XSJL SET ZXR = DECODE(ZXR, NULL, :B5 , ZXR), KSSJ = DECODE(KSSJ, NULL, TO_DATE(:B4 , 'yyyy-MM-dd hh24:mi'), KSSJ), JSSJ = DECODE(JSSJ, NULL, TO_DATE(:B3 , 'yyyy-MM-dd hh24:mi'), JSSJ), XJQK = DECODE(XJQK, NULL, :B2 , XJQK) WHERE :B1 = ZYWBID
gjc7jkjz3pfhg select t2.obj_id, t2.bdzzj mc from (select distinct ssbdz from mw_app.MWT_UD_PD_SB_RH_YXWZ where yxwzlb = '5F017131-22C2-48E5-9EA2-2897DB60FBB8-00797' and (yxdw = 'A75B6776-8265-46A1-9776-35FA9DA0ED31-02001' or INSTR(WHBZ, (SELECT OBJ_ID FROM MW_SYS.MWT_PD_DEPS WHERE MW_SYS.MWT_PD_DEPS.obj_id = (select deptid from mw_app.mwv_om_userinfo where user_id = '002F7B19-1228-4761-9542-4F8C19CC0E60'))) > 0 ) ) t1, mw_app.MWT_UD_SBD_BDZ t2 where t1.ssbdz = t2.obj_id order by mc
grwydz59pu6mcselect text from view$ where rowid=:1
gz37s22zstztyUPDATE MW_APP.MWT_CBM_SBCSTZ SET CSZ = :B3 WHERE SSSB = :B2 AND SSCS = :B1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 4,478,096 77.71 13.05
CPU used when call started 4,284,500 74.35 12.48
CR blocks created 17,181 0.30 0.05
Cached Commit SCN referenced 9,303 0.16 0.03
Commit SCN cached 16 0.00 0.00
DB time 18,997,602 329.69 55.36
DBWR checkpoint buffers written 211,988 3.68 0.62
DBWR checkpoints 13 0.00 0.00
DBWR fusion writes 55,806 0.97 0.16
DBWR object drop buffers written 0 0.00 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 5,285 0.09 0.02
DBWR undo block writes 70,327 1.22 0.20
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 426 0.01 0.00
Misses for writing mapping 1 0.00 0.00
PX local messages recv'd 2,061 0.04 0.01
PX local messages sent 2,061 0.04 0.01
PX remote messages recv'd 5,771 0.10 0.02
PX remote messages sent 4,283 0.07 0.01
Parallel operations downgraded to serial 6 0.00 0.00
Parallel operations not downgraded 426 0.01 0.00
RowCR - row contention 2,393 0.04 0.01
RowCR attempts 344,424 5.98 1.00
RowCR hits 347,321 6.03 1.01
SMON posted for undo segment recovery 2 0.00 0.00
SMON posted for undo segment shrink 41 0.00 0.00
SQL*Net roundtrips to/from client 141,214,603 2,450.64 411.49
active txn count during cleanout 41,407 0.72 0.12
application wait time 1,133 0.02 0.00
background checkpoints completed 9 0.00 0.00
background checkpoints started 8 0.00 0.00
background timeouts 222,924 3.87 0.65
branch node splits 40 0.00 0.00
buffer is not pinned count 1,189,000,826 20,633.97 3,464.70
buffer is pinned count 2,145,035,244 37,225.04 6,250.54
bytes received via SQL*Net from client 52,752,896,886 915,476.09 153,719.66
bytes sent via SQL*Net to client ############### 2,109,739.43 354,251.11
calls to get snapshot scn: kcmgss 107,908,224 1,872.64 314.44
calls to kcmgas 1,015,500 17.62 2.96
calls to kcmgcs 16,057 0.28 0.05
change write time 3,959 0.07 0.01
cleanout - number of ktugct calls 65,823 1.14 0.19
cleanouts and rollbacks - consistent read gets 963 0.02 0.00
cleanouts only - consistent read gets 25,036 0.43 0.07
cluster key scan block gets 1,833,457 31.82 5.34
cluster key scans 968,833 16.81 2.82
cluster wait time 734,850 12.75 2.14
cold recycle reads 0 0.00 0.00
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 256 0.00 0.00
commit batch/immediate requested 256 0.00 0.00
commit cleanout failures: block lost 1,018 0.02 0.00
commit cleanout failures: buffer being written 1 0.00 0.00
commit cleanout failures: callback failure 61,118 1.06 0.18
commit cleanout failures: cannot pin 164 0.00 0.00
commit cleanouts 923,314 16.02 2.69
commit cleanouts successfully completed 861,013 14.94 2.51
commit immediate performed 256 0.00 0.00
commit immediate requested 256 0.00 0.00
commit txn count during cleanout 206,874 3.59 0.60
concurrency wait time 33,690 0.58 0.10
consistent changes 213,346 3.70 0.62
consistent gets 2,280,849,640 39,581.96 6,646.30
consistent gets - examination 111,272,690 1,931.03 324.24
consistent gets direct 2,929,848 50.84 8.54
consistent gets from cache 2,277,921,950 39,531.16 6,637.77
current blocks converted for CR 262 0.00 0.00
cursor authentications 38,864 0.67 0.11
data blocks consistent reads - undo records applied 15,019 0.26 0.04
db block changes 4,445,939 77.16 12.96
db block gets 6,034,951 104.73 17.59
db block gets direct 139,237 2.42 0.41
db block gets from cache 5,895,833 102.32 17.18
deferred (CURRENT) block cleanout applications 332,721 5.77 0.97
dirty buffers inspected 29,618 0.51 0.09
enqueue conversions 92,336 1.60 0.27
enqueue deadlocks 0 0.00 0.00
enqueue releases 2,219,575 38.52 6.47
enqueue requests 2,219,698 38.52 6.47
enqueue timeouts 123 0.00 0.00
enqueue waits 48,174 0.84 0.14
exchange deadlocks 582 0.01 0.00
execute count 8,747,822 151.81 25.49
failed probes on index block reclamation 23 0.00 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 87,566,452 1,519.63 255.16
free buffer requested 86,369,923 1,498.87 251.68
gc CPU used by this session 1,192,377 20.69 3.47
gc blocks lost 2 0.00 0.00
gc cr block build time 417 0.01 0.00
gc cr block flush time 1,110 0.02 0.00
gc cr block receive time 13,248 0.23 0.04
gc cr block send time 1,249 0.02 0.00
gc cr blocks received 284,843 4.94 0.83
gc cr blocks served 259,615 4.51 0.76
gc current block flush time 527 0.01 0.00
gc current block pin time 21,705 0.38 0.06
gc current block receive time 3,229,453 56.04 9.41
gc current block send time 181,620 3.15 0.53
gc current blocks received 36,930,136 640.89 107.61
gc current blocks served 39,476,855 685.08 115.03
gc local grants 25,756,736 446.98 75.05
gc remote grants 23,339,240 405.03 68.01
gcs messages sent 121,069,318 2,101.04 352.79
ges messages sent 2,192,312 38.05 6.39
global enqueue get time 37,778 0.66 0.11
global enqueue gets async 492,561 8.55 1.44
global enqueue gets sync 2,052,416 35.62 5.98
global enqueue releases 2,482,543 43.08 7.23
heap block compress 15,416 0.27 0.04
hot buffers moved to head of LRU 13,144,750 228.11 38.30
immediate (CR) block cleanout applications 26,001 0.45 0.08
immediate (CURRENT) block cleanout applications 169,050 2.93 0.49
index crx upgrade (found) 30 0.00 0.00
index crx upgrade (positioned) 211,309 3.67 0.62
index fast full scans (full) 77,073 1.34 0.22
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 49,957,703 866.97 145.57
index scans kdiixs1 138,623,139 2,405.67 403.94
leaf node 90-10 splits 411 0.01 0.00
leaf node splits 4,884 0.08 0.01
lob reads 908,267 15.76 2.65
lob writes 39,625 0.69 0.12
lob writes unaligned 37,318 0.65 0.11
logons cumulative 2,243 0.04 0.01
messages received 892,062 15.48 2.60
messages sent 888,862 15.43 2.59
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 2,162,223,760 37,523.33 6,300.63
opened cursors cumulative 4,032,067 69.97 11.75
parse count (failures) 46 0.00 0.00
parse count (hard) 453,876 7.88 1.32
parse count (total) 3,025,905 52.51 8.82
parse time cpu 249,016 4.32 0.73
parse time elapsed 377,864 6.56 1.10
physical read IO requests 14,625,808 253.82 42.62
physical read bytes ############### 7,395,844.94 1,241,853.02
physical read total IO requests 15,043,784 261.07 43.84
physical read total bytes ############### 7,555,130.22 1,268,598.97
physical read total multi block requests 3,808,714 66.10 11.10
physical reads 52,023,168 902.81 151.59
physical reads cache 49,009,713 850.52 142.81
physical reads cache prefetch 41,479,616 719.84 120.87
physical reads direct 3,013,496 52.30 8.78
physical reads direct (lob) 2,924,482 50.75 8.52
physical reads direct temporary tablespace 82,215 1.43 0.24
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 347,156 6.02 1.01
physical write bytes 4,200,726,528 72,899.59 12,240.74
physical write total IO requests 1,067,371 18.52 3.11
physical write total bytes 12,038,526,976 208,917.13 35,079.75
physical write total multi block requests 658,531 11.43 1.92
physical writes 512,784 8.90 1.49
physical writes direct 222,595 3.86 0.65
physical writes direct (lob) 137,054 2.38 0.40
physical writes direct temporary tablespace 84,090 1.46 0.25
physical writes from cache 290,189 5.04 0.85
physical writes non checkpoint 444,037 7.71 1.29
pinned buffers inspected 4,552 0.08 0.01
prefetch clients - default 199 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 799 0.01 0.00
process last non-idle time 116,813 2.03 0.34
queries parallelized 426 0.01 0.00
recovery blocks read 3 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 28,577,535 495.94 83.27
recursive cpu usage 466,695 8.10 1.36
redo blocks written 4,513,345 78.32 13.15
redo buffer allocation retries 19 0.00 0.00
redo entries 2,729,334 47.36 7.95
redo log space requests 22 0.00 0.00
redo log space wait time 50 0.00 0.00
redo ordering marks 60,384 1.05 0.18
redo size 2,145,143,628 37,226.92 6,250.86
redo subscn max counts 39,533 0.69 0.12
redo synch time 49,873 0.87 0.15
redo synch writes 287,395 4.99 0.84
redo wastage 91,513,780 1,588.13 266.67
redo write time 50,744 0.88 0.15
redo writer latching time 19 0.00 0.00
redo writes 322,565 5.60 0.94
rollback changes - undo records applied 1,122 0.02 0.00
rollbacks only - consistent read gets 3,532 0.06 0.01
rows fetched via callback 32,980,296 572.34 96.10
session connect time 0 0.00 0.00
session cursor cache hits 2,609,330 45.28 7.60
session logical reads 2,286,884,584 39,686.70 6,663.88
session pga memory 5,806,510,392 100,766.44 16,919.92
session pga memory max 16,532,001,080 286,897.07 48,173.54
session uga memory ############### 11,478,973.94 1,927,460.43
session uga memory max 2,836,774,632 49,229.51 8,266.24
shared hash latch upgrades - no wait 2,087,131 36.22 6.08
shared hash latch upgrades - wait 559 0.01 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 28,905,946 501.64 84.23
sorts (rows) 1,554,177,423 26,971.26 4,528.81
sql area evicted 450,677 7.82 1.31
sql area purged 360 0.01 0.00
summed dirty queue length 31,204 0.54 0.09
switch current to new buffer 43,420 0.75 0.13
table fetch by rowid 1,507,991,270 26,169.75 4,394.22
table fetch continued row 2,880,684 49.99 8.39
table scan blocks gotten 903,506,859 15,679.50 2,632.78
table scan rows gotten 17,030,931,149 295,555.53 49,627.40
table scans (direct read) 0 0.00 0.00
table scans (long tables) 11,020 0.19 0.03
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 661,034 11.47 1.93
total number of times SMON posted 631 0.01 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 256 0.00 0.00
transaction tables consistent read rollbacks 155 0.00 0.00
transaction tables consistent reads - undo records applied 180,574 3.13 0.53
undo change vector size 434,126,452 7,533.85 1,265.03
user I/O wait time 1,750,828 30.38 5.10
user calls 143,194,131 2,485.00 417.26
user commits 284,794 4.94 0.83
user rollbacks 58,382 1.01 0.17
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 28,314,431 491.37 82.51
write clones created in background 2 0.00 0.00
write clones created in foreground 27 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 9,077,919 9,089,231
opened cursors current 10,099 8,541
workarea memory allocated 11,172,792 11,174,444
logons current 224 237

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 8 0.50

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)
MWS_APP 4,633,656 80 1.72 2.95 65,073 1 256,474 1.23
MWS_SYS 3,603,903 63 3.45 2.41 66,507 1 121,601 1.02
MWS_SBDYX 2,128,808 37 1.71 6.89 2,686 0 147,664 1.47
MWS_RTM 1,410,927 24 2.77 3.16 13,704 0 45,293 1.49
MWS_LP 882,496 15 0.96 1.50 3,072 0 122,102 0.48
MWS_SBDJX 875,422 15 2.70 5.90 1,583 0 32,925 2.07
MWS_CBM 563,610 10 2.46 5.20 13,187 0 18,970 1.25
INDX 279,809 5 3.64 1.00 15,825 0 65,946 1.24
MWS_FILE 64,558 1 1.73 1.01 128,927 2 6 1.67
MWS_SBD 40,547 1 7.77 9.49 805 0 2 0.00
UNDOTBS1 21,018 0 2.94 1.00 13,681 0 223 0.04
JCAS_DMS 34,335 1 1.64 1.25 253 0 0 0.00
MWS_GY 28,320 0 3.13 3.15 2,183 0 4 0.00
SYSTEM 24,927 0 4.37 1.31 4,507 0 12 9.17
SYSAUX 7,326 0 4.09 1.03 6,902 0 0 0.00
TEMP 5,772 0 0.73 14.32 5,897 0 0 0.00
GOLDENGATE 7,242 0 3.33 1.00 2,064 0 11 0.00
UNDOTBS2 7,007 0 2.31 1.00 36 0 35 0.86
MWS_PDYX 2,832 0 4.52 8.52 203 0 0 0.00
MWS_LPTX 2,083 0 1.59 15.14 9 0 0 0.00
MWS_PD 111 0 10.45 1.71 9 0 0 0.00
JCAS_DJM 55 0 15.09 1.71 9 0 0 0.00
GEOSTAR 21 0 31.43 1.00 9 0 0 0.00
USERS 21 0 24.29 1.00 9 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)
GEOSTAR /dev/rlvdata2_14_1g 21 0 31.43 1.00 9 0 0 0.00
GOLDENGATE /dev/rlvdata3_9_10g 7,242 0 3.33 1.00 2,064 0 11 0.00
INDX /dev/rlvdata2_12_5g 220,705 4 3.55 1.00 11,644 0 65,659 1.23
INDX /dev/rlvdata4_21_5g 59,104 1 4.00 1.00 4,181 0 287 3.87
JCAS_DJM /dev/rlvdata2_15_1g 55 0 15.09 1.71 9 0 0 0.00
JCAS_DMS /dev/rlvdata2_13_5g 34,335 1 1.64 1.25 253 0 0 0.00
MWS_APP /dev/rlvdata2_14_5g 106,418 2 1.62 3.30 1,538 0 606 1.25
MWS_APP /dev/rlvdata3_10_10g 175,568 3 2.09 4.77 5,366 0 9,313 1.37
MWS_APP /dev/rlvdata3_5_10g 219,175 4 1.78 3.45 10,207 0 4,436 1.80
MWS_APP /dev/rlvdata3_6_10g 226,345 4 1.81 3.66 7,511 0 4,816 1.42
MWS_APP /dev/rlvdata3_7_10g 221,798 4 1.79 3.34 7,368 0 4,041 1.79
MWS_APP /dev/rlvdata4_10_5g 276,432 5 1.65 2.79 1,050 0 12,697 1.08
MWS_APP /dev/rlvdata4_13_5g 285,631 5 1.59 3.02 1,605 0 19,329 1.09
MWS_APP /dev/rlvdata4_15_5g 455,878 8 1.51 2.60 1,751 0 25,984 1.14
MWS_APP /dev/rlvdata4_17_5g 440,539 8 1.65 2.26 1,428 0 29,288 1.17
MWS_APP /dev/rlvdata4_18_5g 435,933 8 1.63 2.30 998 0 29,177 1.19
MWS_APP /dev/rlvdata4_19_5g 445,440 8 1.62 2.43 1,305 0 27,601 1.20
MWS_APP /dev/rlvdata4_1_5g 119,658 2 2.09 4.41 735 0 8,078 1.36
MWS_APP /dev/rlvdata4_22_5g 396,289 7 1.61 2.39 1,162 0 24,627 1.14
MWS_APP /dev/rlvdata4_26_5g 195,332 3 1.93 2.94 1,447 0 14,369 1.28
MWS_APP /dev/rlvdata4_33_5g 129,389 2 1.70 3.47 864 0 9,218 1.28
MWS_APP /dev/rlvdata4_36_5g 126,695 2 1.63 3.64 514 0 9,166 1.16
MWS_APP /dev/rlvdata4_37_5g 120,828 2 1.68 3.55 511 0 9,463 1.23
MWS_APP /dev/rlvdata4_8_5g 161,316 3 1.56 2.50 771 0 6,429 1.00
MWS_APP /dev/rlvdata5_19_30g 75,520 1 3.10 4.36 7,871 0 7,528 1.96
MWS_APP /dev/rlvdata5_20_30g 16,195 0 3.22 8.98 6,810 0 294 5.51
MWS_APP /dev/rlvdata5_22_30g 3,277 0 6.14 2.31 4,261 0 14 0.71
MWS_CBM /dev/rlvdata2_16_1g 58,345 1 3.04 6.10 1,358 0 877 1.72
MWS_CBM /dev/rlvdata2_19_1g 54,185 1 3.76 5.22 887 0 1,834 1.22
MWS_CBM /dev/rlvdata4_34_5g 201,689 4 2.15 5.08 5,045 0 5,775 1.38
MWS_CBM /dev/rlvdata4_42_5g 39,596 1 2.75 4.67 3,632 0 967 1.60
MWS_CBM /dev/rlvdata4_5_5g 209,795 4 2.21 5.15 2,265 0 9,517 1.11
MWS_FILE /dev/rlvdata2_15_5g 252 0 7.46 1.00 98 0 0 0.00
MWS_FILE /dev/rlvdata2_2_5g 132 0 10.23 1.00 50 0 0 0.00
MWS_FILE /dev/rlvdata3_4_10g 297 0 7.21 1.00 102 0 0 0.00
MWS_FILE /dev/rlvdata3_8_10g 240 0 8.54 1.00 110 0 3 3.33
MWS_FILE /dev/rlvdata4_12_5g 83 0 7.95 1.00 57 0 0 0.00
MWS_FILE /dev/rlvdata4_23_5g 158 0 7.53 1.00 137 0 0 0.00
MWS_FILE /dev/rlvdata4_27_5g 69 0 12.17 1.00 45 0 0 0.00
MWS_FILE /dev/rlvdata4_28_5g 82 0 11.10 1.00 39 0 0 0.00
MWS_FILE /dev/rlvdata4_29_5g 44 0 13.86 1.00 19 0 0 0.00
MWS_FILE /dev/rlvdata4_30_5g 296 0 6.28 1.00 374 0 0 0.00
MWS_FILE /dev/rlvdata4_31_5g 39 0 13.59 1.00 25 0 0 0.00
MWS_FILE /dev/rlvdata4_32_5g 70 0 10.14 1.00 165 0 2 0.00
MWS_FILE /dev/rlvdata4_35_5g 43 0 11.16 1.00 9 0 0 0.00
MWS_FILE /dev/rlvdata4_9_5g 135 0 8.96 1.00 93 0 0 0.00
MWS_FILE /dev/rlvdata5_10_30g 1,365 0 1.79 1.03 3,510 0 0 0.00
MWS_FILE /dev/rlvdata5_11_30g 1,510 0 1.32 1.00 9,896 0 0 0.00
MWS_FILE /dev/rlvdata5_12_30g 2,798 0 1.17 1.01 9,438 0 0 0.00
MWS_FILE /dev/rlvdata5_13_30g 3,187 0 1.30 1.01 8,601 0 0 0.00
MWS_FILE /dev/rlvdata5_14_30g 18,204 0 1.33 1.00 8,554 0 0 0.00
MWS_FILE /dev/rlvdata5_15_30g 9,802 0 1.81 1.01 7,384 0 0 0.00
MWS_FILE /dev/rlvdata5_16_30g 3,335 0 2.27 1.01 8,296 0 0 0.00
MWS_FILE /dev/rlvdata5_17_30g 3,355 0 1.90 1.01 7,007 0 0 0.00
MWS_FILE /dev/rlvdata5_18_30g 3,185 0 1.56 1.01 7,314 0 0 0.00
MWS_FILE /dev/rlvdata5_1_30g 794 0 1.98 1.00 6,672 0 1 0.00
MWS_FILE /dev/rlvdata5_2_30g 2,196 0 1.32 1.01 9,486 0 0 0.00
MWS_FILE /dev/rlvdata5_3_30g 1,823 0 1.21 1.02 8,663 0 0 0.00
MWS_FILE /dev/rlvdata5_4_30g 1,908 0 1.66 1.01 7,444 0 0 0.00
MWS_FILE /dev/rlvdata5_5_30g 1,802 0 0.97 1.00 5,847 0 0 0.00
MWS_FILE /dev/rlvdata5_6_30g 1,873 0 1.14 1.00 6,114 0 0 0.00
MWS_FILE /dev/rlvdata5_7_30g 2,276 0 1.15 1.00 6,419 0 0 0.00
MWS_FILE /dev/rlvdata5_8_30g 1,451 0 1.04 1.02 3,291 0 0 0.00
MWS_FILE /dev/rlvdata5_9_30g 1,754 0 2.82 1.00 3,668 0 0 0.00
MWS_GY /dev/rlvdata2_10_1g 24,032 0 2.94 2.90 1,177 0 4 0.00
MWS_GY /dev/rlvdata4_40_5g 4,288 0 4.20 4.55 1,006 0 0 0.00
MWS_LP /dev/rlvdata2_10_5g 882,496 15 0.96 1.50 3,072 0 122,102 0.48
MWS_LPTX /dev/rlvdata2_17_1g 2,083 0 1.59 15.14 9 0 0 0.00
MWS_PD /dev/rlvdata3_3_10g 111 0 10.45 1.71 9 0 0 0.00
MWS_PDYX /dev/rlvdata2_11_1g 2,832 0 4.52 8.52 203 0 0 0.00
MWS_RTM /dev/rlvdata2_17_5g 290,552 5 2.01 5.83 839 0 19,900 1.54
MWS_RTM /dev/rlvdata2_19_5g 108,532 2 3.25 1.54 678 0 371 1.13
MWS_RTM /dev/rlvdata2_20_5g 86,125 1 3.26 1.24 661 0 197 1.42
MWS_RTM /dev/rlvdata2_4_5g 114,381 2 3.53 1.39 2,102 0 967 0.36
MWS_RTM /dev/rlvdata2_7_5g 111,262 2 3.09 1.40 1,971 0 582 0.88
MWS_RTM /dev/rlvdata2_9_5g 120,424 2 3.33 1.25 3,864 0 437 0.94
MWS_RTM /dev/rlvdata3_2_10g 340,099 6 2.28 5.12 2,719 0 22,388 1.49
MWS_RTM /dev/rlvdata4_3_5g 123,094 2 2.85 1.20 527 0 267 4.87
MWS_RTM /dev/rlvdata4_4_5g 116,458 2 3.58 1.17 343 0 184 2.39
MWS_SBD /dev/rlvdata2_11_5g 33,726 1 8.53 9.05 462 0 2 0.00
MWS_SBD /dev/rlvdata2_18_5g 6,821 0 4.06 11.65 343 0 0 0.00
MWS_SBDJX /dev/rlvdata2_12_1g 7,198 0 3.01 13.21 22 0 0 0.00
MWS_SBDJX /dev/rlvdata2_18_1g 116,880 2 2.08 10.90 91 0 663 2.08
MWS_SBDJX /dev/rlvdata2_20_1g 153,117 3 2.87 5.99 59 0 4,744 2.35
MWS_SBDJX /dev/rlvdata4_24_5g 571,985 10 2.78 4.87 737 0 26,118 2.00
MWS_SBDJX /dev/rlvdata4_53_5g 26,242 0 2.56 3.60 674 0 1,400 2.44
MWS_SBDYX /dev/rlvdata2_13_1g 346,502 6 1.60 6.98 126 0 13,465 1.49
MWS_SBDYX /dev/rlvdata2_1_1g 341,112 6 1.65 6.88 53 0 12,996 1.42
MWS_SBDYX /dev/rlvdata2_2_1g 332,861 6 1.78 6.88 83 0 12,048 1.55
MWS_SBDYX /dev/rlvdata2_3_1g 224,655 4 1.82 8.10 39 0 21,457 1.54
MWS_SBDYX /dev/rlvdata2_4_1g 230,880 4 1.63 7.46 45 0 22,407 1.43
MWS_SBDYX /dev/rlvdata2_6_1g 131,772 2 1.64 6.94 832 0 16,252 1.39
MWS_SBDYX /dev/rlvdata4_41_5g 77,001 1 2.37 5.03 457 0 6,606 1.57
MWS_SBDYX /dev/rmws_sbdyx_2g 444,025 8 1.66 6.24 1,051 0 42,433 1.46
MWS_SYS /dev/rlvdata2_16_5g 100,218 2 2.44 3.07 5,053 0 303 3.63
MWS_SYS /dev/rlvdata2_1_5g 292,300 5 4.10 2.15 2,009 0 173 0.81
MWS_SYS /dev/rlvdata2_3_5g 204,403 4 3.13 3.42 745 0 5,718 0.95
MWS_SYS /dev/rlvdata2_5_5g 177,893 3 3.26 3.22 2,801 0 8,801 1.04
MWS_SYS /dev/rlvdata2_6_5g 223,126 4 3.71 2.56 3,839 0 27,220 0.89
MWS_SYS /dev/rlvdata2_8_5g 177,393 3 3.13 3.05 2,196 0 34,857 0.93
MWS_SYS /dev/rlvdata3_1_10g 288,428 5 2.76 2.93 6,801 0 290 4.76
MWS_SYS /dev/rlvdata4_14_5g 325,405 6 3.62 1.89 5,486 0 986 1.21
MWS_SYS /dev/rlvdata4_16_5g 338,957 6 3.53 1.84 6,249 0 1,661 0.96
MWS_SYS /dev/rlvdata4_20_5g 240,379 4 3.63 1.86 6,012 0 601 1.30
MWS_SYS /dev/rlvdata4_25_5g 199,559 3 3.71 1.86 3,550 0 860 0.95
MWS_SYS /dev/rlvdata4_2_5g 106,907 2 3.05 4.03 985 0 24,633 1.05
MWS_SYS /dev/rlvdata4_38_5g 175,926 3 3.63 1.80 3,722 0 774 1.42
MWS_SYS /dev/rlvdata4_39_5g 164,624 3 3.73 1.85 3,957 0 745 2.16
MWS_SYS /dev/rlvdata4_43_5g 49,312 1 3.86 2.09 2,409 0 98 1.12
MWS_SYS /dev/rlvdata4_44_5g 44,300 1 3.61 2.01 3,619 0 320 1.63
MWS_SYS /dev/rlvdata4_45_5g 39,876 1 3.39 2.01 1,586 0 313 1.44
MWS_SYS /dev/rlvdata4_6_5g 214,037 4 3.43 2.53 1,608 0 7,129 1.44
MWS_SYS /dev/rlvdata4_7_5g 221,983 4 3.39 2.49 3,866 0 6,119 1.04
MWS_SYS /dev/rlvdata5_21_30g 18,877 0 3.21 2.83 14 0 0 0.00
SYSAUX /dev/rsysaux01_4g 7,083 0 4.14 1.03 6,685 0 0 0.00
SYSAUX /dev/rsysaux02_5g 243 0 2.72 1.00 217 0 0 0.00
SYSTEM /dev/rlvdata4_11_5g 850 0 4.86 1.12 298 0 4 10.00
SYSTEM /dev/rsystem01_4g 24,077 0 4.36 1.31 4,209 0 8 8.75
TEMP /dev/rlvdata4_52_5g 1,498 0 0.77 14.45 1,520 0 0  
TEMP /dev/rtemp01_5g 2,806 0 0.71 14.66 2,863 0 0  
TEMP /dev/rtemp02_5g 1,468 0 0.74 13.53 1,514 0 0  
UNDOTBS1 /dev/rlvdata4_46_5g 4,363 0 1.88 1.00 2,395 0 5 0.00
UNDOTBS1 /dev/rlvdata4_47_5g 4,627 0 1.73 1.00 2,270 0 8 0.00
UNDOTBS1 /dev/rlvdata4_48_5g 2,178 0 2.14 1.00 1,789 0 1 0.00
UNDOTBS1 /dev/rundotbs1_4g 9,850 0 4.16 1.00 7,227 0 209 0.05
UNDOTBS2 /dev/rlvdata4_49_5g 1,899 0 2.06 1.00 9 0 17 0.59
UNDOTBS2 /dev/rlvdata4_50_5g 1,226 0 2.59 1.00 9 0 4 2.50
UNDOTBS2 /dev/rlvdata4_51_5g 2,172 0 2.20 1.00 9 0 4 0.00
UNDOTBS2 /dev/rundotbs2_4g 1,710 0 2.56 1.00 9 0 10 1.00
USERS /dev/ruser01_1g 21 0 24.29 1.00 9 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 1,082,987 98 2,282,956,478 49,004,267 290,189 0 0 811,654


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 24 9007 116418 132075 1410030 132075  
E 0 9 4773 177719 803689 1410030 803689  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 896 0.10 107,464 1.27 95,725,567,470
D 1,792 0.20 214,928 1.20 90,404,327,319
D 2,688 0.30 322,392 1.15 86,713,312,174
D 3,584 0.39 429,856 1.12 83,974,454,690
D 4,480 0.49 537,320 1.09 81,902,047,908
D 5,376 0.59 644,784 1.07 80,260,521,244
D 6,272 0.69 752,248 1.05 78,869,276,362
D 7,168 0.79 859,712 1.03 77,620,293,072
D 8,064 0.89 967,176 1.02 76,450,127,953
D 8,960 0.99 1,074,640 1.00 75,322,967,761
D 9,088 1.00 1,089,992 1.00 75,165,500,487
D 9,856 1.08 1,182,104 0.99 74,220,942,094
D 10,752 1.18 1,289,568 0.97 73,134,239,541
D 11,648 1.28 1,397,032 0.96 72,057,476,415
D 12,544 1.38 1,504,496 0.94 70,987,172,422
D 13,440 1.48 1,611,960 0.93 69,920,849,468
D 14,336 1.58 1,719,424 0.92 68,854,735,631
D 15,232 1.68 1,826,888 0.90 67,774,762,833
D 16,128 1.77 1,934,352 0.89 66,628,609,078
D 17,024 1.87 2,041,816 0.87 65,172,016,333
D 17,920 1.97 2,149,280 0.84 63,157,709,109

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 249,465 0

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 3,878 2,595 1,480.71 0.19 0.01 100.00 0.00 397,100
E 3,878 2,623 1,547.58 1.80 0.12 100.00 0.00 397,100

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 28,172,260 28,172,260 0 0
64K 128K 20,265 20,265 0 0
128K 256K 6,784 6,784 0 0
256K 512K 19,791 19,791 0 0
512K 1024K 86,229 86,229 0 0
1M 2M 4,619 4,619 0 0
2M 4M 438 438 0 0
4M 8M 462 462 0 0
8M 16M 814 814 0 0
16M 32M 976 976 0 0
32M 64M 160 160 0 0
64M 128M 546 546 0 0
128M 256M 207 207 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
485 0.13 87,781,761.50 23,887,006.33 79.00 674,830
970 0.25 87,781,761.50 14,527,218.79 86.00 368,391
1,939 0.50 87,781,761.50 120,995.65 100.00 753
2,909 0.75 87,781,761.50 94,560.37 100.00 243
3,878 1.00 87,781,761.50 72,296.91 100.00 0
4,654 1.20 87,781,761.50 54,002.83 100.00 0
5,429 1.40 87,781,761.50 54,002.83 100.00 0
6,205 1.60 87,781,761.50 54,002.83 100.00 0
6,980 1.80 87,781,761.50 54,002.83 100.00 0
7,756 2.00 87,781,761.50 54,002.83 100.00 0
11,634 3.00 87,781,761.50 54,002.83 100.00 0
15,512 4.00 87,781,761.50 54,002.83 100.00 0
23,268 6.00 87,781,761.50 54,002.83 100.00 0
31,024 8.00 87,781,761.50 54,002.83 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
1,648 0.28 655 32,284 187,106,522 0.90 25,033,551 5.20 2,948,646,443
2,240 0.39 1,245 60,274 191,885,134 0.93 20,254,939 4.21 2,957,498,358
2,832 0.49 1,835 87,208 195,559,746 0.94 16,580,327 3.44 2,964,173,821
3,424 0.59 2,424 113,476 198,626,484 0.96 13,513,589 2.81 2,969,227,193
4,016 0.69 3,015 140,459 201,267,157 0.97 10,872,916 2.26 2,973,185,138
4,608 0.80 3,606 166,020 203,526,534 0.98 8,613,539 1.79 2,976,694,208
5,200 0.90 4,196 192,435 205,482,377 0.99 6,657,696 1.38 2,979,883,334
5,792 1.00 4,784 219,095 207,324,379 1.00 4,815,694 1.00 2,982,778,786
6,384 1.10 5,375 245,810 209,056,042 1.01 3,084,031 0.64 2,985,429,088
6,976 1.20 5,966 274,595 210,687,972 1.02 1,452,101 0.30 2,987,836,694
7,568 1.31 6,557 301,388 212,240,056 1.02 1 0.00 2,990,058,856
8,160 1.41 7,148 327,733 213,760,918 1.03 1 0.00 2,992,163,846
8,752 1.51 7,739 353,754 215,203,875 1.04 1 0.00 2,994,183,566
9,344 1.61 8,330 378,704 216,586,109 1.04 1 0.00 2,996,146,884
9,936 1.72 8,921 401,401 217,939,285 1.05 1 0.00 2,998,077,053
10,528 1.82 9,511 427,109 219,258,804 1.06 1 0.00 2,999,974,840
11,120 1.92 10,102 450,608 220,568,655 1.06 1 0.00 3,001,831,853
11,712 2.02 10,692 476,173 221,866,939 1.07 1 0.00 3,003,670,458

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
3,752 0.25 455,838,341 95,723,209,206
7,504 0.50 403,742,530 84,982,065,432
11,256 0.75 379,121,908 80,953,196,949
15,008 1.00 356,820,618 75,165,456,777
18,760 1.25 335,054,561 69,009,405,867
22,512 1.50 313,217,143 66,874,706,894
26,264 1.75 306,437,551 66,874,706,894
30,016 2.00 306,437,552 66,874,706,894

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
16 0.50 0 0 0 0
32 1.00 0 0 0 0
48 1.50 0 0 0 0
64 2.00 0 0 0 0
80 2.50 0 0 0 0
96 3.00 0 0 0 0
112 3.50 0 0 0 0
128 4.00 0 0 0 0
144 4.50 0 0 0 0
160 5.00 0 0 0 0
176 5.50 0 0 0 0
192 6.00 0 0 0 0
208 6.50 0 0 0 0
224 7.00 0 0 0 0
240 7.50 0 0 0 0
256 8.00 0 0 0 0
272 8.50 0 0 0 0
288 9.00 0 0 0 0
304 9.50 0 0 0 0
320 10.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP 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
16 0.25 5 101 3 1.00 4,815,694 1.00 101
32 0.50 5 101 3 1.00 4,815,694 1.00 101
48 0.75 5 101 3 1.00 4,815,694 1.00 101
64 1.00 5 101 3 1.00 4,815,694 1.00 101
80 1.25 5 101 3 1.00 4,815,694 1.00 101
96 1.50 5 101 3 1.00 4,815,694 1.00 101
112 1.75 5 101 3 1.00 4,815,694 1.00 101
128 2.00 5 101 3 1.00 4,815,694 1.00 101

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 809,769 958 1
2nd level bmb 6 0 10
undo block 65 0 0
1st level bmb 61 0 0
undo header 193 0 0
segment header 4 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 316 316 0 155 30 191.59
TX-Transaction (index contention) 1,844 1,843 0 1,312 10 7.31
TM-DML 415,449 415,449 0 17,681 8 0.46
XR-Quiesce / Force Logging (database force logging) 19,172 19,172 0 19,172 7 0.39
CF-Controlfile Transaction 139,505 139,503 2 2,666 1 0.40
TX-Transaction (row lock contention) 3,022 3,021 0 1,535 1 0.64
PS-PX Process Reservation 3,793 3,793 0 1,999 1 0.35
TT-Tablespace 57,975 57,975 0 1,608 0 0.31
US-Undo Segment 2,311 2,311 0 1,125 0 0.29
HW-Segment High Water Mark 113,946 113,946 0 173 0 1.21
SQ-Sequence Cache 7,071 7,071 0 62 0 1.53
TD-KTF map table enqueue (KTF dump entries) 190 190 0 190 0 0.36
TO-Temp Object 306 306 0 155 0 0.41
JQ-Job Queue 275 155 120 103 0 0.50
FB-Format Block 324 324 0 116 0 0.34
DR-Distributed Recovery 32 32 0 32 0 0.38
MW-MWIN Schedule 32 32 0 32 0 0.28
JS-Job Scheduler (job run lock - synchronize) 17 16 1 17 0 0.53
TX-Transaction 328,372 328,374 0 2 0 4.00
AF-Advisor Framework (task serialization) 112 112 0 12 0 0.58
TX-Transaction (allocate ITL entry) 10 10 0 10 0 0.60
PG-Global Parameter 138 138 0 14 0 0.21
RO-Multiple Object Reuse (fast object reuse) 20 20 0 7 0 0.14
WL-Being Written Redo Log 8 8 0 4 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 65.86 328,441 10,121,096 22 15.9666666666666666666666666666666666667/5760 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
30-Jun 15:54 1,151 5,592 141 3 5,760 0/0 0/0/0/0/0/0
30-Jun 15:44 953 4,890 140 3 5,760 0/0 0/0/0/0/0/0
30-Jun 15:34 1,055 8,401 138 4 16 0/0 0/0/0/0/0/0
30-Jun 15:24 1,069 8,403 137 6 5,760 0/0 0/0/0/0/0/0
30-Jun 15:14 965 5,933 117 4 16 0/0 0/0/0/0/0/0
30-Jun 15:04 992 6,057 618 4 5,760 0/0 0/0/0/0/0/0
30-Jun 14:54 1,210 5,685 275 5 5,760 0/0 0/0/0/0/0/0
30-Jun 14:44 981 5,553 142 5 5,760 0/0 0/0/0/0/0/0
30-Jun 14:34 912 5,120 142 22 5,760 0/0 0/0/0/0/0/0
30-Jun 14:24 785 5,384 141 3 5,760 0/0 0/0/0/0/0/0
30-Jun 14:14 531 2,762 137 3 5,760 0/0 0/0/0/0/0/0
30-Jun 14:04 614 3,046 140 4 5,760 0/0 0/0/0/0/0/0
30-Jun 13:54 619 3,621 584 5 5,760 0/0 0/0/0/0/0/0
30-Jun 13:44 336 1,636 139 3 5,760 0/0 0/0/0/0/0/0
30-Jun 13:34 457 2,316 139 3 5,760 0/0 0/0/0/0/0/0
30-Jun 13:24 406 1,935 10,121,096 3 5,760 0/0 0/0/0/0/0/0
30-Jun 13:14 384 1,692 163 3 18 0/0 0/0/0/0/0/0
30-Jun 13:04 529 2,320 10,119,894 3 5,760 0/0 0/0/0/0/0/0
30-Jun 12:54 333 1,851 134 4 5,760 0/0 0/0/0/0/0/0
30-Jun 12:44 359 1,735 10,118,693 4 5,760 0/0 0/0/0/0/0/0
30-Jun 12:34 339 1,949 3,069 3 5,760 0/0 0/0/0/0/0/0
30-Jun 12:24 347 1,932 2,465 3 5,760 0/0 0/0/0/0/0/0
30-Jun 12:14 434 2,074 1,866 4 5,760 0/0 0/0/0/0/0/0
30-Jun 12:04 1,075 6,879 1,266 5 5,760 0/0 0/0/0/0/0/0
30-Jun 11:54 1,424 10,684 665 4 5,760 0/0 0/0/0/0/0/0
30-Jun 11:44 941 5,844 1,411 3 38 0/0 0/0/0/0/0/0
30-Jun 11:34 1,241 9,322 809 5 5,760 0/0 0/0/0/0/0/0
30-Jun 11:24 1,665 9,810 851 9 5,760 0/0 0/0/0/0/0/0
30-Jun 11:14 1,277 8,987 41,049 4 698 0/0 0/0/0/0/0/0
30-Jun 11:04 1,294 7,838 40,447 5 688 0/0 0/0/0/0/0/0
30-Jun 10:54 1,567 7,357 39,844 4 5,760 0/0 0/0/0/0/0/0
30-Jun 10:44 1,026 6,589 39,243 4 668 0/0 0/0/0/0/0/0
30-Jun 10:34 1,034 6,397 19,792 4 344 0/0 0/0/0/0/0/0
30-Jun 10:24 1,625 8,538 19,191 4 5,760 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 45,040 0.00   0 0  
AWR Alerted Metric Element list 578,891 0.00   0 0  
Consistent RBA 322,563 0.00 0.00 0 0  
FAL request queue 1,168 0.00   0 0  
FAL subheap alocation 1,168 0.00   0 0  
FIB s.o chain latch 356 0.00   0 0  
FOB s.o list latch 10,966 0.00   0 0  
JS broadcast add buf latch 13,186 0.00   0 0  
JS broadcast drop buf latch 13,186 0.00   0 0  
JS broadcast load blnc latch 11,505 0.00   0 0  
JS mem alloc latch 44 0.00   0 0  
JS queue access latch 44 0.00   0 0  
JS queue state obj latch 415,746 0.00   0 0  
JS slv state obj latch 656 0.00   0 0  
KCL gc element parent latch 441,089,610 0.10 0.01 0 22,025 0.29
KJC message pool free list 5,776,660 0.05 0.00 0 2,610,440 0.03
KJCT flow control latch 75,215,866 0.02 0.00 0 0  
KMG MMAN ready and startup request latch 19,206 0.00   0 0  
KSXR large replies 3,858 0.00   0 0  
KTF sga latch 380 0.26 0.00 0 17,251 0.01
KWQMN job cache list latch 5,162 0.00   0 0  
KWQP Prop Status 32 0.00   0 0  
MQL Tracking Latch 0     0 1,150 0.00
Memory Management Latch 0     0 19,206 0.00
OS process 2,985 0.00   0 0  
OS process allocation 21,212 0.00   0 0  
OS process: request allocation 1,004 0.00   0 0  
PL/SQL warning settings 9,559 0.00   0 0  
SGA IO buffer pool latch 2,301,240 0.05 0.06 0 2,301,240 0.05
SQL memory manager latch 16 0.00   0 19,172 0.00
SQL memory manager workarea list latch 2,182,619 0.00 0.00 0 0  
Shared B-Tree 2,082 0.00   0 0  
active checkpoint queue latch 81,646 0.14 0.00 0 0  
active service list 128,354 0.00   0 19,778 0.01
archive control 1,126 0.00   0 0  
archive process latch 21,524 0.00   0 0  
begin backup scn array 135,672 0.00   0 0  
business card 852 0.00   0 0  
cache buffer handles 749,370 0.00 0.00 0 0  
cache buffers chains 4,686,837,061 0.13 0.01 2 333,091,645 0.13
cache buffers lru chain 75,545,764 0.49 0.00 0 518,751,658 0.35
cache table scan latch 0     0 3,763,924 0.29
channel handle pool latch 1,960 1.48 0.00 0 0  
channel operations parent latch 21,778,219 0.00 0.00 0 0  
checkpoint queue latch 4,246,294 0.00 0.01 0 432,939 0.00
client/application info 16,324 0.00   0 0  
commit callback allocation 12 0.00   0 0  
compile environment latch 2,248 0.00   0 0  
dml lock allocation 831,867 0.01 0.00 0 0  
dummy allocation 4,483 0.00   0 0  
enqueue hash chains 5,772,106 0.00 0.00 0 64,385 0.00
enqueues 3,388,678 0.02 0.00 0 0  
error message lists 1,906 0.00   0 0  
event group latch 509 0.00   0 0  
file cache latch 21,554 0.00   0 0  
gcs opaque info freelist 74,843,472 0.18 0.00 0 0  
gcs partitioned table hash 858,405,105 0.00 0.00 0 0  
gcs remaster request queue 177 1.69 0.67 0 0  
gcs remastering latch 133,133,715 0.00 2.31 0 0  
gcs resource freelist 53,597,987 0.04 0.00 0 21,067,690 0.04
gcs resource hash 415,797,822 0.10 0.00 0 812 0.25
gcs resource scan list 1,626 0.00   0 0  
gcs shadows freelist 40,466,660 0.00 0.00 0 40,433,486 0.00
ges caches resource lists 9,367,496 0.23 0.00 0 8,587,196 0.14
ges deadlock list 1,024,382 0.00 0.00 0 390 0.00
ges domain table 4,025,227 0.00 0.17 0 0  
ges enqueue table freelist 5,108,423 0.00 0.02 0 0  
ges group table 5,968,223 0.00 0.00 0 0  
ges process hash list 998,175 0.00   0 0  
ges process parent latch 11,495,348 0.00 0.00 0 0  
ges process table freelist 1,004 0.00   0 0  
ges resource hash list 11,614,600 0.02 0.45 0 2,146,868 0.02
ges resource scan list 1,282 0.00   0 0  
ges resource table freelist 3,187,092 0.00 0.01 0 0  
ges synchronous data 3,200 1.03 0.00 0 422,387 0.03
ges timeout list 478,926 0.00 0.00 0 499,761 0.00
global KZLD latch for mem in SGA 253 0.00   0 0  
global tx hash mapping 76,972 0.00 0.00 0 0  
hash table column usage latch 23,579 0.07 0.00 0 61,225,910 0.00
hash table modification latch 2,231 0.00   0 0  
internal temp table object number allocation latc 1,943 0.77 0.00 0 0  
job workq parent latch 0     0 350 0.00
job_queue_processes parameter latch 1,134 0.00   0 0  
kks stats 2,780,919 0.01 0.02 0 0  
kmcptab latch 4 0.00   0 0  
kmcpvec latch 0     0 4 0.00
kokc descriptor allocation latch 9,284 0.00   0 0  
ksuosstats global area 3,873 0.00   0 0  
ktm global data 12,576 0.00   0 0  
kwqbsn:qsga 2,066 0.00   0 0  
lgwr LWN SCN 338,855 0.12 0.00 0 0  
library cache 24,123,534 0.03 0.02 0 2,063,621 0.06
library cache load lock 358,070 0.00 0.00 0 0  
library cache lock 11,402,948 0.00 0.00 0 0  
library cache lock allocation 88,038 0.00   0 0  
library cache pin 5,165,366 0.00 0.00 0 5 0.00
library cache pin allocation 51,865 0.00   0 0  
list of block allocation 7,437 0.00   0 0  
loader state object freelist 1,786,672 0.00 0.00 0 0  
logminer context allocation 16 0.00   0 0  
longop free list parent 13,776 0.00   0 941 0.00
message pool operations parent latch 20,099 0.00 0.00 0 0  
messages 4,977,150 0.02 0.00 0 0  
mostly latch-free SCN 358,490 5.28 0.00 0 0  
multiblock read objects 20,443,499 0.07 0.00 0 0  
name-service memory objects 403,326 0.00   0 0  
name-service namespace bucket 636,175 0.00   0 0  
name-service pending queue 262,680 0.00   0 0  
name-service request 30 0.00   0 0  
name-service request queue 765,671 0.00   0 0  
ncodef allocation latch 1,002 0.00   0 0  
object queue header heap 66,890 0.00   0 64,836 0.00
object queue header operation 176,935,065 0.02 0.66 5 0  
object stats modification 700 0.14 0.00 0 0  
parallel query alloc buffer 24,474 0.00   0 0  
parallel query stats 2,846 0.00   0 0  
parallel txn reco latch 827,625 0.00   0 0  
parameter list 3,181 0.00   0 0  
parameter table allocation management 2,516 0.00   0 0  
post/wait queue 477,474 0.01 0.00 0 320,932 0.01
process allocation 429,080 0.00 1.00 0 509 0.00
process group creation 1,004 0.00   0 0  
process queue 7,562 0.00   0 0  
process queue reference 143,470 0.01 0.00 0 14,229 0.08
qmn task queue latch 12,414 14.35 0.01 0 0  
query server freelists 5,904 0.00   0 0  
query server process 5 0.00   0 5 0.00
queued dump request 288,079 0.00   0 0  
redo allocation 1,001,479 0.03 0.01 0 2,728,475 0.08
redo copy 0     0 2,729,398 0.11
redo writing 1,091,204 0.01 0.00 0 0  
resmgr group change latch 4,263 0.00   0 0  
resmgr:active threads 4,435 0.00   0 0  
resmgr:actses change group 1,981 0.00   0 0  
resmgr:free threads list 4,419 0.00   0 0  
resmgr:schema config 16 0.00   0 0  
row cache objects 269,638,458 0.21 0.00 0 302,543 0.36
rules engine aggregate statistics 6 0.00   0 0  
rules engine rule set statistics 1,612 0.00   0 0  
sequence cache 410,554 0.01 0.00 0 0  
session allocation 8,742,184 0.05 0.00 0 0  
session idle bit 286,837,504 0.00 0.01 0 0  
session state list latch 5,017 0.00   0 0  
session switching 1,002 0.00   0 0  
session timer 19,778 0.00   0 0  
shared pool 28,880,055 0.07 0.25 5 0  
shared pool simulator 32,751,226 0.00 0.06 1 0  
simulator hash latch 197,233,664 0.00 0.00 0 0  
simulator lru latch 0     0 158,471,724 0.62
slave class 32 0.00   0 0  
slave class create 128 12.50 1.00 0 0  
sort extent pool 22,937 0.11 0.00 0 0  
state object free list 32 0.00   0 0  
statistics aggregation 28,672 0.00   0 0  
temp lob duration state obj allocation 48 0.00   0 0  
temporary table state object allocation 8 0.00   0 0  
threshold alerts latch 10,342 0.00   0 0  
transaction allocation 18,152,481 0.62 0.00 0 0  
transaction branch allocation 95,305 0.02 0.00 0 0  
undo global data 2,348,374 0.00 0.00 0 6,801 0.00
user lock 1,594 0.06 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 4,686,837,061 6,209,107 49,686 6,160,624 0 0 0
row cache objects 269,638,458 563,324 467 562,887 0 0 0
KCL gc element parent latch 441,089,610 434,453 6,263 428,520 0 0 0
gcs resource hash 415,797,822 415,061 1,387 413,808 0 0 0
cache buffers lru chain 75,545,764 370,889 666 370,253 0 0 0
gcs opaque info freelist 74,843,472 131,022 50 130,977 0 0 0
transaction allocation 18,152,481 111,945 3 111,942 0 0 0
object queue header operation 176,935,065 33,995 22,336 16,425 0 0 0
gcs resource freelist 53,597,987 22,746 11 22,737 0 0 0
ges caches resource lists 9,367,496 21,150 17 21,133 0 0 0
shared pool 28,880,055 20,704 5,260 15,722 0 0 0
mostly latch-free SCN 358,490 18,931 15 18,918 0 0 0
KJCT flow control latch 75,215,866 16,353 13 16,343 0 0 0
multiblock read objects 20,443,499 14,368 20 14,350 0 0 0
simulator hash latch 197,233,664 8,410 8 8,403 0 0 0
library cache 24,123,534 8,036 132 7,905 0 0 0
session idle bit 286,837,504 5,121 28 5,093 0 0 0
session allocation 8,742,184 4,408 2 4,406 0 0 0
KJC message pool free list 5,776,660 2,941 5 2,936 0 0 0
ges resource hash list 11,614,600 2,060 934 1,128 0 0 0
qmn task queue latch 12,414 1,781 18 1,763 0 0 0
gcs remastering latch 133,133,715 1,246 2,884 542 0 0 0
SGA IO buffer pool latch 2,301,240 1,141 65 1,086 0 0 0
shared pool simulator 32,751,226 932 58 874 0 0 0
messages 4,977,150 869 1 868 0 0 0
library cache lock 11,402,948 429 1 428 0 0 0
channel operations parent latch 21,778,219 332 1 331 0 0 0
redo allocation 1,001,479 255 2 253 0 0 0
kks stats 2,780,919 222 5 217 0 0 0
ges resource table freelist 3,187,092 144 2 142 0 0 0
checkpoint queue latch 4,246,294 142 1 141 0 0 0
ges enqueue table freelist 5,108,423 62 1 61 0 0 0
slave class create 128 16 16 0 0 0 0
ges domain table 4,025,227 6 1 5 0 0 0
gcs remaster request queue 177 3 2 1 0 0 0
process allocation 429,080 2 2 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclnfndnewm 0 8,599 3,381
KCL gc element parent latch kclliter 0 1,809 79
KCL gc element parent latch kclzcl 0 1,325 1,303
KCL gc element parent latch kclplz 0 1,261 2,347
KCL gc element parent latch kclulb 0 952 3,756
KCL gc element parent latch kclnfnd 0 843 603
KCL gc element parent latch kclbla 0 377 1
KCL gc element parent latch KCLUNLNK 0 341 2,985
KCL gc element parent latch kclrwrite 0 293 64
KCL gc element parent latch kclgrantlk 0 66 580
KCL gc element parent latch kclgcr 0 42 11
KCL gc element parent latch kclprm 0 34 680
KCL gc element parent latch kclexpand 0 15 80
KCL gc element parent latch kclchkping 0 12 0
KCL gc element parent latch kclfwrite1 0 12 24
KCL gc element parent latch kclwrt 0 8 65
KCL gc element parent latch kclhngcbk1 0 6 0
KCL gc element parent latch kclebs 0 3 0
KCL gc element parent latch kclpdc_14 0 2 2
KCL gc element parent latch kclpdc_3 0 2 2
KCL gc element parent latch kclpto 0 2 9
KCL gc element parent latch kclpto_3 0 2 1
KCL gc element parent latch kclrbast 0 2 10
KJC message pool free list kjcsmpav: allocate a msg buffer 0 3 5
KJC message pool free list kjcspfmbq: free vector of msg buffers 0 2 0
KJCT flow control latch kjctcsnd: send normal message 0 12 2
KJCT flow control latch kjcts_sqenq: queue a message 0 1 10
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 35 0
SGA IO buffer pool latch ksfd_free_sgabuffer 0 30 65
cache buffers chains kcbgtcr: kslbegin excl 0 90,732 92,650
cache buffers chains kcbrls: kslbegin 0 16,279 21,915
cache buffers chains kclcls_3 0 7,550 160
cache buffers chains kcbgtcr: fast path 0 2,200 242
cache buffers chains kclobj_1 0 1,195 0
cache buffers chains kcbzib: multi-block read: nowait 0 937 0
cache buffers chains kcbzwb 0 689 4,001
cache buffers chains kcbzgb: scan from tail. nowait 0 504 0
cache buffers chains kcbgtcr: kslbegin shared 0 139 88
cache buffers chains kclexpand 0 105 41
cache buffers chains kcbzib: finish free bufs 0 98 130
cache buffers chains kcbget: pin buffer 0 74 33
cache buffers chains kcbgcur: kslbegin 0 68 13
cache buffers chains kclwrt 0 31 9
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 28 74
cache buffers chains kcbbxsv 0 19 40
cache buffers chains kclbla 0 12 1
cache buffers chains kclgrantlk_1 0 10 21
cache buffers chains kcbchg: kslbegin: call CR func 0 5 34
cache buffers chains kclebs_1 0 4 1
cache buffers chains kcbgtcr 0 3 2
cache buffers chains kclgrantlk 0 3 0
cache buffers chains kclwcrs 0 3 0
cache buffers chains kcbnew: new latch again 0 2 0
cache buffers chains kclobj 0 2 0
cache buffers chains kclpred 0 2 0
cache buffers chains kcbesc: escalate 0 1 0
cache buffers chains kcbget: exchange 0 1 3
cache buffers chains kcbget: exchange rls 0 1 3
cache buffers chains kcbnlc 0 1 11
cache buffers chains kclwlr 0 1 1
cache buffers lru chain kcbzgb: wait - one set in buffer pool 0 561 615
cache buffers lru chain kcbzgws 0 67 0
cache buffers lru chain kcbzar: KSLNBEGIN 0 25 0
cache buffers lru chain kcbzgm 0 6 0
cache buffers lru chain kcbbxsv: move to being written 0 2 16
cache buffers lru chain kcbrenounce 0 2 0
cache buffers lru chain kcbbwlru 0 1 6
cache buffers lru chain kcbzgb: posted for free bufs 0 1 16
cache buffers lru chain kcbzswcu 0 1 0
channel handle pool latch ksrchconnect() 0 9 9
channel operations parent latch ksrapublish() 0 3 1
channel operations parent latch ksrwait() 0 2 4
channel operations parent latch ksrsconsume() 0 1 0
checkpoint queue latch H_MK_PI_CR_BG 0 1 0
event range base latch No latch 0 18 18
gcs opaque info freelist kjbrcvt save opaque info 0 28 32
gcs opaque info freelist kjbrgrant free opaque info 0 22 18
gcs remaster request queue kjbdomchkreq 0 1 0
gcs remaster request queue kjdrscn 0 1 0
gcs remastering latch 59 0 3,222 1
gcs remastering latch 43 0 140 0
gcs remastering latch 69 0 22 1
gcs remastering latch 12 0 3 0
gcs remastering latch 64 0 2 2,626
gcs remastering latch 66 0 1 445
gcs resource freelist kjbralc add resource 0 11 2
gcs resource hash kjbcropen:affinity 0 557 100
gcs resource hash kjbrrcfwst 0 245 7
gcs resource hash kjblocalfile_nolock 0 230 37
gcs resource hash kjbassume 0 81 119
gcs resource hash kjbcropen 0 68 58
gcs resource hash kjbrrcres_99 0 66 8
gcs resource hash kjbmpopen 0 61 135
gcs resource hash kclzcl 0 20 629
gcs resource hash kjbldrmrpst 0 13 16
gcs resource hash kjbmpclose 0 12 167
gcs resource hash kjbmprlst: shadow 0 12 10
gcs resource hash kclgrantlk_1 0 8 40
gcs resource hash kjbrdrmcvtq_98 0 6 5
gcs resource hash kjbconvert 0 2 0
gcs resource hash kjblpast 0 2 26
gcs resource hash kjbopen:affinity 0 2 18
gcs resource hash kjbmpwrite 0 1 0
gcs resource hash kjbrwrdone reget 0 1 0
ges domain table kjdmlad: add a lock to an xid-hashed lock list 0 1 0
ges enqueue table freelist kjlalc: lock allocation 0 1 1
ges resource hash list kjakcai: search for resp by resname 0 821 53
ges resource hash list kjrmas1: lookup master node 0 58 1
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 47 4
ges resource hash list kjcvscn: remove from scan queue 0 3 0
ges resource hash list kjlrlr: remove lock from resource queue 0 3 149
ges resource hash list kjrref: find matched resource 0 1 4
ges resource hash list kjucvl: lock convert request 0 1 723
ges resource table freelist kjrchc: cached obj cleanup 0 9 1
ges resource table freelist kjruch: cached obj cleanup 0 7 0
ges resource table freelist kjralc: resource allocation 0 2 1
ges resource table freelist kjrm2c: move resource to cache 0 1 16
kks stats kks stats alloc/free 0 5 5
lgwr LWN SCN kcs023 0 7 0
library cache kglpndl: child: after processing 0 15 3
library cache kgldti: 2child 0 10 11
library cache kglobpn: child: 0 9 28
library cache kglukp: child 0 4 6
library cache kglScanDependency 0 3 0
library cache kglic 0 2 0
library cache kglLockCursor 0 1 5
library cache kglpin 0 1 10
library cache kqlmbfre: child: in loop 0 1 3
library cache lock kgllkdl: child: no lock handle 0 6 11
library cache lock ksucallcbksafely: kqllhng 0 2 0
library cache lock kgllkdl: child: cleanup 0 1 0
messages ksarcv: after wait 0 1 1
mostly latch-free SCN kcslcu3 0 8 15
multiblock read objects kcbzib: mbr get 0 12 9
multiblock read objects kcbzib: normal mbr free 0 8 11
object queue header operation kclobj_1 0 26,963 12,554
object queue header operation kcbw_unlink_q 0 364 11,288
object queue header operation kclobj_3 0 330 111
object queue header operation kcbw_link_q 0 108 3,650
object queue header operation kclobj_2 0 71 43
object queue header operation kcbo_switch_mq_bg 0 9 66
object queue header operation kcbo_switch_cq 0 8 88
object queue header operation kcbw_unlink_q_bg 0 6 32
object queue header operation kcbo_ivbo 0 4 4
object queue header operation kcbo_switch_q_bg 0 4 41
process allocation ksucrp 0 2 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 2 0
row cache objects kqreqd: reget 0 61 9
row cache objects ksucallcbksafely: kqrhngc 0 31 0
row cache objects kqrso 0 24 52
row cache objects kqrpre: find obj 0 21 170
row cache objects kqrigt 0 15 8
row cache objects kqrbip 0 12 107
row cache objects kqreqd 0 12 30
row cache objects kqrbgl 0 1 21
row cache objects kqrbtm: pop parent 0 1 16
row cache objects kqrsrd 0 1 13
session allocation ksucri 0 1 1
session allocation ksufap: active sessions 0 1 0
session idle bit ksupuc: set busy 0 67 14
session idle bit ksupuc: clear busy 0 23 75
shared pool kghalo 0 4,384 2,465
shared pool kghfrunp: alloc: wait 0 444 7
shared pool kghfrunp: clatch: nowait 0 308 0
shared pool kghupr1 0 246 1,057
shared pool kghfrunp: clatch: wait 0 58 35
shared pool kghfre 0 54 1,261
shared pool kgh_next_free 0 48 0
shared pool kghasp 0 44 70
shared pool kghalp 0 40 398
shared pool simulator kglsim_unpin_simhp 0 53 4
shared pool simulator kglsim_scan_lru: scan 0 4 25
shared pool simulator kglsim_unpin_simhp: fast path 0 1 25
simulator hash latch kcbsacc: lookup dba 0 4 7
simulator hash latch kcbs_lookup_setid: lookup dba 0 3 0
simulator hash latch kcbsacc: insert dba 0 1 0
slave class create ksvcreate 0 16 0
transaction allocation ktcxbr 0 3 3

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
MW_SYS MWS_SYS MWT_WF_WI   TABLE 921,123,248 40.28
MW_APP MWS_LP MWT_UD_LP_SHEETINDEX   TABLE 255,448,112 11.17
MW_APP MWS_SBD MWT_UD_SBD_YXGT   TABLE 103,984,576 4.55
MW_SYS MWS_SYS INDEX_MWT_PD_DEPS_SJBM   INDEX 102,374,272 4.48
MW_APP MWS_SBDYX MWT_UD_XDCCLJG   TABLE 51,334,928 2.24

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
MW_APP MWS_SBDYX MWT_UD_XDCCLJG   TABLE 9,208,944 17.70
MW_APP MWS_APP MWT_UD_PD_SB_RH_YXWZ   TABLE 6,084,685 11.70
MW_APP MWS_SBDYX MWT_UD_SBDYX_YXRZJL   TABLE 4,932,689 9.48
MW_APP MWS_SBDJX MWT_UD_SY_MPWB   TABLE 3,604,623 6.93
MW_SYS MWS_RTM MWT_OM_OBJ   TABLE 3,138,148 6.03

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
MW_SYS INDX PK_ATVI   INDEX 3,065 43.90
MW_SYS MWS_SYS PK_MWT_IS_VFILE   INDEX 1,351 19.35
MW_APP MWS_APP PK_SJBGJL_OBJ_ID   INDEX 962 13.78
MW_SYS INDX PK_PRCI   INDEX 468 6.70
MW_APP MWS_APP PK_MWT_UD_PERF_PARAM_HISTORY   INDEX 164 2.35

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
MW_APP MWS_APP IDX_MWT_UD_KW_SJBGJL_DXLX   INDEX 1 20.00
MW_SYS MWS_RTM MWT_ULOG_ID   INDEX 1 20.00
MW_SYS MWS_SYS PK_SQLPERF_ID   INDEX 1 20.00
SYS SYSAUX WRH$_JAVA_POOL_ADVICE_PK   INDEX 1 20.00
SYS SYSAUX WRH$_LATCH_PK 0213_34493 INDEX PARTITION 1 20.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
MW_APP MWS_APP PK_SJBGJL_OBJ_ID   INDEX 263 32.03
MW_APP MWS_APP PK_MWT_UD_PERF_PARAM_HISTORY   INDEX 179 21.80
MW_APP MWS_APP DK_PERF_PARAM_HISTORY_KPINAME   INDEX 130 15.83
MW_SYS MWS_SYS IC_MWT_RT_LOG_CREATETIME   INDEX 130 15.83
MW_SYS MWS_RTM PK_MWT_RT_LOG   INDEX 45 5.48

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
MW_APP MWS_APP MWT_UD_PD_SB_RH_YXWZ   TABLE 144,100 20.72
MW_APP MWS_SBDYX MWT_UD_XDCCLJG   TABLE 133,556 19.20
MW_APP MWS_LP MWT_UD_LP_SHEETINDEX   TABLE 115,888 16.66
MW_SYS MWS_SYS MWT_WF_WI   TABLE 103,102 14.82
MW_APP MWS_APP MWT_UD_JXGG_RKJH   TABLE 85,683 12.32

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
MW_APP MWS_APP MWT_UD_PERF_PARAM   TABLE 11,574 4.06
MW_SYS MWS_SYS MWT_WF_WI   TABLE 9,336 3.28
MW_APP MWS_LP MWT_UD_LP_SHEETINDEX   TABLE 8,575 3.01
MW_APP MWS_CBM PK_MWT_CBM_TSRZB   INDEX 8,447 2.97
MW_SYS MWS_SYS MWT_WF_ATVI   TABLE 5,755 2.02

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
MW_APP MWS_SBDYX MWT_UD_XDCCLJG   TABLE 11,622,150 31.47
MW_APP MWS_APP MWT_UD_JXGG_RKJH   TABLE 6,217,362 16.84
MW_APP MWS_APP MWT_UD_PD_SB_RH_YXWZ   TABLE 4,131,061 11.19
MW_APP MWS_LP MWT_UD_LP_SHEETINDEX   TABLE 2,135,166 5.78
MW_APP MWS_SBDJX MWT_UD_SY_MPWB   TABLE 2,115,968 5.73

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 1,018 4.52 0   18 1
dc_database_links 544 10.11 0   0 0
dc_files 7,620 45.00 0   0 0
dc_global_oids 17,447 10.96 0   0 8
dc_histogram_data 28,817,541 1.48 0   0 6,970
dc_histogram_defs 8,200,978 3.36 0   776 2,873
dc_object_grants 260,443 3.18 0   0 140
dc_object_ids 40,618,049 0.14 0   313 1,142
dc_objects 1,362,476 2.87 0   626 647
dc_profiles 408 13.24 0   0 1
dc_rollback_segments 1,254,052 0.00 0   0 2,210
dc_segments 7,397,835 1.04 0   127 1,263
dc_sequences 8,930 61.59 0   8,930 7
dc_table_scns 130 52.31 0   0 1
dc_tablespace_quotas 24 100.00 0   24 0
dc_tablespaces 8,841,925 0.01 0   0 16
dc_usernames 77,244 0.83 0   0 7
dc_users 11,763,649 0.01 0   2 48
outstanding_alerts 4,678 93.27 0   6 0

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 82 14 32
dc_database_links 55 0 56
dc_files 3,429 0 3,556
dc_global_oids 1,912 0 1,920
dc_histogram_defs 275,128 0 276,094
dc_object_ids 58,535 0 60,303
dc_objects 38,848 5 38,985
dc_profiles 54 0 54
dc_segments 77,102 98 76,878
dc_sequences 17,831 4,583 915
dc_table_scns 68 0 67
dc_tablespace_quotas 48 0 26
dc_tablespaces 1,081 0 1,089
dc_usernames 640 0 644
dc_users 760 0 758
outstanding_alerts 9,265 2,156 2,252

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 7,167 2.12 33,712 2.34 620 0
CLUSTER 2,423 3.55 5,279 3.09 77 0
INDEX 513 44.83 1,340 18.66 20 0
JAVA RESOURCE 12 91.67 12 91.67 0 0
JAVA SOURCE 12 91.67 12 100.00 1 0
SQL AREA 1,804,190 45.02 10,794,796 12.74 78,845 32,217
TABLE/PROCEDURE 321,576 5.01 3,995,887 4.40 84,781 0
TRIGGER 8,373 7.49 26,192 7.90 1,419 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 5,279 87 86 86 0
INDEX 1,340 230 232 230 0
JAVA RESOURCE 12 11 11 0 0
JAVA SOURCE 12 11 11 0 0
TABLE/PROCEDURE 1,327,279 13,276 13,577 9,518 0
TRIGGER 12 627 616 616 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 1,244.57   5.48 12.14 165 165 227 227
  Freeable 198.94 0.00 1.12 1.34 14   177 177
  SQL 30.03 14.48 0.14 0.29 2 383 210 205
  PL/SQL 7.20 4.76 0.03 0.08 1 2 225 225
E Other 1,305.21   5.42 12.16 165 165 241 241
  Freeable 198.50 0.00 1.04 1.30 14   190 190
  SQL 36.13 19.94 0.16 0.31 2 406 224 219
  PL/SQL 7.83 5.27 0.03 0.08 1 2 239 239

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 9,529,458,688  
Fixed Size 2,111,864  
Redo Buffers 14,663,680  
Variable Size 6,392,120,968  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 58.24 58.24 0.00
java joxlod exec hp 5.58 5.58 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared Cursor Stats 140.64 140.64 0.00
shared KGH: NO ACCESS 2,985.30 2,985.30 0.00
shared free memory 4,280.45 4,280.20 -0.01
shared gcs resources 203.63 203.63 0.00
shared gcs shadows 428.11 428.68 0.13
shared kglsim heap 106.71 106.71 0.00
shared kglsim object batch 188.03 188.03 0.00
streams free memory 31.98 31.98 0.00
  buffer_cache 9,088.00 9,088.00 0.00
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Coordinator 1,655,196 0 0
QMON Slaves 1,081,973 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 6 0 0 20 44

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 771,695 1,099,300 1145817 1145817
gcs_shadows 1,145,817 4,322,690 1145817 1145817


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /oracle/admin/pmssn/adump   
audit_trail DB_EXTENDED   
background_dump_dest /oracle/admin/pmssn/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.3.0   
control_files /dev/rcontrol1_128m, /dev/rcontrol2_128m, /dev/rcontrol3_128m   
core_dump_dest /oracle/admin/pmssn/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name pmssn   
dispatchers (PROTOCOL=TCP) (SERVICE=pmssnXDB)   
instance_number 1   
job_queue_processes 10   
local_listener (ADDRESS=(PROTOCOL=TCP)(HOST=10.208.15.15)(PORT=1521))   
log_archive_dest_1 location=/archlogpms1   
log_archive_dest_state_1 ENABLE   
log_archive_format arch1_%s_%R_%T.arc   
open_cursors 2000   
pga_aggregate_target 4066377728   
processes 2000   
recyclebin OFF   
remote_listener LISTENERS_PMSSN   
remote_login_passwordfile EXCLUSIVE   
service_names pmssn   
sessions 2205   
sga_max_size 15938355200   
sga_target 15737028608   
spfile /dev/rspfile_128m   
thread 1   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/admin/pmssn/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 166,168 2.88 0.48
acks for commit broadcast(logical) 258,247 4.48 0.75
broadcast msgs on commit(actual) 321,806 5.58 0.94
broadcast msgs on commit(logical) 322,569 5.60 0.94
broadcast msgs on commit(wasted) 44,093 0.77 0.13
broadcast on commit wait time(ms) 2,984 0.05 0.01
broadcast on commit waits 7,919 0.14 0.02
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 6,144 0.11 0.02
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 1 0.00 0.00
flow control messages sent 8 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 18,780,046 325.91 54.72
gcs ast xid 184 0.00 0.00
gcs blocked converts 192,601 3.34 0.56
gcs blocked cr converts 252,827 4.39 0.74
gcs compatible basts 11,272 0.20 0.03
gcs compatible cr basts (global) 23,978 0.42 0.07
gcs compatible cr basts (local) 37,225,559 646.01 108.47
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 49,188 0.85 0.14
gcs dbwr write request msgs 36,393 0.63 0.11
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 17,298 0.30 0.05
gcs immediate (null) converts 4,494,934 78.01 13.10
gcs immediate cr (compatible) converts 172,987 3.00 0.50
gcs immediate cr (null) converts 29,679,292 515.06 86.48
gcs indirect ast 1,191,851 20.68 3.47
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 11,662 0.20 0.03
gcs msgs process time(ms) 3,230,457 56.06 9.41
gcs msgs received 120,397,756 2,089.39 350.83
gcs out-of-order msgs 10 0.00 0.00
gcs pings refused 174,019 3.02 0.51
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 31 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 190 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 65 0.00 0.00
gcs side channel msgs actual 288,122 5.00 0.84
gcs side channel msgs logical 38,971,315 676.31 113.56
gcs stale cr 7,450 0.13 0.02
gcs undo cr 353 0.01 0.00
gcs write notification msgs 4,214 0.07 0.01
gcs writes refused 492 0.01 0.00
ges msgs process time(ms) 25,704 0.45 0.07
ges msgs received 1,941,407 33.69 5.66
global posts dropped 0 0.00 0.00
global posts queue time 41 0.00 0.00
global posts queued 6 0.00 0.00
global posts requested 6 0.00 0.00
global posts sent 6 0.00 0.00
implicit batch messages received 4,659,964 80.87 13.58
implicit batch messages sent 5,083,882 88.23 14.81
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 791,265 13.73 2.31
messages queue sent actual 9,678,832 167.97 28.20
messages queue sent logical 45,278,951 785.77 131.94
messages received actual 25,116,774 435.88 73.19
messages received logical 122,337,836 2,123.06 356.49
messages sent directly 6,381,526 110.75 18.60
messages sent indirectly 42,011,827 729.08 122.42
messages sent not implicit batched 4,594,976 79.74 13.39
messages sent pbatched 75,059,502 1,302.59 218.72
msgs causing lmd to send msgs 548,608 9.52 1.60
msgs causing lms(s) to send msgs 23,566,264 408.97 68.67
msgs received queue time (ms) 2,125,889 36.89 6.19
msgs received queued 122,339,100 2,123.08 356.49
msgs sent queue time (ms) 2,953,577 51.26 8.61
msgs sent queue time on ksxp (ms) 6,306,440 109.44 18.38
msgs sent queued 43,594,383 756.54 127.03
msgs sent queued on ksxp 24,992,792 433.73 72.83
process batch messages received 11,841,743 205.50 34.51
process batch messages sent 10,713,097 185.92 31.22


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 243,528
CURRENT Block Requests 16,847
Data Block Requests 243,528
Undo Block Requests 353
TX Block Requests 9,405
Current Results 258,937
Private results 13
Zero Results 681
Disk Read Results 0
Fail Results 0
Fairness Down Converts 42,510
Fairness Clears 0
Free GC Elements 0
Flushes 15,759
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 1,573
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 39,475,650 100.00 0.00 0.00 0.00 0.00
Flushes 3,161 39.54 59.70 0.76 0.00 0.00
Writes 55,852 2.68 61.87 35.26 0.02 0.17


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 236,086 92.80 7.16 0.04 36,915,125 99.24 0.01 0.75
2 undo header 39,311 99.67 0.29 0.04 2,209 99.23 0.72 0.05
2 Others 7,498 99.72 0.27 0.01 12,028 99.76 0.22 0.02
2 undo block 1,961 99.69 0.20 0.10 0      


Back to Top

End of Report