WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
NDMIS3941636119ndmis2210.2.0.5.0YESndora2

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2647327-Mar-13 17:30:271131 6.3
End Snap:2647427-Mar-13 18:00:291445 6.5
Elapsed:  30.03 (mins)  
DB Time:  58.76 (mins)  

Report Summary

Cache Sizes

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

Load Profile

Per SecondPer Transaction
Redo size: 58,756.12 11,308.01
Logical reads: 72,711.52 13,993.83
Block changes: 789.21 151.89
Physical reads: 574.63 110.59
Physical writes: 41.17 7.92
User calls: 1,615.87 310.99
Parses: 113.08 21.76
Hard parses: 16.63 3.20
Sorts: 63.03 12.13
Logons: 0.40 0.08
Executes: 1,262.19 242.92
Transactions: 5.20 

% Blocks changed per Read: 1.09Recursive Call %: 51.07
Rollback per transaction %: 4.01Rows per Sort: 124.29

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98Redo NoWait %: 100.00
Buffer Hit %: 99.41In-memory Sort %: 100.00
Library Hit %: 96.97Soft Parse %: 85.29
Execute to Parse %: 91.04Latch Hit %: 99.81
Parse CPU to Parse Elapsd %: 19.82% Non-Parse CPU: 99.01

Shared Pool Statistics

BeginEnd
Memory Usage %: 53.61 73.77
% SQL with executions>1: 17.54 37.34
% Memory for SQL w/exec>1: 25.32 50.79

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  1,030  29.2 
db file sequential read 150,683 705 5 20.0User I/O
SQL*Net message from dblink 80,273 698 9 19.8Network
db file scattered read 73,980 308 4 8.7User I/O
gc cr multi block request 922,954 169 0 4.8Cluster

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 784.62 151.00
Global Cache blocks served: 484.79 93.30
GCS/GES messages received: 2,200.01 423.41
GCS/GES messages sent: 2,044.29 393.44
DBWR Fusion writes: 4.16 0.80
Estd Interconnect traffic (KB) 10,984.24 

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

