WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
NDMIS3941636119ndmis1110.2.0.5.0YESndora1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2647027-Mar-13 16:00:141773 20.0
End Snap:2647127-Mar-13 16:30:171783 20.2
Elapsed:  30.05 (mins)  
DB Time:  114.62 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 22,960M 22,960MStd Block Size: 8K
Shared Pool Size: 3,456M 3,456MLog Buffer: 47,052K

Load Profile

Per SecondPer Transaction
Redo size: 136,014.72 5,737.94
Logical reads: 108,428.10 4,574.17
Block changes: 524.80 22.14
Physical reads: 1,010.20 42.62
Physical writes: 60.16 2.54
User calls: 3,056.25 128.93
Parses: 340.87 14.38
Hard parses: 54.82 2.31
Sorts: 231.91 9.78
Logons: 0.09 0.00
Executes: 3,071.09 129.56
Transactions: 23.70 

% Blocks changed per Read: 0.48Recursive Call %: 67.84
Rollback per transaction %: 2.91Rows per Sort: 49.30

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97Redo NoWait %: 100.00
Buffer Hit %: 99.08In-memory Sort %: 100.00
Library Hit %: 94.36Soft Parse %: 83.92
Execute to Parse %: 88.90Latch Hit %: 99.81
Parse CPU to Parse Elapsd %: 19.09% Non-Parse CPU: 98.13

Shared Pool Statistics

BeginEnd
Memory Usage %: 75.34 75.27
% SQL with executions>1: 75.58 66.23
% Memory for SQL w/exec>1: 80.64 72.30

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
db file sequential read 486,678 2,253 5 32.8User I/O
CPU time  2,025  29.4 
SQL*Net message from dblink 115,648 645 6 9.4Network
db file scattered read 94,734 271 3 3.9User I/O
gc current block 2-way 444,659 182 0 2.6Cluster

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 820.77 34.63
Global Cache blocks served: 592.05 24.98
GCS/GES messages received: 2,722.86 114.87
GCS/GES messages sent: 2,928.61 123.55
DBWR Fusion writes: 9.88 0.42
Estd Interconnect traffic (KB) 12,406.40 

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

Buffer access - local cache %: 98.33
Buffer access - remote cache %: 0.76
Buffer access - disk %: 0.92

