WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
NDMIS3941636119ndmis1110.2.0.5.0YESndora1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2647327-Mar-13 17:30:271128 6.5
End Snap:2647427-Mar-13 18:00:291489 5.6
Elapsed:  30.04 (mins)  
DB Time:  92.47 (mins)  

Report Summary

Cache Sizes

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

Load Profile

Per SecondPer Transaction
Redo size: 125,795.14 9,785.81
Logical reads: 89,396.86 6,954.33
Block changes: 796.74 61.98
Physical reads: 1,500.49 116.73
Physical writes: 73.61 5.73
User calls: 1,259.29 97.96
Parses: 169.72 13.20
Hard parses: 25.91 2.02
Sorts: 98.38 7.65
Logons: 0.43 0.03
Executes: 1,746.49 135.86
Transactions: 12.85 

% Blocks changed per Read: 0.89Recursive Call %: 64.06
Rollback per transaction %: 2.55Rows per Sort: 150.70

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.93Redo NoWait %: 100.00
Buffer Hit %: 98.52In-memory Sort %: 100.00
Library Hit %: 96.85Soft Parse %: 84.74
Execute to Parse %: 90.28Latch Hit %: 99.75
Parse CPU to Parse Elapsd %: 19.71% Non-Parse CPU: 98.68

Shared Pool Statistics

BeginEnd
Memory Usage %: 76.75 79.93
% SQL with executions>1: 10.04 29.46
% Memory for SQL w/exec>1: 15.33 37.93

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
db file sequential read 290,690 1,427 5 25.7User I/O
CPU time  1,396  25.2 
db file scattered read 189,132 652 3 11.8User I/O
SQL*Net message from dblink 137,116 597 4 10.8Network
gc buffer busy 112,583 442 4 8.0Cluster

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 484.77 37.71
Global Cache blocks served: 784.52 61.03
GCS/GES messages received: 2,043.80 158.99
GCS/GES messages sent: 2,200.12 171.15
DBWR Fusion writes: 4.28 0.33
Estd Interconnect traffic (KB) 10,983.26 

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

Buffer access - local cache %: 97.97
Buffer access - remote cache %: 0.54
Buffer access - disk %: 1.48

