WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
NDMIS3941636119ndmis2210.2.0.5.0YESndora2

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2647127-Mar-13 16:30:171718 24.0
End Snap:2647227-Mar-13 17:01:4155 2.1
Elapsed:  31.40 (mins)  
DB Time:  5,144.56 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 22,832M 22,816MStd Block Size: 8K
Shared Pool Size: 3,696M 3,712MLog Buffer: 47,052K

Load Profile

Per SecondPer Transaction
Redo size: 32,764.15 8,961.78
Logical reads: 34,924.10 9,552.57
Block changes: 125.83 34.42
Physical reads: 225.12 61.58
Physical writes: 74.49 20.38
User calls: 728.27 199.20
Parses: 86.16 23.57
Hard parses: 7.37 2.01
Sorts: 65.50 17.92
Logons: 1.58 0.43
Executes: 780.75 213.55
Transactions: 3.66 

% Blocks changed per Read: 0.36Recursive Call %: 68.30
Rollback per transaction %: 8.74Rows per Sort: 145.52

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.53Redo NoWait %: 100.00
Buffer Hit %: 99.39In-memory Sort %: 100.00
Library Hit %: 96.79Soft Parse %: 91.45
Execute to Parse %: 88.96Latch Hit %: 98.73
Parse CPU to Parse Elapsd %: 0.77% Non-Parse CPU: 68.13

Shared Pool Statistics

BeginEnd
Memory Usage %: 68.03 66.12
% SQL with executions>1: 76.68 74.45
% Memory for SQL w/exec>1: 80.72 74.63

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
gc buffer busy 327,209 280,993 859 91.0Cluster
gc cr request 132,323 163,498 1,236 53.0Cluster
latch: library cache 309,683 87,793 283 28.4Concurrency
ges enter server mode 171,798 84,157 490 27.3Other
latch free 594,262 48,744 82 15.8Other

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 116.56 31.88
Global Cache blocks served: 114.66 31.36
GCS/GES messages received: 436.25 119.32
GCS/GES messages sent: 1,090.50 298.28
DBWR Fusion writes: 3.67 1.00
Estd Interconnect traffic (KB) 2,147.95 

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