Global Cache and Enqueue Services - Workload Characteristics

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.4
Avg message sent queue time on ksxp (ms): 0.3
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 31.73
% of indirect sent messages: 63.78
% of flow controlled messages: 4.50


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 6,529.44 94.94
DB CPU 2,024.95 29.44
parse time elapsed 393.27 5.72
hard parse elapsed time 355.34 5.17
PL/SQL execution elapsed time 79.00 1.15
PL/SQL compilation elapsed time 59.63 0.87
hard parse (sharing criteria) elapsed time 46.03 0.67
hard parse (bind mismatch) elapsed time 34.36 0.50
failed parse elapsed time 4.27 0.06
repeated bind elapsed time 3.66 0.05
connection management call elapsed time 0.64 0.01
sequence load elapsed time 0.19 0.00
DB time 6,877.46  
background elapsed time 496.05  
background cpu time 335.24  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
User I/O 623,926 0 2,621 4 38.10
CPU time     2,025   29.44
Network 6,866,167   675 0 9.82
Cluster 1,678,879 0 602 0 8.76
System I/O 192,489   85 0 1.23
Other 267,553 45 75 0 1.09
Commit 41,649 0 66 2 0.96
Concurrency 177,100 0 44 0 0.64
Application 607 1 2 4 0.03
Configuration 349   0 0 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 486,678   2,253 5 11.39
SQL*Net message from dblink 115,648   645 6 2.71
db file scattered read 94,734   271 3 2.22
gc current block 2-way 444,659   182 0 10.41
gc cr multi block request 753,085   152 0 17.62
gc buffer busy 50,385 0 106 2 1.18
gc cr grant 2-way 272,786   92 0 6.38
log file sync 41,649 0 66 2 0.97
cr request retry 68 100 66 964 0.00
read by other session 16,149 0 43 3 0.38
gc cr block 2-way 93,889   39 0 2.20
db file parallel read 9,990   37 4 0.23
row cache lock 139,740   36 0 3.27
log file parallel write 44,976   30 1 1.05
db file parallel write 40,554   29 1 0.95
control file sequential read 106,119   24 0 2.48
SQL*Net more data to client 1,441,165   20 0 33.72
direct path read 11,507   15 1 0.27
gc current grant 2-way 43,617   14 0 1.02
gc current grant busy 18,356   8 0 0.43
SQL*Net more data from dblink 3,111   6 2 0.07
SQL*Net message to client 5,166,327   3 0 120.89
library cache lock 8,171   3 0 0.19
gc cr grant congested 63   3 43 0.00
gc current block congested 81   2 30 0.00
reliable message 153 1 2 14 0.00
enq: TX - row lock contention 13 31 2 159 0.00
ges lmd/lmses to freeze in rcfg - mrcvr 387 24 2 4 0.01
gc current block busy 270   2 6 0.01
ksxr poll remote instances 206,031 31 1 0 4.82
gc cr block congested 21   1 70 0.00
latch: cache buffers chains 27,699   1 0 0.65
direct path write temp 1,434   1 1 0.03
SQL*Net more data from client 24,049   1 0 0.56
direct path write 3,429   1 0 0.08
inactive session 1 100 1 977 0.00
os thread startup 15   1 60 0.00
cursor: pin S wait on X 94 96 1 9 0.00
CSS initialization 13   1 66 0.00
control file parallel write 840   1 1 0.02
gcs log flush sync 692 0 1 1 0.02
library cache load lock 13   1 46 0.00
latch: shared pool 110   1 5 0.00
gc current grant congested 11   0 45 0.00
CGS wait for IPC msg 55,210 99 0 0 1.29
library cache pin 1,079   0 0 0.03
DFS lock handle 912   0 0 0.02
latch free 124   0 3 0.00
gc cr block busy 120   0 2 0.00
gc current multi block request 1,349   0 0 0.03
rdbms ipc reply 819   0 0 0.02
enq: HW - contention 346   0 0 0.01
enq: TX - index contention 60   0 1 0.00
latch: object queue header operation 27   0 3 0.00
enq: TT - contention 193   0 0 0.00
SQL*Net message to dblink 115,625   0 0 2.71
SQL*Net break/reset to client 544   0 0 0.01
latch: KCL gc element parent latch 87   0 1 0.00
gc cr disk read 109   0 0 0.00
CSS operation: action 25   0 2 0.00
latch: library cache 15   0 3 0.00
kksfbc child completion 1 100 0 49 0.00
enq: FB - contention 103   0 0 0.00
IPC send completion sync 111 100 0 0 0.00
enq: TO - contention 106   0 0 0.00
enq: CF - contention 101   0 0 0.00
enq: PS - contention 59   0 0 0.00
gc cr failure 68   0 0 0.00
PX Deq: reap credit 1,520 97 0 0 0.04
enq: TX - contention 1   0 14 0.00
LGWR wait for redo copy 475   0 0 0.01
latch: row cache objects 4   0 3 0.00
enq: TM - contention 24   0 0 0.00
gc quiesce 2 50 0 5 0.00
PX Deq Credit: send blkd 30 20 0 0 0.00
buffer busy waits 97   0 0 0.00
enq: WF - contention 9   0 0 0.00
SQL*Net more data to dblink 242   0 0 0.01
latch: gcs resource hash 10   0 0 0.00
enq: RO - fast object reuse 6   0 1 0.00
enq: TD - KTF dump entries 6   0 0 0.00
ges inquiry response 5   0 0 0.00
gc current split 6   0 0 0.00
KJC: Wait for msg sends to complete 75   0 0 0.00
PX Deq: Signal ACK 19 37 0 0 0.00
enq: TX - allocate ITL entry 3   0 0 0.00
gc current block unknown 2   0 0 0.00
enq: MS - contention 2   0 0 0.00
ges2 LMON to wake up LMD - mrcvr 14   0 0 0.00
SQL*Net break/reset to dblink 18   0 0 0.00
direct path read temp 5   0 0 0.00
enq: MW - contention 1   0 0 0.00
enq: DR - contention 1   0 0 0.00
enq: AF - task serialization 1   0 0 0.00
enq: JI - contention 1   0 0 0.00
enq: JS - job run lock - synchronize 1   0 0 0.00
enq: UL - contention 2   0 0 0.00
latch: cache buffers lru chain 1   0 0 0.00
latch: session allocation 2   0 0 0.00
wait for scn ack 5   0 0 0.00
cursor: pin S 148   0 0 0.00
buffer deadlock 3 100 0 0 0.00
cursor: mutex S 2   0 0 0.00
cursor: mutex X 1   0 0 0.00
SQL*Net message from client 5,166,386   2,800,301 542 120.89
gcs remote message 2,296,140 22 27,869 12 53.73
Streams AQ: qmn slave idle wait 552 1 3,521 6379 0.01
virtual circuit status 61 100 1,787 29297 0.00
jobq slave wait 617 96 1,772 2872 0.01
Streams AQ: qmn coordinator idle wait 596 43 1,761 2954 0.01
DIAG idle wait 9,000   1,759 195 0.21
PX Idle Wait 734 93 1,759 2397 0.02
Streams AQ: waiting for messages in the queue 186 100 1,758 9451 0.00
Streams AQ: waiting for time management or cleanup tasks 6 100 1,758 292969 0.00
ges remote message 232,771 6 1,745 7 5.45
PX Deq: Execution Msg 256 29 0 1 0.01
single-task message 4   0 32 0.00
PX Deq: Parse Reply 27 37 0 4 0.00
PX Deq: Execute Reply 22 32 0 1 0.00
PX Deq: Join ACK 25 36 0 1 0.00
PX Deq: Msg Fragment 92 47 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 603 98 0 0 0.01
class slave wait 4   0 1 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 44,978   30 1 1.05
db file parallel write 40,554   29 1 0.95
control file sequential read 37,291   13 0 0.87
events in waitclass Other 264,098 45 5 0 6.18
db file sequential read 708   2 3 0.02
os thread startup 15   1 60 0.00
control file parallel write 840   1 1 0.02
row cache lock 736   0 0 0.02
library cache load lock 1   0 156 0.00
gc current block 2-way 315   0 0 0.01
library cache lock 161   0 0 0.00
gc cr grant 2-way 78   0 0 0.00
gc current grant 2-way 62   0 0 0.00
gc cr block 2-way 29   0 0 0.00
gc quiesce 2 50 0 5 0.00
enq: RO - fast object reuse 6   0 1 0.00
library cache pin 13   0 0 0.00
latch: shared pool 3   0 0 0.00
enq: TM - contention 1   0 0 0.00
buffer busy waits 6   0 0 0.00
latch: cache buffers chains 5   0 0 0.00
rdbms ipc message 355,760 13 35,300 99 8.32
gcs remote message 2,296,139 22 27,869 12 53.73
Streams AQ: qmn slave idle wait 552 1 3,521 6379 0.01
Streams AQ: qmn coordinator idle wait 596 43 1,761 2954 0.01
smon timer 372 99 1,760 4731 0.01
DIAG idle wait 9,000   1,759 195 0.21
pmon timer 702 99 1,758 2505 0.02
Streams AQ: waiting for time management or cleanup tasks 6 100 1,758 292969 0.00
ges remote message 232,764 6 1,745 7 5.45
Streams AQ: RAC qmn coordinator idle wait 603 98 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 6,665
AVG_IDLE_TIME 173,454
AVG_IOWAIT_TIME 3,536
AVG_SYS_TIME 1,579
AVG_USER_TIME 5,036
BUSY_TIME 430,512
IDLE_TIME 11,105,279
IOWAIT_TIME 229,756
SYS_TIME 104,486
USER_TIME 326,026
LOAD 3
OS_CPU_WAIT_TIME 447,800
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 12,414,976
VM_OUT_BYTES 69,632,000
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 6,869.00 2,021.50 1,823,317 195,428,847
SYS$USERS 35.40 15.40 554 234,135
SYS$BACKGROUND 0.10 0.10 2,389 182,872
SYS.KUPC$S_1_20130323232332 0.00 0.00 0 0
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 620689 2608 164870 39 0 0 6864018 675
SYS$USERS 535 2 7065 2 0 0 1604 0
SYS$BACKGROUND 2623 11 5165 2 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
348 213 104,561 0.00 5.05 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
255 26 298 0.86 3.71 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
236 0 53 4.46 3.44 c5tmjxj6rtck4 JDBC Thin Client SELECT mis_t.tg_id id, (SELECT...
212 48 3 70.65 3.08 aw6gj3r2syaxs JDBC Thin Client select interdata.area_code, in...
193 74 4,733 0.04 2.80 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
169 6 2 84.38 2.45 0js73phthdt42 JDBC Thin Client select t.TASK_CD, t.TASK_NO, t...
138 6 7,598 0.02 2.01 9yyb7wvndk114 JDBC Thin Client select * from v$_ST_DYLine whe...
132 66 4,993 0.03 1.92 5wfhpq886xacr JDBC Thin Client SELECT /*+index(t, NK_OL$_REFS...
97 55 263 0.37 1.41 dbgctn9f6071v JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
97 11 426,031 0.00 1.41 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...

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
213 348 104,561 0.00 10.50 5.05 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
74 193 4,733 0.02 3.68 2.80 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
66 132 4,993 0.01 3.25 1.92 5wfhpq886xacr JDBC Thin Client SELECT /*+index(t, NK_OL$_REFS...
55 97 263 0.21 2.70 1.41 dbgctn9f6071v JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
48 212 3 15.96 2.36 3.08 aw6gj3r2syaxs JDBC Thin Client select interdata.area_code, in...
29 58 318,465 0.00 1.45 0.84 fc42s7rxq7chg JDBC Thin Client SELECT CLS_URI FROM OL$_CLASSE...
26 255 298 0.09 1.30 3.71 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
26 41 156 0.16 1.27 0.60 awvtdy3vc6fum JDBC Thin Client SELECT codeId, codeSortId, par...
18 64 388 0.05 0.87 0.92 91d0kuahyy84b JDBC Thin Client SELECT tmp.* FROM (SELECT l.ob...
16 26 298 0.05 0.79 0.38 8u5s8xhp48xm2 JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...

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
33,087,216 104,561 316.44 16.93 212.63 347.61 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
25,896,656 4,733 5,471.51 13.25 74.48 192.69 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
25,611,846 4,993 5,129.55 13.10 65.82 132.20 5wfhpq886xacr JDBC Thin Client SELECT /*+index(t, NK_OL$_REFS...
21,654,668 318,465 68.00 11.08 29.33 58.08 fc42s7rxq7chg JDBC Thin Client SELECT CLS_URI FROM OL$_CLASSE...
7,879,065 156 50,506.83 4.03 25.67 41.16 awvtdy3vc6fum JDBC Thin Client SELECT codeId, codeSortId, par...
5,986,068 298 20,087.48 3.06 16.04 26.21 8u5s8xhp48xm2 JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
5,604,016 82,413 68.00 2.87 13.05 33.77 1gcnmuw9xtb3k JDBC Thin Client SELECT CLS_URI FROM OL$_CLASSE...
3,962,971 298 13,298.56 2.03 26.24 255.08 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
3,475,498 245 14,185.71 1.78 10.51 37.94 830q1znx77va1 JDBC Thin Client BEGIN OL$_CORE_EXPAND.LINESUPP...
3,452,086 263 13,125.80 1.77 54.75 97.10 dbgctn9f6071v JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
3,294,365 219 15,042.76 1.69 8.70 15.83 3tw8g2mwh4kgc JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
3,011,035 5,869 513.04 1.54 6.26 41.84 450w20twk6ku5 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKNAMEM...
2,762,166 1,537 1,797.12 1.41 7.31 19.10 bsm6gmajgmhuu JDBC Thin Client select * from indy_menu where ...
2,433,967 53,411 45.57 1.25 1.03 50.55 dpqpcqn109dcj JDBC Thin Client select * from st_institution_r...
2,410,019 58 41,552.05 1.23 2.30 23.26 gkw6wc3pm09j6 JDBC Thin Client SELECT USER_NAME FROM AMBER.IN...
2,355,941 388 6,072.01 1.21 17.63 63.55 91d0kuahyy84b JDBC Thin Client SELECT tmp.* FROM (SELECT l.ob...
2,136,152 426,031 5.01 1.09 10.85 96.76 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
2,037,976 3 679,325.33 1.04 47.88 211.95 aw6gj3r2syaxs JDBC Thin Client select interdata.area_code, in...

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
351,143 3 117,047.67 19.28 47.88 211.95 aw6gj3r2syaxs JDBC Thin Client select interdata.area_code, in...
50,787 311 163.30 2.79 13.81 44.08 4ydgzsjh9kb57 JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
39,477 298 132.47 2.17 26.24 255.08 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
28,833 2 14,416.50 1.58 5.91 168.76 0js73phthdt42 JDBC Thin Client select t.TASK_CD, t.TASK_NO, t...
19,525 7,598 2.57 1.07 6.15 138.24 9yyb7wvndk114 JDBC Thin Client select * from v$_ST_DYLine whe...
19,361 150 129.07 1.06 11.22 57.77 fdckt0yps3750 JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
17,008 263 64.67 0.93 54.75 97.10 dbgctn9f6071v JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
13,278 426,031 0.03 0.73 10.85 96.76 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
10,691 4,733 2.26 0.59 74.48 192.69 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
9,947 120 82.89 0.55 2.43 60.71 9yh5wgu938tja JDBC Thin Client BEGIN OL$_CORE_EXPAND.Batchins...

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
426,031 426,029 1.00 0.00 0.00 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
393,851 393,842 1.00 0.00 0.00 fkg1futrvwzbg JDBC Thin Client SELECT COUNT(1) FROM OL$_ASSOC...
364,141 364,131 1.00 0.00 0.00 6xz0c679sk859 JDBC Thin Client SELECT NAME FROM V$_ST_IDENTIF...
318,465 318,449 1.00 0.00 0.00 fc42s7rxq7chg JDBC Thin Client SELECT CLS_URI FROM OL$_CLASSE...
154,010 2,652,608 17.22 0.00 0.00 db78fxqxwxt7r   select /*+ rule */ bucket, end...
104,561 104,308 1.00 0.00 0.00 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
84,765 51,872 0.61 0.00 0.00 21w7mktubd1dq JDBC Thin Client SELECT :B2 , T.CAN_BE_NULL, T....
82,413 82,412 1.00 0.00 0.00 1gcnmuw9xtb3k JDBC Thin Client SELECT CLS_URI FROM OL$_CLASSE...
80,664 156,230 1.94 0.00 0.00 cfrwbnuu2xtam JDBC Thin Client select side_b from ol$_associa...
77,356 73,771 0.95 0.00 0.00 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
70,123 70,123 1.00 0.00 0.00 g4rzpg6rj116d JDBC Thin Client BEGIN OL$_RULE_CORE.SETSTRATTR...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
53,365 53,363 8.68 grwydz59pu6mc   select text from view$ where r...
51,272 51,272 8.34 2ym6hhaq30r73   select type#, blocks, extents,...
9,457 12,470 1.54 d3gsxy5k0u8hw JDBC Thin Client select * from v$_ST_Asset wher...
9,289 14,449 1.51 449xyhjkn7apn JDBC Thin Client select * from v$_ST_EquipmentC...
8,703 28,452 1.42 8b9zc43w360qt JDBC Thin Client SELECT O_28 partitionField FRO...
8,519 17,957 1.39 a41yvpfth003x JDBC Thin Client select * from v$_ST_Equipment ...
7,786 33,283 1.27 7xgzx0zrnt0fc JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
7,688 18,369 1.25 02djppxs4a73n JDBC Thin Client update ol$_locks t set t.obj =...
7,333 13,866 1.19 dnctudjagb520 JDBC Thin Client select * from v$_ST_AssetModel...
6,916 10,837 1.13 244v8yhfs7urr JDBC Thin Client SELECT C.CLS_ID, C.CLS_URI, C....
6,841 23,067 1.11 6pcrpqf5dkunf JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
6,780 12,055 1.10 1f5c885f3vvfx JDBC Thin Client select /*+ index(v$_ST_Asset I...
6,245 80,664 1.02 cfrwbnuu2xtam JDBC Thin Client select side_b from ol$_associa...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,154,013 4 0.03 f8uvk4ymbh19z JDBC Thin Client SELECT NAME, TYPE, ACTION_URL,...
1,071,172 156 0.03 awvtdy3vc6fum JDBC Thin Client SELECT codeId, codeSortId, par...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
512 3,260 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
478 4,678 83taa7kaw59c1   select name, intcol#, segcol#,...
462 3,993 f8pavn1bvsj7t   select con#, obj#, rcon#, enab...
409 51,272 2ym6hhaq30r73   select type#, blocks, extents,...
384 154,010 db78fxqxwxt7r   select /*+ rule */ bucket, end...
377 232 47r1y8yn34jmj   select default$ from col$ wher...
344 3,336 dczy7gkm3mpax JDBC Thin Client update ol$_objects set S_04 = ...
344 3,336 dczy7gkm3mpax JDBC Thin Client update ol$_objects set S_04 = ...
329 77,356 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
328 4 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
254 5 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...
235 322 8p7gycr8uy2j7 JDBC Thin Client update ol$_objects set S_04 = ...
235 322 8p7gycr8uy2j7 JDBC Thin Client update ol$_objects set S_04 = ...
177 4,190 2q93zsrvbdw48   select grantee#, privilege#, n...
137 53,363 grwydz59pu6mc   select text from view$ where r...
135 4,183 6aq34nj2zb2n7   select col#, grantee#, privile...
112 6,363 6769wyy3yf66f   select pos#, intcol#, col#, sp...
86 19 8rdg2n7g8ftk3 JDBC Thin Client update ol$_objects set O_10 = ...
86 19 8rdg2n7g8ftk3 JDBC Thin Client update ol$_objects set O_10 = ...
83 28 cma6d053zrny3 JDBC Thin Client update ol$_objects set S_35 = ...
83 28 cma6d053zrny3 JDBC Thin Client update ol$_objects set S_35 = ...
69 426,031 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
67 98 41wp41sp2ns44 JDBC Thin Client SELECT TASKID FROM WF_TASK WHE...
65 767 0ptxn6whczpaj JDBC Thin Client begin insert into indy_online_...
61 101 88h1jt12xms4p JDBC Thin Client INSERT INTO WF_AMBER.INDYSP_TA...
59 203 4nwucqtxta4mt JDBC Thin Client SELECT T.INSTANCE_LABEL, T.ACT...
59 1,173 fasvw7q199577   select u.name, o.name, t.updat...
56 203 7hft0rhsu4hh2 JDBC Thin Client UPDATE WF_NOTIFICATIONS SET FR...
45 109 0k8522rmdzg4k   select privilege# from sysauth...
45 800 avjzuwm5npxv7 JDBC Thin Client select * from indy_menu where ...
43 411 apsygukcr19bq JDBC Thin Client SELECT R.NAME, SUBSTRB(R.DISPL...
41 2 0h6b2sajwb74n   select privilege#, level from ...
38 1,537 bsm6gmajgmhuu JDBC Thin Client select * from indy_menu where ...
35 36 750bnanjunuhh JDBC Thin Client DELETE FROM OWF_MGR.WF_NOTIFIC...
35 36 a3rvzd26ud0vu JDBC Thin Client DELETE INDYWF_WORKLIST_CUR WHE...
35 70,123 g4rzpg6rj116d JDBC Thin Client BEGIN OL$_RULE_CORE.SETSTRATTR...
33 17 2p70njsc3jdvy JDBC Thin Client DELETE FROM SGPM.P_TASK_ASSIGN...
33 36 fbg5fqdjsvbw9 JDBC Thin Client DELETE INDYWF_WORKLIST_COM WHE...
31 489 8d3y3sqaj9f3s JDBC Thin Client SELECT * FROM (SELECT row_.*, ...
31 489 8d3y3sqaj9f3s JDBC Thin Client SELECT * FROM (SELECT row_.*, ...
31 14 95ugsq968zru6 JDBC Thin Client SELECT T.ORG_NAME FROM SGPM.O_...
29 14,449 449xyhjkn7apn JDBC Thin Client select * from v$_ST_EquipmentC...
29 4,733 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
27 40 6229274rb7bpc JDBC Thin Client SELECT * FROM (SELECT row_.*, ...
27 17,957 a41yvpfth003x JDBC Thin Client select * from v$_ST_Equipment ...
27 80,664 cfrwbnuu2xtam JDBC Thin Client select side_b from ol$_associa...
27 4 g73tzgnm4722f   select u.name, o.name, trigger...
26 53,411 dpqpcqn109dcj JDBC Thin Client select * from st_institution_r...
25 8,722 5n9d2rmutsfqv JDBC Thin Client select t.* from ol$_attr_categ...
25 9,933 b3gxg1nhmrvnf JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
24 5,869 450w20twk6ku5 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKNAMEM...
24 3 88awc7wsyhuwm JDBC Thin Client update ol$_objects set S_73 = ...
24 3 88awc7wsyhuwm JDBC Thin Client update ol$_objects set S_73 = ...
24 9 cjy09frsxfv7n JDBC Thin Client SELECT COUNT(*) FROM T_YXDZ_CZ...
24 9 dtun9pmgvp9a8 JDBC Thin Client SELECT COUNT(*) FROM T_YXDZ_CZ...
23 2,280 1hnz140zn79uv JDBC Thin Client SELECT T.ORG_NAME FROM SGPM.O_...
23 364,141 6xz0c679sk859 JDBC Thin Client SELECT NAME FROM V$_ST_IDENTIF...
23 2,300 abhn803avcumh JDBC Thin Client SELECT A.USER_BUREAU_NAME FROM...
23 9 czknwx2xjru6y JDBC Thin Client SELECT COUNT(*) FROM T_YXDZ_CZ...
23 13,866 dnctudjagb520 JDBC Thin Client select * from v$_ST_AssetModel...
23 1,509 ff40ndudptw4c JDBC Thin Client DELETE FROM INDY_ONLINE_USER W...
22 120 cs4fxq1s9xvyc JDBC Thin Client UPDATE OLIVE.V$_ST_ASSET X SET...
21 12,055 1f5c885f3vvfx JDBC Thin Client select /*+ index(v$_ST_Asset I...

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
110.00 51.90 211.95 47.88 3 aw6gj3r2syaxs JDBC Thin Client select interdata.area_code, in...
35.34 13.86 255.08 26.24 298 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
27.93 16.55 168.76 5.91 2 0js73phthdt42 JDBC Thin Client select t.TASK_CD, t.TASK_NO, t...
11.93 8.63 138.24 6.15 7,598 9yyb7wvndk114 JDBC Thin Client select * from v$_ST_DYLine whe...
8.54 4.43 192.69 74.48 4,733 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
6.63 6.85 96.76 10.85 426,031 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
6.37 17.09 37.27 5.97 78 7xn6xppmpg9u7 JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
6.14 10.07 61.03 7.38 1,768 g0mmxhhfz1q9g JDBC Thin Client select * from v$_LowArea where...
6.12 13.88 44.08 13.81 311 4ydgzsjh9kb57 JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
5.86 13.57 43.19 4.09 436 9vrbr3jjprusn JDBC Thin Client SELECT B OBJ_ID, (SELECT S_01 ...
5.45 8.62 63.24 3.13 17,957 a41yvpfth003x JDBC Thin Client select * from v$_ST_Equipment ...
5.13 8.89 57.77 11.22 150 fdckt0yps3750 JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
5.09 9.93 51.26 2.87 12,470 d3gsxy5k0u8hw JDBC Thin Client select * from v$_ST_Asset wher...
4.25 7.00 60.71 2.43 120 9yh5wgu938tja JDBC Thin Client BEGIN OL$_CORE_EXPAND.Batchins...
4.25 7.00 60.63 2.42 120 cs4fxq1s9xvyc JDBC Thin Client UPDATE OLIVE.V$_ST_ASSET X SET...
3.95 4.07 97.10 54.75 263 dbgctn9f6071v JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
3.39 5.33 63.55 17.63 388 91d0kuahyy84b JDBC Thin Client SELECT tmp.* FROM (SELECT l.ob...
3.35 6.56 51.06 1.86 3,557 6xjqy1675jdyr JDBC Thin Client select * from v$_ST_EquipmentC...
3.30 21.15 15.63 8.04 781 93dtuy0vt2k7q JDBC Thin Client SELECT task_id FROM p_task WHE...
3.25 7.76 41.84 6.26 5,869 450w20twk6ku5 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKNAMEM...
3.23 7.68 42.07 9.76 393,851 fkg1futrvwzbg JDBC Thin Client SELECT COUNT(1) FROM OL$_ASSOC...
3.13 8.20 38.12 1.83 3,778 8txqupfzzqh39 JDBC Thin Client select * from v$_ST_EquipmentC...
3.12 30.60 10.19 1.54 14,449 449xyhjkn7apn JDBC Thin Client select * from v$_ST_EquipmentC...
3.05 15.02 20.29 9.90 417 7wgzpzkd96b4p JDBC Thin Client SELECT n.id id, n.name name, n...
2.44 5.40 45.13 3.41 248 1r7mjtz9kp72t JDBC Thin Client select * from (select /*+rule*...
2.25 5.94 37.94 10.51 245 830q1znx77va1 JDBC Thin Client BEGIN OL$_CORE_EXPAND.LINESUPP...
2.12 6.33 33.50 2.63 154,010 db78fxqxwxt7r   select /*+ rule */ bucket, end...
2.11 9.15 23.10 1.90 4,121 apd7t7sfn2wxd JDBC Thin Client SELECT Getnamepathbyidpath(Pc....
1.90 8.96 21.20 7.10 364,141 6xz0c679sk859 JDBC Thin Client SELECT NAME FROM V$_ST_IDENTIF...
1.70 1.29 132.20 65.82 4,993 5wfhpq886xacr JDBC Thin Client SELECT /*+index(t, NK_OL$_REFS...
1.07 7.41 14.42 1.12 12,055 1f5c885f3vvfx JDBC Thin Client select /*+ index(v$_ST_Asset I...
1.02 64.86 1.58 0.46 1,509 ff40ndudptw4c JDBC Thin Client DELETE FROM INDY_ONLINE_USER W...
1.00 8.56 11.73 2.80 3,336 dczy7gkm3mpax JDBC Thin Client update ol$_objects set S_04 = ...
0.88 57.02 1.54 0.65 767 0ptxn6whczpaj JDBC Thin Client begin insert into indy_online_...
0.86 5.31 16.19 0.49 1,130 cv0rtthxrhdxy JDBC Thin Client SELECT O.S_04 || :B2 FROM OL$_...
0.84 1.65 50.55 1.03 53,411 dpqpcqn109dcj JDBC Thin Client select * from st_institution_r...
0.73 12.76 5.72 0.31 33,283 7xgzx0zrnt0fc JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
0.70 3.71 18.95 4.21 800 avjzuwm5npxv7 JDBC Thin Client select * from indy_menu where ...
0.65 11.90 5.48 1.76 489 8d3y3sqaj9f3s JDBC Thin Client SELECT * FROM (SELECT row_.*, ...
0.64 14.34 4.43 0.35 28,452 8b9zc43w360qt JDBC Thin Client SELECT O_28 partitionField FRO...
0.59 29.21 2.00 0.39 6,844 95jvxjj84rcct JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
0.53 14.44 3.65 0.38 23,067 6pcrpqf5dkunf JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
0.52 24.17 2.15 0.44 8,387 0cxypy0hx9g11 JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
0.49 7.45 6.64 0.35 77,356 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
0.39 2.45 15.89 9.88 67 5qr55krh9dkx5 JDBC Thin Client select APPLY_ID, APPLY_CD, APP...
0.29 5.25 5.52 0.24 13,866 dnctudjagb520 JDBC Thin Client select * from v$_ST_AssetModel...
0.28 1.46 19.10 7.31 1,537 bsm6gmajgmhuu JDBC Thin Client select * from indy_menu where ...
0.22 9.00 2.46 0.75 3,648 5v8y4xqjc73kv JDBC Thin Client SELECT Q1.B OBJ_ID FROM OLIVE....
0.19 1.21 15.83 8.70 219 3tw8g2mwh4kgc JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
0.19 0.82 23.26 2.30 58 gkw6wc3pm09j6 JDBC Thin Client SELECT USER_NAME FROM AMBER.IN...
0.19 0.72 26.21 16.04 298 8u5s8xhp48xm2 JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
0.18 1.52 11.65 7.21 11 0jat7ccc9fvct JDBC Thin Client Select Pc.Obj_Id, Pc.Cls_Uri, ...
0.17 8.47 2.07 0.17 14,153 b0mb9f2wdgnrk JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
0.17 8.69 1.94 0.12 101 88h1jt12xms4p JDBC Thin Client INSERT INTO WF_AMBER.INDYSP_TA...
0.11 10.77 1.03 0.06 36 750bnanjunuhh JDBC Thin Client DELETE FROM OWF_MGR.WF_NOTIFIC...
0.08 5.44 1.55 0.47 7 5bhhxz06fvgnk JDBC Thin Client SELECT OBJ_ID, NAME, A.CLS_URI...
0.06 1.34 4.85 3.12 197 9rn5ah9npmbc8 JDBC Thin Client WITH CLS_LIST AS (SELECT (SELE...
0.06 10.50 0.58 0.18 349 dvqv84updkxnc JDBC Thin Client SELECT T.OBJ_ID, T.CLS_URI, T....
0.05 16.76 0.31 0.05 36 fbg5fqdjsvbw9 JDBC Thin Client DELETE INDYWF_WORKLIST_COM WHE...
0.05 13.33 0.39 0.42 322 8p7gycr8uy2j7 JDBC Thin Client update ol$_objects set S_04 = ...
0.05 1.88 2.54 0.06 51,272 2ym6hhaq30r73   select type#, blocks, extents,...
0.04 48.32 0.07 0.04 98 41wp41sp2ns44 JDBC Thin Client SELECT TASKID FROM WF_TASK WHE...
0.03 10.66 0.32 0.14 47 cr5dhraqryr2f JDBC Thin Client Insert Into V$_St_Transmispole...
0.03 14.87 0.23 0.08 13 gf8k0n5kg6hy2 JDBC Thin Client SELECT T.OBJ_ID, T.CLS_URI, T....

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
02djppxs4a73nupdate ol$_locks t set t.obj = 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')
0js73phthdt42select t.TASK_CD, t.TASK_NO, t.TASK_NAME, t.GRID_KIND_CD, t.GRID_KIND, t.STOP_TARGET_ID, t.STOP_TARGET, t.SPEC_CD, t.SPEC, t.BEGIN_DATE, t.END_DATE, t.TASK_STATE_CD, t.TASK_STATE taskState, t.FILLER_CD, t.FILLER, t.FILL_DATE, t.LEADER_CD, t.LEADER, t.PATROLMAN_CD, t.PATROLMAN, t.AUDITOR_CD, t.AUDITOR, t.APPROVER_CD, t.APPROVER, t.LAST_UPDATE_DATE, t.LAST_UPDATER_CD, t.LAST_UPDATER, t.CREATE_DATE, t.CREATER_CD, t.CREATER, t.REASON_CD, t.REASON, t.org_name orgNo , getorgnames(t.org_no) ORGNAME from PMS.T_PATROL_TASK t where 1=1 and t.task_no like :1 and t.grid_kind_cd = :2 and t.org_no like GETORGNO( :3 ) order by t.fill_date desc
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;
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)
1hnz140zn79uvSELECT T.ORG_NAME FROM SGPM.O_ORG T WHERE T.ORG_NO=:B1
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
21w7mktubd1dqSELECT :B2 , T.CAN_BE_NULL, T.MIN_STR_LEN, T.MAX_STR_LEN, T.MIN_NUM_VAL, T.MAX_NUM_VAL, T.NUM_PRECISION, T.MIN_DATE_VAL, T.MAX_DATE_VAL, T.ATTR_CLS FROM OL$_ATTR_CONSTRAINTS T WHERE T.ATTR_URI = :B1
244v8yhfs7urrSELECT C.CLS_ID, C.CLS_URI, C.PKG_URI, C.CLS_NAME, C.CLS_DISP_NAME, C.CLS_INDEX, C.CLS_LEVEL, C.CLS_LOGGABLE, C.CLS_ABSTRACT, C.CLS_DOC, C.CLS_SORT FROM OL$_CLASSES C, OL$_ASSOCIATION_CONSTRAINTS AC WHERE C.CLS_URI = AC.SIDE_B AND C.CLS_SORT = 'T' AND AC.SIDE_A = :1
2p70njsc3jdvyDELETE FROM SGPM.P_TASK_ASSIGN A WHERE A.APP_NO = :B1
2q93zsrvbdw48select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
3tw8g2mwh4kgcSELECT * FROM (SELECT D.OBJ_ID, D.CLS_URI, D.NAME, GETNAMEPATHBYIDPATH(M.PATHNAME || '\' || D.OBJ_ID) PATHNAME, C.CLS_DISP_NAME DISNAME FROM (SELECT ASS.A, ASS.B FROM OLIVE.OL$_ASSOCIATIONS ASS START WITH ASS.A = :1 ---- ¶¥²ãÉ豸ÈÝÆ÷id CONNECT BY PRIOR ASS.B = A) E, OLIVE.V$_ST_ASSET D, OLIVE.OL$_CLASSES C, OLIVE.V$_ST_IDENTIFIEDOBJECT M WHERE D.OBJ_ID = E.B AND M.OBJ_ID = E.A AND D.CLS_URI IN(:2) AND C.CLS_URI = D.CLS_URI AND D.ASSETSSTATUS = 'S' AND D.ORGID = :3) E ORDER BY E.PATHNAME
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;
47r1y8yn34jmjselect default$ from col$ where rowid=:1
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4nwucqtxta4mtSELECT T.INSTANCE_LABEL, T.ACTIVITY_NAME FROM WF_PROCESS_ACTIVITIES T WHERE T.INSTANCE_ID = :B1
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
5bhhxz06fvgnk SELECT OBJ_ID, NAME, A.CLS_URI, A.PATHNAME, C.CLS_DISP_NAME, (CASE WHEN A.CLS_URI LIKE 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/%' THEN (SELECT GETPATHNAMEBYPATHID(P1.PATHNAME || A.PATHNAME) FROM OL$_ASSOCIATIONS ASS, V$_ST_POWERSYSTEMRESOURCE P1, V$_ST_POWERSYSTEMRESOURCE P2 WHERE ASS.AST_URI = 'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"' AND ASS.B = SUBSTR(A.PATHNAME, 2, 64) AND ASS.A = P1.OBJ_ID AND P1.PATHNAME LIKE P2.PATHNAME || '%' AND ROWNUM = 1 AND P2.OBJ_ID IN (:1)) ELSE GETPATHNAMEBYPATHID(PATHNAME) END) PATHNAMEVALUE FROM V$_ST_IDENTIFIEDOBJECT A, OLIVE.OL$_CLASSES C WHERE C.CLS_URI = A.CLS_URI AND OBJ_ID IN(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, : 97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163, :164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178, :179, :180, :181, :182, :183, :184, :185, :186, :187, :188, :189, :190, :191, :192, :193, :194, :195, :196, :197, :198, :199, :200, :201, :202, :203, :204, :205, :206, :207, :208, :209, :210, :211, :212, :213, :214, :215, :216, :217, :218, :219, :220, :221, :222, :223, :224, :225, :226, :227, :228, :229, :230, :231, :232, :233, :234, :235, :236, :237, :238, :239, :240, :241, :242, :243, :244, :245, :246, :247, :248, :249, :250, :251, :252, :253, :254, :255, :256, :257, :258, :259, :260, :261, :262, :263, :264, :265, :266, :267, :268, :269, :270, :271, :272, :273, :274, :275, :276, :277, :278, :279, :280, :281, :282, :283, :284, :285, :286, :287, :288, :289, :290, :291, :292, :293, :294, :295, :296, :297, :298, :299, :300, :301, :302, :303, :304, :305, :306, :307, :308, :309, :310, :311, :312, :313, :314, :315, :316, :317, :318, :319, :320, :321, :322, :323, :324, :325, :326, :327, :328, :329, :330, :331, :332, :333, :334, :335, :336, :337, :338, :339, :340, :341, :342, :343, :344, :345, :346, :347 , :348, :349, :350, :351, :352, :353, :354, :355, :356, :357, :358, :359, :360, :361, :362, :363, :364, :365, :366, :367, :368, :369, :370, :371, :372, :373, :374, :375, :376, :377, :378, :379, :380, :381, :382, :383, :384, :385, :386, :387, :388, :389, :390, :391, :392, :393, :394, :395, :396, :397, :398, :399, :400, :401, :402, :403, :404, :405, :406, :407, :408, :409, :410, :411, :412, :413, :414, :415, :416, :417, :418, :419, :420, :421, :422, :423, :424, :425, :426, :427, :428, :429, :430, :431, :432, :433, :434, :435, :436, :437, :438, :439, :440, :441, :442, :443, :444, :445, :446, :447, :448, :449, :450, :451, :452, :453, :454, :455, :456, :457, :458, :459, :460, :461, :462, :463, :464, :465, :466, :467, :468, :469, :470, :471, :472, :473, :474, :475, :476, :477, :478, :479, :480, :481, :482, :483, :484, :485, :486, :487, :488, :489, :490, :491, :492, :493, :494, :495, :496, :497, :498, :499, :500, :501, :502, :503, :504, :505, :506, :507, :508, :509, :510, :511, :512, :513, :514, :515, :516, :517, :518, :519, :520, :521, :522, :523, :524, :525, :526, :527, :528, :529, :530, :531, :532, :533, :534, :535, :536, :537, :538, :539, :540, :541, :542, :543, :544, :545, :546, :547, :548, :549, :550, :551, :552, :553, :554, :555, :556, :557, :558, :559, :560, :561, :562, :563, :564, :565, :566, :567, :568, :569, :570, :571, :572, :573, :574, :575, :576, :577, :578, :579, :580, :581, :582, :583, :584, :585, :586, :587, :588, :589, :590, :591, :592, :593, :594, :595, :596, :597 , :598, :599, :600, :601, :602, :603, :604, :605, :606, :607, :608, :609, :610, :611, :612, :613, :614, :615, :616, :617, :618, :619, :620, :621, :622, :623, :624, :625, :626, :627, :628, :629, :630, :631, :632, :633, :634, :635, :636, :637, :638, :639, :640, :641, :642, :643, :644, :645, :646, :647, :648, :649, :650, :651, :652, :653, :654, :655, :656, :657, :658, :659, :660, :661, :662, :663, :664, :665, :666, :667, :668, :669, :670, :671, :672, :673, :674, :675, :676, :677, :678, :679, :680, :681, :682, :683, :684, :685, :686, :687, :688, :689, :690, :691, :692, :693, :694, :695, :696, :697, :698, :699, :700, :701, :702, :703, :704, :705, :706, :707, :708, :709, :710, :711, :712, :713, :714, :715, :716, :717, :718, :719, :720, :721, :722, :723, :724, :725, :726, :727, :728, :729, :730, :731, :732, :733, :734, :735, :736, :737, :738, :739, :740, :741, :742, :743, :744, :745, :746, :747, :748, :749, :750, :751, :752, :753, :754, :755, :756, :757, :758, :759, :760, :761, :762, :763, :764, :765, :766, :767, :768, :769, :770, :771, :772, :773, :774, :775, :776, :777, :778, :779, :780, :781, :782, :783, :784, :785, :786, :787, :788, :789, :790, :791, :792, :793, :794, :795, :796, :797, :798, :799, :800, :801) ORDER BY A.CLS_URI , A.PATHNAME
5n9d2rmutsfqvselect t.* from ol$_attr_categories t where t.cls_uri=:1 order by t.cat_index
5qr55krh9dkx5 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 , 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 a.WEEK_PLAN_CD =:1
5v8y4xqjc73kvSELECT Q1.B OBJ_ID FROM OLIVE.OL$_QUOTEASSOCIATIONS Q1, OLIVE.OL$_QUOTEASSOCIATIONS Q2 WHERE Q1.AST_URI = Q2.AST_URI AND Q1.A = Q2.A AND Q2.B = :1
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 ))
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
6769wyy3yf66fselect pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6aq34nj2zb2n7select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6pcrpqf5dkunfselect /*+ index(o PK_OL$_OBJECTS) */ * from v$_DYPolePosition o where obj_id=:1
6xjqy1675jdyrselect * from v$_ST_EquipmentContainer 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 name
6xz0c679sk859SELECT NAME FROM V$_ST_IDENTIFIEDOBJECT WHERE OBJ_ID = :B1
750bnanjunuhhDELETE FROM OWF_MGR.WF_NOTIFICATIONS T WHERE EXISTS( SELECT 1 FROM OWF_MGR.WF_ITEM_ACTIVITY_STATUSES B WHERE B.ITEM_TYPE=:B2 AND B.ITEM_KEY = :B1 AND B.NOTIFICATION_ID=T.NOTIFICATION_ID)
7hft0rhsu4hh2UPDATE WF_NOTIFICATIONS SET FROM_USER = :B5 , FROM_ROLE = NVL(:B4 , FROM_ROLE), TO_USER = :B3 , SUBJECT = :B2 , LANGUAGE = USERENV('LANG') WHERE NOTIFICATION_ID = :B1
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
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
830q1znx77va1BEGIN OL$_CORE_EXPAND.LINESUPPORTACCESS(:1, :2, :3); END;
83taa7kaw59c1select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
88awc7wsyhuwmupdate ol$_objects set S_73 = :S_73, N_06 = :N_06, S_03 = :S_03, N_52 = :N_52, S_32 = :S_32, N_09 = :N_09, S_01 = :S_01, O_01 = :O_01, D_03 = :D_03, S_60 = :S_60, N_51 = :N_51, S_39 = :S_39, S_30 = :S_30, N_42 = :N_42, O_08 = :O_08, S_22 = :S_22, O_06 = :O_06, D_07 = :D_07, O_07 = :O_07, O_31 = :O_31, O_05 = :O_05, S_63 = :S_63, O_14 = :O_14, S_40 = :S_40, S_33 = :S_33, O_04 = :O_04, S_57 = :S_57, S_43 = :S_43, S_75 = :S_75, D_05 = :D_05, S_05 = :S_05, N_07 = :N_07, O_29 = :O_29, O_02 = :O_02, O_10 = :O_10, D_06 = :D_06, S_34 = :S_34, O_25 = :O_25, N_10 = :N_10, S_42 = :S_42, O_15 = :O_15, O_26 = :O_26, D_10 = :D_10, S_15 = :S_15, D_04 = :D_04, O_24 = :O_24, S_27 = :S_27, S_04 = :S_04, O_27 = :O_27, S_02 = :S_02, D_08 = :D_08, S_76 = :S_76, O_03 = :O_03, S_68 = :S_68, D_01 = :D_01, S_21 = :S_21, S_35 = :S_35, S_31 = :S_31, S_36 = :S_36 where obj_id = :objId
88h1jt12xms4pINSERT INTO WF_AMBER.INDYSP_TASK_USER_HIS (APP_NO, TASKID, PRIV_CODE, TASK_TYPE, USER_NO, USER_DEPT_NO, USER_ORG_NO, PROCESS_ORG_NO, CREATE_TIME, CREATE_TYPE, WORKLIST_TYPE) SELECT A.APP_NO, A.TASKID, A.PRIV_CODE, A.TASK_TYPE, A.USER_NO, A.USER_DEPT_NO, A.USER_ORG_NO, A.PROCESS_ORG_NO, SYSDATE, CREATE_TYPE, WORKLIST_TYPE FROM WF_AMBER.INDYSP_TASK_USER_CUR A WHERE TASKID = :B1
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
8p7gycr8uy2j7update ol$_objects set S_04 = :S_04, S_27 = :S_27, S_32 = :S_32, O_04 = :O_04, O_05 = :O_05, S_06 = :S_06, N_07 = :N_07, O_07 = :O_07, D_05 = :D_05, S_68 = :S_68, N_42 = :N_42, O_25 = :O_25, O_03 = :O_03, O_06 = :O_06, S_40 = :S_40, O_31 = :O_31, S_63 = :S_63, N_51 = :N_51, S_31 = :S_31, D_04 = :D_04, S_17 = :S_17, O_08 = :O_08, D_06 = :D_06, O_01 = :O_01, S_05 = :S_05, S_75 = :S_75, N_52 = :N_52, S_42 = :S_42, S_02 = :S_02, O_26 = :O_26, N_10 = :N_10, S_34 = :S_34, N_01 = :N_01, O_29 = :O_29, N_09 = :N_09, S_35 = :S_35, S_01 = :S_01, N_02 = :N_02, S_03 = :S_03, O_02 = :O_02, S_22 = :S_22, D_03 = :D_03, S_15 = :S_15, S_07 = :S_07, O_27 = :O_27, O_24 = :O_24, S_14 = :S_14, D_10 = :D_10, S_76 = :S_76, S_21 = :S_21, S_73 = :S_73, D_07 = :D_07, S_39 = :S_39, S_36 = :S_36, D_08 = :D_08, D_01 = :D_01 where obj_id = :objId
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
8txqupfzzqh39select * from v$_ST_EquipmentContainer 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
8u5s8xhp48xm2SELECT * FROM (SELECT D.OBJ_ID, D.CLS_URI, D.NAME, GETNAMEPATHBYIDPATH(M.PATHNAME || '\' || D.OBJ_ID) PATHNAME, C.CLS_DISP_NAME DISNAME FROM (SELECT ASS.A, ASS.B FROM OLIVE.OL$_ASSOCIATIONS ASS START WITH ASS.A = :1 ---- ¶¥²ãÉ豸ÈÝÆ÷id CONNECT BY PRIOR ASS.B = A) E, OLIVE.V$_ST_ASSET D, OLIVE.OL$_CLASSES C, OLIVE.V$_ST_IDENTIFIEDOBJECT M WHERE D.OBJ_ID = E.B AND M.OBJ_ID = E.A AND D.CLS_URI IN(:2) AND D.NAME LIKE :3 AND C.CLS_URI = D.CLS_URI AND D.ASSETSSTATUS = 'S' AND D.ORGID = :4) E ORDER BY E.PATHNAME
91d0kuahyy84bSELECT tmp.* FROM (SELECT l.obj_id id, l.name, l.orgid org_no, (SELECT o.org_name FROM sgpm.o_org o WHERE o.org_no = l.orgid) org_name, l.pathname path_name, length(l.pathname) / 65 - 4 tree_level, l.voltagelevel voltage_level, l.tconnectid branch_dist_line_node_id, (SELECT p.lpsequence FROM olive.v$_st_transmispoleposition p WHERE l.tconnectid = p.obj_id AND p.resourcestatus = :1) branch_node_lpsequence, olive.ol$_object_util.getparentid(l.pathname) parent_distline_id, l.starsubstation substation_id, l.kgbh dist_breaker_id FROM olive.v$_st_feeder l WHERE l.pathname LIKE :2 AND l.resourcestatus = :3) tmp ORDER BY tmp.tree_level ASC, tmp.branch_node_lpsequence ASC
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
95ugsq968zru6SELECT T.ORG_NAME FROM SGPM.O_ORG T WHERE T.ORG_NO = SUBSTR(:B1 , 0, 5)
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;
9qgtwh66xg6nzupdate seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
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
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
9yh5wgu938tjaBEGIN OL$_CORE_EXPAND.Batchinserviceasset(:1); END;
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
a3rvzd26ud0vuDELETE INDYWF_WORKLIST_CUR WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND DEPT_NAME = :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
abhn803avcumhSELECT A.USER_BUREAU_NAME FROM AMBER.INDY_USER A WHERE A.USER_NAME=UPPER(:B1 )
apd7t7sfn2wxdSELECT Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) pathName, Pc.OBJ_ID resourceId FROM V$_ST_ASSET Ass, OL$_ASSOCIATIONS O, V$_ST_POWERSYSTEMRESOURCE Pc WHERE Ass.OBJ_ID =:1 AND O.B = SUBSTR(Ass.PATHNAME, 2, 64) AND Pc.OBJ_ID = O.A AND O.AST_URI =:2
apsygukcr19bqSELECT R.NAME, SUBSTRB(R.DISPLAY_NAME, 1, 360), SUBSTRB(R.DESCRIPTION, 1, 1000), R.NOTIFICATION_PREFERENCE, R.LANGUAGE, R.TERRITORY, SUBSTRB(R.EMAIL_ADDRESS, 1, 320), R.FAX, R.STATUS, R.EXPIRATION_DATE, R.ORIG_SYSTEM, R.ORIG_SYSTEM_ID FROM WF_ROLES R WHERE R.NAME = :B1 AND R.ORIG_SYSTEM NOT IN ('HZ_PARTY', 'POS', 'ENG_LIST', 'AMV_CHN', 'HZ_GROUP', 'CUST_CONT')
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
aw6gj3r2syaxsselect interdata.area_code, interdata.area_name, interdata.sub_area_code, interdata.sub_area_name, to_char(Min(interdata.import_time), 'yyyy-mm-dd hh24:mi:ss') as fartime, to_char(Max(interdata.import_time), 'yyyy-mm-dd hh24:mi:ss') as neartime, sum(1) As sczcs, sum(Case When interdata.handle_flag = '2' Then 1 When (interdata.handle_flag = '3' or interdata.handle_flag = '4') Then 0 End) as sccgcs, sum(Case When (interdata.handle_flag = '0' or interdata.handle_flag = '1') Then 1 When (interdata.handle_flag = '2' or interdata.handle_flag = '3' or interdata.handle_flag = '4') Then 0 End) as clzzcs, sum(Case When interdata.handle_flag = '2' Then 0 When (interdata.handle_flag = '3' or interdata.handle_flag = '4') Then 1 End) as yccs from scada.scada_interface_data_bd interData where 1=1 and interData.area_code = 'dqid' Group By interdata.area_code, interdata.area_name, interdata.sub_area_code, interdata.sub_area_name order by interdata.area_code, interdata.sub_area_code
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
b3gxg1nhmrvnfselect /*+ index(o PK_OL$_OBJECTS) */ * from v$_ST_CountySubRegion 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
c5tmjxj6rtck4SELECT mis_t.tg_id id, (SELECT mis_area.tg_cap FROM v_mis_tg@ypjc mis_area WHERE mis_area.tg_id = mis_t.tg_id) capacity, (SELECT mis_area.tg_name FROM v_mis_tg@ypjc mis_area WHERE mis_area.tg_id = mis_t.tg_id) name, (SELECT mis_area.org_no FROM v_mis_tg@ypjc mis_area WHERE mis_area.tg_id = mis_t.tg_id) org_no FROM mis_pms_tran_map@ypjc m, v_mis_g_tran@ypjc mis_t WHERE m.equip_id = mis_t.equip_id AND m.org_no LIKE :1 AND mis_t.org_no LIKE :2 AND m.distran_object_id IN ( :3)
cfrwbnuu2xtamselect side_b from ol$_association_constraints where association_type = :1 and side_a = :2
cjy09frsxfv7nSELECT COUNT(*) FROM T_YXDZ_CZPBH WHERE PROCESSID IN (SELECT PROCESSID FROM T_YXDZ_CZPXX T WHERE JHRDM = :B3 AND TO_CHAR(NPSJ, 'yyyymm') = :B2 AND CZPZL = :B1 AND T.CZPBH IS NOT NULL)
cma6d053zrny3update ol$_objects set S_35 = :S_35, D_01 = :D_01, S_76 = :S_76, S_15 = :S_15, S_03 = :S_03, O_25 = :O_25, O_26 = :O_26, D_08 = :D_08, S_22 = :S_22, O_03 = :O_03, S_21 = :S_21, N_07 = :N_07, S_36 = :S_36, O_07 = :O_07, O_24 = :O_24, N_42 = :N_42, S_04 = :S_04, O_29 = :O_29, O_27 = :O_27, N_09 = :N_09, O_31 = :O_31, D_03 = :D_03, S_02 = :S_02, S_05 = :S_05, O_01 = :O_01, N_10 = :N_10, O_05 = :O_05, D_05 = :D_05, D_04 = :D_04, S_40 = :S_40, N_52 = :N_52, S_39 = :S_39, S_42 = :S_42, D_07 = :D_07, N_02 = :N_02, O_04 = :O_04, N_51 = :N_51, S_27 = :S_27, S_34 = :S_34, D_06 = :D_06, S_68 = :S_68, D_10 = :D_10, S_73 = :S_73, S_01 = :S_01, O_06 = :O_06, S_32 = :S_32, S_75 = :S_75, S_63 = :S_63, S_31 = :S_31 where obj_id = :objId
cr5dhraqryr2fInsert Into V$_St_Transmispoleposition_Tem Select /*+index(V$_St_Transmispoleposition, IDX_OL$_OBJECTS_CLS_PATHNAME)*/ V$_St_Transmispoleposition.*, 'D' From V$_St_Transmispoleposition Where Pathname Like :1 And Pathname = :2 ||Obj_Id And Resourcestatus = 'E' And Orgid= :3
cs4fxq1s9xvycUPDATE OLIVE.V$_ST_ASSET X SET X.ASSETSSTATUS = 'S' WHERE X.OBJ_ID IN (SELECT AA.OBJ_ID FROM OLIVE.V$_ST_ASSET A, OLIVE.V$_ST_ASSET AA WHERE AA.ORGID = A.ORGID AND A.ORGID = :B1 AND AA.ASSETSSTATUS = 'W' AND AA.PATHNAME LIKE A.PATHNAME || '%' AND A.OBJ_ID IN (SELECT /*+index(p, IDX_OL$_OBJECTS_CLS_PATHNAME)*/ T.B FROM OLIVE.V$_ST_POWERSYSTEMRESOURCE P, OLIVE.OL$_ASSOCIATIONS T WHERE T.A = P.OBJ_ID AND P.PATHNAME LIKE :B2 || '%' AND P.ORGID = :B1 ))
cv0rtthxrhdxySELECT O.S_04 || :B2 FROM OL$_ASSOCIATIONS A, OL$_OBJECTS O WHERE A.A = O.OBJ_ID AND A.B = :B1 AND ROWNUM = 1
czknwx2xjru6ySELECT COUNT(*) FROM T_YXDZ_CZPXX T WHERE JHRDM = :B3 AND TO_CHAR(NPSJ, 'yyyymm') = :B2 AND CZPZL = :B1 AND T.CZPBH IS NOT NULL
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 )
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
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
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 )
dpqpcqn109dcjselect * from st_institution_resource sr, olive.ol$_classes c where sr.childresourcetype=c.cls_uri(+) and sr.INSTITUTIONID =:1
dtun9pmgvp9a8SELECT COUNT(*) FROM T_YXDZ_CZPBH WHERE PROCESSID IN (SELECT PROCESSID FROM (SELECT T.PROCESSID, T.SHRDM, T.SHSJ FROM T_YXDZ_CZPXX T WHERE T.SHRDM LIKE '%' || :B3 || '%' AND TO_CHAR(T.SHSJ, 'yyyymm') = :B2 AND T.CZPZL = :B1 UNION SELECT H.PROCESSID, H.SHRID SHRDM, H.SHSJ FROM T_YXDZ_CZP_SHHJSHXX H, T_YXDZ_CZPXX X WHERE H.SHRID LIKE '%' || :B3 || '%' AND TO_CHAR(H.SHSJ, 'yyyymm') = :B2 AND H.PROCESSID = X.PROCESSID AND X.CZPZL = :B1 ))
dvqv84updkxncSELECT T.OBJ_ID, T.CLS_URI, T.LPSEQUENCE, (SELECT C.CLS_VIEW FROM OL$_CLASSES C WHERE C.CLS_URI = T.CLS_URI) CLS_VIEW FROM V$_ST_POSITION T, OL$_ASSOCIATIONS S WHERE T.OBJ_ID = S.B AND S.AST_URI = 'OLASSOCIATIONTYPE://ST_IdentifiedObject_ST_IdentifiedObject?A="OLCLASS://Entity/ST_IdentifiedObject"&B="OLCLASS://Entity/ST_IdentifiedObject"' AND T.LPSEQUENCE > :B3 AND S.A = :B2 AND T.ORGID = :B1
f8pavn1bvsj7tselect con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1
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
fasvw7q199577select u.name, o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o, user$ u, trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user# and bitand(property, 16)=0 and bitand(property, 8)=0 order by o.obj#
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
fdckt0yps3750 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 AND a.name LIKE :4 ORDER BY compute_date
ff40ndudptw4cDELETE FROM INDY_ONLINE_USER WHERE LOG_LINK_ID=:B1
fkg1futrvwzbgSELECT COUNT(1) FROM OL$_ASSOCIATIONS ASS WHERE B = :B1
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;
g73tzgnm4722fselect u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o, user$ u, trigger$ where bitand(trigger$.property, 16) = 16 and trigger$.baseobject = :1 and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj#
gf8k0n5kg6hy2SELECT T.OBJ_ID, T.CLS_URI, T.NAME, T.PATHNAME, GETNAMEPATHBYIDPATH(T.PATHNAME) PATHNAMEVALUE , T.RESOURCESTATUS, T.INSERVICEDATE, T.VOLTAGELEVEL, T.LPSEQUENCE, T.OPERATEDEPTID, T.XPOSITION, T.YPOSITION FROM V$_ST_POSITION T, OL$_ASSOCIATIONS S WHERE T.OBJ_ID = S.B AND S.AST_URI = :1 AND S.A = :2 AND T.orgId='1340612' AND RESOURCESTATUS= :3
gkw6wc3pm09j6SELECT USER_NAME FROM AMBER.INDY_USER_ACTION U WHERE U.ACTION_NAME=:1
grwydz59pu6mcselect text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 151,591 84.09 3.55
CPU used when call started 150,311 83.38 3.52
CR blocks created 2,777 1.54 0.06
Cached Commit SCN referenced 5,104,100 2,831.17 119.44
Commit SCN cached 7 0.00 0.00
DB time 1,068,558 592.71 25.00
DBWR checkpoint buffers written 62,970 34.93 1.47
DBWR checkpoints 4 0.00 0.00
DBWR fusion writes 17,804 9.88 0.42
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 143 0.08 0.00
DBWR undo block writes 10,468 5.81 0.24
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 10 0.01 0.00
DML statements parallelized 0 0.00 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 35 0.02 0.00
PX local messages sent 35 0.02 0.00
PX remote messages recv'd 179 0.10 0.00
PX remote messages sent 121 0.07 0.00
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 10 0.01 0.00
RowCR - row contention 807 0.45 0.02
RowCR attempts 78,548 43.57 1.84
RowCR hits 78,564 43.58 1.84
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for undo segment recovery 1 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 5,160,690 2,862.56 120.76
SQL*Net roundtrips to/from dblink 115,667 64.16 2.71
active txn count during cleanout 11,771 6.53 0.28
application wait time 213 0.12 0.00
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 14,971 8.30 0.35
branch node splits 54 0.03 0.00
buffer is not pinned count 48,677,166 27,000.48 1,139.05
buffer is pinned count 69,680,085 38,650.48 1,630.52
bytes received via SQL*Net from client 389,247,355 215,909.55 9,108.40
bytes received via SQL*Net from dblink 18,940,788 10,506.17 443.21
bytes sent via SQL*Net to client 4,316,642,958 2,394,375.81 101,009.55
bytes sent via SQL*Net to dblink 14,240,530 7,899.00 333.23
calls to get snapshot scn: kcmgss 8,667,184 4,807.55 202.81
calls to kcmgas 310,629 172.30 7.27
calls to kcmgcs 8,926 4.95 0.21
change write time 745 0.41 0.02
cleanout - number of ktugct calls 23,682 13.14 0.55
cleanouts and rollbacks - consistent read gets 698 0.39 0.02
cleanouts only - consistent read gets 11,350 6.30 0.27
cluster key scan block gets 397,811 220.66 9.31
cluster key scans 312,717 173.46 7.32
cluster wait time 60,136 33.36 1.41
commit batch performed 278 0.15 0.01
commit batch requested 278 0.15 0.01
commit batch/immediate performed 348 0.19 0.01
commit batch/immediate requested 348 0.19 0.01
commit cleanout failures: block lost 495 0.27 0.01
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 4,375 2.43 0.10
commit cleanout failures: cannot pin 5 0.00 0.00
commit cleanouts 196,709 109.11 4.60
commit cleanouts successfully completed 191,834 106.41 4.49
commit immediate performed 70 0.04 0.00
commit immediate requested 70 0.04 0.00
commit txn count during cleanout 30,139 16.72 0.71
concurrency wait time 4,369 2.42 0.10
consistent changes 111,694 61.95 2.61
consistent gets 194,196,171 107,717.64 4,544.19
consistent gets - examination 50,098,471 27,788.86 1,172.31
consistent gets direct 14,873 8.25 0.35
consistent gets from cache 194,181,228 107,709.36 4,543.85
current blocks converted for CR 35 0.02 0.00
cursor authentications 10,717 5.94 0.25
data blocks consistent reads - undo records applied 3,764 2.09 0.09
db block changes 946,125 524.80 22.14
db block gets 1,280,137 710.07 29.96
db block gets direct 7,257 4.03 0.17
db block gets from cache 1,272,880 706.05 29.79
deferred (CURRENT) block cleanout applications 88,365 49.01 2.07
dirty buffers inspected 20,303 11.26 0.48
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 238,480 132.28 5.58
enqueue deadlocks 0 0.00 0.00
enqueue releases 553,701 307.13 12.96
enqueue requests 553,699 307.13 12.96
enqueue timeouts 0 0.00 0.00
enqueue waits 1,006 0.56 0.02
exchange deadlocks 9 0.00 0.00
execute count 5,536,641 3,071.09 129.56
failed probes on index block reclamation 1 0.00 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 3,418,280 1,896.07 79.99
free buffer requested 3,339,364 1,852.29 78.14
gc CPU used by this session 54,575 30.27 1.28
gc blocks corrupt 0 0.00 0.00
gc blocks lost 0 0.00 0.00
gc cr block build time 138 0.08 0.00
gc cr block flush time 22 0.01 0.00
gc cr block receive time 5,011 2.78 0.12
gc cr block send time 333 0.18 0.01
gc cr blocks received 99,580 55.24 2.33
gc cr blocks served 88,513 49.10 2.07
gc current block flush time 36 0.02 0.00
gc current block pin time 896 0.50 0.02
gc current block receive time 123,040 68.25 2.88
gc current block send time 3,598 2.00 0.08
gc current blocks received 1,380,134 765.54 32.30
gc current blocks served 978,851 542.95 22.91
gc local grants 872,864 484.16 20.43
gc remote grants 966,068 535.86 22.61
gcs messages sent 5,052,989 2,802.82 118.24
ges messages sent 226,778 125.79 5.31
global enqueue get time 4,212 2.34 0.10
global enqueue gets async 143,194 79.43 3.35
global enqueue gets sync 850,046 471.51 19.89
global enqueue releases 994,644 551.71 23.27
global undo segment hints helped 0 0.00 0.00
heap block compress 7,979 4.43 0.19
hot buffers moved to head of LRU 4,598,890 2,550.93 107.61
immediate (CR) block cleanout applications 12,048 6.68 0.28
immediate (CURRENT) block cleanout applications 24,524 13.60 0.57
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 22,081 12.25 0.52
index fast full scans (full) 104,845 58.16 2.45
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 14,498,999 8,042.37 339.28
index scans kdiixs1 5,319,721 2,950.77 124.48
leaf node 90-10 splits 75 0.04 0.00
leaf node splits 2,079 1.15 0.05
lob reads 13,299 7.38 0.31
lob writes 30,157 16.73 0.71
lob writes unaligned 29,885 16.58 0.70
local undo segment hints helped 0 0.00 0.00
local undo segment hints were stale 0 0.00 0.00
logons cumulative 168 0.09 0.00
messages received 273,254 151.57 6.39
messages sent 273,254 151.57 6.39
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 140,831,954 78,117.33 3,295.47
opened cursors cumulative 864,319 479.42 20.23
parse count (failures) 5,322 2.95 0.12
parse count (hard) 98,835 54.82 2.31
parse count (total) 614,524 340.87 14.38
parse time cpu 3,790 2.10 0.09
parse time elapsed 19,857 11.01 0.46
physical read IO requests 696,891 386.55 16.31
physical read bytes 14,919,409,664 8,275,568.28 349,114.54
physical read total IO requests 803,284 445.57 18.80
physical read total bytes 16,660,152,320 9,241,131.60 389,847.95
physical read total multi block requests 96,226 53.38 2.25
physical reads 1,821,217 1,010.20 42.62
physical reads cache 1,806,346 1,001.95 42.27
physical reads cache prefetch 1,215,327 674.12 28.44
physical reads direct 14,871 8.25 0.35
physical reads direct (lob) 14,207 7.88 0.33
physical reads direct temporary tablespace 5 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 89,718 49.77 2.10
physical write bytes 888,430,592 492,798.86 20,789.30
physical write total IO requests 183,166 101.60 4.29
physical write total bytes 1,460,681,728 810,217.81 34,179.99
physical write total multi block requests 88,185 48.91 2.06
physical writes 108,451 60.16 2.54
physical writes direct 7,257 4.03 0.17
physical writes direct (lob) 5,796 3.21 0.14
physical writes direct temporary tablespace 1,435 0.80 0.03
physical writes from cache 101,194 56.13 2.37
physical writes non checkpoint 95,556 53.00 2.24
pinned buffers inspected 67 0.04 0.00
pinned cursors current 116 0.06 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 68 0.04 0.00
process last non-idle time 1,655 0.92 0.04
queries parallelized 10 0.01 0.00
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 11,625,216 6,448.33 272.03
recursive cpu usage 56,636 31.42 1.33
redo blocks written 518,519 287.61 12.13
redo buffer allocation retries 0 0.00 0.00
redo entries 513,347 284.75 12.01
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 10,241 5.68 0.24
redo size 245,210,872 136,014.72 5,737.94
redo subscn max counts 4,457 2.47 0.10
redo synch time 6,817 3.78 0.16
redo synch writes 42,794 23.74 1.00
redo wastage 11,762,928 6,524.72 275.25
redo write broadcast ack time 882 0.49 0.02
redo write time 3,617 2.01 0.08
redo writer latching time 5 0.00 0.00
redo writes 44,954 24.94 1.05
rollback changes - undo records applied 3,907 2.17 0.09
rollbacks only - consistent read gets 710 0.39 0.02
root node splits 0 0.00 0.00
rows fetched via callback 8,253,502 4,578.09 193.13
session connect time 0 0.00 0.00
session cursor cache hits 581,683 322.65 13.61
session logical reads 195,476,997 108,428.10 4,574.17
shared hash latch upgrades - no wait 543,426 301.43 12.72
shared hash latch upgrades - wait 393 0.22 0.01
sorts (disk) 0 0.00 0.00
sorts (memory) 418,101 231.91 9.78
sorts (rows) 20,613,783 11,434.15 482.36
space was found by tune down 0 0.00 0.00
sql area evicted 90,855 50.40 2.13
sql area purged 5,335 2.96 0.12
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 30,127 16.71 0.70
switch current to new buffer 9,884 5.48 0.23
table fetch by rowid 46,280,467 25,671.07 1,082.96
table fetch continued row 241,590 134.01 5.65
table scan blocks gotten 70,396,898 39,048.08 1,647.29
table scan rows gotten 814,447,369 451,761.50 19,058.09
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 0 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 680,080 377.23 15.91
total number of times SMON posted 5 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 348 0.19 0.01
transaction tables consistent read rollbacks 9 0.00 0.00
transaction tables consistent reads - undo records applied 1,032 0.57 0.02
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 69,940,332 38,794.83 1,636.61
user I/O wait time 262,253 145.47 6.14
user calls 5,509,894 3,056.25 128.93
user commits 41,491 23.01 0.97
user rollbacks 1,244 0.69 0.03
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 284,246 157.67 6.65
write clones created in background 0 0.00 0.00
write clones created in foreground 5 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 6.7E+13 6.7E+13
session cursor cache count 11,297,203 11,300,082
session uga memory 6.5E+14 6.5E+14
opened cursors current 35,520 36,015
workarea memory allocated 5,878 15,790
logons current 1,773 1,783
session uga memory max 4.8E+12 4.8E+12
session pga memory 2.4E+12 2.4E+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 352,275 195 4.24 3.18 17,601 10 1,158 3.13
IDX_OL 197,506 110 4.73 1.00 26,866 15 1,110 1.46
IDX_SCA7 18,820 10 5.60 1.00 17,602 10 1 0.00
DATA_P 29,469 16 3.25 1.01 1,042 1 26,501 2.36
DATA_WF 23,551 13 4.66 1.26 3,759 2 5,116 1.41
IDX_WF 8,360 5 5.03 1.00 5,754 3 751 1.77
DATA_SCA4 9,402 5 3.05 5.22 34 0 4,078 2.90
DATA_SCA5 6,737 4 3.59 6.10 41 0 4,042 2.74
IDX_P 4,790 3 4.71 1.00 1,856 1 2,969 3.25
SYSTEM 6,266 3 3.92 1.00 122 0 0 0.00
TEMP 1,472 1 0.35 1.00 3,073 2 0 0.00
DATA_BI9 4,240 2 3.05 2.32 0 0 0 0.00
DATA_SCA3 4,022 2 1.42 12.53 32 0 3,000 2.15
DATA_SCA2 3,968 2 1.52 12.76 44 0 2,913 2.22
DATA_SCA1 3,796 2 1.71 13.33 39 0 2,936 2.10
IDX_SCA 3,283 2 2.80 13.42 366 0 0 0.00
DATA_YP 684 0 4.05 1.03 2,919 2 0 0.00
DATA_SCA6 3,464 2 1.53 10.99 36 0 3,977 2.14
DATA_SCA8 3,059 2 1.96 12.34 44 0 3,994 2.17
IDX_SG 1,153 1 5.19 1.00 1,833 1 0 0.00
DATA_SCA7 2,898 2 1.39 12.90 41 0 3,977 2.02
DATA_BI7 2,511 1 3.32 2.81 0 0 0 0.00
DATA_SG 423 0 5.08 1.02 1,449 1 0 0.00
SYSAUX 1,427 1 4.09 1.06 432 0 0 0.00
LOB_SCA 0 0 0.00 0.00 1,854 1 0 0.00
UNDOTBS1 435 0 3.49 1.00 969 1 11 0.00
DATA_BI 1,072 1 4.68 5.64 0 0 0 0.00
IDX_SCA6 321 0 5.89 1.00 205 0 0 0.00
IDX_SCA5 315 0 5.56 1.00 199 0 0 0.00
IDX_SCA4 325 0 4.86 1.00 183 0 0 0.00
IDX_SCA3 314 0 5.67 1.00 192 0 0 0.00
DATA_SCA15 65 0 6.62 1.00 73 0 0 0.00
DATA_SCA19 61 0 5.74 1.00 68 0 0 0.00
DATA_SCA20 63 0 5.24 1.00 60 0 0 0.00
DATA_SCA11 64 0 5.16 1.00 58 0 0 0.00
DATA_SCA22 63 0 5.87 1.00 59 0 0 0.00
DATA_SCA23 64 0 6.72 1.00 58 0 0 0.00
DATA_SCA21 58 0 5.86 1.00 63 0 0 0.00
DATA_SCA9 62 0 6.77 1.00 57 0 1 0.00
DATA_SCA14 61 0 7.38 1.00 52 0 0 0.00
DATA_SCA16 45 0 4.89 1.00 66 0 0 0.00
DATA_SCA18 47 0 4.68 1.00 63 0 0 0.00
DATA_SCA13 42 0 5.71 1.00 66 0 0 0.00
DATA_SCA10 43 0 5.81 1.00 60 0 0 0.00
DATA_SCA17 42 0 6.19 1.00 61 0 0 0.00
DATA_SCA24 31 0 7.10 1.00 59 0 0 0.00
DATA_SCA12 30 0 6.67 1.00 50 0 0 0.00
IDX_BI 48 0 7.29 1.00 0 0 0 0.00
IDX_BI1 46 0 2.39 1.00 0 0 0 0.00
IDX_SCA1 14 0 5.00 1.00 32 0 0 0.00
IDX_SCA2 14 0 5.71 1.00 29 0 0 0.00
IDX_YP 6 0 5.00 1.00 19 0 0 0.00
DATA_BI11 23 0 3.48 1.00 0 0 0 0.00
UNDOTBS2 7 0 4.29 1.00 0 0 0 0.00
USERS 2 0 15.00 1.00 0 0 0 0.00
DATA_BI12 0 0 0.00 0.00 1 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
DATA_BI /dev/rndmis_4g_003 43 0 3.26 4.19 0 0 0 0.00
DATA_BI /dev/rndmis_4g_025 31 0 2.90 4.81 0 0 0 0.00
DATA_BI /dev/rndmis_4g_030 53 0 2.83 3.23 0 0 0 0.00
DATA_BI /dev/rndmis_4g_037 20 0 6.00 6.90 0 0 0 0.00
DATA_BI /dev/rndmis_4g_038 15 0 4.00 8.87 0 0 0 0.00
DATA_BI /dev/rndmis_4g_043 33 0 2.73 3.58 0 0 0 0.00
DATA_BI /dev/rndmis_4g_044 9 0 3.33 14.11 0 0 0 0.00
DATA_BI /dev/rndmis_4g_046 17 0 4.12 4.76 0 0 0 0.00
DATA_BI /dev/rndmis_4g_048 22 0 3.64 4.23 0 0 0 0.00
DATA_BI /dev/rndmis_4g_049 52 0 3.08 2.40 0 0 0 0.00
DATA_BI /dev/rndmis_4g_050 31 0 3.55 7.48 0 0 0 0.00
DATA_BI /dev/rndmis_4g_053 18 0 2.22 14.33 0 0 0 0.00
DATA_BI /dev/rndmis_4g_057 28 0 2.86 8.11 0 0 0 0.00
DATA_BI /dev/rndmis_4g_060 19 0 4.74 13.42 0 0 0 0.00
DATA_BI /dev/rndmis_4g_061 32 0 6.56 7.91 0 0 0 0.00
DATA_BI /dev/rndmis_4g_067 30 0 4.00 8.10 0 0 0 0.00
DATA_BI /dev/rndmis_4g_068 21 0 4.76 11.71 0 0 0 0.00
DATA_BI /dev/rndmis_4g_081 89 0 14.61 2.64 0 0 0 0.00
DATA_BI /dev/rndmis_4g_101 57 0 3.16 3.74 0 0 0 0.00
DATA_BI /dev/rndmis_4g_102 20 0 4.00 12.80 0 0 0 0.00
DATA_BI /dev/rndmis_4g_106 33 0 2.12 6.42 0 0 0 0.00
DATA_BI /dev/rndmis_4g_113 28 0 6.07 8.89 0 0 0 0.00
DATA_BI /dev/rndmis_4g_114 52 0 8.65 3.27 0 0 0 0.00
DATA_BI /dev/rndmis_4g_115 56 0 2.86 2.04 0 0 0 0.00
DATA_BI /dev/rndmis_4g_116 8 0 5.00 15.75 0 0 0 0.00
DATA_BI /dev/rndmis_4g_127 33 0 3.64 3.67 0 0 0 0.00
DATA_BI /dev/rndmis_4g_133 8 0 2.50 15.75 0 0 0 0.00
DATA_BI /dev/rndmis_4g_134 79 0 2.28 1.00 0 0 0 0.00
DATA_BI /dev/rndmis_4g_135 11 0 2.73 11.73 0 0 0 0.00
DATA_BI /dev/rndmis_4g_146 8 0 2.50 8.25 0 0 0 0.00
DATA_BI /dev/rndmis_4g_152 20 0 8.00 6.10 0 0 0 0.00
DATA_BI /dev/rndmis_4g_155 40 0 2.25 3.95 0 0 0 0.00
DATA_BI /dev/rndmis_4g_156 8 0 3.75 15.75 0 0 0 0.00
DATA_BI /dev/rndmis_4g_160 9 0 4.44 14.11 0 0 0 0.00
DATA_BI /dev/rndmis_4g_163 13 0 4.62 10.08 0 0 0 0.00
DATA_BI /dev/rndmis_4g_164 16 0 4.38 8.38 0 0 0 0.00
DATA_BI /dev/rndmis_4g_167 10 0 1.00 12.80 0 0 0 0.00
DATA_BI11 /dev/rndmis_8g_022 23 0 3.48 1.00 0 0 0 0.00
DATA_BI12 /dev/rndmis_8g_023 0 0     1 0 0 0.00
DATA_BI7 /dev/rndmis_8g_018 2,511 1 3.32 2.81 0 0 0 0.00
DATA_BI9 /dev/rndmis_8g_020 4,240 2 3.05 2.32 0 0 0 0.00
DATA_OL /dev/rndmis_4g_015 19,522 11 3.98 2.89 538 0 13 3.85
DATA_OL /dev/rndmis_4g_016 18,188 10 3.88 3.10 486 0 38 5.26
DATA_OL /dev/rndmis_4g_017 20,261 11 3.44 2.85 568 0 21 3.33
DATA_OL /dev/rndmis_4g_018 17,596 10 3.79 3.07 435 0 41 3.41
DATA_OL /dev/rndmis_4g_019 19,212 11 3.95 2.93 355 0 90 3.33
DATA_OL /dev/rndmis_4g_020 19,242 11 3.80 2.98 382 0 45 4.44
DATA_OL /dev/rndmis_4g_021 19,164 11 3.69 2.94 517 0 19 3.68
DATA_OL /dev/rndmis_4g_022 18,384 10 3.87 2.97 477 0 11 1.82
DATA_OL /dev/rndmis_4g_023 17,930 10 3.94 3.11 554 0 23 1.74
DATA_OL /dev/rndmis_4g_024 18,252 10 3.78 3.04 555 0 37 3.51
DATA_OL /dev/rndmis_4g_026 6,178 3 3.92 2.69 348 0 2 5.00
DATA_OL /dev/rndmis_4g_028 8,113 5 3.82 2.93 186 0 0 0.00
DATA_OL /dev/rndmis_4g_034 10,262 6 3.87 3.90 325 0 56 2.50
DATA_OL /dev/rndmis_4g_035 9,026 5 4.10 4.35 363 0 108 2.59
DATA_OL /dev/rndmis_4g_040 12,841 7 4.34 4.38 528 0 124 2.82
DATA_OL /dev/rndmis_4g_041 12,444 7 4.44 4.42 483 0 9 1.11
DATA_OL /dev/rndmis_4g_058 14,077 8 4.66 3.95 399 0 4 2.50
DATA_OL /dev/rndmis_4g_059 13,702 8 4.50 4.04 541 0 106 2.64
DATA_OL /dev/rndmis_4g_071 10,063 6 4.61 3.78 920 1 92 2.83
DATA_OL /dev/rndmis_4g_072 8,927 5 4.66 3.95 762 0 32 2.81
DATA_OL /dev/rndmis_4g_075 8,734 5 4.76 4.15 888 0 108 2.04
DATA_OL /dev/rndmis_4g_079 5,076 3 5.97 2.11 598 0 74 1.89
DATA_OL /dev/rndmis_4g_080 5,306 3 5.82 1.96 713 0 2 0.00
DATA_OL /dev/rndmis_4g_083 4,729 3 5.34 1.94 514 0 0 0.00
DATA_OL /dev/rndmis_4g_084 4,357 2 5.87 2.03 415 0 10 8.00
DATA_OL /dev/rndmis_4g_085 3,211 2 5.64 2.51 407 0 35 1.43
DATA_OL /dev/rndmis_4g_086 3,861 2 5.51 2.29 457 0 13 14.62
DATA_OL /dev/rndmis_4g_087 4,182 2 5.65 2.14 469 0 12 3.33
DATA_OL /dev/rndmis_4g_088 4,189 2 5.18 2.35 416 0 12 2.50
DATA_OL /dev/rndmis_4g_092 3,885 2 5.58 2.49 355 0 0 0.00
DATA_OL /dev/rndmis_4g_210 917 1 5.25 1.89 284 0 0 0.00
DATA_OL /dev/rndmis_4g_211 866 0 7.92 1.23 799 0 0 0.00
DATA_OL /dev/rndmis_4g_212 282 0 7.16 1.42 134 0 0 0.00
DATA_OL /dev/rndmis_4g_213 1,808 1 2.88 1.32 661 0 0 0.00
DATA_OL /dev/rndmis_8g_043 3,640 2 5.67 2.52 417 0 6 6.67
DATA_OL /dev/rndmis_8g_044 3,848 2 5.56 2.42 352 0 15 12.00
DATA_P /dev/rndmis_4g_004 199 0 4.62 2.56 86 0 0 0.00
DATA_P /dev/rndmis_4g_027 126 0 4.29 1.06 50 0 0 0.00
DATA_P /dev/rndmis_4g_031 3,978 2 1.69 1.00 32 0 3,717 1.07
DATA_P /dev/rndmis_4g_032 4,805 3 2.10 1.00 37 0 4,540 1.37
DATA_P /dev/rndmis_4g_033 3,758 2 1.66 1.00 9 0 3,693 0.96
DATA_P /dev/rndmis_4g_064 1,014 1 2.45 1.00 7 0 994 1.48
DATA_P /dev/rndmis_4g_065 1,040 1 2.11 1.00 6 0 938 1.26
DATA_P /dev/rndmis_4g_074 1,005 1 1.45 1.00 13 0 1,006 0.79
DATA_P /dev/rndmis_4g_099 4 0 5.00 2.25 18 0 0 0.00
DATA_P /dev/rndmis_4g_104 1,004 1 5.12 1.00 2 0 1,080 4.19
DATA_P /dev/rndmis_4g_109 1,013 1 4.76 1.00 1 0 1,009 3.66
DATA_P /dev/rndmis_4g_121 6 0 3.33 1.00 3 0 0 0.00
DATA_P /dev/rndmis_4g_122 1,014 1 4.95 1.00 0 0 998 3.99
DATA_P /dev/rndmis_4g_123 7 0 4.29 1.00 1 0 0 0.00
DATA_P /dev/rndmis_4g_124 3 0 36.67 1.00 0 0 0 0.00
DATA_P /dev/rndmis_4g_125 993 1 4.51 1.00 1 0 1,046 3.39
DATA_P /dev/rndmis_4g_128 1 0 0.00 1.00 0 0 0 0.00
DATA_P /dev/rndmis_4g_136 2 0 0.00 1.00 0 0 0 0.00
DATA_P /dev/rndmis_4g_137 994 1 5.40 1.00 0 0 1,019 4.78
DATA_P /dev/rndmis_4g_138 1 0 10.00 1.00 0 0 0 0.00
DATA_P /dev/rndmis_4g_139 2 0 5.00 1.00 1 0 0 0.00
DATA_P /dev/rndmis_4g_140 1 0 10.00 1.00 1 0 0 0.00
DATA_P /dev/rndmis_4g_141 1,001 1 4.66 1.00 0 0 928 3.84
DATA_P /dev/rndmis_4g_142 996 1 4.68 1.00 6 0 999 3.71
DATA_P /dev/rndmis_4g_143 984 1 4.45 1.00 2 0 1,074 3.55
DATA_P /dev/rndmis_4g_144 972 1 4.88 1.00 0 0 932 3.85
DATA_P /dev/rndmis_4g_148 1,301 1 5.51 1.00 38 0 1,036 3.89
DATA_P /dev/rndmis_4g_149 1,517 1 4.85 1.00 119 0 1,013 3.90
DATA_P /dev/rndmis_4g_150 557 0 4.40 1.00 31 0 475 4.21
DATA_P /dev/rndmis_4g_153 150 0 1.93 1.00 49 0 0 0.00
DATA_P /dev/rndmis_4g_154 103 0 3.40 1.00 84 0 0 0.00
DATA_P /dev/rndmis_4g_158 55 0 4.73 1.00 149 0 2 0.00
DATA_P /dev/rndmis_4g_159 21 0 3.33 1.24 3 0 0 0.00
DATA_P /dev/rndmis_4g_165 31 0 4.19 1.00 6 0 0 0.00
DATA_P /dev/rndmis_4g_166 36 0 4.72 1.00 16 0 0 0.00
DATA_P /dev/rndmis_4g_168 154 0 4.09 1.00 16 0 0 0.00
DATA_P /dev/rndmis_4g_169 2 0 10.00 1.00 1 0 0 0.00
DATA_P /dev/rndmis_4g_170 103 0 6.02 1.01 9 0 0 0.00
DATA_P /dev/rndmis_8g_035 373 0 3.73 1.01 138 0 0 0.00
DATA_P /dev/rndmis_8g_038 87 0 5.98 1.00 35 0 0 0.00
DATA_P /dev/rndmis_8g_061 26 0 7.31 1.00 72 0 2 0.00
DATA_P /dev/rndmis_8g_062 30 0 6.67 1.00 0 0 0 0.00
DATA_SCA1 /dev/rndmis_4g_176 3,796 2 1.71 13.33 39 0 2,936 2.10
DATA_SCA10 /dev/rndmis_4g_187 43 0 5.81 1.00 60 0 0 0.00
DATA_SCA11 /dev/rndmis_4g_188 64 0 5.16 1.00 58 0 0 0.00
DATA_SCA12 /dev/rndmis_4g_189 30 0 6.67 1.00 50 0 0 0.00
DATA_SCA13 /dev/rndmis_4g_190 42 0 5.71 1.00 66 0 0 0.00
DATA_SCA14 /dev/rndmis_4g_191 61 0 7.38 1.00 52 0 0 0.00
DATA_SCA15 /dev/rndmis_4g_192 65 0 6.62 1.00 73 0 0 0.00
DATA_SCA16 /dev/rndmis_4g_193 45 0 4.89 1.00 66 0 0 0.00
DATA_SCA17 /dev/rndmis_4g_194 42 0 6.19 1.00 61 0 0 0.00
DATA_SCA18 /dev/rndmis_4g_195 47 0 4.68 1.00 63 0 0 0.00
DATA_SCA19 /dev/rndmis_4g_196 61 0 5.74 1.00 68 0 0 0.00
DATA_SCA2 /dev/rndmis_4g_177 3,968 2 1.52 12.76 44 0 2,913 2.22
DATA_SCA20 /dev/rndmis_4g_197 63 0 5.24 1.00 60 0 0 0.00
DATA_SCA21 /dev/rndmis_4g_198 58 0 5.86 1.00 63 0 0 0.00
DATA_SCA22 /dev/rndmis_4g_199 63 0 5.87 1.00 59 0 0 0.00
DATA_SCA23 /dev/rndmis_4g_200 64 0 6.72 1.00 58 0 0 0.00
DATA_SCA24 /dev/rndmis_4g_201 31 0 7.10 1.00 59 0 0 0.00
DATA_SCA3 /dev/rndmis_4g_178 4,022 2 1.42 12.53 32 0 3,000 2.15
DATA_SCA4 /dev/rndmis_4g_179 9,402 5 3.05 5.22 34 0 4,078 2.90
DATA_SCA5 /dev/rndmis_4g_180 6,737 4 3.59 6.10 41 0 4,042 2.74
DATA_SCA6 /dev/rndmis_4g_181 3,464 2 1.53 10.99 36 0 3,977 2.14
DATA_SCA7 /dev/rndmis_4g_182 2,898 2 1.39 12.90 41 0 3,977 2.02
DATA_SCA8 /dev/rndmis_4g_183 3,059 2 1.96 12.34 44 0 3,994 2.17
DATA_SCA9 /dev/rndmis_4g_186 62 0 6.77 1.00 57 0 1 0.00
DATA_SG /dev/rndmis_4g_009 371 0 5.07 1.03 1,341 1 0 0.00
DATA_SG /dev/rndmis_8g_013 17 0 5.29 1.00 70 0 0 0.00
DATA_SG /dev/rndmis_8g_014 35 0 5.14 1.00 38 0 0 0.00
DATA_WF /dev/rndmis_4g_005 9,571 5 4.14 1.55 2,526 1 1,320 1.18
DATA_WF /dev/rndmis_4g_036 8,259 5 5.03 1.08 599 0 2,380 1.34
DATA_WF /dev/rndmis_4g_107 5,721 3 4.99 1.03 634 0 1,416 1.74
DATA_YP /dev/rndmis_4g_007 684 0 4.05 1.03 2,919 2 0 0.00
IDX_BI /dev/rndmis_4g_001 32 0 9.06 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_052 5 0 4.00 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_055 5 0 2.00 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_056 6 0 5.00 1.00 0 0 0 0.00
IDX_BI1 /dev/rndmis_8g_016 46 0 2.39 1.00 0 0 0 0.00
IDX_OL /dev/rndmis_4g_011 18,316 10 3.27 1.00 396 0 236 0.81
IDX_OL /dev/rndmis_4g_012 20,196 11 3.19 1.00 362 0 269 1.12
IDX_OL /dev/rndmis_4g_013 18,719 10 3.23 1.00 361 0 138 1.52
IDX_OL /dev/rndmis_4g_014 17,814 10 3.39 1.00 759 0 220 1.18
IDX_OL /dev/rndmis_4g_029 12,068 7 4.29 1.00 1,309 1 40 1.25
IDX_OL /dev/rndmis_4g_069 11,359 6 4.98 1.00 764 0 8 2.50
IDX_OL /dev/rndmis_4g_070 11,698 6 5.32 1.00 647 0 9 4.44
IDX_OL /dev/rndmis_4g_076 10,576 6 5.08 1.00 506 0 12 3.33
IDX_OL /dev/rndmis_4g_077 7,121 4 6.17 1.00 1,662 1 5 4.00
IDX_OL /dev/rndmis_4g_078 6,382 4 6.41 1.00 1,342 1 1 10.00
IDX_OL /dev/rndmis_4g_089 6,144 3 6.35 1.00 1,339 1 5 4.00
IDX_OL /dev/rndmis_4g_090 7,781 4 6.21 1.00 1,403 1 1 0.00
IDX_OL /dev/rndmis_4g_091 6,288 3 6.28 1.00 1,519 1 0 0.00
IDX_OL /dev/rndmis_4g_093 6,653 4 5.36 1.00 1,057 1 60 2.00
IDX_OL /dev/rndmis_4g_094 6,349 4 5.67 1.00 1,491 1 36 3.61
IDX_OL /dev/rndmis_4g_095 6,176 3 5.81 1.00 1,003 1 25 3.20
IDX_OL /dev/rndmis_4g_096 5,941 3 5.92 1.00 696 0 9 5.56
IDX_OL /dev/rndmis_4g_097 3,777 2 6.35 1.00 1,818 1 9 4.44
IDX_OL /dev/rndmis_4g_098 3,817 2 6.35 1.00 2,706 2 10 1.00
IDX_OL /dev/rndmis_4g_108 2,776 2 6.02 1.00 1,593 1 13 0.00
IDX_OL /dev/rndmis_4g_110 1,958 1 6.32 1.00 790 0 0 0.00
IDX_OL /dev/rndmis_4g_111 1,862 1 6.78 1.00 1,021 1 1 0.00
IDX_OL /dev/rndmis_4g_112 1,649 1 6.09 1.00 680 0 2 10.00
IDX_OL /dev/rndmis_8g_024 1,131 1 5.04 1.00 852 0 1 10.00
IDX_OL /dev/rndmis_8g_025 955 1 5.20 1.00 790 0 0 0.00
IDX_P /dev/rndmis_4g_002 774 0 2.30 1.00 230 0 411 0.51
IDX_P /dev/rndmis_4g_130 1,182 1 4.56 1.00 338 0 840 2.98
IDX_P /dev/rndmis_4g_131 1,074 1 4.93 1.00 250 0 871 3.64
IDX_P /dev/rndmis_4g_173 1,122 1 5.29 1.00 426 0 846 4.47
IDX_P /dev/rndmis_4g_217 353 0 5.98 1.00 339 0 1 0.00
IDX_P /dev/rndmis_4g_218 285 0 7.12 1.00 273 0 0 0.00
IDX_SCA /dev/rndmis_4g_208 3,115 2 2.67 13.64 326 0 0 0.00
IDX_SCA /dev/rndmis_4g_219 168 0 5.06 9.27 40 0 0 0.00
IDX_SCA1 /dev/rndmis_4g_184 14 0 5.00 1.00 32 0 0 0.00
IDX_SCA2 /dev/rndmis_4g_185 14 0 5.71 1.00 29 0 0 0.00
IDX_SCA3 /dev/rndmis_4g_202 139 0 5.32 1.00 87 0 0 0.00
IDX_SCA3 /dev/rndmis_4g_220 175 0 5.94 1.00 105 0 0 0.00
IDX_SCA4 /dev/rndmis_4g_203 159 0 3.96 1.00 79 0 0 0.00
IDX_SCA4 /dev/rndmis_4g_221 166 0 5.72 1.00 104 0 0 0.00
IDX_SCA5 /dev/rndmis_4g_204 164 0 6.22 1.00 88 0 0 0.00
IDX_SCA5 /dev/rndmis_4g_222 151 0 4.83 1.00 111 0 0 0.00
IDX_SCA6 /dev/rndmis_4g_205 170 0 5.41 1.00 102 0 0 0.00
IDX_SCA6 /dev/rndmis_4g_223 151 0 6.42 1.00 103 0 0 0.00
IDX_SCA7 /dev/rndmis_8g_011 15,091 8 5.53 1.00 14,062 8 0 0.00
IDX_SCA7 /dev/rndmis_8g_034 3,729 2 5.89 1.00 3,540 2 1 0.00
IDX_SG /dev/rndmis_4g_010 1,153 1 5.19 1.00 1,833 1 0 0.00
IDX_WF /dev/rndmis_4g_006 6,178 3 4.97 1.00 3,632 2 442 2.04
IDX_WF /dev/rndmis_4g_042 2,182 1 5.21 1.00 2,122 1 309 1.39
IDX_YP /dev/rndmis_4g_008 6 0 5.00 1.00 19 0 0 0.00
LOB_SCA /dev/rndmis_8g_006 0 0     4 0 0 0.00
LOB_SCA /dev/rndmis_8g_026 0 0     525 0 0 0.00
LOB_SCA /dev/rndmis_8g_039 0 0     262 0 0 0.00
LOB_SCA /dev/rndmis_8g_040 0 0     1,063 1 0 0.00
SYSAUX /dev/rndmis_4g_225 42 0 5.24 1.00 34 0 0 0.00
SYSAUX /dev/rsysaux_4g 1,385 1 4.05 1.06 398 0 0 0.00
SYSTEM /dev/rsystem_4g 6,266 3 3.92 1.00 122 0 0 0.00
TEMP /dev/rndmis_8g_056 292 0 0.31 1.00 853 0 0  
TEMP /dev/rtemp01_16g 697 0 0.44 1.00 1,727 1 0  
TEMP /dev/rtemp02_16g 483 0 0.25 1.00 493 0 0  
UNDOTBS1 /dev/rndmis_8g_030 0 0     34 0 0 0.00
UNDOTBS1 /dev/rndmis_8g_036 1 0 0.00 1.00 0 0 0 0.00
UNDOTBS1 /dev/rundo_1a_16g 273 0 3.70 1.00 565 0 3 0.00
UNDOTBS1 /dev/rundo_1b_16g 161 0 3.17 1.00 370 0 8 0.00
UNDOTBS2 /dev/rndmis_8g_032 3 0 0.00 1.00 0 0 0 0.00
UNDOTBS2 /dev/rndmis_8g_033 3 0 6.67 1.00 0 0 0 0.00
UNDOTBS2 /dev/rundo_2b_16g 1 0 10.00 1.00 0 0 0 0.00
USERS /dev/rusers_4g 2 0 15.00 1.00 0 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 2,749,842 99 195,416,088 1,806,161 101,292 0 0 66,622


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 8 11981 57820 477111 5640120 477111  
E 0 9 14229 73222 515357 5640120 515357  

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,288 0.10 274,131 1.88 13,923,101,168
D 4,576 0.20 548,262 1.72 12,747,619,912
D 6,864 0.30 822,393 1.59 11,736,348,933
D 9,152 0.40 1,096,524 1.47 10,866,928,330
D 11,440 0.50 1,370,655 1.37 10,112,458,775
D 13,728 0.60 1,644,786 1.28 9,449,131,534
D 16,016 0.70 1,918,917 1.20 8,860,272,631
D 18,304 0.80 2,193,048 1.13 8,333,703,872
D 20,592 0.90 2,467,179 1.06 7,856,871,110
D 22,880 1.00 2,741,310 1.00 7,418,966,296
D 22,960 1.00 2,750,895 1.00 7,404,751,518
D 25,168 1.10 3,015,441 0.95 7,012,173,075
D 27,456 1.20 3,289,572 0.90 6,630,650,010
D 29,744 1.30 3,563,703 0.85 6,269,336,793
D 32,032 1.40 3,837,834 0.80 5,924,074,580
D 34,320 1.49 4,111,965 0.76 5,591,679,555
D 36,608 1.59 4,386,096 0.71 5,269,381,484
D 38,896 1.69 4,660,227 0.67 4,954,242,399
D 41,184 1.79 4,934,358 0.63 4,643,500,788
D 43,472 1.89 5,208,489 0.59 4,334,806,700
D 45,760 1.99 5,482,620 0.54 4,026,397,718

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 23,545 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 6,144 2,338 4,727.87 3.81 0.08 100.00 0.00 629,140
E 6,144 2,306 4,756.07 14.08 0.30 100.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 244,234 244,234 0 0
64K 128K 4,923 4,923 0 0
128K 256K 3,491 3,491 0 0
256K 512K 5,721 5,721 0 0
512K 1024K 25,309 25,309 0 0
1M 2M 148 148 0 0
2M 4M 391 391 0 0
4M 8M 13 13 0 0
8M 16M 10 10 0 0
16M 32M 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 55,271,478.97 28,929,064.38 66.00 641,226
1,536 0.25 55,271,478.97 28,178,848.31 66.00 621,776
3,072 0.50 55,271,478.97 17,583,981.23 76.00 340,891
4,608 0.75 55,271,478.97 6,311,252.89 90.00 51,037
6,144 1.00 55,271,478.97 1,599,166.42 97.00 1,828
7,373 1.20 55,271,478.97 1,210,768.73 98.00 1,652
8,602 1.40 55,271,478.97 1,210,478.86 98.00 1,040
9,830 1.60 55,271,478.97 1,210,021.78 98.00 528
11,059 1.80 55,271,478.97 1,210,003.44 98.00 220
12,288 2.00 55,271,478.97 1,209,857.67 98.00 14
18,432 3.00 55,271,478.97 1,209,802.66 98.00 0
24,576 4.00 55,271,478.97 1,209,802.66 98.00 0
36,864 6.00 55,271,478.97 1,209,802.66 98.00 0
49,152 8.00 55,271,478.97 1,209,802.66 98.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,768 0.80 398 31,987 282,649,246 1.00 776,453 1.11 3,163,811
3,120 0.90 742 53,499 282,687,745 1.00 737,954 1.05 3,173,294
3,472 1.00 1,093 74,486 282,725,394 1.00 700,305 1.00 3,182,709
3,824 1.10 1,444 97,281 282,762,257 1.00 663,442 0.95 3,192,050
4,176 1.20 1,795 119,375 282,798,117 1.00 627,582 0.90 3,201,278
4,528 1.30 2,144 141,220 282,833,179 1.00 592,520 0.85 3,210,381
4,880 1.41 2,495 162,752 282,867,490 1.00 558,209 0.80 3,219,336
5,232 1.51 2,846 185,405 282,901,096 1.00 524,603 0.75 3,228,130
5,584 1.61 3,196 207,773 282,934,052 1.00 491,647 0.70 3,236,764
5,936 1.71 3,544 229,966 282,966,412 1.00 459,287 0.66 3,245,238
6,288 1.81 3,895 251,515 282,998,216 1.00 427,483 0.61 3,253,547
6,640 1.91 4,246 272,304 283,029,532 1.00 396,167 0.57 3,261,702
6,992 2.01 4,597 293,675 283,060,433 1.00 365,266 0.52 3,269,727

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 37,799,273 13,923,144,161
13,312 0.50 29,686,567 10,867,205,431
19,968 0.75 24,323,794 8,860,519,228
26,624 1.00 20,460,794 7,404,746,137
33,280 1.25 17,446,921 6,269,598,554
39,936 1.50 16,947,677 5,591,323,808
46,592 1.75 16,939,493 4,643,516,303
53,248 2.00 16,933,355 4,026,700,949

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
32 0.29 4 82 3 1.00 700,306 1.00 82
48 0.43 4 82 3 1.00 700,306 1.00 82
64 0.57 4 82 3 1.00 700,306 1.00 82
80 0.71 4 82 3 1.00 700,306 1.00 82
96 0.86 4 82 3 1.00 700,306 1.00 82
112 1.00 4 82 3 1.00 700,306 1.00 82
128 1.14 4 82 3 1.00 700,306 1.00 82
144 1.29 4 82 3 1.00 700,306 1.00 82
160 1.43 4 82 3 1.00 700,306 1.00 82
176 1.57 4 82 3 1.00 700,306 1.00 82
192 1.71 4 82 3 1.00 700,306 1.00 82
208 1.86 4 82 3 1.00 700,306 1.00 82
224 2.00 4 82 3 1.00 700,306 1.00 82
240 2.14 4 82 3 1.00 700,306 1.00 82

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 66,441 153 2
segment header 142 0 0
1st level bmb 15 0 1
2nd level bmb 13 0 1
undo header 8 0 0
undo block 3 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 14 14 0 9 2 234.67
HW-Segment High Water Mark 2,377 2,377 0 343 0 0.40
TX-Transaction (index contention) 147 147 0 59 0 1.36
TT-Tablespace 2,294 2,294 0 182 0 0.43
TO-Temp Object 1,564 1,564 0 102 0 0.57
FB-Format Block 211 211 0 101 0 0.54
CF-Controlfile Transaction 36,509 36,509 0 98 0 0.51
PS-PX Process Reservation 96 96 0 55 0 0.53
TM-DML 105,921 105,920 0 24 0 0.75
TX-Transaction 50,143 50,139 0 1 0 15.00
WF-AWR Flush 20 20 0 9 0 0.89
RO-Multiple Object Reuse (fast object reuse) 16 16 0 6 0 0.50
TD-KTF map table enqueue (KTF dump entries) 6 6 0 6 0 0.50
TX-Transaction (allocate ITL entry) 5 5 0 3 0 0.67
MS-Materialized View Refresh Log 4 4 0 2 0 0.50
AF-Advisor Framework (task serialization) 7 7 0 1 0 1.00
DR-Distributed Recovery 1 1 0 1 0 0.00
JI-Materialized View 2 2 0 1 0 0.00
JS-Job Scheduler (job run lock - synchronize) 2 2 0 1 0 0.00
MW-MWIN Schedule 1 1 0 1 0 0.00
UL-User-defined 2 2 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 7.68 39,975 198 14 10098.7/10101.4 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:19 3,521 22,144 198 11 10,099 0/0 0/0/0/0/0/0
27-Mar 16:09 4,160 17,831 135 14 10,101 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,309 0.00   0 0  
AWR Alerted Metric Element list 67,760 0.00   0 0  
Consistent RBA 44,969 0.00   0 0  
FAL request queue 36 0.00   0 0  
FAL subheap alocation 36 0.00   0 0  
FOB s.o list latch 3,273 0.00   0 0  
JS broadcast add buf latch 4,791 0.00   0 0  
JS broadcast drop buf latch 4,792 0.00   0 0  
JS broadcast load blnc latch 4,739 0.00   0 0  
JS mem alloc latch 4 0.00   0 0  
JS queue access latch 4 0.00   0 0  
JS queue state obj latch 227,514 0.00   0 0  
JS slv state obj latch 40 0.00   0 0  
KCL gc element parent latch 17,146,316 0.05 0.01 0 7,814 0.01
KJC message pool free list 229,314 9.17 0.00 0 67,125 0.02
KJCT flow control latch 4,374,738 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 601 0.00   0 0  
KSXR large replies 122 0.00   0 0  
KTF sga latch 4,704 0.00   0 607 0.00
KWQMN job cache list latch 610 0.00   0 0  
KWQP Prop Status 225 0.00   0 0  
MQL Tracking Latch 0     0 36 0.00
Memory Management Latch 0     0 601 0.00
Memory Queue 446 0.00   0 0  
OS process 333 0.00   0 0  
OS process allocation 832 0.00   0 0  
OS process: request allocation 172 0.00   0 0  
PL/SQL warning settings 40,108 0.00   0 0  
SGA IO buffer pool latch 72,469 0.01 0.00 0 72,469 0.01
SQL memory manager latch 1 0.00   0 600 0.00
SQL memory manager workarea list latch 362,901 0.01 0.00 0 0  
Shared B-Tree 1,607 0.00   0 0  
active checkpoint queue latch 53,466 0.33 0.00 0 0  
active service list 49,063 0.00 1.00 0 249,061 0.00
archive control 32 0.00   0 0  
archive process latch 672 0.00   0 0  
begin backup scn array 5,277 0.02 0.00 0 0  
bq:time manger info latch 64 0.00   0 0  
bufq statistics 225 0.00   0 0  
business card 20 0.00   0 0  
cache buffer handles 41,100 0.00 0.00 0 0  
cache buffers chains 350,902,638 0.26 0.03 1 10,737,394 0.02
cache buffers lru chain 3,390,926 0.04 0.00 0 5,264,569 0.05
cache table scan latch 0     0 94,543 0.03
channel handle pool latch 189 0.00   0 0  
channel operations parent latch 5,209,000 0.00 0.00 0 0  
checkpoint queue latch 1,183,722 0.01 0.00 0 127,283 0.00
client/application info 1,659 0.00   0 0  
commit callback allocation 240 0.00   0 0  
compile environment latch 168 0.00   0 0  
dml lock allocation 211,818 0.03 0.00 0 0  
dummy allocation 326 0.00   0 0  
enqueue hash chains 1,573,116 0.00 0.00 0 1,478 0.00
enqueues 2,459,251 0.06 0.00 0 0  
error message lists 44 0.00   0 0  
event group latch 91 0.00   0 0  
file cache latch 2,276 0.00   0 0  
gcs opaque info freelist 2,476,938 0.12 0.00 0 0  
gcs partitioned table hash 32,273,104 0.00   0 193,002 0.00
gcs remastering latch 2,328,450 0.00 0.50 0 5,977 0.00
gcs resource freelist 2,542,156 0.01 0.00 0 1,075,587 0.00
gcs resource hash 15,233,625 0.23 0.00 0 30 0.00
gcs resource scan list 60 0.00   0 0  
gcs shadows freelist 1,691,246 0.00 0.00 0 1,603,255 0.00
ges caches resource lists 815,528 0.19 0.00 0 261,060 0.45
ges deadlock list 16,210 0.01 0.00 0 1 0.00
ges domain table 1,698,398 0.00 0.00 0 0  
ges enqueue table freelist 1,865,760 0.00 0.00 0 0  
ges group table 2,542,166 0.00 0.00 0 0  
ges process hash list 97,671 0.00   0 0  
ges process parent latch 4,068,193 0.00 0.00 0 0  
ges process table freelist 172 0.00   0 0  
ges resource hash list 3,528,118 0.04 0.00 0 272,660 0.00
ges resource scan list 48 0.00   0 0  
ges resource table freelist 401,114 0.01 0.00 0 1 0.00
ges synchronous data 32 0.00   0 18,043 0.02
ges timeout list 121,964 0.01 0.00 0 63,250 0.00
global KZLD latch for mem in SGA 76 0.00   0 0  
global tx hash mapping 5,900 0.00   0 3 0.00
hash table column usage latch 1,208 0.00   0 765,698 0.00
hash table modification latch 279 0.00   0 0  
internal temp table object number allocation latc 45 0.00   0 0  
interrupt manipulation 321 0.00   0 0  
job workq parent latch 0     0 64 0.00
job_queue_processes parameter latch 62 0.00   0 0  
kks stats 573,947 0.05 0.00 0 0  
kokc descriptor allocation latch 164,062 0.00   0 0  
ksuosstats global area 122 0.00   0 0  
ktm global data 372 0.00   0 0  
kwqbsn:qsga 1,101 0.00   0 0  
lgwr LWN SCN 45,055 0.02 0.00 0 0  
library cache 11,775,739 0.05 0.00 0 457,647 0.05
library cache load lock 34,588 0.00   0 0  
library cache lock 19,022,711 0.04 0.00 0 0  
library cache lock allocation 29,687 0.00   0 0  
library cache pin 3,062,027 0.02 0.00 0 0  
library cache pin allocation 74,902 0.00 0.00 0 0  
list of block allocation 2,818 0.00   0 0  
loader state object freelist 15,030 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 64 0.00   0 23 0.00
message pool operations parent latch 581 0.00   0 0  
messages 1,033,341 0.09 0.00 0 0  
mostly latch-free SCN 46,141 2.09 0.00 0 0  
multiblock read objects 486,209 0.01 0.00 0 0  
name-service memory objects 31,890 0.00   0 0  
name-service namespace bucket 27,991 0.00   0 0  
name-service pending queue 16,110 0.00   0 0  
name-service request queue 59,336 0.00   0 0  
ncodef allocation latch 40 0.00   0 0  
object queue header heap 63,337 0.00   0 69,001 0.00
object queue header operation 7,538,411 0.01 0.03 0 0  
object stats modification 82 0.00   0 0  
parallel query alloc buffer 696 0.00   0 0  
parallel query stats 75 0.00   0 0  
parallel txn reco latch 10,450 0.00   0 0  
parameter list 617 0.00   0 0  
parameter table management 438 0.00   0 0  
post/wait queue 96,460 0.05 0.00 0 42,352 0.00
process allocation 12,030 0.00   0 91 0.00
process group creation 172 0.00   0 0  
process queue 200 0.00   0 0  
process queue reference 3,904 0.00   0 374 0.00
qmn task queue latch 1,972 25.46 0.07 0 0  
query server freelists 154 0.00   0 0  
queue sender's info. latch 669 0.75 0.00 0 0  
queued dump request 8,999 0.00   0 0  
redo allocation 225,870 0.01 0.00 0 513,543 0.12
redo copy 0     0 513,779 0.10
redo writing 190,086 0.07 0.00 0 0  
resmgr group change latch 336 0.00   0 0  
resmgr:active threads 317 0.00   0 0  
resmgr:actses change group 153 0.00   0 0  
resmgr:free threads list 316 0.00   0 0  
resmgr:resource group CPU method 142 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 19,670,774 0.28 0.00 0 40,369 0.61
rules engine rule set statistics 100 0.00   0 0  
sequence cache 17,278 0.00   0 0  
session allocation 3,372,722 0.17 0.00 0 0  
session idle bit 12,694,127 0.00 0.00 0 0  
session state list latch 384 0.00   0 0  
session switching 447 0.00   0 0  
session timer 702 0.00   0 0  
shared pool 5,906,987 0.08 0.02 1 0  
shared pool simulator 684,217 0.01 0.13 0 0  
simulator hash latch 10,898,877 0.00 0.00 0 0  
simulator lru latch 0     0 10,715,001 0.60
slave class 5 0.00   0 0  
slave class create 20 5.00 1.00 0 0  
sort extent pool 10,662 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 21,504 0.00   0 0  
temp lob duration state obj allocation 7 0.00   0 0  
temporary table state object allocation 25 0.00   0 0  
threshold alerts latch 828 0.00   0 0  
transaction allocation 1,641,548 0.00   0 0  
transaction branch allocation 6,020 0.00   0 0  
undo global data 196,857 0.01 0.00 0 0  
user lock 483 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 350,902,638 905,431 27,699 882,076 0 0 0
row cache objects 19,670,774 55,214 4 55,210 0 0 0
gcs resource hash 15,233,625 34,571 10 34,562 0 0 0
KJC message pool free list 229,314 21,023 80 20,945 0 0 0
KCL gc element parent latch 17,146,316 8,532 87 8,449 0 0 0
session allocation 3,372,722 5,898 2 5,896 0 0 0
library cache 11,775,739 5,800 15 5,785 0 0 0
shared pool 5,906,987 4,572 109 4,467 0 0 0
cache buffers lru chain 3,390,926 1,445 1 1,444 0 0 0
object queue header operation 7,538,411 1,075 27 1,048 0 0 0
qmn task queue latch 1,972 502 35 467 0 0 0
shared pool simulator 684,217 48 6 42 0 0 0
gcs remastering latch 2,328,450 2 1 1 0 0 0
active service list 49,063 1 1 0 0 0 0
slave class create 20 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclnfndnewm 0 420 60
KCL gc element parent latch kclbla 0 18 1
KCL gc element parent latch kclplz 0 16 98
KCL gc element parent latch kclnfnd 0 15 17
KCL gc element parent latch kclzcl 0 15 139
KCL gc element parent latch kclrwrite 0 11 5
KCL gc element parent latch kclwrt 0 9 2
KCL gc element parent latch kclgcr 0 7 1
KCL gc element parent latch kclple_1 0 7 0
KCL gc element parent latch kclfwrite1 0 5 7
KCL gc element parent latch KCLUNLNK 0 3 100
KCL gc element parent latch kclulb 0 3 76
KJC message pool free list kjcsmpav: allocate a msg buffer 0 80 80
active service list kswssyis: find service entry 1 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 31,539 38,351
cache buffers chains kclcls_3 0 11,000 12
cache buffers chains kcbrls: kslbegin 0 464 432
cache buffers chains kcbgtcr: kslbegin shared 0 117 72
cache buffers chains kcbgtcr: fast path 0 106 53
cache buffers chains kclwrt 0 45 0
cache buffers chains kcbzwb 0 18 4,359
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 17 9
cache buffers chains kcbzgb: scan from tail. nowait 0 17 0
cache buffers chains kcbzib: multi-block read: nowait 0 10 0
cache buffers chains kclexpandlock 0 10 0
cache buffers chains kcbgcur: kslbegin 0 3 5
cache buffers chains kcbgtcr 0 3 0
cache buffers chains kcbbxsv 0 2 46
cache buffers chains kcbget: pin buffer 0 2 2
cache buffers chains kcbzib: finish free bufs 0 2 0
cache buffers chains kclbla 0 1 0
cache buffers chains kclebs_1 0 1 1
cache buffers lru chain kcbzgb: wait - one set in buffer pool 0 1 1
event range base latch No latch 0 35 35
gcs remastering latch 43 0 1 0
gcs resource hash kjbcropen:affinity 0 6 2
gcs resource hash kjbrrcfwst 0 3 1
gcs resource hash kjbcropen 0 1 0
library cache kgldte: child 0 0 3 6
library cache kglic 0 3 0
library cache kglpndl: child: after processing 0 3 0
library cache kqlmbpil: parent 0 1 0
library cache lock kgllkdl: child: no lock handle 0 2 0
object queue header operation kclobj_1 0 23 12
object queue header operation kcbw_unlink_q 0 6 20
object queue header operation kcbw_link_q 0 4 0
object queue header operation kcbo_switch_mq_bg 0 3 4
object queue header operation kcbo_switch_q_bg 0 2 1
row cache objects kqreqd: reget 0 3 0
row cache objects kqrpre: find obj 0 1 4
session allocation ksucri 0 1 2
session allocation ksufap: active sessions 0 1 0
session idle bit ksupuc: set busy 0 1 0
shared pool kghupr1 0 83 59
shared pool kghalo 0 22 22
shared pool kghfrunp: clatch: nowait 0 3 0
shared pool kghfre 0 2 18
shared pool kghfrunp: alloc: wait 0 2 0
shared pool simulator kglsim_unpin_simhp 0 5 1
shared pool simulator kglsim_scan_lru: scan 0 1 4
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
OLIVE IDX_OL PK_OL$_ATTR_DEFS   INDEX 33,672,720 17.23
OLIVE DATA_OL OL$_CLASSES   TABLE 29,282,384 14.98
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 19,709,472 10.08
AMBER IDX_WF UK_USER_ACTION_BAK   INDEX 10,141,376 5.19
AMBER IDX_WF NDX_INDY_USER_PROFILE   INDEX 7,363,488 3.77

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
OLIVE DATA_OL OL$_ASSOCIATIONS   TABLE 107,876 5.92
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 51,181 2.81
OLIVE IDX_OL NK_OL$_REFS_URI_B   INDEX 32,307 1.77
OLIVE DATA_OL OL$_OBJECTS_R01 P_1340308 TABLE PARTITION 26,959 1.48
OLIVE IDX_OL OL$_ASSOCIATIONS_N1   INDEX 25,744 1.41

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
OLIVE IDX_OL OL$_EVENT_LOG_D1   INDEX 43 29.66
OLIVE IDX_OL OL$_EVENT_LOG_N1   INDEX 27 18.62
SCADA IDX_SCA6 IDX_MEASURE_N2 201303_S12 INDEX SUBPARTITION 5 3.45
SCADA IDX_SCA4 IDX_MEASURE_N2 201303_S14 INDEX SUBPARTITION 5 3.45
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 4 2.76

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 2 66.67
SCADA IDX_SCA6 IDX_MEASURE_N2 P201303_S8 INDEX SUBPARTITION 1 33.33

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
OLIVE DATA_OL OL$_OBJECTS _134052003 TABLE PARTITION 46 55.42
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 16 19.28
OLIVE IDX_OL OL$_ASSOCIATIONS_N1   INDEX 11 13.25
OLIVE IDX_OL OL$_EVENT_LOG_D1   INDEX 3 3.61
OLIVE IDX_OL OL$_OBJECTS_N2 _134052003 INDEX PARTITION 3 3.61

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
SCADA DATA_SCA2 SCADA_INTERFACE_DATA_BD P201303_S2 TABLE SUBPARTITION 1,131 6.67
SCADA DATA_SCA1 SCADA_INTERFACE_DATA_BD P201303_S1 TABLE SUBPARTITION 1,126 6.64
SCADA DATA_SCA5 SCADA_INTERFACE_DATA_BD P201303_S5 TABLE SUBPARTITION 1,124 6.63
SCADA DATA_SCA6 SCADA_INTERFACE_DATA_BD P201303_S6 TABLE SUBPARTITION 1,107 6.53
SCADA DATA_SCA3 SCADA_INTERFACE_DATA_BD P201303_S3 TABLE SUBPARTITION 1,094 6.45

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 7,140 7.17
OLIVE IDX_OL NK_OL$_REFS_URI_A   INDEX 6,896 6.93
SGPM DATA_SG P_TASK   TABLE 6,238 6.26
OLIVE DATA_OL OL$_ASSOCIATIONS   TABLE 3,949 3.97
OLIVE IDX_OL OL$_ASSOCIATIONS_N1   INDEX 2,649 2.66

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 78,277 5.67
OLIVE DATA_OL OL$_ASSOCIATIONS   TABLE 77,094 5.59
AMBER DATA_WF INDY_USER_ACTION P1340500 TABLE PARTITION 42,105 3.05
OLIVE IDX_OL OL$_ASSOCIATIONS_N1   INDEX 35,871 2.60
OLIVE DATA_OL OL$_OBJECTS_R01 P_1340308 TABLE PARTITION 33,007 2.39

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 34 20.59 0   2 1
dc_database_links 118,997 0.01 0   0 4
dc_files 2,232 25.00 0   0 0
dc_global_oids 83,531 0.45 0   0 6
dc_histogram_data 4,057,129 3.77 0   0 13,317
dc_histogram_defs 1,193,881 6.45 0   64 5,252
dc_object_grants 1,201 38.97 0   0 32
dc_object_ids 1,768,743 0.36 0   13 984
dc_objects 199,945 2.70 0   31 560
dc_profiles 110 0.00 0   0 1
dc_rollback_segments 22,331 0.00 0   0 953
dc_segments 217,413 23.40 0   34 1,161
dc_sequences 119 46.22 0   119 2
dc_table_scns 207 13.53 0   4 2
dc_tablespace_quotas 136 44.12 0   0 4
dc_tablespaces 223,603 0.14 0   0 40
dc_usernames 10,182 1.52 0   0 13
dc_users 988,380 0.02 0   0 36
outstanding_alerts 398 100.00 0   0 0

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 11 0 7
dc_database_links 6 0 6
dc_files 558 0 837
dc_global_oids 377 0 451
dc_histogram_defs 76,896 0 78,140
dc_object_ids 6,400 0 6,789
dc_objects 5,399 0 5,527
dc_segments 50,922 8 51,617
dc_sequences 238 9 46
dc_table_scns 35 0 29
dc_tablespace_quotas 128 5 54
dc_tablespaces 311 0 338
dc_usernames 155 0 162
dc_users 130 0 134
outstanding_alerts 794 0 398

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 703 7.25 256,853 0.11 230 0
CLUSTER 308 3.25 504 3.77 9 0
INDEX 13,040 0.30 178,181 0.08 100 0
JAVA DATA 3 100.00 3 100.00 0 0
JAVA RESOURCE 3 100.00 3 100.00 0 0
JAVA SOURCE 3 100.00 3 100.00 0 0
SQL AREA 398,596 42.80 6,823,477 6.63 19,226 8,491
TABLE/PROCEDURE 54,190 2.08 1,069,551 1.55 9,675 0
TRIGGER 171 28.07 1,458 6.79 51 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 504 10 9 10 0
INDEX 178,177 39 42 36 0
JAVA DATA 3 3 5 0 0
JAVA RESOURCE 3 3 4 0 0
JAVA SOURCE 3 3 5 0 0
TABLE/PROCEDURE 299,282 862 1,030 526 0
TRIGGER 3 48 45 45 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 3,786.79   2.13 8.63 353 353 1,775 1,775
  Freeable 769.56 0.00 0.73 0.27 2   1,057 1,057
  PL/SQL 188.10 44.41 0.11 3.00 126 126 1,774 1,774
  SQL 109.31 8.36 0.06 0.09 2 210 1,741 1,733
E Other 3,834.60   2.15 8.61 353 353 1,785 1,785
  Freeable 737.94 0.00 0.69 0.28 2   1,070 1,070
  PL/SQL 188.42 44.59 0.11 2.99 126 126 1,784 1,784
  SQL 125.49 22.42 0.07 0.28 10 210 1,751 1,743

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 24,075,304,960  
Fixed Size 2,147,040  
Redo Buffers 48,181,248  
Variable Size 3,791,654,176  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 106.52 106.52 0.00
java joxlod exec hp 5.38 5.38 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared ASH buffers 68.00 68.00 0.00
shared CCursor 70.08 72.17 3.00
shared Checkpoint queue 62.52 62.52 0.00
shared KGH: NO ACCESS 677.17 677.17 0.00
shared PCursor 50.61 51.09 0.95
shared db_block_hash_buckets 180.00 180.00 0.00
shared event statistics per sess 49.73 49.73 0.00
shared free memory 852.34 854.70 0.28
shared gcs resources 644.30 644.30 0.00
shared gcs shadows 298.64 298.64 0.00
shared ges enqueues 102.62 102.62 0.00
shared ges resource 63.12 62.56 -0.88
shared kglsim object batch 68.52 68.52 0.00
shared library cache 104.29 104.17 -0.11
shared obj stat memo 167.95 167.98 0.01
shared sql area 88.86 92.19 3.75
shared trace buffer 60.08 60.08 0.00
streams KGH: NO ACCESS 15.99 15.99 0.00
streams Sender info 4.50 4.50 0.00
streams free memory 31.20 31.20 0.00
streams kwqbcqini:spilledovermsgs 0.63 0.63 0.00
  buffer_cache 22,960.00 22,960.00 0.00
  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 270,000 42,435 0
QMON Coordinator 190,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

Queue Schema and NameIncoming per secondOutgoing per secondSpilled per secondDiff Pct Spilled
SYS.KUPC$S_1_20130323232332 0 0 0 0

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 1,885,132 3,367,550 3227533 3227533


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 1   
job_queue_processes 20   
local_listener (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.6.71)(PORT = 1521))   
log_archive_dest /arch01   
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 SYS$SYS.KUPC$S_1_20130323232332.NDMIS, nd_mis, ndmis   
sessions 5505   
sga_target 27917287424   
spfile /dev/rspfile_128m   
thread 1   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/product/admin/ndmis/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 26,643 14.78 0.62
acks for commit broadcast(logical) 31,738 17.60 0.74
broadcast msgs on commit(actual) 44,715 24.80 1.05
broadcast msgs on commit(logical) 44,953 24.93 1.05
broadcast msgs on commit(wasted) 7,522 4.17 0.18
broadcast on commit wait time(ms) 7,159 3.97 0.17
broadcast on commit waits 35,794 19.85 0.84
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 2 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 535,745 297.17 12.54
gcs ast xid 6 0.00 0.00
gcs blocked converts 48,058 26.66 1.12
gcs blocked cr converts 88,183 48.91 2.06
gcs compatible basts 1,363 0.76 0.03
gcs compatible cr basts (global) 10,588 5.87 0.25
gcs compatible cr basts (local) 1,183,673 656.57 27.70
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 14,722 8.17 0.34
gcs dbwr write request msgs 11,739 6.51 0.27
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 19,355 10.74 0.45
gcs immediate (null) converts 121,517 67.40 2.84
gcs immediate cr (compatible) converts 320 0.18 0.01
gcs immediate cr (null) converts 1,725,108 956.89 40.37
gcs indirect ast 278,355 154.40 6.51
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 5,353 2.97 0.13
gcs msgs process time(ms) 208,069 115.41 4.87
gcs msgs received 4,666,766 2,588.58 109.20
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 351 0.19 0.01
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 0 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 4 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 79 0.04 0.00
gcs side channel msgs actual 87,581 48.58 2.05
gcs side channel msgs logical 1,807,104 1,002.37 42.29
gcs stale cr 294 0.16 0.01
gcs undo cr 67 0.04 0.00
gcs write notification msgs 1,015 0.56 0.02
gcs writes refused 37 0.02 0.00
ges msgs process time(ms) 2,145 1.19 0.05
ges msgs received 242,071 134.27 5.66
global posts dropped 0 0.00 0.00
global posts queue time 0 0.00 0.00
global posts queued 0 0.00 0.00
global posts requested 0 0.00 0.00
global posts sent 0 0.00 0.00
implicit batch messages received 334,583 185.59 7.83
implicit batch messages sent 323,793 179.60 7.58
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 125,202 69.45 2.93
messages queue sent actual 805,834 446.98 18.86
messages queue sent logical 2,016,868 1,118.73 47.19
messages received actual 1,883,150 1,044.55 44.07
messages received logical 4,908,897 2,722.89 114.87
messages sent directly 883,522 490.08 20.67
messages sent indirectly 1,775,946 985.09 41.56
messages sent not implicit batched 482,071 267.40 11.28
messages sent pbatched 2,628,159 1,457.80 61.50
msgs causing lmd to send msgs 82,317 45.66 1.93
msgs causing lms(s) to send msgs 134,437 74.57 3.15
msgs received queue time (ms) 35,481 19.68 0.83
msgs received queued 4,908,568 2,722.71 114.86
msgs sent queue time (ms) 779,490 432.37 18.24
msgs sent queue time on ksxp (ms) 614,759 341.00 14.39
msgs sent queued 1,923,659 1,067.02 45.01
msgs sent queued on ksxp 1,973,182 1,094.49 46.17
number of ges deadlock detected 0 0.00 0.00
process batch messages received 373,613 207.24 8.74
process batch messages sent 449,999 249.61 10.53


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 86,543
CURRENT Block Requests 1,930
Data Block Requests 86,543
Undo Block Requests 65
TX Block Requests 391
Current Results 88,152
Private results 83
Zero Results 237
Disk Read Results 0
Fail Results 0
Fairness Down Converts 17,851
Fairness Clears 0
Free GC Elements 0
Flushes 121
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 246
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 978,593 99.99 0.00 0.01 0.00 0.00
Flushes 250 80.00 16.00 4.00 0.00 0.00
Writes 17,781 53.28 40.63 4.86 0.42 0.82


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 97,314 99.71 0.11 0.18 1,376,736 98.01 0.02 1.97
2 Others 1,635 99.94 0.06 0.00 2,755 99.89 0.04 0.07
2 undo header 553 97.65 2.35 0.00 171 96.49 3.51 0.00
2 undo block 97 97.94 2.06 0.00 0      


Back to Top

End of Report