Buffer access - local cache %: 98.33
Buffer access - remote cache %: 1.08
Buffer access - disk %: 0.59

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0
Avg global cache cr block receive time (ms): 0.6
Avg global cache current block receive time (ms): 1.0
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 0.4
Avg global cache cr block flush time (ms): 0.6
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): 0.8

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 1.7
Avg message sent queue time on ksxp (ms): 0.4
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: 35.05
% of indirect sent messages: 62.65
% of flow controlled messages: 2.29


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 3,412.69 96.79
DB CPU 1,030.18 29.22
parse time elapsed 83.97 2.38
hard parse elapsed time 69.13 1.96
PL/SQL execution elapsed time 52.27 1.48
PL/SQL compilation elapsed time 14.07 0.40
hard parse (sharing criteria) elapsed time 4.43 0.13
connection management call elapsed time 1.96 0.06
failed parse elapsed time 1.83 0.05
hard parse (bind mismatch) elapsed time 0.95 0.03
repeated bind elapsed time 0.92 0.03
sequence load elapsed time 0.06 0.00
DB time 3,525.86  
background elapsed time 332.51  
background cpu time 222.23  

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 240,940   1,068 4 30.29
CPU time     1,030   29.22
Network 3,301,334   748 0 21.23
Cluster 1,289,278 0 338 0 9.58
System I/O 258,942   60 0 1.71
Other 60,172 74 17 0 0.47
Commit 9,090 0 13 1 0.38
Concurrency 12,997   3 0 0.09
Application 231   0 1 0.00
Configuration 86   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 150,683   705 5 16.09
SQL*Net message from dblink 80,273   698 9 8.57
db file scattered read 73,980   308 4 7.90
gc cr multi block request 922,954   169 0 98.57
gc current block 2-way 205,315   83 0 21.93
control file sequential read 211,409   38 0 22.58
SQL*Net more data from client 8,406   36 4 0.90
db file parallel read 6,186   34 6 0.66
gc buffer busy 32,231 0 28 1 3.44
gc cr grant 2-way 69,905   24 0 7.47
db file parallel write 35,686   15 0 3.81
gc cr block 2-way 34,526   15 0 3.69
log file sync 9,090 0 13 1 0.97
direct path read temp 3,777   12 3 0.40
SQL*Net more data from dblink 9,584   8 1 1.02
gc current grant busy 8,506   7 1 0.91
direct path read 5,093   7 1 0.54
log file parallel write 11,007   6 1 1.18
Streams AQ: qmn coordinator waiting for slave to start 1 100 5 5209 0.00
SQL*Net more data to client 342,392   5 0 36.57
enq: WF - contention 20 45 4 225 0.00
gc current grant 2-way 7,856   3 0 0.84
gc current multi block request 7,334   3 0 0.78
ges lmd/lmses to freeze in rcfg - mrcvr 739 27 3 4 0.08
row cache lock 10,760   2 0 1.15
CSS initialization 33   2 51 0.00
SQL*Net message to client 2,780,354   2 0 296.95
gc cr grant congested 11   2 137 0.00
direct path write temp 407   1 3 0.04
gc current block busy 78   1 15 0.01
gc current block congested 12   1 89 0.00
control file parallel write 840   1 1 0.09
os thread startup 10   1 58 0.00
gc cr block congested 6   0 82 0.00
read by other session 102   0 3 0.01
latch: object queue header operation 49   0 6 0.01
CGS wait for IPC msg 36,636 98 0 0 3.91
gcs drm freeze in enter server mode 1   0 272 0.00
gcs log flush sync 342   0 1 0.04
DFS lock handle 596   0 0 0.06
latch free 170   0 1 0.02
gc cr disk read 427   0 0 0.05
gc cr block busy 99   0 1 0.01
library cache pin 477   0 0 0.05
ksxr poll remote instances 17,940 34 0 0 1.92
direct path write 712   0 0 0.08
rdbms ipc reply 456   0 0 0.05
library cache lock 242   0 0 0.03
name-service call wait 1   0 78 0.00
enq: TM - contention 174   0 0 0.02
enq: TX - row lock contention 5   0 14 0.00
enq: PS - contention 102   0 0 0.01
latch: gcs resource hash 29   0 2 0.00
latch: cache buffers chains 1,463   0 0 0.16
reliable message 156   0 0 0.02
SQL*Net message to dblink 80,237   0 0 8.57
enq: CF - contention 92   0 0 0.01
enq: HW - contention 86   0 0 0.01
latch: KCL gc element parent latch 44   0 1 0.00
enq: TX - index contention 36   0 1 0.00
PX Deq: reap credit 2,071 97 0 0 0.22
PX Deq Credit: send blkd 106 14 0 0 0.01
CSS operation: action 49   0 1 0.01
IPC send completion sync 47 100 0 0 0.01
enq: FB - contention 32   0 0 0.00
PX Deq: Signal ACK 109 36 0 0 0.01
SQL*Net break/reset to client 37   0 0 0.00
LGWR wait for redo copy 274   0 0 0.03
enq: TA - contention 8   0 0 0.00
latch: session allocation 13   0 0 0.00
enq: TD - KTF dump entries 4   0 0 0.00
enq: TT - contention 5   0 0 0.00
gc current block unknown 4   0 0 0.00
SQL*Net more data to dblink 88   0 0 0.01
ges2 LMON to wake up LMD - mrcvr 36   0 0 0.00
enq: AF - task serialization 2   0 0 0.00
enq: AS - service activation 1   0 0 0.00
enq: TO - contention 1   0 0 0.00
SQL*Net break/reset to dblink 15   0 0 0.00
enq: MW - contention 1   0 0 0.00
enq: DR - contention 1   0 0 0.00
buffer busy waits 7   0 0 0.00
gc current split 1   0 0 0.00
latch: shared pool 2   0 0 0.00
gc object scan 13 92 0 0 0.00
wait for scn ack 1   0 0 0.00
latch: cache buffers lru chain 1   0 0 0.00
KJC: Wait for msg sends to complete 1   0 0 0.00
lock escalate retry 1   0 0 0.00
cursor: pin S 1   0 0 0.00
SQL*Net message from client 2,780,688   2,448,372 880 296.99
gcs remote message 1,769,309 37 27,901 16 188.97
Streams AQ: qmn slave idle wait 71 1 1,797 25309 0.01
virtual circuit status 60 100 1,758 29297 0.01
Streams AQ: waiting for time management or cleanup tasks 6 100 1,758 292969 0.00
DIAG idle wait 8,994   1,758 195 0.96
Streams AQ: waiting for messages in the queue 371 98 1,757 4736 0.04
PX Idle Wait 736 92 1,757 2387 0.08
ges remote message 41,998 50 1,756 42 4.49
Streams AQ: qmn coordinator idle wait 125 50 1,733 13865 0.01
jobq slave wait 96 100 281 2930 0.01
single-task message 21   1 28 0.00
PX Deq: Execution Msg 246 12 0 2 0.03
PX Deq: Join ACK 120 33 0 1 0.01
PX Deq: Parse Reply 122 34 0 1 0.01
PX Deq: Msg Fragment 90 12 0 0 0.01
PX Deq: Execute Reply 107 27 0 0 0.01
class slave wait 6   0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 127 100 0 0 0.01

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file parallel write 35,686   15 0 3.81
events in waitclass Other 56,851 74 9 0 6.07
log file parallel write 11,008   6 1 1.18
control file sequential read 5,114   5 1 0.55
control file parallel write 840   1 1 0.09
db file sequential read 119   1 6 0.01
os thread startup 10   1 58 0.00
gc cr block 2-way 171   0 0 0.02
gc current block 2-way 26   0 1 0.00
gc current grant 2-way 33   0 0 0.00
gc cr grant 2-way 12   0 0 0.00
latch: cache buffers chains 14   0 0 0.00
gc object scan 13 92 0 0 0.00
buffer busy waits 1   0 0 0.00
rdbms ipc message 84,055 33 35,118 418 8.98
gcs remote message 1,769,266 37 27,900 16 188.96
pmon timer 746 100 1,758 2357 0.08
Streams AQ: waiting for time management or cleanup tasks 6 100 1,758 292969 0.00
DIAG idle wait 8,994   1,758 195 0.96
ges remote message 41,956 50 1,756 42 4.48
Streams AQ: qmn coordinator idle wait 125 50 1,733 13865 0.01
smon timer 43 14 1,594 37064 0.00
Streams AQ: RAC qmn coordinator idle wait 127 100 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 3,790
AVG_IDLE_TIME 176,157
AVG_IOWAIT_TIME 1,250
AVG_SYS_TIME 1,126
AVG_USER_TIME 2,601
BUSY_TIME 246,559
IDLE_TIME 11,277,648
IOWAIT_TIME 83,374
SYS_TIME 76,213
USER_TIME 170,346
LOAD 2
OS_CPU_WAIT_TIME 277,000
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 1,449,984
VM_OUT_BYTES 25,690,112
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 3,400.50 975.10 955,646 128,307,930
SYS$USERS 134.80 60.20 79,207 2,665,110
SYS$BACKGROUND 0.00 0.00 742 81,612
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 233290 1048 9554 2 0 0 3294340 713
SYS$USERS 6621 16 1085 0 0 0 3318 0
SYS$BACKGROUND 1022 4 2448 1 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
645 0 124 5.20 18.30 c5tmjxj6rtck4 JDBC Thin Client SELECT mis_t.tg_id id, (SELECT...
249 22 1 248.93 7.06 5b547zkdp3mq6 JDBC Thin Client begin ol$_core_expand.MADEEQUI...
239 17 1 238.63 6.77 6fn21cpfwmbmw JDBC Thin Client INSERT INTO T_EQUIMODIFY_DETAI...
193 13 580 0.33 5.46 gkw6wc3pm09j6 JDBC Thin Client SELECT USER_NAME FROM AMBER.IN...
126 77 44,750 0.00 3.56 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
92 38 1 92.45 2.62 aw6gj3r2syaxs JDBC Thin Client select interdata.area_code, in...
90 14 1 90.06 2.55 525r285cr9aa7 nqsserver@ndmisbiee02 (TNS V1-V3) select T128047.KGLX as c4, T1...
75 6 87 0.86 2.12 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
62 2 54 1.15 1.76 9yh5wgu938tja JDBC Thin Client BEGIN OL$_CORE_EXPAND.Batchins...
62 2 54 1.15 1.75 cs4fxq1s9xvyc JDBC Thin Client UPDATE OLIVE.V$_ST_ASSET X SET...
52 24 63 0.83 1.48 598k07tzg7tud JDBC Thin Client Select Ass.Obj_Id, ass.CLS_URI...
51 32 197 0.26 1.44 0b243yjuy3dvq JDBC Thin Client select x.attr_uri, x.attr_name...
51 11 1,225 0.04 1.44 1h1sr3yhptj6t JDBC Thin Client SELECT DISTINCT a.sys_user_nam...
47 15 10 4.73 1.34 05fs85a4b0dy2 JDBC Thin Client select t.plan_item_id, t.plan_...
44 5 1 43.50 1.23 gxv1gvzu11p4a nqsserver@ndmisbiee02 (TNS V1-V3) select T121580.BDSMC as c1, T...
42 7 132 0.32 1.19 7xn6xppmpg9u7 JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...

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
77 126 44,750 0.00 7.50 3.56 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
38 92 1 38.16 3.70 2.62 aw6gj3r2syaxs JDBC Thin Client select interdata.area_code, in...
32 51 197 0.16 3.14 1.44 0b243yjuy3dvq JDBC Thin Client select x.attr_uri, x.attr_name...
24 52 63 0.39 2.37 1.48 598k07tzg7tud JDBC Thin Client Select Ass.Obj_Id, ass.CLS_URI...
22 249 1 22.44 2.18 7.06 5b547zkdp3mq6 JDBC Thin Client begin ol$_core_expand.MADEEQUI...
17 239 1 17.03 1.65 6.77 6fn21cpfwmbmw JDBC Thin Client INSERT INTO T_EQUIMODIFY_DETAI...
17 27 126 0.13 1.64 0.77 awvtdy3vc6fum JDBC Thin Client SELECT codeId, codeSortId, par...
16 27 2 7.81 1.52 0.76 572fbaj0fdw2b sqlplus@ndora2 (TNS V1-V3) select output from table(dbms_...
15 47 10 1.53 1.49 1.34 05fs85a4b0dy2 JDBC Thin Client select t.plan_item_id, t.plan_...
14 90 1 13.73 1.33 2.55 525r285cr9aa7 nqsserver@ndmisbiee02 (TNS V1-V3) select T128047.KGLX as c4, T1...
13 20 6 2.14 1.24 0.57 2w5dgfjvasy4j JDBC Thin Client SELECT stat.sid, sess.status, ...
13 193 580 0.02 1.22 5.46 gkw6wc3pm09j6 JDBC Thin Client SELECT USER_NAME FROM AMBER.IN...
12 29 274 0.04 1.18 0.83 4ydgzsjh9kb57 JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
11 33 25 0.45 1.09 0.93 fkc00x536y5kw JDBC Thin Client select /*+rule*/ p.OBJ_ID as i...
11 51 1,225 0.01 1.09 1.44 1h1sr3yhptj6t JDBC Thin Client SELECT DISTINCT a.sys_user_nam...
11 17 1 11.17 1.08 0.49 cq9hj0h4ju789 JDBC Thin Client select b.name deptName, a.USER...

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
19,609,457 580 33,809.41 14.97 12.54 192.51 gkw6wc3pm09j6 JDBC Thin Client SELECT USER_NAME FROM AMBER.IN...
14,175,007 44,750 316.76 10.82 77.24 125.68 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
9,132,887 1 9,132,887.00 6.97 13.73 90.06 525r285cr9aa7 nqsserver@ndmisbiee02 (TNS V1-V3) select T128047.KGLX as c4, T1...
6,358,288 126 50,462.60 4.85 16.94 27.24 awvtdy3vc6fum JDBC Thin Client SELECT codeId, codeSortId, par...
5,437,525 197 27,601.65 4.15 32.37 50.85 0b243yjuy3dvq JDBC Thin Client select x.attr_uri, x.attr_name...
4,578,309 1,048 4,368.62 3.49 9.67 22.02 5wfhpq886xacr JDBC Thin Client SELECT /*+index(t, NK_OL$_REFS...
4,061,391 1 4,061,391.00 3.10 22.44 248.93 5b547zkdp3mq6 JDBC Thin Client begin ol$_core_expand.MADEEQUI...
3,474,451 3 1,158,150.33 2.65 5.34 18.38 1zqktnh3k2w9h JDBC Thin Client SELECT * FROM ( select name "Éú...
3,240,389 10 324,038.90 2.47 15.30 47.35 05fs85a4b0dy2 JDBC Thin Client select t.plan_item_id, t.plan_...
3,132,635 624,646 5.02 2.39 5.66 19.20 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
3,050,393 903 3,378.07 2.33 7.19 21.81 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
2,184,246 2 1,092,123.00 1.67 15.61 26.84 572fbaj0fdw2b sqlplus@ndora2 (TNS V1-V3) select output from table(dbms_...
2,030,959 1 2,030,959.00 1.55 5.25 8.40 7rph7uc1mq73k JDBC Thin Client INSERT INTO T_EQUIMODIFY_DETAI...
2,024,131 1 2,024,131.00 1.54 17.03 238.63 6fn21cpfwmbmw JDBC Thin Client INSERT INTO T_EQUIMODIFY_DETAI...
1,864,777 1 1,864,777.00 1.42 11.17 17.27 cq9hj0h4ju789 JDBC Thin Client select b.name deptName, a.USER...
1,553,556 63 24,659.62 1.19 24.43 52.18 598k07tzg7tud JDBC Thin Client Select Ass.Obj_Id, ass.CLS_URI...
1,358,974 3,161 429.92 1.04 0.09 10.35 c7udywnqw95vh JDBC Thin Client select value, name from sgpm.p...
1,344,457 2 672,228.50 1.03 4.71 26.95 39896zjqcvbms JDBC Thin Client SELECT * FROM ( select s.equip...

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
337,751 1 337,751.00 32.62 13.73 90.06 525r285cr9aa7 nqsserver@ndmisbiee02 (TNS V1-V3) select T128047.KGLX as c4, T1...
64,344 1 64,344.00 6.21 22.44 248.93 5b547zkdp3mq6 JDBC Thin Client begin ol$_core_expand.MADEEQUI...
63,477 1 63,477.00 6.13 17.03 238.63 6fn21cpfwmbmw JDBC Thin Client INSERT INTO T_EQUIMODIFY_DETAI...
51,878 1 51,878.00 5.01 4.50 43.50 gxv1gvzu11p4a nqsserver@ndmisbiee02 (TNS V1-V3) select T121580.BDSMC as c1, T...
51,196 1,225 41.79 4.94 11.19 50.69 1h1sr3yhptj6t JDBC Thin Client SELECT DISTINCT a.sys_user_nam...
25,008 8 3,126.00 2.42 5.18 19.06 35x85qdq8manh JDBC Thin Client SELECT DISTINCT a.sys_user_nam...
16,717 274 61.01 1.61 12.14 29.28 4ydgzsjh9kb57 JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
16,456 87 189.15 1.59 6.45 74.70 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
13,708 54 253.85 1.32 1.96 61.89 9yh5wgu938tja JDBC Thin Client BEGIN OL$_CORE_EXPAND.Batchins...
13,708 54 253.85 1.32 1.96 61.86 cs4fxq1s9xvyc JDBC Thin Client UPDATE OLIVE.V$_ST_ASSET X SET...

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
624,646 624,630 1.00 0.00 0.00 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
108,555 108,555 1.00 0.00 0.00 5yp7648cjj2s1 JDBC Thin Client SELECT t.sys_user_name, t.user...
108,384 108,386 1.00 0.00 0.00 gfaqgusc2hfr5 JDBC Thin Client SELECT org_no, org_name, p_org...
44,750 44,708 1.00 0.00 0.00 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
17,334 35,895 2.07 0.00 0.00 cfrwbnuu2xtam JDBC Thin Client select side_b from ol$_associa...
14,026 14,026 1.00 0.00 0.00 g4rzpg6rj116d JDBC Thin Client BEGIN OL$_RULE_CORE.SETSTRATTR...
13,561 13,561 1.00 0.00 0.00 grwydz59pu6mc   select text from view$ where r...
9,149 9,149 1.00 0.00 0.00 2bnuvr2y93awr JDBC Thin Client SELECT T.CLS_URI, T.ATTR_NAME,...
7,494 7,493 1.00 0.00 0.00 7xgzx0zrnt0fc JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
6,516 0 0.00 0.00 0.00 15p742qrkv57u JDBC Thin Client SELECT * FROM sgpm.o_org WHERE...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
13,561 13,561 6.66 grwydz59pu6mc   select text from view$ where r...
4,067 4,067 2.00 2ym6hhaq30r73   select type#, blocks, extents,...
2,137 5,978 1.05 02djppxs4a73n JDBC Thin Client update ol$_locks t set t.obj =...
1,899 2,942 0.93 449xyhjkn7apn JDBC Thin Client select * from v$_ST_EquipmentC...
1,882 2,434 0.92 d3gsxy5k0u8hw JDBC Thin Client select * from v$_ST_Asset wher...
1,851 6,340 0.91 8b9zc43w360qt JDBC Thin Client SELECT O_28 partitionField FRO...
1,668 3,570 0.82 a41yvpfth003x JDBC Thin Client select * from v$_ST_Equipment ...
1,558 2,500 0.76 dnctudjagb520 JDBC Thin Client select * from v$_ST_AssetModel...
1,541 17,334 0.76 cfrwbnuu2xtam JDBC Thin Client select side_b from ol$_associa...
1,521 2,344 0.75 244v8yhfs7urr JDBC Thin Client SELECT C.CLS_ID, C.CLS_URI, C....

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,289,669 30 0.06 f8uvk4ymbh19z JDBC Thin Client SELECT NAME, TYPE, ACTION_URL,...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

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
57.28 61.95 92.45 38.16 1 aw6gj3r2syaxs JDBC Thin Client select interdata.area_code, in...
27.05 10.87 248.93 22.44 1 5b547zkdp3mq6 JDBC Thin Client begin ol$_core_expand.MADEEQUI...
26.70 11.19 238.63 17.03 1 6fn21cpfwmbmw JDBC Thin Client INSERT INTO T_EQUIMODIFY_DETAI...
20.42 43.13 47.35 15.30 10 05fs85a4b0dy2 JDBC Thin Client select t.plan_item_id, t.plan_...
14.07 52.55 26.77 6.39 3 57dshrk20f9nk JDBC Thin Client select t.plan_item_id, t.plan_...
10.92 44.30 24.65 8.01 5 0k5gsd7bnr1wr JDBC Thin Client select b.workingBeginDateMin, ...
9.61 12.86 74.70 6.45 87 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
8.46 16.21 52.18 24.43 63 598k07tzg7tud JDBC Thin Client Select Ass.Obj_Id, ass.CLS_URI...
8.22 19.65 41.84 7.24 132 7xn6xppmpg9u7 JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
7.51 8.34 90.06 13.73 1 525r285cr9aa7 nqsserver@ndmisbiee02 (TNS V1-V3) select T128047.KGLX as c4, T1...
6.29 12.41 50.69 11.19 1,225 1h1sr3yhptj6t JDBC Thin Client SELECT DISTINCT a.sys_user_nam...
4.60 15.77 29.14 2.66 1 ggsus9qmhfqws JDBC Thin Client SELECT COUNT(1) cnt FROM( With...
4.51 23.67 19.06 5.18 8 35x85qdq8manh JDBC Thin Client SELECT DISTINCT a.sys_user_nam...
4.42 10.16 43.50 4.50 1 gxv1gvzu11p4a nqsserver@ndmisbiee02 (TNS V1-V3) select T121580.BDSMC as c1, T...
4.37 14.91 29.28 12.14 274 4ydgzsjh9kb57 JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
4.03 14.73 27.39 3.64 230 7kg4x6mdk9rf0 JDBC Thin Client BEGIN :1 :=OWF_MGR.PKG_INDY_OR...
2.80 1.46 192.51 12.54 580 gkw6wc3pm09j6 JDBC Thin Client SELECT USER_NAME FROM AMBER.IN...
2.59 4.19 61.89 1.96 54 9yh5wgu938tja JDBC Thin Client BEGIN OL$_CORE_EXPAND.Batchins...
2.59 4.19 61.86 1.96 54 cs4fxq1s9xvyc JDBC Thin Client UPDATE OLIVE.V$_ST_ASSET X SET...
2.41 11.26 21.40 2.45 678 g0mmxhhfz1q9g JDBC Thin Client select * from v$_LowArea where...
2.10 7.12 29.55 1.56 1,921 9yyb7wvndk114 JDBC Thin Client select * from v$_ST_DYLine whe...
1.60 4.89 32.74 11.24 25 fkc00x536y5kw JDBC Thin Client select /*+rule*/ p.OBJ_ID as i...
1.45 5.38 26.95 4.71 2 39896zjqcvbms JDBC Thin Client SELECT * FROM ( select s.equip...
1.38 7.21 19.20 5.66 624,646 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
1.32 10.29 12.83 6.50 818 93dtuy0vt2k7q JDBC Thin Client SELECT task_id FROM p_task WHE...
1.30 5.79 22.46 1.52 107 1r7mjtz9kp72t JDBC Thin Client select * from (select /*+rule*...
1.18 10.49 11.25 0.79 3,570 a41yvpfth003x JDBC Thin Client select * from v$_ST_Equipment ...
0.95 4.36 21.81 7.19 903 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
0.92 8.12 11.29 0.79 2,434 d3gsxy5k0u8hw JDBC Thin Client select * from v$_ST_Asset wher...
0.68 29.91 2.28 0.31 2,942 449xyhjkn7apn JDBC Thin Client select * from v$_ST_EquipmentC...
0.61 6.11 9.90 1.13 1,229 450w20twk6ku5 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKNAMEM...
0.40 4.63 8.69 0.68 6 5bhhxz06fvgnk JDBC Thin Client SELECT OBJ_ID, NAME, A.CLS_URI...
0.38 1.71 22.02 9.67 1,048 5wfhpq886xacr JDBC Thin Client SELECT /*+index(t, NK_OL$_REFS...
0.32 1.18 26.84 15.61 2 572fbaj0fdw2b sqlplus@ndora2 (TNS V1-V3) select output from table(dbms_...
0.28 58.22 0.49 0.04 292 bm62pp5bq23r5 JDBC Thin Client SELECT a.app_no, a.taskid, b.l...
0.28 57.96 0.49 0.13 389 ac4pb7ypdb95a JDBC Thin Client select count(l.log_machine_ip)...
0.25 7.92 3.11 0.26 2,143 1f5c885f3vvfx JDBC Thin Client select /*+ index(v$_ST_Asset I...
0.19 6.81 2.86 0.75 945 dczy7gkm3mpax JDBC Thin Client update ol$_objects set S_04 = ...
0.18 12.90 1.36 0.11 7,494 7xgzx0zrnt0fc JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
0.17 20.49 0.83 0.14 4,560 6pcrpqf5dkunf JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
0.17 2.00 8.40 5.25 1 7rph7uc1mq73k JDBC Thin Client INSERT INTO T_EQUIMODIFY_DETAI...
0.13 17.09 0.78 0.09 6,340 8b9zc43w360qt JDBC Thin Client SELECT O_28 partitionField FRO...
0.11 21.05 0.51 0.18 611 8d3y3sqaj9f3s JDBC Thin Client SELECT * FROM (SELECT row_.*, ...
0.11 1.80 6.02 3.74 30 5qr55krh9dkx5 JDBC Thin Client select APPLY_ID, APPLY_CD, APP...
0.11 1.03 10.35 0.09 3,161 c7udywnqw95vh JDBC Thin Client select value, name from sgpm.p...
0.10 8.36 1.18 0.07 2,500 dnctudjagb520 JDBC Thin Client select * from v$_ST_AssetModel...
0.06 50.84 0.12 0.00 28 4860dcbah84h4 JDBC Thin Client update t_yxdz_czpxx t set t.zl...
0.06 14.79 0.38 0.25 2,680 3c1kubcdjnppq   update sys.col_usage$ set equa...
0.05 16.03 0.29 0.03 1,040 4hn182nyc6xd5 JDBC Thin Client INSERT INTO T_YPJC_DISTLINESEG...
0.05 3.61 1.27 0.10 1 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
0.05 14.25 0.32 0.02 20 8d150bzkm38pm JDBC Thin Client SELECT 1 FROM indy_user_action...
0.04 20.30 0.20 0.07 258 czxzy970jq50g JDBC Thin Client update ol$_objects set S_27 = ...
0.04 17.51 0.22 0.01 716 byuacw6h7dqkn JDBC Thin Client INSERT INTO T_YPJC_DISTTRANSFO...
0.04 11.24 0.34 0.03 2,699 b0mb9f2wdgnrk JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
0.04 3.91 0.93 0.23 1 dst5yk4vxcg04 JDBC Thin Client select a.line_id, a.line_name,...
0.03 6.97 0.49 0.03 303 d7qa0bq22h0p3 JDBC Thin Client SELECT A FROM OL$_ASSOCIATIONS...
0.03 0.39 8.26 5.06 76 g8kw89rqydxjm JDBC Thin Client select b.* from t_plan_week_pl...
0.03 31.03 0.09 0.03 331 gk7v3zx64y3ma JDBC Thin Client INSERT INTO t_ypjc_lowlinesegm...
0.03 11.85 0.22 0.01 71 btd9xht9j1ah9 JDBC Thin Client insert into PMS.t_plan_workflo...
0.02 10.49 0.21 0.14 102 6t8pyz0wcrk16 JDBC Thin Client update ol$_objects set D_03 = ...
0.02 35.75 0.04 0.02 15 bvuadm73ru53a JDBC Thin Client INSERT INTO T_YPJC_LINELOSE (i...
0.02 0.09 17.27 11.17 1 cq9hj0h4ju789 JDBC Thin Client select b.name deptName, a.USER...
0.01 12.07 0.12 0.06 62 4bzh761vk20q0 JDBC Thin Client update ol$_objects set D_07 = ...
0.01 8.94 0.14 0.04 30 f8uvk4ymbh19z JDBC Thin Client SELECT NAME, TYPE, ACTION_URL,...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
02djppxs4a73nupdate ol$_locks t set t.obj = null
05fs85a4b0dy2select t.plan_item_id, t.plan_year, t.PLAN_CD, t.month_plan_cd, t.plan_type, t.voltage_class_cd, t.voltage_class, t.work_site_id, t.work_site, t.stop_asset_id, t.stop_asset, t.item_State_Cd, t.stop_power_switch_id, t.stop_power_switch, t.org_no, t.org_name, t.dept_no, t.dept_name, t.item_state, to_char(t.stop_begin_date, 'yyyy-mm-dd hh24:mi:ss') strStopBeginDate, to_char(t.stop_end_date, 'yyyy-mm-dd hh24:mi:ss') strStopEndDate from t_plan_week_plan_items t where 1=1 and t.item_state in ('ÒÑ·¢²¼', 'ÒÑÍê³É') and t.org_no like GETORGNO(:1) and t.plan_type_cd =:2 and t.plan_year = :3 and t.plan_cd in (select a.week_plan_id from V_TICKET_QUERY a, V_POWERCUT_QUERY b where a.week_plan_id=b.WEEK_PLAN_CD )
0b243yjuy3dvqselect x.attr_uri, x.attr_name, x.attr_disp_name, x.attr_data_type, x.attr_index, x.attr_pos, x.attr_doc, x.cls_uri, x.cls_derive, y.cat_id, y.cat_disp_name, z.con_id, z.can_be_null, z.min_str_len, z.max_str_len, z.min_num_val, z.max_num_val, z.num_precision, z.min_date_val, z.max_date_val, z.attr_cls, e.edt_package, e.edt_class, e.edt_data from ol$_attr_defs x left join ol$_attr_categories y on x.cat_id = y.cat_id left join ol$_attr_constraints z on ol$_core.GETATTRDERIVE(x.attr_uri) = z.attr_uri left join ol$_attr_editors e on ol$_core.getattrprime(x.attr_uri) = e.attr_uri where x.cls_uri = :1 order by x.attr_index
0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0k5gsd7bnr1wrselect b.workingBeginDateMin, b.workingEndDateMax , a.delay_begin_date, a.delay_end_date from v_powercut_apply_query a, ( select min(t.WORKING_BEGIN_DATE) workingBeginDateMin, max(t.WORKING_END_DATE ) workingEndDateMax from v_powercut_apply_query t where t.actionname in('EXECUTE', 'OVER') and t.ORG_NO= :1 and t.week_plan_cd= :2 ) b where a.WORKING_END_DATE=b.workingEndDateMax
15p742qrkv57uSELECT * FROM sgpm.o_org WHERE org_no=''
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
1h1sr3yhptj6tSELECT DISTINCT a.sys_user_name, a.user_name, a.org_no, a.dept_no, (SELECT NAME FROM o_dept WHERE dept_no = a.dept_no) dept_name, (SELECT org_name FROM o_org WHERE org_no = a.org_no) org_name FROM v_sp_user a, v_sp_user_operpriv b WHERE a.sys_user_name = b.sys_user_name AND a.cur_status_code = '01' AND a.org_no = b.org_no AND a.org_no = :1 AND a.dept_no = :2 AND b.auth_id = :3 ORDER BY nlssort(a.user_name, 'NLS_SORT=SCHINESE_PINYIN_M')
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
1zqktnh3k2w9h SELECT * FROM ( select name "Éú²ú±äѹÆ÷Ãû³Æ", (select org_name from sgpm.o_org where org_no = orgid And Rownum = 1) "¹©µçµ¥Î»", (select (select (select name from olive.v$_st_feeder where obj_id = substr(o.s_04, 197, 64) And Rownum = 1) from olive.ol$_objects o where obj_id = x.a And Rownum = 1) from olive.ol$_associations x where b = substr(pathname, 2, 64) And Rownum = 1) "ËùÊôÖ÷Ïß", (select (select olive.getpathnamebypathid(o.s_04) from olive.ol$_objects o where obj_id = x.a And Rownum = 1) from olive.ol$_associations x where b = substr(pathname, 2, 64) And Rownum = 1) "Éú²ú±äѹÆ÷λÖÃ", (select (select o.INSERVICEDATE from olive.v$_st_powersystemresource o where obj_id = x.a And Rownum = 1) from olive.ol$_associations x where b = substr(pathname, 2, 64) And Rownum = 1) "ͶÔËÈÕÆÚ", (select (select (select (select org_name from sgpm.o_org where org_no=p_dept_no) from sgpm.o_dept where dept_no=o.o_15) from olive.ol$_objects o where obj_id = x.a And Rownum = 1) from olive.ol$_associations x where b = substr(pathname, 2, 64) And Rownum = 1) "ά»¤°à×é", '10kV' "µçѹµÈ¼¶", ratedCapacity "¶î¶¨ÈÝÁ¿(kVA)", obj_id "Éú²úID", (select name from sgpm.p_code where value = AssetsStatus and code_type = 'AssetsState' And Rownum = 1) "״̬", CCBH "³ö³§±àºÅ", (select name from sgpm.p_code where value = SBXH and code_type = 'DisTransAssetXH' And Rownum = 1) "É豸ÐͺÅ", (Select Name From Sgpm.p_Code p Where Value = (Select Usetype From Olive.V$_St_Distransformer Where Obj_Id = (Select a From Olive.Ol$_Associations Where b = t.Obj_Id and rownum = 1)) And p.Code_Type = 'UseType' and rownum = 1) "ËùÓÃÐÔÖÊ", (select name from sgpm.p_code where code_type = 'BDSB_ZCSSDW' and value = t.ASSETNATURE) "×ʲúÐÔÖÊ", decode((select (select ( (select 'Ïä±ä' from v$_ST_BoxStation where obj_id=substr(o.s_04, -129, 64)) ) from olive.ol$_objects o where obj_id = x.a A nd Rownum = 1) from olive.ol$_associations x where b = substr(pathname, 2, 64) And Rownum = 1), 'Ïä±ä', 'ÊÇ', '·ñ') "ÊÇ·ñÏä±ä", (select name from sgpm.p_code where code_type = 'TransforNature' and value = t.TRANSFORNATURE) "×ʲúËùÓÃÐÔÖÊ" from olive.v$_ST_DisTransAsset t where orgid = :1 and assetsstatus = decode(:2, null, 'S', :3, :4) and length( :5)=7 ) WHERE rownum <= :6
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
2bnuvr2y93awrSELECT T.CLS_URI, T.ATTR_NAME, T.ATTR_URI, T.ATTR_DISP_NAME, T.ATTR_DATA_TYPE, T.ATTR_POS FROM OL$_ATTR_DEFS T WHERE T.CLS_URI = :B2 AND T.ATTR_NAME = :B1
2w5dgfjvasy4jSELECT stat.sid, sess.status, sess.machine, sess.username, (SYSDATE-sess.logon_time)*86400 elapsed_time, stat.cpu, stat.memsorts, stat.tablescans, stat.phyreads, stat.logreads, stat.disksorts, stat.blks_changed, stat.chained_rows, stat.commits, stat.cursors, round((1-(stat.phyreads/DECODE(stat.logreads, 0, NULL, stat.logreads)))*100) buffer_cache_hitrate from (SELECT st.sid, SUM(DECODE(name, 'CPU used by this session', value, 0)) cpu, SUM(DECODE(name, 'sorts (disk)', value, 0)) disksorts, SUM(DECODE(name, 'sorts (memory)', value, 0)) memsorts, SUM(DECODE(SUBSTR(name, 0, 11), 'table scans', value, 0)) tablescans, SUM(DECODE(name, 'physical reads', value, 0)) phyreads, SUM(DECODE(name, 'session logical reads', value, 0)) logreads, SUM(DECODE(name, 'db block changes', value, 0)) blks_changed, SUM(DECODE(name, 'table fetch continued row', value, 0)) chained_rows, SUM(DECODE(name, 'user commits', value, 0)) commits, SUM(DECODE(name, 'opened cursors current', value, 0)) cursors FROM V$SESSTAT st, V$STATNAME sn WHERE st.statistic# = sn.statistic# GROUP BY st.sid) stat, v$session sess where stat.sid = sess.sid
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
35x85qdq8manhSELECT DISTINCT a.sys_user_name, a.user_name, a.org_no, a.dept_no, (SELECT NAME FROM o_dept WHERE dept_no = a.dept_no) dept_name, (SELECT org_name FROM o_org WHERE org_no = a.org_no) org_name FROM v_sp_user a, v_sp_user_operpriv b WHERE a.sys_user_name = b.sys_user_name AND a.org_no = b.org_no AND a.cur_status_code = '01' AND a.org_no = :1 AND b.auth_id = :2 ORDER BY a.dept_no, nlssort(a.user_name, 'NLS_SORT=SCHINESE_PINYIN_M')
39896zjqcvbms SELECT * FROM ( select s.equip_id ÓªÏú±äѹÆ÷ID, s.tran_name ÓªÏú±äѹÆ÷Ãû³Æ, s.distran_object_name Éú²ú±äѹÆ÷Ãû³Æ, (select org_name from sgpm.o_org where org_no = orgid And Rownum = 1) ¹©µçµ¥Î», (select (select (select name from olive.v$_st_feeder where obj_id = substr(o.s_04, 197, 64) And Rownum = 1) from olive.ol$_objects o where obj_id = x.a And Rownum = 1) from olive.ol$_associations x where b = substr(pathname, 2, 64) And Rownum = 1) ËùÊôÖ÷Ïß, (select (select olive.getpathnamebypathid(o.s_04) from olive.ol$_objects o where obj_id = x.a And Rownum = 1) from olive.ol$_associations x where b = substr(pathname, 2, 64) And Rownum = 1) Éú²ú±äѹÆ÷λÖÃ, '10kV' µçѹµÈ¼¶, ratedCapacity "¶î¶¨ÈÝÁ¿(kVA)", obj_id Éú²úID, (select name from sgpm.p_code where value = AssetsStatus and code_type = 'AssetsState' And Rownum = 1) ״̬, CCBH ³ö³§±àºÅ, (select name from sgpm.p_code where value = SBXH and code_type = 'DisTransAssetXH' And Rownum = 1) É豸ÐͺŠfrom olive.v$_ST_DisTransAsset t, mis_pms_tran_map@ypjc s where t.obj_id = s.DISTRAN_OBJECT_ID and t.assetsstatus = :1 and s.org_no like :2 || '%' and orgid = :3 ) WHERE rownum <= :4
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
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;
4860dcbah84h4update t_yxdz_czpxx t set t.zlrdm=:1, t.zlr=:2, t.zldd=:3, t.zldddm=:4, t.zlsj=to_date( :5, 'yyyy - mm - dd hh24 : mi'), t.zljsr=:6, t.zljhr=:7, t.sfzx=:8, t.zxrdm=:9, t.zxr=:10, t.zxkssj=to_date( :11, 'yyyy - mm - dd hh24 : mi'), t.zxjssj=to_date( :12, 'yyyy - mm - dd hh24 : mi'), t.jhr=:13, t.jhrdm=:14, t.zbfzr=:15, t.zbfzrdm=:16, shdd=:17, shdddm=:18, shddy=:19, shddydm=:20, shddsj=to_date( :21, 'yyyy-mm-dd hh24:mi'), shyy=:22, disabledFlag=:23, hbdd=:24, hbdddm=:25, czph=:26, hbddy=:27, hbddydm=:28, czbzs=:29, xzshr=:30, xzshrdm=:31, sfzzzx=:32, zxbz=:33, czpbh=:34, zljsrdm=:35, dlh=:36, t.flsj=to_date( :37, 'yyyy - mm - dd hh24 : mi'), flr=:38, flrdm=:39, ylr=:40, ylrdm=:41 where t.processid=:42
4bzh761vk20q0update ol$_objects set D_07 = :D_07, S_34 = :S_34, S_35 = :S_35, S_05 = :S_05, N_15 = :N_15, D_01 = :D_01, N_42 = :N_42, O_09 = :O_09, O_21 = :O_21, S_09 = :S_09, S_36 = :S_36, O_17 = :O_17, S_63 = :S_63, O_01 = :O_01, S_31 = :S_31, S_32 = :S_32, D_04 = :D_04, S_01 = :S_01, O_05 = :O_05, S_28 = :S_28, S_27 = :S_27, O_15 = :O_15, S_02 = :S_02, O_02 = :O_02, O_16 = :O_16, O_20 = :O_20, D_05 = :D_05, S_03 = :S_03, D_06 = :D_06, S_04 = :S_04, D_03 = :D_03 where obj_id = :objId
4hn182nyc6xd5INSERT INTO T_YPJC_DISTLINESEGMENT (id, loss_id, from_dist_pole_position_id, to_dist_pole_position_id, dist_line_segment_id, distlinesegmentname, linename, location, wirelength, wire_type_code, wire_type_name, unitresistance, unitreactance) VALUES (sys_guid(), :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
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
525r285cr9aa7 select T128047.KGLX as c4, T121580.BDSMC as c5, T114421.KGMC as c6, T133554.DD as c7, T128047.MIN_VALUE as c9, T128047.AVG_VALUE as c10, T128047.MAX_VALUE as c11, T121580.XJDM as c12, T121580.DSJDM as c13 from D_RQ_BY T133554, D_SCADA_SWITCH T114421, D_SB_DW$BDZ$ZB T121580, F_SCADA_BDZ_VALUE T128047 where ( T114421.KGDM = T128047.KGDM and T121580.BDSDM = T128047.BDZDM and T128047.DATAID = T133554.HID and T121580.DSJMC = 'ºªµ¦¹©µç¹«Ë¾' and T121580.XJMC = '·ÊÏçÏØ¹©µç¹«Ë¾' and T128047.KGLX = 'Ïß·¿ª¹Ø' and (T121580.DSJDM in ('1340220') or T121580.XJDM in (substr('1340220' , 1 , 7), '1340220')) and T128047.DWDM in ('1340220') )
572fbaj0fdw2bselect output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
57dshrk20f9nkselect t.plan_item_id, t.plan_year, t.PLAN_CD, t.month_plan_cd, t.plan_type, t.voltage_class_cd, t.voltage_class, t.work_site_id, t.work_site, t.stop_asset_id, t.stop_asset, t.item_State_Cd, t.stop_power_switch_id, t.stop_power_switch, t.org_no, t.org_name, t.dept_no, t.dept_name, t.item_state, to_char(t.stop_begin_date, 'yyyy-mm-dd hh24:mi:ss') strStopBeginDate, to_char(t.stop_end_date, 'yyyy-mm-dd hh24:mi:ss') strStopEndDate from t_plan_week_plan_items t where 1=1 and t.item_state in ('ÒÑ·¢²¼', 'ÒÑÍê³É') and t.org_no like GETORGNO(:1) and t.plan_year = :2 and t.plan_cd in (select a.week_plan_id from V_TICKET_QUERY a, V_POWERCUT_QUERY b where a.week_plan_id=b.WEEK_PLAN_CD )
598k07tzg7tudSelect Ass.Obj_Id, ass.CLS_URI, Ass.Name, Ass.Ratedcapacity, (Select Name From Sgpm.p_Code Where Code_Type = 'DisTransAssetXH' And Value = Ass.Sbxh) Sbxh, pc.Pathname Pathid, Olive.Getpathnamebypathid(pc.Pathname) Pathname, Ass.Assetsstatus, Ass.Orgid, Ass.CODE From olive.v$_st_powersystemresource pp, Olive.V$_St_Distransformer Pc, Olive.V$_St_Distransasset Ass, Olive.Ol$_Associations a Where Pc.Pathname Like pp.PATHNAME||'%' And pp.OBJ_ID = :1 And Ass.Pathname Like '\' || a.b || '%' And Pc.Obj_Id = a.a And Ass.Assetsstatus In (:2, :3) And Ass.Orgid = Pc.Orgid And Pc.Orgid = :4 and pc.RESOURCESTATUS = 'E'
5b547zkdp3mq6begin ol$_core_expand.MADEEQUIMODIFYDETAIL(:1, :2, :3); end;
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
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
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 ))
5yp7648cjj2s1SELECT t.sys_user_name, t.user_name, t.org_no, t.dept_no, (SELECT name FROM o_dept WHERE dept_no=t.dept_no) dept_name, (SELECT org_name FROM o_org WHERE org_no=t.org_no) org_name FROM v_sp_user t WHERE t.sys_user_name = UPPER(:1)
646v5z184310mselect t.s_01 from olive.ol$_objects t where t.obj_id= :1
6fn21cpfwmbmwINSERT INTO T_EQUIMODIFY_DETAIL WITH TEMP_ASSET_S AS (SELECT AA.OBJ_ID FROM OLIVE.V$_ST_ASSET AA WHERE AA.ORGID = :B1 AND AA.OBJ_ID IN (SELECT T.B FROM OLIVE.V$_ST_POWERSYSTEMRESOURCE P, OLIVE.OL$_OBJECTS_TEMP_TAB P1, OLIVE.OL$_ASSOCIATIONS T WHERE T.A = P.OBJ_ID AND P.PATHNAME LIKE P1.S_04 || '%' AND P.ORGID = :B1 )), TEMP_ASSET_R AS (SELECT AA.OBJ_ID FROM OLIVE.V$_ST_ASSET AA WHERE AA.ORGID = :B1 AND AA.OBJ_ID IN (SELECT T.B FROM OLIVE.V$_ST_POWERSYSTEMRESOURCE P, OLIVE.OL$_OBJECTS_TEMP_TAB P1, OLIVE.OL$_ASSOCIATIONS_RETIRE T WHERE T.A = P.OBJ_ID AND P.PATHNAME LIKE P1.S_04 || '%' AND P.ORGID = :B1 )), TEMP_ASSET_FIRSTALL AS (SELECT OBJ_ID FROM TEMP_ASSET_S UNION ALL SELECT OBJ_ID FROM TEMP_ASSET_R) SELECT :B3 , X.OBJ_ID, X.CLS_URI, X.NAME, X.VOLTAGELEVEL, X.INSERVICEDATE, X.CREATORID, X.CREATEDATE, X.LASTUPDATEID, X.LASTUPDATEDATE, X.ASSETSSTATUS, '', X.ORGID, DECODE(X.LASTUPDATEDATE, X.CREATEDATE, 'A', DECODE(X.ASSETSSTATUS, 'R', 'D', 'U')) OPERATOR_TYPE FROM OLIVE.V$_ST_ASSET X WHERE X.OBJ_ID IN (SELECT OBJ_ID FROM TEMP_ASSET_FIRSTALL) AND TO_CHAR(X.LASTUPDATEDATE, 'YYYY-MM-DD') = TO_CHAR(SYSDATE, 'YYYY-MM-DD') AND X.LASTUPDATEID = :B2 AND X.ORGID = :B1
6pcrpqf5dkunfselect /*+ index(o PK_OL$_OBJECTS) */ * from v$_DYPolePosition o where obj_id=:1
6t8pyz0wcrk16update ol$_objects set D_03 = :D_03, S_04 = :S_04, O_16 = :O_16, N_42 = :N_42, S_03 = :S_03, O_05 = :O_05, D_01 = :D_01, S_28 = :S_28, O_17 = :O_17, S_36 = :S_36, S_31 = :S_31, O_01 = :O_01, D_04 = :D_04, S_01 = :S_01, S_34 = :S_34, N_15 = :N_15, O_15 = :O_15, O_20 = :O_20, O_21 = :O_21, S_63 = :S_63, S_35 = :S_35, S_09 = :S_09, S_02 = :S_02, S_05 = :S_05, D_07 = :D_07, D_06 = :D_06, S_27 = :S_27, O_09 = :O_09, S_32 = :S_32, D_05 = :D_05 where obj_id = :objId
7kg4x6mdk9rf0BEGIN :1 :=OWF_MGR.PKG_INDY_ORWF_API.SENDFLOW(:2, :3);END;
7rph7uc1mq73k INSERT INTO T_EQUIMODIFY_DETAIL WITH TEMP_ASSET_S AS (SELECT AA.OBJ_ID FROM OLIVE.V$_ST_ASSET AA WHERE AA.ORGID = :B1 AND AA.OBJ_ID IN (SELECT T.B FROM OLIVE.V$_ST_POWERSYSTEMRESOURCE P, OLIVE.OL$_OBJECTS_TEMP_TAB P1, OLIVE.OL$_ASSOCIATIONS T WHERE T.A = P.OBJ_ID AND P.PATHNAME LIKE P1.S_04 || '%' AND P.ORGID = :B1 )), TEMP_ASSET_R AS (SELECT AA.OBJ_ID FROM OLIVE.V$_ST_ASSET AA WHERE AA.ORGID = :B1 AND AA.OBJ_ID IN (SELECT T.B FROM OLIVE.V$_ST_POWERSYSTEMRESOURCE P, OLIVE.OL$_OBJECTS_TEMP_TAB P1, OLIVE.OL$_ASSOCIATIONS_RETIRE T WHERE T.A = P.OBJ_ID AND P.PATHNAME LIKE P1.S_04 || '%' AND P.ORGID = :B1 )), TEMP_ASSET_FIRSTALL AS (SELECT OBJ_ID FROM TEMP_ASSET_S UNION ALL SELECT OBJ_ID FROM TEMP_ASSET_R), TEMP_ASSET_SUB_R AS (SELECT A.B OBJ_ID FROM OL$_ASSOCIATIONS_RETIRE A, TEMP_ASSET_FIRSTALL F WHERE A.A = F.OBJ_ID), TEMP_ASSET_SUB_S AS (SELECT A.B OBJ_ID FROM OL$_ASSOCIATIONS A, TEMP_ASSET_S S WHERE A.A = S.OBJ_ID) SELECT :B3 , AAA.OBJ_ID, AAA.CLS_URI, AAA.NAME, AAA.VOLTAGELEVEL, AAA.INSERVICEDATE, AAA.CREATORID, AAA.CREATEDATE, AAA.LASTUPDATEID, AAA.LASTUPDATEDATE, AAA.ASSETSSTATUS, '', AAA.ORGID, 'D' FROM OLIVE.V$_ST_ASSET AAA WHERE AAA.OBJ_ID IN (SELECT OBJ_ID FROM TEMP_ASSET_SUB_R UNION ALL SELECT OBJ_ID FROM TEMP_ASSET_SUB_S) AND AAA.ASSETSSTATUS = 'R' AND AAA.LASTUPDATEID = :B2 AND TO_CHAR(AAA.LASTUPDATEDATE, 'YYYY-MM-DD') = TO_CHAR(SYSDATE, 'YYYY-MM-DD')
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
8b9zc43w360qtSELECT O_28 partitionField FROM ol$_objects t WHERE t.obj_id=:1
8d150bzkm38pmSELECT 1 FROM indy_user_action t WHERE t.user_name = :1 AND t.user_bureau_name = :2 AND t.action_name = :3
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
93dtuy0vt2k7qSELECT task_id FROM p_task WHERE set_emp_no = :1 AND content LIKE '%methodName=notifyDeskMessage%'
964zgsudcdac7SELECT D.ATTR_URI FROM OL$_ATTR_DEFS D WHERE D.CLS_URI = :B2 AND D.ATTR_NAME = :B1
9g4jrwq86jnb7BEGIN OL$_RULE_CORE.CHECKANDUPDATELOWERNAME(:1); END;
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
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
ac4pb7ypdb95aselect count(l.log_machine_ip) from indy_online_user l, indy_user u where l.log_link_id !=:1 and l.log_web_path=:2 and l.log_user_id = u.user_id and u.user_name = :3
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
bm62pp5bq23r5SELECT a.app_no, a.taskid, b.locker, b.cur_state FROM wf_amber.indysp_task_user_cur a, wf_amber.indywf_worklist_cur b WHERE a.app_no = b.item_key AND a.taskid = b.taskid AND a.process_org_no = b.dept_name AND a.app_no = :1 AND a.taskid = :2 AND a.user_no = :3 AND a.user_dept_no = :4 AND a.user_org_no = :5
btd9xht9j1ah9insert into PMS.t_plan_workflow( ITEM_KEY , AUDITOR_ID , AUDITOR , AUDIT_DATE , ACTION_NAME , ACTION_TITLE , NEXT_ACTION_NAME , NEXT_ACTION_TITLE , TASK_ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9)
bvuadm73ru53aINSERT INTO T_YPJC_LINELOSE (id, org_no, org_name, line_id, line_name, voltage_level_code, voltage_level_name, count_date, active_power, reactive_power, active_load, reactive_load, actual_line_lose, actual_line_lose_rate, academic_line_lose, academic_line_lose_rate, line_active_load, line_reactive_load, line_active_power, line_reactive_power, algorithm, calcalgo, calcresult) VALUES (:1, :2, :3, :4, :5, :6, :7, to_date(:8, 'yyyy-mm'), :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23)
byuacw6h7dqknINSERT INTO T_YPJC_DISTTRANSFORMER (id, loss_id, dist_trans_id, dist_trans_res_id, disttransformername, location, measuremode, pub_priv_flag, ratedcapacity, noloadcurrent, impedancevoltage, ratedshortcircuitloss, noloadloss, suppactivequantity, suppactivequantityafter, suppreactivequantity, suppreactivequantityafter) VALUES (sys_guid(), :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16)
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)
c7udywnqw95vhselect value, name from sgpm.p_code t where t.code_type = :1
cfrwbnuu2xtamselect side_b from ol$_association_constraints where association_type = :1 and side_a = :2
cq9hj0h4ju789select b.name deptName, a.USER_TITLE userName, t_yxdz_czpxx_count(user_name, '', 'czrws', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') czrws, t_yxdz_czpxx_count(user_name, '', 'czps', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') czps, t_yxdz_czpxx_count(user_name, '', 'czbzs', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') czbzs, t_yxdz_czpxx_count(user_name, '', 'kprws', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') kprws, t_yxdz_czpxx_count(user_name, '', 'kps', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') kps, t_yxdz_czpxx_count(user_name, '', 'kpbzs', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') kpbzs, t_yxdz_czpxx_count(user_name, '', 'shrws', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') shrws, t_yxdz_czpxx_count(user_name, '', 'shps', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') shps, t_yxdz_czpxx_count(user_name, '', 'shbzs', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') shbzs, t_yxdz_czpxx_count(user_name, '', 'jhrws', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') jhrws, t_yxdz_czpxx_count(user_name, '', 'jhps', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') jhps, t_yxdz_czpxx_count(user_name, '', 'jhbzs', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') jhbzs from amber.indy_user a, sgpm.o_dept b where b.dept_no = '0000081025' and a.USER_DEPARTMENT_NAME=b.DEPT_NO order by a.user_title desc
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 ))
czxzy970jq50gupdate ol$_objects set S_27 = :S_27, D_08 = :D_08, S_40 = :S_40, D_10 = :D_10, O_07 = :O_07, S_36 = :S_36, D_04 = :D_04, D_01 = :D_01, S_32 = :S_32, O_03 = :O_03, D_06 = :D_06, O_29 = :O_29, S_35 = :S_35, S_75 = :S_75, S_15 = :S_15, S_68 = :S_68, N_07 = :N_07, N_01 = :N_01, O_04 = :O_04, S_63 = :S_63, S_02 = :S_02, S_76 = :S_76, D_03 = :D_03, O_27 = :O_27, S_03 = :S_03, S_21 = :S_21, O_01 = :O_01, N_10 = :N_10, N_52 = :N_52, N_42 = :N_42, O_25 = :O_25, D_05 = :D_05, O_24 = :O_24, S_42 = :S_42, D_07 = :D_07, O_31 = :O_31, S_01 = :S_01, S_04 = :S_04, O_02 = :O_02, O_26 = :O_26, N_09 = :N_09, O_05 = :O_05, O_06 = :O_06, N_02 = :N_02, S_73 = :S_73, N_51 = :N_51, S_31 = :S_31, S_22 = :S_22, S_34 = :S_34, S_05 = :S_05, S_39 = :S_39 where obj_id = :objId
d3gsxy5k0u8hwselect * from v$_ST_Asset where ( orgId = :1 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :2 and ol$_associations.a = :3 )
d7qa0bq22h0p3SELECT A FROM OL$_ASSOCIATIONS WHERE B = :B1
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 )
dst5yk4vxcg04 select a.line_id, a.line_name, a.issue_unit_id, a.issue_unit, a.unit, a.unit_id, a.leader_id, a.leader, a.ticket_no, a.working_unit_id, a.working_unit, a.working_staff_id, a.working_staff, a.total_staff, a.work_site, a.pulling_switch, a.live_electrical_equipment, a.other_security_measures, to_char(a.start_date, 'yyyy-mm-dd hh24:mi') str_start_date, to_char(a.end_date, 'yyyy-mm-dd hh24:mi') str_end_date, a.start_date, a.end_date, a.issue_no, a.issuer, a.issue_date, a.receive_leader_id, a.receive_leader_name, a.receive_date, (select wmsys.wm_concat(permit_leader_id) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_leader_id, (select wmsys.wm_concat(permit_working_man) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_working_man, a.exec_working_staff_id, (select wmsys.wm_concat(to_char(permit_working_time, 'yyyy-mm-dd hh24:mi:ss')) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) SpermitWorkingTime, (select wmsys.wm_concat(permit_working_man_id) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_working_man_id, (select wmsys.wm_concat(permit_leader) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_leader, (select wmsys.wm_concat(permit_mode) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_mode, a.issuer_id, a.working_condition, a.reclose_equipment, a.exec_working _staff, a.changed_date, a.working_staff_changes, a.exec_leader_id, a.exec_leader, a.deadline, a.delay_permiter_id, a.delay_permiter, a.earth_wire_no, a.terminal_mode, a.earth_wire_total_set, a.terminal_permiter_id, a.terminal_permiter, a.terminal_leader_id, a.terminal_leader, a.terminal_report_time, a.permiter_audit_date, a.leader_audit_date, a.del_flg, a.should_earth_wire_no, a.should_earth_wire_total_set, a.filler_id, a.filler, a.delay_leader, a.former_leader, a.former_leader_id, a.changed_leader_id, a.changed_leader, a.exec_issuer_id, a.exec_issuer, a.work_team, a.action_url, a.actionname, GETORGNAMES(a.issue_unit_id) orgName, a.activity_name, a.week_plan_id from pms.V_LINE_TICKET1_QUERY a where 1=1 and del_flg = 'F' and org_no LIKE GETORGNO('1340308')
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
fkc00x536y5kw select /*+rule*/ p.OBJ_ID as id, p.NAME as psrName, OL$_OBJECT_UTIL.GETPARENTID(P.PATHNAME) as parentID, p.cls_uri as psrGroupID, c.cls_disp_name AS psrGroupName, to_number(getViewAttribute(c.cls_view, p.obj_id, 'lpsequence')) as lpsequence, '' as attemperNumber, c.cls_view as clsView, p.VOLTAGELEVEL AS VOLTAGELEVEL from v$_st_powersystemresource p, ol$_classes c, v$_st_powersystemresource power where p.cls_uri = c.cls_uri AND c.cls_uri IN ('OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_Line/ST_Feeder', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_Fuse/DropoutFuse', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_TransmisPolePosition', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_DisTransformer', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_HolePosition', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_Disconnector', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_ProtectedSwitch/ST_LoadBreakSwitch', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_Fuse', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentCont ainer/ST_Station/ST_CableBox', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_CompositeSwitch/ST_RMU', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_ProtectedSwitch/ST_Breaker', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_Station/ST_BoxStation', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_Station/ST_DisStation') and p.PATHNAME LIKE power.PATHNAME||'%' AND p.RESOURCESTATUS <> 'I' and power.OBJ_ID = :1 and power.orgId = :2 and p.orgId = :3 ORDER BY lpsequence
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;
g8kw89rqydxjmselect b.* from t_plan_week_plan_items b where 1=1 and b.item_state_cd='FILLED' and b.plan_id=:1 order by b.fill_date desc
gfaqgusc2hfr5SELECT org_no, org_name, p_org_no, org_type, sort_no FROM o_org WHERE org_no = :1
ggsus9qmhfqws SELECT COUNT(1) cnt FROM( With Temp_St_Transmispoleposition As ( Select v.OBJ_ID From Olive.V$_St_Transmispoleposition v Where v.Resourcestatus = 'E' And v.Orgid =:1 And Exists (Select 1 From Olive.Ol$_Associations Aa Where Aa.b in (Select a.b From Olive.Ol$_Associations a, Olive.V$_St_Pole p Where a.a = v.Obj_Id And a.b = p.Obj_Id And a.ast_uri='OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"') And Aa.a <> v.Obj_Id) ) Select (Select o.Org_Name From Sgpm.o_Org o Where o.Org_No = f.Orgid) "ÏØµ¥Î»", f.Obj_Id, f.Name "Ïß·Ãû³Æ", Olive.Pkg_Imp_Equi_Common.Getpathnamebypathid(f.Pathname) "Ïß··¾¶", f.Tconnectid, (Select Olive.Pkg_Imp_Equi_Common.Getpathnamebypathid(v.Pathname) From Olive.V$_St_Transmispoleposition v Where v.Obj_Id = f.Tconnectid And v.RESOURCESTATUS='E' ) "T½Ó¸Ë·¾¶" From Olive.V$_St_Feeder f Where f.Resourcestatus = 'E' And f.Tconnectname Is Not Null And Length(f.Pathname) > 260 And f.Orgid = :2 and exists (select 1 f rom Olive.V$_St_Transmispoleposition where obj_id = f.Tconnectid) And Not Exists (Select 1 From Temp_St_Transmispoleposition t Where t.Obj_Id = f.Tconnectid))
gk7v3zx64y3maINSERT INTO t_ypjc_lowlinesegment (id, loss_id, low_area_id, low_area_original_id, low_area_name, low_line_id, low_line_original_id, low_line_name, low_line_segment_id, low_line_segment_original_id, low_line_segment_name, location, wire_length, wire_type_code, wire_type_name, wire_unit_resistance, wire_unit_reactance) VALUES (sys_guid(), :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16)
gkw6wc3pm09j6SELECT USER_NAME FROM AMBER.INDY_USER_ACTION U WHERE U.ACTION_NAME=:1
grwydz59pu6mcselect text from view$ where rowid=:1
gxv1gvzu11p4a select T121580.BDSMC as c1, T128574.HH as c7, T121580.DSJXH as c8, T136748.BHL as c10, T136748.DATAID as c11, T121580.DSJDM as c12, T121580.XJDM as c13 from (select t.dd, t.did, t.hh, t.hid from d_rq_by t where t.did = to_char(sysdate, 'yyyymmdd') ) T128574, D_SB_DW$BDZ$ZB T121580, F_SCADA_FHTB_BY T136748 where ( T121580.BDSDM = T136748.BDSDM and T128574.HID = T136748.DATAID and (T121580.DSJDM in ('134011612') or T121580.XJDM in (substr('134011612' , 1 , 7), '134011612')) )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 71,094 39.45 7.59
CPU used when call started 70,625 39.19 7.54
CR blocks created 1,091 0.61 0.12
Cached Commit SCN referenced 118,586 65.81 12.67
Commit SCN cached 37 0.02 0.00
DB time 573,668 318.36 61.27
DBWR checkpoint buffers written 44,019 24.43 4.70
DBWR fusion writes 7,497 4.16 0.80
DBWR transaction table writes 746 0.41 0.08
DBWR undo block writes 6,000 3.33 0.64
DFO trees parallelized 42 0.02 0.00
PX local messages recv'd 225 0.12 0.02
PX local messages sent 225 0.12 0.02
PX remote messages recv'd 154 0.09 0.02
PX remote messages sent 209 0.12 0.02
Parallel operations not downgraded 42 0.02 0.00
RowCR - row contention 210 0.12 0.02
RowCR attempts 37,594 20.86 4.02
RowCR hits 38,497 21.36 4.11
SQL*Net roundtrips to/from client 2,781,406 1,543.53 297.06
SQL*Net roundtrips to/from dblink 80,240 44.53 8.57
active txn count during cleanout 51,065 28.34 5.45
application wait time 14 0.01 0.00
background timeouts 10,564 5.86 1.13
branch node splits 24 0.01 0.00
buffer is not pinned count 35,426,688 19,659.94 3,783.69
buffer is pinned count 85,111,101 47,232.17 9,090.15
bytes received via SQL*Net from client 146,394,573 81,241.27 15,635.43
bytes received via SQL*Net from dblink 27,780,630 15,416.78 2,967.07
bytes sent via SQL*Net to client 1,299,032,932 720,894.78 138,741.10
bytes sent via SQL*Net to dblink 9,655,567 5,358.33 1,031.25
calls to get snapshot scn: kcmgss 3,985,737 2,211.87 425.69
calls to kcmgas 134,313 74.54 14.35
calls to kcmgcs 49,741 27.60 5.31
change write time 259 0.14 0.03
cleanout - number of ktugct calls 55,681 30.90 5.95
cleanouts and rollbacks - consistent read gets 567 0.31 0.06
cleanouts only - consistent read gets 3,365 1.87 0.36
cluster key scan block gets 268,831 149.19 28.71
cluster key scans 261,665 145.21 27.95
cluster wait time 33,776 18.74 3.61
commit batch performed 354 0.20 0.04
commit batch requested 354 0.20 0.04
commit batch/immediate performed 435 0.24 0.05
commit batch/immediate requested 435 0.24 0.05
commit cleanout failures: block lost 87 0.05 0.01
commit cleanout failures: callback failure 1,411 0.78 0.15
commit cleanout failures: cannot pin 2 0.00 0.00
commit cleanouts 89,237 49.52 9.53
commit cleanouts successfully completed 87,737 48.69 9.37
commit immediate performed 81 0.04 0.01
commit immediate requested 81 0.04 0.01
commit txn count during cleanout 9,186 5.10 0.98
concurrency wait time 314 0.17 0.03
consistent changes 984,087 546.12 105.10
consistent gets 127,693,321 70,863.06 13,638.08
consistent gets - examination 47,052,368 26,111.58 5,025.35
consistent gets direct 6,406 3.55 0.68
consistent gets from cache 127,686,918 70,859.51 13,637.39
current blocks converted for CR 0 0.00 0.00
cursor authentications 3,335 1.85 0.36
data blocks consistent reads - undo records applied 1,432 0.79 0.15
db block changes 1,422,134 789.21 151.89
db block gets 3,330,886 1,848.47 355.75
db block gets direct 1,969 1.09 0.21
db block gets from cache 3,328,917 1,847.37 355.54
deferred (CURRENT) block cleanout applications 26,593 14.76 2.84
dirty buffers inspected 251 0.14 0.03
enqueue conversions 161,419 89.58 17.24
enqueue releases 110,834 61.51 11.84
enqueue requests 110,836 61.51 11.84
enqueue timeouts 1 0.00 0.00
enqueue waits 526 0.29 0.06
exchange deadlocks 5 0.00 0.00
execute count 2,274,437 1,262.19 242.92
free buffer inspected 997,402 553.51 106.53
free buffer requested 2,959,530 1,642.38 316.09
gc CPU used by this session 35,449 19.67 3.79
gc cr block build time 59 0.03 0.01
gc cr block flush time 9 0.00 0.00
gc cr block receive time 2,213 1.23 0.24
gc cr block send time 132 0.07 0.01
gc cr blocks received 40,142 22.28 4.29
gc cr blocks served 36,273 20.13 3.87
gc current block flush time 5 0.00 0.00
gc current block pin time 557 0.31 0.06
gc current block receive time 140,007 77.70 14.95
gc current block send time 2,927 1.62 0.31
gc current blocks received 1,373,714 762.34 146.72
gc current blocks served 837,313 464.66 89.43
gc local grants 386,884 214.70 41.32
gc remote grants 402,166 223.18 42.95
gcs messages sent 3,668,269 2,035.70 391.78
ges messages sent 15,488 8.60 1.65
global enqueue get time 856 0.48 0.09
global enqueue gets async 10,740 5.96 1.15
global enqueue gets sync 205,713 114.16 21.97
global enqueue releases 204,824 113.67 21.88
heap block compress 2,506 1.39 0.27
hot buffers moved to head of LRU 1,463,427 812.12 156.30
immediate (CR) block cleanout applications 3,932 2.18 0.42
immediate (CURRENT) block cleanout applications 19,851 11.02 2.12
index crx upgrade (positioned) 11,554 6.41 1.23
index fast full scans (full) 44,957 24.95 4.80
index fetch by key 21,596,995 11,985.19 2,306.63
index scans kdiixs1 3,405,165 1,889.69 363.68
leaf node 90-10 splits 49 0.03 0.01
leaf node splits 687 0.38 0.07
lob reads 241,463 134.00 25.79
lob writes 211,093 117.15 22.55
lob writes unaligned 211,002 117.09 22.54
logons cumulative 719 0.40 0.08
messages received 73,737 40.92 7.88
messages sent 73,737 40.92 7.88
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 79,223,367 43,964.79 8,461.32
opened cursors cumulative 218,002 120.98 23.28
parse count (failures) 2,354 1.31 0.25
parse count (hard) 29,969 16.63 3.20
parse count (total) 203,761 113.08 21.76
parse time cpu 1,019 0.57 0.11
parse time elapsed 5,140 2.85 0.55
physical read IO requests 302,746 168.01 32.33
physical read bytes 8,482,553,856 4,707,370.12 905,965.38
physical read total IO requests 514,431 285.48 54.94
physical read total bytes 11,948,515,328 6,630,795.98 1,276,141.76
physical read total multi block requests 110,112 61.11 11.76
physical reads 1,035,468 574.63 110.59
physical reads cache 775,985 430.63 82.88
physical reads cache prefetch 545,702 302.84 58.28
physical reads direct 259,483 144.00 27.71
physical reads direct (lob) 6,234 3.46 0.67
physical reads direct temporary tablespace 253,080 140.45 27.03
physical reads prefetch warmup 159,157 88.32 17.00
physical write IO requests 41,824 23.21 4.47
physical write bytes 607,690,752 337,236.32 64,903.42
physical write total IO requests 66,513 36.91 7.10
physical write total bytes 873,627,648 484,817.28 93,306.38
physical write total multi block requests 26,235 14.56 2.80
physical writes 74,181 41.17 7.92
physical writes direct 21,140 11.73 2.26
physical writes direct (lob) 1,710 0.95 0.18
physical writes direct temporary tablespace 19,420 10.78 2.07
physical writes from cache 53,041 29.43 5.66
physical writes non checkpoint 63,572 35.28 6.79
pinned buffers inspected 36 0.02 0.00
pinned cursors current 170 0.09 0.02
prefetch clients - default 3 0.00 0.00
prefetch warmup blocks aged out before use 120,876 67.08 12.91
prefetched blocks aged out before use 18 0.01 0.00
process last non-idle time 1,592 0.88 0.17
queries parallelized 42 0.02 0.00
recursive calls 3,038,724 1,686.33 324.55
recursive cpu usage 20,046 11.12 2.14
redo blocks written 219,432 121.77 23.44
redo entries 280,319 155.56 29.94
redo ordering marks 5,079 2.82 0.54
redo size 105,876,944 58,756.12 11,308.01
redo subscn max counts 4,662 2.59 0.50
redo synch time 1,311 0.73 0.14
redo synch writes 9,259 5.14 0.99
redo wastage 3,000,208 1,664.96 320.43
redo write broadcast ack time 183 0.10 0.02
redo write time 757 0.42 0.08
redo writes 10,984 6.10 1.17
rollback changes - undo records applied 251 0.14 0.03
rollbacks only - consistent read gets 175 0.10 0.02
rows fetched via callback 7,108,324 3,944.75 759.19
session connect time 2 0.00 0.00
session cursor cache hits 104,300 57.88 11.14
session logical reads 131,024,204 72,711.52 13,993.83
shared hash latch upgrades - no wait 312,885 173.63 33.42
shared hash latch upgrades - wait 1,154 0.64 0.12
sorts (disk) 1 0.00 0.00
sorts (memory) 113,584 63.03 12.13
sorts (rows) 14,117,343 7,834.38 1,507.78
sql area evicted 0 0.00 0.00
sql area purged 2,357 1.31 0.25
summed dirty queue length 235 0.13 0.03
switch current to new buffer 5,313 2.95 0.57
table fetch by rowid 42,015,115 23,316.17 4,487.36
table fetch continued row 183,764 101.98 19.63
table scan blocks gotten 28,845,308 16,007.62 3,080.78
table scan rows gotten 486,079,986 269,748.76 51,914.98
table scans (long tables) 3 0.00 0.00
table scans (short tables) 159,515 88.52 17.04
total number of times SMON posted 37 0.02 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 435 0.24 0.05
undo change vector size 34,034,900 18,887.57 3,635.04
user I/O wait time 106,727 59.23 11.40
user calls 2,911,753 1,615.87 310.99
user commits 8,988 4.99 0.96
user rollbacks 375 0.21 0.04
workarea executions - onepass 4 0.00 0.00
workarea executions - optimal 96,247 53.41 10.28

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 2,090,133,008 3,173,925,920
session cursor cache count 17,958 24,415
session uga memory 26,306,038,688 26,468,578,680
opened cursors current 7,108 9,455
logons current 1,131 1,445
session uga memory max 1,249,856,200 2,228,426,792
session pga memory 1,453,736,272 1,816,554,208

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)
IDX_OL 86,394 48 5.49 1.61 5,380 3 115 2.43
DATA_OL 82,845 46 4.89 2.46 4,159 2 775 1.54
TEMP 39,603 22 7.25 6.40 1,173 1 0 0.00
DATA_WF 33,849 19 3.87 2.88 4,490 2 28,979 0.81
DATA_BI 28,725 16 2.34 7.29 13 0 54 3.15
IDX_WF 6,951 4 5.37 1.60 7,263 4 2,265 1.63
IDX_P 5,013 3 5.54 2.04 5,570 3 51 4.90
DATA_P 7,976 4 3.52 11.74 1,045 1 20 3.00
IDX_SCA7 1,127 1 6.30 1.53 3,467 2 0 0.00
IDX_SG 1,388 1 5.49 1.40 2,439 1 2 0.00
IDX_BI 3,021 2 2.50 2.27 86 0 0 0.00
DATA_SG 392 0 5.79 1.57 1,644 1 7 0.00
SYSTEM 1,860 1 4.29 1.00 148 0 5 6.00
UNDOTBS2 0 0 0.00 0.00 1,873 1 3 3.33
DATA_YP 320 0 3.97 1.15 1,518 1 0 0.00
SYSAUX 1,412 1 3.53 1.07 417 0 0 0.00
DATA_BI12 1,437 1 1.11 1.29 4 0 0 0.00
DATA_SCA8 190 0 9.16 1.02 8 0 0 0.00
IDX_SCA 46 0 5.22 1.89 103 0 0 0.00
LOB_SCA 0 0 0.00 0.00 122 0 0 0.00
DATA_SCA1 92 0 6.63 1.05 12 0 0 0.00
IDX_SCA3 30 0 9.33 1.10 55 0 0 0.00
IDX_SCA5 11 0 3.64 1.91 71 0 0 0.00
IDX_SCA6 32 0 9.06 1.50 40 0 0 0.00
IDX_SCA4 20 0 8.00 1.10 48 0 0 0.00
DATA_SCA7 38 0 5.79 1.11 10 0 0 0.00
DATA_SCA19 3 0 23.33 5.67 20 0 0 0.00
IDX_BI1 23 0 6.96 1.70 0 0 0 0.00
DATA_SCA11 1 0 10.00 12.00 19 0 0 0.00
DATA_SCA9 1 0 10.00 9.00 19 0 0 0.00
DATA_SCA22 1 0 0.00 1.00 18 0 0 0.00
DATA_SCA12 2 0 5.00 6.50 15 0 0 0.00
DATA_SCA15 1 0 10.00 1.00 16 0 0 0.00
DATA_SCA16 3 0 6.67 5.67 14 0 0 0.00
DATA_SCA21 2 0 5.00 3.00 14 0 0 0.00
DATA_SCA23 0 0 0.00 0.00 16 0 0 0.00
DATA_SCA14 1 0 0.00 1.00 14 0 0 0.00
DATA_SCA13 1 0 10.00 9.00 13 0 0 0.00
DATA_SCA17 1 0 10.00 1.00 13 0 0 0.00
DATA_SCA18 1 0 0.00 4.00 13 0 0 0.00
DATA_SCA3 2 0 5.00 1.00 12 0 0 0.00
IDX_SCA2 13 0 10.00 1.00 1 0 0 0.00
DATA_SCA20 1 0 10.00 9.00 12 0 0 0.00
USERS 6 0 6.67 1.00 7 0 0 0.00
DATA_SCA10 1 0 0.00 9.00 11 0 0 0.00
DATA_SCA24 0 0 0.00 0.00 12 0 0 0.00
DATA_SCA6 1 0 0.00 1.00 11 0 0 0.00
DATA_SCA2 4 0 5.00 2.00 7 0 0 0.00
DATA_SCA4 4 0 2.50 1.00 6 0 0 0.00
DATA_SCA5 0 0 0.00 0.00 6 0 0 0.00
IDX_YP 1 0 10.00 1.00 4 0 0 0.00
IDX_SCA1 0 0 0.00 0.00 3 0 0 0.00
DATA_BI7 0 0 0.00 0.00 2 0 0 0.00
DATA_BI9 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 992 1 2.20 6.44 0 0 5 2.00
DATA_BI /dev/rndmis_4g_025 1,435 1 1.93 5.94 0 0 7 4.29
DATA_BI /dev/rndmis_4g_030 1,129 1 1.97 5.75 0 0 11 3.64
DATA_BI /dev/rndmis_4g_037 883 0 2.16 6.21 0 0 7 2.86
DATA_BI /dev/rndmis_4g_038 596 0 2.82 8.25 0 0 13 3.85
DATA_BI /dev/rndmis_4g_043 562 0 2.54 8.49 0 0 6 1.67
DATA_BI /dev/rndmis_4g_044 568 0 2.55 8.55 0 0 0 0.00
DATA_BI /dev/rndmis_4g_046 601 0 2.81 8.50 0 0 0 0.00
DATA_BI /dev/rndmis_4g_048 686 0 2.64 7.24 0 0 0 0.00
DATA_BI /dev/rndmis_4g_049 652 0 2.65 7.85 0 0 0 0.00
DATA_BI /dev/rndmis_4g_050 715 0 2.43 7.77 0 0 0 0.00
DATA_BI /dev/rndmis_4g_053 762 0 2.53 7.75 0 0 0 0.00
DATA_BI /dev/rndmis_4g_057 742 0 2.35 8.14 0 0 0 0.00
DATA_BI /dev/rndmis_4g_060 708 0 2.19 7.68 0 0 0 0.00
DATA_BI /dev/rndmis_4g_061 741 0 2.56 7.43 0 0 5 2.00
DATA_BI /dev/rndmis_4g_067 661 0 2.81 8.08 0 0 0 0.00
DATA_BI /dev/rndmis_4g_068 674 0 2.24 7.56 0 0 0 0.00
DATA_BI /dev/rndmis_4g_081 762 0 2.39 7.83 0 0 0 0.00
DATA_BI /dev/rndmis_4g_101 705 0 2.61 7.47 0 0 0 0.00
DATA_BI /dev/rndmis_4g_102 708 0 2.06 7.80 0 0 0 0.00
DATA_BI /dev/rndmis_4g_106 777 0 2.24 7.69 0 0 0 0.00
DATA_BI /dev/rndmis_4g_113 736 0 2.61 7.78 0 0 0 0.00
DATA_BI /dev/rndmis_4g_114 747 0 2.10 7.77 0 0 0 0.00
DATA_BI /dev/rndmis_4g_115 733 0 2.33 7.56 0 0 0 0.00
DATA_BI /dev/rndmis_4g_116 733 0 2.69 7.72 4 0 0 0.00
DATA_BI /dev/rndmis_4g_127 692 0 2.75 6.93 0 0 0 0.00
DATA_BI /dev/rndmis_4g_133 656 0 2.74 8.06 0 0 0 0.00
DATA_BI /dev/rndmis_4g_134 1,045 1 2.14 6.03 0 0 0 0.00
DATA_BI /dev/rndmis_4g_135 1,021 1 2.02 6.23 0 0 0 0.00
DATA_BI /dev/rndmis_4g_146 998 1 2.21 6.17 0 0 0 0.00
DATA_BI /dev/rndmis_4g_152 639 0 2.49 6.89 2 0 0 0.00
DATA_BI /dev/rndmis_4g_155 518 0 2.64 8.31 0 0 0 0.00
DATA_BI /dev/rndmis_4g_156 498 0 3.11 8.09 0 0 0 0.00
DATA_BI /dev/rndmis_4g_160 615 0 3.04 9.51 0 0 0 0.00
DATA_BI /dev/rndmis_4g_163 652 0 2.16 9.66 1 0 0 0.00
DATA_BI /dev/rndmis_4g_164 1,070 1 1.50 6.50 0 0 0 0.00
DATA_BI /dev/rndmis_4g_167 1,313 1 1.85 5.92 6 0 0 0.00
DATA_BI12 /dev/rndmis_8g_023 1,437 1 1.11 1.29 4 0 0 0.00
DATA_BI7 /dev/rndmis_8g_018 0 0     2 0 0 0.00
DATA_BI9 /dev/rndmis_8g_020 0 0     1 0 0 0.00
DATA_OL /dev/rndmis_4g_015 4,533 3 5.05 2.10 82 0 96 1.67
DATA_OL /dev/rndmis_4g_016 3,578 2 4.75 2.26 107 0 90 1.89
DATA_OL /dev/rndmis_4g_017 3,854 2 4.74 2.11 80 0 134 1.12
DATA_OL /dev/rndmis_4g_018 3,379 2 4.53 2.07 81 0 0 0.00
DATA_OL /dev/rndmis_4g_019 3,632 2 4.65 2.15 81 0 0 0.00
DATA_OL /dev/rndmis_4g_020 3,333 2 4.62 2.05 108 0 0 0.00
DATA_OL /dev/rndmis_4g_021 3,811 2 5.00 2.05 103 0 0 0.00
DATA_OL /dev/rndmis_4g_022 3,645 2 4.86 2.06 70 0 0 0.00
DATA_OL /dev/rndmis_4g_023 4,489 2 4.88 2.08 98 0 9 2.22
DATA_OL /dev/rndmis_4g_024 4,311 2 4.68 2.15 118 0 80 2.13
DATA_OL /dev/rndmis_4g_026 2,465 1 4.99 1.82 65 0 0 0.00
DATA_OL /dev/rndmis_4g_028 2,130 1 5.07 2.31 92 0 106 1.23
DATA_OL /dev/rndmis_4g_034 2,183 1 4.55 2.78 54 0 0 0.00
DATA_OL /dev/rndmis_4g_035 2,454 1 5.03 2.87 86 0 0 0.00
DATA_OL /dev/rndmis_4g_040 3,136 2 4.83 3.06 127 0 120 1.33
DATA_OL /dev/rndmis_4g_041 3,072 2 5.00 3.11 137 0 0 0.00
DATA_OL /dev/rndmis_4g_058 3,659 2 4.83 2.80 113 0 0 0.00
DATA_OL /dev/rndmis_4g_059 3,323 2 4.76 2.71 157 0 29 2.41
DATA_OL /dev/rndmis_4g_071 2,596 1 4.82 3.05 186 0 111 1.44
DATA_OL /dev/rndmis_4g_072 2,422 1 5.24 3.31 155 0 0 0.00
DATA_OL /dev/rndmis_4g_075 2,449 1 4.65 2.85 174 0 0 0.00
DATA_OL /dev/rndmis_4g_079 1,461 1 5.52 2.44 153 0 0 0.00
DATA_OL /dev/rndmis_4g_080 1,510 1 5.28 2.42 114 0 0 0.00
DATA_OL /dev/rndmis_4g_083 1,156 1 4.97 2.57 150 0 0 0.00
DATA_OL /dev/rndmis_4g_084 1,316 1 4.26 2.41 67 0 0 0.00
DATA_OL /dev/rndmis_4g_085 1,263 1 5.04 2.29 70 0 0 0.00
DATA_OL /dev/rndmis_4g_086 1,238 1 4.73 2.57 67 0 0 0.00
DATA_OL /dev/rndmis_4g_087 1,071 1 5.56 2.87 180 0 0 0.00
DATA_OL /dev/rndmis_4g_088 1,343 1 4.99 2.53 110 0 0 0.00
DATA_OL /dev/rndmis_4g_092 1,196 1 6.51 3.10 112 0 0 0.00
DATA_OL /dev/rndmis_4g_210 147 0 5.24 3.33 39 0 0 0.00
DATA_OL /dev/rndmis_4g_211 232 0 7.89 1.78 219 0 0 0.00
DATA_OL /dev/rndmis_4g_212 86 0 7.09 2.44 17 0 0 0.00
DATA_OL /dev/rndmis_4g_213 218 0 5.09 2.38 386 0 0 0.00
DATA_OL /dev/rndmis_8g_043 1,053 1 4.88 3.47 120 0 0 0.00
DATA_OL /dev/rndmis_8g_044 1,101 1 4.64 3.45 81 0 0 0.00
DATA_P /dev/rndmis_4g_004 400 0 4.83 8.67 72 0 0 0.00
DATA_P /dev/rndmis_4g_027 243 0 4.90 13.03 41 0 0 0.00
DATA_P /dev/rndmis_4g_031 314 0 4.68 7.68 28 0 0 0.00
DATA_P /dev/rndmis_4g_032 253 0 4.03 11.62 51 0 0 0.00
DATA_P /dev/rndmis_4g_033 203 0 5.27 10.01 39 0 0 0.00
DATA_P /dev/rndmis_4g_064 65 0 4.15 12.45 1 0 0 0.00
DATA_P /dev/rndmis_4g_065 204 0 2.06 14.54 0 0 0 0.00
DATA_P /dev/rndmis_4g_074 260 0 2.92 15.69 9 0 0 0.00
DATA_P /dev/rndmis_4g_099 471 0 3.04 15.69 5 0 2 0.00
DATA_P /dev/rndmis_4g_104 721 0 2.36 15.75 8 0 0 0.00
DATA_P /dev/rndmis_4g_109 486 0 1.81 15.30 1 0 0 0.00
DATA_P /dev/rndmis_4g_121 299 0 2.21 13.40 3 0 0 0.00
DATA_P /dev/rndmis_4g_122 197 0 1.42 15.56 1 0 0 0.00
DATA_P /dev/rndmis_4g_123 205 0 2.15 14.99 2 0 0 0.00
DATA_P /dev/rndmis_4g_124 138 0 2.17 14.86 0 0 0 0.00
DATA_P /dev/rndmis_4g_125 71 0 2.39 14.51 1 0 0 0.00
DATA_P /dev/rndmis_4g_126 74 0 3.24 15.53 0 0 0 0.00
DATA_P /dev/rndmis_4g_128 64 0 2.97 15.94 0 0 0 0.00
DATA_P /dev/rndmis_4g_129 64 0 1.09 15.94 0 0 0 0.00
DATA_P /dev/rndmis_4g_136 48 0 2.50 15.94 0 0 0 0.00
DATA_P /dev/rndmis_4g_137 32 0 1.56 15.94 1 0 0 0.00
DATA_P /dev/rndmis_4g_138 16 0 3.75 15.94 0 0 0 0.00
DATA_P /dev/rndmis_4g_139 32 0 7.50 15.94 0 0 0 0.00
DATA_P /dev/rndmis_4g_141 48 0 1.88 15.94 0 0 0 0.00
DATA_P /dev/rndmis_4g_142 69 0 4.20 14.86 2 0 0 0.00
DATA_P /dev/rndmis_4g_143 94 0 3.62 15.00 6 0 0 0.00
DATA_P /dev/rndmis_4g_144 68 0 3.97 15.06 4 0 0 0.00
DATA_P /dev/rndmis_4g_145 64 0 1.72 15.94 0 0 0 0.00
DATA_P /dev/rndmis_4g_148 255 0 2.98 11.51 43 0 0 0.00
DATA_P /dev/rndmis_4g_149 297 0 3.00 10.34 69 0 0 0.00
DATA_P /dev/rndmis_4g_150 207 0 4.49 11.24 46 0 2 0.00
DATA_P /dev/rndmis_4g_153 182 0 4.01 7.65 35 0 5 0.00
DATA_P /dev/rndmis_4g_154 158 0 6.33 8.23 63 0 2 0.00
DATA_P /dev/rndmis_4g_158 119 0 3.03 10.09 49 0 0 0.00
DATA_P /dev/rndmis_4g_159 105 0 3.52 11.23 12 0 0 0.00
DATA_P /dev/rndmis_4g_165 85 0 4.24 13.64 0 0 0 0.00
DATA_P /dev/rndmis_4g_166 95 0 3.47 11.11 32 0 0 0.00
DATA_P /dev/rndmis_4g_168 161 0 5.16 6.94 5 0 0 0.00
DATA_P /dev/rndmis_4g_169 65 0 3.69 15.71 11 0 6 10.00
DATA_P /dev/rndmis_4g_170 65 0 3.69 15.71 1 0 2 0.00
DATA_P /dev/rndmis_8g_035 685 0 5.46 1.06 62 0 0 0.00
DATA_P /dev/rndmis_8g_038 121 0 4.71 2.41 233 0 0 0.00
DATA_P /dev/rndmis_8g_061 96 0 3.13 10.99 109 0 1 0.00
DATA_P /dev/rndmis_8g_062 77 0 4.29 13.42 0 0 0 0.00
DATA_SCA1 /dev/rndmis_4g_176 92 0 6.63 1.05 12 0 0 0.00
DATA_SCA10 /dev/rndmis_4g_187 1 0 0.00 9.00 11 0 0 0.00
DATA_SCA11 /dev/rndmis_4g_188 1 0 10.00 12.00 19 0 0 0.00
DATA_SCA12 /dev/rndmis_4g_189 2 0 5.00 6.50 15 0 0 0.00
DATA_SCA13 /dev/rndmis_4g_190 1 0 10.00 9.00 13 0 0 0.00
DATA_SCA14 /dev/rndmis_4g_191 1 0 0.00 1.00 14 0 0 0.00
DATA_SCA15 /dev/rndmis_4g_192 1 0 10.00 1.00 16 0 0 0.00
DATA_SCA16 /dev/rndmis_4g_193 3 0 6.67 5.67 14 0 0 0.00
DATA_SCA17 /dev/rndmis_4g_194 1 0 10.00 1.00 13 0 0 0.00
DATA_SCA18 /dev/rndmis_4g_195 1 0 0.00 4.00 13 0 0 0.00
DATA_SCA19 /dev/rndmis_4g_196 3 0 23.33 5.67 20 0 0 0.00
DATA_SCA2 /dev/rndmis_4g_177 4 0 5.00 2.00 7 0 0 0.00
DATA_SCA20 /dev/rndmis_4g_197 1 0 10.00 9.00 12 0 0 0.00
DATA_SCA21 /dev/rndmis_4g_198 2 0 5.00 3.00 14 0 0 0.00
DATA_SCA22 /dev/rndmis_4g_199 1 0 0.00 1.00 18 0 0 0.00
DATA_SCA23 /dev/rndmis_4g_200 0 0     16 0 0 0.00
DATA_SCA24 /dev/rndmis_4g_201 0 0     12 0 0 0.00
DATA_SCA3 /dev/rndmis_4g_178 2 0 5.00 1.00 12 0 0 0.00
DATA_SCA4 /dev/rndmis_4g_179 4 0 2.50 1.00 6 0 0 0.00
DATA_SCA5 /dev/rndmis_4g_180 0 0     6 0 0 0.00
DATA_SCA6 /dev/rndmis_4g_181 1 0 0.00 1.00 11 0 0 0.00
DATA_SCA7 /dev/rndmis_4g_182 38 0 5.79 1.11 10 0 0 0.00
DATA_SCA8 /dev/rndmis_4g_183 190 0 9.16 1.02 8 0 0 0.00
DATA_SCA9 /dev/rndmis_4g_186 1 0 10.00 9.00 19 0 0 0.00
DATA_SG /dev/rndmis_4g_009 336 0 5.65 1.58 1,434 1 7 0.00
DATA_SG /dev/rndmis_8g_013 4 0 7.50 1.50 138 0 0 0.00
DATA_SG /dev/rndmis_8g_014 52 0 6.54 1.54 72 0 0 0.00
DATA_WF /dev/rndmis_4g_005 26,766 15 3.61 3.12 3,017 2 6,177 0.88
DATA_WF /dev/rndmis_4g_036 4,400 2 4.73 1.97 814 0 13,272 0.79
DATA_WF /dev/rndmis_4g_107 2,683 1 5.10 2.02 659 0 9,530 0.78
DATA_YP /dev/rndmis_4g_007 320 0 3.97 1.15 1,518 1 0 0.00
IDX_BI /dev/rndmis_4g_001 236 0 2.75 1.97 11 0 0 0.00
IDX_BI /dev/rndmis_4g_039 72 0 2.08 2.06 12 0 0 0.00
IDX_BI /dev/rndmis_4g_045 75 0 2.40 1.93 1 0 0 0.00
IDX_BI /dev/rndmis_4g_047 71 0 1.97 2.13 7 0 0 0.00
IDX_BI /dev/rndmis_4g_051 83 0 2.77 1.81 8 0 0 0.00
IDX_BI /dev/rndmis_4g_052 64 0 3.59 2.20 4 0 0 0.00
IDX_BI /dev/rndmis_4g_054 68 0 2.50 2.24 6 0 0 0.00
IDX_BI /dev/rndmis_4g_055 65 0 2.46 2.23 0 0 0 0.00
IDX_BI /dev/rndmis_4g_056 59 0 3.56 2.39 1 0 0 0.00
IDX_BI /dev/rndmis_4g_062 60 0 3.33 2.55 0 0 0 0.00
IDX_BI /dev/rndmis_4g_063 64 0 3.59 2.31 2 0 0 0.00
IDX_BI /dev/rndmis_4g_066 5 0 8.00 1.00 2 0 0 0.00
IDX_BI /dev/rndmis_4g_073 13 0 5.38 1.15 2 0 0 0.00
IDX_BI /dev/rndmis_4g_082 13 0 4.62 1.77 0 0 0 0.00
IDX_BI /dev/rndmis_4g_100 47 0 3.19 2.89 1 0 0 0.00
IDX_BI /dev/rndmis_4g_103 71 0 2.82 2.24 3 0 0 0.00
IDX_BI /dev/rndmis_4g_105 70 0 2.86 2.56 2 0 0 0.00
IDX_BI /dev/rndmis_4g_117 92 0 2.28 2.41 0 0 0 0.00
IDX_BI /dev/rndmis_4g_118 94 0 1.28 2.21 3 0 0 0.00
IDX_BI /dev/rndmis_4g_119 145 0 2.41 2.17 1 0 0 0.00
IDX_BI /dev/rndmis_4g_120 170 0 2.41 2.36 0 0 0 0.00
IDX_BI /dev/rndmis_4g_132 159 0 2.14 2.39 1 0 0 0.00
IDX_BI /dev/rndmis_4g_147 101 0 2.28 2.64 1 0 0 0.00
IDX_BI /dev/rndmis_4g_151 118 0 1.69 2.39 1 0 0 0.00
IDX_BI /dev/rndmis_4g_157 113 0 2.83 2.44 0 0 0 0.00
IDX_BI /dev/rndmis_4g_161 116 0 1.90 2.29 3 0 0 0.00
IDX_BI /dev/rndmis_4g_162 126 0 1.83 2.29 1 0 0 0.00
IDX_BI /dev/rndmis_4g_171 116 0 2.50 2.31 3 0 0 0.00
IDX_BI /dev/rndmis_4g_172 128 0 2.81 2.27 2 0 0 0.00
IDX_BI /dev/rndmis_4g_174 228 0 2.19 2.37 3 0 0 0.00
IDX_BI /dev/rndmis_4g_175 179 0 2.74 2.19 5 0 0 0.00
IDX_BI1 /dev/rndmis_8g_016 23 0 6.96 1.70 0 0 0 0.00
IDX_OL /dev/rndmis_4g_011 6,675 4 4.96 1.65 56 0 30 3.33
IDX_OL /dev/rndmis_4g_012 6,787 4 4.90 1.61 70 0 37 1.35
IDX_OL /dev/rndmis_4g_013 6,681 4 4.74 1.58 63 0 6 3.33
IDX_OL /dev/rndmis_4g_014 6,592 4 4.62 1.57 125 0 22 2.27
IDX_OL /dev/rndmis_4g_029 4,442 2 5.35 1.60 237 0 11 3.64
IDX_OL /dev/rndmis_4g_069 6,651 4 5.64 1.68 123 0 0 0.00
IDX_OL /dev/rndmis_4g_070 9,208 5 5.80 1.74 129 0 0 0.00
IDX_OL /dev/rndmis_4g_076 8,452 5 5.58 1.72 84 0 0 0.00
IDX_OL /dev/rndmis_4g_077 2,037 1 5.65 1.32 333 0 2 0.00
IDX_OL /dev/rndmis_4g_078 1,885 1 5.78 1.38 275 0 0 0.00
IDX_OL /dev/rndmis_4g_089 1,996 1 6.08 1.34 363 0 0 0.00
IDX_OL /dev/rndmis_4g_090 2,404 1 6.07 1.42 286 0 0 0.00
IDX_OL /dev/rndmis_4g_091 2,162 1 5.62 1.48 278 0 1 0.00
IDX_OL /dev/rndmis_4g_093 2,807 2 5.46 1.70 245 0 0 0.00
IDX_OL /dev/rndmis_4g_094 2,618 1 5.83 1.61 328 0 0 0.00
IDX_OL /dev/rndmis_4g_095 2,420 1 5.86 1.64 224 0 0 0.00
IDX_OL /dev/rndmis_4g_096 2,841 2 6.12 1.58 165 0 6 3.33
IDX_OL /dev/rndmis_4g_097 2,224 1 6.30 1.57 377 0 0 0.00
IDX_OL /dev/rndmis_4g_098 2,231 1 6.33 1.66 357 0 0 0.00
IDX_OL /dev/rndmis_4g_108 1,125 1 5.80 1.57 316 0 0 0.00
IDX_OL /dev/rndmis_4g_110 885 0 6.18 1.44 150 0 0 0.00
IDX_OL /dev/rndmis_4g_111 1,003 1 6.17 1.55 262 0 0 0.00
IDX_OL /dev/rndmis_4g_112 911 1 6.88 1.61 176 0 0 0.00
IDX_OL /dev/rndmis_8g_024 682 0 5.51 1.59 195 0 0 0.00
IDX_OL /dev/rndmis_8g_025 675 0 6.12 1.52 163 0 0 0.00
IDX_P /dev/rndmis_4g_002 484 0 4.75 1.58 276 0 0 0.00
IDX_P /dev/rndmis_4g_130 975 1 5.87 2.02 954 1 17 1.76
IDX_P /dev/rndmis_4g_131 777 0 5.11 2.00 674 0 15 3.33
IDX_P /dev/rndmis_4g_173 1,124 1 5.25 2.12 1,303 1 8 2.50
IDX_P /dev/rndmis_4g_217 975 1 6.03 2.15 1,356 1 11 13.64
IDX_P /dev/rndmis_4g_218 678 0 5.88 2.17 1,007 1 0 0.00
IDX_SCA /dev/rndmis_4g_208 45 0 5.33 1.89 93 0 0 0.00
IDX_SCA /dev/rndmis_4g_219 1 0 0.00 2.00 10 0 0 0.00
IDX_SCA1 /dev/rndmis_4g_184 0 0     3 0 0 0.00
IDX_SCA2 /dev/rndmis_4g_185 13 0 10.00 1.00 1 0 0 0.00
IDX_SCA3 /dev/rndmis_4g_202 2 0 5.00 1.00 21 0 0 0.00
IDX_SCA3 /dev/rndmis_4g_220 28 0 9.64 1.11 34 0 0 0.00
IDX_SCA4 /dev/rndmis_4g_203 9 0 6.67 1.00 23 0 0 0.00
IDX_SCA4 /dev/rndmis_4g_221 11 0 9.09 1.18 25 0 0 0.00
IDX_SCA5 /dev/rndmis_4g_204 7 0 2.86 1.00 32 0 0 0.00
IDX_SCA5 /dev/rndmis_4g_222 4 0 5.00 3.50 39 0 0 0.00
IDX_SCA6 /dev/rndmis_4g_205 14 0 7.14 2.14 23 0 0 0.00
IDX_SCA6 /dev/rndmis_4g_223 18 0 10.56 1.00 17 0 0 0.00
IDX_SCA7 /dev/rndmis_8g_011 871 0 6.39 1.57 2,732 2 0 0.00
IDX_SCA7 /dev/rndmis_8g_034 256 0 5.98 1.39 735 0 0 0.00
IDX_SG /dev/rndmis_4g_010 1,388 1 5.49 1.40 2,439 1 2 0.00
IDX_WF /dev/rndmis_4g_006 4,923 3 5.29 1.62 4,336 2 1,302 1.63
IDX_WF /dev/rndmis_4g_042 2,028 1 5.58 1.55 2,927 2 963 1.63
IDX_YP /dev/rndmis_4g_008 1 0 10.00 1.00 4 0 0 0.00
LOB_SCA /dev/rndmis_8g_006 0 0     2 0 0 0.00
LOB_SCA /dev/rndmis_8g_026 0 0     79 0 0 0.00
LOB_SCA /dev/rndmis_8g_040 0 0     41 0 0 0.00
SYSAUX /dev/rndmis_4g_225 384 0 2.97 1.25 26 0 0 0.00
SYSAUX /dev/rsysaux_4g 1,028 1 3.74 1.00 391 0 0 0.00
SYSTEM /dev/rsystem_4g 1,860 1 4.29 1.00 148 0 5 6.00
TEMP /dev/rndmis_8g_056 45 0 0.22 1.00 111 0 0  
TEMP /dev/rtemp01_16g 64 0 0.16 1.00 69 0 0  
TEMP /dev/rtemp02_16g 39,494 22 7.27 6.41 993 1 0  
UNDOTBS2 /dev/rndmis_8g_032 0 0     250 0 1 0.00
UNDOTBS2 /dev/rndmis_8g_033 0 0     162 0 0 0.00
UNDOTBS2 /dev/rndmis_8g_037 0 0     169 0 1 0.00
UNDOTBS2 /dev/rundo_2a_16g 0 0     536 0 1 10.00
UNDOTBS2 /dev/rundo_2b_16g 0 0     756 0 0 0.00
USERS /dev/rusers_4g 6 0 6.67 1.00 7 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,733,642 99 131,031,130 776,024 53,155 0 0 32,323


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 23 10520 53645 5640120 5640120    
E 0 17 6964 39952 220159 5640120 220159  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 2,272 0.10 272,214 2.57 4,217,029
D 4,544 0.20 544,428 1.75 2,868,883
D 6,816 0.30 816,642 1.37 2,247,900
D 9,088 0.40 1,088,856 1.25 2,044,047
D 11,360 0.50 1,361,070 1.15 1,884,978
D 13,632 0.60 1,633,284 1.09 1,792,456
D 15,904 0.70 1,905,498 1.06 1,741,707
D 18,176 0.80 2,177,712 1.02 1,671,619
D 20,448 0.90 2,449,926 1.01 1,650,249
D 22,720 1.00 2,722,140 1.00 1,638,313
D 22,816 1.00 2,733,642 1.00 1,637,980
D 24,992 1.10 2,994,354 1.00 1,634,356
D 27,264 1.20 3,266,568 1.00 1,634,356
D 29,536 1.29 3,538,782 1.00 1,634,356
D 31,808 1.39 3,810,996 1.00 1,634,356
D 34,080 1.49 4,083,210 1.00 1,634,356
D 36,352 1.59 4,355,424 1.00 1,634,356
D 38,624 1.69 4,627,638 1.00 1,634,356
D 40,896 1.79 4,899,852 1.00 1,634,356
D 43,168 1.89 5,172,066 1.00 1,634,356
D 45,440 1.99 5,444,280 1.00 1,634,356

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
99.73 10,942 30

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 4,699 1,310.47 29.25 2.23 100.00 0.00 629,140
E 6,144 4,494 1,579.67 0.00 0.00 0.00 0.00 629,140

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 80,231 80,231 0 0
64K 128K 1,678 1,678 0 0
128K 256K 1,974 1,974 0 0
256K 512K 1,827 1,827 0 0
512K 1024K 9,858 9,858 0 0
1M 2M 350 350 0 0
2M 4M 323 323 0 0
4M 8M 5 1 4 0
8M 16M 14 14 0 0
16M 32M 6 6 0 0
32M 64M 2 2 0 0
64M 128M 1 1 0 0
128M 256M 2 2 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 15,195.27 3,046.46 83.00 262
1,536 0.25 15,195.27 191.12 99.00 1
3,072 0.50 15,195.27 191.12 99.00 0
4,608 0.75 15,195.27 191.12 99.00 0
6,144 1.00 15,195.27 32.98 100.00 0
7,373 1.20 15,195.27 0.00 100.00 0
8,602 1.40 15,195.27 0.00 100.00 0
9,830 1.60 15,195.27 0.00 100.00 0
11,059 1.80 15,195.27 0.00 100.00 0
12,288 2.00 15,195.27 0.00 100.00 0
18,432 3.00 15,195.27 0.00 100.00 0
24,576 4.00 15,195.27 0.00 100.00 0
36,864 6.00 15,195.27 0.00 100.00 0
49,152 8.00 15,195.27 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
2,192 0.59 434 43,910 28,431 1.00 252 1.28 1,811
2,576 0.69 788 62,802 28,486 1.00 197 1.00 1,814
2,960 0.79 836 65,937 28,486 1.00 197 1.00 1,814
3,344 0.90 836 65,937 28,486 1.00 197 1.00 1,814
3,728 1.00 836 65,937 28,486 1.00 197 1.00 1,814
4,112 1.10 836 65,937 28,486 1.00 197 1.00 1,814
4,496 1.21 836 65,937 28,486 1.00 197 1.00 1,814
4,880 1.31 836 65,937 28,486 1.00 197 1.00 1,814
5,264 1.41 836 65,937 28,486 1.00 197 1.00 1,814
5,648 1.52 836 65,937 28,486 1.00 197 1.00 1,814
6,032 1.62 836 65,937 28,486 1.00 197 1.00 1,814
6,416 1.72 836 65,937 28,486 1.00 197 1.00 1,814
6,800 1.82 836 65,937 28,486 1.00 197 1.00 1,814
7,184 1.93 836 65,937 28,486 1.00 197 1.00 1,814
7,568 2.03 836 65,937 28,486 1.00 197 1.00 1,814

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 9,283 2,868,417
13,312 0.50 6,892 1,884,964
19,968 0.75 6,320 1,671,690
26,624 1.00 6,232 1,635,544
33,280 1.25 6,232 1,635,544
39,936 1.50 6,234 1,635,544
46,592 1.75 6,234 1,635,544
53,248 2.00 6,234 1,635,544

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
16 1.00 0 0 0 0
32 2.00 0 0 0 0
48 3.00 0 0 0 0
64 4.00 0 0 0 0
80 5.00 0 0 0 0
96 6.00 0 0 0 0
112 7.00 0 0 0 0
128 8.00 0 0 0 0
144 9.00 0 0 0 0
160 10.00 0 0 0 0
176 11.00 0 0 0 0
192 12.00 0 0 0 0
208 13.00 0 0 0 0
224 14.00 0 0 0 0
240 15.00 0 0 0 0
256 16.00 0 0 0 0
272 17.00 0 0 0 0
288 18.00 0 0 0 0
304 19.00 0 0 0 0
320 20.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 32,320 29 1
undo block 3 0 3

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
WF-AWR Flush 22 22 0 11 5 419.09
TM-DML 31,517 31,517 0 166 0 0.57
TX-Transaction (row lock contention) 5 5 0 4 0 17.50
PS-PX Process Reservation 298 298 0 100 0 0.53
CF-Controlfile Transaction 4,285 4,285 0 90 0 0.56
HW-Segment High Water Mark 2,578 2,578 0 85 0 0.53
TX-Transaction (index contention) 54 54 0 35 0 0.91
FB-Format Block 77 77 0 32 0 0.47
TA-Instance Undo 8 8 0 8 0 0.38
TD-KTF map table enqueue (KTF dump entries) 4 4 0 4 0 0.50
TT-Tablespace 1,989 1,989 0 4 0 0.50
MW-MWIN Schedule 1 1 0 1 0 1.00
TO-Temp Object 209 209 0 1 0 1.00
AF-Advisor Framework (task serialization) 8 8 0 2 0 0.00
AS-Service Operations (service activation) 3 3 0 1 0 0.00
DR-Distributed Recovery 1 1 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
4 6.82 20,335 100 9 27303.7/30502 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 18:02 1,723 4,098 53 6 30,350 0/0 0/0/0/0/0/0
27-Mar 17:52 1,290 3,745 89 7 30,502 0/0 0/0/0/0/0/0
27-Mar 17:42 2,050 4,760 88 8 27,304 0/0 0/0/0/0/0/0
27-Mar 17:32 1,755 7,732 100 9 29,793 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,212 0.00   0 0  
AWR Alerted Metric Element list 57,273 0.00   0 0  
Consistent RBA 11,003 0.01 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 8,176 0.01 0.00 0 0  
JS broadcast add buf latch 411 0.00   0 0  
JS broadcast drop buf latch 411 0.00   0 0  
JS broadcast load blnc latch 360 0.00   0 0  
JS mem alloc latch 2 0.00   0 0  
JS queue access latch 2 0.00   0 0  
JS queue state obj latch 15,120 0.00   0 0  
KCL gc element parent latch 9,593,632 0.02 0.02 0 3,695 0.03
KJC message pool free list 182,204 15.48 0.01 0 116,312 0.03
KJCT flow control latch 1,745,756 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 601 0.00   0 0  
KTF sga latch 8 0.00   0 597 0.00
KWQMN job cache list latch 151 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 36 2.78
Memory Management Latch 0     0 601 0.00
OS process 1,104 0.00   0 0  
OS process allocation 1,652 0.00   0 0  
OS process: request allocation 1,012 0.00   0 0  
PL/SQL warning settings 13,789 0.00   0 0  
SGA IO buffer pool latch 23,856 0.00 0.00 0 23,856 0.00
SQL memory manager latch 1 0.00   0 599 0.00
SQL memory manager workarea list latch 170,618 0.00 0.00 0 0  
Shared B-Tree 67 0.00   0 0  
active checkpoint queue latch 47,293 0.05 0.00 0 0  
active service list 7,428 0.50 0.00 0 361,603 0.00
archive control 74 0.00   0 0  
archive process latch 671 0.00   0 0  
begin backup scn array 1,584 0.00   0 0  
business card 84 0.00   0 0  
cache buffer handles 101,649 0.00 0.00 0 0  
cache buffers chains 223,673,380 0.25 0.00 0 18,928,466 0.01
cache buffers lru chain 2,731,468 0.03 0.00 0 4,723,769 0.05
cache table scan latch 0     0 30,969 0.03
channel handle pool latch 1,056 0.00   0 0  
channel operations parent latch 485,545 0.00 0.00 0 0  
checkpoint queue latch 685,883 0.00 0.00 0 59,705 0.00
client/application info 4,829 0.00   0 0  
commit callback allocation 44 0.00   0 0  
compile environment latch 719 0.00   0 0  
dml lock allocation 63,098 0.00 0.00 0 0  
dummy allocation 1,124 1.33 0.00 0 0  
enqueue hash chains 457,811 0.00 0.00 0 638 0.00
enqueues 997,566 0.03 0.00 0 0  
error message lists 204 0.00   0 0  
event group latch 664 0.00   0 0  
file cache latch 2,472 0.00   0 0  
gcs opaque info freelist 2,348,868 0.11 0.00 0 0  
gcs partitioned table hash 31,959,571 0.00   0 5,268 0.00
gcs remaster request queue 3 0.00   0 0  
gcs remastering latch 2,107,588 0.00 0.25 0 3,646 0.03
gcs resource freelist 1,548,916 0.00 0.15 0 1,185,478 0.00
gcs resource hash 11,538,274 0.25 0.00 0 3 0.00
gcs resource scan list 6 0.00   0 0  
gcs shadows freelist 1,284,764 0.00 0.00 0 1,721,399 0.00
ges caches resource lists 139,235 0.04 0.00 0 37,057 0.08
ges deadlock list 854 0.00   0 0  
ges domain table 410,437 0.00   0 0  
ges enqueue table freelist 434,133 0.00   0 0  
ges group table 612,441 0.00 0.00 0 0  
ges process hash list 33,647 0.00   0 0  
ges process parent latch 874,794 0.00   0 0  
ges process table freelist 1,012 0.00   0 0  
ges resource hash list 688,710 0.01 0.00 0 10,727 0.00
ges resource scan list 48 0.00   0 0  
ges resource table freelist 19,739 0.00   0 0  
ges synchronous data 64 0.00   0 18,625 0.02
ges timeout list 7,722 0.00   0 4,160 0.00
global KZLD latch for mem in SGA 650 0.00   0 0  
global tx hash mapping 3,934 0.00   0 0  
hash table column usage latch 1,248 0.08 0.00 0 251,600 0.00
hash table modification latch 227 0.00   0 0  
internal temp table object number allocation latc 42 0.00   0 0  
interrupt manipulation 419 0.00   0 0  
job_queue_processes parameter latch 30 0.00   0 0  
kks stats 53,336 0.01 0.00 0 0  
kokc descriptor allocation latch 188 0.00   0 0  
ksuosstats global area 122 0.00   0 0  
ktm global data 43 0.00   0 0  
kwqbsn:qsga 66 0.00   0 0  
lgwr LWN SCN 11,031 0.04 0.00 0 0  
library cache 3,782,623 0.05 0.00 0 356 0.00
library cache load lock 2,496 0.00   0 0  
library cache lock 6,401,361 0.01 0.00 0 0  
library cache lock allocation 8,682 0.00   0 0  
library cache pin 786,984 0.03 0.00 0 0  
library cache pin allocation 30,350 0.00   0 0  
list of block allocation 3,847 0.00   0 0  
loader state object freelist 3,920 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 16 0.00   0 15 0.00
message pool operations parent latch 714 0.00   0 0  
messages 280,731 0.04 0.00 0 0  
mostly latch-free SCN 11,220 1.46 0.00 0 0  
multiblock read objects 642,196 0.04 0.00 0 0  
name-service memory objects 26,649 0.00   0 0  
name-service namespace bucket 26,633 0.00   0 0  
name-service pending queue 12,644 0.00   0 0  
name-service request 2 0.00   0 0  
name-service request queue 36,847 0.00   0 0  
ncodef allocation latch 37 0.00   0 0  
object queue header heap 249,277 0.00   0 48,330 0.00
object queue header operation 5,085,342 0.01 0.08 0 0  
object stats modification 1,006 0.00   0 0  
parallel query alloc buffer 1,160 0.00   0 0  
parallel query stats 181 0.00   0 0  
parallel txn reco latch 7,600 0.00   0 0  
parameter list 5,208 0.50 0.00 0 0  
parameter table management 1,122 0.00   0 0  
post/wait queue 21,103 0.01 0.00 0 9,423 0.00
process allocation 14,004 0.05 0.00 0 662 0.30
process group creation 1,012 0.00   0 0  
process queue 486 0.00   0 0  
process queue reference 8,563 0.00   0 819 0.00
qmn state object latch 2 0.00   0 0  
qmn task queue latch 271 0.00   0 0  
query server freelists 398 0.00   0 0  
queued dump request 8,994 0.00   0 0  
redo allocation 55,280 0.02 0.00 0 280,168 0.05
redo copy 0     0 280,218 0.13
redo writing 81,851 0.03 0.00 0 0  
resmgr group change latch 742 0.00   0 0  
resmgr:active threads 1,113 0.00   0 0  
resmgr:actses change group 709 0.00   0 0  
resmgr:free threads list 1,112 2.61 0.00 0 0  
resmgr:resource group CPU method 394 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 4,279,178 0.10 0.00 0 545 0.18
rules engine aggregate statistics 4 0.00   0 0  
rules engine rule set statistics 108 0.00   0 0  
sequence cache 21,891 0.54 0.00 0 0  
session allocation 1,751,573 0.11 0.01 0 0  
session idle bit 6,681,567 0.00 0.01 0 0  
session state list latch 1,610 3.98 0.00 0 0  
session switching 1,777 0.00   0 0  
session timer 745 0.00   0 0  
shared pool 1,546,555 0.03 0.00 0 0  
shared pool sim alloc 2,056 0.00   0 0  
shared pool simulator 78,133 0.00   0 0  
shared server configuration 1 0.00   0 1 0.00
simulator hash latch 6,951,637 0.00 0.00 0 0  
simulator lru latch 0     0 6,644,843 0.35
slave class 6 0.00   0 0  
slave class create 24 4.17 1.00 0 0  
sort extent pool 1,638 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 702 0.00   0 0  
temp lob duration state obj allocation 14 0.00   0 0  
temporary table state object allocation 22 0.00   0 0  
threshold alerts latch 832 0.00   0 0  
trace latch 35 0.00   0 0  
transaction allocation 2,461,773 0.00   0 0  
transaction branch allocation 4,201 0.00   0 0  
undo global data 181,576 0.00 0.00 0 0  
user lock 1,970 2.84 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 223,673,380 566,373 1,463 564,964 0 0 0
gcs resource hash 11,538,274 28,666 29 28,640 0 0 0
KJC message pool free list 182,204 28,197 160 28,040 0 0 0
KCL gc element parent latch 9,593,632 2,099 44 2,058 0 0 0
session allocation 1,751,573 1,971 13 1,958 0 0 0
cache buffers lru chain 2,731,468 790 1 789 0 0 0
object queue header operation 5,085,342 640 49 591 0 0 0
shared pool 1,546,555 452 2 450 0 0 0
session idle bit 6,681,567 112 1 111 0 0 0
gcs resource freelist 1,548,916 48 7 41 0 0 0
gcs remastering latch 2,107,588 4 1 3 0 0 0
slave class create 24 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 130 21
KCL gc element parent latch kclnfnd 0 13 11
KCL gc element parent latch kclple_1 0 6 0
KCL gc element parent latch KCLUNLNK 0 3 46
KCL gc element parent latch kclcontext 0 2 3
KCL gc element parent latch kclbla 0 1 1
KCL gc element parent latch kclebs 0 1 0
KCL gc element parent latch kclgcr 0 1 1
KCL gc element parent latch kclplz 0 1 37
KCL gc element parent latch kclrwrite 0 1 0
KCL gc element parent latch kclulb 0 1 16
KCL gc element parent latch kclzcl 0 1 39
KJC message pool free list kjcsmpav: allocate a msg buffer 0 160 160
active service list kswslogon: session login 0 31 31
cache buffers chains kcbgtcr: kslbegin excl 0 7,326 7,227
cache buffers chains kcbzwb 0 73 74
cache buffers chains kcbrls: kslbegin 0 64 193
cache buffers chains kcbgtcr: fast path 0 51 15
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 34 17
cache buffers chains kcbzgb: scan from tail. nowait 0 7 0
cache buffers chains kcbzib: multi-block read: nowait 0 7 0
cache buffers chains kcbzib: finish free bufs 0 5 2
cache buffers chains kclwrt 0 4 0
cache buffers chains kcbgcur: kslbegin 0 2 0
cache buffers chains kcbgtcr: kslbegin shared 0 2 2
cache buffers chains kclwcrs 0 2 2
cache buffers chains kcbget: pin buffer 0 1 0
cache buffers chains kcbgtcr 0 1 0
cache buffers chains kcbnlc 0 1 12
cache buffers chains kclgrantlk_1 0 1 0
cache buffers lru chain kcbzgws 0 1 0
gcs remastering latch 43 0 1 0
gcs resource freelist kjbralc add resource 0 5 4
gcs resource freelist kjbrralc: reserve allocation 0 2 2
gcs resource hash kjbcropen:affinity 0 15 13
gcs resource hash kjbrrcfwst 0 14 0
object queue header operation kclobj_1 0 47 30
object queue header operation kcbo_switch_mq_bg 0 5 0
object queue header operation kcbw_unlink_q 0 1 12
object queue header operation kclobj_3 0 1 1
session allocation ksufap: active sessions 0 8 0
session allocation ksuxds: not user session 0 3 1
session allocation ksucri 0 2 12
session idle bit ksupuc: set busy 0 1 0
shared pool kghalo 0 2 1
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
AMBER IDX_WF UK_USER_ACTION_BAK   INDEX 17,030,544 13.00
OLIVE IDX_OL PK_OL$_ATTR_DEFS   INDEX 14,383,008 10.98
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 13,017,024 9.93
PMS IDX_P PK_RECORD_ID   INDEX 7,824,752 5.97
PMSBI DATA_BI D_SCADA_SWITCH_N1   INDEX 6,405,936 4.89

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 76,152 7.35
PMSBI DATA_BI F_SCADA_KGBWXX   TABLE 75,252 7.27
PMS DATA_P T_EQUIPMENT_LEVEL_MAIN   TABLE 71,296 6.89
OLIVE DATA_OL OL$_ASSOCIATIONS   TABLE 55,276 5.34
AMBER DATA_WF INDY_USER_ACTION P1340600 TABLE PARTITION 27,008 2.61

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_N1   INDEX 12 19.67
OLIVE IDX_OL OL$_EVENT_LOG_D1   INDEX 11 18.03
OLIVE IDX_OL OL$_ASSOCIATIONS_N2   INDEX 10 16.39
SGPM IDX_SG PK_P_TASK_PARA   INDEX 5 8.20
AMBER IDX_P IDX_USE_LOG_USER_ID_TIME   INDEX 4 6.56

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SGPM IDX_SG PK_P_TASK_PARA   INDEX 2 50.00
PMS DATA_P EXAM_REPORT   TABLE 1 25.00
AMBER DATA_WF SP_QUERY_DEF   TABLE 1 25.00

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
WF_AMBER DATA_WF INDYWF_WORKLIST_HIS P3140100 TABLE PARTITION 14,091 94.12
OLIVE DATA_OL OL$_OBJECTS_R01 P_1340404 TABLE PARTITION 775 5.18
PMSBI DATA_BI D_SCADA_SWITCH_N1   INDEX 35 0.23
OLIVE IDX_OL OL$_ASSOCIATIONS_N1   INDEX 26 0.17
AMBER DATA_WF SP_QUERY_DEF   TABLE 13 0.09

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
SGPM DATA_SG P_TASK   TABLE 2,288 5.70
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 1,595 3.97
OLIVE IDX_OL NK_OL$_REFS_URI_A   INDEX 1,498 3.73
OLIVE DATA_OL OL$_ASSOCIATIONS   TABLE 959 2.39
OLIVE IDX_OL NK_OL$_REFS_URI_B   INDEX 902 2.25

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 62,706 4.56
OLIVE DATA_OL OL$_OBJECTS_R01 P_1340308 TABLE PARTITION 33,366 2.43
PMSBI DATA_BI F_SCADA_KGTZJL   TABLE 32,913 2.40
OLIVE DATA_OL OL$_ASSOCIATIONS   TABLE 28,594 2.08
OLIVE DATA_OL OL$_OBJECTS_R01 P_1340610 TABLE PARTITION 26,266 1.91

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 33 3.03 0   1 1
dc_database_links 82,323 0.00 0   0 5
dc_files 6,696 0.00 0   0 279
dc_global_oids 582 2.75 0   0 51
dc_histogram_data 572,940 1.60 0   0 25,708
dc_histogram_defs 212,879 2.61 0   8 15,884
dc_object_grants 226 7.08 0   0 106
dc_object_ids 380,201 0.10 0   3 2,180
dc_objects 61,328 0.71 0   6 1,807
dc_profiles 650 0.00 0   0 1
dc_rollback_segments 16,369 0.00 0   0 952
dc_segments 73,501 5.02 0   15 15,947
dc_sequences 45 37.78 0   45 13
dc_table_scns 243 0.82 0   0 5
dc_tablespace_quotas 52 30.77 0   0 26
dc_tablespaces 115,095 0.00 0   0 68
dc_usernames 3,744 0.00 0   0 27
dc_users 259,832 0.00 0   0 73
outstanding_alerts 402 97.76 0   4 7

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 3 1 0
dc_global_oids 16 0 0
dc_histogram_defs 5,540 0 0
dc_object_ids 376 0 0
dc_objects 434 0 0
dc_segments 3,712 20 0
dc_sequences 90 11 0
dc_table_scns 2 0 0
dc_tablespace_quotas 42 5 0
outstanding_alerts 799 390 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 954 1.47 70,869 0.02 0 0
CLUSTER 7 0.00 9 0.00 0 0
INDEX 1,489 1.14 39,180 0.04 0 0
SQL AREA 131,420 43.47 2,557,209 3.45 5 0
TABLE/PROCEDURE 12,757 3.25 285,118 0.41 41 0
TRIGGER 76 0.00 2,104 0.00 0 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 9 0 0 0 0
INDEX 39,180 17 0 17 0
TABLE/PROCEDURE 74,353 386 0 317 0

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 1,029.39   0.91 1.48 11 11 1,134 1,134
  Freeable 231.06 0.00 1.02 2.46 35   226 226
  PL/SQL 33.75 27.85 0.03 0.02 0 0 1,132 1,132
  SQL 24.22 5.82 0.02 0.08 3 37 1,096 1,094
E Other 1,269.52   0.88 1.37 11 11 1,448 1,448
  Freeable 242.50 0.00 0.91 0.83 14   266 266
  PL/SQL 42.87 35.92 0.03 0.01 0 0 1,446 1,446
  SQL 25.91 2.78 0.02 0.04 0 90 1,411 1,409

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared ASH buffers 68.00 68.00 0.00
shared CCursor 57.49 171.74 198.73
shared Checkpoint queue 62.52 62.52 0.00
shared PCursor 38.72 120.98 212.49
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 1,722.11 973.57 -43.47
shared gcs resources 478.62 530.03 10.74
shared gcs shadows 286.61 286.61 0.00
shared ges enqueues 62.86 63.76 1.42
shared library cache 43.61 88.72 103.44
shared sql area 253.54 612.23 141.47
shared sql area:PLSQL   47.22  
streams free memory 16.00 16.00 0.00
  buffer_cache 22,816.00 22,816.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 Coordinator 70,000 0 0
QMON Slaves 0 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

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


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 23,139 12.84 2.47
acks for commit broadcast(logical) 24,553 13.63 2.62
broadcast msgs on commit(actual) 10,949 6.08 1.17
broadcast msgs on commit(logical) 10,981 6.09 1.17
broadcast msgs on commit(wasted) 1,140 0.63 0.12
broadcast on commit wait time(ms) 1,565 0.87 0.17
broadcast on commit waits 8,653 4.80 0.92
dynamically allocated gcs resources 332,800 184.69 35.54
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 452,222 250.96 48.30
gcs ast xid 1 0.00 0.00
gcs blocked converts 22,940 12.73 2.45
gcs blocked cr converts 36,126 20.05 3.86
gcs compatible basts 963 0.53 0.10
gcs compatible cr basts (global) 4,040 2.24 0.43
gcs compatible cr basts (local) 1,151,194 638.85 122.95
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 6,394 3.55 0.68
gcs dbwr write request msgs 4,514 2.51 0.48
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 8,671 4.81 0.93
gcs immediate (null) converts 29,639 16.45 3.17
gcs immediate cr (compatible) converts 41,218 22.87 4.40
gcs immediate cr (null) converts 1,508,588 837.19 161.12
gcs indirect ast 150,146 83.32 16.04
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 1,883 1.04 0.20
gcs msgs process time(ms) 165,854 92.04 17.71
gcs msgs received 3,935,554 2,184.02 420.33
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 41,221 22.88 4.40
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 1 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 0 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 69,516 38.58 7.42
gcs side channel msgs actual 59,218 32.86 6.32
gcs side channel msgs logical 1,489,091 826.37 159.04
gcs stale cr 848 0.47 0.09
gcs undo cr 38 0.02 0.00
gcs write notification msgs 535 0.30 0.06
gcs writes refused 21 0.01 0.00
ges msgs process time(ms) 273 0.15 0.03
ges msgs received 28,800 15.98 3.08
global posts dropped 0 0.00 0.00
global posts queue time 1 0.00 0.00
global posts queued 4 0.00 0.00
global posts requested 4 0.00 0.00
global posts sent 4 0.00 0.00
implicit batch messages received 199,542 110.74 21.31
implicit batch messages sent 74,625 41.41 7.97
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 17,557 9.74 1.88
messages queue sent actual 192,653 106.91 20.58
messages queue sent logical 556,355 308.75 59.42
messages received actual 1,118,074 620.47 119.41
messages received logical 3,964,335 2,200.00 423.40
messages sent directly 268,412 148.95 28.67
messages sent indirectly 479,733 266.23 51.24
messages sent not implicit batched 118,023 65.50 12.61
messages sent pbatched 2,961,838 1,643.66 316.33
msgs causing lmd to send msgs 9,193 5.10 0.98
msgs causing lms(s) to send msgs 178,940 99.30 19.11
msgs received queue time (ms) 74,006 41.07 7.90
msgs received queued 3,964,127 2,199.88 423.38
msgs sent queue time (ms) 882,041 489.49 94.20
msgs sent queue time on ksxp (ms) 358,201 198.78 38.26
msgs sent queued 517,490 287.18 55.27
msgs sent queued on ksxp 914,122 507.29 97.63
number of ges deadlock detected 0 0.00 0.00
process batch messages received 409,116 227.04 43.69
process batch messages sent 526,447 292.15 56.23


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 34,955
CURRENT Block Requests 1,324
Data Block Requests 34,955
Undo Block Requests 38
TX Block Requests 458
Current Results 35,965
Private results 25
Zero Results 289
Disk Read Results 0
Fail Results 0
Fairness Down Converts 6,624
Fairness Clears 0
Free GC Elements 0
Flushes 143
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 13,983
Light Works 243
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 837,282 100.00 0.00 0.00 0.00 0.00
Flushes 66 84.85 13.64 1.52 0.00 0.00
Writes 7,491 83.33 11.27 1.66 1.86 1.90


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 38,897 99.56 0.25 0.19 1,364,737 98.86 0.01 1.14
1 Others 882 100.00 0.00 0.00 1,668 100.00 0.00 0.00
1 undo header 207 100.00 0.00 0.00 57 96.49 3.51 0.00
1 undo block 20 80.00 20.00 0.00 0      


Back to Top

End of Report