Buffer access - local cache %: 99.06
Buffer access - remote cache %: 0.33
Buffer access - disk %: 0.61

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 177.6
Avg global cache cr block receive time (ms): 230.8
Avg global cache current block receive time (ms): 108.1
Avg global cache cr block build time (ms): 9.1
Avg global cache cr block send time (ms): 0.4
Global cache log flushes for cr blocks served %: 0.8
Avg global cache cr block flush time (ms): 317.9
Avg global cache current block pin time (ms): 8.1
Avg global cache current block send time (ms): 4.7
Global cache log flushes for current blocks served %: 0.1
Avg global cache current block flush time (ms): 223.3

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 15.1
Avg message sent queue time on ksxp (ms): 124.3
Avg message received queue time (ms): 6.9
Avg GCS message process time (ms): 3.3
Avg GES message process time (ms): 0.4
% of direct sent messages: 9.85
% of indirect sent messages: 88.32
% of flow controlled messages: 1.84


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 220,606.64 71.47
parse time elapsed 65,947.68 21.36
hard parse elapsed time 25,076.24 8.12
connection management call elapsed time 17,287.83 5.60
PL/SQL compilation elapsed time 7,957.08 2.58
PL/SQL execution elapsed time 5,984.34 1.94
hard parse (sharing criteria) elapsed time 3,254.32 1.05
hard parse (bind mismatch) elapsed time 2,654.58 0.86
DB CPU 1,351.66 0.44
failed parse elapsed time 527.29 0.17
repeated bind elapsed time 67.26 0.02
sequence load elapsed time 0.45 0.00
DB time 308,673.54  
background elapsed time 30,679.94  
background cpu time 152.51  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
Cluster 777,981 64 511,848 658 165.82
Other 17,480,207 2 185,781 11 60.19
Concurrency 2,263,783 51 179,814 79 58.25
Application 79,373 98 38,175 481 12.37
Commit 69,443 91 6,188 89 2.00
User I/O 180,946 0 2,049 11 0.66
CPU time     1,352   0.44
Network 1,669,888   1,327 1 0.43
Configuration 883 20 224 254 0.07
System I/O 37,800   37 1 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
gc buffer busy 327,209 93 280,993 859 47.50
gc cr request 132,323 100 163,498 1236 19.21
latch: library cache 309,683 0 87,793 283 44.96
ges enter server mode 171,798 100 84,157 490 24.94
latch free 594,262 0 48,744 82 86.27
enq: TX - row lock contention 78,294 99 38,154 487 11.37
latch: shared pool 111,725 0 30,693 275 16.22
gc current request 24,689 100 23,443 950 3.58
row cache lock 51,627 12 22,969 445 7.50
gc cr multi block request 111,771 12 18,061 162 16.23
latch: session allocation 53,724 0 15,455 288 7.80
gcs enter server mode 29,292 100 14,381 491 4.25
enq: TX - index contention 25,025 99 12,157 486 3.63
enq: US - contention 36,247 59 11,404 315 5.26
cursor: pin S wait on X 1,115,466 100 10,954 10 161.94
latch: row cache objects 33,396 0 9,252 277 4.85
log file sync 69,443 91 6,188 89 10.08
gc cr failure 3,191 99 3,948 1237 0.46
gc current block 2-way 68,525 3 3,946 58 9.95
gc current block congested 3,438 89 3,929 1143 0.50
latch: KCL gc element parent latch 13,976   3,151 225 2.03
gc current retry 3,454 99 3,047 882 0.50
gc cr block 2-way 26,455 7 2,868 108 3.84
gc cr block congested 2,367 90 2,749 1161 0.34
enq: CF - contention 4,402 99 2,723 619 0.64
latch: cache buffers chains 27,063   2,421 89 3.93
gc cr grant 2-way 58,920 2 1,974 33 8.55
latch: library cache lock 5,881 0 1,642 279 0.85
latch: gcs resource hash 6,647   1,522 229 0.97
gc current grant busy 6,528 30 1,485 227 0.95
gcs resource directory to be unfrozen 663 93 1,299 1959 0.10
db file sequential read 154,160   1,239 8 22.38
library cache lock 4,117 44 1,221 297 0.60
SQL*Net message from dblink 23,609   942 40 3.43
enq: JS - job recov lock 700 100 884 1263 0.10
gc cr grant congested 856 69 853 996 0.12
ges2 LMON to wake up lms - mrcvr 2 33,110 100 658 20 4.81
db file scattered read 19,093   648 34 2.77
gc current block busy 748 25 311 416 0.11
os thread startup 406 61 266 655 0.06
SQL*Net more data from client 7,588   263 35 1.10
enq: TH - metric threshold evaluation 90 98 262 2913 0.01
gc current grant 2-way 5,565 3 244 44 0.81
library cache load lock 236 23 237 1003 0.03
buffer busy waits 1,287 14 203 158 0.19
gc domain validation 112 91 200 1786 0.02
latch: object queue header operation 1,469 22 164 112 0.21
latch: cache buffers lru chain 1,100 5 164 149 0.16
latch: ges resource hash list 1,088   142 130 0.16
KJC: Wait for msg sends to complete 182 67 118 651 0.03
read by other session 1,819 3 118 65 0.26
gc current grant congested 117 66 116 989 0.02
SQL*Net message to client 1,298,645   109 0 188.54
enq: HW - contention 637 28 94 148 0.09
ges lmd/lmses to freeze in rcfg - mrcvr 8,107 95 78 10 1.18
checkpoint completed 32   74 2321 0.00
gc cr block busy 586 4 70 120 0.09
gc recovery quiesce 174 22 56 323 0.03
wait for scn ack 594 95 55 93 0.09
latch: redo writing 196   55 281 0.03
gcs log flush sync 3,116 46 49 16 0.45
ges LMD to inherit communication channels 497 96 47 94 0.07
db file parallel read 1,164   35 30 0.17
gc current multi block request 263 19 33 127 0.04
latch: messages 142 1 28 198 0.02
latch: redo allocation 181   26 144 0.03
rdbms ipc reply 1,573 1 26 17 0.23
inactive session 24 100 23 977 0.00
CSS initialization 17   22 1309 0.00
cursor: pin S 16,418,246   20 0 2,383.60
gc current split 31 45 20 641 0.00
DFS lock handle 863 4 19 22 0.13
PX Deq: Signal ACK 65 18 18 280 0.01
SQL*Net break/reset to client 371   16 42 0.05
db file parallel write 9,629   15 2 1.40
Streams AQ: qmn coordinator waiting for slave to start 3 67 12 4161 0.00
ges reconfiguration to start 650 96 12 18 0.09
control file sequential read 19,024   11 1 2.76
ksdxexeotherwait 983 100 10 10 0.14
SGA: allocation forcing component growth 918 99 9 10 0.13
ges generic event 883 100 9 10 0.13
SQL*Net more data from dblink 5,218   9 2 0.76
name-service call wait 134 1 9 64 0.02
PX Deq: Test for msg 356 0 8 23 0.05
reliable message 55 13 8 137 0.01
enq: TQ - INI contention 3 33 7 2339 0.00
latch: enqueue hash chains 115   7 59 0.02
library cache pin 715 0 7 9 0.10
LGWR wait for redo copy 888 71 6 7 0.13
latch: checkpoint queue latch 84   6 75 0.01
log file parallel write 8,559   6 1 1.24
cr request retry 13 100 6 451 0.00
ges LMON to get to FTDONE 281 92 5 19 0.04
SQL*Net more data to client 311,217   5 0 45.18
PX Deq Credit: send blkd 191 3 5 24 0.03
ges inquiry response 10 80 4 428 0.00
enq: TT - contention 99 3 4 42 0.01
Wait for Table Lock 4 100 4 977 0.00
direct path read 2,582   4 1 0.37
recovery read 48   4 74 0.01
direct path write temp 1,212   3 3 0.18
gc object scan 620 97 3 5 0.09
enq: WF - contention 19 26 3 142 0.00
wait for votes 91 100 3 29 0.01
direct path read temp 434   3 6 0.06
enq: TO - contention 42 5 3 61 0.01
enq: TM - contention 692 0 1 2 0.10
enq: PS - contention 99 2 1 13 0.01
latch: parallel query alloc buffer 107   1 11 0.02
wait for a undo record 244 0 1 4 0.04
CSS operation: data query 6   1 161 0.00
kksfbc child completion 17 100 1 49 0.00
enq: TX - contention 375   1 2 0.05
control file parallel write 478   1 1 0.07
CSS operation: action 361   1 2 0.05
cursor: mutex S 510,250   1 0 74.08
kjctssqmg: quick message send wait 285 98 1 2 0.04
ksxr poll remote instances 52,374 38 0 0 7.60
latch: cache buffer handles 41   0 10 0.01
enq: SQ - contention 17   0 24 0.00
enq: IR - contention 2   0 154 0.00
enq: PR - contention 4   0 73 0.00
CGS wait for IPC msg 31,354 99 0 0 4.55
gc current block unknown 25   0 9 0.00
log file sequential read 52   0 4 0.01
direct path write 482   0 0 0.07
cursor: mutex X 66,905   0 0 9.71
enq: FB - contention 32   0 3 0.00
global enqueue expand wait 12 83 0 8 0.00
SQL*Net break/reset to dblink 11   0 4 0.00
PX Deq: reap credit 2,434 98 0 0 0.35
buffer deadlock 3,696 100 0 0 0.54
wait for stopper event to be increased 1   0 22 0.00
SQL*Net message to dblink 23,592   0 0 3.43
ges2 LMON to wake up LMD - mrcvr 14   0 1 0.00
IPC send completion sync 16 100 0 0 0.00
CSS operation: query 2   0 3 0.00
gc claim 13   0 0 0.00
lock deadlock retry 439 100 0 0 0.06
log file single write 8   0 0 0.00
enq: RT - contention 2   0 0 0.00
enq: TA - contention 3   0 0 0.00
latch: library cache pin 1   0 1 0.00
enq: JQ - contention 1   0 1 0.00
enq: TX - allocate ITL entry 1   0 0 0.00
PX qref latch 286 78 0 0 0.04
gc cr disk read 1   0 0 0.00
SQL*Net more data to dblink 19   0 0 0.00
enq: PW - flush prewarm buffers 1   0 0 0.00
control file single write 1   0 0 0.00
enq: PG - contention 1   0 0 0.00
enq: PE - contention 1   0 0 0.00
ges lmd/lmses to unfreeze in rcfg - mrcvr 1   0 0 0.00
lock escalate retry 3 67 0 0 0.00
ges global resource directory to be frozen 1   0 0 0.00
Log archive I/O 1   0 0 0.00
SQL*Net message from client 1,300,860   1,521,772 1170 188.86
gcs remote message 1,066,663 71 23,538 22 154.86
PX Idle Wait 1,655 90 3,973 2400 0.24
virtual circuit status 64 100 1,875 29297 0.01
DIAG idle wait 7,631 1 1,509 198 1.11
Streams AQ: qmn slave idle wait 51 14 1,444 28308 0.01
Streams AQ: qmn coordinator idle wait 173 64 1,305 7544 0.03
PX Deq: Txn Recovery Start 820 64 1,286 1568 0.12
jobq slave wait 369 100 1,080 2927 0.05
ges remote message 437,342 65 933 2 63.49
Streams AQ: waiting for messages in the queue 137 93 612 4468 0.02
Streams AQ: waiting for time management or cleanup tasks 16 69 350 21898 0.00
class slave wait 61 89 266 4356 0.01
PX Deq: Join ACK 199 54 236 1187 0.03
PX Deq: Par Recov Execute 1,900 2 154 81 0.28
PX Deq: Execution Msg 126 48 126 998 0.02
PX Deq: Parse Reply 39 38 14 350 0.01
PX Deq: Par Recov Reply 86 5 7 85 0.01
PX Deq: Par Recov Change Vector 4,536   5 1 0.66
Streams AQ: RAC qmn coordinator idle wait 176 100 4 21 0.03
single-task message 7   0 32 0.00
PX Deq: Msg Fragment 26 8 0 1 0.00
PX Deq: Execute Reply 24 21 0 1 0.00
PX Deq Credit: need buffer 72   0 0 0.01

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 170,958 73 17,252 101 24.82
gc cr failure 863 99 1,087 1259 0.13
gc current retry 875 99 1,073 1226 0.13
latch: shared pool 3,103 17 733 236 0.45
latch: library cache 1,297 3 340 262 0.19
os thread startup 405 61 266 656 0.06
latch: row cache objects 831 1 214 257 0.12
row cache lock 1,340 2 102 76 0.19
gc domain validation 48 92 89 1861 0.01
latch: redo writing 196   55 281 0.03
latch: cache buffers chains 271   45 165 0.04
db file parallel write 9,586   15 2 1.39
gc cr block congested 9 78 12 1290 0.00
control file sequential read 18,831   11 1 2.73
library cache lock 149 13 11 76 0.02
buffer busy waits 20 55 11 549 0.00
gc cr multi block request 103 2 11 103 0.01
gc cr grant 2-way 200 4 10 49 0.03
db file sequential read 921   9 10 0.13
log file parallel write 8,555   6 1 1.24
gc current block congested 3 33 6 1938 0.00
gc current grant 2-way 95 4 5 52 0.01
db file scattered read 116   3 29 0.02
library cache pin 61 2 3 54 0.01
gc object scan 620 97 3 5 0.09
gc cr block 2-way 82   2 28 0.01
gc cr grant congested 2   1 689 0.00
enq: TM - contention 646 0 1 2 0.09
control file parallel write 479   1 1 0.07
gc current grant congested 1   0 445 0.00
latch: library cache lock 3 67 0 93 0.00
log file sequential read 52   0 4 0.01
enq: HW - contention 275   0 0 0.04
db file parallel read 6   0 15 0.00
log file single write 8   0 0 0.00
control file single write 1   0 0 0.00
Log archive I/O 1   0 0 0.00
gc buffer busy 1   0 0 0.00
gcs remote message 1,066,677 71 23,546 22 154.86
rdbms ipc message 93,157 25 19,159 206 13.52
DIAG idle wait 7,521   1,487 198 1.09
Streams AQ: qmn slave idle wait 47 13 1,387 29510 0.01
pmon timer 1,010 82 1,322 1308 0.15
Streams AQ: qmn coordinator idle wait 173 64 1,305 7544 0.03
smon timer 6 83 991 165137 0.00
ges remote message 437,294 65 934 2 63.49
Streams AQ: waiting for time management or cleanup tasks 16 69 350 21898 0.00
class slave wait 57 95 266 4662 0.01
PX Deq: Par Recov Reply 86 5 7 85 0.01
Streams AQ: RAC qmn coordinator idle wait 176 100 4 21 0.03
PX Deq: Join ACK 67   0 1 0.01
PX Deq Credit: need buffer 72   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 5,947
AVG_IDLE_TIME 185,594
AVG_IOWAIT_TIME 32,069
AVG_SYS_TIME 2,388
AVG_USER_TIME 3,536
BUSY_TIME 381,928
IDLE_TIME 11,879,510
IOWAIT_TIME 2,053,835
SYS_TIME 154,013
USER_TIME 227,915
LOAD 29
OS_CPU_WAIT_TIME 1,583,300
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 834,916,352
VM_OUT_BYTES 5,303,087,104
PHYSICAL_MEMORY_BYTES 66,571,993,088
NUM_CPUS 64
NUM_CPU_CORES 32

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
ndmis 302,620.30 1,348.60 403,136 66,116,454
SYS$USERS 5,806.00 3.20 10,588 30,666
SYS$BACKGROUND 4.30 0.10 8,661 122,566
nd_mis 0.00 0.00 0 0
ndmisXDB 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
ndmis 177408 2007 2205924 165081 0 0 1654901 1073
SYS$USERS 1455 24 2936 597 0 0 866 0
SYS$BACKGROUND 2067 17 12436 1759 0 0 0 0
nd_mis 0 0 0 0 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
39,982 3 998 40.06 12.95 fgu2g3jt27ka4 JDBC Thin Client select count(1) from indy_onli...
17,211 75 1,107 15.55 5.58 483awj0kbnfqr JDBC Thin Client declare linkid varchar2(128); ...
13,725 11 711 19.30 4.45 0ptxn6whczpaj JDBC Thin Client begin insert into indy_online_...
13,469 4 1,110 12.13 4.36 7q0mrfy5py47y JDBC Thin Client INSERT INTO INDY_USE_LOG(LOG_I...
13,199 7 711 18.56 4.28 fcgwwxtw17p55 JDBC Thin Client INSERT INTO INDY_ONLINE_USER(L...
4,925 171 772 6.38 1.60 f3zd7grha43by JDBC Thin Client select count(1) from indy_onli...
3,674 74 1,052 3.49 1.19 ff40ndudptw4c JDBC Thin Client DELETE FROM INDY_ONLINE_USER W...
3,415 0 37 92.30 1.11 4bm46js67ss7t JDBC Thin Client update ol$_objects set D_03 = ...
3,110 0 7 444.32 1.01 f1ypmrqprt2j2 JDBC Thin Client update ol$_objects set S_15 = ...
3,042 2 1,129 2.69 0.99 cjz46bvt9kd0t JDBC Thin Client INSERT INTO OL$_OBJECTS (OBJ_I...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total% Total DB Time SQL IdSQL ModuleSQL Text
171 4,925 772 0.22 12.68 1.60 f3zd7grha43by JDBC Thin Client select count(1) from indy_onli...
75 17,211 1,107 0.07 5.58 5.58 483awj0kbnfqr JDBC Thin Client declare linkid varchar2(128); ...
74 3,674 1,052 0.07 5.48 1.19 ff40ndudptw4c JDBC Thin Client DELETE FROM INDY_ONLINE_USER W...
63 262 31,462 0.00 4.69 0.08 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
29 2,716 1,165 0.03 2.17 0.88 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
24 233 1,205 0.02 1.78 0.08 5wfhpq886xacr JDBC Thin Client SELECT /*+index(t, NK_OL$_REFS...
19 1,745 3,587 0.01 1.42 0.57 a41yvpfth003x JDBC Thin Client select * from v$_ST_Equipment ...
12 1,103 51 0.23 0.86 0.36 dbgctn9f6071v JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
11 28 2 5.71 0.84 0.01 2jbjm1m7dstzs JDBC Thin Client SELECT * FROM sgpm.o_org WHERE...
11 29 69 0.16 0.84 0.01 awvtdy3vc6fum JDBC Thin Client SELECT codeId, codeSortId, par...

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
9,945,902 31,462 316.12 15.12 63.35 261.75 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
8,824,930 1,165 7,575.05 13.41 29.30 2716.16 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
8,540,809 1,205 7,087.81 12.98 24.01 232.96 5wfhpq886xacr JDBC Thin Client SELECT /*+index(t, NK_OL$_REFS...
7,229,488 106,458 67.91 10.99 10.65 36.76 fc42s7rxq7chg JDBC Thin Client SELECT CLS_URI FROM OL$_CLASSE...
3,481,466 69 50,456.03 5.29 11.36 28.71 awvtdy3vc6fum JDBC Thin Client SELECT codeId, codeSortId, par...
1,716,033 942 1,821.69 2.61 4.91 817.99 bsm6gmajgmhuu JDBC Thin Client select * from indy_menu where ...
1,393,116 20,485 68.01 2.12 3.58 28.91 1gcnmuw9xtb3k JDBC Thin Client SELECT CLS_URI FROM OL$_CLASSE...
1,288,250 1 1,288,250.00 1.96 9.07 278.79 7hg004b3d9kkg JDBC Thin Client select b.name deptName, a.USER...
923,160 59 15,646.78 1.40 5.85 1223.80 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
764,279 1,461 523.12 1.16 2.21 968.66 450w20twk6ku5 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKNAMEM...
751,342 419 1,793.18 1.14 2.17 157.94 avjzuwm5npxv7 JDBC Thin Client select * from indy_menu where ...
750,044 91 8,242.24 1.14 4.84 1497.10 7xn6xppmpg9u7 JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
709,255 3 236,418.33 1.08 3.24 306.04 0k5gsd7bnr1wr JDBC Thin Client select b.workingBeginDateMin, ...
690,873 612 1,128.88 1.05 2.72 2189.32 g0mmxhhfz1q9g JDBC Thin Client select * from v$_LowArea where...

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
76,785 1 76,785.00 18.10 8.73 515.40 3dkx4wzwqd49x JDBC Thin Client SELECT PROCESSID, SW_PROCESSID...
48,656 82 593.37 11.47 7.15 1935.01 4ydgzsjh9kb57 JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
28,159 4 7,039.75 6.64 9.57 27.15 0jat7ccc9fvct JDBC Thin Client Select Pc.Obj_Id, Pc.Cls_Uri, ...
17,003 19 894.89 4.01 9.94 2316.21 598k07tzg7tud JDBC Thin Client Select Ass.Obj_Id, ass.CLS_URI...
5,748 59 97.42 1.36 5.85 1223.80 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
5,334 91 58.62 1.26 4.84 1497.10 7xn6xppmpg9u7 JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
5,329 14 380.64 1.26 7.63 431.93 5nnxqj41g9xk6 JDBC Thin Client Select Pc.Obj_Id, Pc.Cls_Uri, ...
3,449 1,557 2.22 0.81 1.84 1859.30 9yyb7wvndk114 JDBC Thin Client select * from v$_ST_DYLine whe...
3,368 612 5.50 0.79 2.72 2189.32 g0mmxhhfz1q9g JDBC Thin Client select * from v$_LowArea where...
3,087 110 28.06 0.73 1.32 275.36 1r7mjtz9kp72t JDBC Thin Client select * from (select /*+rule*...

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
122,146 121,974 1.00 0.00 0.00 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
106,458 106,256 1.00 0.00 0.00 fc42s7rxq7chg JDBC Thin Client SELECT CLS_URI FROM OL$_CLASSE...
31,462 31,344 1.00 0.00 0.01 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
20,485 20,486 1.00 0.00 0.00 1gcnmuw9xtb3k JDBC Thin Client SELECT CLS_URI FROM OL$_CLASSE...
18,507 16,747 0.90 0.00 0.00 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
16,962 33,139 1.95 0.00 0.01 cfrwbnuu2xtam JDBC Thin Client select side_b from ol$_associa...
16,906 16,894 1.00 0.00 0.11 g4rzpg6rj116d JDBC Thin Client BEGIN OL$_RULE_CORE.SETSTRATTR...
15,841 15,794 1.00 0.00 0.08 bunvx480ynf57 JDBC Thin Client SELECT 1 FROM DUAL
8,932 8,932 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
6,729 6,728 1.00 0.00 0.01 7gfjbwmcxjx9s JDBC Thin Client SELECT COUNT(*) FROM OL$_OBJEC...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
8,932 8,932 5.50 2ym6hhaq30r73   select type#, blocks, extents,...
6,149 6,152 3.79 grwydz59pu6mc   select text from view$ where r...
5,217 5,231 3.21 0h6b2sajwb74n   select privilege#, level from ...
3,174 3,174 1.96 1cjy8v3c0agny   select sys_nc_oid$ from xdb.xd...
2,445 2,450 1.51 3pxuuh0sx2sqx   Begin Dbms_Application_Info.Se...
2,435 2,478 1.50 0k8522rmdzg4k   select privilege# from sysauth...
2,401 2,457 1.48 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
2,394 2,471 1.47 459f3z9u4fb3u   select value$ from props$ wher...
2,383 2,430 1.47 5ur69atw3vfhj   select decode(failover_method,...
2,086 15,841 1.29 bunvx480ynf57 JDBC Thin Client SELECT 1 FROM DUAL
1,936 2,824 1.19 449xyhjkn7apn JDBC Thin Client select * from v$_ST_EquipmentC...
1,921 2,500 1.18 d3gsxy5k0u8hw JDBC Thin Client select * from v$_ST_Asset wher...
1,914 5,848 1.18 8b9zc43w360qt JDBC Thin Client SELECT O_28 partitionField FRO...
1,827 3,587 1.13 a41yvpfth003x JDBC Thin Client select * from v$_ST_Equipment ...
1,785 4,457 1.10 02djppxs4a73n JDBC Thin Client update ol$_locks t set t.obj =...
1,676 6,644 1.03 7xgzx0zrnt0fc JDBC Thin Client select /*+ index(o PK_OL$_OBJE...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,355,817 3 0.03 f5yun5dynkskv plsqldev.exe select s.synonym_name as obje...
1,154,013 18 0.03 f8uvk4ymbh19z JDBC Thin Client SELECT NAME, TYPE, ACTION_URL,...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
540 1,113 dczy7gkm3mpax JDBC Thin Client update ol$_objects set S_04 = ...
540 1,113 dczy7gkm3mpax JDBC Thin Client update ol$_objects set S_04 = ...
428 8,932 2ym6hhaq30r73   select type#, blocks, extents,...
312 82 48hzu5y6ztvb8 JDBC Thin Client update ol$_objects set O_04 = ...
312 82 48hzu5y6ztvb8 JDBC Thin Client update ol$_objects set O_04 = ...
284 18,507 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
220 30 27znnd1xfzpnp JDBC Thin Client update ol$_objects set S_63 = ...
220 30 27znnd1xfzpnp JDBC Thin Client update ol$_objects set S_63 = ...
209 414 czxzy970jq50g JDBC Thin Client update ol$_objects set S_27 = ...
209 414 czxzy970jq50g JDBC Thin Client update ol$_objects set S_27 = ...
199 53 2mah5fag4pzzv JDBC Thin Client update ol$_objects set O_05 = ...
199 53 2mah5fag4pzzv JDBC Thin Client update ol$_objects set O_05 = ...
175 56 1ks9z4mvpjt33 JDBC Thin Client update ol$_objects set D_03 = ...
175 56 1ks9z4mvpjt33 JDBC Thin Client update ol$_objects set D_03 = ...
173 1,333 04xtrk7uyhknh   select obj#, type#, ctime, mti...
142 100 4bzh761vk20q0 JDBC Thin Client update ol$_objects set D_07 = ...
142 100 4bzh761vk20q0 JDBC Thin Client update ol$_objects set D_07 = ...
135 1 c4zp1p9yb7brg JDBC Thin Client update ol$_objects set S_63 = ...
134 6,152 grwydz59pu6mc   select text from view$ where r...
111 8 1nbxgk51xtn9p JDBC Thin Client update ol$_objects set S_63 = ...
111 8 1nbxgk51xtn9p JDBC Thin Client update ol$_objects set S_63 = ...
93 2,430 5ur69atw3vfhj   select decode(failover_method,...
89 122,146 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
68 86 5f4yasqwng66g JDBC Thin Client update ol$_objects set N_52 = ...
68 86 5f4yasqwng66g JDBC Thin Client update ol$_objects set N_52 = ...
63 25 41wp41sp2ns44 JDBC Thin Client SELECT TASKID FROM WF_TASK WHE...
50 27 91hakq9n36htp JDBC Thin Client SELECT TEXT_VALUE FROM WF_ITEM...
45 711 0ptxn6whczpaj JDBC Thin Client begin insert into indy_online_...
45 748 26sr8u5xavn56 JDBC Thin Client SELECT CLS_VIEW FROM OL$_CLASS...
44 40 02upj301bbpz7 JDBC Thin Client update ol$_objects set S_63 = ...
44 40 02upj301bbpz7 JDBC Thin Client update ol$_objects set S_63 = ...
40 1,165 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
38 9 2p70njsc3jdvy JDBC Thin Client DELETE FROM SGPM.P_TASK_ASSIGN...
37 1,107 483awj0kbnfqr JDBC Thin Client declare linkid varchar2(128); ...
37 9 fbg5fqdjsvbw9 JDBC Thin Client DELETE INDYWF_WORKLIST_COM WHE...
37 9 fbg5fqdjsvbw9 JDBC Thin Client DELETE INDYWF_WORKLIST_COM WHE...
36 68 dh48uzmwms409 JDBC Thin Client update ol$_objects set D_03 = ...
36 68 dh48uzmwms409 JDBC Thin Client update ol$_objects set D_03 = ...
36 16,906 g4rzpg6rj116d JDBC Thin Client BEGIN OL$_RULE_CORE.SETSTRATTR...
35 419 avjzuwm5npxv7 JDBC Thin Client select * from indy_menu where ...
34 1,461 450w20twk6ku5 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKNAMEM...
34 711 fcgwwxtw17p55 JDBC Thin Client INSERT INTO INDY_ONLINE_USER(L...
32 9 80hn6zhb2zpf4 JDBC Thin Client DELETE FROM OWF_MGR.WF_NOTIFIC...
32 772 f3zd7grha43by JDBC Thin Client select count(1) from indy_onli...
31 1,052 ff40ndudptw4c JDBC Thin Client DELETE FROM INDY_ONLINE_USER W...
31 9 gtfzp7x4sg6xu JDBC Thin Client DELETE FROM OWF_MGR.WF_ITEM_AC...
30 18 6229274rb7bpc JDBC Thin Client SELECT * FROM (SELECT row_.*, ...
30 9 9trfmfyhqpm5p JDBC Thin Client UPDATE INDYWF_INSTANCES_CUR SE...
29 379 218prcturdt25 JDBC Thin Client DELETE FROM p_task WHERE task_...
29 16,962 cfrwbnuu2xtam JDBC Thin Client select side_b from ol$_associa...
29 2,549 dnctudjagb520 JDBC Thin Client select * from v$_ST_AssetModel...
29 9 g7sx2r79bnt4v JDBC Thin Client INSERT INTO INDYWF_WORKLIST_HI...
28 5,231 0h6b2sajwb74n   select privilege#, level from ...
27 2,500 d3gsxy5k0u8hw JDBC Thin Client select * from v$_ST_Asset wher...
27 17 ggak0dvtsppv3 JDBC Thin Client SELECT /*+ leading(wias) index...
26 100 8d3y3sqaj9f3s JDBC Thin Client SELECT * FROM (SELECT row_.*, ...
26 100 8d3y3sqaj9f3s JDBC Thin Client SELECT * FROM (SELECT row_.*, ...
25 703 d7qa0bq22h0p3 JDBC Thin Client SELECT A FROM OL$_ASSOCIATIONS...
25 612 g0mmxhhfz1q9g JDBC Thin Client select * from v$_LowArea where...
24 2,478 0k8522rmdzg4k   select privilege# from sysauth...
24 1,921 1f5c885f3vvfx JDBC Thin Client select /*+ index(v$_ST_Asset I...
24 2,824 449xyhjkn7apn JDBC Thin Client select * from v$_ST_EquipmentC...
23 45 8rdg2n7g8ftk3 JDBC Thin Client update ol$_objects set O_10 = ...
23 45 8rdg2n7g8ftk3 JDBC Thin Client update ol$_objects set O_10 = ...
23 998 fgu2g3jt27ka4 JDBC Thin Client select count(1) from indy_onli...

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
38,429.33 96.12 39,981.80 2.67 998 fgu2g3jt27ka4 JDBC Thin Client select count(1) from indy_onli...
7,414.22 43.08 17,211.23 75.39 1,107 483awj0kbnfqr JDBC Thin Client declare linkid varchar2(128); ...
6,331.40 47.01 13,468.78 3.57 1,110 7q0mrfy5py47y JDBC Thin Client INSERT INTO INDY_USE_LOG(LOG_I...
2,462.99 98.63 2,497.15 0.10 30 573u87gdj8xm1 JDBC Thin Client SELECT COUNT(*) CUN FROM T_WT_...
2,360.45 47.93 4,924.65 171.45 772 f3zd7grha43by JDBC Thin Client select count(1) from indy_onli...
1,851.01 76.78 2,410.80 1.30 8 g8w9fba2jp4ph JDBC Thin Client select * from st_institution_r...
1,696.45 79.30 2,139.16 0.59 342 fgyb29rrzf9jf JDBC Thin Client insert into P_TASK( TASK_ID , ...
1,675.54 78.87 2,124.38 3.98 354 93dtuy0vt2k7q JDBC Thin Client SELECT task_id FROM p_task WHE...
1,443.62 85.06 1,697.22 0.83 2,500 d3gsxy5k0u8hw JDBC Thin Client select * from v$_ST_Asset wher...
1,134.73 65.03 1,745.02 19.15 3,587 a41yvpfth003x JDBC Thin Client select * from v$_ST_Equipment ...
1,122.32 60.36 1,859.30 1.84 1,557 9yyb7wvndk114 JDBC Thin Client select * from v$_ST_DYLine whe...
1,073.10 29.21 3,673.95 74.02 1,052 ff40ndudptw4c JDBC Thin Client DELETE FROM INDY_ONLINE_USER W...
1,034.76 47.26 2,189.32 2.72 612 g0mmxhhfz1q9g JDBC Thin Client select * from v$_LowArea where...
924.16 90.72 1,018.72 0.77 40 7wgzpzkd96b4p JDBC Thin Client SELECT n.id id, n.name name, n...
807.22 32.83 2,458.64 0.60 379 218prcturdt25 JDBC Thin Client DELETE FROM p_task WHERE task_...
745.06 5.64 13,199.36 7.07 711 fcgwwxtw17p55 JDBC Thin Client INSERT INTO INDY_ONLINE_USER(L...
745.06 5.43 13,725.46 11.00 711 0ptxn6whczpaj JDBC Thin Client begin insert into indy_online_...
644.94 78.84 817.99 4.91 942 bsm6gmajgmhuu JDBC Thin Client select * from indy_menu where ...
568.06 18.68 3,041.67 1.68 1,129 cjz46bvt9kd0t JDBC Thin Client INSERT INTO OL$_OBJECTS (OBJ_I...
552.03 28.53 1,935.01 7.15 82 4ydgzsjh9kb57 JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
469.42 61.18 767.31 7.29 2,824 449xyhjkn7apn JDBC Thin Client select * from v$_ST_EquipmentC...
359.37 24.00 1,497.10 4.84 91 7xn6xppmpg9u7 JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
339.14 35.01 968.66 2.21 1,461 450w20twk6ku5 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKNAMEM...
333.25 14.31 2,328.67 0.26 136 5z8x0pna8fk4a JDBC Thin Client DELETE FROM OL$_ASSOCIATIONS T...
333.25 13.35 2,495.86 0.50 136 cm7kjhuwrrq3g JDBC Thin Client begin begin OL$_Core.DeleteAss...
300.13 27.21 1,102.86 11.58 51 dbgctn9f6071v JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
295.09 76.24 387.07 0.15 1,810 0cxypy0hx9g11 JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
235.52 76.61 307.41 0.76 7 7vzpyu7p1t79j JDBC Thin Client select APPLY_ID, APPLY_CD, APP...
221.10 25.00 884.35 1.30 5,848 8b9zc43w360qt JDBC Thin Client SELECT O_28 partitionField FRO...
217.91 96.59 225.60 0.08 1 4bqz0z7vq1k3j JDBC Thin Client SELECT ORGID ORG_NO, ORGNAME O...
212.83 17.39 1,223.80 5.85 59 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
202.34 7.45 2,716.16 29.30 1,165 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
178.01 34.54 515.40 8.73 1 3dkx4wzwqd49x JDBC Thin Client SELECT PROCESSID, SW_PROCESSID...
177.78 64.56 275.36 1.32 110 1r7mjtz9kp72t JDBC Thin Client select * from (select /*+rule*...
128.21 55.04 232.96 24.01 1,205 5wfhpq886xacr JDBC Thin Client SELECT /*+index(t, NK_OL$_REFS...
88.92 5.36 1,658.20 0.30 150 5ursqxfwnrz2m JDBC Thin Client insert into olive.ol$_event_lo...
68.51 36.78 186.24 0.53 1,113 dczy7gkm3mpax JDBC Thin Client update ol$_objects set S_04 = ...
62.58 14.49 431.93 7.63 14 5nnxqj41g9xk6 JDBC Thin Client Select Pc.Obj_Id, Pc.Cls_Uri, ...
57.92 40.36 143.50 0.32 1,921 1f5c885f3vvfx JDBC Thin Client select /*+ index(v$_ST_Asset I...
41.16 1.78 2,316.21 9.94 19 598k07tzg7tud JDBC Thin Client Select Ass.Obj_Id, ass.CLS_URI...
38.64 59.69 64.74 1.03 122,146 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
37.72 55.06 68.52 0.09 4,537 6pcrpqf5dkunf JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
35.13 12.07 291.11 0.48 1,571 95jvxjj84rcct JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
34.58 30.24 114.38 0.86 65 9vrbr3jjprusn JDBC Thin Client SELECT B OBJ_ID, (SELECT S_01 ...
31.33 21.16 148.12 0.26 2 bvnkf18n91h4q JDBC Thin Client select a.line_id, a.line_name,...
31.18 22.34 139.53 0.19 100 8d3y3sqaj9f3s JDBC Thin Client SELECT * FROM (SELECT row_.*, ...
31.13 26.87 115.87 0.11 6,644 7xgzx0zrnt0fc JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
28.36 9.27 306.04 3.24 3 0k5gsd7bnr1wr JDBC Thin Client select b.workingBeginDateMin, ...
28.28 51.68 54.71 0.18 100 4bzh761vk20q0 JDBC Thin Client update ol$_objects set D_07 = ...
23.78 15.06 157.94 2.17 419 avjzuwm5npxv7 JDBC Thin Client select * from indy_menu where ...
23.15 1.35 1,719.21 0.52 288 a1ymvq7wx3y4v JDBC Thin Client UPDATE V$_ST_IDENTIFIEDOBJECT ...
18.00 21.77 82.70 0.17 18,507 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
16.97 0.97 1,741.39 0.51 40 02upj301bbpz7 JDBC Thin Client update ol$_objects set S_63 = ...
14.92 1.04 1,431.13 0.19 54 g8mb1ky69dcp6 JDBC Thin Client update ol$_objects set N_42 = ...
13.74 20.49 67.07 0.53 46 9rn5ah9npmbc8 JDBC Thin Client WITH CLS_LIST AS (SELECT (SELE...
12.34 33.14 37.23 5.86 6,729 7gfjbwmcxjx9s JDBC Thin Client SELECT COUNT(*) FROM OL$_OBJEC...
8.30 8.94 92.83 0.17 18 6229274rb7bpc JDBC Thin Client SELECT * FROM (SELECT row_.*, ...
7.42 34.33 21.60 0.25 703 d7qa0bq22h0p3 JDBC Thin Client SELECT A FROM OL$_ASSOCIATIONS...
7.16 84.56 8.46 0.06 53 2mah5fag4pzzv JDBC Thin Client update ol$_objects set O_05 = ...
6.72 83.17 8.08 0.03 2 6mv6h2kff55p2 JDBC Thin Client select distinct k.org_name, t....
5.84 11.49 50.85 0.12 2,549 dnctudjagb520 JDBC Thin Client select * from v$_ST_AssetModel...
5.06 62.16 8.14 0.05 30 27znnd1xfzpnp JDBC Thin Client update ol$_objects set S_63 = ...
4.09 1.29 317.43 2.48 2,699 b0mb9f2wdgnrk JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
4.06 19.32 21.01 2.87 82 48hzu5y6ztvb8 JDBC Thin Client update ol$_objects set O_04 = ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
02djppxs4a73nupdate ol$_locks t set t.obj = null
02upj301bbpz7update ol$_objects set S_63 = :S_63, D_03 = :D_03, N_42 = :N_42 where obj_id = :objId
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
0cxypy0hx9g11select /*+ index(o PK_OL$_OBJECTS) */ * from v$_FamilyLine o where obj_id=:1
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0jat7ccc9fvct Select Pc.Obj_Id, Pc.Cls_Uri, Pc.Voltagelevel, Pc.Pathname, Ass.Obj_Id Assetid, Ass.Name Assetname, Ass.Cls_Uri Asseturi, Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) Assetnamepath, c.Cls_Uri Clsuri, c.Cls_Disp_Name, Ass.Assetsstatus, Ass.Manufacturer, Ass.Sbxh, Ass.Inservicedate, Ass.Code From V$_St_Powersystemresource Pp, V$_St_Powersystemresource Pc, Ol$_Associations a, V$_St_Asset Ass, Ol$_Classes c Where Pc.Pathname Like Pp.Pathname || '%' And Ass.Pathname Like '\' || a.b || '%' And Pp.Obj_Id =:1 And Pc.Obj_Id = a.a And Ass.Cls_Uri = c.Cls_Uri And a.Ast_Uri = 'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"' and Pc.orgId=:2 and Ass.orgId=Pc.orgId and ass.Assetsstatus in( 'S', 'W') and ass.CLS_URI in( 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_AssetContainer/ST_Structure/ST_Pole', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/ST_OHConductorAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_EarthWire/OHEarthWireAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/ST_CableAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_Terminal', 'OLCLASS://Entity/ST_Identifie dObject/ST_Asset/ST_ElectricalAsset/IntermediateConnectortAsset')
0k5gsd7bnr1wrselect b.workingBeginDateMin, b.workingEndDateMax , a.delay_begin_date, a.delay_end_date from v_powercut_apply_query a, ( select min(t.WORKING_BEGIN_DATE) workingBeginDateMin, max(t.WORKING_END_DATE ) workingEndDateMax from v_powercut_apply_query t where t.actionname in('EXECUTE', 'OVER') and t.ORG_NO= :1 and t.week_plan_cd= :2 ) b where a.WORKING_END_DATE=b.workingEndDateMax
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ptxn6whczpajbegin insert into indy_online_user(log_id, log_link_id, log_user_id, log_person_id, log_web_path, log_server_path, log_logon_time, log_machine_ip, log_machine_name) values(:1, :2, :3, :4, :5, :6, sysdate, :7, :8); end;
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1cjy8v3c0agnyselect sys_nc_oid$ from xdb.xdb$resource where rowid = :1
1f5c885f3vvfxselect /*+ index(v$_ST_Asset IDX_OL$_OBJECTS_CLS_PATHNAME) */ v$_ST_Asset.* from v$_ST_Asset where orgId = :1 and ( (ASSETSSTATUS = :2 OR ASSETSSTATUS = :3) and pathName like :4 ) order by pathName
1gcnmuw9xtb3kSELECT CLS_URI FROM OL$_CLASSES WHERE CLS_ID = SUBSTR(:B1 , 1, 32)
1ks9z4mvpjt33update ol$_objects set D_03 = :D_03, O_04 = :O_04 where obj_id = :objId
1nbxgk51xtn9pupdate ol$_objects set S_63 = :S_63, N_42 = :N_42 where obj_id = :objId
1r7mjtz9kp72t select * from (select /*+rule*/ p.OBJ_ID as id, p.NAME as psrName, OL$_OBJECT_UTIL.GETPARENTID(P.PATHNAME) as parentID, p.cls_uri as psrGroupID, '' as attemperNumber, p.VOLTAGELEVEL AS VOLTAGELEVEL, c.cls_disp_name AS psrGroupName, 0 as lpsequence from olive.v$_st_powersystemresource p, olive.ol$_classes c where p.PATHNAME like (select pathname from olive.v$_lowarea l where l.ORGID = :1 and l.OBJ_ID =:2) || '%' and orgid = :3 and p.CLS_URI <>'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_Station/DYCableBox' and p.CLS_URI <>'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/DYPolePosition' AND p.RESOURCESTATUS <> 'I' and p.CLS_URI = c.cls_uri union all select /*+rule*/ dp.OBJ_ID as id, dp.NAME as psrName, OL$_OBJECT_UTIL.GETPARENTID(dP.PATHNAME) as parentID, dp.cls_uri as psrGroupID, '' as attemperNumber, dp.VOLTAGELEVEL AS VOLTAGELEVEL, c.cls_disp_name AS psrGroupName, dp.LPSEQUENCE from olive.v$_dypoleposition dp, olive.ol$_classes c where dp.PATHNAME like (select pathname from olive.v$_lowarea l where l.ORGID = :4 and l.OBJ_ID = :5) || '%' and orgid = :6 AND dp.RESOURCESTATUS <> 'I' and dp.CLS_URI = c.cls_uri union all select /*+rule*/ mb.OBJ_ID as id, mb.NAME as psrName, OL$_OBJECT_UTIL.GETPARENTID(mb.PATHNAME) as parentID, mb.cls_uri as psrGroupID, '' as attemperNumber, mb.VOLTAGELEVEL AS VOLTAGELEVEL, c.cls_disp_name AS psrGroupName, mb.LPSEQUENCE from olive.v$_dycab lebox mb, olive.ol$_classes c where mb.PATHNAME like (select pathname from olive.v$_lowarea l where l.ORGID = :7 and l.OBJ_ID = :8) || '%' and orgid = :9 AND mb.RESOURCESTATUS <> 'I' and mb.CLS_URI = c.cls_uri) order by lpsequence
218prcturdt25DELETE FROM p_task WHERE task_id = :1
26sr8u5xavn56SELECT CLS_VIEW FROM OL$_CLASSES WHERE CLS_URI = :B1
27znnd1xfzpnpupdate ol$_objects set S_63 = :S_63, D_03 = :D_03, N_42 = :N_42, S_01 = :S_01 where obj_id = :objId
2jbjm1m7dstzsSELECT * FROM sgpm.o_org WHERE org_no='¶¨ÐËÏØ»Æ½ð̨'
2mah5fag4pzzvupdate ol$_objects set O_05 = :O_05, D_03 = :D_03 where obj_id = :objId
2p70njsc3jdvyDELETE FROM SGPM.P_TASK_ASSIGN A WHERE A.APP_NO = :B1
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
3dkx4wzwqd49xSELECT PROCESSID, SW_PROCESSID, KB_CD, KB_CONTENT, KB_TYPE, KB_P_TYPE_ID, ANNOUNCEMENTS, TOOL_NAME, TOOLITEM_TYPE, TOOL_UNIT, MATERIALS_ABC, STANDARDPRICE, TOOL_UNIT_ID FROM PMS.T_SW_KB_CONTENT WHERE 1=1 order by to_number(KB_CD)
3pxuuh0sx2sqxBegin Dbms_Application_Info.Set_Client_Info(Sys_Context('userenv', 'ip_address')); End;
41wp41sp2ns44SELECT TASKID FROM WF_TASK WHERE ITEM_TYPE=:B2 AND ITEM_KEY=:B1
449xyhjkn7apnselect * from v$_ST_EquipmentCategory where ( orgId = :1 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :2 and ol$_associations.a = :3 )
450w20twk6ku5BEGIN OL$_RULE_CORE.CHECKNAMEMAIN(:1, :2, :3, :4, :5, :6, :7); END;
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
483awj0kbnfqrdeclare linkid varchar2(128); begin linkid:=:1; insert into indy_use_log(log_id, log_link_id, log_user_id, log_person_id, log_logon_time, log_logoff_time, log_machine_ip, log_machine_name, log_web_path, log_server_path) select log_id, log_link_id, log_user_id, log_person_id, log_logon_time, sysdate, log_machine_ip, log_machine_name, log_web_path, log_server_path from indy_online_user where log_link_id=linkid; delete from indy_online_user where log_link_id=linkid; end;
48hzu5y6ztvb8update ol$_objects set O_04 = :O_04, D_03 = :D_03 where obj_id = :objId
4bm46js67ss7tupdate ol$_objects set D_03 = :D_03, N_42 = :N_42, S_63 = :S_63 where obj_id = :objId
4bqz0z7vq1k3j SELECT ORGID ORG_NO, ORGNAME ORG_NAME, CLS_URI, CLSNAME EQUIPMENTTYPE, MOUNTCLSNAME EQUIPMENTPOSITION, NAMERULEID NAMEID, EXAMPLENAME EXAMPLE_NAME, COUNT(1) TOTAL FROM (SELECT B, (SELECT ORGID FROM V$_ST_POWERSYSTEMRESOURCE WHERE OBJ_ID = T.B) ORGID, (SELECT ORG_NAME FROM SGPM.O_ORG WHERE ORG_NO = (SELECT ORGID FROM V$_ST_POWERSYSTEMRESOURCE WHERE OBJ_ID = T.B)) ORGNAME, (SELECT CLS_URI FROM V$_ST_POWERSYSTEMRESOURCE WHERE OBJ_ID = T.B) CLS_URI, (SELECT CLS_DISP_NAME FROM OL$_CLASSES WHERE CLS_URI = (SELECT CLS_URI FROM V$_ST_POWERSYSTEMRESOURCE WHERE OBJ_ID = T.B)) CLSNAME, (SELECT (SELECT CLS_DISP_NAME FROM OL$_CLASSES WHERE CLS_URI = D.MOUNT_CLS) FROM OL$_CLSNAME_DEFS D WHERE MAIN_ID = (SELECT NAMERULEID FROM V$_ST_POWERSYSTEMRESOURCE WHERE OBJ_ID = T.B)) MOUNTCLSNAME, (SELECT IRREGULAR FROM V$_ST_POWERSYSTEMRESOURCE WHERE OBJ_ID = T.B) IRREGULAR, (SELECT NAMERULEID FROM V$_ST_POWERSYSTEMRESOURCE WHERE OBJ_ID = T.B) NAMERULEID, (SELECT D.EXAMPLE_NAME FROM OL$_CLSNAME_DEFS D WHERE MAIN_ID = (SELECT NAMERULEID FROM V$_ST_POWERSYSTEMRESOURCE WHERE OBJ_ID = T.B)) EXAMPLENAME, (SELECT SUGGESTNAME FROM V$_ST_POWERSYSTEMRESOURCE WHERE OBJ_ID = T.B) SUGGESTNAME, (SELECT RESOURCESTATUS FROM V$_ST_POWERSYSTEMRESOURCE WHERE OBJ_ID = T.B) EQUIPMENTSTATUS FROM OL$_ASSOCIATIONS T START WITH B = :1 CONNECT BY PRIOR B = A GROUP BY B UNION ALL SELECT B, (SELECT ORGID FROM V$_ST_ASSET WHERE OBJ_ID = T.B) ORGID, (SELECT ORG_NAME FROM SGPM.O_ORG WHERE ORG_NO = (SELECT ORGID FROM V$_ST_ASSET WHERE OBJ_ID = T.B)) ORGNAME, (SELECT CLS_URI FROM V$_ST_ASSET WHERE OBJ_ID = T.B) CLS_URI, (SELECT CLS_DISP_NAME FROM OL$_CLASSES WHERE CLS_URI = (SELECT CLS_URI FROM V$_ST_ASSET WHERE OBJ_ID = T.B)) CLSNAME, (SELECT (SELECT CLS_DISP_NAME FROM OL$_CLASSES WHERE CLS_URI = D.MOUNT_CLS) FROM OL$_CLSNAME_DEFS D WHERE MAIN_ID = (SELECT NAMERULEID FROM V$_ST_ASSET WHERE OBJ_ID = T.B)) MOUNTCLSNAME, (SELECT IRREGULAR FROM V$_ST_ASSET WHERE OBJ_ID = T.B) IRREGULAR, (SELECT NAMERULEID FROM V$_ST_ASSET WHERE OBJ_ID = T.B) NAMERULEID, (SELECT D.EXAMPLE_NAME FROM OL$_CLSNAME_DEFS D WHERE MAIN_ID = (SELECT NAMERULEID FROM V$_ST_ASSET WHERE OBJ_ID = T.B)) EXAMPLENAME, (SELECT SUGGESTNAME FROM V$_ST_ASSET WHERE OBJ_ID = T.B) SUGGESTNAME, (SELECT ASSETSSTATUS FROM V$_ST_ASSET WHERE OBJ_ID = T.B) EQUIPMENTSTATUS FROM OL$_ASSOCIATIONS T START WITH A = :2 CONNECT BY PRIOR B = A GROUP BY B) I WHERE I.ORGID = :3 --µ¥Î» AND I.IRREGULAR = 0 --²»·ûºÏ¹æÔò±êÖ¾ AND I.EQUIPMENTSTATUS IN ('E', 'S', 'W') AND CLS_URI = 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_DisTransAsset'GROUP BY ORGID, ORGNAME, CLS_URI, CLSNAME, NAMERULEID, EXAMPLENAME, MOUNTCLSNAME ORDER BY MOUNTCLSNAME DESC
4bzh761vk20q0update ol$_objects set D_07 = :D_07, S_34 = :S_34, S_35 = :S_35, S_05 = :S_05, N_15 = :N_15, D_01 = :D_01, N_42 = :N_42, O_09 = :O_09, O_21 = :O_21, S_09 = :S_09, S_36 = :S_36, O_17 = :O_17, S_63 = :S_63, O_01 = :O_01, S_31 = :S_31, S_32 = :S_32, D_04 = :D_04, S_01 = :S_01, O_05 = :O_05, S_28 = :S_28, S_27 = :S_27, O_15 = :O_15, S_02 = :S_02, O_02 = :O_02, O_16 = :O_16, O_20 = :O_20, D_05 = :D_05, S_03 = :S_03, D_06 = :D_06, S_04 = :S_04, D_03 = :D_03 where obj_id = :objId
4ydgzsjh9kb57 SELECT a.obj_id objid, a.cls_uri, a.orgid, getorgnamebyorgno(orgid) org_name, a.NAME linename, b.id, b.objname, to_char(b.count_date, 'yyyy-mm') count_date, b.active_power, b.reactive_power, b.actual_line_lose, b.actual_line_lose_rate, b.academic_line_lose, b.academic_line_lose_rate, b.algorithm, b.count_date, b.compute_date FROM olive.v$_lowarea a LEFT JOIN (SELECT id, low_area_original_id, org_no, org_name, objid, objname, deptid, userid, active_power, reactive_power, actual_line_lose, actual_line_lose_rate, academic_line_lose, academic_line_lose_rate, calcalgo, compute_date, calcresult, count_date, algorithm, row_number() over(PARTITION BY low_area_original_id ORDER BY count_date DESC) count_date_ord FROM t_ypjc_dy_linelose l WHERE NOT EXISTS (SELECT 1 FROM t_ypjc_low_plan_loss_relation r WHERE r.loss_id = l.id) ) b ON a.obj_id = b.low_area_original_id AND b.count_date_ord = 1 WHERE a.resourcestatus = :1 AND a.orgid = :2 ORDER BY compute_date
573u87gdj8xm1SELECT COUNT(*) CUN FROM T_WT_ISSUE_LSH_WH WHERE DQDM=:1 AND XDM=:2 AND CODE=:3 AND PZ=:4 AND NY=:5
598k07tzg7tudSelect Ass.Obj_Id, ass.CLS_URI, Ass.Name, Ass.Ratedcapacity, (Select Name From Sgpm.p_Code Where Code_Type = 'DisTransAssetXH' And Value = Ass.Sbxh) Sbxh, pc.Pathname Pathid, Olive.Getpathnamebypathid(pc.Pathname) Pathname, Ass.Assetsstatus, Ass.Orgid, Ass.CODE From olive.v$_st_powersystemresource pp, Olive.V$_St_Distransformer Pc, Olive.V$_St_Distransasset Ass, Olive.Ol$_Associations a Where Pc.Pathname Like pp.PATHNAME||'%' And pp.OBJ_ID = :1 And Ass.Pathname Like '\' || a.b || '%' And Pc.Obj_Id = a.a And Ass.Assetsstatus In (:2, :3) And Ass.Orgid = Pc.Orgid And Pc.Orgid = :4 and pc.RESOURCESTATUS = 'E'
5f4yasqwng66gupdate ol$_objects set N_52 = :N_52, N_02 = :N_02, O_06 = :O_06, S_39 = :S_39, S_03 = :S_03, S_02 = :S_02, S_04 = :S_04, S_76 = :S_76, D_08 = :D_08, N_10 = :N_10, O_03 = :O_03, D_07 = :D_07, O_27 = :O_27, O_02 = :O_02, S_73 = :S_73, O_25 = :O_25, D_04 = :D_04, O_05 = :O_05, S_35 = :S_35, N_07 = :N_07, S_40 = :S_40, N_51 = :N_51, O_29 = :O_29, S_60 = :S_60, S_68 = :S_68, S_75 = :S_75, S_15 = :S_15, O_10 = :O_10, O_26 = :O_26, N_42 = :N_42, O_01 = :O_01, O_15 = :O_15, N_09 = :N_09, N_06 = :N_06, O_08 = :O_08, D_06 = :D_06, S_27 = :S_27, S_01 = :S_01, S_63 = :S_63, D_10 = :D_10, D_03 = :D_03, D_01 = :D_01, S_33 = :S_33, N_01 = :N_01, S_31 = :S_31, O_24 = :O_24, S_05 = :S_05, S_43 = :S_43, O_14 = :O_14, S_30 = :S_30, O_07 = :O_07, S_57 = :S_57, S_42 = :S_42, S_36 = :S_36, N_03 = :N_03, S_34 = :S_34, O_31 = :O_31, S_32 = :S_32, O_04 = :O_04, S_21 = :S_21, S_22 = :S_22, D_05 = :D_05 where obj_id = :objId
5nnxqj41g9xk6Select Pc.Obj_Id, Pc.Cls_Uri, Pc.Voltagelevel, Pc.Pathname, Ass.Obj_Id Assetid, Ass.Name Assetname, Ass.Cls_Uri Asseturi, Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) Assetnamepath, c.Cls_Uri Clsuri, c.Cls_Disp_Name, Ass.Assetsstatus, Ass.Manufacturer, Ass.Sbxh, Ass.Inservicedate, Ass.Code From V$_St_Powersystemresource Pp, V$_St_Powersystemresource Pc, Ol$_Associations a, V$_St_Asset Ass, Ol$_Classes c Where Pc.Pathname Like Pp.Pathname || '%' And Ass.Pathname Like '\' || a.b || '%' And Pp.Obj_Id =:1 And Pc.Obj_Id = a.a And Ass.Cls_Uri = c.Cls_Uri And a.Ast_Uri = 'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"' and Pc.orgId=:2 and Ass.orgId=Pc.orgId and ass.Assetsstatus in( 'S', 'W') and ass.CLS_URI in( 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/MeterBoxAsset')
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5ursqxfwnrz2minsert into olive.ol$_event_log( OBJID , PSROBJECTID , PSROBJECTNAME , CHANGEDATE , CHANGETIME , OPERATEUSER , OPERATEUSERID , CHANGEREASON , EVENTTYPE , PATHNAME , STATUS , ORGID , RESOURCEID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
5wfhpq886xacrSELECT /*+index(t, NK_OL$_REFS_URI_A)*/ A, B OBJ_ID, (SELECT S_01 FROM OL$_OBJECTS WHERE OBJ_ID = B) NAME FROM OL$_ASSOCIATIONS T WHERE AST_URI = :B2 AND A = :B1 AND SUBSTR(B, 1, 32) IN (SELECT (SELECT CLS_ID FROM OL$_CLASSES WHERE CLS_URI = C.CLS_URI) CLS_ID FROM OL$_CLSNAME_DEFS C WHERE EXISTS (SELECT 1 FROM OL$_CLSRULE_DEFS D WHERE D.MAIN_ID = C.MAIN_ID AND EXISTS (SELECT 1 FROM OL$_RULE_DEFS WHERE UPPER(UP_COL) = 'NAME' AND RULE_TYPE = 'C2' AND RULE_ID = D.RULE_ID)) AND EQUIPMENT_SORT = OL$_RULE_CORE.GETEQUSORT(:B1 ))
5z8x0pna8fk4aDELETE FROM OL$_ASSOCIATIONS T WHERE T.AST_URI = :B3 AND T.A = :B2 AND T.B = :B1
6229274rb7bpcSELECT * FROM (SELECT row_.*, ROWNUM rownum_ FROM ( SELECT a.process_type, a.process_no, a.process_title, a.app_no, a.taskid, a.act_name, a.rcv_time, a.finish_time, a.alarm_date, a.due_time, a.cur_state status_code, a.lock_emp_no, a.lock_time, a.org_no, a.overreason, a.worklist_type, a.alarm_time_limit, a.time_limit, a.task_color, a.back_reason, handle_rslt, a.busi_type_code, a.srv_mode , a.cons_no, a.cons_name, a.elec_addr, a.sect_no, a.sect_name, a.sect_remark, a.chk_subject_no, a.chk_type, a.chk_name, a.chk_prio , a.exam_chk_type, a.equip_categ, a.equip_model, a.assign_date, a.qty, a.subs_no, a.subs_name, a.subs_addr , a.cust_no, a.cust_name, a.cust_use_addr, a.link_addr, a.link_name, a.link_tel, a.srv_channel, a.call_no, a.call_content, a.selbuy_equip, a.crm_cust_no, a.crm_cust_name, a.crm_resume, a.exam_remark, a.busi_data, a.start_user, a.distribute_dept, a.dm_task_type, a.app_contract_cap, a.t_contract_cap, a.volt_code, a.process_color, a.resume_time, a.user_org_no, a.terminal_addr, a.fault_addr, a.fault_property , a.scip_register_no, a.scip_cons_no, a.scip_busi_type, a.scip_srv_content, a.scip_req_time FROM wf_amber.v_indysp_worklist_com a WHERE a.user_no = :1 ORDER BY a.rcv_time DESC ) row_ WHERE ROWNUM <:2) WHERE rownum_ >=:3
646v5z184310mselect t.s_01 from olive.ol$_objects t where t.obj_id= :1
6mv6h2kff55p2select distinct k.org_name, t.*, v.action_title from V_YXDZ_CZPXX t, V_YXDZ_CZPCX v, T_YXDZ_CZPXX k where t.processid=v.PROCESSID(+) and t.processid='130327507505' and k.processid=t.PROCESSID
6pcrpqf5dkunfselect /*+ index(o PK_OL$_OBJECTS) */ * from v$_DYPolePosition o where obj_id=:1
7gfjbwmcxjx9sSELECT COUNT(*) FROM OL$_OBJECTS T WHERE T.OBJ_ID = :B1
7hg004b3d9kkgselect b.name deptName, a.USER_TITLE userName, t_yxdz_czpxx_count(user_name, '', 'czrws', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') czrws, t_yxdz_czpxx_count(user_name, '', 'czps', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') czps, t_yxdz_czpxx_count(user_name, '', 'czbzs', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') czbzs, t_yxdz_czpxx_count(user_name, '', 'kprws', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') kprws, t_yxdz_czpxx_count(user_name, '', 'kps', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') kps, t_yxdz_czpxx_count(user_name, '', 'kpbzs', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') kpbzs, t_yxdz_czpxx_count(user_name, '', 'shrws', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') shrws, t_yxdz_czpxx_count(user_name, '', 'shps', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') shps, t_yxdz_czpxx_count(user_name, '', 'shbzs', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') shbzs, t_yxdz_czpxx_count(user_name, '', 'jhrws', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') jhrws, t_yxdz_czpxx_count(user_name, '', 'jhps', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') jhps, t_yxdz_czpxx_count(user_name, '', 'jhbzs', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') jhbzs from amber.indy_user a, sgpm.o_dept b where b.dept_no = '0000057904' and a.USER_DEPARTMENT_NAME=b.DEPT_NO order by a.user_title desc
7q0mrfy5py47yINSERT INTO INDY_USE_LOG(LOG_ID, LOG_LINK_ID, LOG_USER_ID, LOG_PERSON_ID, LOG_LOGON_TIME, LOG_LOGOFF_TIME, LOG_MACHINE_IP, LOG_MACHINE_NAME, LOG_WEB_PATH, LOG_SERVER_PATH) SELECT LOG_ID, LOG_LINK_ID, LOG_USER_ID, LOG_PERSON_ID, LOG_LOGON_TIME, SYSDATE, LOG_MACHINE_IP, LOG_MACHINE_NAME, LOG_WEB_PATH, LOG_SERVER_PATH FROM INDY_ONLINE_USER WHERE LOG_LINK_ID=:B1
7vzpyu7p1t79j select APPLY_ID, APPLY_CD, APPLY_DATE, APPLICANT_CD, APPLICANT, APPLY_UNIT_CD, APPLY_UNIT, REPAIR_UNIT_CD, REPAIR_UNIT, PLAN_TO_CUT, WEEK_PLAN_CD, WORK_LEADER_CD, WORK_LEADER, APPLY_STOP_BEGIN_DATE, APPLY_STOP_END_DATE, STOP_TARGET_ID, STOP_TARGET, STOP_ASSETS_ID, STOP_ASSETS, STOP_SCOPE, WORK_CONTENT, WIRING_CHART, CHANGED_WIRING_CHART, HANDLER_CD, HANDLER, AUDITOR_CD, AUDITOR, APPROVAL_STOP_BEGIN_DATE, APPROVAL_STOP_END_DATE, DISTRICT_DISP_FASHION, DISTRICT_DISP_GUARD, DISTRICT_DISP_APPROVE, FASHION, FASHION_AUDITOR_CD, FASHION_AUDITOR, GUARD, GUARD_AUDITOR_CD, GUARD_AUDITOR, APPROVAL, APPROVER_CD, APPROVER, RECEIVER_CD, RECEIVER, WORKING_BEGIN_DATE, DELEGATE_CD, DELEGATE, BEGIN_DISPATCHER_CD, BEGIN_DISPATCHER, WORKING_END_DATE, REPORTER_CD, REPORTER, END_DISPATCHER_CD, END_DISPATCHER, REAUDITOR_CD, REAUDITOR, DELAY_APPLY_BEGIN_DATE, DELAY_APPLY_END_DATE, DELAY_BEGIN_DATE, DELAY_END_DATE, APPROVAL_BEGIN_DATE, APPROVAL_END_DATE, REPAIR_BEGIN_DATE, REPAIR_END_DATE, DELAY_APPLICANT_CD, DELAY_APPLICANT, DELAY_APPROVER_CD, DELAY_APPROVER, DELAY_REASON, MEMO, LAST_UPDATE_DATE, LAST_UPDATER_CD, LAST_UPDATER, CREATE_DATE, CREATER_CD, CREATER, ORG_NO, ORG_NAME, DEL_FLG, (SELECT O.ORG_NAME FROM SGPM.O_ORG O WHERE O.ORG_NO=SUBSTR(A.ORG_NO, 1, 7)) ORG_NAMES , action_url, actionname, activity_name, HANDLE_AUDIT_DATE, FASHION_AUDIT_DATE, FASHION_APPROVAL_BEGIN_DATE, FASHION_APPROVAL_END_DATE, GUARD_AUDIT_DATE, APPROVE_AUDIT_DATE from V_POWERCUT_APPLY_QUERY a where 1=1 and trunc(a.fashion _approval_begin_date, 'DD') >= to_date(:1, 'yyyy-MM-dd') and trunc(a.fashion_approval_begin_date, 'DD') <= to_date(:2, 'yyyy-MM-dd') and a.org_no like GETORGNO(:3)
7wgzpzkd96b4pSELECT n.id id, n.name name, n.node_type_code node_type_code, n.span / 1000 span, n.lpsequence lp_sequence, n.dist_line_id dist_line_id FROM v_dist_line_node n WHERE n.pathname LIKE :1 AND n.org_no = :2 ORDER BY n.dist_line_id ASC, n.lpsequence ASC
7xgzx0zrnt0fcselect /*+ index(o PK_OL$_OBJECTS) */ * from v$_ST_DYLine o where obj_id=:1
7xn6xppmpg9u7SELECT * FROM (SELECT D.OBJ_ID, D.CLS_URI, D.NAME, GETNAMEPATHBYIDPATH(D.PATHNAME) PATHNAME, C.CLS_DISP_NAME DISNAME FROM (SELECT ASS.B FROM OLIVE.OL$_ASSOCIATIONS ASS START WITH ASS.A = :1 ---- ¶¥²ãÉ豸ÈÝÆ÷id CONNECT BY PRIOR ASS.B = A) E, OLIVE.V$_ST_POWERSYSTEMRESOURCE D, OLIVE.OL$_CLASSES C WHERE D.OBJ_ID = E.B AND D.CLS_URI IN(:2) AND C.CLS_URI = D.CLS_URI AND D.RESOURCESTATUS = 'E' AND D.ORGID =:3 ) E ORDER BY E.PATHNAME
80hn6zhb2zpf4DELETE FROM OWF_MGR.WF_NOTIFICATION_ATTRIBUTES T WHERE EXISTS( SELECT 1 FROM OWF_MGR.WF_ITEM_ACTIVITY_STATUSES_H B WHERE B.ITEM_TYPE=:B2 AND B.ITEM_KEY = :B1 AND B.NOTIFICATION_ID=T.NOTIFICATION_ID)
8b9zc43w360qtSELECT O_28 partitionField FROM ol$_objects t WHERE t.obj_id=:1
8d3y3sqaj9f3s SELECT * FROM (SELECT row_.*, ROWNUM rownum_ FROM ( SELECT a.process_type, a.process_no, a.process_title, a.app_no, a.taskid, a.act_name, a.rcv_time, a.finish_time, a.alarm_date, a.due_time, a.cur_state status_code, a.lock_emp_no, a.lock_time, a.org_no, a.overreason, a.worklist_type, a.alarm_time_limit, a.time_limit, a.task_color, a.back_reason, handle_rslt, a.busi_type_code, a.srv_mode , CASE WHEN a.due_time < SYSDATE THEN 'Y' ELSE 'N' END isovertimer, CASE WHEN a.alarm_date < SYSDATE THEN 'Y' ELSE 'N' END isalarmtimer, a.cons_no, a.cons_name, a.elec_addr, a.sect_no, a.sect_name, a.sect_remark, a.chk_subject_no, a.chk_type, a.chk_name, a.chk_prio , a.exam_chk_type, a.equip_categ, a.equip_model, a.assign_date, a.qty, a.subs_no, a.subs_name, a.subs_addr , a.cust_no, a.cust_name, a.cust_use_addr, a.link_addr, a.link_name, a.link_tel, a.srv_channel, a.call_no, a.call_content, a.selbuy_equip, a.crm_cust_no, a.crm_cust_name, a.crm_resume, a.exam_remark, a.busi_data, a.start_user, a.distribute_dept, a.dm_task_type, a.app_contract_cap, a.t_contract_cap, a.volt_code, a.process_color, a.resume_time, a.user_org_no, a.terminal_addr, a.fault_addr, a.fault_property , a.scip_register_no, a.scip_cons_no, a.scip_busi_type, a.scip_srv_content, a.scip_req_time FROM wf_amber.v_indysp_worklist_cur a, wf_amber.indysp_task_user_cur b WHERE a.taskid = b.taskid AND a.app_no = b.app_no AND a.org_no = b.process_org_no AND b.user_no = :1 AND b.user_ dept_no = :2 AND b.user_org_no = :3 AND a.cur_state NOT IN( 'WAIT', 'BACKWAIT') AND ( a.lock_emp_no = :4 OR a.lock_emp_no IS NULL ) ORDER BY a.rcv_time DESC ) row_ WHERE ROWNUM <:5) WHERE rownum_ >=:6
8rdg2n7g8ftk3update ol$_objects set O_10 = :O_10, S_37 = :S_37, S_27 = :S_27, S_63 = :S_63, S_06 = :S_06, O_20 = :O_20, O_05 = :O_05, O_25 = :O_25, O_21 = :O_21, O_02 = :O_02, S_38 = :S_38, N_07 = :N_07, D_07 = :D_07, S_12 = :S_12, O_23 = :O_23, S_13 = :S_13, O_18 = :O_18, S_17 = :S_17, S_47 = :S_47, S_31 = :S_31, S_05 = :S_05, O_17 = :O_17, N_20 = :N_20, S_03 = :S_03, S_01 = :S_01, S_30 = :S_30, N_10 = :N_10, S_25 = :S_25, O_04 = :O_04, O_01 = :O_01, N_42 = :N_42, S_11 = :S_11, S_14 = :S_14, O_13 = :O_13, S_32 = :S_32, S_34 = :S_34, S_35 = :S_35, S_09 = :S_09, N_04 = :N_04, O_15 = :O_15, N_03 = :N_03, N_02 = :N_02, O_19 = :O_19, D_01 = :D_01, S_33 = :S_33, O_11 = :O_11, N_09 = :N_09, N_11 = :N_11, S_44 = :S_44, N_18 = :N_18, S_07 = :S_07, N_19 = :N_19, O_14 = :O_14, N_12 = :N_12, S_15 = :S_15, D_05 = :D_05, O_24 = :O_24, D_04 = :D_04, D_03 = :D_03, O_09 = :O_09, N_01 = :N_01, N_05 = :N_05, O_07 = :O_07, N_06 = :N_06, O_12 = :O_12, N_15 = :N_15, S_02 = :S_02, O_16 = :O_16, S_36 = :S_36, N_08 = :N_08, O_03 = :O_03, D_06 = :D_06, S_04 = :S_04, O_08 = :O_08, N_13 = :N_13, S_16 = :S_16, S_28 = :S_28, O_22 = :O_22, S_43 = :S_43, O_06 = :O_06, S_18 = :S_18 where obj_id = :objId
91hakq9n36htpSELECT TEXT_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
93dtuy0vt2k7qSELECT task_id FROM p_task WHERE set_emp_no = :1 AND content LIKE '%methodName=notifyDeskMessage%'
95jvxjj84rcctselect /*+ index(o PK_OL$_OBJECTS) */ * from v$_MeterBox o where obj_id=:1
964zgsudcdac7SELECT D.ATTR_URI FROM OL$_ATTR_DEFS D WHERE D.CLS_URI = :B2 AND D.ATTR_NAME = :B1
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
9g4jrwq86jnb7BEGIN OL$_RULE_CORE.CHECKANDUPDATELOWERNAME(:1); END;
9rn5ah9npmbc8WITH CLS_LIST AS (SELECT (SELECT CLS_ID FROM OL$_CLASSES WHERE CLS_URI = C.CLS_URI) CLS_ID, MAIN_ID, C.LINE_TYPE FROM OL$_CLSNAME_DEFS C WHERE EXISTS (SELECT 1 FROM OL$_CLSRULE_DEFS D WHERE D.MAIN_ID = C.MAIN_ID AND EXISTS (SELECT 1 FROM OL$_RULE_DEFS WHERE UP_TARGET_CLS = :B1 AND UPPER(UP_COL) = 'NAME' AND RULE_TYPE = 'C1' AND RULE_ID = D.RULE_ID))), OBJ_LIST AS (SELECT B OBJ_ID, (SELECT S_01 FROM OL$_OBJECTS WHERE OBJ_ID = B) NAME, LEVEL LEL FROM (SELECT T.* FROM OL$_ASSOCIATIONS T WHERE AST_URI = :B3 AND B LIKE SUBSTR(:B2 , 1, 32) || '%' AND A LIKE SUBSTR(:B2 , 1, 32) || '%' START WITH A = :B2 CONNECT BY PRIOR B = A) WHERE SUBSTR(B, 1, 32) IN (SELECT CLS_ID FROM CLS_LIST C) START WITH A = :B2 CONNECT BY PRIOR B = A)SELECT * FROM OBJ_LIST, CLS_LIST WHERE SUBSTR(OBJ_LIST.OBJ_ID, 1, 32) = CLS_LIST.CLS_ID AND DECODE(OBJ_LIST.LEL, 1, '02', '03') = CLS_LIST.LINE_TYPE
9trfmfyhqpm5pUPDATE INDYWF_INSTANCES_CUR SET END_DATE = :B5 , STATE = :B4 WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND DEPT_NAME = :B1
9vrbr3jjprusnSELECT B OBJ_ID, (SELECT S_01 FROM OL$_OBJECTS WHERE OBJ_ID = B) NAME FROM (SELECT T.*, LEVEL FROM OL$_ASSOCIATIONS T WHERE AST_URI = :B2 AND SUBSTR(B, 1, 32) != SUBSTR(:B1 , 1, 32) AND SUBSTR(DECODE(A, :B1 , '1', A), 1, 32) != SUBSTR(:B1 , 1, 32) START WITH A = :B1 CONNECT BY PRIOR B = A) WHERE SUBSTR(B, 1, 32) IN (SELECT (SELECT CLS_ID FROM OL$_CLASSES WHERE CLS_URI = C.CLS_URI) CLS_ID FROM OL$_CLSNAME_DEFS C WHERE EXISTS (SELECT 1 FROM OL$_CLSRULE_DEFS D WHERE D.MAIN_ID = C.MAIN_ID AND EXISTS (SELECT 1 FROM OL$_RULE_DEFS WHERE UP_TARGET_CLS = :B3 AND UPPER(UP_COL) = 'NAME' AND RULE_TYPE = 'C' AND RULE_ID = D.RULE_ID))) START WITH A = :B1 CONNECT BY PRIOR B = A
9yyb7wvndk114select * from v$_ST_DYLine where ( orgId = :1 and ResourceStatus = :2 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :3 and ol$_associations.a = :4 ) order by cls_uri
a1ymvq7wx3y4vUPDATE V$_ST_IDENTIFIEDOBJECT O SET O.NAME = :B4 , O.SUGGESTNAME = :B3 , O.NAMERULEID = :B2 , O.IRREGULAR = 0 WHERE OBJ_ID = :B1
a41yvpfth003xselect * from v$_ST_Equipment where ( orgId = :1 and RESOURCESTATUS=:2) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :3 and ol$_associations.a = :4 )
ab0n17bxfj28dSELECT * FROM (SELECT D.OBJ_ID, D.CLS_URI, D.NAME, GETNAMEPATHBYIDPATH(D.PATHNAME) PATHNAME, C.CLS_DISP_NAME DISNAME FROM (SELECT ASS.B FROM OLIVE.OL$_ASSOCIATIONS ASS START WITH ASS.A = :1 ---- ¶¥²ãÉ豸ÈÝÆ÷id CONNECT BY PRIOR ASS.B = A) E, OLIVE.V$_ST_POWERSYSTEMRESOURCE D, OLIVE.OL$_CLASSES C WHERE D.OBJ_ID = E.B AND D.CLS_URI IN(:2) AND D.NAME LIKE :3 AND C.CLS_URI = D.CLS_URI AND D.RESOURCESTATUS = 'E' AND D.ORGID =:4 ) E ORDER BY E.PATHNAME
avjzuwm5npxv7select * from indy_menu where menu_id in ( select menu_id from indy_menu start with menu_id in ( select n.menu_id from indy_menu n where menu_state = '01' and n.action_normal = 'T' and n.action_id in ( select ua.action_id from indy_user_action ua where ua.user_id = :1 ) union all select m.menu_id from indy_menu m where menu_state = '01' and m.action_normal = 'T' and m.action_authorized = 'F' and m.action_id is not null ) connect by menu_id = prior menu_parent_id ) and menu_kind in ('MenuFolder', 'MenuItem') and decode(:2, menu_parent_id, 1, menu_grant_id, 1, 0) = 1 and menu_state = :3 order by menu_index
awvtdy3vc6fumSELECT codeId, codeSortId, parentCodeId, codeType, orgNo, value, name, dispSn, content1, content2, content3, content4, content5 FROM (SELECT '' codeId, '' codeSortId, p_code parentCodeId, code_type codeType, org_no orgNo, value, name, disp_sn dispSn, content1, content2, content3, content4, content5 FROM v_sp_cache_code) WHERE codeType=:1
b0mb9f2wdgnrkselect /*+ index(o PK_OL$_OBJECTS) */ * from v$_LowArea o where obj_id=:1
bsm6gmajgmhuuselect * from indy_menu where menu_id in ( select menu_id from indy_menu start with menu_id in ( select n.menu_id from indy_menu n where menu_state = '01' and n.action_normal = 'T' and n.action_id in ( select ua.action_id from indy_user_action ua where ua.user_id = :1 ) union all select m.menu_id from indy_menu m where menu_state = '01' and m.action_normal = 'T' and m.action_authorized = 'F' and m.action_id is not null ) connect by menu_id = prior menu_parent_id ) and menu_kind in ('MenuFolder', 'MenuItem') and menu_parent_id=:2 and menu_state = :3 order by menu_index
bunvx480ynf57SELECT 1 FROM DUAL
bvnkf18n91h4q select a.line_id, a.line_name, a.issue_unit_id, a.issue_unit, a.unit, a.unit_id, a.leader_id, a.leader, a.ticket_no, a.working_unit_id, a.working_unit, a.working_staff_id, a.working_staff, a.total_staff, a.work_site, a.pulling_switch, a.live_electrical_equipment, a.other_security_measures, to_char(a.start_date, 'yyyy-mm-dd hh24:mi') str_start_date, to_char(a.end_date, 'yyyy-mm-dd hh24:mi') str_end_date, a.start_date, a.end_date, a.issue_no, a.issuer, a.issue_date, a.receive_leader_id, a.receive_leader_name, a.receive_date, (select wmsys.wm_concat(permit_leader_id) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_leader_id, (select wmsys.wm_concat(permit_working_man) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_working_man, a.exec_working_staff_id, (select wmsys.wm_concat(to_char(permit_working_time, 'yyyy-mm-dd hh24:mi:ss')) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) SpermitWorkingTime, (select wmsys.wm_concat(permit_working_man_id) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_working_man_id, (select wmsys.wm_concat(permit_leader) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_leader, (select wmsys.wm_concat(permit_mode) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_mode, a.issuer_id, a.working_condition, a.reclose_equipment, a.exec_working _staff, a.changed_date, a.working_staff_changes, a.exec_leader_id, a.exec_leader, a.deadline, a.delay_permiter_id, a.delay_permiter, a.earth_wire_no, a.terminal_mode, a.earth_wire_total_set, a.terminal_permiter_id, a.terminal_permiter, a.terminal_leader_id, a.terminal_leader, a.terminal_report_time, a.permiter_audit_date, a.leader_audit_date, a.del_flg, a.should_earth_wire_no, a.should_earth_wire_total_set, a.filler_id, a.filler, a.delay_leader, a.former_leader, a.former_leader_id, a.changed_leader_id, a.changed_leader, a.exec_issuer_id, a.exec_issuer, a.work_team, a.action_url, a.actionname, GETORGNAMES(a.issue_unit_id) orgName, a.activity_name, a.week_plan_id from pms.V_LINE_TICKET1_QUERY a where 1=1 and start_date>=to_date(:1, 'yyyy-mm-dd hh24:mi:ss') and end_date<=to_date(:2, 'yyyy-mm-dd hh24:mi:ss') and del_flg = 'F' and org_no LIKE GETORGNO('1340510')
c4zp1p9yb7brgupdate ol$_objects set S_63 = :S_63, D_01 = :D_01, N_42 = :N_42, S_31 = :S_31, O_02 = :O_02, D_03 = :D_03, S_05 = :S_05, S_01 = :S_01 where obj_id = :objId
cfrwbnuu2xtamselect side_b from ol$_association_constraints where association_type = :1 and side_a = :2
cjz46bvt9kd0tINSERT INTO OL$_OBJECTS (OBJ_ID, CLS_URI, O_28) VALUES (:B3 , :B2 , :B1 )
cm7kjhuwrrq3gbegin begin OL$_Core.DeleteAssociation(:1, :2, :3); end; end;
czxzy970jq50gupdate ol$_objects set S_27 = :S_27, D_08 = :D_08, S_40 = :S_40, D_10 = :D_10, O_07 = :O_07, S_36 = :S_36, D_04 = :D_04, D_01 = :D_01, S_32 = :S_32, O_03 = :O_03, D_06 = :D_06, O_29 = :O_29, S_35 = :S_35, S_75 = :S_75, S_15 = :S_15, S_68 = :S_68, N_07 = :N_07, N_01 = :N_01, O_04 = :O_04, S_63 = :S_63, S_02 = :S_02, S_76 = :S_76, D_03 = :D_03, O_27 = :O_27, S_03 = :S_03, S_21 = :S_21, O_01 = :O_01, N_10 = :N_10, N_52 = :N_52, N_42 = :N_42, O_25 = :O_25, D_05 = :D_05, O_24 = :O_24, S_42 = :S_42, D_07 = :D_07, O_31 = :O_31, S_01 = :S_01, S_04 = :S_04, O_02 = :O_02, O_26 = :O_26, N_09 = :N_09, O_05 = :O_05, O_06 = :O_06, N_02 = :N_02, S_73 = :S_73, N_51 = :N_51, S_31 = :S_31, S_22 = :S_22, S_34 = :S_34, S_05 = :S_05, S_39 = :S_39 where obj_id = :objId
d3gsxy5k0u8hwselect * from v$_ST_Asset where ( orgId = :1 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :2 and ol$_associations.a = :3 )
d7qa0bq22h0p3SELECT A FROM OL$_ASSOCIATIONS WHERE B = :B1
dbgctn9f6071v SELECT a.obj_id objid, a.cls_uri, a.orgid, getorgnamebyorgno(a.orgid) org_name, a.name linename, a.voltagelevel volcode, b.id, b.count_date countDate, b.active_power, b.active_load, b.reactive_load, b.actual_line_lose, b.actual_line_lose_rate, b.academic_line_lose, b.academic_line_lose_rate, b.algorithm, b.compute_date, s.name qdbdz FROM OLIVE.V$_ST_FEEDER a LEFT JOIN (SELECT l.id, l.line_id, l.count_date, l.active_power, l.active_load, l.reactive_load, l.actual_line_lose, l.actual_line_lose_rate, l.academic_line_lose, l.academic_line_lose_rate, l.algorithm, l.compute_date, row_number() over(PARTITION BY line_id ORDER BY count_date DESC) count_date_ord FROM T_YPJC_LINELOSE l WHERE NOT EXISTS (SELECT 1 FROM t_ypjc_loss_expend_relation r WHERE r.loss_id = l.id) ) b ON a.obj_id = b.line_id AND b.count_date_ord = 1 LEFT JOIN olive.v$_st_substation s ON a.starsubstation = s.obj_id WHERE a.resourcestatus = :1 AND length(a.pathname) = :2 AND a.orgid = :3 ORDER BY compute_date
dczy7gkm3mpaxupdate ol$_objects set S_04 = :S_04 where obj_id = :objId
dh48uzmwms409update ol$_objects set D_03 = :D_03, N_42 = :N_42, S_63 = :S_63, O_14 = :O_14, O_15 = :O_15, O_27 = :O_27, S_31 = :S_31 where obj_id = :objId
dnctudjagb520select * from v$_ST_AssetModel where ( orgId = :1 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :2 and ol$_associations.a = :3 )
f1ypmrqprt2j2update ol$_objects set S_15 = :S_15, N_42 = :N_42, S_63 = :S_63, D_03 = :D_03, S_31 = :S_31, S_36 = :S_36 where obj_id = :objId
f3zd7grha43byselect count(1) from indy_online_user l where l.log_web_path=:1 and l.log_machine_ip =:2 and l.log_link_id !=:3
f5yun5dynkskv select s.synonym_name as object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
f8uvk4ymbh19zSELECT NAME, TYPE, ACTION_URL, actionname, activity_name, ticket_no, filler_id, filler, leader, leader_id, str_start_date, str_end_date, issuer, issuer_id, issue_date, permit_permiter_id, permit_permiter, week_plan_id FROM v_all_ticket1_query T WHERE T.WEEK_PLAN_ID =:1
fbg5fqdjsvbw9DELETE INDYWF_WORKLIST_COM WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND DEPT_NAME = :B1
fc42s7rxq7chgSELECT CLS_URI FROM OL$_CLASSES WHERE CLS_ID = :B1
fcgwwxtw17p55INSERT INTO INDY_ONLINE_USER(LOG_ID, LOG_LINK_ID, LOG_USER_ID, LOG_PERSON_ID, LOG_WEB_PATH, LOG_SERVER_PATH, LOG_LOGON_TIME, LOG_MACHINE_IP, LOG_MACHINE_NAME) VALUES(:B1, :B2, :B3, :B4, :B5, :B6, SYSDATE, :B7, :B8)
ff40ndudptw4cDELETE FROM INDY_ONLINE_USER WHERE LOG_LINK_ID=:B1
fgu2g3jt27ka4select count(1) from indy_online_user t where t.log_web_path = :1
fgyb29rrzf9jfinsert into P_TASK( TASK_ID , NAME , REPEAT_MODE , RUN_TIME , VALID_TIME , INVALID_TIME , RETRY_TIMES , RETRY_INTERVAL , PRIO , SET_EMP_NO , SET_TIME , CONTENT) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
g0mmxhhfz1q9gselect * from v$_LowArea where ( orgId = :1 and ResourceStatus = :2 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :3 and ol$_associations.a = :4 ) order by cls_uri
g4rzpg6rj116dBEGIN OL$_RULE_CORE.SETSTRATTR(:1, :2); END;
g7sx2r79bnt4vINSERT INTO INDYWF_WORKLIST_HIS SELECT * FROM INDYWF_WORKLIST_CUR WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND DEPT_NAME = :B1
g8mb1ky69dcp6update ol$_objects set N_42 = :N_42, S_63 = :S_63, D_03 = :D_03 where obj_id = :objId
g8w9fba2jp4phselect * from st_institution_resource sr, olive.ol$_classes c where sr.childresourcetype=c.cls_uri(+)
ggak0dvtsppv3SELECT /*+ leading(wias) index(wias, WF_ITEM_ACTIVITY_STATUSES_PK) */ WPA.INSTANCE_ID FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA WHERE WPA.ACTIVITY_ITEM_TYPE = :B2 AND WPA.ACTIVITY_NAME = :B1 AND WPA.INSTANCE_ID = WIAS.PROCESS_ACTIVITY AND WIAS.ITEM_TYPE = :B4 AND WIAS.ITEM_KEY = :B3
grwydz59pu6mcselect text from view$ where rowid=:1
gtfzp7x4sg6xuDELETE FROM OWF_MGR.WF_ITEM_ACTIVITY_STATUSES_H T WHERE T.ITEM_TYPE=:B2 AND T.ITEM_KEY=: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,062,334 2,156.19 589.77
CPU used when call started 98,634 52.35 14.32
CR blocks created 8,913 4.73 1.29
Cached Commit SCN referenced 141,350 75.03 20.52
Commit SCN cached 45 0.02 0.01
DB time 24,448,194 12,976.53 3,549.39
DBWR checkpoint buffers written 33,818 17.95 4.91
DBWR checkpoints 16 0.01 0.00
DBWR fusion writes 6,919 3.67 1.00
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 509 0.27 0.07
DBWR undo block writes 7,800 4.14 1.13
DFO trees parallelized 13 0.01 0.00
Misses for writing mapping 1 0.00 0.00
PX local messages recv'd 8,540 4.53 1.24
PX local messages sent 8,109 4.30 1.18
PX remote messages recv'd 50 0.03 0.01
PX remote messages sent 71 0.04 0.01
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 13 0.01 0.00
RowCR - row contention 431 0.23 0.06
RowCR attempts 17,004 9.03 2.47
RowCR hits 16,723 8.88 2.43
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for instance recovery 1 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 1,280,305 679.56 185.87
SQL*Net roundtrips to/from dblink 23,587 12.52 3.42
active txn count during cleanout 10,624 5.64 1.54
application wait time 3,817,513 2,026.25 554.23
auto extends on undo tablespace 0 0.00 0.00
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 5,437 2.89 0.79
branch node splits 16 0.01 0.00
buffer is not pinned count 15,978,702 8,481.12 2,319.79
buffer is pinned count 24,129,811 12,807.54 3,503.17
bytes received via SQL*Net from client 97,092,051 51,534.18 14,095.83
bytes received via SQL*Net from dblink 12,370,369 6,565.90 1,795.93
bytes sent via SQL*Net to client 993,599,560 527,379.34 144,250.81
bytes sent via SQL*Net to dblink 2,789,802 1,480.76 405.02
calls to get snapshot scn: kcmgss 2,461,127 1,306.31 357.31
calls to kcmgas 102,957 54.65 14.95
calls to kcmgcs 1,529 0.81 0.22
change write time 5,230 2.78 0.76
cleanout - number of ktugct calls 12,131 6.44 1.76
cleanouts and rollbacks - consistent read gets 5,178 2.75 0.75
cleanouts only - consistent read gets 2,684 1.42 0.39
cluster key scan block gets 69,304 36.78 10.06
cluster key scans 49,003 26.01 7.11
cluster wait time 51,184,723 27,167.65 7,431.00
commit batch performed 2,809 1.49 0.41
commit batch requested 2,809 1.49 0.41
commit batch/immediate performed 2,988 1.59 0.43
commit batch/immediate requested 2,988 1.59 0.43
commit cleanout failures: block lost 653 0.35 0.09
commit cleanout failures: buffer being written 2 0.00 0.00
commit cleanout failures: callback failure 825 0.44 0.12
commit cleanout failures: cannot pin 52 0.03 0.01
commit cleanouts 39,977 21.22 5.80
commit cleanouts successfully completed 38,445 20.41 5.58
commit immediate performed 179 0.10 0.03
commit immediate requested 179 0.10 0.03
commit txn count during cleanout 6,701 3.56 0.97
concurrency wait time 16,945,384 8,994.21 2,460.13
consistent changes 46,120 24.48 6.70
consistent gets 65,468,267 34,749.02 9,504.68
consistent gets - examination 17,020,316 9,033.98 2,471.01
consistent gets direct 3,367 1.79 0.49
consistent gets from cache 65,464,898 34,747.23 9,504.20
current blocks converted for CR 56 0.03 0.01
cursor authentications 2,284 1.21 0.33
data blocks consistent reads - undo records applied 15,549 8.25 2.26
db block changes 237,076 125.83 34.42
db block gets 329,829 175.07 47.88
db block gets direct 1,579 0.84 0.23
db block gets from cache 328,250 174.23 47.66
deferred (CURRENT) block cleanout applications 17,377 9.22 2.52
dirty buffers inspected 122 0.06 0.02
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 56,687 30.09 8.23
enqueue deadlocks 0 0.00 0.00
enqueue releases 130,676 69.36 18.97
enqueue requests 130,681 69.36 18.97
enqueue timeouts 23 0.01 0.00
enqueue waits 17,715 9.40 2.57
exchange deadlocks 4,454 2.36 0.65
execute count 1,470,962 780.75 213.55
failed probes on index block reclamation 1 0.00 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 642,771 341.17 93.32
free buffer requested 648,323 344.11 94.12
gc CPU used by this session 13,002 6.90 1.89
gc blocks lost 0 0.00 0.00
gc claim blocks lost 13 0.01 0.00
gc cr block build time 21,906 11.63 3.18
gc cr block flush time 6,421 3.41 0.93
gc cr block receive time 594,813 315.71 86.35
gc cr block send time 1,070 0.57 0.16
gc cr blocks received 25,768 13.68 3.74
gc cr blocks served 24,067 12.77 3.49
gc current block flush time 5,605 2.98 0.81
gc current block pin time 154,649 82.08 22.45
gc current block receive time 2,095,844 1,112.42 304.27
gc current block send time 90,823 48.21 13.19
gc current blocks received 193,841 102.89 28.14
gc current blocks served 191,950 101.88 27.87
gc local grants 239,948 127.36 34.84
gc remote grants 165,124 87.64 23.97
gcs messages sent 1,909,154 1,013.33 277.17
ges messages sent 145,383 77.17 21.11
global enqueue get time 3,073,565 1,631.38 446.22
global enqueue gets async 33,638 17.85 4.88
global enqueue gets sync 139,421 74.00 20.24
global enqueue releases 169,609 90.02 24.62
global undo segment hints helped 0 0.00 0.00
global undo segment hints were stale 0 0.00 0.00
heap block compress 2,218 1.18 0.32
hot buffers moved to head of LRU 528,211 280.36 76.69
immediate (CR) block cleanout applications 7,865 4.17 1.14
immediate (CURRENT) block cleanout applications 6,497 3.45 0.94
index crx upgrade (found) 17 0.01 0.00
index crx upgrade (positioned) 6,626 3.52 0.96
index fast full scans (full) 32,069 17.02 4.66
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 6,554,119 3,478.77 951.53
index scans kdiixs1 1,760,865 934.63 255.64
leaf node 90-10 splits 81 0.04 0.01
leaf node splits 500 0.27 0.07
lob reads 4,400 2.34 0.64
lob writes 9,110 4.84 1.32
lob writes unaligned 9,046 4.80 1.31
local undo segment hints helped 0 0.00 0.00
local undo segment hints were stale 0 0.00 0.00
logons cumulative 2,971 1.58 0.43
messages received 61,008 32.38 8.86
messages sent 61,008 32.38 8.86
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 47,438,464 25,179.22 6,887.12
opened cursors cumulative 221,531 117.58 32.16
parse count (failures) 749 0.40 0.11
parse count (hard) 13,877 7.37 2.01
parse count (total) 162,334 86.16 23.57
parse time cpu 43,078 22.86 6.25
parse time elapsed 5,604,515 2,974.75 813.66
physical read IO requests 196,047 104.06 28.46
physical read bytes 3,474,530,304 1,844,199.20 504,432.39
physical read total IO requests 215,376 114.32 31.27
physical read total bytes 3,885,343,744 2,062,249.34 564,074.30
physical read total multi block requests 21,672 11.50 3.15
physical reads 424,137 225.12 61.58
physical reads cache 401,103 212.90 58.23
physical reads cache prefetch 221,915 117.79 32.22
physical reads direct 22,498 11.94 3.27
physical reads direct (lob) 3,233 1.72 0.47
physical reads direct temporary tablespace 19,138 10.16 2.78
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 40,784 21.65 5.92
physical write bytes 1,149,698,048 610,232.76 166,913.19
physical write total IO requests 60,553 32.14 8.79
physical write total bytes 1,304,995,840 692,661.19 189,459.33
physical write total multi block requests 21,950 11.65 3.19
physical writes 140,344 74.49 20.38
physical writes direct 95,531 50.71 13.87
physical writes direct (lob) 903 0.48 0.13
physical writes direct temporary tablespace 94,237 50.02 13.68
physical writes from cache 44,813 23.79 6.51
physical writes non checkpoint 133,004 70.60 19.31
pinned buffers inspected 290 0.15 0.04
prefetch clients - default 11 0.01 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 10 0.01 0.00
process last non-idle time 2,000 1.06 0.29
queries parallelized 13 0.01 0.00
recovery blocks read 6,851 3.64 0.99
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 2,956,325 1,569.15 429.20
recursive cpu usage 32,913 17.47 4.78
redo blocks read for recovery 91,488 48.56 13.28
redo blocks written 129,012 68.48 18.73
redo buffer allocation retries 0 0.00 0.00
redo entries 129,309 68.63 18.77
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 4,905 2.60 0.71
redo size 61,728,716 32,764.15 8,961.78
redo subscn max counts 1,511 0.80 0.22
redo synch time 39,652 21.05 5.76
redo synch writes 6,816 3.62 0.99
redo wastage 2,517,100 1,336.02 365.43
redo write broadcast ack time 195,027 103.52 28.31
redo write time 987 0.52 0.14
redo writer latching time 647 0.34 0.09
redo writes 8,528 4.53 1.24
rollback changes - undo records applied 1,374 0.73 0.20
rollbacks only - consistent read gets 3,928 2.08 0.57
root node splits 1 0.00 0.00
rows fetched via callback 2,544,588 1,350.61 369.42
session connect time 1,987,652 1,055.00 288.57
session cursor cache hits 131,085 69.58 19.03
session logical reads 65,798,128 34,924.10 9,552.57
shared hash latch upgrades - no wait 123,535 65.57 17.93
shared hash latch upgrades - wait 685 0.36 0.10
sorts (disk) 1 0.00 0.00
sorts (memory) 123,411 65.50 17.92
sorts (rows) 17,959,031 9,532.23 2,607.29
space was found by tune down 0 0.00 0.00
space was not found by tune down 0 0.00 0.00
sql area evicted 12,676 6.73 1.84
sql area purged 749 0.40 0.11
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 152 0.08 0.02
switch current to new buffer 2,977 1.58 0.43
table fetch by rowid 13,598,097 7,217.55 1,974.17
table fetch continued row 90,197 47.87 13.09
table scan blocks gotten 25,120,531 13,333.39 3,647.00
table scan rows gotten 401,863,671 213,299.81 58,342.58
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 2 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 212,060 112.56 30.79
total number of times SMON posted 1 0.00 0.00
transaction lock background get time 0 0.00 0.00
transaction lock background gets 536 0.28 0.08
transaction lock foreground requests 536 0.28 0.08
transaction lock foreground wait time 338 0.18 0.05
transaction rollbacks 2,988 1.59 0.43
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 18,535,680 9,838.30 2,691.01
user I/O wait time 204,821 108.71 29.74
user calls 1,372,077 728.27 199.20
user commits 6,286 3.34 0.91
user rollbacks 602 0.32 0.09
workarea executions - onepass 24 0.01 0.00
workarea executions - optimal 87,797 46.60 12.75
write clones created in background 0 0.00 0.00
write clones created in foreground 8 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 4.9E+13 4.9E+13
session cursor cache count 13,084,089 13,104,138
session uga memory 8.2E+14 8.2E+14
opened cursors current 41,317 113
workarea memory allocated 24,499 113,511
logons current 1,718 55
session uga memory max 5.1E+12 5.1E+12
session pga memory 2.6E+12 2.6E+12

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
DATA_OL 75,044 40 34.94 2.50 9,708 5 19,673 777.45
IDX_OL 37,973 20 47.29 1.00 13,555 7 18,620 871.97
DATA_BI 47,797 25 2.52 1.33 8 0 1,340 422.09
DATA_WF 10,270 5 74.42 1.02 1,850 1 12,933 813.36
DATA_P 6,198 3 34.02 13.04 635 0 26,185 992.40
IDX_WF 3,009 2 442.36 1.00 3,531 2 193,914 987.21
IDX_BI 6,525 3 2.10 1.00 3 0 4 40.00
TEMP 2,475 1 15.24 7.88 3,939 2 0 0.00
IDX_P 1,952 1 204.66 1.00 1,206 1 1,164 938.23
SYSTEM 2,401 1 14.48 1.22 73 0 103 186.02
IDX_SG 597 0 527.69 1.00 1,051 1 4,170 898.14
DATA_SG 374 0 676.68 1.00 1,144 1 7,632 406.96
UNDOTBS1 813 0 1505.15 1.00 674 0 17,429 951.62
SYSAUX 818 0 217.74 1.05 541 0 0 0.00
UNDOTBS2 40 0 82.00 1.00 1,305 1 371 5.34
DATA_YP 207 0 580.63 1.00 1,105 1 0 0.00
IDX_SCA7 650 0 970.66 1.00 566 0 7 7.14
IDX_BI1 530 0 16.92 1.00 0 0 9 684.44
DATA_BI10 473 0 2.73 8.27 0 0 0 0.00
IDX_SCA 90 0 369.22 1.00 54 0 0 0.00
DATA_BI9 79 0 44.68 4.87 6 0 640 274.94
IDX_SCA6 52 0 616.35 1.00 30 0 1 0.00
IDX_SCA5 41 0 580.24 1.00 31 0 0 0.00
IDX_SCA4 38 0 565.00 1.00 30 0 0 0.00
LOB_SCA 36 0 195.00 1.00 18 0 0 0.00
IDX_SCA3 26 0 486.54 1.00 18 0 0 0.00
DATA_BI2 35 0 747.43 15.26 1 0 0 0.00
DATA_BI11 28 0 5.71 1.00 0 0 0 0.00
DATA_SCA14 23 0 675.22 1.00 4 0 0 0.00
DATA_SCA2 14 0 331.43 1.00 7 0 28 17.14
DATA_SCA6 13 0 473.08 1.00 7 0 9 0.00
DATA_SCA10 13 0 450.00 1.00 6 0 0 0.00
DATA_SCA22 11 0 559.09 1.00 8 0 0 0.00
DATA_SCA8 13 0 342.31 1.00 6 0 12 7.50
DATA_BI8 17 0 4.71 1.00 1 0 1,861 543.16
DATA_SCA1 12 0 385.83 1.00 6 0 8 8.75
DATA_SCA11 11 0 454.55 1.00 7 0 0 0.00
DATA_SCA24 11 0 498.18 1.00 7 0 5 4.00
DATA_BI7 16 0 6.88 1.00 0 0 0 0.00
DATA_SCA13 10 0 454.00 1.00 6 0 0 0.00
DATA_SCA16 10 0 464.00 1.00 6 0 0 0.00
DATA_SCA18 9 0 655.56 1.00 6 0 0 0.00
IDX_SCA1 12 0 205.83 1.00 3 0 4 5.00
DATA_SCA3 11 0 215.45 1.00 3 0 15 8.00
DATA_SCA7 11 0 176.36 1.00 3 0 8 11.25
DATA_SCA9 9 0 482.22 1.00 5 0 0 0.00
IDX_SCA2 10 0 234.00 1.00 4 0 12 1.67
DATA_SCA12 7 0 812.86 1.00 6 0 0 0.00
DATA_SCA17 9 0 373.33 1.00 4 0 0 0.00
DATA_SCA15 8 0 456.25 1.00 4 0 0 0.00
DATA_SCA19 8 0 455.00 1.00 4 0 0 0.00
DATA_SCA23 8 0 370.00 1.00 4 0 0 0.00
DATA_SCA21 6 0 690.00 1.00 5 0 0 0.00
DATA_SCA5 9 0 155.56 1.00 2 0 0 0.00
DATA_SCA20 6 0 558.33 1.00 4 0 0 0.00
DATA_SCA4 5 0 758.00 1.00 4 0 0 0.00
DATA_BI6 3 0 1166.67 1.00 3 0 385 152.21
IDX_YP 0 0 0.00 0.00 5 0 0 0.00
DATA_BI12 1 0 10.00 1.00 3 0 28 469.29

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
DATA_BI /dev/rndmis_4g_003 1,820 1 3.73 1.56 0 0 0 0.00
DATA_BI /dev/rndmis_4g_025 2,811 1 2.61 1.36 3 0 0 0.00
DATA_BI /dev/rndmis_4g_030 2,165 1 1.60 1.43 0 0 0 0.00
DATA_BI /dev/rndmis_4g_037 1,547 1 2.05 1.61 0 0 0 0.00
DATA_BI /dev/rndmis_4g_038 920 0 3.09 2.05 0 0 0 0.00
DATA_BI /dev/rndmis_4g_043 831 0 1.78 1.44 0 0 0 0.00
DATA_BI /dev/rndmis_4g_044 798 0 1.78 1.46 0 0 0 0.00
DATA_BI /dev/rndmis_4g_046 863 0 2.18 1.56 0 0 0 0.00
DATA_BI /dev/rndmis_4g_048 857 0 1.76 1.56 0 0 0 0.00
DATA_BI /dev/rndmis_4g_049 976 1 2.51 1.41 0 0 0 0.00
DATA_BI /dev/rndmis_4g_050 1,055 1 2.20 1.34 0 0 28 499.29
DATA_BI /dev/rndmis_4g_053 1,053 1 2.13 1.34 1 0 13 193.08
DATA_BI /dev/rndmis_4g_057 1,076 1 2.11 1.34 1 0 24 565.83
DATA_BI /dev/rndmis_4g_060 1,070 1 1.93 1.39 0 0 25 578.80
DATA_BI /dev/rndmis_4g_061 1,065 1 1.88 1.34 0 0 12 438.33
DATA_BI /dev/rndmis_4g_067 1,130 1 2.20 1.33 0 0 16 521.25
DATA_BI /dev/rndmis_4g_068 1,143 1 4.37 1.21 0 0 19 690.00
DATA_BI /dev/rndmis_4g_081 1,222 1 2.58 1.27 0 0 44 708.86
DATA_BI /dev/rndmis_4g_101 1,281 1 3.49 1.28 0 0 220 330.05
DATA_BI /dev/rndmis_4g_102 1,267 1 5.16 1.29 0 0 108 480.74
DATA_BI /dev/rndmis_4g_106 1,266 1 2.73 1.29 0 0 109 463.67
DATA_BI /dev/rndmis_4g_113 1,276 1 3.50 1.29 0 0 161 506.21
DATA_BI /dev/rndmis_4g_114 1,274 1 3.31 1.28 0 0 2 0.00
DATA_BI /dev/rndmis_4g_115 1,302 1 3.15 1.32 2 0 181 257.40
DATA_BI /dev/rndmis_4g_116 1,246 1 5.91 1.30 0 0 186 554.95
DATA_BI /dev/rndmis_4g_127 1,260 1 3.10 1.29 0 0 126 175.24
DATA_BI /dev/rndmis_4g_133 1,048 1 1.81 1.35 0 0 66 525.76
DATA_BI /dev/rndmis_4g_134 1,950 1 2.35 1.20 0 0 0 0.00
DATA_BI /dev/rndmis_4g_135 1,918 1 2.14 1.18 0 0 0 0.00
DATA_BI /dev/rndmis_4g_146 1,820 1 1.69 1.20 0 0 0 0.00
DATA_BI /dev/rndmis_4g_152 1,047 1 2.02 1.33 0 0 0 0.00
DATA_BI /dev/rndmis_4g_155 787 0 5.40 1.31 1 0 0 0.00
DATA_BI /dev/rndmis_4g_156 775 0 1.38 1.30 0 0 0 0.00
DATA_BI /dev/rndmis_4g_160 779 0 1.26 1.31 0 0 0 0.00
DATA_BI /dev/rndmis_4g_163 783 0 1.28 1.30 0 0 0 0.00
DATA_BI /dev/rndmis_4g_164 1,681 1 1.55 1.14 0 0 0 0.00
DATA_BI /dev/rndmis_4g_167 2,635 1 0.88 1.09 0 0 0 0.00
DATA_BI10 /dev/rndmis_8g_021 473 0 2.73 8.27 0 0 0 0.00
DATA_BI11 /dev/rndmis_8g_022 28 0 5.71 1.00 0 0 0 0.00
DATA_BI12 /dev/rndmis_8g_023 1 0 10.00 1.00 3 0 28 469.29
DATA_BI2 /dev/rndmis_8g_008 35 0 747.43 15.26 1 0 0 0.00
DATA_BI6 /dev/rndmis_8g_015 3 0 1166.67 1.00 3 0 385 152.21
DATA_BI7 /dev/rndmis_8g_018 16 0 6.88 1.00 0 0 0 0.00
DATA_BI8 /dev/rndmis_8g_019 17 0 4.71 1.00 1 0 1,861 543.16
DATA_BI9 /dev/rndmis_8g_020 79 0 44.68 4.87 6 0 640 274.94
DATA_OL /dev/rndmis_4g_015 5,251 3 13.97 2.39 180 0 166 329.70
DATA_OL /dev/rndmis_4g_016 3,960 2 17.47 3.28 134 0 398 141.88
DATA_OL /dev/rndmis_4g_017 3,694 2 23.91 3.36 225 0 2,745 833.82
DATA_OL /dev/rndmis_4g_018 3,809 2 18.35 2.81 223 0 2,834 731.19
DATA_OL /dev/rndmis_4g_019 4,297 2 28.72 2.44 220 0 1,787 617.80
DATA_OL /dev/rndmis_4g_020 3,691 2 17.55 2.65 168 0 198 65.05
DATA_OL /dev/rndmis_4g_021 3,583 2 19.55 2.73 135 0 132 186.29
DATA_OL /dev/rndmis_4g_022 4,344 2 12.24 2.59 149 0 136 21.69
DATA_OL /dev/rndmis_4g_023 3,981 2 15.97 2.70 180 0 1,175 898.14
DATA_OL /dev/rndmis_4g_024 3,895 2 16.99 3.04 170 0 114 16.40
DATA_OL /dev/rndmis_4g_026 1,510 1 8.60 2.56 41 0 26 272.69
DATA_OL /dev/rndmis_4g_028 1,508 1 9.81 3.10 52 0 8 12.50
DATA_OL /dev/rndmis_4g_034 1,542 1 29.84 3.74 168 0 72 311.94
DATA_OL /dev/rndmis_4g_035 1,375 1 34.64 2.90 181 0 1,133 953.74
DATA_OL /dev/rndmis_4g_040 3,042 2 95.00 2.39 343 0 143 329.23
DATA_OL /dev/rndmis_4g_041 2,064 1 29.34 2.73 358 0 130 59.77
DATA_OL /dev/rndmis_4g_058 2,601 1 57.23 2.05 295 0 106 402.83
DATA_OL /dev/rndmis_4g_059 2,355 1 57.93 2.07 394 0 135 483.56
DATA_OL /dev/rndmis_4g_071 2,676 1 81.93 2.29 580 0 449 173.59
DATA_OL /dev/rndmis_4g_072 2,373 1 60.88 1.86 623 0 85 263.18
DATA_OL /dev/rndmis_4g_075 2,377 1 44.39 1.95 636 0 194 499.79
DATA_OL /dev/rndmis_4g_079 1,064 1 40.30 1.89 357 0 975 923.35
DATA_OL /dev/rndmis_4g_080 1,122 1 76.65 1.63 412 0 132 348.48
DATA_OL /dev/rndmis_4g_083 1,056 1 36.01 1.73 286 0 49 2.04
DATA_OL /dev/rndmis_4g_084 768 0 53.37 1.95 209 0 971 983.71
DATA_OL /dev/rndmis_4g_085 633 0 64.11 2.27 302 0 1,093 980.66
DATA_OL /dev/rndmis_4g_086 767 0 53.68 1.93 227 0 1,099 996.67
DATA_OL /dev/rndmis_4g_087 959 1 39.38 1.72 395 0 25 423.20
DATA_OL /dev/rndmis_4g_088 864 0 41.47 1.68 240 0 9 3.33
DATA_OL /dev/rndmis_4g_092 843 0 53.05 1.39 253 0 2,210 979.23
DATA_OL /dev/rndmis_4g_210 735 0 51.58 1.07 210 0 901 994.97
DATA_OL /dev/rndmis_4g_211 359 0 339.97 1.33 428 0 0 0.00
DATA_OL /dev/rndmis_4g_212 120 0 51.42 1.98 55 0 1 160.00
DATA_OL /dev/rndmis_4g_213 379 0 38.84 1.45 418 0 2 55.00
DATA_OL /dev/rndmis_8g_043 685 0 50.88 1.75 233 0 18 460.00
DATA_OL /dev/rndmis_8g_044 762 0 41.08 1.55 228 0 22 95.91
DATA_P /dev/rndmis_4g_004 329 0 26.35 6.64 52 0 3 3.33
DATA_P /dev/rndmis_4g_027 54 0 146.48 8.26 43 0 5 0.00
DATA_P /dev/rndmis_4g_031 99 0 76.77 7.36 27 0 2,137 998.18
DATA_P /dev/rndmis_4g_032 63 0 79.05 10.98 40 0 39 672.82
DATA_P /dev/rndmis_4g_033 115 0 4.52 13.77 17 0 11 337.27
DATA_P /dev/rndmis_4g_064 30 0 14.00 12.93 0 0 2,107 1007.58
DATA_P /dev/rndmis_4g_065 48 0 298.75 11.23 0 0 3 0.00
DATA_P /dev/rndmis_4g_074 24 0 37.08 11.63 7 0 0 0.00
DATA_P /dev/rndmis_4g_099 40 0 75.25 2.15 8 0 3 0.00
DATA_P /dev/rndmis_4g_104 29 0 5.17 13.69 10 0 0 0.00
DATA_P /dev/rndmis_4g_109 11 0 5.45 2.09 8 0 1 10.00
DATA_P /dev/rndmis_4g_121 1 0 10.00 1.00 3 0 8 985.00
DATA_P /dev/rndmis_4g_122 3 0 10.00 1.00 0 0 31 925.16
DATA_P /dev/rndmis_4g_123 13 0 10.77 1.00 0 0 13 767.69
DATA_P /dev/rndmis_4g_124 6 0 3.33 1.00 0 0 7 4.29
DATA_P /dev/rndmis_4g_128 1 0 0.00 1.00 0 0 0 0.00
DATA_P /dev/rndmis_4g_136 6 0 3.33 3.67 0 0 0 0.00
DATA_P /dev/rndmis_4g_137 0 0     1 0 0 0.00
DATA_P /dev/rndmis_4g_139 2 0 5.00 1.00 0 0 2 10.00
DATA_P /dev/rndmis_4g_141 2 0 15.00 1.00 2 0 3 6.67
DATA_P /dev/rndmis_4g_142 1 0 0.00 1.00 1 0 3 3.33
DATA_P /dev/rndmis_4g_143 80 0 2.00 2.46 2 0 0 0.00
DATA_P /dev/rndmis_4g_144 6 0 5.00 1.00 0 0 1 780.00
DATA_P /dev/rndmis_4g_148 367 0 3.92 14.99 18 0 2 0.00
DATA_P /dev/rndmis_4g_149 499 0 16.25 11.29 93 0 0 0.00
DATA_P /dev/rndmis_4g_150 356 0 20.67 15.42 19 0 1,070 998.99
DATA_P /dev/rndmis_4g_153 359 0 77.69 15.30 9 0 0 0.00
DATA_P /dev/rndmis_4g_154 377 0 99.18 14.62 61 0 4,611 946.24
DATA_P /dev/rndmis_4g_158 358 0 112.96 15.34 22 0 36 551.11
DATA_P /dev/rndmis_4g_159 402 0 23.23 13.83 1 0 1 10.00
DATA_P /dev/rndmis_4g_165 355 0 25.27 15.46 0 0 0 0.00
DATA_P /dev/rndmis_4g_166 367 0 11.17 14.99 12 0 0 0.00
DATA_P /dev/rndmis_4g_168 465 0 8.92 11.88 29 0 3 983.33
DATA_P /dev/rndmis_4g_169 320 0 6.41 14.06 0 0 0 0.00
DATA_P /dev/rndmis_4g_170 315 0 1.84 14.26 9 0 0 0.00
DATA_P /dev/rndmis_8g_035 41 0 160.98 1.00 51 0 16,042 1008.38
DATA_P /dev/rndmis_8g_038 47 0 26.17 1.00 24 0 27 545.93
DATA_P /dev/rndmis_8g_061 306 0 3.86 14.65 66 0 16 403.13
DATA_P /dev/rndmis_8g_062 301 0 3.36 14.90 0 0 0 0.00
DATA_SCA1 /dev/rndmis_4g_176 12 0 385.83 1.00 6 0 8 8.75
DATA_SCA10 /dev/rndmis_4g_187 13 0 450.00 1.00 6 0 0 0.00
DATA_SCA11 /dev/rndmis_4g_188 11 0 454.55 1.00 7 0 0 0.00
DATA_SCA12 /dev/rndmis_4g_189 7 0 812.86 1.00 6 0 0 0.00
DATA_SCA13 /dev/rndmis_4g_190 10 0 454.00 1.00 6 0 0 0.00
DATA_SCA14 /dev/rndmis_4g_191 23 0 675.22 1.00 4 0 0 0.00
DATA_SCA15 /dev/rndmis_4g_192 8 0 456.25 1.00 4 0 0 0.00
DATA_SCA16 /dev/rndmis_4g_193 10 0 464.00 1.00 6 0 0 0.00
DATA_SCA17 /dev/rndmis_4g_194 9 0 373.33 1.00 4 0 0 0.00
DATA_SCA18 /dev/rndmis_4g_195 9 0 655.56 1.00 6 0 0 0.00
DATA_SCA19 /dev/rndmis_4g_196 8 0 455.00 1.00 4 0 0 0.00
DATA_SCA2 /dev/rndmis_4g_177 14 0 331.43 1.00 7 0 28 17.14
DATA_SCA20 /dev/rndmis_4g_197 6 0 558.33 1.00 4 0 0 0.00
DATA_SCA21 /dev/rndmis_4g_198 6 0 690.00 1.00 5 0 0 0.00
DATA_SCA22 /dev/rndmis_4g_199 11 0 559.09 1.00 8 0 0 0.00
DATA_SCA23 /dev/rndmis_4g_200 8 0 370.00 1.00 4 0 0 0.00
DATA_SCA24 /dev/rndmis_4g_201 11 0 498.18 1.00 7 0 5 4.00
DATA_SCA3 /dev/rndmis_4g_178 11 0 215.45 1.00 3 0 15 8.00
DATA_SCA4 /dev/rndmis_4g_179 5 0 758.00 1.00 4 0 0 0.00
DATA_SCA5 /dev/rndmis_4g_180 9 0 155.56 1.00 2 0 0 0.00
DATA_SCA6 /dev/rndmis_4g_181 13 0 473.08 1.00 7 0 9 0.00
DATA_SCA7 /dev/rndmis_4g_182 11 0 176.36 1.00 3 0 8 11.25
DATA_SCA8 /dev/rndmis_4g_183 13 0 342.31 1.00 6 0 12 7.50
DATA_SCA9 /dev/rndmis_4g_186 9 0 482.22 1.00 5 0 0 0.00
DATA_SG /dev/rndmis_4g_009 352 0 696.25 1.00 1,027 1 7,006 438.78
DATA_SG /dev/rndmis_8g_013 11 0 322.73 1.00 94 0 626 50.85
DATA_SG /dev/rndmis_8g_014 11 0 404.55 1.00 23 0 0 0.00
DATA_WF /dev/rndmis_4g_005 2,943 2 157.21 1.05 1,180 1 10,137 902.04
DATA_WF /dev/rndmis_4g_036 4,657 2 41.12 1.02 383 0 1,380 278.52
DATA_WF /dev/rndmis_4g_107 2,670 1 41.24 1.00 287 0 1,416 699.77
DATA_YP /dev/rndmis_4g_007 207 0 580.63 1.00 1,105 1 0 0.00
IDX_BI /dev/rndmis_4g_001 392 0 2.73 1.00 0 0 1 160.00
IDX_BI /dev/rndmis_4g_039 131 0 1.30 1.00 0 0 3 0.00
IDX_BI /dev/rndmis_4g_045 137 0 1.39 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_047 133 0 2.03 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_051 142 0 1.90 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_052 135 0 2.74 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_054 147 0 1.84 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_055 141 0 1.63 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_056 136 0 1.40 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_062 155 0 1.68 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_063 123 0 1.63 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_066 2 0 10.00 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_073 15 0 6.00 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_082 27 0 5.56 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_100 138 0 3.41 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_103 151 0 1.66 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_105 171 0 2.46 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_117 219 0 2.51 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_118 204 0 1.62 1.00 2 0 0 0.00
IDX_BI /dev/rndmis_4g_119 305 0 1.84 1.00 1 0 0 0.00
IDX_BI /dev/rndmis_4g_120 396 0 2.73 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_132 351 0 1.99 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_147 258 0 2.05 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_151 276 0 2.03 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_157 275 0 2.73 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_161 263 0 1.44 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_162 283 0 2.19 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_171 259 0 1.54 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_172 285 0 3.23 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_174 498 0 1.87 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_175 377 0 1.27 1.00 0 0 0 0.00
IDX_BI1 /dev/rndmis_8g_016 530 0 16.92 1.00 0 0 9 684.44
IDX_OL /dev/rndmis_4g_011 2,929 2 19.92 1.00 154 0 3,170 913.81
IDX_OL /dev/rndmis_4g_012 3,043 2 16.26 1.00 153 0 2,036 794.97
IDX_OL /dev/rndmis_4g_013 3,081 2 17.90 1.00 181 0 742 399.51
IDX_OL /dev/rndmis_4g_014 3,350 2 21.77 1.00 338 0 479 97.54
IDX_OL /dev/rndmis_4g_029 2,173 1 48.09 1.00 692 0 188 117.39
IDX_OL /dev/rndmis_4g_069 2,846 2 21.46 1.00 367 0 60 308.17
IDX_OL /dev/rndmis_4g_070 2,670 1 25.21 1.00 320 0 84 296.31
IDX_OL /dev/rndmis_4g_076 2,614 1 22.76 1.00 246 0 48 108.13
IDX_OL /dev/rndmis_4g_077 1,325 1 55.48 1.00 801 0 3,439 993.79
IDX_OL /dev/rndmis_4g_078 1,263 1 49.71 1.00 781 0 36 766.39
IDX_OL /dev/rndmis_4g_089 1,247 1 54.02 1.00 721 0 19 284.21
IDX_OL /dev/rndmis_4g_090 1,563 1 46.54 1.00 836 0 41 372.44
IDX_OL /dev/rndmis_4g_091 1,440 1 64.46 1.00 923 0 1,021 990.59
IDX_OL /dev/rndmis_4g_093 1,153 1 89.95 1.00 612 0 259 720.69
IDX_OL /dev/rndmis_4g_094 1,205 1 89.05 1.00 872 0 50 73.60
IDX_OL /dev/rndmis_4g_095 1,079 1 60.66 1.00 446 0 29 138.28
IDX_OL /dev/rndmis_4g_096 965 1 41.47 1.00 433 0 1,856 989.88
IDX_OL /dev/rndmis_4g_097 928 0 142.58 1.00 783 0 4,423 976.06
IDX_OL /dev/rndmis_4g_098 868 0 225.47 1.00 1,527 1 469 823.16
IDX_OL /dev/rndmis_4g_108 537 0 166.54 1.00 722 0 39 521.54
IDX_OL /dev/rndmis_4g_110 409 0 58.61 1.00 297 0 7 2.86
IDX_OL /dev/rndmis_4g_111 479 0 75.14 1.00 436 0 12 145.00
IDX_OL /dev/rndmis_4g_112 445 0 71.03 1.00 288 0 28 223.57
IDX_OL /dev/rndmis_8g_024 195 0 179.44 1.00 356 0 4 10.00
IDX_OL /dev/rndmis_8g_025 166 0 226.69 1.00 270 0 81 821.73
IDX_P /dev/rndmis_4g_002 375 0 617.33 1.00 368 0 13 898.46
IDX_P /dev/rndmis_4g_130 338 0 128.73 1.00 210 0 30 194.00
IDX_P /dev/rndmis_4g_131 320 0 156.34 1.00 223 0 18 365.56
IDX_P /dev/rndmis_4g_173 336 0 124.58 1.00 239 0 23 305.65
IDX_P /dev/rndmis_4g_217 352 0 55.03 1.00 89 0 1,075 986.87
IDX_P /dev/rndmis_4g_218 231 0 57.23 1.00 77 0 5 22.00
IDX_SCA /dev/rndmis_4g_208 82 0 365.24 1.00 47 0 0 0.00
IDX_SCA /dev/rndmis_4g_219 8 0 410.00 1.00 7 0 0 0.00
IDX_SCA1 /dev/rndmis_4g_184 12 0 205.83 1.00 3 0 4 5.00
IDX_SCA2 /dev/rndmis_4g_185 10 0 234.00 1.00 4 0 12 1.67
IDX_SCA3 /dev/rndmis_4g_202 14 0 322.86 1.00 7 0 0 0.00
IDX_SCA3 /dev/rndmis_4g_220 12 0 677.50 1.00 11 0 0 0.00
IDX_SCA4 /dev/rndmis_4g_203 18 0 625.00 1.00 13 0 0 0.00
IDX_SCA4 /dev/rndmis_4g_221 20 0 511.00 1.00 17 0 0 0.00
IDX_SCA5 /dev/rndmis_4g_204 21 0 534.76 1.00 14 0 0 0.00
IDX_SCA5 /dev/rndmis_4g_222 20 0 628.00 1.00 17 0 0 0.00
IDX_SCA6 /dev/rndmis_4g_205 36 0 658.06 1.00 16 0 1 0.00
IDX_SCA6 /dev/rndmis_4g_223 16 0 522.50 1.00 14 0 0 0.00
IDX_SCA7 /dev/rndmis_8g_011 501 0 1026.77 1.00 441 0 5 10.00
IDX_SCA7 /dev/rndmis_8g_034 149 0 782.01 1.00 125 0 2 0.00
IDX_SG /dev/rndmis_4g_010 597 0 527.69 1.00 1,051 1 4,170 898.14
IDX_WF /dev/rndmis_4g_006 2,182 1 483.62 1.00 2,428 1 188,927 991.19
IDX_WF /dev/rndmis_4g_042 827 0 333.48 1.00 1,103 1 4,987 836.39
IDX_YP /dev/rndmis_4g_008 0 0     5 0 0 0.00
LOB_SCA /dev/rndmis_8g_001 1 0 0.00 1.00 0 0 0 0.00
LOB_SCA /dev/rndmis_8g_002 1 0 10.00 1.00 0 0 0 0.00
LOB_SCA /dev/rndmis_8g_003 1 0 10.00 1.00 0 0 0 0.00
LOB_SCA /dev/rndmis_8g_004 1 0 10.00 1.00 0 0 0 0.00
LOB_SCA /dev/rndmis_8g_005 1 0 10.00 1.00 0 0 0 0.00
LOB_SCA /dev/rndmis_8g_006 16 0 9.38 1.00 0 0 0 0.00
LOB_SCA /dev/rndmis_8g_017 1 0 0.00 1.00 0 0 0 0.00
LOB_SCA /dev/rndmis_8g_026 4 0 975.00 1.00 7 0 0 0.00
LOB_SCA /dev/rndmis_8g_028 1 0 0.00 1.00 0 0 0 0.00
LOB_SCA /dev/rndmis_8g_029 1 0 10.00 1.00 0 0 0 0.00
LOB_SCA /dev/rndmis_8g_039 1 0 680.00 1.00 2 0 0 0.00
LOB_SCA /dev/rndmis_8g_040 5 0 444.00 1.00 9 0 0 0.00
LOB_SCA /dev/rndmis_8g_063 1 0 10.00 1.00 0 0 0 0.00
LOB_SCA /dev/rndmis_8g_064 1 0 10.00 1.00 0 0 0 0.00
SYSAUX /dev/rndmis_4g_225 101 0 66.14 1.00 69 0 0 0.00
SYSAUX /dev/rsysaux_4g 717 0 239.09 1.05 472 0 0 0.00
SYSTEM /dev/rsystem_4g 2,401 1 14.48 1.22 73 0 103 186.02
TEMP /dev/rndmis_8g_056 134 0 89.78 1.00 3,027 2 0  
TEMP /dev/rtemp01_16g 279 0 4.77 17.34 268 0 0  
TEMP /dev/rtemp02_16g 2,062 1 11.81 7.04 644 0 0  
UNDOTBS1 /dev/rndmis_8g_030 123 0 1122.68 1.00 79 0 86 136.74
UNDOTBS1 /dev/rndmis_8g_031 51 0 1147.45 1.00 50 0 7 0.00
UNDOTBS1 /dev/rndmis_8g_036 57 0 1126.32 1.00 44 0 132 464.92
UNDOTBS1 /dev/rundo_1a_16g 249 0 1634.50 1.00 224 0 2,198 873.57
UNDOTBS1 /dev/rundo_1b_16g 333 0 1669.34 1.00 277 0 15,006 972.45
UNDOTBS2 /dev/rndmis_8g_032 7 0 45.71 1.00 67 0 1 110.00
UNDOTBS2 /dev/rndmis_8g_033 3 0 3.33 1.00 35 0 54 5.74
UNDOTBS2 /dev/rndmis_8g_037 9 0 317.78 1.00 116 0 50 5.80
UNDOTBS2 /dev/rundo_2a_16g 11 0 4.55 1.00 524 0 143 4.20
UNDOTBS2 /dev/rundo_2b_16g 10 0 4.00 1.00 563 0 123 5.45

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 2,727,688 99 65,774,966 394,536 44,842 0 0 307,134


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 12 16550 81274 578222 5640120 578222  
E 0 5 2684 16954 420866 5640120 420866  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 2,272 0.10 272,214 3.08 11,307,090,167
D 4,544 0.20 544,428 2.60 9,567,465,313
D 6,816 0.30 816,642 2.22 8,139,226,115
D 9,088 0.40 1,088,856 1.91 7,007,409,758
D 11,360 0.50 1,361,070 1.66 6,111,543,229
D 13,632 0.60 1,633,284 1.47 5,398,329,247
D 15,904 0.70 1,905,498 1.31 4,827,509,321
D 18,176 0.80 2,177,712 1.19 4,367,482,167
D 20,448 0.90 2,449,926 1.09 3,993,119,342
D 22,720 1.00 2,722,140 1.00 3,684,608,225
D 22,816 1.00 2,733,642 1.00 3,673,704,092
D 24,992 1.10 2,994,354 0.93 3,426,541,211
D 27,264 1.20 3,266,568 0.87 3,207,133,245
D 29,536 1.29 3,538,782 0.82 3,017,134,867
D 31,808 1.39 3,810,996 0.78 2,849,362,470
D 34,080 1.49 4,083,210 0.73 2,698,136,838
D 36,352 1.59 4,355,424 0.70 2,558,852,241
D 38,624 1.69 4,627,638 0.66 2,427,841,083
D 40,896 1.79 4,899,852 0.63 2,302,256,044
D 43,168 1.89 5,172,066 0.59 2,179,869,119
D 45,440 1.99 5,444,280 0.56 2,058,936,536

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
98.37 10,253 170

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 6,144 1,817 5,099.21 1.12 0.02 100.00 0.00 629,140
E 6,144 4,953 764.34 0.00 0.00 0.00 0.00 629,140

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 72,508 72,508 0 0
64K 128K 2,294 2,294 0 0
128K 256K 1,197 1,197 0 0
256K 512K 1,526 1,526 0 0
512K 1024K 9,865 9,865 0 0
1M 2M 228 228 0 0
2M 4M 169 169 0 0
4M 8M 25 1 24 0
8M 16M 11 11 0 0
16M 32M 2 2 0 0
32M 64M 1 1 0 0
64M 128M 5 5 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
768 0.13 63,377,508.94 39,987,424.18 61.00 671,343
1,536 0.25 63,377,508.94 39,476,610.13 62.00 658,173
3,072 0.50 63,377,508.94 24,420,852.20 72.00 343,910
4,608 0.75 63,377,508.94 7,954,266.78 89.00 35,367
6,144 1.00 63,377,508.94 2,970,528.89 96.00 2,384
7,373 1.20 63,377,508.94 2,778,555.77 96.00 2,187
8,602 1.40 63,377,508.94 2,778,457.02 96.00 2,026
9,830 1.60 63,377,508.94 2,778,457.02 96.00 1,790
11,059 1.80 63,377,508.94 2,778,432.25 96.00 1,470
12,288 2.00 63,377,508.94 2,778,421.43 96.00 1,308
18,432 3.00 63,377,508.94 2,778,358.20 96.00 859
24,576 4.00 63,377,508.94 2,778,176.08 96.00 79
36,864 6.00 63,377,508.94 2,777,546.25 96.00 0
49,152 8.00 63,377,508.94 2,777,546.25 96.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
2,576 0.69 442 30,749 104,824,926 1.00 776,544 1.12 2,319,222
2,960 0.79 817 52,672 104,853,193 1.00 748,277 1.08 2,327,767
3,344 0.90 1,199 77,962 104,881,067 1.00 720,403 1.04 2,336,294
3,728 1.00 1,581 102,098 104,908,650 1.00 692,820 1.00 2,344,795
4,112 1.10 1,964 125,952 104,935,850 1.00 665,620 0.96 2,353,258
4,496 1.21 2,347 153,844 104,962,627 1.00 638,843 0.92 2,361,675
4,880 1.31 2,730 180,789 104,989,000 1.00 612,470 0.88 2,370,047
5,264 1.41 3,112 206,341 105,014,976 1.00 586,494 0.85 2,378,369
5,648 1.52 3,495 234,613 105,040,544 1.00 560,926 0.81 2,386,639
6,032 1.62 3,878 264,980 105,065,790 1.00 535,680 0.77 2,394,865
6,416 1.72 4,261 291,139 105,090,770 1.00 510,700 0.74 2,403,055
6,800 1.82 4,644 319,035 105,115,518 1.00 485,952 0.70 2,411,213
7,184 1.93 5,027 347,073 105,140,070 1.00 461,400 0.67 2,419,343
7,568 2.03 5,410 376,311 105,164,456 1.00 437,014 0.63 2,427,449

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
6,656 0.25 38,577,806 12,122,830,189
13,312 0.50 26,657,934 7,512,708,790
19,968 0.75 19,497,564 4,682,493,215
26,624 1.00 16,895,636 3,673,696,230
33,280 1.25 15,298,998 3,055,045,785
39,936 1.50 14,520,110 2,743,516,345
46,592 1.75 14,337,637 2,602,813,779
53,248 2.00 14,334,258 2,207,524,065

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 1.00 0 0 0 0
32 2.00 0 0 0 0
48 3.00 0 0 0 0
64 4.00 0 0 0 0
80 5.00 0 0 0 0
96 6.00 0 0 0 0
112 7.00 0 0 0 0
128 8.00 0 0 0 0
144 9.00 0 0 0 0
160 10.00 0 0 0 0
176 11.00 0 0 0 0
192 12.00 0 0 0 0
208 13.00 0 0 0 0
224 14.00 0 0 0 0
240 15.00 0 0 0 0
256 16.00 0 0 0 0
272 17.00 0 0 0 0
288 18.00 0 0 0 0
304 19.00 0 0 0 0
320 20.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 288,768 269,363 933
undo block 15,508 14,633 944
undo header 2,314 1,953 844
1st level bmb 133 36 267
2nd level bmb 90 9 105
segment header 32 2 75

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 742 696 3 711 12,498 17,578.44
US-Undo Segment 15,114 15,106 0 14,950 11,809 789.90
CF-Controlfile Transaction 18,139 18,127 12 43 2,800 65,110.47
JS-Job Scheduler (job recov lock) 1 1 0 1 905 905,200.00
IR-Instance Recovery 2 2 0 2 824 411,921.00
TX-Transaction (index contention) 218 206 0 205 775 3,781.79
TH-Threshold Chain (metric threshold evaluation) 11 11 0 2 268 134,243.50
HW-Segment High Water Mark 1,489 1,488 1 443 98 220.76
TQ-Queue table enqueue (INI contention) 24 24 0 2 7 3,593.50
TT-Tablespace 1,762 1,762 0 96 6 65.45
WF-AWR Flush 30 30 0 14 3 197.36
TO-Temp Object 313 313 0 40 3 66.95
TM-DML 20,146 20,143 0 683 1 2.02
PS-PX Process Reservation 675 673 2 96 1 13.72
TX-Transaction 12,930 12,929 1 356 1 2.76
SQ-Sequence Cache 43 43 0 17 0 24.12
PR-Process Startup 147 147 0 4 0 75.25
FB-Format Block 48 48 0 29 0 3.83
RT-Redo Thread 2 2 0 2 0 5.00
JQ-Job Queue 4 1 3 1 0 2.00
PG-Global Parameter 2 2 0 1 0 1.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 1 0 1 1 0 1.00
TX-Transaction (allocate ITL entry) 1 1 0 1 0 1.00
TA-Instance Undo 4 4 0 3 0 0.00
PE-Parameter 4 4 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
4 6.44 14,898 609 121 0/11340.8 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
27-Mar 16:56 0 0 0 0 0 0/0 0/0/0/0/0/0
27-Mar 16:46 3,121 6,081 609 85 11,341 0/0 0/0/0/0/0/0
27-Mar 16:36 3,322 8,817 304 121 11,328 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 1,154 0.00   0 0  
AWR Alerted Metric Element list 28,285 0.00   0 0  
Consistent RBA 8,552 0.01 0.00 0 0  
FAL request queue 22 0.00   0 0  
FAL subheap alocation 22 0.00   0 0  
FIB s.o chain latch 4 0.00   0 0  
FOB s.o list latch 65,553 1.67 0.31 80 0  
JS broadcast add buf latch 175 0.00   0 0  
JS broadcast drop buf latch 175 0.00   0 0  
JS broadcast load blnc latch 150 0.00   0 0  
JS mem alloc latch 2 0.00   0 0  
JS queue access latch 2 0.00   0 0  
JS queue state obj latch 6,300 0.00   0 0  
KCL gc element parent latch 6,604,679 0.10 2.10 3150 69,698 0.04
KJC destination ctx free list 51 0.00   0 0  
KJC message pool free list 71,688 1.47 1.11 104 13,389 3.02
KJCT flow control latch 982,542 0.01 0.00 0 0  
KMG MMAN ready and startup request latch 367 0.00   0 0  
KMG resize request state object freelist 2 0.00   0 0  
KSXR large replies 4 0.00   0 0  
KTF sga latch 13,332 0.00   0 279 0.36
KWQMN job cache list latch 243 0.00   0 0  
KWQMN to-be-Stopped Buffer list Latch 1 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 17 0.00
Memory Management Latch 23 0.00   0 366 0.00
OS process 16,638 0.00   0 0  
OS process allocation 10,174 3.71 16.74 1788 0  
OS process: request allocation 8,970 1.63 2.47 84 0  
PL/SQL warning settings 16,577 0.00   0 0  
SGA IO buffer pool latch 13,004 0.26 4.26 36 13,005 2.11
SQL memory manager latch 42 52.38 0.73 0 310 0.00
SQL memory manager workarea list latch 132,923 0.02 0.00 0 0  
Shared B-Tree 37 0.00   0 0  
active checkpoint queue latch 14,192 0.44 0.03 0 0  
active service list 17,694 2.72 0.21 0 6,831 0.04
archive control 25 0.00   0 0  
archive process latch 360 0.00   0 0  
begin backup scn array 883 0.00   0 0  
buffer pool 1 0.00   0 0  
business card 36 0.00   0 0  
cache buffer handles 66,048 0.08 0.75 0 0  
cache buffers chains 117,545,179 1.87 0.01 2413 1,738,919 0.99
cache buffers lru chain 688,613 0.18 0.87 164 1,229,156 0.38
cache table scan latch 0     0 19,158 0.10
channel handle pool latch 7,878 4.82 5.33 566 0  
channel operations parent latch 1,329,106 0.00 0.00 0 0  
checkpoint queue latch 451,157 0.02 0.86 6 35,821 0.02
client/application info 18,468 0.04 0.00 0 0  
commit callback allocation 184 0.00   0 0  
compile environment latch 2,964 0.00   0 0  
database property service latch 3 0.00   0 0  
dml lock allocation 40,405 0.27 0.00 0 0  
dummy allocation 7,495 2.87 1.70 79 0  
enqueue hash chains 404,318 0.62 0.05 7 52,079 0.03
enqueues 622,994 0.39 0.00 0 0  
error message lists 352 3.41 0.00 0 0  
event group latch 3,718 0.11 0.00 0 0  
file cache latch 1,697 0.00   0 0  
gcs domain validate latch 203 0.00   0 0  
gcs drop object freelist 1 0.00   0 0  
gcs opaque info freelist 380,980 0.13 0.00 0 0  
gcs partitioned table hash 22,724,309 0.00   0 88,805 0.00
gcs remastering latch 982,771 0.00 0.00 0 412 0.00
gcs resource freelist 3,303,939 0.00 0.00 0 100,257 0.00
gcs resource hash 9,580,556 0.12 0.58 1522 52 0.00
gcs resource scan list 104 0.00   0 0  
gcs resource validate list 460,534 0.09 0.08 0 0  
gcs shadows freelist 1,596,083 0.00 0.00 0 189,616 0.00
generalized trace enabling latch 1 0.00   0 0  
ges caches resource lists 100,692 0.25 1.20 72 71,542 0.17
ges deadlock list 6,562 0.06 0.00 0 694 0.00
ges domain table 277,620 0.00 0.20 0 0  
ges enqueue table freelist 354,571 0.01 0.31 3 0  
ges group table 389,333 0.02 0.00 0 0  
ges process hash list 73,278 0.00   0 0  
ges process parent latch 768,281 0.00 0.48 3 0  
ges process table freelist 7,882 1.10 2.39 51 0  
ges resource hash list 1,307,440 0.74 0.11 141 202,898 0.01
ges resource scan list 30,929 0.38 0.00 0 0  
ges resource table freelist 107,817 0.03 0.68 4 0  
ges synchronous data 41 2.44 0.00 0 5,058 0.02
ges timeout list 36,143 0.02 0.00 0 135,754 0.00
global KZLD latch for mem in SGA 2,479 0.00   0 0  
global hanganlyze operation 89 0.00   0 0  
global tx hash mapping 35,114 0.00   0 15 0.00
hash table column usage latch 1,299 0.15 0.00 0 390,314 0.00
hash table modification latch 126 0.00   0 0  
internal temp table object number allocation latc 5 0.00   0 0  
interrupt manipulation 721 3.19 0.00 0 0  
intra txn parallel recovery 5,897 0.27 0.00 0 0  
job workq parent latch 0     0 2 0.00
job_queue_processes parameter latch 13 0.00   0 0  
kks stats 91,352 2.11 3.27 1525 0  
kokc descriptor allocation latch 172,732 0.00   0 0  
ksuosstats global area 47 0.00   0 0  
ktm global data 19 0.00   0 0  
kwqbsn:qsga 36 0.00   0 0  
lgwr LWN SCN 8,574 0.06 0.00 0 0  
library cache 2,722,513 1.22 9.35 87777 83,327 3.67
library cache load lock 9,195 0.29 0.00 0 99 0.00
library cache lock 5,131,156 0.29 0.40 1641 0  
library cache lock allocation 34,956 0.13 0.76 1 0  
library cache pin 733,600 0.35 0.00 0 141 0.00
library cache pin allocation 15,925 0.00   0 0  
list of block allocation 2,809 0.04 29.00 8 0  
loader state object freelist 2,768 0.04 0.00 0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 6,411 0.00   0 95 0.00
message pool operations parent latch 237 0.00   0 0  
messages 271,952 0.12 0.43 28 0  
mostly latch-free SCN 9,084 4.91 0.00 0 0  
multiblock read objects 99,441 0.06 1.69 25 0  
name-service memory objects 5,073 0.02 0.00 0 6 16.67
name-service namespace bucket 20,869 0.00   0 0  
name-service namespace objects 8 0.00   0 0  
name-service pending queue 2,718 0.00   0 0  
name-service request 264 0.00   0 0  
name-service request queue 21,273 0.00   0 0  
ncodef allocation latch 199 0.00   0 0  
object queue header heap 16,515 0.01 0.00 0 14,697 0.01
object queue header operation 1,650,747 0.11 0.79 164 1,916 0.84
object stats modification 60 0.00   0 0  
parallel query alloc buffer 1,989 7.29 0.74 1 0  
parallel query stats 206 1.46 0.00 0 0  
parallel txn reco latch 8,353 0.06 0.00 0 0  
parameter list 23,989 2.44 0.00 0 0  
parameter table management 7,583 0.04 1.00 0 0  
post/wait queue 153,002 0.04 0.00 0 72,598 0.03
process allocation 23,402 3.08 606.74 4355 3,361 10.62
process group creation 7,892 0.29 0.00 0 0  
process queue 9,431 0.00   0 0  
process queue reference 822,215 0.05 0.00 0 14,927 1.92
qmn state object latch 4 0.00   0 0  
qmn task queue latch 233 17.17 0.00 0 0  
query server freelists 843 1.54 0.00 0 0  
query server process 130 2.31 4.67 3 1 0.00
queued dump request 7,422 0.00   0 0  
redo allocation 43,714 0.29 1.43 26 129,360 1.01
redo copy 0     0 129,610 1.98
redo writing 41,088 0.09 5.16 55 0  
reg$ timeout service time 1 0.00   0 0  
resmgr group change latch 2,658 0.00   0 0  
resmgr:active threads 7,484 0.00   0 0  
resmgr:actses change group 2,641 0.00   0 0  
resmgr:free threads list 7,483 2.29 1.25 59 0  
resmgr:resource group CPU method 1,746 0.11 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 5,337,337 3.69 0.17 9224 19,091 5.39
rules engine aggregate statistics 28 0.00   0 0  
rules engine rule set statistics 156 0.00   0 0  
sequence cache 13,343 6.98 0.00 0 0  
session allocation 881,511 0.67 5.52 15447 0  
session idle bit 3,189,928 0.00 0.01 0 0  
session state list latch 6,404 8.57 0.00 0 0  
session switching 27,961 0.23 51.63 965 0  
session timer 916 0.00   0 0  
shared pool 1,274,319 1.36 6.26 30680 0  
shared pool simulator 110,770 0.12 6.00 213 0  
simulator hash latch 3,419,806 0.00 0.89 10 0  
simulator lru latch 291 0.69 2.00 1 3,387,309 2.70
slave class 5 0.00   0 0  
slave class create 22 4.55 1.00 0 0  
sort extent pool 3,819 0.55 4.81 21 0  
state object free list 2 0.00   0 0  
statistics aggregation 983 0.00   0 0  
temp lob duration state obj allocation 363 0.00   0 0  
temporary table state object allocation 314 0.00   0 0  
threshold alerts latch 586 0.00   0 0  
trace latch 857 16.69 8.87 360 0  
transaction allocation 8,994 0.00   0 0  
transaction branch allocation 33,129 0.02 0.00 0 0  
undo global data 239,586 0.17 0.00 0 33 0.00
user lock 13,644 20.88 20.47 38325 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 117,545,179 2,197,268 27,063 2,179,209 0 0 0
row cache objects 5,337,337 196,719 33,396 194,303 0 0 0
library cache 2,722,513 33,104 309,504 14,358 0 0 0
shared pool 1,274,319 17,351 108,663 5,853 0 0 0
library cache lock 5,131,156 14,731 5,881 14,224 0 0 0
gcs resource hash 9,580,556 11,419 6,647 9,252 0 0 0
ges resource hash list 1,307,440 9,657 1,089 8,915 0 0 0
KCL gc element parent latch 6,604,679 6,671 13,976 1,923 0 0 0
session allocation 881,511 5,924 32,703 3,512 0 0 0
user lock 13,644 2,849 58,323 533 0 0 0
library cache pin 733,600 2,586 1 2,585 0 0 0
enqueue hash chains 404,318 2,496 115 2,385 0 0 0
enqueues 622,994 2,452 8 2,444 0 0 0
kks stats 91,352 1,925 6,299 262 0 0 0
object queue header operation 1,650,747 1,858 1,469 1,083 0 0 0
cache buffers lru chain 688,613 1,266 1,100 675 0 0 0
FOB s.o list latch 65,553 1,093 339 1,007 0 0 0
KJC message pool free list 71,688 1,056 1,171 186 0 0 0
process allocation 23,402 720 436,850 43 0 0 0
session state list latch 6,404 549 2 547 0 0 0
active service list 17,694 481 101 384 0 0 0
gcs resource validate list 460,534 398 30 368 0 0 0
channel handle pool latch 7,878 380 2,024 58 0 0 0
OS process allocation 10,174 377 6,310 21 0 0 0
messages 271,952 329 142 275 0 0 0
ges caches resource lists 100,692 252 302 162 0 0 0
dummy allocation 7,495 215 365 109 0 0 0
resmgr:free threads list 7,483 171 214 156 0 0 0
OS process: request allocation 8,970 146 361 28 0 0 0
parallel query alloc buffer 1,989 145 107 41 0 0 0
session idle bit 3,189,928 143 1 142 0 0 0
trace latch 857 143 1,269 78 0 0 0
shared pool simulator 110,770 138 828 17 0 0 0
redo allocation 43,714 127 181 25 0 0 0
checkpoint queue latch 451,157 98 84 31 0 0 0
ges process table freelist 7,882 87 208 41 0 0 0
session switching 27,961 65 3,356 11 0 0 0
active checkpoint queue latch 14,192 63 2 62 0 0 0
multiblock read objects 99,441 58 98 39 0 0 0
cache buffer handles 66,048 55 41 14 0 0 0
simulator hash latch 3,419,806 46 41 37 0 0 0
ges enqueue table freelist 354,571 45 14 39 0 0 0
library cache lock allocation 34,956 45 34 11 0 0 0
redo writing 41,088 38 196 22 0 0 0
SGA IO buffer pool latch 13,004 34 145 5 0 0 0
ges resource table freelist 107,817 28 19 22 0 0 0
ges process parent latch 768,281 27 13 25 0 0 0
SQL memory manager latch 42 22 16 6 0 0 0
sort extent pool 3,819 21 101 12 0 0 0
ges domain table 277,620 10 2 8 0 0 0
parameter table management 7,583 3 3 0 0 0 0
query server process 130 3 14 0 0 0 0
simulator lru latch 291 2 4 0 0 0 0
list of block allocation 2,809 1 29 0 0 0 0
slave class create 22 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
FOB s.o list latch ksfd_allfob 0 227 272
FOB s.o list latch ksfd_fobd 0 112 67
KCL gc element parent latch kclnfndnewm 0 9,842 3,782
KCL gc element parent latch kclrwrite 0 1,481 1,201
KCL gc element parent latch kclnfnd 0 1,062 511
KCL gc element parent latch kclfwrite1 0 526 213
KCL gc element parent latch kclplz 0 415 706
KCL gc element parent latch kclgcr 0 237 158
KCL gc element parent latch kclbla 0 209 118
KCL gc element parent latch kclwrt 0 130 35
KCL gc element parent latch kclzcl 0 86 88
KCL gc element parent latch kcl_get_le_latch 0 79 0
KCL gc element parent latch kclnfndnew 0 44 0
KCL gc element parent latch kclulb 0 42 6,449
KCL gc element parent latch kcllwr 0 40 3
KCL gc element parent latch kclrbast 0 7 0
KCL gc element parent latch kclfwrite2 0 4 0
KCL gc element parent latch kclpto_3 0 4 1
KCL gc element parent latch KCLUNLNK 0 3 714
KCL gc element parent latch kclchkping 0 1 0
KCL gc element parent latch kclebs 0 1 128
KCL gc element parent latch kclexpand 0 1 4
KCL gc element parent latch kclgrantlk 0 1 68
KCL gc element parent latch kclrdone 0 1 0
KJC message pool free list kjcsmpav: allocate a msg buffer 0 1,158 1,171
KJC message pool free list kjcspfmbq: free vector of msg buffers 0 13 0
OS process allocation kso_new_process:2 0 6,302 6,215
OS process allocation ksosp_scrub:1 0 4 89
OS process allocation kso_delete_process:1 0 2 2
OS process: request allocation kso_new_process 0 324 330
OS process: request allocation ksoreqholder_delete 0 37 31
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 126 0
SGA IO buffer pool latch ksfd_free_sgabuffer 0 19 145
SQL memory manager latch qesmmIQueryRefreshBound 0 16 16
active checkpoint queue latch kcbbacq: scan active checkpoints 0 2 2
active service list kswslogon: session login 0 186 186
active service list kswslogon: session logout 0 105 98
cache buffer handles kcbzgs 0 41 41
cache buffers chains kcbgtcr: kslbegin excl 0 47,522 50,612
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 7,848 3,160
cache buffers chains kcbzwb 0 2,941 2,839
cache buffers chains kcbrls: kslbegin 0 2,702 5,305
cache buffers chains kcbgtcr: fast path 0 1,039 616
cache buffers chains kclcls_3 0 913 18
cache buffers chains kcbgtcr: kslbegin shared 0 449 337
cache buffers chains kcbget: pin buffer 0 447 223
cache buffers chains kcbzgb: scan from tail. nowait 0 350 0
cache buffers chains kcbzib: multi-block read: nowait 0 155 0
cache buffers chains kcbgcur: kslbegin 0 115 110
cache buffers chains kcbbxsv 0 71 69
cache buffers chains kclbla 0 65 23
cache buffers chains kcbbic1 0 53 1
cache buffers chains kcbzib: finish free bufs 0 49 34
cache buffers chains kcbchg: kslbegin: call CR func 0 39 1,105
cache buffers chains kcbgtcr 0 38 8
cache buffers chains kclebs_1 0 35 27
cache buffers chains kclwrt 0 31 1
cache buffers chains kcbnew: new latch again 0 23 1
cache buffers chains kcbgcur: buf pinned 0 20 9
cache buffers chains kclwcrs 0 20 17
cache buffers chains kcbso1: set no access 0 19 14
cache buffers chains kclgrantlk 0 15 0
cache buffers chains kclexpandlock 0 9 5
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 7 0
cache buffers chains kcbsod1 0 5 12
cache buffers chains kcbnlc 0 4 97
cache buffers chains kclgrantlk_1 0 3 0
cache buffers chains kclswrite 0 3 0
cache buffers chains kcbesc: escalate 0 2 1
cache buffers chains kclclaim 0 2 0
cache buffers chains kcbibr 0 1 0
cache buffers chains kclpto_1 0 1 1
cache buffers lru chain kcbzgb: wait - one set in buffer pool 0 408 129
cache buffers lru chain kcbzgws 0 260 0
cache buffers lru chain kcbbxsv: move to being written 0 153 287
cache buffers lru chain kcbo_link_q 0 81 3
cache buffers lru chain kclmvreqbg 0 78 98
cache buffers lru chain kcbbic2 0 27 142
cache buffers lru chain H_MK_PI_CR_BG 0 24 0
cache buffers lru chain kcbzgb: posted for free bufs 0 13 236
cache buffers lru chain kcbw_quiesce_granule 0 11 1
cache buffers lru chain kcbzfw 0 9 24
cache buffers lru chain kcbibr 0 8 31
cache buffers lru chain kcbzib: move stale buffers 0 8 53
cache buffers lru chain kcbbwlru 0 7 28
cache buffers lru chain kclrecfree 0 4 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 3 0
cache buffers lru chain kclmvreq 0 2 22
cache buffers lru chain kcbo_ivd_proc 0 1 39
cache buffers lru chain kcbrenounce 0 1 0
cache buffers lru chain kcbzswcu 0 1 0
cache buffers lru chain kclmergepi 0 1 0
channel handle pool latch ksrchconnect() 0 2,078 1,880
checkpoint queue latch kcbkubc 0 64 56
checkpoint queue latch kclmergepi_3 0 15 1
checkpoint queue latch kcbk_get_cqlt_nowait2 0 3 0
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 1 17
checkpoint queue latch kcbkllrba: compute lowest lrba 0 1 10
cost function kzulgt: find user res 0 104,525 56,654
cost function kzulrl 0 26,213 74,097
dummy allocation ktcscnfy 0 365 365
enqueue hash chains ksqgtl3 0 105 111
enqueue hash chains ksqrcl 0 6 4
enqueue hash chains ksqcmi: if lk mode requested 0 3 0
enqueue hash chains ksqcmi: if lk mode not requested 0 1 0
enqueues ksqies 0 5 7
enqueues ksqdel 0 1 0
enqueues ksqgel: create enqueue 0 1 1
enqueues ksqgtl2 0 1 0
event range base latch No latch 0 262 1,707
gcs resource hash kjbmpclose 0 2,766 81
gcs resource hash kjbcropen 0 1,046 977
gcs resource hash kjblocalfile_nolock 0 862 1,041
gcs resource hash kclzcl 0 646 270
gcs resource hash kjbmpopen 0 386 60
gcs resource hash kjbcropen:affinity 0 244 1,544
gcs resource hash kclrwrite 0 189 967
gcs resource hash kjbcrconvert 0 99 283
gcs resource hash kjbassume 0 90 247
gcs resource hash kjbconvert 0 53 491
gcs resource hash kclgrantlk_1 0 42 43
gcs resource hash kclfwrite1 0 39 249
gcs resource hash kjbopen 0 35 53
gcs resource hash kjbmpwrite 0 33 2
gcs resource hash kjbcrcomplete 0 31 87
gcs resource hash kjbopen:affinity 0 28 128
gcs resource hash kjbmpconvert 0 15 18
gcs resource hash kjbrwrdone reget 0 11 0
gcs resource hash kclpdc 0 10 34
gcs resource hash kjbrrcfwst 0 9 1
gcs resource hash kjblpast 0 4 1
gcs resource hash kclcfusion 0 2 0
gcs resource hash kclrwrite_1 0 1 0
gcs resource hash kclrwrite_3 0 1 0
gcs resource hash kjblpbast 0 1 30
gcs resource hash kjblpwreq 0 1 0
gcs resource hash kjbmdowncvt 0 1 0
gcs resource hash kjbmpcreatepi 0 1 0
gcs resource hash kjbmpflushpi 0 1 0
gcs resource validate list enq res to validate list 0 30 30
ges domain table kjdmlad: add a lock to an xid-hashed lock list 0 2 3
ges enqueue table freelist kjlalc: lock allocation 0 12 10
ges enqueue table freelist kjlfr: remove lock from parent object 0 2 4
ges process parent latch kjlrem: detach lock from group 0 13 0
ges process table freelist kjpalc: process allocation 0 208 208
ges resource hash list kjrmas1: lookup master node 0 647 51
ges resource hash list kjucvl: lock convert request 0 274 13
ges resource hash list kjrref: find matched resource 0 110 971
ges resource hash list kjcvscn: remove from scan queue 0 38 0
ges resource hash list kjakcai: search for resp by resname 0 10 5
ges resource hash list kjlrlr: remove lock from resource queue 0 9 49
ges resource hash list kjruch: move resource from cache to freelist 0 1 0
ges resource table freelist kjruch: cached obj cleanup 0 231 0
ges resource table freelist kjrm2c: move resource to cache 0 61 302
ges resource table freelist kjralc: resource allocation 0 19 5
ges resource table freelist kjrchc: cached obj cleanup 0 10 0
kks stats kks stats alloc/free 0 6,296 6,293
library cache kgldti: 2child 0 85,875 3,022
library cache kgldte: child 0 0 55,771 75,871
library cache kglpin 0 39,716 4,956
library cache kglobpn: child: 0 27,921 24,291
library cache kglukp: child 0 15,852 3,464
library cache kglpndl: child: before processing 0 13,276 21,454
library cache kglati 0 4,954 9
library cache kglhdgn: child: 0 4,553 86,524
library cache kglpndl: child: after processing 0 3,249 47
library cache kglLockCursor 0 2,722 12,825
library cache kglpnp: child 0 1,472 19,503
library cache kgldtld: 2child 0 174 531
library cache kglhdbrnl: child 0 45 4,875
library cache kglrtl 0 40 57
library cache kglhdgc: child: 0 32 19
library cache kglobld 0 24 76
library cache kqlmbpil: parent 0 17 24
library cache kglini: child 0 11 6
library cache kglScanDependency 0 6 0
library cache kglic 0 6 99
library cache kglnti 0 2 20
library cache lock kgllkdl: child: no lock handle 0 39,167 27,656
library cache lock kgllkdl: child: cleanup 0 4,871 1,855
library cache lock kgllkal: child: multiinstance 0 738 2,309
library cache lock ksucallcbksafely: kqllhng 0 6 0
library cache lock kglget: un-set reserved lock 0 4 0
library cache lock allocation kgllkget 0 33 31
library cache lock allocation kgllkrel 0 1 3
library cache pin kglpnal: child: alloc space 0 1 1
list of block allocation ktcdod 0 29 29
messages ksaamb: after wakeup 0 119 77
messages ksarcv 0 12 5
messages ksarcv: after wait 0 11 60
multiblock read objects kcbzib: mbr get 0 87 20
multiblock read objects kcbzib: normal mbr free 0 11 77
object queue header operation kcbw_unlink_q 0 658 327
object queue header operation kcbo_ivbo 0 361 700
object queue header operation kcbw_make_free_nowait 0 134 0
object queue header operation kcbo_switch_q_bg 0 95 68
object queue header operation kcbo_switch_mq_bg 0 76 123
object queue header operation kcbw_link_q 0 57 15
object queue header operation kclobj_2 0 27 14
object queue header operation kclobj_3 0 24 109
object queue header operation kcb_flush_undo_segment 0 11 15
object queue header operation kclobj_1 0 4 6
object queue header operation kcbo_switch_cq 0 3 44
object queue header operation kcbw_unlink_q_bg 0 2 13
parallel query alloc buffer kxfpbalo 0 86 101
parallel query alloc buffer kxfpbfre 0 21 7
parameter table management ksp_param_table_free 0 3 1
process allocation ksuapc 0 439,154 437,339
process allocation ksucrp 0 331 0
process allocation ksudlp 0 7 1,525
process allocation ksufap: active procs 0 4 593
query server process kxfpg1srv 0 13 2
query server process kxfpcrer 0 1 12
redo allocation kcrfw_redo_gen: redo allocation 1 0 140 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 40 66
redo allocation kcrfw_redo_gen: redo allocation 2 0 1 0
redo writing kcrfw_post: after write 0 180 0
redo writing kcrfwcr 0 8 177
redo writing kcrfw_post: rba scn pair 0 6 0
redo writing kcrfsr: rba scn pair 0 1 19
redo writing kcrfw_cal_target_rba 0 1 0
resmgr:free threads list kgskthrcreate 0 213 187
resmgr:free threads list kgskthrsod 0 1 27
row cache objects kqrbip 0 26,263 34
row cache objects kqreqd 0 3,453 85
row cache objects kqreqd: reget 0 1,326 33
row cache objects kqrpre: find obj 0 1,323 8,983
row cache objects kqrigt 0 431 22,919
row cache objects kqrso 0 224 123
row cache objects kqrbgl 0 51 72
row cache objects kqrbtm: pop parent 0 24 47
row cache objects kqrbfr 0 3 109
row cache objects kqrpre: init complete 0 3 411
row cache objects kqrsrd 0 3 312
row cache objects ksucallcbksafely: kqrhngc 0 3 0
row cache objects kqrbpr: KQRRSNRL 0 2 11
row cache objects kqrcmt: while loop 0 2 16
session allocation ksucrp 0 49,247 41,421
session allocation ksucri 0 1,889 8,185
session allocation ksuxds: KSUSFCLC not set 0 1,643 1,203
session allocation ksuxds: not user session 0 472 2,840
session allocation ksudlc 0 226 0
session allocation ksuprc 0 205 12
session allocation ksudlp 0 5 0
session allocation ksufap: active sessions 0 3 0
session idle bit ksuxds 0 1 1
session state list latch kpseqd 0 2 0
session switching kskexeall 0 3,355 2,958
shared pool kghalo 0 42,272 78,006
shared pool kgh_next_free 0 34,805 967
shared pool kghfrh 0 17,689 32
shared pool kghfrunp: clatch: nowait 0 7,490 0
shared pool kghupr1 0 7,409 16,664
shared pool kghfrunp: clatch: wait 0 7,217 24,216
shared pool kghfre 0 6,656 10,937
shared pool kghfrunp: alloc: wait 0 2,153 424
shared pool kghalp 0 639 4,471
shared pool kghasp 0 29 94
shared pool kghfree_extents: scan 0 2 30
shared pool kghfen: not perm alloc class 0 1 1
shared pool kghfrunp: alloc: session dur 0 1 0
shared pool simulator kglsim_unpin_simhp 0 493 286
shared pool simulator kglsim_upd_newhp 0 211 111
shared pool simulator kglsim_chg_simhp_free 0 71 134
shared pool simulator kglsim_chg_simhp_inval 0 24 0
shared pool simulator kglsim_scan_lru: scan 0 16 255
shared pool simulator kglsim_chg_simhp_noob 0 11 42
shared pool simulator kglsim_scan_lru: rebalance 0 2 0
simulator hash latch kcbsacc: lookup dba 0 32 41
simulator hash latch kcbs_lookup_setid: lookup dba 0 9 0
simulator lru latch kcbs_shrink_pool 0 4 0
slave class create ksvcreate 0 1 0
sort extent pool ktstdt: return extent 0 92 32
sort extent pool ktstdt: dealloc sort extent 0 9 0
trace latch kstipg 0 1,269 1,269

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
OLIVE IDX_OL PK_OL$_ATTR_DEFS   INDEX 10,611,056 16.13
OLIVE DATA_OL OL$_CLASSES   TABLE 9,691,840 14.73
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 5,792,064 8.80
AMBER IDX_WF NDX_INDY_USER_PROFILE   INDEX 3,309,872 5.03
AMBER IDX_WF UK_USER_ACTION_BAK   INDEX 3,269,776 4.97

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
OLIVE DATA_OL OL$_ASSOCIATIONS   TABLE 24,186 5.70
OLIVE DATA_OL OL$_OBJECTS_R01 P_1340513 TABLE PARTITION 16,847 3.97
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 7,597 1.79
OLIVE IDX_OL OL$_ASSOCIATIONS_N1   INDEX 7,128 1.68
OLIVE IDX_OL NK_OL$_REFS_URI_A   INDEX 4,322 1.02

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
PMS DATA_P T_YXDZ_CZPZB   TABLE 244 17.63
OLIVE DATA_OL OL$_OBJECTS _134030904 TABLE PARTITION 104 7.51
OLIVE DATA_OL OL$_OBJECTS _134011708 TABLE PARTITION 94 6.79
OLIVE DATA_OL OL$_OBJECTS _134061413 TABLE PARTITION 88 6.36
OLIVE DATA_OL OL$_OBJECTS_R01 P_1340610 TABLE PARTITION 82 5.92

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
OLIVE IDX_OL OL$_EVENT_LOG_D1   INDEX 1 100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
PMS DATA_P T_YXDZ_CZPZB   TABLE 244 31.73
OLIVE IDX_OL OL$_EVENT_LOG_D1   INDEX 141 18.34
SGPM IDX_SG PK_P_TASK   INDEX 136 17.69
SGPM IDX_SG PK_P_TASK_PARA   INDEX 105 13.65
AMBER IDX_WF IDX_ONLINE_USER   INDEX 39 5.07

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
AMBER IDX_WF IDX_ONLINE_USER   INDEX 168,021 66.57
AMBER IDX_WF IDX_USE_LOG   INDEX 17,283 6.85
PMS DATA_P T_WT_ISSUE_LSH_WH   TABLE 16,051 6.36
OLIVE IDX_OL NK_OL$_REFS_URI_A   INDEX 8,127 3.22
SGPM DATA_SG P_TASK   TABLE 7,619 3.02

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
SGPM DATA_SG P_TASK   TABLE 3,413 13.25
AMBER IDX_WF IDX_ONLINE_USER   INDEX 2,471 9.59
OLIVE DATA_OL OL$_ASSOCIATIONS   TABLE 1,379 5.35
OLIVE IDX_OL NK_OL$_REFS_URI_A   INDEX 1,251 4.85
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 1,191 4.62

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
SCADA IDX_SCA SCADA_SUBAREA_MEASURE_SUM   TABLE 21,236 10.96
OLIVE DATA_OL OL$_OBJECTS_R01 P_1340412 TABLE PARTITION 15,097 7.79
OLIVE DATA_OL OL$_ASSOCIATIONS   TABLE 13,824 7.13
OLIVE DATA_OL OL$_OBJECTS_R01 P_1340625 TABLE PARTITION 13,646 7.04
OLIVE DATA_OL OL$_OBJECTS_R01 P_1340106 TABLE PARTITION 13,281 6.85

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 18 5.56 0   1 1
dc_database_links 18,310 0.02 0   0 5
dc_global_oids 86,814 0.15 0   0 88
dc_histogram_data 794,631 4.15 0   0 10,956
dc_histogram_defs 252,503 7.44 0   6 5,256
dc_object_grants 282 32.27 0   0 49
dc_object_ids 318,634 0.62 0   1 1,788
dc_objects 31,721 4.55 0   2 911
dc_profiles 2,478 0.04 0   0 1
dc_rollback_segments 120,475 0.09 0   638 952
dc_segments 45,753 19.58 0   14 2,578
dc_sequences 26 57.69 0   26 0
dc_table_scns 85 7.06 0   0 3
dc_tablespace_quotas 40 35.00 0   0 8
dc_tablespaces 168,880 0.07 0   0 67
dc_usernames 13,029 0.17 0   0 24
dc_users 360,417 0.01 0   0 72
outstanding_alerts 306 94.12 0   28 4

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 3 1 0
dc_database_links 3 0 3
dc_global_oids 128 0 117
dc_histogram_defs 18,771 0 21,017
dc_object_ids 1,961 0 1,546
dc_objects 1,442 0 1,209
dc_profiles 1 0 1
dc_rollback_segments 1,296 114 0
dc_segments 9,250 0 8,479
dc_sequences 52 2 13
dc_table_scns 6 0 5
dc_tablespace_quotas 34 0 6
dc_tablespaces 118 0 77
dc_usernames 23 0 15
dc_users 24 0 6
outstanding_alerts 576 128 138

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 508 4.72 69,607 0.09 39 0
CLUSTER 87 3.45 140 2.86 1 0
INDEX 1,263 1.90 15,257 0.64 11 0
JAVA DATA 1 100.00 1 100.00 0 0
JAVA RESOURCE 1 100.00 1 100.00 0 0
JAVA SOURCE 1 100.00 1 100.00 0 0
SQL AREA 101,011 23.78 1,806,326 3.60 2,878 1,155
TABLE/PROCEDURE 13,593 6.99 273,002 1.57 1,797 0
TRIGGER 235 3.40 2,994 0.43 5 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 140 3 3 3 0
INDEX 15,257 24 25 23 0
JAVA DATA 1 1 1 0 0
JAVA RESOURCE 1 1 2 0 0
JAVA SOURCE 1 1 2 0 0
TABLE/PROCEDURE 57,428 594 488 365 0
TRIGGER 1 8 10 7 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 4,284.94   2.49 8.83 354 354 1,720 1,720
  Freeable 630.44 0.00 0.63 0.36 4   995 995
  PL/SQL 154.50 43.25 0.09 2.19 91 91 1,719 1,719
  SQL 121.71 5.06 0.07 0.07 0 210 1,685 1,682
E Other 728.81   3.90 26.05 354 354 187 187
  Freeable 33.44 0.00 0.98 0.99 6   34 34
  SQL 1.77 0.11 0.08 0.09 0 2 23 19
  PL/SQL 0.47 0.30 0.00 0.01 0 0 185 56

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 23,941,087,232 23,924,310,016
Fixed Size 2,147,040  
Redo Buffers 48,181,248  
Variable Size 3,925,871,904 3,942,649,120

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large PX msg pool 1.03 1.54 50.00
large free memory 14.97 14.46 -3.43
shared ASH buffers 68.00 68.00 0.00
shared CCursor 72.35   -100.00
shared Checkpoint queue 62.52 62.52 0.00
shared KGH: NO ACCESS 2,030.74 1,999.82 -1.52
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 1,181.57 1,257.47 6.42
shared gcs resources 626.14 626.14 0.00
shared gcs shadows 294.06 294.06 0.00
shared ges enqueues 109.87 109.87 0.00
shared kglsim object batch 75.65 75.65 0.00
shared library cache 98.35 96.88 -1.50
shared obj stat memo 134.54 134.56 0.01
shared sql area 87.05 88.68 1.88
shared trace buffer   71.30  
streams KGH: NO ACCESS 15.99 15.99 0.00
streams free memory 16.00 16.00 0.00
  buffer_cache 22,832.00 22,816.00 -0.07
  fixed_sga 2.05 2.05 0.00
  log_buffer 45.95 45.95 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 Slaves 540,000 996,691 0
QMON Coordinator 80,000 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 28 0 0 13 112

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 1,369,926 3,420,531 3177578 3177578
ges_procs 187 4,018 5001 5001
processes 188 4,565 5000 5000


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /oracle/product/admin/ndmis/adump   
background_dump_dest /oracle/product/admin/ndmis/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.5.0   
control_files /dev/rctrl_01_128m, /dev/rctrl_02_128m, /dev/rctrl_03_128m   
core_dump_dest /oracle/product/admin/ndmis/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_files 2000   
db_name ndmis   
dispatchers (PROTOCOL=TCP) (SERVICE=ndmisXDB)   
instance_number 2   
job_queue_processes 20   
local_listener (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.6.73)(PORT = 1521))   
log_archive_dest /arch02   
log_archive_dest_1      
nls_language AMERICAN   
nls_length_semantics BYTE   
open_cursors 3000   
optimizer_index_cost_adj 20   
optimizer_mode ALL_ROWS   
pga_aggregate_target 6442450944   
processes 5000   
remote_listener LISTENERS_NDMIS   
remote_login_passwordfile EXCLUSIVE   
service_names nd_mis, ndmis   
sessions 5505   
sga_target 27917287424   
spfile /dev/rspfile_128m   
thread 2   
undo_management AUTO   
undo_tablespace UNDOTBS2   
user_dump_dest /oracle/product/admin/ndmis/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 6,572 3.49 0.95
acks for commit broadcast(logical) 10,577 5.61 1.54
broadcast msgs on commit(actual) 8,295 4.40 1.20
broadcast msgs on commit(logical) 8,519 4.52 1.24
broadcast msgs on commit(wasted) 2,234 1.19 0.32
broadcast on commit wait time(ms) 267,033 141.73 38.77
broadcast on commit waits 5,879 3.12 0.85
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 571 0.30 0.08
flow control messages received 32 0.02 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 91,601 48.62 13.30
gcs ast xid 16 0.01 0.00
gcs blocked converts 14,133 7.50 2.05
gcs blocked cr converts 25,824 13.71 3.75
gcs compatible basts 256 0.14 0.04
gcs compatible cr basts (global) 3,201 1.70 0.46
gcs compatible cr basts (local) 174,306 92.52 25.31
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 4,869 2.58 0.71
gcs dbwr write request msgs 4,120 2.19 0.60
gcs error msgs 2 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 4,333 2.30 0.63
gcs immediate (null) converts 25,676 13.63 3.73
gcs immediate cr (compatible) converts 60 0.03 0.01
gcs immediate cr (null) converts 237,341 125.98 34.46
gcs indirect ast 61,719 32.76 8.96
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 1,858 0.99 0.27
gcs msgs process time(ms) 2,202,919 1,169.26 319.82
gcs msgs received 669,263 355.23 97.16
gcs out-of-order msgs 43 0.02 0.01
gcs pings refused 102 0.05 0.01
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 35 0.02 0.01
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 11 0.01 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 25 0.01 0.00
gcs side channel msgs actual 18,578 9.86 2.70
gcs side channel msgs logical 284,463 150.99 41.30
gcs stale cr 6 0.00 0.00
gcs undo cr 1,326 0.70 0.19
gcs write notification msgs 273 0.14 0.04
gcs writes refused 27 0.01 0.00
ges msgs process time(ms) 54,931 29.16 7.97
ges msgs received 152,643 81.02 22.16
global posts dropped 0 0.00 0.00
global posts queue time 33 0.02 0.00
global posts queued 30 0.02 0.00
global posts requested 30 0.02 0.00
global posts sent 30 0.02 0.00
implicit batch messages received 46,787 24.83 6.79
implicit batch messages sent 62,450 33.15 9.07
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 30,818 16.36 4.47
messages queue sent actual 266,260 141.32 38.66
messages queue sent logical 461,880 245.16 67.06
messages received actual 452,301 240.07 65.67
messages received logical 821,935 436.26 119.33
messages sent directly 165,094 87.63 23.97
messages sent indirectly 1,480,987 786.07 215.01
messages sent not implicit batched 203,834 108.19 29.59
messages sent pbatched 1,552,984 824.29 225.46
msgs causing lmd to send msgs 97,220 51.60 14.11
msgs causing lms(s) to send msgs 11,385 6.04 1.65
msgs received queue time (ms) 5,675,249 3,012.29 823.93
msgs received queued 821,848 436.22 119.32
msgs sent queue time (ms) 6,911,785 3,668.61 1,003.45
msgs sent queue time on ksxp (ms) 58,378,312 30,985.84 8,475.36
msgs sent queued 457,809 242.99 66.46
msgs sent queued on ksxp 469,682 249.30 68.19
number of ges deadlock detected 0 0.00 0.00
process batch messages received 63,843 33.89 9.27
process batch messages sent 166,503 88.38 24.17


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 21,793
CURRENT Block Requests 2,094
Data Block Requests 21,796
Undo Block Requests 441
TX Block Requests 1,295
Current Results 21,604
Private results 67
Zero Results 2,207
Disk Read Results 0
Fail Results 3
Fairness Down Converts 3,981
Fairness Clears 0
Free GC Elements 0
Flushes 202
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 310
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 191,084 99.53 0.14 0.22 0.06 0.04
Flushes 251 58.17 18.73 10.36 6.37 6.37
Writes 6,774 31.92 25.26 14.79 17.57 10.47


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 23,718 96.91 2.17 0.92 192,780 97.84 0.28 1.88
1 undo header 1,215 97.78 1.15 1.07 73 93.15 6.85 0.00
1 Others 387 97.93 1.03 1.03 792 99.37 0.25 0.38
1 undo block 390 94.62 3.08 2.31 33 96.97 0.00 3.03


Back to Top

End of Report