Global Cache and Enqueue Services - Workload Characteristics

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.8
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: 21.99
% of indirect sent messages: 75.82
% of flow controlled messages: 2.19


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 5,352.20 96.47
DB CPU 1,396.41 25.17
parse time elapsed 134.83 2.43
hard parse elapsed time 109.47 1.97
PL/SQL execution elapsed time 69.15 1.25
PL/SQL compilation elapsed time 25.38 0.46
hard parse (sharing criteria) elapsed time 4.33 0.08
failed parse elapsed time 3.95 0.07
connection management call elapsed time 2.03 0.04
repeated bind elapsed time 1.23 0.02
hard parse (bind mismatch) elapsed time 1.06 0.02
sequence load elapsed time 0.08 0.00
DB time 5,548.02  
background elapsed time 366.08  
background cpu time 218.78  

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 507,867   2,151 4 38.77
CPU time     1,396   25.17
Cluster 1,131,701 0 771 1 13.91
Network 2,993,568   694 0 12.52
System I/O 279,095   70 0 1.26
Other 54,123 65 51 1 0.92
Commit 22,548 0 29 1 0.53
Application 563 3 10 17 0.17
Concurrency 51,823 0 7 0 0.12
Configuration 49   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 290,690   1,427 5 12.55
db file scattered read 189,132   652 3 8.16
SQL*Net message from dblink 137,116   597 4 5.92
gc buffer busy 112,583 0 442 4 4.86
gc cr multi block request 634,480   177 0 27.39
SQL*Net more data from client 55,810   78 1 2.41
gc current block 2-way 188,517   74 0 8.14
gc cr grant 2-way 131,891   46 0 5.69
control file sequential read 212,292   40 0 9.16
db file parallel read 8,127   35 4 0.35
latch: object queue header operation 1,549   31 20 0.07
log file sync 22,548 0 29 1 0.97
db file parallel write 41,326   17 0 1.78
direct path read 10,655   15 1 0.46
direct path read temp 4,675   15 3 0.20
gc cr block 2-way 31,977   13 0 1.38
log file parallel write 24,637   12 0 1.06
SQL*Net more data from dblink 9,358   10 1 0.40
enq: TX - row lock contention 24 63 10 396 0.00
reliable message 180 3 9 47 0.01
SQL*Net more data to client 575,365   8 0 24.84
ges lmd/lmses to freeze in rcfg - mrcvr 1,116 45 6 6 0.05
gc object scan 1,191 89 6 5 0.05
gc current grant busy 9,110   6 1 0.39
gc current grant 2-way 15,642   5 0 0.68
read by other session 820   4 5 0.04
row cache lock 11,329   4 0 0.49
direct path write temp 1,300   3 2 0.06
CSS initialization 41   2 51 0.00
gc current multi block request 5,588   2 0 0.24
SQL*Net message to client 2,078,747   1 0 89.73
latch: cache buffers chains 38,879   1 0 1.68
os thread startup 19   1 62 0.00
latch: cache buffers lru chain 30   1 26 0.00
control file parallel write 840   1 1 0.04
direct path write 2,468   1 0 0.11
gc current block busy 95   1 6 0.00
enq: WF - contention 12   1 48 0.00
DFS lock handle 1,554   0 0 0.07
library cache lock 981   0 0 0.04
gcs drm freeze in enter server mode 1   0 298 0.00
CGS wait for IPC msg 24,830 98 0 0 1.07
gc cr block busy 139   0 1 0.01
cursor: pin S wait on X 20 100 0 10 0.00
gc cr disk read 450   0 0 0.02
library cache pin 523   0 0 0.02
gcs log flush sync 218 0 0 1 0.01
latch: KCL gc element parent latch 102   0 2 0.00
ksxr poll remote instances 21,143 41 0 0 0.91
rdbms ipc reply 471   0 0 0.02
gc cr grant congested 11   0 7 0.00
latch free 45   0 2 0.00
SQL*Net message to dblink 137,081   0 0 5.92
enq: TM - contention 77   0 1 0.00
enq: TX - index contention 37   0 1 0.00
CSS operation: action 99   0 1 0.00
kksfbc child completion 1 100 0 49 0.00
latch: gcs resource hash 58   0 1 0.00
SGA: allocation forcing component growth 6 50 0 8 0.00
IPC send completion sync 123 100 0 0 0.01
enq: FB - contention 90   0 0 0.00
SQL*Net break/reset to client 451   0 0 0.02
enq: PS - contention 74   0 0 0.00
gc current block congested 17   0 2 0.00
enq: CF - contention 61   0 0 0.00
gc current split 3   0 8 0.00
enq: TT - contention 76   0 0 0.00
enq: HW - contention 47   0 0 0.00
PX Deq: reap credit 1,738 97 0 0 0.08
latch: library cache 5   0 3 0.00
PX Deq Credit: send blkd 46 17 0 0 0.00
LGWR wait for redo copy 366   0 0 0.02
gc cr block congested 3   0 2 0.00
PX Deq: Signal ACK 39 33 0 0 0.00
enq: TA - contention 9   0 0 0.00
gc current grant congested 2   0 2 0.00
library cache load lock 6   0 0 0.00
enq: TO - contention 7   0 0 0.00
SQL*Net more data to dblink 91   0 0 0.00
enq: JQ - contention 3   0 0 0.00
enq: TX - allocate ITL entry 2   0 1 0.00
latch: shared pool 5   0 0 0.00
latch: session allocation 4   0 0 0.00
buffer busy waits 15   0 0 0.00
enq: SR - contention 3   0 0 0.00
enq: DR - contention 1   0 1 0.00
enq: FU - contention 1   0 1 0.00
enq: PW - flush prewarm buffers 1   0 0 0.00
enq: PE - contention 2   0 0 0.00
gc current retry 2   0 0 0.00
wait for scn ack 4   0 0 0.00
SQL*Net break/reset to dblink 10   0 0 0.00
enq: PG - contention 1   0 0 0.00
KJC: Wait for msg sends to complete 3   0 0 0.00
cr request retry 12 100 0 0 0.00
ges2 LMON to wake up LMD - mrcvr 2   0 0 0.00
buffer deadlock 1 100 0 0 0.00
cursor: mutex S 3   0 0 0.00
cursor: pin S 1   0 0 0.00
cursor: mutex X 1   0 0 0.00
SQL*Net message from client 2,079,046   2,379,342 1144 89.74
gcs remote message 1,628,443 43 27,903 17 70.29
Streams AQ: qmn slave idle wait 745   3,528 4736 0.03
Streams AQ: waiting for time management or cleanup tasks 80 75 1,866 23326 0.00
Streams AQ: qmn coordinator idle wait 606 42 1,764 2911 0.03
DIAG idle wait 9,004 0 1,760 195 0.39
Streams AQ: waiting for messages in the queue 186 100 1,758 9451 0.01
virtual circuit status 60 100 1,758 29297 0.00
PX Idle Wait 737 92 1,757 2384 0.03
ges remote message 44,948 47 1,756 39 1.94
jobq slave wait 601 97 1,727 2873 0.03
single-task message 25   1 30 0.00
PX Deq: Execution Msg 291 24 0 1 0.01
PX Deq: Parse Reply 44 36 0 1 0.00
PX Deq: Join ACK 45 36 0 1 0.00
PX Deq: Execute Reply 31 26 0 1 0.00
PX Deq: Msg Fragment 107 46 0 0 0.00
class slave wait 5   0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 622 99 0 0 0.03

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 50,144 67 38 1 2.16
db file parallel write 41,323   17 0 1.78
log file parallel write 24,633   12 0 1.06
gc object scan 1,191 89 6 5 0.05
control file sequential read 5,035   5 1 0.22
os thread startup 19   1 62 0.00
control file parallel write 840   1 1 0.04
db file sequential read 213   1 3 0.01
gc current block 2-way 314   0 0 0.01
gc cr block 2-way 74   0 0 0.00
latch: cache buffers chains 8   0 2 0.00
gc current grant busy 42   0 0 0.00
enq: HW - contention 12   0 0 0.00
gc cr block busy 1   0 4 0.00
gc current multi block request 11   0 0 0.00
gc current block busy 1   0 1 0.00
enq: PW - flush prewarm buffers 1   0 0 0.00
rdbms ipc message 112,125 25 35,093 313 4.84
gcs remote message 1,628,413 43 27,903 17 70.29
Streams AQ: qmn slave idle wait 745   3,528 4736 0.03
Streams AQ: waiting for time management or cleanup tasks 80 75 1,866 23326 0.00
Streams AQ: qmn coordinator idle wait 606 42 1,764 2911 0.03
DIAG idle wait 8,996   1,758 195 0.39
pmon timer 832 100 1,757 2111 0.04
smon timer 369 99 1,756 4760 0.02
ges remote message 44,909 47 1,756 39 1.94
Streams AQ: RAC qmn coordinator idle wait 622 99 0 0 0.03

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 4,660
AVG_IDLE_TIME 175,282
AVG_IOWAIT_TIME 2,506
AVG_SYS_TIME 1,129
AVG_USER_TIME 3,468
BUSY_TIME 301,761
IDLE_TIME 11,222,395
IOWAIT_TIME 164,453
SYS_TIME 75,893
USER_TIME 225,868
LOAD 1
OS_CPU_WAIT_TIME 313,100
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 5,484,544
VM_OUT_BYTES 30,162,944
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 5,378.70 1,332.50 2,645,095 158,422,162
SYS$USERS 179.30 66.70 71,139 2,759,313
SYS$BACKGROUND 0.00 0.10 1,595 91,049
SYS.KUPC$S_1_20130323232332 0.00 0.00 0 0
nd_mis 0.00 0.00 0 0
ndmisXDB 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
ndmis 494799 2103 47268 4 0 0 2986517 618
SYS$USERS 11319 41 1592 0 0 0 3722 0
SYS$BACKGROUND 1837 7 3050 2 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
684 23 4 171.03 12.33 6fn21cpfwmbmw JDBC Thin Client INSERT INTO T_EQUIMODIFY_DETAI...
502 0 99 5.07 9.05 c5tmjxj6rtck4 JDBC Thin Client SELECT mis_t.tg_id id, (SELECT...
197 45 2,472 0.08 3.55 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
192 13 526 0.37 3.46 gkw6wc3pm09j6 JDBC Thin Client SELECT USER_NAME FROM AMBER.IN...
174 9 2 86.89 3.13 fzu969xyv90pv JDBC Thin Client SELECT * FROM ( Select (Select...
167 103 64,106 0.00 3.00 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
164 33 1 163.54 2.95 5bf742hjadsqf PL/SQL Developer select * from olive.v$_ST_Cabl...
149 38 3 49.71 2.69 aw6gj3r2syaxs JDBC Thin Client select interdata.area_code, in...
139 33 111 1.25 2.50 673hs7hb3w9g1 JDBC Thin Client Select Pc.Obj_Id, Pc.Cls_Uri, ...
131 10 126 1.04 2.36 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
112 4 9,017 0.01 2.02 cv0rtthxrhdxy JDBC Thin Client SELECT O.S_04 || :B2 FROM OL$_...
111 10 189 0.59 2.01 9vrbr3jjprusn JDBC Thin Client SELECT B OBJ_ID, (SELECT S_01 ...
92 14 990,484 0.00 1.65 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
81 3 4,622 0.02 1.46 9yyb7wvndk114 JDBC Thin Client select * from v$_ST_DYLine whe...
66 13 1 65.70 1.18 72ffsqhv7dd6h nqsserver@ndmisbiee02 (TNS V1-V3) select T128047.KGLX as c4, T1...
65 5 21 3.08 1.17 bnaq6cxbzqy6u JDBC Thin Client SELECT * FROM ( Select (Select...
60 9 204 0.29 1.08 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
103 167 64,106 0.00 7.36 3.00 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
45 197 2,472 0.02 3.23 3.55 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
38 149 3 12.50 2.69 2.69 aw6gj3r2syaxs JDBC Thin Client select interdata.area_code, in...
33 139 111 0.30 2.39 2.50 673hs7hb3w9g1 JDBC Thin Client Select Pc.Obj_Id, Pc.Cls_Uri, ...
33 164 1 33.05 2.37 2.95 5bf742hjadsqf PL/SQL Developer select * from olive.v$_ST_Cabl...
31 50 27 1.14 2.20 0.90 49qruxf8jhu57 JDBC Thin Client select a.*, b.org_name, c.org_...
27 43 179 0.15 1.94 0.77 0b243yjuy3dvq JDBC Thin Client select x.attr_uri, x.attr_name...
24 51 21 1.16 1.75 0.92 0jat7ccc9fvct JDBC Thin Client Select Pc.Obj_Id, Pc.Cls_Uri, ...
23 684 4 5.64 1.62 12.33 6fn21cpfwmbmw JDBC Thin Client INSERT INTO T_EQUIMODIFY_DETAI...
20 44 2,623 0.01 1.40 0.78 5wfhpq886xacr JDBC Thin Client SELECT /*+index(t, NK_OL$_REFS...
16 38 39 0.41 1.15 0.68 fkc00x536y5kw JDBC Thin Client select /*+rule*/ p.OBJ_ID as i...
14 92 990,484 0.00 1.03 1.65 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...

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,867,938 27 735,849.56 12.33 30.78 49.68 49qruxf8jhu57 JDBC Thin Client select a.*, b.org_name, c.org_...
18,545,526 526 35,257.65 11.51 12.87 192.00 gkw6wc3pm09j6 JDBC Thin Client SELECT USER_NAME FROM AMBER.IN...
18,204,122 64,106 283.97 11.30 102.73 166.67 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
14,105,165 2,472 5,705.97 8.75 45.15 196.87 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
9,223,834 2,623 3,516.52 5.73 19.50 43.55 5wfhpq886xacr JDBC Thin Client SELECT /*+index(t, NK_OL$_REFS...
8,653,000 127,253 68.00 5.37 8.46 17.68 fc42s7rxq7chg JDBC Thin Client SELECT CLS_URI FROM OL$_CLASSE...
4,961,006 990,484 5.01 3.08 14.33 91.79 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
4,547,183 179 25,403.26 2.82 27.15 42.82 0b243yjuy3dvq JDBC Thin Client select x.attr_uri, x.attr_name...
3,247,204 47,755 68.00 2.02 6.16 17.03 1gcnmuw9xtb3k JDBC Thin Client SELECT CLS_URI FROM OL$_CLASSE...
3,071,361 4 767,840.25 1.91 22.57 684.12 6fn21cpfwmbmw JDBC Thin Client INSERT INTO T_EQUIMODIFY_DETAI...
2,930,589 7 418,655.57 1.82 9.94 48.96 1zqktnh3k2w9h JDBC Thin Client SELECT * FROM ( select name "Éú...
2,926,807 58 50,462.19 1.82 8.07 12.94 awvtdy3vc6fum JDBC Thin Client SELECT codeId, codeSortId, par...
1,999,009 3 666,336.33 1.24 37.51 149.14 aw6gj3r2syaxs JDBC Thin Client select interdata.area_code, in...
1,905,783 2 952,891.50 1.18 13.74 29.28 572fbaj0fdw2b sqlplus@ndora1 (TNS V1-V3) select output from table(dbms_...
1,805,953 189 9,555.31 1.12 9.90 111.33 9vrbr3jjprusn JDBC Thin Client SELECT B OBJ_ID, (SELECT S_01 ...
1,646,864 907 1,815.73 1.02 3.39 9.73 bsm6gmajgmhuu JDBC Thin Client select * from indy_menu where ...
1,620,265 5 324,053.00 1.01 7.68 19.40 05fs85a4b0dy2 JDBC Thin Client select t.plan_item_id, t.plan_...
1,617,664 1,242 1,302.47 1.00 4.51 34.37 g0mmxhhfz1q9g JDBC Thin Client select * from v$_LowArea where...
1,611,360 204 7,898.82 1.00 8.59 59.79 7xn6xppmpg9u7 JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...

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
672,512 3 224,170.67 24.87 37.51 149.14 aw6gj3r2syaxs JDBC Thin Client select interdata.area_code, in...
415,331 1 415,331.00 15.36 33.05 163.54 5bf742hjadsqf PL/SQL Developer select * from olive.v$_ST_Cabl...
357,267 1 357,267.00 13.21 12.84 65.70 72ffsqhv7dd6h nqsserver@ndmisbiee02 (TNS V1-V3) select T128047.KGLX as c4, T1...
98,179 4 24,544.75 3.63 22.57 684.12 6fn21cpfwmbmw JDBC Thin Client INSERT INTO T_EQUIMODIFY_DETAI...
82,810 51 1,623.73 3.06 8.60 54.41 4za9rvjqxptak JDBC Thin Client SELECT COUNT(1) cnt FROM( Sele...
69,125 1 69,125.00 2.56 6.80 48.57 d9s3b9vwvm5t2 SQL*Plus declare begin PRO_YWTJ_ALL; en...
44,523 2 22,261.50 1.65 9.20 173.78 fzu969xyv90pv JDBC Thin Client SELECT * FROM ( Select (Select...
38,468 126 305.30 1.42 10.15 131.13 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
36,994 111 333.28 1.37 33.36 138.83 673hs7hb3w9g1 JDBC Thin Client Select Pc.Obj_Id, Pc.Cls_Uri, ...
32,446 180 180.26 1.20 10.05 29.49 4ydgzsjh9kb57 JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
29,826 2,472 12.07 1.10 45.15 196.87 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
28,317 9,017 3.14 1.05 4.28 112.33 cv0rtthxrhdxy JDBC Thin Client SELECT O.S_04 || :B2 FROM OL$_...

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
990,484 990,457 1.00 0.00 0.00 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
127,253 127,250 1.00 0.00 0.00 fc42s7rxq7chg JDBC Thin Client SELECT CLS_URI FROM OL$_CLASSE...
64,106 64,082 1.00 0.00 0.00 964zgsudcdac7 JDBC Thin Client SELECT D.ATTR_URI FROM OL$_ATT...
47,755 47,753 1.00 0.00 0.00 1gcnmuw9xtb3k JDBC Thin Client SELECT CLS_URI FROM OL$_CLASSE...
44,504 86,582 1.95 0.00 0.00 cfrwbnuu2xtam JDBC Thin Client select side_b from ol$_associa...
39,598 39,598 1.00 0.00 0.00 g4rzpg6rj116d JDBC Thin Client BEGIN OL$_RULE_CORE.SETSTRATTR...
26,411 26,410 1.00 0.00 0.00 grwydz59pu6mc   select text from view$ where r...
20,226 20,226 1.00 0.00 0.00 7xgzx0zrnt0fc JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
16,261 16,261 1.00 0.00 0.00 8b9zc43w360qt JDBC Thin Client SELECT O_28 partitionField FRO...
14,022 0 0.00 0.00 0.00 02djppxs4a73n JDBC Thin Client update ol$_locks t set t.obj =...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
26,411 26,411 8.63 grwydz59pu6mc   select text from view$ where r...
5,536 14,022 1.81 02djppxs4a73n JDBC Thin Client update ol$_locks t set t.obj =...
5,527 8,496 1.81 449xyhjkn7apn JDBC Thin Client select * from v$_ST_EquipmentC...
5,436 7,334 1.78 d3gsxy5k0u8hw JDBC Thin Client select * from v$_ST_Asset wher...
5,185 16,261 1.70 8b9zc43w360qt JDBC Thin Client SELECT O_28 partitionField FRO...
5,160 9,834 1.69 a41yvpfth003x JDBC Thin Client select * from v$_ST_Equipment ...
4,386 4,386 1.43 2ym6hhaq30r73   select type#, blocks, extents,...
4,306 20,226 1.41 7xgzx0zrnt0fc JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
4,242 6,798 1.39 dnctudjagb520 JDBC Thin Client select * from v$_ST_AssetModel...
4,044 6,179 1.32 1f5c885f3vvfx JDBC Thin Client select /*+ index(v$_ST_Asset I...
4,010 6,055 1.31 244v8yhfs7urr JDBC Thin Client SELECT C.CLS_ID, C.CLS_URI, C....
3,856 13,137 1.26 6pcrpqf5dkunf JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
3,785 44,504 1.24 cfrwbnuu2xtam JDBC Thin Client select side_b from ol$_associa...
3,503 4,622 1.15 9yyb7wvndk114 JDBC Thin Client select * from v$_ST_DYLine whe...
3,121 7,192 1.02 b0mb9f2wdgnrk JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
3,092 4,880 1.01 5n9d2rmutsfqv JDBC Thin Client select t.* from ol$_attr_categ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,709,153 2 0.07 f5yun5dynkskv plsqldev.exe select s.synonym_name as obje...
2,289,669 8 0.06 f8uvk4ymbh19z JDBC Thin Client SELECT NAME, TYPE, ACTION_URL,...
2,210,270 8 0.06 5bhhxz06fvgnk JDBC Thin Client SELECT OBJ_ID, NAME, A.CLS_URI...

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
406.33 59.39 684.12 22.57 4 6fn21cpfwmbmw JDBC Thin Client INSERT INTO T_EQUIMODIFY_DETAI...
58.58 39.27 149.14 37.51 3 aw6gj3r2syaxs JDBC Thin Client select interdata.area_code, in...
27.47 16.80 163.54 33.05 1 5bf742hjadsqf PL/SQL Developer select * from olive.v$_ST_Cabl...
13.91 7.07 196.87 45.15 2,472 9g4jrwq86jnb7 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKANDUP...
13.48 10.28 131.13 10.15 126 ab0n17bxfj28d JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
12.00 10.78 111.33 9.90 189 9vrbr3jjprusn JDBC Thin Client SELECT B OBJ_ID, (SELECT S_01 ...
7.84 4.51 173.78 9.20 2 fzu969xyv90pv JDBC Thin Client SELECT * FROM ( Select (Select...
6.99 3.64 192.00 12.87 526 gkw6wc3pm09j6 JDBC Thin Client SELECT USER_NAME FROM AMBER.IN...
6.77 13.94 48.57 6.80 1 d9s3b9vwvm5t2 SQL*Plus declare begin PRO_YWTJ_ALL; en...
6.72 10.23 65.70 12.84 1 72ffsqhv7dd6h nqsserver@ndmisbiee02 (TNS V1-V3) select T128047.KGLX as c4, T1...
5.57 9.32 59.79 8.59 204 7xn6xppmpg9u7 JDBC Thin Client SELECT * FROM (SELECT D.OBJ_ID...
5.03 4.47 112.33 4.28 9,017 cv0rtthxrhdxy JDBC Thin Client SELECT O.S_04 || :B2 FROM OL$_...
4.50 15.27 29.49 10.05 180 4ydgzsjh9kb57 JDBC Thin Client SELECT a.obj_id objid, a.cls_u...
4.44 8.16 54.41 8.60 51 4za9rvjqxptak JDBC Thin Client SELECT COUNT(1) cnt FROM( Sele...
4.11 5.09 80.79 2.91 4,622 9yyb7wvndk114 JDBC Thin Client select * from v$_ST_DYLine whe...
4.06 4.43 91.79 14.33 990,484 646v5z184310m JDBC Thin Client select t.s_01 from olive.ol$_o...
3.82 2.75 138.83 33.36 111 673hs7hb3w9g1 JDBC Thin Client Select Pc.Obj_Id, Pc.Cls_Uri, ...
3.36 6.86 48.96 9.94 7 1zqktnh3k2w9h JDBC Thin Client SELECT * FROM ( select name "Éú...
3.17 9.21 34.37 4.51 1,242 g0mmxhhfz1q9g JDBC Thin Client select * from v$_LowArea where...
2.65 5.33 49.66 4.77 7 g5cxtvzf3du35 JDBC Thin Client SELECT COUNT(1) cnt FROM( Sele...
2.04 3.16 64.75 5.11 21 bnaq6cxbzqy6u JDBC Thin Client SELECT * FROM ( Select (Select...
1.84 5.64 32.61 1.44 7,334 d3gsxy5k0u8hw JDBC Thin Client select * from v$_ST_Asset wher...
1.66 4.62 35.89 2.26 4 ggsus9qmhfqws JDBC Thin Client SELECT COUNT(1) cnt FROM( With...
1.47 4.43 33.14 1.36 9,834 a41yvpfth003x JDBC Thin Client select * from v$_ST_Equipment ...
1.41 2.76 50.87 24.39 21 0jat7ccc9fvct JDBC Thin Client Select Pc.Obj_Id, Pc.Cls_Uri, ...
1.40 2.82 49.68 30.78 27 49qruxf8jhu57 JDBC Thin Client select a.*, b.org_name, c.org_...
1.38 8.68 15.94 7.85 10 21z5a641zuy0m JDBC Thin Client Select Pc.Obj_Id, Pc.Cls_Uri, ...
1.36 3.73 36.33 4.05 47 bqbmpc6p2anhj JDBC Thin Client Select Pc.Obj_Id, Pc.Cls_Uri, ...
1.34 3.90 34.26 2.83 8 5bhhxz06fvgnk JDBC Thin Client SELECT OBJ_ID, NAME, A.CLS_URI...
1.24 4.02 30.89 1.26 2,267 6xjqy1675jdyr JDBC Thin Client select * from v$_ST_EquipmentC...
1.24 4.88 25.36 13.25 29 598k07tzg7tud JDBC Thin Client Select Ass.Obj_Id, ass.CLS_URI...
1.01 5.18 19.40 7.68 5 05fs85a4b0dy2 JDBC Thin Client select t.plan_item_id, t.plan_...
1.00 2.66 37.64 16.01 39 fkc00x536y5kw JDBC Thin Client select /*+rule*/ p.OBJ_ID as i...
0.93 4.15 22.42 2.38 3,152 450w20twk6ku5 JDBC Thin Client BEGIN OL$_RULE_CORE.CHECKNAMEM...
0.77 9.82 7.89 1.38 8 3ypmvj5df15za JDBC Thin Client SELECT COUNT(1) cnt FROM( sele...
0.64 4.69 13.72 0.74 2,214 apd7t7sfn2wxd JDBC Thin Client SELECT Getnamepathbyidpath(Pc....
0.57 2.82 20.17 3.08 709 avjzuwm5npxv7 JDBC Thin Client select * from indy_menu where ...
0.52 1.19 43.55 19.50 2,623 5wfhpq886xacr JDBC Thin Client SELECT /*+index(t, NK_OL$_REFS...
0.44 10.84 4.04 0.34 8,496 449xyhjkn7apn JDBC Thin Client select * from v$_ST_EquipmentC...
0.36 1.24 29.28 13.74 2 572fbaj0fdw2b sqlplus@ndora1 (TNS V1-V3) select output from table(dbms_...
0.32 4.06 7.85 0.36 6,179 1f5c885f3vvfx JDBC Thin Client select /*+ index(v$_ST_Asset I...
0.30 3.75 7.87 1.74 6,813 d7qa0bq22h0p3 JDBC Thin Client SELECT A FROM OL$_ASSOCIATIONS...
0.24 54.91 0.43 0.06 717 ac4pb7ypdb95a JDBC Thin Client select count(l.log_machine_ip)...
0.20 20.35 1.00 0.09 4,841 0cxypy0hx9g11 JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
0.15 44.66 0.34 0.11 201 8d3y3sqaj9f3s JDBC Thin Client SELECT * FROM (SELECT row_.*, ...
0.15 3.99 3.72 0.14 6,798 dnctudjagb520 JDBC Thin Client select * from v$_ST_AssetModel...
0.13 4.39 3.06 1.83 8 7vzpyu7p1t79j JDBC Thin Client select APPLY_ID, APPLY_CD, APP...
0.12 1.19 9.73 3.39 907 bsm6gmajgmhuu JDBC Thin Client select * from indy_menu where ...
0.10 6.13 1.68 0.09 13,137 6pcrpqf5dkunf JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
0.10 12.50 0.77 0.06 3,766 95jvxjj84rcct JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
0.10 2.09 4.56 2.14 171 48cbp9fvjyc13 JDBC Thin Client select t.ID, t.linename, t.bra...
0.09 5.29 1.74 1.05 8 5qr55krh9dkx5 JDBC Thin Client select APPLY_ID, APPLY_CD, APP...
0.08 26.92 0.29 0.15 1 6f4zjjxqztymw JDBC Thin Client select DECODE(SFCQCQCS, 'T', '...
0.07 4.88 1.38 0.08 16,261 8b9zc43w360qt JDBC Thin Client SELECT O_28 partitionField FRO...
0.07 5.50 1.19 0.29 8 20qj7xd001w39 JDBC Thin Client SELECT * FROM (SELECT row_.*, ...
0.06 2.33 2.78 0.15 20,226 7xgzx0zrnt0fc JDBC Thin Client select /*+ index(o PK_OL$_OBJE...
0.04 13.00 0.33 0.03 1,653 4hn182nyc6xd5 JDBC Thin Client INSERT INTO T_YPJC_DISTLINESEG...
0.04 26.80 0.15 0.02 247 gk7v3zx64y3ma JDBC Thin Client INSERT INTO t_ypjc_lowlinesegm...
0.04 17.33 0.21 0.10 1 7jm90h66ramq2 JDBC Thin Client select DECODE(SFCQCQCS, 'T', '...
0.04 2.57 1.39 0.60 26,411 grwydz59pu6mc   select text from view$ where r...
0.03 4.08 0.80 0.19 1,910 5v8y4xqjc73kv JDBC Thin Client SELECT Q1.B OBJ_ID FROM OLIVE....
0.03 16.02 0.19 0.02 1,008 byuacw6h7dqkn JDBC Thin Client INSERT INTO T_YPJC_DISTTRANSFO...
0.03 12.56 0.21 0.15 1,626 9v06ad27zwf4x JDBC Thin Client Select NAME From v$_ST_Transmi...
0.02 2.90 0.77 0.04 7,192 b0mb9f2wdgnrk JDBC Thin Client select /*+ index(o PK_OL$_OBJE...

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
0cxypy0hx9g11select /*+ index(o PK_OL$_OBJECTS) */ * from v$_FamilyLine o where obj_id=:1
0jat7ccc9fvct Select Pc.Obj_Id, Pc.Cls_Uri, Pc.Voltagelevel, Pc.Pathname, Ass.Obj_Id Assetid, Ass.Name Assetname, Ass.Cls_Uri Asseturi, Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) Assetnamepath, c.Cls_Uri Clsuri, c.Cls_Disp_Name, Ass.Assetsstatus, Ass.Manufacturer, Ass.Sbxh, Ass.Inservicedate, Ass.Code From V$_St_Powersystemresource Pp, V$_St_Powersystemresource Pc, Ol$_Associations a, V$_St_Asset Ass, Ol$_Classes c Where Pc.Pathname Like Pp.Pathname || '%' And Ass.Pathname Like '\' || a.b || '%' And Pp.Obj_Id =:1 And Pc.Obj_Id = a.a And Ass.Cls_Uri = c.Cls_Uri And a.Ast_Uri = 'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"' and Pc.orgId=:2 and Ass.orgId=Pc.orgId and ass.Assetsstatus in( 'S', 'W') and ass.CLS_URI in( 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_AssetContainer/ST_Structure/ST_Pole', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/ST_OHConductorAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_EarthWire/OHEarthWireAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/ST_CableAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_Terminal', 'OLCLASS://Entity/ST_Identifie dObject/ST_Asset/ST_ElectricalAsset/IntermediateConnectortAsset')
1f5c885f3vvfxselect /*+ index(v$_ST_Asset IDX_OL$_OBJECTS_CLS_PATHNAME) */ v$_ST_Asset.* from v$_ST_Asset where orgId = :1 and ( (ASSETSSTATUS = :2 OR ASSETSSTATUS = :3) and pathName like :4 ) order by pathName
1gcnmuw9xtb3kSELECT CLS_URI FROM OL$_CLASSES WHERE CLS_ID = SUBSTR(:B1 , 1, 32)
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
20qj7xd001w39 SELECT * FROM (SELECT row_.*, rownum rownum_ 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 And 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 ) row_ WHERE rownum <= :6) WHERE rownum_ > :7
21z5a641zuy0mSelect Pc.Obj_Id, Pc.Cls_Uri, Pc.Voltagelevel, Pc.Pathname, Ass.Obj_Id Assetid, Ass.Name Assetname, Ass.Cls_Uri Asseturi, Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) Assetnamepath, c.Cls_Uri Clsuri, c.Cls_Disp_Name, Ass.Assetsstatus, Ass.Manufacturer, Ass.Sbxh, Ass.Inservicedate, Ass.Code From V$_St_Powersystemresource Pp, V$_St_Powersystemresource Pc, Ol$_Associations a, V$_St_Asset Ass, Ol$_Classes c Where Pc.Pathname Like Pp.Pathname || '%' And Ass.Pathname Like '\' || a.b || '%' And Pp.Obj_Id =:1 And Pc.Obj_Id = a.a And Ass.Cls_Uri = c.Cls_Uri And a.Ast_Uri = 'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"' and Pc.orgId=:2 and Ass.orgId=Pc.orgId and ass.Assetsstatus in( 'S', 'W') and ass.CLS_URI in( 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_SwitchAsset/ST_FuseAsset')
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
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
3ypmvj5df15za SELECT COUNT(1) cnt 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 Rownu m = 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 And 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 )
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;
48cbp9fvjyc13select t.ID, t.linename, t.branchPoint location, t.wirepart name, t.yparam distWireType, t.WireType distWireTypeNew, t.unitResistance, t.unitReactance, t.sectionalArea, t.distWireMaterial, 'true' flag, t.TransformerID, round(t.jjzll, 4) jjzll, t.begPoleId, t.endPoleId from T_YPJC_ANALOYANALYSISDX_INFO t where t.TransformerID = :1
49qruxf8jhu57select a.*, b.org_name, c.org_name org_name_city from v_failure_record_query a, sgpm.o_org b , sgpm.o_org c where a.xjid = b.org_no AND SUBSTR(a.xjid, 1, 5) = c.ORG_NO and a.orgno like GETORGNO('1340313') order by a.gzbh desc
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
4za9rvjqxptakSELECT COUNT(1) cnt FROM( Select (Select Org_Name From Sgpm.o_Org Where Org_No = Substr(t.Orgid, 1, 5)) "Êе¥Î»", (Select Org_Name From Sgpm.o_Org Where Org_No = Substr(t.Orgid, 1, 7)) "ÏØµ¥Î»", (Select Org_Name From Sgpm.o_Org Where Org_No = t.Orgid) "¹©µçËù", Name "Ïß·Ãû³Æ", (Select Name From v$_st_dyline Where Obj_Id = Substr(t.Pathname, -129, 64)) "Éϼ¶Ïß·", Getpathnamebypathid(Substr(t.Pathname, 1, Length(t.Pathname) - 65)) "Éϼ¶Ïß·λÖÃ", t.Tconnectname "T½Ó¸ËËþ±àºÅ" From olive.v$_st_dyline t Where t.RESOURCESTATUS = 'E' And Length(t.Pathname) > 390 And Orgid = :1 and length(:2) > 7 and (t.Tconnectid Is Null or not exists (select 1 from olive.ol$_objects p where p.OBJ_ID = t.Tconnectid and p.s_04 like Substr(t.Pathname, 1, Length(t.Pathname) - 65) || '%')))
572fbaj0fdw2bselect output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
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'
5bf742hjadsqfselect * from olive.v$_ST_CableAssetModel
5bhhxz06fvgnk SELECT OBJ_ID, NAME, A.CLS_URI, A.PATHNAME, C.CLS_DISP_NAME, (CASE WHEN A.CLS_URI LIKE 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/%' THEN (SELECT GETPATHNAMEBYPATHID(P1.PATHNAME || A.PATHNAME) FROM OL$_ASSOCIATIONS ASS, V$_ST_POWERSYSTEMRESOURCE P1, V$_ST_POWERSYSTEMRESOURCE P2 WHERE ASS.AST_URI = 'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"' AND ASS.B = SUBSTR(A.PATHNAME, 2, 64) AND ASS.A = P1.OBJ_ID AND P1.PATHNAME LIKE P2.PATHNAME || '%' AND ROWNUM = 1 AND P2.OBJ_ID IN (:1)) ELSE GETPATHNAMEBYPATHID(PATHNAME) END) PATHNAMEVALUE FROM V$_ST_IDENTIFIEDOBJECT A, OLIVE.OL$_CLASSES C WHERE C.CLS_URI = A.CLS_URI AND OBJ_ID IN(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, : 97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163, :164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178, :179, :180, :181, :182, :183, :184, :185, :186, :187, :188, :189, :190, :191, :192, :193, :194, :195, :196, :197, :198, :199, :200, :201, :202, :203, :204, :205, :206, :207, :208, :209, :210, :211, :212, :213, :214, :215, :216, :217, :218, :219, :220, :221, :222, :223, :224, :225, :226, :227, :228, :229, :230, :231, :232, :233, :234, :235, :236, :237, :238, :239, :240, :241, :242, :243, :244, :245, :246, :247, :248, :249, :250, :251, :252, :253, :254, :255, :256, :257, :258, :259, :260, :261, :262, :263, :264, :265, :266, :267, :268, :269, :270, :271, :272, :273, :274, :275, :276, :277, :278, :279, :280, :281, :282, :283, :284, :285, :286, :287, :288, :289, :290, :291, :292, :293, :294, :295, :296, :297, :298, :299, :300, :301, :302, :303, :304, :305, :306, :307, :308, :309, :310, :311, :312, :313, :314, :315, :316, :317, :318, :319, :320, :321, :322, :323, :324, :325, :326, :327, :328, :329, :330, :331, :332, :333, :334, :335, :336, :337, :338, :339, :340, :341, :342, :343, :344, :345, :346, :347 , :348, :349, :350, :351, :352, :353, :354, :355, :356, :357, :358, :359, :360, :361, :362, :363, :364, :365, :366, :367, :368, :369, :370, :371, :372, :373, :374, :375, :376, :377, :378, :379, :380, :381, :382, :383, :384, :385, :386, :387, :388, :389, :390, :391, :392, :393, :394, :395, :396, :397, :398, :399, :400, :401, :402, :403, :404, :405, :406, :407, :408, :409, :410, :411, :412, :413, :414, :415, :416, :417, :418, :419, :420, :421, :422, :423, :424, :425, :426, :427, :428, :429, :430, :431, :432, :433, :434, :435, :436, :437, :438, :439, :440, :441, :442, :443, :444, :445, :446, :447, :448, :449, :450, :451, :452, :453, :454, :455, :456, :457, :458, :459, :460, :461, :462, :463, :464, :465, :466, :467, :468, :469, :470, :471, :472, :473, :474, :475, :476, :477, :478, :479, :480, :481, :482, :483, :484, :485, :486, :487, :488, :489, :490, :491, :492, :493, :494, :495, :496, :497, :498, :499, :500, :501, :502, :503, :504, :505, :506, :507, :508, :509, :510, :511, :512, :513, :514, :515, :516, :517, :518, :519, :520, :521, :522, :523, :524, :525, :526, :527, :528, :529, :530, :531, :532, :533, :534, :535, :536, :537, :538, :539, :540, :541, :542, :543, :544, :545, :546, :547, :548, :549, :550, :551, :552, :553, :554, :555, :556, :557, :558, :559, :560, :561, :562, :563, :564, :565, :566, :567, :568, :569, :570, :571, :572, :573, :574, :575, :576, :577, :578, :579, :580, :581, :582, :583, :584, :585, :586, :587, :588, :589, :590, :591, :592, :593, :594, :595, :596, :597 , :598, :599, :600, :601, :602, :603, :604, :605, :606, :607, :608, :609, :610, :611, :612, :613, :614, :615, :616, :617, :618, :619, :620, :621, :622, :623, :624, :625, :626, :627, :628, :629, :630, :631, :632, :633, :634, :635, :636, :637, :638, :639, :640, :641, :642, :643, :644, :645, :646, :647, :648, :649, :650, :651, :652, :653, :654, :655, :656, :657, :658, :659, :660, :661, :662, :663, :664, :665, :666, :667, :668, :669, :670, :671, :672, :673, :674, :675, :676, :677, :678, :679, :680, :681, :682, :683, :684, :685, :686, :687, :688, :689, :690, :691, :692, :693, :694, :695, :696, :697, :698, :699, :700, :701, :702, :703, :704, :705, :706, :707, :708, :709, :710, :711, :712, :713, :714, :715, :716, :717, :718, :719, :720, :721, :722, :723, :724, :725, :726, :727, :728, :729, :730, :731, :732, :733, :734, :735, :736, :737, :738, :739, :740, :741, :742, :743, :744, :745, :746, :747, :748, :749, :750, :751, :752, :753, :754, :755, :756, :757, :758, :759, :760, :761, :762, :763, :764, :765, :766, :767, :768, :769, :770, :771, :772, :773, :774, :775, :776, :777, :778, :779, :780, :781, :782, :783, :784, :785, :786, :787, :788, :789, :790, :791, :792, :793, :794, :795, :796, :797, :798, :799, :800, :801) ORDER BY A.CLS_URI , A.PATHNAME
5n9d2rmutsfqvselect t.* from ol$_attr_categories t where t.cls_uri=:1 order by t.cat_index
5qr55krh9dkx5 select APPLY_ID, APPLY_CD, APPLY_DATE, APPLICANT_CD, APPLICANT, APPLY_UNIT_CD, APPLY_UNIT, REPAIR_UNIT_CD, REPAIR_UNIT, PLAN_TO_CUT, WEEK_PLAN_CD, WORK_LEADER_CD, WORK_LEADER, APPLY_STOP_BEGIN_DATE, APPLY_STOP_END_DATE, STOP_TARGET_ID, STOP_TARGET, STOP_ASSETS_ID, STOP_ASSETS, STOP_SCOPE, WORK_CONTENT, WIRING_CHART, CHANGED_WIRING_CHART, HANDLER_CD, HANDLER, AUDITOR_CD, AUDITOR, APPROVAL_STOP_BEGIN_DATE, APPROVAL_STOP_END_DATE, DISTRICT_DISP_FASHION, DISTRICT_DISP_GUARD, DISTRICT_DISP_APPROVE, FASHION, FASHION_AUDITOR_CD, FASHION_AUDITOR, GUARD, GUARD_AUDITOR_CD, GUARD_AUDITOR, APPROVAL, APPROVER_CD, APPROVER, RECEIVER_CD, RECEIVER, WORKING_BEGIN_DATE, DELEGATE_CD, DELEGATE, BEGIN_DISPATCHER_CD, BEGIN_DISPATCHER, WORKING_END_DATE, REPORTER_CD, REPORTER, END_DISPATCHER_CD, END_DISPATCHER, REAUDITOR_CD, REAUDITOR, DELAY_APPLY_BEGIN_DATE, DELAY_APPLY_END_DATE, DELAY_BEGIN_DATE, DELAY_END_DATE, APPROVAL_BEGIN_DATE, APPROVAL_END_DATE, REPAIR_BEGIN_DATE, REPAIR_END_DATE, DELAY_APPLICANT_CD, DELAY_APPLICANT, DELAY_APPROVER_CD, DELAY_APPROVER, DELAY_REASON, MEMO, LAST_UPDATE_DATE, LAST_UPDATER_CD, LAST_UPDATER, CREATE_DATE, CREATER_CD, CREATER, ORG_NO, ORG_NAME, DEL_FLG , action_url, actionname, activity_name, HANDLE_AUDIT_DATE, FASHION_AUDIT_DATE, FASHION_APPROVAL_BEGIN_DATE, FASHION_APPROVAL_END_DATE, GUARD_AUDIT_DATE, APPROVE_AUDIT_DATE from V_POWERCUT_APPLY_QUERY a where 1=1 and a.WEEK_PLAN_CD =:1
5v8y4xqjc73kvSELECT Q1.B OBJ_ID FROM OLIVE.OL$_QUOTEASSOCIATIONS Q1, OLIVE.OL$_QUOTEASSOCIATIONS Q2 WHERE Q1.AST_URI = Q2.AST_URI AND Q1.A = Q2.A AND Q2.B = :1
5wfhpq886xacrSELECT /*+index(t, NK_OL$_REFS_URI_A)*/ A, B OBJ_ID, (SELECT S_01 FROM OL$_OBJECTS WHERE OBJ_ID = B) NAME FROM OL$_ASSOCIATIONS T WHERE AST_URI = :B2 AND A = :B1 AND SUBSTR(B, 1, 32) IN (SELECT (SELECT CLS_ID FROM OL$_CLASSES WHERE CLS_URI = C.CLS_URI) CLS_ID FROM OL$_CLSNAME_DEFS C WHERE EXISTS (SELECT 1 FROM OL$_CLSRULE_DEFS D WHERE D.MAIN_ID = C.MAIN_ID AND EXISTS (SELECT 1 FROM OL$_RULE_DEFS WHERE UPPER(UP_COL) = 'NAME' AND RULE_TYPE = 'C2' AND RULE_ID = D.RULE_ID)) AND EQUIPMENT_SORT = OL$_RULE_CORE.GETEQUSORT(:B1 ))
646v5z184310mselect t.s_01 from olive.ol$_objects t where t.obj_id= :1
673hs7hb3w9g1Select Pc.Obj_Id, Pc.Cls_Uri, Pc.Voltagelevel, Pc.Pathname, Ass.Obj_Id Assetid, Ass.Name Assetname, Ass.Cls_Uri Asseturi, Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) Assetnamepath, c.Cls_Uri Clsuri, c.Cls_Disp_Name, Ass.Assetsstatus, Ass.Manufacturer, Ass.Sbxh, Ass.Inservicedate, Ass.Code From V$_St_Powersystemresource Pp, V$_St_Powersystemresource Pc, Ol$_Associations a, V$_St_Asset Ass, Ol$_Classes c Where Pc.Pathname Like Pp.Pathname || '%' And Ass.Pathname Like '\' || a.b || '%' And Pp.Obj_Id =:1 And Pc.Obj_Id = a.a And Ass.Cls_Uri = c.Cls_Uri And a.Ast_Uri = 'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"' and Pc.orgId=:2 and Ass.orgId=Pc.orgId and ass.Assetsstatus in( 'S', 'W') and ass.CLS_URI in( 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_AssetContainer/ST_Structure/DYPole', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/DYLinearConductorAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/DYCableAsset')
6f4zjjxqztymwselect DECODE(SFCQCQCS, 'T', 'ÊÇ', '·ñ') SFCQCQCS, decode(ysbdd, 'T', 'ÊÇ', '·ñ') ysbddchar, decode(t.JSZXXQ, 'J', 'ÊÇ', '·ñ') jsxq, decode(sfsc, 'T', 'ÊÇ', '·ñ') sfscchar, case when t.JSZXXQ = 'J' then '¼´Ê±Ïûȱ' when t.JSZXXQ = 'Z' then '×ÔÐÐÏûȱ' else '·ñ' end jszxxqchar, t.* from v_qx_query2 t where 1=1 and t.fxrq >=to_date('1995-03-01 00:00:01', 'yyyy-mm-dd hh24:mi:ss') and t.fxrq<=to_date('2013-03-31 23:59:59', 'yyyy-mm-dd hh24:mi:ss') and t.ssjdm like GETORGNO('1340123') order by ID desc
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
6xjqy1675jdyrselect * from v$_ST_EquipmentContainer where ( orgId = :1 and ResourceStatus = :2 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :3 and ol$_associations.a = :4 ) order by name
72ffsqhv7dd6h select T128047.KGLX as c4, T121580.BDSMC as c5, T128574.HH as c6, T128047.MIN_VALUE as c8, T128047.AVG_VALUE as c9, T128047.MAX_VALUE as c10, T121580.XJDM as c11, T121580.DSJDM as c12 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_BDZ_VALUE T128047 where ( T121580.BDSDM = T128047.BDZDM and T128047.DATAID = T128574.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') )
7jm90h66ramq2select DECODE(SFCQCQCS, 'T', 'ÊÇ', '·ñ') SFCQCQCS, decode(ysbdd, 'T', 'ÊÇ', '·ñ') ysbddchar, decode(t.JSZXXQ, 'J', 'ÊÇ', '·ñ') jsxq, decode(sfsc, 'T', 'ÊÇ', '·ñ') sfscchar, case when t.JSZXXQ = 'J' then '¼´Ê±Ïûȱ' when t.JSZXXQ = 'Z' then '×ÔÐÐÏûȱ' else '·ñ' end jszxxqchar, t.* from v_qx_query2 t where 1=1 and (t.ysxqxzdm='55' or t.ysxqxzdm='54' or t.ysxqxzdm='57') and t.fxrq >=to_date('1995-03-01 00:00:01', 'yyyy-mm-dd hh24:mi:ss') and t.fxrq<=to_date('2013-03-31 23:59:59', 'yyyy-mm-dd hh24:mi:ss') and t.ssjdm like GETORGNO('1340123') order by ID desc
7vzpyu7p1t79j select APPLY_ID, APPLY_CD, APPLY_DATE, APPLICANT_CD, APPLICANT, APPLY_UNIT_CD, APPLY_UNIT, REPAIR_UNIT_CD, REPAIR_UNIT, PLAN_TO_CUT, WEEK_PLAN_CD, WORK_LEADER_CD, WORK_LEADER, APPLY_STOP_BEGIN_DATE, APPLY_STOP_END_DATE, STOP_TARGET_ID, STOP_TARGET, STOP_ASSETS_ID, STOP_ASSETS, STOP_SCOPE, WORK_CONTENT, WIRING_CHART, CHANGED_WIRING_CHART, HANDLER_CD, HANDLER, AUDITOR_CD, AUDITOR, APPROVAL_STOP_BEGIN_DATE, APPROVAL_STOP_END_DATE, DISTRICT_DISP_FASHION, DISTRICT_DISP_GUARD, DISTRICT_DISP_APPROVE, FASHION, FASHION_AUDITOR_CD, FASHION_AUDITOR, GUARD, GUARD_AUDITOR_CD, GUARD_AUDITOR, APPROVAL, APPROVER_CD, APPROVER, RECEIVER_CD, RECEIVER, WORKING_BEGIN_DATE, DELEGATE_CD, DELEGATE, BEGIN_DISPATCHER_CD, BEGIN_DISPATCHER, WORKING_END_DATE, REPORTER_CD, REPORTER, END_DISPATCHER_CD, END_DISPATCHER, REAUDITOR_CD, REAUDITOR, DELAY_APPLY_BEGIN_DATE, DELAY_APPLY_END_DATE, DELAY_BEGIN_DATE, DELAY_END_DATE, APPROVAL_BEGIN_DATE, APPROVAL_END_DATE, REPAIR_BEGIN_DATE, REPAIR_END_DATE, DELAY_APPLICANT_CD, DELAY_APPLICANT, DELAY_APPROVER_CD, DELAY_APPROVER, DELAY_REASON, MEMO, LAST_UPDATE_DATE, LAST_UPDATER_CD, LAST_UPDATER, CREATE_DATE, CREATER_CD, CREATER, ORG_NO, ORG_NAME, DEL_FLG, (SELECT O.ORG_NAME FROM SGPM.O_ORG O WHERE O.ORG_NO=SUBSTR(A.ORG_NO, 1, 7)) ORG_NAMES , action_url, actionname, activity_name, HANDLE_AUDIT_DATE, FASHION_AUDIT_DATE, FASHION_APPROVAL_BEGIN_DATE, FASHION_APPROVAL_END_DATE, GUARD_AUDIT_DATE, APPROVE_AUDIT_DATE from V_POWERCUT_APPLY_QUERY a where 1=1 and trunc(a.fashion _approval_begin_date, 'DD') >= to_date(:1, 'yyyy-MM-dd') and trunc(a.fashion_approval_begin_date, 'DD') <= to_date(:2, 'yyyy-MM-dd') and a.org_no like GETORGNO(:3)
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
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
95jvxjj84rcctselect /*+ index(o PK_OL$_OBJECTS) */ * from v$_MeterBox o where obj_id=:1
964zgsudcdac7SELECT D.ATTR_URI FROM OL$_ATTR_DEFS D WHERE D.CLS_URI = :B2 AND D.ATTR_NAME = :B1
9g4jrwq86jnb7BEGIN OL$_RULE_CORE.CHECKANDUPDATELOWERNAME(:1); END;
9v06ad27zwf4xSelect NAME From v$_ST_TransmisPolePosition Where obj_id =:Upobjid
9vrbr3jjprusnSELECT B OBJ_ID, (SELECT S_01 FROM OL$_OBJECTS WHERE OBJ_ID = B) NAME FROM (SELECT T.*, LEVEL FROM OL$_ASSOCIATIONS T WHERE AST_URI = :B2 AND SUBSTR(B, 1, 32) != SUBSTR(:B1 , 1, 32) AND SUBSTR(DECODE(A, :B1 , '1', A), 1, 32) != SUBSTR(:B1 , 1, 32) START WITH A = :B1 CONNECT BY PRIOR B = A) WHERE SUBSTR(B, 1, 32) IN (SELECT (SELECT CLS_ID FROM OL$_CLASSES WHERE CLS_URI = C.CLS_URI) CLS_ID FROM OL$_CLSNAME_DEFS C WHERE EXISTS (SELECT 1 FROM OL$_CLSRULE_DEFS D WHERE D.MAIN_ID = C.MAIN_ID AND EXISTS (SELECT 1 FROM OL$_RULE_DEFS WHERE UP_TARGET_CLS = :B3 AND UPPER(UP_COL) = 'NAME' AND RULE_TYPE = 'C' AND RULE_ID = D.RULE_ID))) START WITH A = :B1 CONNECT BY PRIOR B = A
9yyb7wvndk114select * from v$_ST_DYLine where ( orgId = :1 and ResourceStatus = :2 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :3 and ol$_associations.a = :4 ) order by cls_uri
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
apd7t7sfn2wxdSELECT Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) pathName, Pc.OBJ_ID resourceId FROM V$_ST_ASSET Ass, OL$_ASSOCIATIONS O, V$_ST_POWERSYSTEMRESOURCE Pc WHERE Ass.OBJ_ID =:1 AND O.B = SUBSTR(Ass.PATHNAME, 2, 64) AND Pc.OBJ_ID = O.A AND O.AST_URI =:2
avjzuwm5npxv7select * from indy_menu where menu_id in ( select menu_id from indy_menu start with menu_id in ( select n.menu_id from indy_menu n where menu_state = '01' and n.action_normal = 'T' and n.action_id in ( select ua.action_id from indy_user_action ua where ua.user_id = :1 ) union all select m.menu_id from indy_menu m where menu_state = '01' and m.action_normal = 'T' and m.action_authorized = 'F' and m.action_id is not null ) connect by menu_id = prior menu_parent_id ) and menu_kind in ('MenuFolder', 'MenuItem') and decode(:2, menu_parent_id, 1, menu_grant_id, 1, 0) = 1 and menu_state = :3 order by menu_index
aw6gj3r2syaxsselect interdata.area_code, interdata.area_name, interdata.sub_area_code, interdata.sub_area_name, to_char(Min(interdata.import_time), 'yyyy-mm-dd hh24:mi:ss') as fartime, to_char(Max(interdata.import_time), 'yyyy-mm-dd hh24:mi:ss') as neartime, sum(1) As sczcs, sum(Case When interdata.handle_flag = '2' Then 1 When (interdata.handle_flag = '3' or interdata.handle_flag = '4') Then 0 End) as sccgcs, sum(Case When (interdata.handle_flag = '0' or interdata.handle_flag = '1') Then 1 When (interdata.handle_flag = '2' or interdata.handle_flag = '3' or interdata.handle_flag = '4') Then 0 End) as clzzcs, sum(Case When interdata.handle_flag = '2' Then 0 When (interdata.handle_flag = '3' or interdata.handle_flag = '4') Then 1 End) as yccs from scada.scada_interface_data_bd interData where 1=1 and interData.area_code = 'dqid' Group By interdata.area_code, interdata.area_name, interdata.sub_area_code, interdata.sub_area_name order by interdata.area_code, interdata.sub_area_code
awvtdy3vc6fumSELECT codeId, codeSortId, parentCodeId, codeType, orgNo, value, name, dispSn, content1, content2, content3, content4, content5 FROM (SELECT '' codeId, '' codeSortId, p_code parentCodeId, code_type codeType, org_no orgNo, value, name, disp_sn dispSn, content1, content2, content3, content4, content5 FROM v_sp_cache_code) WHERE codeType=:1
b0mb9f2wdgnrkselect /*+ index(o PK_OL$_OBJECTS) */ * from v$_LowArea o where obj_id=:1
bnaq6cxbzqy6uSELECT * FROM ( Select (Select Org_Name From Sgpm.o_Org Where Org_No = Substr(t.Orgid, 1, 5)) "Êе¥Î»", (Select Org_Name From Sgpm.o_Org Where Org_No = Substr(t.Orgid, 1, 7)) "ÏØµ¥Î»", (Select Org_Name From Sgpm.o_Org Where Org_No = t.Orgid) "¹©µçËù", Name "µ¼ÏßÃû³Æ", Getpathnamebypathid((Select pathname From v$_st_dyline Where Obj_Id = (select a from olive.ol$_associations where b = t.OBJ_ID and rownum = 1))) "µÍѹÏß·λÖÃ" From olive.v$_DYLinearConductorAsset t Where t.ASSETSSTATUS = 'S' and (not exists (select 1 from olive.v$_DYPolePosition p where p.OBJ_ID = t.FROMPOLE) or not exists (select 1 from olive.v$_DYPolePosition p where p.OBJ_ID = t.TOPOLE)) And Orgid = :1 and length(:2) > 7 ) WHERE rownum <= :3
bqbmpc6p2anhjSelect Pc.Obj_Id, Pc.Cls_Uri, Pc.Voltagelevel, Pc.Pathname, Ass.Obj_Id Assetid, Ass.Name Assetname, Ass.Cls_Uri Asseturi, Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) Assetnamepath, c.Cls_Uri Clsuri, c.Cls_Disp_Name, Ass.Assetsstatus, Ass.Manufacturer, Ass.Sbxh, Ass.Inservicedate, Ass.Code From V$_St_Powersystemresource Pp, V$_St_Powersystemresource Pc, Ol$_Associations a, V$_St_Asset Ass, Ol$_Classes c Where Pc.Pathname Like Pp.Pathname || '%' And Ass.Pathname Like '\' || a.b || '%' And Pp.Obj_Id =:1 And Pc.Obj_Id = a.a And Ass.Cls_Uri = c.Cls_Uri And a.Ast_Uri = 'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"' and Pc.orgId=:2 and Ass.orgId=Pc.orgId and ass.Assetsstatus in( 'S', 'W') and ass.CLS_URI in( 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/DYLinearConductorAsset')
bsm6gmajgmhuuselect * from indy_menu where menu_id in ( select menu_id from indy_menu start with menu_id in ( select n.menu_id from indy_menu n where menu_state = '01' and n.action_normal = 'T' and n.action_id in ( select ua.action_id from indy_user_action ua where ua.user_id = :1 ) union all select m.menu_id from indy_menu m where menu_state = '01' and m.action_normal = 'T' and m.action_authorized = 'F' and m.action_id is not null ) connect by menu_id = prior menu_parent_id ) and menu_kind in ('MenuFolder', 'MenuItem') and menu_parent_id=:2 and menu_state = :3 order by menu_index
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)
cfrwbnuu2xtamselect side_b from ol$_association_constraints where association_type = :1 and side_a = :2
cv0rtthxrhdxySELECT O.S_04 || :B2 FROM OL$_ASSOCIATIONS A, OL$_OBJECTS O WHERE A.A = O.OBJ_ID AND A.B = :B1 AND ROWNUM = 1
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
d9s3b9vwvm5t2declare begin PRO_YWTJ_ALL; end;
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 )
f5yun5dynkskv select s.synonym_name as object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
f8uvk4ymbh19zSELECT NAME, TYPE, ACTION_URL, actionname, activity_name, ticket_no, filler_id, filler, leader, leader_id, str_start_date, str_end_date, issuer, issuer_id, issue_date, permit_permiter_id, permit_permiter, week_plan_id FROM v_all_ticket1_query T WHERE T.WEEK_PLAN_ID =:1
fc42s7rxq7chgSELECT CLS_URI FROM OL$_CLASSES WHERE CLS_ID = :B1
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
fzu969xyv90pvSELECT * FROM ( Select (Select org_name From sgpm.o_org Where org_no = substr(orgid, 1, 5)) "Êе¥Î»", (Select org_name From sgpm.o_org Where org_no = orgid) "ÏØµ¥Î»", (Select a.Cls_Disp_Name From Ol$_Classes a Where Cls_Uri = s.Cls_Uri) "É豸ÀàÐÍ", s.NAME, ol$_tools.getallpathnamebypathid(pathname) É豸·¾¶, '' "É豸ÐͺÅΪ¿Õ" From V$_St_Asset s Where s.ASSETSSTATUS = 'S' and s.SBXH is null and exists (select 1 from ol$_attr_defs t where t.cls_uri = s.CLS_URI and attr_name = 'SBXH' and t.cat_id is not null) and s.ORGID = :1 ) WHERE rownum <= :2
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;
g5cxtvzf3du35SELECT COUNT(1) cnt FROM( Select Obj_Id "Ïß·ID", Name "Ïß·Ãû³Æ", Getpathnamebypathid(Pathname) "Ïß·λÖÃ" From V$_St_Feeder t Where Orgid = :1 And t.Resourcestatus = 'E' And t.LINEKIND<>'30' And Not Exists (Select 1 From Ol$_Associations a Where a.a = t.Obj_Id And a.Ast_Uri = 'OLASSOCIATIONTYPE://ST_IdentifiedObject_ST_IdentifiedObject?A="OLCLASS://Entity/ST_IdentifiedObject"&B="OLCLASS://Entity/ST_IdentifiedObject"' And Exists (Select 1 From V$_St_Linesection Where Obj_Id = a.b And Resourcestatus = 'E' And Orgid = :2)))
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

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 105,863 58.74 4.57
CPU used when call started 105,171 58.36 4.54
CR blocks created 1,067 0.59 0.05
Cached Commit SCN referenced 186,253 103.35 8.04
Commit SCN cached 38 0.02 0.00
DB time 926,133 513.89 39.98
DBWR checkpoint buffers written 48,801 27.08 2.11
DBWR checkpoints 0 0.00 0.00
DBWR fusion writes 7,710 4.28 0.33
DBWR transaction table writes 272 0.15 0.01
DBWR undo block writes 10,634 5.90 0.46
DFO trees parallelized 16 0.01 0.00
PX local messages recv'd 66 0.04 0.00
PX local messages sent 66 0.04 0.00
PX remote messages recv'd 209 0.12 0.01
PX remote messages sent 154 0.09 0.01
Parallel operations not downgraded 16 0.01 0.00
RowCR - row contention 1,020 0.57 0.04
RowCR attempts 38,712 21.48 1.67
RowCR hits 38,231 21.21 1.65
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SQL*Net roundtrips to/from client 2,074,379 1,151.03 89.54
SQL*Net roundtrips to/from dblink 137,081 76.06 5.92
active txn count during cleanout 3,737 2.07 0.16
application wait time 961 0.53 0.04
background timeouts 10,565 5.86 0.46
branch node splits 11 0.01 0.00
buffer is not pinned count 30,899,677 17,145.54 1,333.78
buffer is pinned count 92,213,943 51,167.46 3,980.40
bytes received via SQL*Net from client 284,191,314 157,691.42 12,267.07
bytes received via SQL*Net from dblink 32,254,813 17,897.48 1,392.27
bytes sent via SQL*Net to client 1,798,813,589 998,121.51 77,645.51
bytes sent via SQL*Net to dblink 16,304,156 9,046.81 703.77
calls to get snapshot scn: kcmgss 5,520,281 3,063.08 238.28
calls to kcmgas 183,247 101.68 7.91
calls to kcmgcs 2,215 1.23 0.10
change write time 438 0.24 0.02
cleanout - number of ktugct calls 13,240 7.35 0.57
cleanouts and rollbacks - consistent read gets 382 0.21 0.02
cleanouts only - consistent read gets 8,299 4.60 0.36
cluster key scan block gets 271,917 150.88 11.74
cluster key scans 262,043 145.40 11.31
cluster wait time 77,130 42.80 3.33
commit batch performed 4,180 2.32 0.18
commit batch requested 4,180 2.32 0.18
commit batch/immediate performed 4,198 2.33 0.18
commit batch/immediate requested 4,198 2.33 0.18
commit cleanout failures: block lost 141 0.08 0.01
commit cleanout failures: callback failure 2,585 1.43 0.11
commit cleanout failures: cannot pin 11 0.01 0.00
commit cleanouts 113,590 63.03 4.90
commit cleanouts successfully completed 110,853 61.51 4.78
commit immediate performed 18 0.01 0.00
commit immediate requested 18 0.01 0.00
commit txn count during cleanout 18,342 10.18 0.79
concurrency wait time 670 0.37 0.03
consistent changes 898,702 498.67 38.79
consistent gets 157,992,553 87,666.54 6,819.72
consistent gets - examination 60,700,723 33,681.48 2,620.14
consistent gets direct 14,774 8.20 0.64
consistent gets from cache 157,977,723 87,658.31 6,819.08
current blocks converted for CR 6 0.00 0.00
cursor authentications 8,791 4.88 0.38
data blocks consistent reads - undo records applied 2,476 1.37 0.11
db block changes 1,435,876 796.74 61.98
db block gets 3,117,611 1,729.89 134.57
db block gets direct 14,415 8.00 0.62
db block gets from cache 3,103,196 1,721.89 133.95
deferred (CURRENT) block cleanout applications 48,108 26.69 2.08
dirty buffers inspected 9,485 5.26 0.41
enqueue conversions 260,867 144.75 11.26
enqueue releases 208,204 115.53 8.99
enqueue requests 208,204 115.53 8.99
enqueue timeouts 1 0.00 0.00
enqueue waits 512 0.28 0.02
exchange deadlocks 2 0.00 0.00
execute count 3,147,521 1,746.49 135.86
free buffer inspected 2,770,621 1,537.36 119.59
free buffer requested 3,784,921 2,100.17 163.38
gc CPU used by this session 38,057 21.12 1.64
gc blocks lost 0 0.00 0.00
gc cr block build time 59 0.03 0.00
gc cr block flush time 7 0.00 0.00
gc cr block receive time 1,827 1.01 0.08
gc cr block send time 149 0.08 0.01
gc cr blocks received 36,282 20.13 1.57
gc cr blocks served 40,144 22.28 1.73
gc current block flush time 6 0.00 0.00
gc current block pin time 922 0.51 0.04
gc current block receive time 73,024 40.52 3.15
gc current block send time 4,629 2.57 0.20
gc current blocks received 837,378 464.64 36.15
gc current blocks served 1,373,720 762.25 59.30
gc local grants 1,218,240 675.97 52.59
gc remote grants 1,209,287 671.01 52.20
gcs messages sent 3,936,195 2,184.11 169.91
ges messages sent 28,860 16.01 1.25
global enqueue get time 1,739 0.96 0.08
global enqueue gets async 11,538 6.40 0.50
global enqueue gets sync 431,308 239.32 18.62
global enqueue releases 454,879 252.40 19.63
heap block compress 4,615 2.56 0.20
hot buffers moved to head of LRU 3,424,530 1,900.20 147.82
immediate (CR) block cleanout applications 8,681 4.82 0.37
immediate (CURRENT) block cleanout applications 15,118 8.39 0.65
index crx upgrade (found) 1 0.00 0.00
index crx upgrade (positioned) 8,798 4.88 0.38
index fast full scans (full) 57,400 31.85 2.48
index fetch by key 33,093,523 18,362.86 1,428.48
index scans kdiixs1 4,378,705 2,429.65 189.01
leaf node 90-10 splits 57 0.03 0.00
leaf node splits 958 0.53 0.04
lob reads 227,545 126.26 9.82
lob writes 193,660 107.46 8.36
lob writes unaligned 193,512 107.38 8.35
logons cumulative 776 0.43 0.03
messages received 105,150 58.35 4.54
messages sent 105,150 58.35 4.54
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 95,158,056 52,801.08 4,107.48
opened cursors cumulative 309,190 171.56 13.35
parse count (failures) 5,541 3.07 0.24
parse count (hard) 46,690 25.91 2.02
parse count (total) 305,878 169.72 13.20
parse time cpu 1,846 1.02 0.08
parse time elapsed 9,364 5.20 0.40
physical read IO requests 604,242 335.28 26.08
physical read bytes 22,152,691,712 12,292,034.18 956,217.54
physical read total IO requests 816,823 453.24 35.26
physical read total bytes 25,633,155,072 14,223,265.62 1,106,451.21
physical read total multi block requests 228,890 127.01 9.88
physical reads 2,704,186 1,500.49 116.73
physical reads cache 2,405,414 1,334.71 103.83
physical reads cache prefetch 1,919,942 1,065.33 82.87
physical reads direct 298,772 165.78 12.90
physical reads direct (lob) 13,863 7.69 0.60
physical reads direct temporary tablespace 284,004 157.59 12.26
physical reads prefetch warmup 242,689 134.66 10.48
physical write IO requests 66,837 37.09 2.89
physical write bytes 1,086,791,680 603,036.45 46,911.20
physical write total IO requests 119,076 66.07 5.14
physical write total bytes 1,609,488,384 893,069.18 69,473.32
physical write total multi block requests 52,288 29.01 2.26
physical writes 132,665 73.61 5.73
physical writes direct 64,510 35.80 2.78
physical writes direct (lob) 13,719 7.61 0.59
physical writes direct temporary tablespace 50,774 28.17 2.19
physical writes from cache 68,155 37.82 2.94
physical writes non checkpoint 125,257 69.50 5.41
pinned buffers inspected 26 0.01 0.00
pinned cursors current 168 0.09 0.01
prefetch clients - default 4 0.00 0.00
prefetch warmup blocks aged out before use 404,668 224.54 17.47
prefetched blocks aged out before use 33 0.02 0.00
process last non-idle time 1,801 1.00 0.08
queries parallelized 16 0.01 0.00
recovery blocks read 0 0.00 0.00
recursive calls 4,044,993 2,244.48 174.60
recursive cpu usage 29,608 16.43 1.28
redo blocks read for recovery 0 0.00 0.00
redo blocks written 470,138 260.87 20.29
redo entries 351,769 195.19 15.18
redo ordering marks 9,516 5.28 0.41
redo size 226,707,880 125,795.14 9,785.81
redo subscn max counts 2,711 1.50 0.12
redo synch time 2,891 1.60 0.12
redo synch writes 22,989 12.76 0.99
redo wastage 6,404,060 3,553.47 276.43
redo write broadcast ack time 543 0.30 0.02
redo write time 1,488 0.83 0.06
redo writer latching time 1 0.00 0.00
redo writes 24,621 13.66 1.06
rollback changes - undo records applied 689 0.38 0.03
rollbacks only - consistent read gets 266 0.15 0.01
rows fetched via callback 6,208,747 3,445.10 268.00
session connect time 0 0.00 0.00
session cursor cache hits 159,544 88.53 6.89
session logical reads 161,110,930 89,396.86 6,954.33
shared hash latch upgrades - no wait 395,079 219.22 17.05
shared hash latch upgrades - wait 48,743 27.05 2.10
sorts (disk) 3 0.00 0.00
sorts (memory) 177,306 98.38 7.65
sorts (rows) 26,721,264 14,827.03 1,153.42
sql area evicted 44,151 24.50 1.91
sql area purged 5,543 3.08 0.24
summed dirty queue length 11,576 6.42 0.50
switch current to new buffer 9,179 5.09 0.40
table fetch by rowid 31,273,720 17,353.09 1,349.93
table fetch continued row 132,437 73.49 5.72
table scan blocks gotten 42,063,240 23,339.95 1,815.65
table scan rows gotten 713,704,759 396,018.84 30,806.96
table scans (long tables) 3 0.00 0.00
table scans (short tables) 372,091 206.46 16.06
total number of times SMON posted 3 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 4,198 2.33 0.18
transaction tables consistent read rollbacks 13 0.01 0.00
transaction tables consistent reads - undo records applied 1,820 1.01 0.08
undo change vector size 39,345,740 21,832.07 1,698.35
user I/O wait time 214,719 119.14 9.27
user calls 2,269,491 1,259.29 97.96
user commits 22,576 12.53 0.97
user rollbacks 591 0.33 0.03
workarea executions - onepass 32 0.02 0.00
workarea executions - optimal 164,651 91.36 7.11
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 2,654,261,504 3,825,595,776
session cursor cache count 30,938 38,235
session uga memory 65,006,332,592 1.9E+11
opened cursors current 7,320 8,273
logons current 1,128 1,489
session uga memory max 2,650,025,088 3,876,474,440
session pga memory 1,615,687,392 2,047,434,464

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
DATA_OL 286,477 159 4.14 4.19 21,341 12 1,182 4.06
IDX_OL 175,086 97 5.35 1.72 12,450 7 89,581 4.50
TEMP 43,667 24 4.68 6.52 2,680 1 0 0.00
IDX_SCA7 8,538 5 6.09 1.49 10,450 6 0 0.00
DATA_WF 12,614 7 4.10 2.82 2,146 1 41 5.37
IDX_WF 7,126 4 5.14 1.46 4,986 3 14 1.43
DATA_BI 10,733 6 3.85 12.42 11 0 993 1.92
DATA_SCA5 5,757 3 1.10 14.77 46 0 2,273 1.97
DATA_SCA2 5,751 3 1.27 14.83 49 0 2,228 2.29
DATA_SCA3 5,749 3 1.30 14.78 48 0 2,315 2.49
DATA_SCA6 5,724 3 1.08 14.86 41 0 3,229 1.78
DATA_SCA8 5,683 3 1.18 15.02 39 0 3,328 2.06
DATA_SCA4 5,632 3 1.05 15.10 38 0 2,290 1.80
DATA_SCA1 5,622 3 1.08 15.17 41 0 2,318 1.91
DATA_SCA7 5,611 3 1.17 15.18 38 0 3,303 2.11
DATA_P 4,707 3 3.69 9.32 600 0 18 0.56
IDX_P 1,721 1 6.13 1.64 1,434 1 41 0.24
DATA_YP 833 0 3.93 3.71 2,241 1 0 0.00
UNDOTBS1 406 0 3.52 1.00 2,527 1 0 0.00
IDX_SCA 2,215 1 2.36 1.10 414 0 0 0.00
SYSTEM 2,421 1 4.04 1.01 64 0 12 4.17
SYSAUX 1,712 1 4.18 1.09 586 0 0 0.00
IDX_SG 596 0 5.70 1.31 945 1 0 0.00
LOB_SCA 1 0 0.00 1.00 1,060 1 0 0.00
DATA_SG 275 0 3.75 2.03 746 0 0 0.00
IDX_BI 472 0 4.83 1.20 0 0 74 22.97
IDX_SCA3 55 0 6.91 1.65 233 0 0 0.00
IDX_SCA5 46 0 6.09 1.39 226 0 1 0.00
IDX_SCA6 48 0 6.46 1.44 221 0 0 0.00
IDX_SCA4 49 0 11.43 1.88 205 0 2 0.00
IDX_BI1 91 0 6.15 1.84 0 0 0 0.00
DATA_BI12 70 0 5.57 1.00 7 0 0 0.00
DATA_SCA24 21 0 6.67 1.90 51 0 0 0.00
DATA_SCA15 8 0 7.50 1.00 63 0 0 0.00
DATA_SCA13 20 0 7.50 1.10 50 0 0 0.00
DATA_SCA16 24 0 5.42 1.83 46 0 0 0.00
DATA_SCA11 14 0 7.14 1.14 52 0 0 0.00
DATA_SCA12 20 0 7.00 1.35 45 0 0 0.00
DATA_SCA20 15 0 5.33 1.80 49 0 0 0.00
DATA_SCA14 17 0 7.06 1.00 46 0 0 0.00
DATA_SCA21 16 0 6.88 1.00 47 0 0 0.00
DATA_SCA17 18 0 7.22 1.17 44 0 0 0.00
DATA_SCA23 13 0 6.15 1.38 48 0 0 0.00
DATA_SCA10 18 0 5.00 1.44 42 0 0 0.00
DATA_SCA18 17 0 5.88 1.47 43 0 0 0.00
DATA_SCA22 10 0 6.00 1.20 49 0 0 0.00
DATA_SCA19 8 0 3.75 1.00 50 0 0 0.00
DATA_SCA9 6 0 5.00 1.00 50 0 0 0.00
IDX_SCA2 16 0 6.25 1.81 33 0 0 0.00
IDX_SCA1 7 0 5.71 2.14 32 0 0 0.00
IDX_YP 3 0 3.33 1.00 14 0 0 0.00
DATA_BI7 9 0 8.89 3.67 4 0 1 0.00
USERS 7 0 4.29 1.00 0 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
DATA_BI /dev/rndmis_4g_003 324 0 4.44 11.97 0 0 15 3.33
DATA_BI /dev/rndmis_4g_025 843 0 2.93 8.75 0 0 18 3.33
DATA_BI /dev/rndmis_4g_030 800 0 2.66 9.96 0 0 27 2.22
DATA_BI /dev/rndmis_4g_037 489 0 3.80 8.11 0 0 23 1.30
DATA_BI /dev/rndmis_4g_038 488 0 3.03 7.82 0 0 30 2.33
DATA_BI /dev/rndmis_4g_043 302 0 3.81 13.36 0 0 12 1.67
DATA_BI /dev/rndmis_4g_044 284 0 3.63 14.29 0 0 12 1.67
DATA_BI /dev/rndmis_4g_046 269 0 4.13 14.81 0 0 0 0.00
DATA_BI /dev/rndmis_4g_048 389 0 3.19 10.76 0 0 0 0.00
DATA_BI /dev/rndmis_4g_049 233 0 4.12 14.00 0 0 16 0.63
DATA_BI /dev/rndmis_4g_050 186 0 3.98 14.06 0 0 0 0.00
DATA_BI /dev/rndmis_4g_053 300 0 3.67 10.77 1 0 11 2.73
DATA_BI /dev/rndmis_4g_057 223 0 4.17 14.69 0 0 10 2.00
DATA_BI /dev/rndmis_4g_060 321 0 2.90 12.76 0 0 10 3.00
DATA_BI /dev/rndmis_4g_061 343 0 2.92 12.87 0 0 27 3.70
DATA_BI /dev/rndmis_4g_067 292 0 2.81 14.99 0 0 0 0.00
DATA_BI /dev/rndmis_4g_068 250 0 3.32 14.79 0 0 14 1.43
DATA_BI /dev/rndmis_4g_081 232 0 3.58 14.33 0 0 65 1.54
DATA_BI /dev/rndmis_4g_101 210 0 5.48 14.14 0 0 59 1.69
DATA_BI /dev/rndmis_4g_102 193 0 3.83 13.93 0 0 70 1.71
DATA_BI /dev/rndmis_4g_106 286 0 4.62 11.83 0 0 60 1.83
DATA_BI /dev/rndmis_4g_113 264 0 4.36 12.76 1 0 58 1.90
DATA_BI /dev/rndmis_4g_114 182 0 4.51 13.53 0 0 57 1.93
DATA_BI /dev/rndmis_4g_115 174 0 6.26 13.54 0 0 51 2.35
DATA_BI /dev/rndmis_4g_116 243 0 5.51 13.53 0 0 55 1.82
DATA_BI /dev/rndmis_4g_127 253 0 4.98 13.80 0 0 65 1.69
DATA_BI /dev/rndmis_4g_133 227 0 4.76 13.82 0 0 103 1.75
DATA_BI /dev/rndmis_4g_134 188 0 5.16 12.96 0 0 105 1.90
DATA_BI /dev/rndmis_4g_135 199 0 4.87 13.20 0 0 17 0.59
DATA_BI /dev/rndmis_4g_146 205 0 4.34 13.42 0 0 0 0.00
DATA_BI /dev/rndmis_4g_152 161 0 4.22 14.48 0 0 0 0.00
DATA_BI /dev/rndmis_4g_155 223 0 3.77 14.77 0 0 1 0.00
DATA_BI /dev/rndmis_4g_156 225 0 4.31 14.96 0 0 0 0.00
DATA_BI /dev/rndmis_4g_160 237 0 4.60 14.91 0 0 0 0.00
DATA_BI /dev/rndmis_4g_163 223 0 3.41 14.58 0 0 1 10.00
DATA_BI /dev/rndmis_4g_164 233 0 3.95 14.75 0 0 1 10.00
DATA_BI /dev/rndmis_4g_167 239 0 5.06 14.89 9 0 0 0.00
DATA_BI12 /dev/rndmis_8g_023 70 0 5.57 1.00 7 0 0 0.00
DATA_BI7 /dev/rndmis_8g_018 9 0 8.89 3.67 4 0 1 0.00
DATA_OL /dev/rndmis_4g_015 18,481 10 3.96 3.52 347 0 98 4.90
DATA_OL /dev/rndmis_4g_016 15,921 9 3.93 4.06 500 0 124 4.03
DATA_OL /dev/rndmis_4g_017 14,718 8 3.96 4.37 540 0 92 3.04
DATA_OL /dev/rndmis_4g_018 13,882 8 3.96 4.33 503 0 102 4.31
DATA_OL /dev/rndmis_4g_019 14,499 8 3.98 4.12 483 0 177 4.69
DATA_OL /dev/rndmis_4g_020 15,660 9 3.84 4.00 489 0 99 4.55
DATA_OL /dev/rndmis_4g_021 17,235 10 3.60 3.65 347 0 70 4.14
DATA_OL /dev/rndmis_4g_022 17,780 10 3.82 3.96 363 0 79 4.18
DATA_OL /dev/rndmis_4g_023 16,674 9 4.03 3.99 401 0 88 3.64
DATA_OL /dev/rndmis_4g_024 16,540 9 4.01 3.84 544 0 94 3.83
DATA_OL /dev/rndmis_4g_026 6,909 4 4.22 3.28 779 0 21 2.38
DATA_OL /dev/rndmis_4g_028 5,758 3 4.01 4.98 1,002 1 28 3.21
DATA_OL /dev/rndmis_4g_034 6,273 3 3.64 4.76 496 0 2 0.00
DATA_OL /dev/rndmis_4g_035 5,336 3 4.21 5.29 377 0 15 5.33
DATA_OL /dev/rndmis_4g_040 7,718 4 4.18 4.37 425 0 13 3.08
DATA_OL /dev/rndmis_4g_041 6,394 4 4.60 4.74 598 0 13 0.77
DATA_OL /dev/rndmis_4g_058 9,100 5 4.72 3.91 355 0 9 5.56
DATA_OL /dev/rndmis_4g_059 9,761 5 4.37 3.62 345 0 3 3.33
DATA_OL /dev/rndmis_4g_071 8,690 5 4.61 3.43 661 0 0 0.00
DATA_OL /dev/rndmis_4g_072 7,594 4 4.94 3.65 593 0 7 2.86
DATA_OL /dev/rndmis_4g_075 6,880 4 4.73 4.11 984 1 3 0.00
DATA_OL /dev/rndmis_4g_079 4,198 2 5.25 4.28 483 0 6 3.33
DATA_OL /dev/rndmis_4g_080 4,776 3 4.84 3.85 664 0 3 3.33
DATA_OL /dev/rndmis_4g_083 3,523 2 4.88 4.63 586 0 1 10.00
DATA_OL /dev/rndmis_4g_084 3,262 2 4.74 4.77 463 0 0 0.00
DATA_OL /dev/rndmis_4g_085 3,449 2 4.32 4.69 342 0 7 1.43
DATA_OL /dev/rndmis_4g_086 3,624 2 4.27 4.83 284 0 2 10.00
DATA_OL /dev/rndmis_4g_087 3,431 2 4.67 5.06 3,378 2 0 0.00
DATA_OL /dev/rndmis_4g_088 3,675 2 4.55 4.71 281 0 3 3.33
DATA_OL /dev/rndmis_4g_092 3,542 2 4.59 5.13 273 0 0 0.00
DATA_OL /dev/rndmis_4g_210 1,110 1 2.73 11.53 228 0 6 3.33
DATA_OL /dev/rndmis_4g_211 1,960 1 3.05 5.85 673 0 7 4.29
DATA_OL /dev/rndmis_4g_212 400 0 4.35 8.23 50 0 5 2.00
DATA_OL /dev/rndmis_4g_213 1,010 1 3.34 5.40 1,832 1 4 5.00
DATA_OL /dev/rndmis_8g_043 3,106 2 4.76 5.57 422 0 0 0.00
DATA_OL /dev/rndmis_8g_044 3,608 2 4.04 6.75 250 0 1 10.00
DATA_P /dev/rndmis_4g_004 355 0 4.42 7.35 30 0 0 0.00
DATA_P /dev/rndmis_4g_027 261 0 3.72 7.82 38 0 0 0.00
DATA_P /dev/rndmis_4g_031 501 0 3.07 10.89 36 0 0 0.00
DATA_P /dev/rndmis_4g_032 493 0 2.80 12.31 20 0 0 0.00
DATA_P /dev/rndmis_4g_033 442 0 3.05 12.24 59 0 0 0.00
DATA_P /dev/rndmis_4g_064 144 0 2.64 14.38 5 0 0 0.00
DATA_P /dev/rndmis_4g_065 148 0 3.11 13.35 1 0 0 0.00
DATA_P /dev/rndmis_4g_074 124 0 3.63 14.58 4 0 0 0.00
DATA_P /dev/rndmis_4g_099 40 0 3.25 13.55 12 0 0 0.00
DATA_P /dev/rndmis_4g_104 103 0 3.50 14.01 4 0 0 0.00
DATA_P /dev/rndmis_4g_109 103 0 2.14 13.88 1 0 0 0.00
DATA_P /dev/rndmis_4g_121 21 0 8.10 6.90 0 0 0 0.00
DATA_P /dev/rndmis_4g_122 72 0 1.25 15.92 0 0 0 0.00
DATA_P /dev/rndmis_4g_123 12 0 1.67 10.83 0 0 0 0.00
DATA_P /dev/rndmis_4g_124 12 0 4.17 11.17 0 0 0 0.00
DATA_P /dev/rndmis_4g_125 81 0 2.10 14.32 0 0 0 0.00
DATA_P /dev/rndmis_4g_126 1 0 10.00 1.00 0 0 0 0.00
DATA_P /dev/rndmis_4g_128 10 0 5.00 12.80 3 0 0 0.00
DATA_P /dev/rndmis_4g_136 9 0 2.22 14.11 0 0 0 0.00
DATA_P /dev/rndmis_4g_137 74 0 1.89 15.51 0 0 0 0.00
DATA_P /dev/rndmis_4g_138 7 0 8.57 2.71 0 0 0 0.00
DATA_P /dev/rndmis_4g_139 17 0 4.12 8.47 0 0 0 0.00
DATA_P /dev/rndmis_4g_140 1 0 0.00 1.00 0 0 0 0.00
DATA_P /dev/rndmis_4g_141 68 0 2.21 15.06 0 0 0 0.00
DATA_P /dev/rndmis_4g_142 66 0 1.67 15.48 1 0 0 0.00
DATA_P /dev/rndmis_4g_143 77 0 2.08 13.45 0 0 0 0.00
DATA_P /dev/rndmis_4g_144 64 0 1.72 15.94 3 0 0 0.00
DATA_P /dev/rndmis_4g_145 1 0 0.00 1.00 0 0 0 0.00
DATA_P /dev/rndmis_4g_148 162 0 3.02 8.12 23 0 0 0.00
DATA_P /dev/rndmis_4g_149 174 0 6.55 6.64 41 0 0 0.00
DATA_P /dev/rndmis_4g_150 108 0 2.78 9.85 8 0 0 0.00
DATA_P /dev/rndmis_4g_153 42 0 7.14 1.29 35 0 12 0.00
DATA_P /dev/rndmis_4g_154 78 0 5.51 1.06 59 0 0 0.00
DATA_P /dev/rndmis_4g_158 35 0 7.71 1.00 20 0 0 0.00
DATA_P /dev/rndmis_4g_159 56 0 5.18 1.00 5 0 0 0.00
DATA_P /dev/rndmis_4g_165 27 0 8.15 1.00 2 0 0 0.00
DATA_P /dev/rndmis_4g_166 31 0 7.42 1.48 22 0 0 0.00
DATA_P /dev/rndmis_4g_168 115 0 3.91 1.01 7 0 0 0.00
DATA_P /dev/rndmis_4g_169 37 0 3.78 1.00 3 0 6 1.67
DATA_P /dev/rndmis_4g_170 45 0 4.67 1.73 4 0 0 0.00
DATA_P /dev/rndmis_8g_035 216 0 5.05 1.10 69 0 0 0.00
DATA_P /dev/rndmis_8g_038 139 0 5.54 1.22 21 0 0 0.00
DATA_P /dev/rndmis_8g_061 60 0 6.00 1.05 64 0 0 0.00
DATA_P /dev/rndmis_8g_062 75 0 6.67 1.27 0 0 0 0.00
DATA_SCA1 /dev/rndmis_4g_176 5,622 3 1.08 15.17 41 0 2,318 1.91
DATA_SCA10 /dev/rndmis_4g_187 18 0 5.00 1.44 42 0 0 0.00
DATA_SCA11 /dev/rndmis_4g_188 14 0 7.14 1.14 52 0 0 0.00
DATA_SCA12 /dev/rndmis_4g_189 20 0 7.00 1.35 45 0 0 0.00
DATA_SCA13 /dev/rndmis_4g_190 20 0 7.50 1.10 50 0 0 0.00
DATA_SCA14 /dev/rndmis_4g_191 17 0 7.06 1.00 46 0 0 0.00
DATA_SCA15 /dev/rndmis_4g_192 8 0 7.50 1.00 63 0 0 0.00
DATA_SCA16 /dev/rndmis_4g_193 24 0 5.42 1.83 46 0 0 0.00
DATA_SCA17 /dev/rndmis_4g_194 18 0 7.22 1.17 44 0 0 0.00
DATA_SCA18 /dev/rndmis_4g_195 17 0 5.88 1.47 43 0 0 0.00
DATA_SCA19 /dev/rndmis_4g_196 8 0 3.75 1.00 50 0 0 0.00
DATA_SCA2 /dev/rndmis_4g_177 5,751 3 1.27 14.83 49 0 2,228 2.29
DATA_SCA20 /dev/rndmis_4g_197 15 0 5.33 1.80 49 0 0 0.00
DATA_SCA21 /dev/rndmis_4g_198 16 0 6.88 1.00 47 0 0 0.00
DATA_SCA22 /dev/rndmis_4g_199 10 0 6.00 1.20 49 0 0 0.00
DATA_SCA23 /dev/rndmis_4g_200 13 0 6.15 1.38 48 0 0 0.00
DATA_SCA24 /dev/rndmis_4g_201 21 0 6.67 1.90 51 0 0 0.00
DATA_SCA3 /dev/rndmis_4g_178 5,749 3 1.30 14.78 48 0 2,315 2.49
DATA_SCA4 /dev/rndmis_4g_179 5,632 3 1.05 15.10 38 0 2,290 1.80
DATA_SCA5 /dev/rndmis_4g_180 5,757 3 1.10 14.77 46 0 2,273 1.97
DATA_SCA6 /dev/rndmis_4g_181 5,724 3 1.08 14.86 41 0 3,229 1.78
DATA_SCA7 /dev/rndmis_4g_182 5,611 3 1.17 15.18 38 0 3,303 2.11
DATA_SCA8 /dev/rndmis_4g_183 5,683 3 1.18 15.02 39 0 3,328 2.06
DATA_SCA9 /dev/rndmis_4g_186 6 0 5.00 1.00 50 0 0 0.00
DATA_SG /dev/rndmis_4g_009 192 0 3.85 1.92 680 0 0 0.00
DATA_SG /dev/rndmis_8g_013 54 0 2.41 2.46 47 0 0 0.00
DATA_SG /dev/rndmis_8g_014 29 0 5.52 1.93 19 0 0 0.00
DATA_WF /dev/rndmis_4g_005 10,336 6 4.01 3.02 1,449 1 28 1.79
DATA_WF /dev/rndmis_4g_036 1,184 1 4.73 1.87 395 0 13 13.08
DATA_WF /dev/rndmis_4g_107 1,094 1 4.25 1.87 302 0 0 0.00
DATA_YP /dev/rndmis_4g_007 833 0 3.93 3.71 2,241 1 0 0.00
IDX_BI /dev/rndmis_4g_001 134 0 2.99 1.15 0 0 6 6.67
IDX_BI /dev/rndmis_4g_039 14 0 2.86 1.36 0 0 6 0.00
IDX_BI /dev/rndmis_4g_045 11 0 3.64 1.00 0 0 14 2.86
IDX_BI /dev/rndmis_4g_047 10 0 5.00 1.00 0 0 18 0.00
IDX_BI /dev/rndmis_4g_051 9 0 7.78 1.56 0 0 7 8.57
IDX_BI /dev/rndmis_4g_052 9 0 6.67 1.56 0 0 3 6.67
IDX_BI /dev/rndmis_4g_054 7 0 7.14 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_055 9 0 6.67 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_056 11 0 2.73 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_062 6 0 5.00 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_063 6 0 5.00 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_066 6 0 8.33 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_073 9 0 6.67 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_082 9 0 8.89 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_100 8 0 6.25 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_103 8 0 3.75 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_105 9 0 3.33 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_117 11 0 3.64 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_118 8 0 3.75 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_119 17 0 4.71 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_120 18 0 3.33 1.06 0 0 0 0.00
IDX_BI /dev/rndmis_4g_132 14 0 5.71 1.36 0 0 5 226.00
IDX_BI /dev/rndmis_4g_147 17 0 14.12 1.29 0 0 8 15.00
IDX_BI /dev/rndmis_4g_151 16 0 9.38 1.31 0 0 7 41.43
IDX_BI /dev/rndmis_4g_157 42 0 4.29 2.05 0 0 0 0.00
IDX_BI /dev/rndmis_4g_161 12 0 4.17 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_162 6 0 5.00 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_171 9 0 4.44 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_172 7 0 2.86 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_174 11 0 5.45 1.00 0 0 0 0.00
IDX_BI /dev/rndmis_4g_175 9 0 6.67 1.00 0 0 0 0.00
IDX_BI1 /dev/rndmis_8g_016 91 0 6.15 1.84 0 0 0 0.00
IDX_OL /dev/rndmis_4g_011 11,935 7 4.47 1.82 273 0 2,328 3.97
IDX_OL /dev/rndmis_4g_012 12,637 7 4.52 1.85 202 0 2,176 4.40
IDX_OL /dev/rndmis_4g_013 10,752 6 4.47 1.72 233 0 649 4.30
IDX_OL /dev/rndmis_4g_014 10,512 6 4.52 1.70 368 0 636 4.39
IDX_OL /dev/rndmis_4g_029 9,558 5 5.52 1.61 734 0 3,352 4.87
IDX_OL /dev/rndmis_4g_069 13,315 7 5.58 1.88 364 0 10,505 4.39
IDX_OL /dev/rndmis_4g_070 16,882 9 5.77 1.95 273 0 18,794 4.57
IDX_OL /dev/rndmis_4g_076 14,896 8 5.67 1.98 193 0 16,008 4.31
IDX_OL /dev/rndmis_4g_077 6,858 4 5.58 1.41 974 1 1,665 4.08
IDX_OL /dev/rndmis_4g_078 6,244 3 5.65 1.53 796 0 2,113 3.47
IDX_OL /dev/rndmis_4g_089 6,445 4 5.48 1.44 723 0 1,785 4.26
IDX_OL /dev/rndmis_4g_090 8,901 5 5.42 1.43 743 0 2,145 4.21
IDX_OL /dev/rndmis_4g_091 5,985 3 5.66 1.48 780 0 2,172 4.27
IDX_OL /dev/rndmis_4g_093 5,433 3 5.46 1.67 454 0 3,858 4.56
IDX_OL /dev/rndmis_4g_094 5,119 3 5.72 1.53 600 0 3,302 4.62
IDX_OL /dev/rndmis_4g_095 5,172 3 5.45 1.73 573 0 2,826 4.39
IDX_OL /dev/rndmis_4g_096 5,534 3 5.93 1.67 350 0 3,229 4.94
IDX_OL /dev/rndmis_4g_097 3,793 2 5.83 1.71 740 0 1,756 4.98
IDX_OL /dev/rndmis_4g_098 3,979 2 5.61 1.67 786 0 2,804 4.38
IDX_OL /dev/rndmis_4g_108 2,667 1 5.66 1.60 677 0 1,364 4.95
IDX_OL /dev/rndmis_4g_110 2,155 1 6.04 1.54 362 0 1,258 5.47
IDX_OL /dev/rndmis_4g_111 2,069 1 5.99 1.60 382 0 1,559 5.50
IDX_OL /dev/rndmis_4g_112 1,643 1 5.95 1.72 272 0 1,051 5.85
IDX_OL /dev/rndmis_8g_024 1,243 1 6.11 1.93 315 0 1,104 5.07
IDX_OL /dev/rndmis_8g_025 1,359 1 5.71 2.24 283 0 1,142 4.58
IDX_P /dev/rndmis_4g_002 426 0 5.26 1.33 247 0 0 0.00
IDX_P /dev/rndmis_4g_130 324 0 6.11 1.58 263 0 7 0.00
IDX_P /dev/rndmis_4g_131 285 0 7.44 1.30 195 0 29 0.34
IDX_P /dev/rndmis_4g_173 282 0 6.06 1.70 352 0 3 0.00
IDX_P /dev/rndmis_4g_217 223 0 6.01 2.17 198 0 2 0.00
IDX_P /dev/rndmis_4g_218 181 0 6.41 2.23 179 0 0 0.00
IDX_SCA /dev/rndmis_4g_208 1,271 1 2.95 1.18 382 0 0 0.00
IDX_SCA /dev/rndmis_4g_219 944 1 1.56 1.00 32 0 0 0.00
IDX_SCA1 /dev/rndmis_4g_184 7 0 5.71 2.14 32 0 0 0.00
IDX_SCA2 /dev/rndmis_4g_185 16 0 6.25 1.81 33 0 0 0.00
IDX_SCA3 /dev/rndmis_4g_202 34 0 7.35 1.91 73 0 0 0.00
IDX_SCA3 /dev/rndmis_4g_220 21 0 6.19 1.24 160 0 0 0.00
IDX_SCA4 /dev/rndmis_4g_203 11 0 5.45 2.18 57 0 0 0.00
IDX_SCA4 /dev/rndmis_4g_221 38 0 13.16 1.79 148 0 2 0.00
IDX_SCA5 /dev/rndmis_4g_204 18 0 6.11 1.94 101 0 0 0.00
IDX_SCA5 /dev/rndmis_4g_222 28 0 6.07 1.04 125 0 1 0.00
IDX_SCA6 /dev/rndmis_4g_205 22 0 5.00 1.00 107 0 0 0.00
IDX_SCA6 /dev/rndmis_4g_223 26 0 7.69 1.81 114 0 0 0.00
IDX_SCA7 /dev/rndmis_8g_011 6,796 4 6.06 1.51 8,315 5 0 0.00
IDX_SCA7 /dev/rndmis_8g_034 1,742 1 6.22 1.40 2,135 1 0 0.00
IDX_SG /dev/rndmis_4g_010 596 0 5.70 1.31 945 1 0 0.00
IDX_WF /dev/rndmis_4g_006 5,296 3 5.15 1.44 3,448 2 14 1.43
IDX_WF /dev/rndmis_4g_042 1,830 1 5.12 1.52 1,538 1 0 0.00
IDX_YP /dev/rndmis_4g_008 3 0 3.33 1.00 14 0 0 0.00
LOB_SCA /dev/rndmis_8g_006 1 0 0.00 1.00 3 0 0 0.00
LOB_SCA /dev/rndmis_8g_026 0 0     671 0 0 0.00
LOB_SCA /dev/rndmis_8g_039 0 0     1 0 0 0.00
LOB_SCA /dev/rndmis_8g_040 0 0     385 0 0 0.00
SYSAUX /dev/rndmis_4g_225 106 0 4.06 1.92 56 0 0 0.00
SYSAUX /dev/rsysaux_4g 1,606 1 4.18 1.04 530 0 0 0.00
SYSTEM /dev/rsystem_4g 2,421 1 4.04 1.01 64 0 12 4.17
TEMP /dev/rndmis_8g_056 3,703 2 8.31 6.88 1,188 1 0  
TEMP /dev/rtemp01_16g 39,601 22 4.34 6.40 1,077 1 0  
TEMP /dev/rtemp02_16g 363 0 4.77 16.21 415 0 0  
UNDOTBS1 /dev/rndmis_8g_030 4 0 12.50 1.00 476 0 0 0.00
UNDOTBS1 /dev/rndmis_8g_031 0 0     142 0 0 0.00
UNDOTBS1 /dev/rndmis_8g_036 1 0 10.00 1.00 347 0 0 0.00
UNDOTBS1 /dev/rundo_1a_16g 257 0 3.54 1.00 784 0 0 0.00
UNDOTBS1 /dev/rundo_1b_16g 144 0 3.19 1.00 778 0 0 0.00
USERS /dev/rusers_4g 7 0 4.29 1.00 0 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 2,747,061 99 161,022,355 2,409,322 68,139 0 0 113,388


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 9 13000 59532 5640120 5640120    
E 0 7 8433 65975 472157 5640120 472157  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 2,288 0.10 274,131 3.42 11,601,535
D 4,576 0.20 548,262 2.53 8,592,547
D 6,864 0.30 822,393 1.90 6,452,105
D 9,152 0.40 1,096,524 1.59 5,399,631
D 11,440 0.50 1,370,655 1.32 4,494,965
D 13,728 0.60 1,644,786 1.19 4,028,382
D 16,016 0.70 1,918,917 1.12 3,795,788
D 18,304 0.80 2,193,048 1.08 3,649,936
D 20,592 0.90 2,467,179 1.03 3,498,687
D 22,880 1.00 2,741,310 1.00 3,398,450
D 22,944 1.00 2,748,978 1.00 3,395,065
D 25,168 1.10 3,015,441 0.98 3,330,456
D 27,456 1.20 3,289,572 0.97 3,299,118
D 29,744 1.30 3,563,703 0.96 3,254,139
D 32,032 1.40 3,837,834 0.95 3,232,287
D 34,320 1.50 4,111,965 0.95 3,230,343
D 36,608 1.60 4,386,096 0.95 3,230,343
D 38,896 1.70 4,660,227 0.95 3,230,343
D 41,184 1.80 4,934,358 0.95 3,230,343
D 43,472 1.89 5,208,489 0.95 3,230,343
D 45,760 1.99 5,482,620 0.95 3,230,343

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
98.54 18,453 273

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,614 1,423.89 2.22 0.16 100.00 0.00 629,140
E 6,144 4,422 1,671.13 1.13 0.07 100.00 0.00 629,140

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 138,039 138,039 0 0
64K 128K 2,491 2,491 0 0
128K 256K 2,498 2,498 0 0
256K 512K 3,263 3,263 0 0
512K 1024K 17,562 17,562 0 0
1M 2M 594 594 0 0
2M 4M 175 175 0 0
4M 8M 33 5 28 0
8M 16M 19 19 0 0
16M 32M 14 10 4 0
32M 64M 2 2 0 0
64M 128M 9 9 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 29,546.51 9,955.76 75.00 512
1,536 0.25 29,546.51 411.12 99.00 1
3,072 0.50 29,546.51 411.12 99.00 0
4,608 0.75 29,546.51 411.12 99.00 0
6,144 1.00 29,546.51 33.04 100.00 0
7,373 1.20 29,546.51 0.00 100.00 0
8,602 1.40 29,546.51 0.00 100.00 0
9,830 1.60 29,546.51 0.00 100.00 0
11,059 1.80 29,546.51 0.00 100.00 0
12,288 2.00 29,546.51 0.00 100.00 0
18,432 3.00 29,546.51 0.00 100.00 0
24,576 4.00 29,546.51 0.00 100.00 0
36,864 6.00 29,546.51 0.00 100.00 0
49,152 8.00 29,546.51 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,096 0.60 405 43,510 629,431 0.99 24,647 1.44 3,072
2,448 0.70 747 68,631 635,309 1.00 18,769 1.09 3,080
2,800 0.80 1,096 86,395 636,259 1.00 17,819 1.04 3,082
3,152 0.90 1,447 103,203 636,936 1.00 17,142 1.00 3,083
3,504 1.00 1,745 117,778 636,936 1.00 17,142 1.00 3,083
3,856 1.10 1,780 119,414 636,936 1.00 17,142 1.00 3,083
4,208 1.20 1,780 119,414 636,936 1.00 17,142 1.00 3,083
4,560 1.30 1,780 119,414 636,936 1.00 17,142 1.00 3,083
4,912 1.40 1,780 119,414 636,936 1.00 17,142 1.00 3,083
5,264 1.50 1,780 119,414 636,936 1.00 17,142 1.00 3,083
5,616 1.60 1,780 119,414 636,936 1.00 17,142 1.00 3,083
5,968 1.70 1,780 119,414 636,936 1.00 17,142 1.00 3,083
6,320 1.80 1,780 119,414 636,936 1.00 17,142 1.00 3,083
6,672 1.90 1,780 119,414 636,936 1.00 17,142 1.00 3,083
7,024 2.00 1,780 119,414 636,936 1.00 17,142 1.00 3,083

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 134,039 8,592,476
13,312 0.50 99,503 4,495,017
19,968 0.75 86,116 3,795,641
26,624 1.00 82,740 3,395,028
33,280 1.25 81,549 3,254,134
39,936 1.50 81,350 3,230,369
46,592 1.75 81,351 3,230,369
53,248 2.00 81,351 3,230,369

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

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 113,215 455 4
segment header 128 0 0
1st level bmb 22 0 0
2nd level bmb 6 0 0
undo block 5 0 0
undo header 3 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 11 11 0 9 10 1,081.33
WF-AWR Flush 20 20 0 12 1 48.67
TM-DML 62,108 62,108 0 75 0 0.99
TX-Transaction (index contention) 147 147 0 37 0 1.46
FB-Format Block 183 183 0 93 0 0.52
PS-PX Process Reservation 142 142 0 74 0 0.62
CF-Controlfile Transaction 4,286 4,286 0 60 0 0.48
HW-Segment High Water Mark 2,220 2,220 0 53 0 0.47
TT-Tablespace 2,559 2,559 0 75 0 0.31
TO-Temp Object 646 646 0 7 0 0.57
TA-Instance Undo 12 12 0 9 0 0.33
TX-Transaction (allocate ITL entry) 7 7 0 2 0 1.00
FU-DBFUS 1 1 0 1 0 2.00
JQ-Job Queue 30 30 0 3 0 0.33
SR-Synchronized Replication 222 222 0 3 0 0.33
DR-Distributed Recovery 1 1 0 1 0 1.00
PE-Parameter 8 8 0 1 0 1.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 1 0 1 1 0 1.00
PG-Global Parameter 4 4 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 12.75 48,110 664 32 24752.5/38770.8 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
27-Mar 18:05 2,142 10,583 95 7 24,753 0/0 0/0/0/0/0/0
27-Mar 17:55 2,144 11,024 664 6 24,856 0/0 0/0/0/0/0/0
27-Mar 17:45 5,719 15,543 90 10 24,993 0/0 0/0/0/0/0/0
27-Mar 17:35 2,744 10,960 175 32 38,771 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 58,115 0.00   0 0  
Consistent RBA 24,637 0.00   0 0  
FAL request queue 36 0.00   0 0  
FAL subheap alocation 36 0.00   0 0  
FIB s.o chain latch 8 0.00   0 0  
FOB s.o list latch 9,877 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 2 0.00
JS queue access latch 2 0.00   0 0  
JS queue state obj latch 17,280 0.00   0 0  
JS slv state obj latch 52 0.00   0 0  
KCL gc element parent latch 16,677,452 0.05 0.01 0 11,961 0.08
KJC destination ctx free list 0     0 2 0.00
KJC message pool free list 161,677 0.10 0.00 0 105,286 0.02
KJC receiver ctx free list 0     0 2 0.00
KJCT flow control latch 2,654,757 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 648 0.00   0 0  
KMG resize request state object freelist 6 0.00   0 0  
KSXR large replies 122 0.00   0 0  
KTF sga latch 8,476 0.00   0 606 0.00
KWQMN job cache list latch 767 0.26 1.00 0 0  
KWQP Prop Status 224 0.00   0 0  
MQL Tracking Latch 0     0 36 0.00
Memory Management Latch 84 1.19 0.00 0 645 0.00
Memory Queue 222 0.00   0 0  
OS process 1,104 0.00   0 0  
OS process allocation 1,698 0.00   0 0  
OS process: request allocation 1,021 0.00   0 0  
PL/SQL warning settings 22,538 0.00   0 0  
SGA IO buffer pool latch 107,383 0.03 0.00 0 107,382 0.04
SQL memory manager latch 1 0.00   0 599 0.00
SQL memory manager workarea list latch 222,741 0.00 0.00 0 0  
Shared B-Tree 1,377 0.00   0 0  
active checkpoint queue latch 52,577 0.02 0.00 0 2 0.00
active service list 7,997 0.54 0.00 0 713,609 0.00
alert log latch 0     0 2 0.00
archive control 42 0.00   0 0  
archive process latch 671 0.00   0 0  
begin backup scn array 12,027 0.00   0 0  
bq:time manger info latch 64 0.00   0 0  
buffer pool 3 0.00   0 0  
bufq statistics 224 0.00   0 0  
business card 32 0.00   0 0  
cache buffer handles 186,591 0.00 0.00 0 0  
cache buffers chains 271,176,772 0.36 0.04 1 29,149,184 0.01
cache buffers lru chain 3,817,395 0.04 0.02 1 6,214,129 0.05
cache table scan latch 0     0 125,183 0.06
channel handle pool latch 1,054 0.00   0 0  
channel operations parent latch 566,998 0.00 0.00 0 0  
checkpoint queue latch 995,074 0.00 0.00 0 77,693 0.00
client/application info 5,819 0.02 0.00 0 0  
commit callback allocation 112 0.00   0 0  
compile environment latch 775 0.00   0 0  
dml lock allocation 124,206 0.02 0.00 0 0  
dummy allocation 1,191 1.43 0.00 0 0  
enqueue hash chains 815,428 0.01 0.00 0 1,387 0.00
enqueues 924,976 0.03 0.00 0 0  
error message lists 74 0.00   0 0  
event group latch 691 0.00   0 0  
file cache latch 2,440 0.00   0 0  
gcs opaque info freelist 2,255,822 0.14 0.00 0 0  
gcs partitioned table hash 34,667,590 0.00   0 10,351 0.00
gcs remaster request queue 4 0.00   0 0  
gcs remastering latch 2,484,364 0.00 0.33 0 25,589 0.01
gcs resource freelist 2,560,051 0.01 0.05 0 372,971 0.01
gcs resource hash 13,422,319 0.22 0.00 0 8 0.00
gcs resource scan list 16 0.00   0 0  
gcs shadows freelist 577,929 0.00   0 1,280,163 0.00
ges caches resource lists 202,694 0.01 0.00 0 50,217 0.01
ges deadlock list 2,124 0.00   0 2 0.00
ges domain table 858,710 0.02 0.00 0 0  
ges enqueue table freelist 866,951 0.00 0.00 0 0  
ges group table 1,286,602 0.00 0.00 0 0  
ges process hash list 30,141 0.00   0 0  
ges process parent latch 1,795,973 0.00   0 0  
ges process table freelist 1,021 0.00   0 0  
ges resource hash list 1,310,187 0.05 0.00 0 26,071 0.00
ges resource scan list 102 0.00   0 0  
ges resource table freelist 33,355 0.00   0 130 0.00
ges synchronous data 64 3.13 0.00 0 6,009 0.05
ges timeout list 12,536 0.00   0 6,597 0.00
global KZLD latch for mem in SGA 668 0.00   0 0  
global hanganlyze operation 21 0.00   0 0  
global tx hash mapping 25,600 0.00   0 0  
hash table column usage latch 1,179 0.00   0 542,414 0.00
hash table modification latch 228 0.00   0 2 0.00
internal temp table object number allocation latc 45 0.00   0 0  
interrupt manipulation 393 0.00   0 0  
job workq parent latch 0     0 60 0.00
job_queue_processes free list latch 0     0 2 0.00
job_queue_processes parameter latch 60 0.00   0 0  
kks stats 255,042 0.02 0.00 0 0  
kokc descriptor allocation latch 8,946 0.00   0 0  
ksuosstats global area 122 0.00   0 0  
ktm global data 369 0.00   0 0  
kwqbsn:qsga 1,094 0.00   0 0  
lgwr LWN SCN 24,665 0.02 0.25 0 0  
library cache 5,990,918 0.04 0.00 0 51,758 0.06
library cache load lock 3,181 0.00   0 0  
library cache lock 9,602,391 0.01 0.00 0 0  
library cache lock allocation 15,674 0.00   0 0  
library cache pin 1,504,291 0.03 0.00 0 0  
library cache pin allocation 47,040 0.00   0 0  
list of block allocation 1,863 0.00   0 0  
loader state object freelist 11,706 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 19 0.00   0 19 0.00
message pool operations parent latch 630 0.00   0 0  
messages 374,683 0.04 0.00 0 0  
mostly latch-free SCN 25,147 1.72 0.00 0 0  
multiblock read objects 744,863 0.03 0.00 0 1 0.00
name-service memory objects 26,663 0.00   0 3 0.00
name-service namespace bucket 25,199 0.00   0 0  
name-service namespace objects 0     0 2 0.00
name-service pending queue 14,014 0.00   0 0  
name-service request queue 37,543 0.00   0 0  
ncodef allocation latch 42 0.00   0 0  
object queue header heap 270,701 0.00 0.00 0 71,749 0.00
object queue header operation 7,466,390 0.04 0.55 31 3,811 0.05
object stats modification 1,050 0.10 0.00 0 0  
parallel query alloc buffer 848 0.00   0 0  
parallel query stats 103 0.00   0 0  
parallel txn reco latch 10,450 0.00   0 0  
parameter list 5,635 0.83 0.00 0 0  
parameter table management 1,318 0.00   0 0  
post/wait queue 56,554 0.04 0.00 0 22,764 0.00
process allocation 12,677 0.02 0.00 0 690 0.14
process group creation 1,021 0.00   0 0  
process queue 278 0.00   0 0  
process queue reference 5,217 0.00   0 505 0.00
qmn task queue latch 2,162 23.96 0.05 0 0  
query server freelists 216 0.00   0 0  
queued dump request 8,995 0.00   0 0  
redo allocation 123,519 0.02 0.00 0 351,704 0.06
redo copy 0     0 351,788 0.13
redo writing 127,937 0.02 0.00 0 0  
resmgr group change latch 928 0.00   0 0  
resmgr:active threads 1,180 0.00   0 0  
resmgr:actses change group 757 0.00   0 0  
resmgr:free threads list 1,179 2.71 0.00 0 0  
resmgr:resource group CPU method 396 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 7,192,252 0.14 0.00 0 4,829 0.06
rules engine aggregate statistics 2 0.00   0 0  
rules engine evaluation context statistics 0     0 2 0.00
rules engine rule set statistics 104 0.00   0 0  
sequence cache 11,779 1.12 0.00 0 0  
session allocation 1,441,039 0.10 0.00 0 0  
session idle bit 5,246,629 0.00 0.00 0 0  
session state list latch 1,664 4.39 0.00 0 0  
session switching 1,692 0.00   0 0  
session timer 830 0.00   0 0  
shared pool 2,684,007 0.05 0.00 0 0  
shared pool sim alloc 2,969 0.03 0.00 0 0  
shared pool simulator 256,005 0.00 0.00 0 0  
simulator hash latch 8,136,263 0.00 0.00 0 0  
simulator lru latch 835 0.00   0 7,759,465 0.64
slave class 6 0.00   0 0  
slave class create 24 4.17 1.00 0 0  
sort extent pool 5,138 0.06 0.00 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 1,008 0.00   0 0  
temp lob duration state obj allocation 12 0.00   0 0  
temporary table state object allocation 48 0.00   0 0  
threshold alerts latch 829 0.00   0 0  
trace latch 34 0.00   0 0  
transaction allocation 2,469,776 0.00   0 104 0.00
transaction branch allocation 22,012 0.00   0 0  
undo global data 169,328 0.01 0.00 0 0  
user lock 2,041 2.60 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 271,176,772 982,599 38,875 944,478 0 0 0
gcs resource hash 13,422,319 29,392 58 29,342 0 0 0
KCL gc element parent latch 16,677,452 8,439 102 8,344 0 0 0
object queue header operation 7,466,390 2,812 1,549 1,380 0 0 0
library cache 5,990,918 2,685 5 2,680 0 0 0
session allocation 1,441,039 1,498 4 1,494 0 0 0
cache buffers lru chain 3,817,395 1,492 30 1,462 0 0 0
shared pool 2,684,007 1,250 5 1,245 0 0 0
qmn task queue latch 2,162 518 27 491 0 0 0
mostly latch-free SCN 25,147 433 1 432 0 0 0
gcs resource freelist 2,560,051 192 9 184 0 0 0
gcs remastering latch 2,484,364 12 4 8 0 0 0
lgwr LWN SCN 24,665 4 1 3 0 0 0
KWQMN job cache list latch 767 2 2 0 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 386 77
KCL gc element parent latch kclple_1 0 30 0
KCL gc element parent latch kclplz 0 26 64
KCL gc element parent latch kclnfnd 0 16 21
KCL gc element parent latch kclbla 0 12 1
KCL gc element parent latch kclzcl 0 10 91
KCL gc element parent latch KCLUNLNK 0 8 146
KCL gc element parent latch kclgcr 0 2 0
KCL gc element parent latch kclrwrite 0 2 1
KCL gc element parent latch kclulb 0 2 58
KCL gc element parent latch kclfwrite2 0 1 0
KCL gc element parent latch kclwrt 0 1 1
KWQMN job cache list latch kwqmnprsc: loop 0 2 0
active service list kswslogon: session login 0 33 33
cache buffers chains kcbgtcr: kslbegin shared 0 28,960 16,764
cache buffers chains kcbgtcr: kslbegin excl 0 24,178 43,247
cache buffers chains kcbgtcr: fast path 0 14,389 7,636
cache buffers chains kcbzwb 0 1,501 1,420
cache buffers chains kcbgtcr 0 390 459
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 86 45
cache buffers chains kcbrls: kslbegin 0 52 144
cache buffers chains kcbzgb: scan from tail. nowait 0 24 0
cache buffers chains kcbzib: multi-block read: nowait 0 14 0
cache buffers chains kcbgcur: kslbegin 0 8 8
cache buffers chains kclgrantlk_1 0 7 6
cache buffers chains kcbzib: finish free bufs 0 5 0
cache buffers chains kclgrantlk_2 0 4 36
cache buffers chains kcbget: pin buffer 0 3 0
cache buffers chains kclebs_1 0 1 3
cache buffers chains kclgrantlk 0 1 0
cache buffers lru chain kcbzgb: wait - one set in buffer pool 0 13 18
cache buffers lru chain kcbzib 0 7 1
cache buffers lru chain kcbzgws 0 3 0
cache buffers lru chain kcbibr 0 2 3
cache buffers lru chain kcbzib: move stale buffers 0 2 4
cache buffers lru chain kcbbxsv: move to being written 0 1 6
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 1 0
cache buffers lru chain kcbzfw 0 1 0
event range base latch No latch 0 27 27
gcs remastering latch 43 0 3 0
gcs remastering latch 69 0 1 0
gcs resource freelist kjbralc add resource 0 6 6
gcs resource freelist kjbrralc: reserve allocation 0 3 0
gcs resource hash kjbcropen:affinity 0 36 16
gcs resource hash kjbrrcfwst 0 21 0
gcs resource hash kjbrdrmcvtq_98 0 1 0
library cache kglhdgn: child: 0 1 0
library cache kglnti 0 1 0
library cache kglobpn: child: 0 1 0
library cache lock kgllkdl: child: no lock handle 0 2 1
mostly latch-free SCN kcs024 0 1 0
mostly latch-free SCN kcslcu3 0 1 2
object queue header operation kclobj_1 0 1,295 449
object queue header operation kclobj_2 0 210 157
object queue header operation kclobj_3 0 43 23
object queue header operation kcbw_unlink_q 0 11 436
object queue header operation kcbw_link_q 0 3 426
object queue header operation kcbo_switch_mq_bg 0 2 7
object queue header operation kcbo_ivbo 0 1 29
object queue header operation kcbo_switch_cq 0 1 4
session allocation kspallmod 0 1 0
session allocation ksucri 0 1 3
session allocation ksufap: active sessions 0 1 0
session allocation ksuxds: not user session 0 1 1
shared pool kghalo 0 3 2
shared pool kghfrunp: alloc: cursor dur 0 1 0
shared pool kghupr1 0 1 3
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
PMS IDX_P PK_RECORD_ID   INDEX 21,331,168 13.24
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 18,909,104 11.74
OLIVE IDX_OL PK_OL$_ATTR_DEFS   INDEX 18,596,944 11.54
AMBER IDX_WF UK_USER_ACTION_BAK   INDEX 16,236,288 10.08
OLIVE DATA_OL OL$_CLASSES   TABLE 13,533,456 8.40

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
OLIVE DATA_OL OL$_STATUS_LOG   TABLE 155,016 5.73
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 154,337 5.71
OLIVE DATA_OL OL$_ASSOCIATIONS   TABLE 149,911 5.54
OLIVE IDX_OL OL$_ASSOCIATIONS_N1   INDEX 41,349 1.53
OLIVE DATA_OL OL$_OBJECTS_R01 P_1340308 TABLE PARTITION 33,061 1.22

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 22 14.97
OLIVE IDX_OL OL$_EVENT_LOG_D1   INDEX 18 12.24
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 11 7.48
OLIVE DATA_OL OL$_OBJECTS_R01 P_1340606 TABLE PARTITION 10 6.80
SCADA IDX_SCA3 IDX_MEASURE_N2 P201303_S1 INDEX SUBPARTITION 9 6.12

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
SCADA IDX_SCA5 IDX_MEASURE_N2 P201303_S7 INDEX SUBPARTITION 1 25.00
OLIVE IDX_OL OL$_EVENT_LOG_D1   INDEX 1 25.00
AMBER IDX_WF PK_INDY_USER_ACTION_BAK   INDEX 1 25.00
AMBER IDX_WF UK_USER_ACTION_BAK   INDEX 1 25.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
AMBER DATA_WF SP_QUERY_DEF   TABLE 4 30.77
SCADA IDX_SCA4 IDX_MEASURE_N2 P201303_S6 INDEX SUBPARTITION 2 15.38
OLIVE DATA_OL T_EQUIMODIFY_DETAIL_N1   INDEX 2 15.38
SCADA IDX_SCA5 IDX_MEASURE_N2 P201303_S3 INDEX SUBPARTITION 1 7.69
AMBER IDX_WF IDX_USE_LOG   INDEX 1 7.69

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 88,409 87.41
SCADA DATA_SCA1 SCADA_INTERFACE_DATA_BD P201303_S1 TABLE SUBPARTITION 1,326 1.31
SCADA DATA_SCA3 SCADA_INTERFACE_DATA_BD P201303_S3 TABLE SUBPARTITION 1,294 1.28
SCADA DATA_SCA4 SCADA_INTERFACE_DATA_BD P201303_S4 TABLE SUBPARTITION 1,291 1.28
SCADA DATA_SCA5 SCADA_INTERFACE_DATA_BD P201303_S5 TABLE SUBPARTITION 1,278 1.26

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 4,923 13.57
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 1,369 3.77
OLIVE IDX_OL NK_OL$_REFS_URI_B   INDEX 839 2.31
OLIVE DATA_OL OL$_ASSOCIATIONS   TABLE 659 1.82
AMBER DATA_WF SP_QUERY_DEF   TABLE 474 1.31

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
AMBER DATA_WF INDY_USE_LOG0308   TABLE 257,192 30.71
PMS DATA_P T_QX_QXXX   TABLE 44,453 5.31
PMSBI DATA_BI F_SCADA_KGTZJL   TABLE 32,897 3.93
OLIVE IDX_OL OL$_OBJECTS_U1   INDEX 31,558 3.77
PMS DATA_P T_YX_LOG_SUMMARY   TABLE 29,480 3.52

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 123,721 0.00 0   0 7
dc_files 6,975 0.00 0   0 279
dc_global_oids 5,223 0.27 0   0 137
dc_histogram_data 850,763 0.91 0   0 32,103
dc_histogram_defs 297,289 1.95 0   4 12,270
dc_object_grants 302 6.62 0   0 120
dc_object_ids 687,868 0.07 0   2 1,271
dc_objects 89,566 0.61 0   4 1,112
dc_profiles 698 0.00 0   0 1
dc_rollback_segments 21,576 0.00 0   0 952
dc_segments 68,450 5.70 0   20 5,175
dc_sequences 70 18.57 0   70 1
dc_table_scns 112 0.89 0   0 5
dc_tablespace_quotas 52 36.54 0   0 18
dc_tablespaces 230,923 0.00 0   0 68
dc_usernames 4,052 0.07 0   0 23
dc_users 565,751 0.00 0   0 82
outstanding_alerts 400 98.00 0   2 134

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 3 1 0
dc_database_links 1 0 1
dc_global_oids 14 0 23
dc_histogram_defs 5,784 0 7,924
dc_object_ids 475 0 1,755
dc_objects 546 0 1,153
dc_segments 3,925 14 14,721
dc_sequences 140 14 3
dc_table_scns 1 0 2
dc_tablespace_quotas 45 9 27
dc_usernames 3 0 28
dc_users 1 0 2
outstanding_alerts 796 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 1,034 0.77 138,582 0.01 2 0
CLUSTER 43 0.00 53 1.89 1 0
INDEX 6,732 0.24 92,938 0.02 6 0
JAVA DATA 4 50.00 8 37.50 1 0
JAVA RESOURCE 4 50.00 8 37.50 1 0
JAVA SOURCE 4 50.00 8 37.50 1 0
SQL AREA 193,167 43.65 3,620,975 3.73 3,006 1
TABLE/PROCEDURE 20,192 1.81 485,675 0.31 339 0
TRIGGER 104 1.92 1,365 0.22 1 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 53 0 0 0 0
INDEX 92,938 16 18 14 0
JAVA DATA 8 2 0 0 0
JAVA RESOURCE 8 2 1 0 0
JAVA SOURCE 8 2 1 0 0
TABLE/PROCEDURE 135,592 422 32 289 0
TRIGGER 8 2 3 0 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,126.45   1.00 2.50 68 68 1,131 1,131
  Freeable 238.25 0.00 0.90 1.01 14   265 265
  PL/SQL 33.28 27.71 0.03 0.01 0 0 1,129 1,129
  SQL 23.05 3.88 0.02 0.04 0 123 1,094 1,090
E Other 1,357.26   0.91 2.23 68 68 1,492 1,492
  Freeable 248.31 0.00 0.93 1.00 14   267 267
  PL/SQL 43.10 36.84 0.03 0.01 0 0 1,490 1,490
  SQL 23.63 2.85 0.02 0.04 0 124 1,456 1,451

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 112.00 112.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 155.72 207.98 33.56
shared Checkpoint queue 62.52 62.52 0.00
shared KQR L PO 34.97   -100.00
shared PCursor 106.92 153.75 43.80
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 803.60 700.00 -12.89
shared gcs resources 481.61 521.96 8.38
shared gcs shadows 288.41 288.41 0.00
shared ges enqueues 61.10 61.22 0.19
shared library cache 80.61 132.86 64.81
shared sql area 642.54 547.08 -14.86
shared sql area:PLSQL   46.94  
streams free memory 31.99 31.99 0.00
  buffer_cache 22,960.00 22,928.00 -0.14
  fixed_sga 2.05 2.05 0.00
  log_buffer 45.95 45.95 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves 290,000 28,275 0
QMON Coordinator 220,000 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

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

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 1,770,662 2,716,849 3116763 3116763


Back to Top

init.ora Parameters

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


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 10,217 5.67 0.44
acks for commit broadcast(logical) 10,950 6.08 0.47
broadcast msgs on commit(actual) 24,561 13.63 1.06
broadcast msgs on commit(logical) 24,621 13.66 1.06
broadcast msgs on commit(wasted) 2,466 1.37 0.11
broadcast on commit wait time(ms) 4,864 2.70 0.21
broadcast on commit waits 20,655 11.46 0.89
dynamically allocated gcs resources 261,120 144.89 11.27
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 2 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 696,421 386.43 30.06
gcs ast xid 0 0.00 0.00
gcs blocked converts 23,839 13.23 1.03
gcs blocked cr converts 40,192 22.30 1.73
gcs compatible basts 998 0.55 0.04
gcs compatible cr basts (global) 4,276 2.37 0.18
gcs compatible cr basts (local) 1,103,580 612.35 47.64
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,363 3.53 0.27
gcs dbwr write request msgs 4,897 2.72 0.21
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 9,238 5.13 0.40
gcs immediate (null) converts 28,411 15.76 1.23
gcs immediate cr (compatible) converts 42,328 23.49 1.83
gcs immediate cr (null) converts 1,531,183 849.62 66.09
gcs indirect ast 77,084 42.77 3.33
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 1,888 1.05 0.08
gcs msgs process time(ms) 129,044 71.60 5.57
gcs msgs received 3,667,933 2,035.25 158.33
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 42,330 23.49 1.83
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 2 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 1 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 159,163 88.32 6.87
gcs side channel msgs actual 64,760 35.93 2.80
gcs side channel msgs logical 1,021,674 566.90 44.10
gcs stale cr 905 0.50 0.04
gcs undo cr 57 0.03 0.00
gcs write notification msgs 614 0.34 0.03
gcs writes refused 26 0.01 0.00
ges msgs process time(ms) 204 0.11 0.01
ges msgs received 15,403 8.55 0.66
global posts dropped 0 0.00 0.00
global posts queue time 73 0.04 0.00
global posts queued 9 0.00 0.00
global posts requested 9 0.00 0.00
global posts sent 9 0.00 0.00
implicit batch messages received 74,637 41.41 3.22
implicit batch messages sent 199,616 110.76 8.62
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 35,469 19.68 1.53
messages queue sent actual 377,334 209.37 16.29
messages queue sent logical 1,289,714 715.63 55.67
messages received actual 913,999 507.16 39.45
messages received logical 3,683,380 2,043.83 158.99
messages sent directly 356,594 197.87 15.39
messages sent indirectly 1,229,416 682.18 53.07
messages sent not implicit batched 177,736 98.62 7.67
messages sent pbatched 2,371,868 1,316.10 102.38
msgs causing lmd to send msgs 5,176 2.87 0.22
msgs causing lms(s) to send msgs 128,414 71.25 5.54
msgs received queue time (ms) 104,596 58.04 4.51
msgs received queued 3,683,275 2,043.77 158.99
msgs sent queue time (ms) 50,351 27.94 2.17
msgs sent queue time on ksxp (ms) 852,690 473.14 36.81
msgs sent queued 1,272,459 706.06 54.93
msgs sent queued on ksxp 1,118,733 620.76 48.29
number of ges deadlock detected 0 0.00 0.00
process batch messages received 483,562 268.32 20.87
process batch messages sent 421,275 233.76 18.18


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 38,896
CURRENT Block Requests 1,111
Data Block Requests 38,896
Undo Block Requests 20
TX Block Requests 207
Current Results 39,836
Private results 33
Zero Results 139
Disk Read Results 0
Fail Results 0
Fairness Down Converts 7,748
Fairness Clears 0
Free GC Elements 0
Flushes 102
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 727
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 1,366,800 100.00 0.00 0.00 0.00 0.00
Flushes 49 89.80 10.20 0.00 0.00 0.00
Writes 7,709 79.92 11.91 2.54 2.52 3.11


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 34,954 99.41 0.39 0.21 835,675 97.78 0.01 2.21
2 Others 828 99.88 0.12 0.00 1,538 99.93 0.07 0.00
2 undo header 458 98.91 1.09 0.00 68 100.00 0.00 0.00
2 undo block 38 94.74 5.26 0.00 0      


Back to Top

End of Report