WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
GPSDB202909363gpsdb2210.2.0.5.0YESgps02.yto.com

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2104414-Mar-14 09:00:1779 .9
End Snap:2104514-Mar-14 10:00:1377 .9
Elapsed:  59.93 (mins)  
DB Time:  10.97 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 13,072M 13,072MStd Block Size: 8K
Shared Pool Size: 7,280M 7,280MLog Buffer: 47,064K

Load Profile

Per SecondPer Transaction
Redo size: 905.80 4,086.85
Logical reads: 3,407.67 15,374.98
Block changes: 3.93 17.72
Physical reads: 0.60 2.73
Physical writes: 0.62 2.78
User calls: 6.17 27.83
Parses: 3.19 14.39
Hard parses: 0.33 1.51
Sorts: 2.47 11.15
Logons: 0.71 3.22
Executes: 4.45 20.07
Transactions: 0.22 

% Blocks changed per Read: 0.12Recursive Call %: 73.28
Rollback per transaction %: 8.28Rows per Sort: 9575.47

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.99In-memory Sort %: 100.00
Library Hit %: 92.97Soft Parse %: 89.51
Execute to Parse %: 28.31Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 99.20% Non-Parse CPU: 98.30

Shared Pool Statistics

BeginEnd
Memory Usage %: 44.85 45.88
% SQL with executions>1: 97.36 94.03
% Memory for SQL w/exec>1: 97.29 93.78

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  728  110.7 
control file parallel write 1,349 119 88 18.0System I/O
control file sequential read 12,225 4 0 .6System I/O
db file sequential read 481 3 6 .5User I/O
db file scattered read 167 1 8 .2User I/O

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 0.77 3.46
Global Cache blocks served: 1.41 6.35
GCS/GES messages received: 465.83 2,101.77
GCS/GES messages sent: 450.50 2,032.61
DBWR Fusion writes: 0.07 0.33
Estd Interconnect traffic (KB) 196.37 

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

Buffer access - local cache %: 99.97
Buffer access - remote cache %: 0.02
Buffer access - disk %: 0.01

Global Cache and Enqueue Services - Workload Characteristics

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.1
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: 15.87
% of indirect sent messages: 61.68
% of flow controlled messages: 22.45


Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU 728.07 110.66
sql execute elapsed time 626.80 95.27
parse time elapsed 15.05 2.29
hard parse elapsed time 13.96 2.12
connection management call elapsed time 2.99 0.45
hard parse (sharing criteria) elapsed time 1.97 0.30
PL/SQL execution elapsed time 0.67 0.10
sequence load elapsed time 0.02 0.00
hard parse (bind mismatch) elapsed time 0.01 0.00
repeated bind elapsed time 0.00 0.00
DB time 657.93  
background elapsed time 248.43  
background cpu time 188.52  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
CPU time     728   110.66
System I/O 16,711   124 7 18.84
User I/O 1,933   5 2 0.73
Other 50,462 83 2 0 0.28
Concurrency 794   1 1 0.15
Cluster 3,619   1 0 0.14
Commit 161   0 0 0.01
Network 18,667   0 0 0.01
Application 156   0 0 0.01
Configuration 4   0 2 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write 1,349   119 88 1.69
control file sequential read 12,225   4 0 15.34
db file sequential read 481   3 6 0.60
db file scattered read 167   1 8 0.21
db file parallel write 1,579   1 0 1.98
log file parallel write 1,487   1 0 1.87
os thread startup 22   1 28 0.03
gc cr block 2-way 1,678   0 0 2.11
latch free 39   0 11 0.05
rdbms ipc reply 4,483   0 0 5.62
direct path read 1,009   0 0 1.27
row cache lock 595   0 0 0.75
reliable message 243   0 1 0.30
CGS wait for IPC msg 30,709 99 0 0 38.53
log file sequential read 26   0 6 0.03
gc current block 2-way 608   0 0 0.76
gc current grant busy 487   0 0 0.61
DFS lock handle 696   0 0 0.87
ksxr poll remote instances 9,279 86 0 0 11.64
gc cr multi block request 439   0 0 0.55
log file sync 161   0 0 0.20
latch: shared pool 3   0 25 0.00
enq: CF - contention 489   0 0 0.61
SQL*Net more data from client 1,306   0 0 1.64
enq: PS - contention 178   0 0 0.22
db file parallel read 6   0 8 0.01
gc current multi block request 123   0 0 0.15
PX Deq: reap credit 3,697 94 0 0 4.64
enq: TM - contention 151   0 0 0.19
direct path write 250   0 0 0.31
gc current grant 2-way 191   0 0 0.24
CSS operation: query 12   0 3 0.02
enq: TT - contention 144   0 0 0.18
library cache lock 125   0 0 0.16
gcs log flush sync 49   0 1 0.06
gc cr grant 2-way 81   0 0 0.10
SQL*Net message to client 17,261   0 0 21.66
PX Deq: Signal ACK 168 26 0 0 0.21
PX Deq Credit: send blkd 163 67 0 0 0.20
Log archive I/O 35   0 0 0.04
enq: SQ - contention 1   0 9 0.00
direct path read temp 10   0 1 0.01
IPC send completion sync 33 100 0 0 0.04
CSS initialization 4   0 1 0.01
enq: JQ - contention 15   0 0 0.02
log file single write 10   0 0 0.01
enq: TA - contention 13   0 0 0.02
gc cr block busy 3   0 1 0.00
enq: WF - contention 10   0 0 0.01
SQL*Net more data to client 100   0 0 0.13
library cache pin 10   0 0 0.01
direct path write temp 10   0 0 0.01
gc current block unknown 7   0 0 0.01
enq: TX - row lock contention 4   0 0 0.01
gc buffer busy 2   0 1 0.00
CSS operation: action 8   0 0 0.01
latch: cache buffers chains 38   0 0 0.05
enq: MW - contention 2   0 0 0.00
enq: HW - contention 3   0 0 0.00
enq: FB - contention 2   0 0 0.00
enq: WL - contention 2   0 0 0.00
enq: AF - task serialization 1   0 0 0.00
latch: ges resource hash list 7   0 0 0.01
latch: session allocation 5   0 0 0.01
enq: UL - contention 1   0 0 0.00
enq: JS - job run lock - synchronize 1   0 0 0.00
LGWR wait for redo copy 4   0 0 0.01
cursor: pin S 3   0 0 0.00
buffer busy waits 1   0 0 0.00
latch: gcs resource hash 1   0 0 0.00
latch: KCL gc element parent latch 1   0 0 0.00
latch: object queue header operation 1   0 0 0.00
SQL*Net message from client 19,659   65,184 3316 24.67
gcs remote message 2,847,960 43 56,094 20 3,573.35
Streams AQ: waiting for time management or cleanup tasks 1 100 3,634 3633905 0.00
DIAG idle wait 17,977   3,511 195 22.56
PX Idle Wait 1,505 94 3,510 2332 1.89
ges remote message 62,852 68 3,510 56 78.86
ASM background timer 1,556   3,509 2255 1.95
class slave wait 1,308 84 3,495 2672 1.64
virtual circuit status 120 100 3,492 29098 0.15
Streams AQ: qmn slave idle wait 127   3,492 27493 0.16
Streams AQ: qmn coordinator idle wait 255 50 3,492 13692 0.32
jobq slave wait 1,244 84 3,479 2796 1.56
KSV master wait 196   14 74 0.25
PX Deq: Execution Msg 357 6 0 1 0.45
PX Deq: Join ACK 224 33 0 0 0.28
PX Deq: Parse Reply 213 36 0 0 0.27
PX Deq: Execute Reply 177 33 0 0 0.22
PX Deq: Msg Fragment 134 1 0 0 0.17
Streams AQ: RAC qmn coordinator idle wait 255 100 0 0 0.32

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write 1,349   119 88 1.69
control file sequential read 11,671   4 0 14.64
events in waitclass Other 41,373 93 1 0 51.91
db file parallel write 1,579   1 0 1.98
log file parallel write 1,487   1 0 1.87
os thread startup 22   1 28 0.03
direct path read 1,006   0 0 1.26
log file sequential read 26   0 6 0.03
enq: TM - contention 145   0 0 0.18
direct path write 240   0 0 0.30
gc current block 2-way 78   0 0 0.10
gc cr block 2-way 62   0 0 0.08
Log archive I/O 35   0 0 0.04
library cache lock 29   0 0 0.04
log file single write 10   0 0 0.01
gc cr multi block request 24   0 0 0.03
row cache lock 1   0 1 0.00
gc current multi block request 5   0 0 0.01
gc current grant busy 4   0 0 0.01
buffer busy waits 1   0 0 0.00
rdbms ipc message 79,509 67 73,266 921 99.76
gcs remote message 2,847,936 43 56,094 20 3,573.32
Streams AQ: waiting for time management or cleanup tasks 1 100 3,634 3633905 0.00
DIAG idle wait 17,976   3,511 195 22.55
ges remote message 62,852 68 3,510 56 78.86
ASM background timer 1,556   3,509 2255 1.95
pmon timer 1,849 100 3,509 1898 2.32
class slave wait 1,300 85 3,495 2688 1.63
Streams AQ: qmn slave idle wait 127   3,492 27493 0.16
Streams AQ: qmn coordinator idle wait 255 50 3,492 13692 0.32
smon timer 21   3,486 166020 0.03
KSV master wait 196   14 74 0.25
Streams AQ: RAC qmn coordinator idle wait 255 100 0 0 0.32

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 128,293
IDLE_TIME 22,888,268
IOWAIT_TIME 12,884
NICE_TIME 44
SYS_TIME 35,533
USER_TIME 88,394
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 225,649,664
VM_OUT_BYTES 444,366,848
PHYSICAL_MEMORY_BYTES 33,737,773,056
NUM_CPUS 64
NUM_CPU_SOCKETS 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
gpsdb.yto.com.cn 654.90 724.20 1,122 12,185,153
SYS$USERS 2.70 3.50 1 30,122
SYS$BACKGROUND 0.00 0.00 1,051 34,169
gpsdbXDB 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
gpsdb.yto.com.cn 489 4 114 0 0 0 13223 0
SYS$USERS 1 0 50 0 0 0 162 0
SYS$BACKGROUND 1443 1 628 1 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
163 166 104 1.56 24.71 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
153 156 95 1.61 23.28 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
19 20 108 0.18 2.95 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
15 15 94 0.15 2.21 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
12 12 251 0.05 1.75 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
5 5 71 0.07 0.74 832bswus1k5s4 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
5 5 73 0.06 0.70 5qg0cz6q69b6r JDBC Thin Client SELECT * FROM (SELECT YTO_AUDI...
2 2 12 0.19 0.35 80buw7h8q9ugu JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
1 1 59 0.02 0.19 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
1 1 4 0.21 0.13 82ryj14n802dq JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...

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
166 163 104 1.60 22.85 24.71 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
156 153 95 1.65 21.47 23.28 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
20 19 108 0.18 2.72 2.95 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
15 15 94 0.16 2.04 2.21 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
12 12 251 0.05 1.61 1.75 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
5 5 71 0.07 0.68 0.74 832bswus1k5s4 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
5 5 73 0.06 0.65 0.70 5qg0cz6q69b6r JDBC Thin Client SELECT * FROM (SELECT YTO_AUDI...
2 2 12 0.20 0.33 0.35 80buw7h8q9ugu JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
1 1 59 0.02 0.18 0.19 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
1 1 4 0.21 0.12 0.13 82ryj14n802dq JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...

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
1,042,057 108 9,648.68 8.50 19.83 19.42 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
975,280 95 10,266.11 7.96 156.32 153.19 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
966,626 104 9,294.48 7.89 166.35 162.59 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
805,050 251 3,207.37 6.57 11.71 11.54 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
754,550 94 8,027.13 6.16 14.84 14.53 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
425,481 73 5,828.51 3.47 4.72 4.63 5qg0cz6q69b6r JDBC Thin Client SELECT * FROM (SELECT YTO_AUDI...
196,357 71 2,765.59 1.60 4.96 4.89 832bswus1k5s4 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
62,420 20 3,121.00 0.51 0.58 0.57 5b39qfau94tzj JDBC Thin Client SELECT COUNT(1) FROM YTO_DIFFE...
53,603 15 3,573.53 0.44 0.58 0.57 7bwxgqjqqwn1y JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
46,541 12 3,878.42 0.38 0.54 0.53 2h79jm9f76rau JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...

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
150 11 13.64 6.90 0.51 0.54 6wsph5c17t4kb JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
76 95 0.80 3.50 156.32 153.19 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
48 6 8.00 2.21 0.03 0.45 122cz41jvv0f2 JDBC Thin Client INSERT INTO YTO_ROAD SELECT M....
23 68 0.34 1.06 0.07 0.20 54g344fvq2153 JDBC Thin Client SELECT T6.DISTRICT_NAMES , T1....
13 104 0.13 0.60 166.35 162.59 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
12 108 0.11 0.55 19.83 19.42 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
6 94 0.06 0.28 14.84 14.53 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
5 251 0.02 0.23 11.71 11.54 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
3 1 3.00 0.14 0.64 0.63 84qubbrsr0kfn   insert into wrh$_latch (snap_i...
0 1 0.00 0.00 0.48 0.47 04pdbfp2t31j3 JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...

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
684 1,540 2.25 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
552 0 0.00 0.00 0.00 c4nhd1ntptxq7 MMON_SLAVE select message_level, sequence...
338 0 0.00 0.00 0.00 az33m61ym46y4   SELECT NULL AS table_cat, o.ow...
310 684 2.21 0.00 0.00 0k8522rmdzg4k   select privilege# from sysauth...
301 301 1.00 0.00 0.00 18naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
282 282 1.00 0.00 0.00 6xvp6nxs4a9n4   select nvl(sum(space), 0) from...
282 0 0.00 0.00 0.00 csnp95dz2r8ss   select file#, block# from recy...
274 274 1.00 0.00 0.00 26ggbs707cx1q JDBC Thin Client SELECT COUNT(1) FROM YTO_AUDIT...
256 256 1.00 0.00 0.00 5kyb5bvnu3s04 SEVERITY EVALUATION SELECT DISTINCT METRIC_GUID FR...
251 251 1.00 0.05 0.05 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
249 249 1.00 0.00 0.00 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
249 248 1.00 0.00 0.00 459f3z9u4fb3u   select value$ from props$ wher...
247 247 1.00 0.00 0.00 5ur69atw3vfhj   select decode(failover_method,...
236 236 1.00 0.00 0.00 c3hhngpbpvvmk SEVERITY EVALUATION SELECT MARKER_TIMESTAMP FROM M...
236 236 1.00 0.00 0.00 c45crtmadjf65 SEVERITY EVALUATION SELECT SEVERITY_CODE FROM (SEL...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
684 684 5.96 0h6b2sajwb74n   select privilege#, level from ...
552 552 4.81 c4nhd1ntptxq7 MMON_SLAVE select message_level, sequence...
339 338 2.96 az33m61ym46y4   SELECT NULL AS table_cat, o.ow...
310 310 2.70 0k8522rmdzg4k   select privilege# from sysauth...
282 282 2.46 6xvp6nxs4a9n4   select nvl(sum(space), 0) from...
282 282 2.46 csnp95dz2r8ss   select file#, block# from recy...
274 274 2.39 26ggbs707cx1q JDBC Thin Client SELECT COUNT(1) FROM YTO_AUDIT...
251 251 2.19 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
249 249 2.17 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
249 249 2.17 459f3z9u4fb3u   select value$ from props$ wher...
247 247 2.15 5ur69atw3vfhj   select decode(failover_method,...
133 133 1.16 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
133 133 1.16 g00cj285jmgsw   update sys.mon_mods$ set inser...
118 236 1.03 c3hhngpbpvvmk SEVERITY EVALUATION SELECT MARKER_TIMESTAMP FROM M...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

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
0.11 0.07 162.59 166.35 104 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
0.11 0.07 153.19 156.32 95 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
0.07 0.61 11.54 11.71 251 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
0.06 1.25 4.89 4.96 71 832bswus1k5s4 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
0.05 0.25 19.42 19.83 108 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
0.03 0.19 14.53 14.84 94 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
0.02 0.52 4.63 4.72 73 5qg0cz6q69b6r JDBC Thin Client SELECT * FROM (SELECT YTO_AUDI...
0.02 9.76 0.20 0.07 68 54g344fvq2153 JDBC Thin Client SELECT T6.DISTRICT_NAMES , T1....
0.01 2.09 0.54 0.51 11 6wsph5c17t4kb JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
0.01 1.78 0.45 0.03 6 122cz41jvv0f2 JDBC Thin Client INSERT INTO YTO_ROAD SELECT M....
0.01 3.58 0.21 0.21 8 ajzh5n7z4wgxh JDBC Thin Client SELECT * FROM (SELECT AUDIT_AL...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04pdbfp2t31j3 SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = '²×ÀËÇø' /*OR B.ALIAS1='²×ÀËÇø' OR B.ALIAS2='²×ÀËÇø' OR B.ALIAS3='²×ÀËÇø'*/ OR B.NAME like'%ËÕÖÝÊÐ%' /* OR B.ALIAS1='ËÕÖÝÊÐ' OR B.ALIAS2='ËÕÖÝÊÐ' OR B.ALIAS3='ËÕÖÝÊÐ'*/ OR B.NAME like'%ʮȫ½Ö%' /* OR B.ALIAS1='ʮȫ½Ö' OR B.ALIAS2='ʮȫ½Ö' OR B.ALIAS3='ʮȫ½Ö'*/ OR B.NAME like'%20%' /* OR B.ALIAS1='20' OR B.ALIAS2='20' OR B.ALIAS3='20'*/ OR B.NAME like'%1ºÅ%' /* OR B.ALIAS1='1ºÅ' OR B.ALIAS2='1ºÅ' OR B.ALIAS3='1ºÅ'*/ OR B.NAME like'%Ò»²ã%' /* OR B.ALIAS1='Ò»²ã' OR B.ALIAS2='Ò»²ã' OR B.ALIAS3='Ò»²ã'*/ OR B.NAME like'%±±Çø%' /* OR B.ALIAS1='±±Çø' OR B.ALIAS2='±±Çø' OR B.ALIAS3='±±Çø'*/ OR B.NAME like'%30%' /* OR B.ALIAS1='30' OR B.ALIAS2='30' OR B.ALIAS3='30'*/ OR B.NAME like'%ºÅ%' /* OR B.ALIAS1='ºÅ' OR B.ALIAS2='ºÅ' OR B.ALIAS3='ºÅ'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='²×ÀËÇø' OR B.NAME like'%ËÕÖÝÊÐ%' /* OR B.ALIA S1='ËÕÖÝÊÐ' OR B.ALIAS2='ËÕÖÝÊÐ' OR B.ALIAS3='ËÕÖÝÊÐ'*/ OR B.NAME like'%ʮȫ½Ö%' /* OR B.ALIAS1='ʮȫ½Ö' OR B.ALIAS2='ʮȫ½Ö' OR B.ALIAS3='ʮȫ½Ö'*/ OR B.NAME like'%20%' /* OR B.ALIAS1='20' OR B.ALIAS2='20' OR B.ALIAS3='20'*/ OR B.NAME like'%1ºÅ%' /* OR B.ALIAS1='1ºÅ' OR B.ALIAS2='1ºÅ' OR B.ALIAS3='1ºÅ'*/ OR B.NAME like'%Ò»²ã%' /* OR B.ALIAS1='Ò»²ã' OR B.ALIAS2='Ò»²ã' OR B.ALIAS3='Ò»²ã'*/ OR B.NAME like'%±±Çø%' /* OR B.ALIAS1='±±Çø' OR B.ALIAS2='±±Çø' OR B.ALIAS3='±±Çø'*/ OR B.NAME like'%30%' /* OR B.ALIAS1='30' OR B.ALIAS2='30' OR B.ALIAS3='30'*/ OR B.NAME like'%ºÅ%' /* OR B.ALIAS1='ºÅ' OR B.ALIAS2='ºÅ' OR B.ALIAS3='ºÅ'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ')
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
122cz41jvv0f2INSERT INTO YTO_ROAD SELECT M.ROAD_ID , M.DISTRICT_ID , M.PROVINCE_ID , M.DISTRICT_IDS , M.NAME , M.TYPE , M.ALIAS1 , M.ALIAS3 , M.ALIAS2 , M.OWNER , M.CREATER , '' OUTLET_ID , M.IS_REACH , '' NEW_RELEASE FROM YTO_MID_ROAD M WHERE M.ROAD_ID IN ( :1 , :2 ) AND M.ROAD_ID NOT IN (SELECT ROAD_ID FROM YTO_ROAD)
18naypzfmabd6INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
26ggbs707cx1qSELECT COUNT(1) FROM YTO_AUDIT_STATISTICS T1 WHERE T1.STATION_CODE=:1 AND T1.AUDIT_STATE=:2
2h79jm9f76rau SELECT * FROM (SELECT A.*, ROWNUM RN FROM( SELECT T1.ROAD_ID , T1.NAME , CASE WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NULL THEN '' WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NULL THEN T2.DATA_VALUE_MIN WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN T2.DATA_VALUE_MAX WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN (TO_CHAR(T2.DATA_VALUE_MIN) ||'-'||(TO_CHAR(SUBSTR(T2.DATA_VALUE_MAX, INSTR(T2.DATA_VALUE_MAX, ')')+1, length(T2.DATA_VALUE_MAX))))) END AS DATA_VALUE , DECODE(T2.IS_REACH, 1, 'ÅÉËÍ', 0, '²»ÅÉËÍ') AS IS_REACH , TRIM(', ' FROM T1.ALIAS1||', '||DECODE(T1.ALIAS2, '', '', T1.ALIAS2, T1.ALIAS2||', ')||T1.ALIAS3) AS ALIAS1 , T2.OWNER , T2.CREATE_STATION_CODE , T2.CREATER , T2.ROAD_NUM_ID , T1.DISTRICT_ID , T6.DISTRICT_NAMES , T6.LEVELS , T2.DATA_VALUE_MIN , T2.DATA_VALUE_MAX , DECODE(T2.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T5.AUDIT_TYPE, 1, 'ÐÂÔö', 2, 'ÐÞ¸Ä', 3, 'ɾ³ý') AS AUDIT_TYPE , DECODE(T2.IS_SINGLE, '0', '·ñ', '1', 'ÊÇ') IS_SINGLE , T3.NAME G_NAME , T7.NAME AS G_NAME2 , DECODE(T5.STATE, 10, '²Ý¸å', 20, '·Ö¹«Ë¾ÉóºËÖÐ', 30, 'Ê¡ÇøÉóºËÖÐ', 40, '¹ÜÀíÇøÉóºËÖÐ', 50, '×ܹ«Ë¾ÉóºËÖÐ', 60, 'ÉóºËͨ¹ý', 70, 'ÉóºË²»Í¨¹ý') AS STATE , T5.CREATE_TIME , T2.FLOOR_VALUE , '' NOPASSREASON FROM YTO_MID_ROAD T1 LEFT JOIN (SELECT A.*, B.DATA_VALUE_MIN||'-'||B .DATA_VALUE_MIN FLOOR_VALUE FROM YTO_MID_ROAD_NUM A LEFT JOIN YTO_MID_POI_DTL B ON A.ROAD_NUM_ID = B.ROAD_NUM_ID) T2 ON T1.ROAD_ID = T2.ROAD_ID LEFT JOIN YTO_JINGANG_STATION T3 ON (T1.OWNER = T3.CODE AND T3.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER T4 ON T1.CREATER = T4.USER_CODE LEFT JOIN YTO_AUDIT_RECORD T5 ON T2.ROAD_NUM_ID = T5.AUDIT_VALUE LEFT JOIN YTO_MID_DISTRICT T6 ON T1.DISTRICT_ID = T6.DISTRICT_ID LEFT JOIN YTO_JINGANG_STATION T7 ON (T1.CREATE_STATION_CODE = T7.CODE AND T7.STATUS = 'VALID') WHERE T2.ISDELETE = '0' AND T1.OWNER IN (SELECT CODE FROM YTO_JINGANG_STATION WHERE STATUS = 'VALID' START WITH CODE = :1 CONNECT BY PRIOR ID = PARENT_ID) AND T2.ROAD_NUM_ID IS NOT NULL AND T1.NAME LIKE '%'||:2||'%' ORDER BY T1.CREATE_TIME DESC) A WHERE ROWNUM <=:3) WHERE RN >= :4
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
54g344fvq2153SELECT T6.DISTRICT_NAMES , T1.NAME , CASE WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NULL THEN '' WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NULL THEN T2.DATA_VALUE_MIN WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN T2.DATA_VALUE_MAX WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN (TO_CHAR(T2.DATA_VALUE_MIN) ||'-'||(TO_CHAR(SUBSTR(T2.DATA_VALUE_MAX, INSTR(T2.DATA_VALUE_MAX, ')')+1, length(T2.DATA_VALUE_MAX))))) END AS DATA_VALUE , DECODE(T2.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T2.IS_REACH, 1, 'ÅÉËÍ', 0, '²»ÅÉËÍ') AS IS_REACH , T1.OWNER , T3.NAME G_NAME FROM YTO_MID_ROAD T1 INNER JOIN YTO_MID_ROAD_NUM T2 ON T1.ROAD_ID = T2.ROAD_ID INNER JOIN YTO_JINGANG_STATION T3 ON (T1.OWNER = T3.CODE AND T3.STATUS = 'VALID') INNER JOIN YTO_JINGANG_USER T4 ON T1.CREATER = T4.USER_CODE INNER JOIN YTO_AUDIT_RECORD T5 ON T2.ROAD_NUM_ID = T5.AUDIT_VALUE INNER JOIN YTO_MID_DISTRICT T6 ON T1.DISTRICT_ID = T6.DISTRICT_ID AND T1.NAME = :1 AND T1.DISTRICT_ID = :2 AND T1.ISDELETE = '0'
5b39qfau94tzjSELECT COUNT(1) FROM YTO_DIFFERENT_MATCHDATA A1 WHERE A1.STATUS = 1 AND A1.ORG_CODE = :1
5kyb5bvnu3s04SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
5qg0cz6q69b6rSELECT * FROM (SELECT YTO_AUDIT_STATISTICS.*, ROWNUM RN FROM( SELECT P.STATION_CODE GID , P.STATION_NAME G_NAME , P.ROAD_NUM V_NUM_ROAD , P.POI_NUM V_NUM_POI , P.DIS_NUM V_NUM_DISTRICT FROM YTO_AUDIT_STATISTICS P WHERE P.AUDIT_STATE = :1 AND NVL(ROAD_NUM, 0)+NVL(POI_NUM, 0)+NVL(DIS_NUM, 0)>0 AND P.STATION_CODE IN( SELECT G.CODE FROM YTO_JINGANG_STATION G WHERE G.STATUS = 'VALID' START WITH G.CODE = (SELECT USER_ORG_CODE FROM YTO_JINGANG_USER WHERE USER_CODE = :2) CONNECT BY PRIOR G.ID = G.PARENT_ID ) ) YTO_AUDIT_STATISTICS WHERE ROWNUM <=:3) WHERE RN >= :4
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6wsph5c17t4kb SELECT COUNT(1) FROM ( SELECT P.STATION_CODE, P.STATION_NAME, NVL(SUM(CASE WHEN AUDIT_STATE = '10' THEN NVL(P.ROAD_NUM, 0) END), 0)D_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '10' THEN NVL(P.POI_NUM, 0) END), 0)D_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '10' THEN NVL(P.DIS_NUM, 0) END), 0)D_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '20' THEN NVL(P.ROAD_NUM, 0) END), 0)S_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '20' THEN NVL(P.POI_NUM, 0) END), 0)S_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '20' THEN NVL(P.DIS_NUM, 0) END), 0)S_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '30' THEN NVL(P.ROAD_NUM, 0) END), 0)P_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '30' THEN NVL(P.POI_NUM, 0) END), 0)P_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '30' THEN NVL(P.DIS_NUM, 0) END), 0)P_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '40' THEN NVL(P.ROAD_NUM, 0) END), 0)M_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '40' THEN NVL(P.POI_NUM, 0) END), 0)M_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '40' THEN NVL(P.DIS_NUM, 0) END), 0)M_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '50' THEN NVL(P.ROAD_NUM, 0) END), 0)H_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '50' THEN NVL(P.POI_NUM, 0) END), 0)H_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '50' THEN NVL(P.DIS_NUM, 0) END), 0)H_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '60' THEN NVL(P.ROAD_NUM, 0) END), 0)C_NUM_ROAD, NVL(SUM (CASE WHEN AUDIT_STATE = '60' THEN NVL(P.POI_NUM, 0) END), 0)C_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '60' THEN NVL(P.DIS_NUM, 0) END), 0)C_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '70' THEN NVL(P.ROAD_NUM, 0) END), 0)N_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '70' THEN NVL(P.POI_NUM, 0) END), 0)N_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '70' THEN NVL(P.DIS_NUM, 0) END), 0)N_NUM_DISTRICT FROM YTO_AUDIT_STATISTICS P WHERE P.STATION_CODE IN( SELECT G.CODE FROM YTO_JINGANG_STATION G WHERE G.STATUS = 'VALID' START WITH G.CODE = (SELECT USER_ORG_CODE FROM YTO_JINGANG_USER WHERE USER_CODE = :1) CONNECT BY PRIOR G.ID = G.PARENT_ID ) GROUP BY P.STATION_CODE, P.STATION_NAME )
6xvp6nxs4a9n4select nvl(sum(space), 0) from recyclebin$ where ts# = :1
7bwxgqjqqwn1ySELECT COUNT(1) FROM YTO_MID_ROAD T1 LEFT JOIN YTO_MID_ROAD_NUM T2 ON T1.ROAD_ID = T2.ROAD_ID LEFT JOIN YTO_JINGANG_STATION T3 ON (T1.CREATE_STATION_CODE = T3.CODE AND T3.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER T4 ON T1.CREATER = T4.USER_CODE LEFT JOIN YTO_AUDIT_RECORD T5 ON T2.ROAD_NUM_ID = T5.AUDIT_VALUE LEFT JOIN YTO_MID_DISTRICT T6 ON T1.DISTRICT_ID = T6.DISTRICT_ID LEFT JOIN YTO_JINGANG_STATION T7 ON (T1.CREATE_STATION_CODE = T7.CODE AND T7.STATUS = 'VALID') WHERE T2.ISDELETE = '0' AND T1.OWNER IN (SELECT CODE FROM YTO_JINGANG_STATION WHERE STATUS = 'VALID' START WITH CODE = :1 CONNECT BY PRIOR ID = PARENT_ID) AND T2.ROAD_NUM_ID IS NOT NULL AND T1.NAME LIKE '%'||:2||'%'
80buw7h8q9ugu SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = 'null' /*OR B.ALIAS1='null' OR B.ALIAS2='null' OR B.ALIAS3='null'*/ OR B.NAME like'%µã»÷%' /* OR B.ALIAS1='µã»÷' OR B.ALIAS2='µã»÷' OR B.ALIAS3='µã»÷'*/ OR B.NAME like'%ÂÌÉ«%' /* OR B.ALIAS1='ÂÌÉ«' OR B.ALIAS2='ÂÌÉ«' OR B.ALIAS3='ÂÌÉ«'*/ OR B.NAME like'%¸ñ×Ó%' /* OR B.ALIAS1='¸ñ×Ó' OR B.ALIAS2='¸ñ×Ó' OR B.ALIAS3='¸ñ×Ó'*/ OR B.NAME like'%²é¿´%' /* OR B.ALIAS1='²é¿´' OR B.ALIAS2='²é¿´' OR B.ALIAS3='²é¿´'*/ OR B.NAME like'%ͼƬ%' /* OR B.ALIAS1='ͼƬ' OR B.ALIAS2='ͼƬ' OR B.ALIAS3='ͼƬ'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='null' OR B.NAME like'%µã»÷%' /* OR B.ALIAS1='µã»÷' OR B.ALIAS2='µã»÷' OR B.ALIAS3='µã»÷'*/ OR B.NAME like'%ÂÌÉ«%' /* OR B.ALIAS1='ÂÌÉ«' OR B.ALIAS2='ÂÌÉ«' OR B.ALIAS3='ÂÌÉ«'*/ OR B.NAME like'%¸ñ×Ó%' /* OR B.ALIAS1='¸ñ×Ó' OR B.ALIAS2='¸ñ×Ó' OR B.ALIAS3='¸ñ×Ó'*/ OR B.NAME like'%²é¿´%' /* OR B.ALIA S1='²é¿´' OR B.ALIAS2='²é¿´' OR B.ALIAS3='²é¿´'*/ OR B.NAME like'%ͼƬ%' /* OR B.ALIAS1='ͼƬ' OR B.ALIAS2='ͼƬ' OR B.ALIAS3='ͼƬ'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ')
82ryj14n802dq SELECT * FROM (SELECT A.*, ROWNUM RN FROM( SELECT T1.ROAD_ID , T1.NAME , CASE WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NULL THEN '' WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NULL THEN T2.DATA_VALUE_MIN WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN T2.DATA_VALUE_MAX WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN (TO_CHAR(T2.DATA_VALUE_MIN) ||'-'||(TO_CHAR(SUBSTR(T2.DATA_VALUE_MAX, INSTR(T2.DATA_VALUE_MAX, ')')+1, length(T2.DATA_VALUE_MAX))))) END AS DATA_VALUE , DECODE(T2.IS_REACH, 1, 'ÅÉËÍ', 0, '²»ÅÉËÍ') AS IS_REACH , TRIM(', ' FROM T1.ALIAS1||', '||DECODE(T1.ALIAS2, '', '', T1.ALIAS2, T1.ALIAS2||', ')||T1.ALIAS3) AS ALIAS1 , T2.OWNER , T2.CREATE_STATION_CODE , T2.CREATER , T2.ROAD_NUM_ID , T1.DISTRICT_ID , T6.DISTRICT_NAMES , T6.LEVELS , T2.DATA_VALUE_MIN , T2.DATA_VALUE_MAX , DECODE(T2.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T5.AUDIT_TYPE, 1, 'ÐÂÔö', 2, 'ÐÞ¸Ä', 3, 'ɾ³ý') AS AUDIT_TYPE , DECODE(T2.IS_SINGLE, '0', '·ñ', '1', 'ÊÇ') IS_SINGLE , T3.NAME G_NAME , T7.NAME AS G_NAME2 , DECODE(T5.STATE, 10, '²Ý¸å', 20, '·Ö¹«Ë¾ÉóºËÖÐ', 30, 'Ê¡ÇøÉóºËÖÐ', 40, '¹ÜÀíÇøÉóºËÖÐ', 50, '×ܹ«Ë¾ÉóºËÖÐ', 60, 'ÉóºËͨ¹ý', 70, 'ÉóºË²»Í¨¹ý') AS STATE , T5.CREATE_TIME , T2.FLOOR_VALUE , '' NOPASSREASON FROM YTO_MID_ROAD T1 LEFT JOIN (SELECT A.*, B.DATA_VALUE_MIN||'-'||B .DATA_VALUE_MIN FLOOR_VALUE FROM YTO_MID_ROAD_NUM A LEFT JOIN YTO_MID_POI_DTL B ON A.ROAD_NUM_ID = B.ROAD_NUM_ID) T2 ON T1.ROAD_ID = T2.ROAD_ID LEFT JOIN YTO_JINGANG_STATION T3 ON (T1.OWNER = T3.CODE AND T3.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER T4 ON T1.CREATER = T4.USER_CODE LEFT JOIN YTO_AUDIT_RECORD T5 ON T2.ROAD_NUM_ID = T5.AUDIT_VALUE LEFT JOIN YTO_MID_DISTRICT T6 ON T1.DISTRICT_ID = T6.DISTRICT_ID LEFT JOIN YTO_JINGANG_STATION T7 ON (T1.CREATE_STATION_CODE = T7.CODE AND T7.STATUS = 'VALID') WHERE T2.ISDELETE = '0' AND T1.OWNER IN (SELECT CODE FROM YTO_JINGANG_STATION WHERE STATUS = 'VALID' START WITH CODE = :1 CONNECT BY PRIOR ID = PARENT_ID) AND T2.ROAD_NUM_ID IS NOT NULL AND T2.OWNER = :2 ORDER BY T1.CREATE_TIME DESC) A WHERE ROWNUM <=:3) WHERE RN >= :4
832bswus1k5s4SELECT COUNT(1) FROM ( SELECT P.STATION_CODE GID , P.STATION_NAME G_NAME , P.ROAD_NUM V_NUM_ROAD , P.POI_NUM V_NUM_POI , P.DIS_NUM V_NUM_DISTRICT FROM YTO_AUDIT_STATISTICS P WHERE P.AUDIT_STATE = :1 AND NVL(ROAD_NUM, 0)+NVL(POI_NUM, 0)+NVL(DIS_NUM, 0)>0 AND P.STATION_CODE IN( SELECT G.CODE FROM YTO_JINGANG_STATION G WHERE G.STATUS = 'VALID' START WITH G.CODE = (SELECT USER_ORG_CODE FROM YTO_JINGANG_USER WHERE USER_CODE = :2) CONNECT BY PRIOR G.ID = G.PARENT_ID ) )
84qubbrsr0kfninsert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
9g8rftjc929u0 SELECT * FROM (SELECT A.*, ROWNUM RN FROM( SELECT T1.ROAD_ID , T1.NAME , CASE WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NULL THEN '' WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NULL THEN T2.DATA_VALUE_MIN WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN T2.DATA_VALUE_MAX WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN (TO_CHAR(T2.DATA_VALUE_MIN) ||'-'||(TO_CHAR(SUBSTR(T2.DATA_VALUE_MAX, INSTR(T2.DATA_VALUE_MAX, ')')+1, length(T2.DATA_VALUE_MAX))))) END AS DATA_VALUE , DECODE(T2.IS_REACH, 1, 'ÅÉËÍ', 0, '²»ÅÉËÍ') AS IS_REACH , TRIM(', ' FROM T1.ALIAS1||', '||DECODE(T1.ALIAS2, '', '', T1.ALIAS2, T1.ALIAS2||', ')||T1.ALIAS3) AS ALIAS1 , T2.OWNER , T2.CREATE_STATION_CODE , T2.CREATER , T2.ROAD_NUM_ID , T1.DISTRICT_ID , T6.DISTRICT_NAMES , T6.LEVELS , T2.DATA_VALUE_MIN , T2.DATA_VALUE_MAX , DECODE(T2.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T5.AUDIT_TYPE, 1, 'ÐÂÔö', 2, 'ÐÞ¸Ä', 3, 'ɾ³ý') AS AUDIT_TYPE , DECODE(T2.IS_SINGLE, '0', '·ñ', '1', 'ÊÇ') IS_SINGLE , T3.NAME G_NAME , T7.NAME AS G_NAME2 , DECODE(T5.STATE, 10, '²Ý¸å', 20, '·Ö¹«Ë¾ÉóºËÖÐ', 30, 'Ê¡ÇøÉóºËÖÐ', 40, '¹ÜÀíÇøÉóºËÖÐ', 50, '×ܹ«Ë¾ÉóºËÖÐ', 60, 'ÉóºËͨ¹ý', 70, 'ÉóºË²»Í¨¹ý') AS STATE , T5.CREATE_TIME , T2.FLOOR_VALUE , '' NOPASSREASON FROM YTO_MID_ROAD T1 LEFT JOIN (SELECT A.*, B.DATA_VALUE_MIN||'-'||B .DATA_VALUE_MIN FLOOR_VALUE FROM YTO_MID_ROAD_NUM A LEFT JOIN YTO_MID_POI_DTL B ON A.ROAD_NUM_ID = B.ROAD_NUM_ID) T2 ON T1.ROAD_ID = T2.ROAD_ID LEFT JOIN YTO_JINGANG_STATION T3 ON (T1.OWNER = T3.CODE AND T3.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER T4 ON T1.CREATER = T4.USER_CODE LEFT JOIN YTO_AUDIT_RECORD T5 ON T2.ROAD_NUM_ID = T5.AUDIT_VALUE LEFT JOIN YTO_MID_DISTRICT T6 ON T1.DISTRICT_ID = T6.DISTRICT_ID LEFT JOIN YTO_JINGANG_STATION T7 ON (T1.CREATE_STATION_CODE = T7.CODE AND T7.STATUS = 'VALID') WHERE T2.ISDELETE = '0' AND T1.OWNER IN (SELECT CODE FROM YTO_JINGANG_STATION WHERE STATUS = 'VALID' START WITH CODE = :1 CONNECT BY PRIOR ID = PARENT_ID) AND T2.ROAD_NUM_ID IS NOT NULL ORDER BY T1.CREATE_TIME DESC) A WHERE ROWNUM <=:2) WHERE RN >= :3
ajzh5n7z4wgxh SELECT * FROM (SELECT AUDIT_ALL_TEMP.*, ROWNUM RN FROM( SELECT P.STATION_CODE, P.STATION_NAME, NVL(SUM(CASE WHEN AUDIT_STATE = '10' THEN NVL(P.ROAD_NUM, 0) END), 0)D_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '10' THEN NVL(P.POI_NUM, 0) END), 0)D_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '10' THEN NVL(P.DIS_NUM, 0) END), 0)D_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '20' THEN NVL(P.ROAD_NUM, 0) END), 0)S_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '20' THEN NVL(P.POI_NUM, 0) END), 0)S_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '20' THEN NVL(P.DIS_NUM, 0) END), 0)S_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '30' THEN NVL(P.ROAD_NUM, 0) END), 0)P_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '30' THEN NVL(P.POI_NUM, 0) END), 0)P_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '30' THEN NVL(P.DIS_NUM, 0) END), 0)P_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '40' THEN NVL(P.ROAD_NUM, 0) END), 0)M_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '40' THEN NVL(P.POI_NUM, 0) END), 0)M_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '40' THEN NVL(P.DIS_NUM, 0) END), 0)M_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '50' THEN NVL(P.ROAD_NUM, 0) END), 0)H_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '50' THEN NVL(P.POI_NUM, 0) END), 0)H_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '50' THEN NVL(P.DIS_NUM, 0) END), 0)H_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '60' THEN NVL(P.ROAD_NUM, 0 ) END), 0)C_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '60' THEN NVL(P.POI_NUM, 0) END), 0)C_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '60' THEN NVL(P.DIS_NUM, 0) END), 0)C_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '70' THEN NVL(P.ROAD_NUM, 0) END), 0)N_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '70' THEN NVL(P.POI_NUM, 0) END), 0)N_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '70' THEN NVL(P.DIS_NUM, 0) END), 0)N_NUM_DISTRICT FROM YTO_AUDIT_STATISTICS P WHERE P.STATION_CODE IN( SELECT G.CODE FROM YTO_JINGANG_STATION G WHERE G.STATUS = 'VALID' START WITH G.CODE = (SELECT USER_ORG_CODE FROM YTO_JINGANG_USER WHERE USER_CODE = :1) CONNECT BY PRIOR G.ID = G.PARENT_ID ) GROUP BY P.STATION_CODE, P.STATION_NAME ) AUDIT_ALL_TEMP WHERE ROWNUM <=:2) WHERE RN >= :3
an9ph1jq3g7fdSELECT COUNT(1) FROM YTO_MID_ROAD T1 LEFT JOIN YTO_MID_ROAD_NUM T2 ON T1.ROAD_ID = T2.ROAD_ID LEFT JOIN YTO_JINGANG_STATION T3 ON (T1.CREATE_STATION_CODE = T3.CODE AND T3.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER T4 ON T1.CREATER = T4.USER_CODE LEFT JOIN YTO_AUDIT_RECORD T5 ON T2.ROAD_NUM_ID = T5.AUDIT_VALUE LEFT JOIN YTO_MID_DISTRICT T6 ON T1.DISTRICT_ID = T6.DISTRICT_ID LEFT JOIN YTO_JINGANG_STATION T7 ON (T1.CREATE_STATION_CODE = T7.CODE AND T7.STATUS = 'VALID') WHERE T2.ISDELETE = '0' AND T1.OWNER IN (SELECT CODE FROM YTO_JINGANG_STATION WHERE STATUS = 'VALID' START WITH CODE = :1 CONNECT BY PRIOR ID = PARENT_ID) AND T2.ROAD_NUM_ID IS NOT NULL
az33m61ym46y4SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name
bk5k8x08y0wfw SELECT COUNT(1) FROM ( SELECT T.AUDIT_ID , M.ROAD_ID , N.ROAD_NUM_ID , M.NAME , TRIM('£¬' FROM M.ALIAS1||'£¬'||DECODE(M.ALIAS2, '', '', M.ALIAS2, M.ALIAS2||'£¬')||M.ALIAS3) ALIAS , DECODE(NVL(N.IS_REACH, M.IS_REACH), '1', 'ÅÉËÍ', '0', '²»ÅÉËÍ')IS_REACH , M.OWNER , (SELECT TT.NAME FROM YTO_JINGANG_STATION TT WHERE TT.CODE = M.OWNER AND TT.STATUS = 'VALID') OGNAME , M.DISTRICT_ID , Y.DISTRICT_NAMES DIS_NAME , T.AUDIT_VALUE_TYPE , DECODE(T.STATE, '10', '²Ý¸å', '20', '·Ö¹«Ë¾ÉóºËÖÐ', '30', 'Ê¡ÇøÉóºËÖÐ', '40', '¹ÜÀíÇøÉóºËÖÐ', '50', '×ܹ«Ë¾ÉóºËÖÐ', '60', 'ÉóºËͨ¹ý', '70', 'ÉóºË²»Í¨¹ý' ) STATE , T.STATE AUDIT_STATE_NUM , DECODE(N.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T.AUDIT_TYPE, '1', 'ÐÂÔö', '2', 'ÐÞ¸Ä', '3', 'ɾ³ý') AUDIT_TYPE , TO_CHAR(CAST(T.CREATE_TIME AS DATE), 'YYYY-MM-DD HH24:MI:SS')CREATE_TIME , TO_CHAR(NVL(N.DATA_VALUE_MIN, 1)) || '-' ||TO_CHAR(NVL(SUBSTR(N.DATA_VALUE_MAX, INSTR(N.DATA_VALUE_MAX, ')')+1, length(N.DATA_VALUE_MAX)), 9999)) DATA_VALUE , N.DATA_VALUE_MAX , N.DATA_VALUE_MIN , G.CODE CGCODE , G.NAME CGNAME , M.CREATER CREATER_CODE , U.USER_NAME CREATER_NAME , T.COMMENTS , '' NEW_RELEASE , T.AUDIT_ORG_ID , T.AUDIT_ORG_NAME , T.AUDITOR_ID , T.AUDITOR_NAME , T.AUD IT_TIME , DECODE(N.IS_SINGLE, '0', '·ñ' , ' 1' , 'ÊÇ') IS_SINGLE , N.FLOOR_VALUE FROM YTO_MID_ROAD M , (SELECT A.*, B.DATA_VALUE_MIN||'-'||B.DATA_VALUE_MIN FLOOR_VALUE FROM YTO_MID_ROAD_NUM A LEFT JOIN YTO_MID_POI_DTL B ON A.ROAD_NUM_ID = B.ROAD_NUM_ID) N , ( SELECT A.* , B.COMMENTS , B.AUDIT_ORG_ID , S.NAME AUDIT_ORG_NAME , B.AUDITOR_ID , TO_CHAR(B.AUDIT_TIME, 'YYYY-MM-DD HH24:MI:SS') AUDIT_TIME , U.USER_NAME AUDITOR_NAME FROM (SELECT P.* FROM YTO_AUDIT_RECORD P WHERE P.OUTLET_ID = :1 AND P.STATE = :2 ) A LEFT JOIN (SELECT Q.*, ROW_NUMBER() OVER(PARTITION BY Q.AUDIT_ID ORDER BY Q.AUDIT_TIME DESC) RN FROM YTO_AUDIT_DETAIL Q) B ON A.AUDIT_ID = B.AUDIT_ID AND B.RN = 1 LEFT JOIN YTO_JINGANG_STATION S ON (S.CODE = B.AUDIT_ORG_ID AND S.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER U ON U.USER_CODE = B.AUDITOR_ID ) T , YTO_JINGANG_STATION G , YTO_JINGANG_USER U , YTO_MID_DISTRICT Y WHERE N.ISDELETE = 0 AND M.ROAD_ID = N.ROAD_ID AND G.STATUS = 'VALID' AND N.ROAD_NUM_ID = T.AUDIT_VALUE AND T.OUTLET_ID = G.CODE AND U.USER_CODE = T.CREATOR_ID AND M.DISTRICT_ID = Y.DISTRICT_ID )
c3hhngpbpvvmkSELECT MARKER_TIMESTAMP FROM MGMT_AVAILABILITY_MARKER WHERE TARGET_GUID = :B1
c45crtmadjf65SELECT SEVERITY_CODE FROM (SELECT SEVERITY_CODE FROM MGMT_SEVERITY WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP <= :B1 ORDER BY COLLECTION_TIMESTAMP DESC) WHERE ROWNUM = 1
c4nhd1ntptxq7select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4
cg2fjydbr0u8mUPDATE YTO_AUDIT_STATISTICS T SET ROAD_NUM = NVL((SELECT COUNT(1) FROM YTO_AUDIT_RECORD A, YTO_MID_ROAD_NUM B WHERE A.AUDIT_VALUE = B.ROAD_NUM_ID AND B.ISDELETE = 0 AND T.STATION_CODE = A.OUTLET_ID AND T.AUDIT_STATE = A.STATE GROUP BY A.AUDIT_VALUE_TYPE, A.OUTLET_ID, A.STATE), 0) WHERE T.AUDIT_STATE = :1 AND T.STATION_CODE = :2
csnp95dz2r8ssselect file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
dknnjdqsdhb73 SELECT * FROM (SELECT YTO_ROAD_AUDIT.*, ROWNUM RN FROM( SELECT T.AUDIT_ID , M.ROAD_ID , N.ROAD_NUM_ID , M.NAME , TRIM('£¬' FROM M.ALIAS1||'£¬'||DECODE(M.ALIAS2, '', '', M.ALIAS2, M.ALIAS2||'£¬')||M.ALIAS3) ALIAS , DECODE(NVL(N.IS_REACH, M.IS_REACH), '1', 'ÅÉËÍ', '0', '²»ÅÉËÍ')IS_REACH , M.OWNER , (SELECT TT.NAME FROM YTO_JINGANG_STATION TT WHERE TT.CODE = M.OWNER AND TT.STATUS = 'VALID') OGNAME , M.DISTRICT_ID , Y.DISTRICT_NAMES DIS_NAME , T.AUDIT_VALUE_TYPE , DECODE(T.STATE, '10', '²Ý¸å', '20', '·Ö¹«Ë¾ÉóºËÖÐ', '30', 'Ê¡ÇøÉóºËÖÐ', '40', '¹ÜÀíÇøÉóºËÖÐ', '50', '×ܹ«Ë¾ÉóºËÖÐ', '60', 'ÉóºËͨ¹ý', '70', 'ÉóºË²»Í¨¹ý' ) STATE , T.STATE AUDIT_STATE_NUM , DECODE(N.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T.AUDIT_TYPE, '1', 'ÐÂÔö', '2', 'ÐÞ¸Ä', '3', 'ɾ³ý') AUDIT_TYPE , TO_CHAR(CAST(T.CREATE_TIME AS DATE), 'YYYY-MM-DD HH24:MI:SS')CREATE_TIME , TO_CHAR(NVL(N.DATA_VALUE_MIN, 1)) || '-' ||TO_CHAR(NVL(SUBSTR(N.DATA_VALUE_MAX, INSTR(N.DATA_VALUE_MAX, ')')+1, length(N.DATA_VALUE_MAX)), 9999)) DATA_VALUE , N.DATA_VALUE_MAX , N.DATA_VALUE_MIN , G.CODE CGCODE , G.NAME CGNAME , M.CREATER CREATER_CODE , U.USER_NAME CREATER_NAME , T.COMMENTS , '' NEW_RELEASE , T.AUDIT_ORG_ID , T.AUDIT_ORG_NAME , T.AUDITOR_ID , T.AUDITOR_NAME , T.AUDIT_TIME , D ECODE(N.IS_SINGLE, '0', '·ñ' , '1' , 'ÊÇ') IS_SINGLE , N.FLOOR_VALUE FROM YTO_MID_ROAD M , (SELECT A.*, B.DATA_VALUE_MIN||'-'||B.DATA_VALUE_MIN FLOOR_VALUE FROM YTO_MID_ROAD_NUM A LEFT JOIN YTO_MID_POI_DTL B ON A.ROAD_NUM_ID = B.ROAD_NUM_ID) N , ( SELECT A.* , B.COMMENTS , B.AUDIT_ORG_ID , S.NAME AUDIT_ORG_NAME , B.AUDITOR_ID , TO_CHAR(B.AUDIT_TIME, 'YYYY-MM-DD HH24:MI:SS') AUDIT_TIME , U.USER_NAME AUDITOR_NAME FROM (SELECT P.* FROM YTO_AUDIT_RECORD P WHERE P.OUTLET_ID = :1 AND P.STATE = :2 ) A LEFT JOIN (SELECT Q.*, ROW_NUMBER() OVER(PARTITION BY Q.AUDIT_ID ORDER BY Q.AUDIT_TIME DESC) RN FROM YTO_AUDIT_DETAIL Q) B ON A.AUDIT_ID = B.AUDIT_ID AND B.RN = 1 LEFT JOIN YTO_JINGANG_STATION S ON (S.CODE = B.AUDIT_ORG_ID AND S.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER U ON U.USER_CODE = B.AUDITOR_ID ) T , YTO_JINGANG_STATION G , YTO_JINGANG_USER U , YTO_MID_DISTRICT Y WHERE N.ISDELETE = 0 AND M.ROAD_ID = N.ROAD_ID AND G.STATUS = 'VALID' AND N.ROAD_NUM_ID = T.AUDIT_VALUE AND T.OUTLET_ID = G.CODE AND U.USER_CODE = T.CREATOR_ID AND M.DISTRICT_ID = Y.DISTRICT_ID )YTO_ROAD_AUDIT WHERE ROWNUM <=:3) WHERE RN >= :4
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 65,721 18.28 82.46
CPU used when call started 64,528 17.94 80.96
CR blocks created 165 0.05 0.21
Cached Commit SCN referenced 0 0.00 0.00
Commit SCN cached 0 0.00 0.00
DB time 422,753 117.56 530.43
DBWR checkpoint buffers written 1,621 0.45 2.03
DBWR checkpoints 5 0.00 0.01
DBWR fusion writes 264 0.07 0.33
DBWR transaction table writes 68 0.02 0.09
DBWR undo block writes 215 0.06 0.27
DFO trees parallelized 78 0.02 0.10
PX local messages recv'd 420 0.12 0.53
PX local messages sent 420 0.12 0.53
PX remote messages recv'd 196 0.05 0.25
PX remote messages sent 320 0.09 0.40
Parallel operations not downgraded 78 0.02 0.10
RowCR - row contention 28 0.01 0.04
RowCR attempts 424 0.12 0.53
RowCR hits 433 0.12 0.54
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 11,983 3.33 15.04
active txn count during cleanout 87 0.02 0.11
application wait time 5 0.00 0.01
background checkpoints completed 4 0.00 0.01
background checkpoints started 5 0.00 0.01
background timeouts 24,462 6.80 30.69
branch node splits 0 0.00 0.00
buffer is not pinned count 648,672 180.39 813.89
buffer is pinned count 1,304,057 362.64 1,636.21
bytes received via SQL*Net from client 6,301,334 1,752.33 7,906.32
bytes sent via SQL*Net to client 4,532,784 1,260.52 5,687.31
calls to get snapshot scn: kcmgss 71,697 19.94 89.96
calls to kcmgas 6,704 1.86 8.41
calls to kcmgcs 96 0.03 0.12
change write time 19 0.01 0.02
cleanout - number of ktugct calls 526 0.15 0.66
cleanouts and rollbacks - consistent read gets 35 0.01 0.04
cleanouts only - consistent read gets 299 0.08 0.38
cluster key scan block gets 9,347 2.60 11.73
cluster key scans 264 0.07 0.33
cluster wait time 94 0.03 0.12
commit batch/immediate performed 0 0.00 0.00
commit batch/immediate requested 0 0.00 0.00
commit cleanout failures: block lost 19 0.01 0.02
commit cleanout failures: callback failure 286 0.08 0.36
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 2,891 0.80 3.63
commit cleanouts successfully completed 2,586 0.72 3.24
commit immediate performed 0 0.00 0.00
commit immediate requested 0 0.00 0.00
commit txn count during cleanout 532 0.15 0.67
concurrency wait time 100 0.03 0.13
consistent changes 216 0.06 0.27
consistent gets 12,239,012 3,403.54 15,356.35
consistent gets - examination 805,980 224.13 1,011.27
consistent gets direct 12 0.00 0.02
consistent gets from cache 12,239,000 3,403.53 15,356.34
current blocks converted for CR 0 0.00 0.00
cursor authentications 90 0.03 0.11
data blocks consistent reads - undo records applied 71 0.02 0.09
db block changes 14,120 3.93 17.72
db block gets 14,857 4.13 18.64
db block gets direct 10 0.00 0.01
db block gets from cache 14,847 4.13 18.63
deferred (CURRENT) block cleanout applications 1,687 0.47 2.12
dirty buffers inspected 0 0.00 0.00
enqueue conversions 3,246 0.90 4.07
enqueue releases 125,415 34.88 157.36
enqueue requests 125,415 34.88 157.36
enqueue timeouts 0 0.00 0.00
enqueue waits 850 0.24 1.07
exchange deadlocks 0 0.00 0.00
execute count 15,996 4.45 20.07
free buffer inspected 2,658 0.74 3.34
free buffer requested 4,952 1.38 6.21
gc CPU used by this session 17,522 4.87 21.98
gc blocks lost 0 0.00 0.00
gc cr block build time 4 0.00 0.01
gc cr block flush time 2 0.00 0.00
gc cr block receive time 71 0.02 0.09
gc cr block send time 8 0.00 0.01
gc cr blocks received 1,996 0.56 2.50
gc cr blocks served 2,288 0.64 2.87
gc current block flush time 0 0.00 0.00
gc current block pin time 6 0.00 0.01
gc current block receive time 22 0.01 0.03
gc current block send time 11 0.00 0.01
gc current blocks received 761 0.21 0.95
gc current blocks served 2,776 0.77 3.48
gc local grants 525 0.15 0.66
gc remote grants 836 0.23 1.05
gcs messages sent 1,605,011 446.34 2,013.82
ges messages sent 14,977 4.16 18.79
global enqueue get time 176 0.05 0.22
global enqueue gets async 3,812 1.06 4.78
global enqueue gets sync 18,038 5.02 22.63
global enqueue releases 18,722 5.21 23.49
heap block compress 42 0.01 0.05
hot buffers moved to head of LRU 136 0.04 0.17
immediate (CR) block cleanout applications 334 0.09 0.42
immediate (CURRENT) block cleanout applications 357 0.10 0.45
index crx upgrade (positioned) 1,886 0.52 2.37
index fast full scans (full) 368 0.10 0.46
index fetch by key 395,262 109.92 495.94
index scans kdiixs1 77,206 21.47 96.87
leaf node 90-10 splits 10 0.00 0.01
leaf node splits 19 0.01 0.02
lob reads 3 0.00 0.00
lob writes 26 0.01 0.03
lob writes unaligned 26 0.01 0.03
logons cumulative 2,566 0.71 3.22
messages received 8,284 2.30 10.39
messages sent 8,284 2.30 10.39
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 11,376,255 3,163.61 14,273.85
opened cursors cumulative 11,567 3.22 14.51
parse count (failures) 0 0.00 0.00
parse count (hard) 1,203 0.33 1.51
parse count (total) 11,467 3.19 14.39
parse time cpu 1,240 0.34 1.56
parse time elapsed 1,250 0.35 1.57
physical read IO requests 1,530 0.43 1.92
physical read bytes 17,809,408 4,952.60 22,345.56
physical read total IO requests 13,941 3.88 17.49
physical read total bytes 223,560,192 62,169.68 280,502.12
physical read total multi block requests 184 0.05 0.23
physical reads 2,174 0.60 2.73
physical reads cache 1,006 0.28 1.26
physical reads cache prefetch 519 0.14 0.65
physical reads direct 1,168 0.32 1.47
physical reads direct (lob) 3 0.00 0.00
physical reads direct temporary tablespace 150 0.04 0.19
physical reads prefetch warmup 519 0.14 0.65
physical write IO requests 1,840 0.51 2.31
physical write bytes 18,128,896 5,041.45 22,746.42
physical write total IO requests 7,395 2.06 9.28
physical write total bytes 89,799,680 24,972.32 112,672.12
physical write total multi block requests 1,074 0.30 1.35
physical writes 2,213 0.62 2.78
physical writes direct 400 0.11 0.50
physical writes direct (lob) 10 0.00 0.01
physical writes direct temporary tablespace 150 0.04 0.19
physical writes from cache 1,813 0.50 2.27
physical writes non checkpoint 1,101 0.31 1.38
pinned buffers inspected 0 0.00 0.00
pinned cursors current 4 0.00 0.01
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 392 0.11 0.49
process last non-idle time 3,608 1.00 4.53
queries parallelized 78 0.02 0.10
recursive calls 60,808 16.91 76.30
recursive cpu usage 1,943 0.54 2.44
redo blocks written 7,512 2.09 9.43
redo buffer allocation retries 0 0.00 0.00
redo entries 9,954 2.77 12.49
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 135 0.04 0.17
redo size 3,257,216 905.80 4,086.85
redo subscn max counts 495 0.14 0.62
redo synch time 6 0.00 0.01
redo synch writes 160 0.04 0.20
redo wastage 449,508 125.00 564.00
redo write broadcast ack time 0 0.00 0.00
redo write time 80 0.02 0.10
redo writer latching time 0 0.00 0.00
redo writes 1,488 0.41 1.87
rollback changes - undo records applied 0 0.00 0.00
rollbacks only - consistent read gets 16 0.00 0.02
rows fetched via callback 194,337 54.04 243.84
session connect time 0 0.00 0.00
session cursor cache hits 3,459 0.96 4.34
session logical reads 12,253,861 3,407.67 15,374.98
shared hash latch upgrades - no wait 2,991 0.83 3.75
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 8,885 2.47 11.15
sorts (rows) 85,078,046 23,659.29 106,747.86
sql area evicted 35 0.01 0.04
sql area purged 0 0.00 0.00
summed dirty queue length 0 0.00 0.00
switch current to new buffer 96 0.03 0.12
table fetch by rowid 642,648 178.71 806.33
table fetch continued row 101 0.03 0.13
table scan blocks gotten 10,895,747 3,029.99 13,670.95
table scan rows gotten 594,615,801 165,356.25 746,067.50
table scans (long tables) 0 0.00 0.00
table scans (short tables) 9,347 2.60 11.73
total number of times SMON posted 21 0.01 0.03
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 0 0.00 0.00
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 1,047,280 291.24 1,314.03
user I/O wait time 486 0.14 0.61
user calls 22,178 6.17 27.83
user commits 731 0.20 0.92
user rollbacks 66 0.02 0.08
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 11,158 3.10 14.00
write clones created in background 0 0.00 0.00
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 19,673,426,016 20,198,389,696
session cursor cache count 269,565 273,189
session uga memory 1.2E+13 1.2E+13
opened cursors current 68 69
workarea memory allocated 0 1,815
logons current 79 77
session uga memory max 32,946,525,624 33,883,167,544
session pga memory 15,082,315,904 15,427,810,592

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 5 5.01

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)
WZT 659 0 6.15 1.74 867 0 2 0.00
SYSAUX 34 0 5.29 1.38 541 0 0 0.00
UNDOTBS2 25 0 0.00 1.00 153 0 1 0.00
SYSTEM 2 0 5.00 1.00 93 0 0 0.00
HIS_GPS_02_2 51 0 0.00 1.00 6 0 0 0.00
HIS_GPS_01_1 48 0 0.00 1.00 7 0 0 0.00
HIS_GPS_01_2 48 0 0.00 1.00 7 0 0 0.00
HIS_GPS_02_1 49 0 0.00 1.00 6 0 0 0.00
HIS_GPS_12_3 36 0 0.00 1.00 7 0 0 0.00
HIS_GPS_10_3 31 0 0.00 1.00 8 0 0 0.00
HIS_GPS_03_1 31 0 0.00 1.00 3 0 0 0.00
HIS_GPS_03_2 31 0 0.00 1.00 3 0 0 0.00
HIS_GPS_03_3 31 0 0.00 1.00 3 0 0 0.00
HIS_GPS_01_3 28 0 0.00 1.00 5 0 0 0.00
HIS_GPS_02_3 29 0 0.00 1.00 4 0 0 0.00
HIS_GPS_12_1 26 0 0.00 1.00 6 0 0 0.00
HIS_GPS_12_2 26 0 0.00 1.00 6 0 0 0.00
TS_IDX_YTMOT 20 0 0.00 1.00 10 0 0 0.00
HIS_GPS_09_2 23 0 0.00 1.00 6 0 0 0.00
HIS_GPS_10_2 23 0 0.00 1.00 6 0 0 0.00
HIS_GPS_11_2 23 0 0.00 1.00 6 0 0 0.00
HIS_GPS_11_3 23 0 0.00 1.00 6 0 0 0.00
HIS_GPS_08_3 18 0 0.00 1.00 6 0 0 0.00
HIS_GPS_08_1 14 0 0.00 1.00 6 0 0 0.00
TEMP 10 0 0.00 15.00 10 0 0 0.00
HIS_GPS_09_1 14 0 0.00 1.00 4 0 0 0.00
HIS_GPS_09_3 14 0 0.00 1.00 4 0 0 0.00
HIS_GPS_10_1 14 0 0.00 1.00 4 0 0 0.00
HIS_GPS_11_1 14 0 0.00 1.00 4 0 0 0.00
UNDOTBS1 13 0 0.00 1.00 5 0 0 0.00
HIS_GPS_07_3 10 0 0.00 1.00 4 0 0 0.00
HIS_GPS_08_2 10 0 0.00 1.00 4 0 0 0.00
HIS_GPS_04_1 11 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_2 8 0 0.00 1.00 4 0 0 0.00
HIS_GPS_06_3 8 0 0.00 1.00 4 0 0 0.00
HIS_GPS_07_1 8 0 0.00 1.00 4 0 0 0.00
HIS_GPS_07_2 8 0 0.00 1.00 4 0 0 0.00
HIS_GPS_04_2 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_04_3 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_05_1 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_05_2 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_05_3 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_1 6 0 0.00 1.00 3 0 0 0.00
HIS_GPS_20130501 1 0 0.00 1.00 1 0 0 0.00
HIS_GPS_20130502 1 0 0.00 1.00 1 0 0 0.00
HIS_GPS_20130503 1 0 0.00 1.00 1 0 0 0.00
SPLEX_TSP 1 0 0.00 1.00 1 0 0 0.00
USERS 1 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_01.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_1.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_11.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_21.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_31.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_02.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_12.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_2.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_22.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_32.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_3 +DATADG/gpsdb/dbf_01_03.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_3 +DATADG/gpsdb/dbf_01_13.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_3 +DATADG/gpsdb/dbf_01_3.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_01.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_1.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_11.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_21.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_31.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_02.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_12.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_2.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_22.dbf 11 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_32.dbf 11 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_3 +DATADG/gpsdb/dbf_02_03.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_3 +DATADG/gpsdb/dbf_02_13.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_3 +DATADG/gpsdb/dbf_02_3.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_1 +DATADG/gpsdb/dbf_03_1 11 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_1 +DATADG/gpsdb/dbf__03_01.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_1 +DATADG/gpsdb/dbf__03_11.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_2 +DATADG/gpsdb/dbf_03_02.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_2 +DATADG/gpsdb/dbf_03_12.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_2 +DATADG/gpsdb/dbf_03_2 11 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_3 +DATADG/gpsdb/dbf_03_03.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_3 +DATADG/gpsdb/dbf_03_13.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_3 +DATADG/gpsdb/dbf_03_3 11 0 0.00 1.00 1 0 0 0.00
HIS_GPS_04_1 +DATADG/gpsdb/dbf_04_1 11 0 0.00 1.00 1 0 0 0.00
HIS_GPS_04_2 +DATADG/gpsdb/dbf_04_2 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_04_3 +DATADG/gpsdb/dbf_04_3 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_05_1 +DATADG/gpsdb/dbf_05_1 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_05_2 +DATADG/gpsdb/dbf_05_2 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_05_3 +DATADG/gpsdb/dbf_05_3 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_1 +DATADG/gpsdb/dbf_06_1.dbf 2 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_1 +DATADG/gpsdb/dbf_06_1b.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_2 +DATADG/gpsdb/dbf_06_2.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_2 +DATADG/gpsdb/dbf_06_2b.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_3 +DATADG/gpsdb/dbf_06_3.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_3 +DATADG/gpsdb/dbf_06_3b.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_1 +DATADG/gpsdb/dbf_07_1.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_1 +DATADG/gpsdb/dbf_07_1b.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_2 +DATADG/gpsdb/dbf_07_2.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_2 +DATADG/gpsdb/dbf_07_2b.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_3 +DATADG/gpsdb/dbf_07_3.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_3 +DATADG/gpsdb/dbf_07_3b.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_1 +DATADG/gpsdb/dbf_08_1.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_1 +DATADG/gpsdb/dbf_08_1b.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_1 +FLASHAREA_DG/gpsdb/dbf_08_2.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_2 +DATADG/gpsdb/dbf_08_2.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_2 +DATADG/gpsdb/dbf_08_2b.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_3 +DATADG/gpsdb/dbf_08_3.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_3 +DATADG/gpsdb/dbf_08_3b.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_3 +DATADG/gpsdb/dbf_08_3c.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_1 +DATADG/gpsdb/dbf_09_1.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_1 +DATADG/gpsdb/dbf_09_1_01.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_2 +DATADG/gpsdb/dbf_09_2.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_2 +DATADG/gpsdb/dbf_09_2b.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_2 +DATADG/gpsdb/dbf_10_2_03.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_3 +DATADG/gpsdb/dbf_09_3.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_3 +DATADG/gpsdb/dbf_09_3b.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_1 +DATADG/gpsdb/dbf_10_1.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_1 +DATADG/gpsdb/dbf_10_1_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_2 +DATADG/gpsdb/dbf_10_2.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_2 +DATADG/gpsdb/dbf_10_2_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_2 +DATADG/gpsdb/dbf_10_2_12.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_3 +DATADG/gpsdb/dbf_10_3.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_3 +DATADG/gpsdb/dbf_10_3_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_3 +DATADG/gpsdb/dbf_10_3_03.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_3 +DATADG/gpsdb/dbf_10_3_13.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_1 +DATADG/gpsdb/dbf_11_1.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_1 +DATADG/gpsdb/dbf_11_1_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_2 +DATADG/gpsdb/dbf_11_2.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_2 +DATADG/gpsdb/dbf_11_2_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_2 +DATADG/gpsdb/dbf_11_2_12.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_3 +DATADG/gpsdb/dbf_11_3.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_3 +DATADG/gpsdb/dbf_11_3_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_3 +DATADG/gpsdb/dbf_11_3_03.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_1 +DATADG/gpsdb/dbf_12_01.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_1 +DATADG/gpsdb/dbf_12_1.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_1 +DATADG/gpsdb/dbf_12_11.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_2 +DATADG/gpsdb/dbf_12_02.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_2 +DATADG/gpsdb/dbf_12_12.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_2 +DATADG/gpsdb/dbf_12_2.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_3 +DATADG/gpsdb/dbf_12_03.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_3 +DATADG/gpsdb/dbf_12_23.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_12_3 +DATADG/gpsdb/dbf_12_3.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_3 +DATADG/gpsdb/dbf_12_3_13.dbf 9 0 0.00 1.00 2 0 0 0.00
HIS_GPS_20130501 +DATADG/gpsdb/dbf_130501.dbf 1 0 0.00 1.00 1 0 0 0.00
HIS_GPS_20130502 +DATADG/gpsdb/dbf_130502.dbf 1 0 0.00 1.00 1 0 0 0.00
HIS_GPS_20130503 +DATADG/gpsdb/dbf_130503.dbf 1 0 0.00 1.00 1 0 0 0.00
SPLEX_TSP +DATADG/gpsdb/splex_tbs_01.dbf 1 0 0.00 1.00 1 0 0 0.00
SYSAUX +DATADG/gpsdb/sysaux01.dbf 34 0 5.29 1.38 541 0 0 0.00
SYSTEM +DATADG/gpsdb/system01.dbf 2 0 5.00 1.00 93 0 0 0.00
TEMP +DATADG/gpsdb/temp01.dbf 10 0 0.00 15.00 10 0 0  
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_01.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_02.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_03.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_04.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_05.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_06.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_07.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_08.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_09.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_10.dbf 2 0 0.00 1.00 1 0 0 0.00
UNDOTBS1 +DATADG/gpsdb/undotbs01.dbf 1 0 0.00 1.00 1 0 0 0.00
UNDOTBS1 +DATADG/gpsdb/undotbs03.dbf 6 0 0.00 1.00 2 0 0 0.00
UNDOTBS1 +DATADG/gpsdb/undotbs05.dbf 6 0 0.00 1.00 2 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs02.dbf 1 0 0.00 1.00 70 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs04.dbf 6 0 0.00 1.00 22 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs06.dbf 6 0 0.00 1.00 51 0 1 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs07.dbf 6 0 0.00 1.00 2 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs08.dbf 6 0 0.00 1.00 8 0 0 0.00
USERS +DATADG/gpsdb/users01.dbf 1 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_01.dbf 22 0 11.82 2.00 33 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_02.dbf 21 0 4.29 1.71 27 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_03.dbf 9 0 4.44 1.00 10 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_04.dbf 8 0 10.00 1.50 12 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_05.dbf 7 0 10.00 2.14 12 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_06.dbf 36 0 8.33 2.06 29 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_07.dbf 52 0 6.73 1.73 47 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_08.dbf 25 0 5.60 1.84 31 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_09.dbf 14 0 9.29 1.50 59 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_10.dbf 4 0 7.50 3.50 27 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_11.dbf 53 0 5.28 1.98 62 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_12.dbf 48 0 6.46 1.65 82 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_13.dbf 51 0 6.27 2.24 67 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_14.dbf 19 0 23.68 1.68 37 0 1 0.00
WZT +DATADG/gpsdb/wzt_tbs_15.dbf 14 0 7.86 2.21 16 0 1 0.00
WZT +DATADG/gpsdb/wzt_tbs_16.dbf 9 0 7.78 2.33 26 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_17.dbf 17 0 5.88 1.94 29 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_18.dbf 16 0 11.25 2.19 33 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_19.dbf 30 0 6.67 2.57 46 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_20.dbf 22 0 6.82 1.32 30 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_21.dbf 19 0 4.21 1.95 35 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_22.dbf 11 0 10.00 2.00 11 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_23.dbf 8 0 3.75 2.75 12 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_24.dbf 6 0 1.67 1.17 7 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_25.dbf 5 0 4.00 1.00 5 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_26.dbf 6 0 0.00 1.00 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_27.dbf 8 0 0.00 1.00 7 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_28.dbf 8 0 0.00 1.00 14 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_29.dbf 8 0 0.00 1.00 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_30.dbf 8 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_31.dbf 8 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_32.dbf 8 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_33.dbf 10 0 0.00 1.00 26 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_34.dbf 11 0 0.91 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_35.dbf 10 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_36.dbf 10 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_37.dbf 10 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_38.dbf 10 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_39.dbf 10 0 0.00 1.00 1 0 0 0.00
WZT +FLASHAREA_DG/gpsdb/wzt_tbs_26.dbf 8 0 16.25 1.75 17 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 1,566,189 100 12,253,384 1,010 1,813 0 0 3


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 0 269 802 2731 2831130 2731  
E 0 0 347 829 2524 2831130 2524  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 1,296 0.10 155,277 1.31 1,967,153
D 2,592 0.20 310,554 1.22 1,836,632
D 3,888 0.30 465,831 1.20 1,813,637
D 5,184 0.40 621,108 1.18 1,776,229
D 6,480 0.50 776,385 1.15 1,735,885
D 7,776 0.59 931,662 1.01 1,526,418
D 9,072 0.69 1,086,939 1.00 1,505,689
D 10,368 0.79 1,242,216 1.00 1,505,638
D 11,664 0.89 1,397,493 1.00 1,505,298
D 12,960 0.99 1,552,770 1.00 1,505,298
D 13,072 1.00 1,566,189 1.00 1,505,298
D 14,256 1.09 1,708,047 1.00 1,505,298
D 15,552 1.19 1,863,324 1.00 1,505,298
D 16,848 1.29 2,018,601 1.00 1,505,298
D 18,144 1.39 2,173,878 1.00 1,505,298
D 19,440 1.49 2,329,155 1.00 1,505,298
D 20,736 1.59 2,484,432 1.00 1,505,298
D 22,032 1.69 2,639,709 1.00 1,505,298
D 23,328 1.78 2,794,986 1.00 1,505,298
D 24,624 1.88 2,950,263 1.00 1,505,298
D 25,920 1.98 3,105,540 1.00 1,505,298

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
99.96 22,232 8

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 8,192 7,084 415.45 0.00 0.00 0.00 0.00 838,860
E 8,192 7,087 415.08 0.00 0.00 0.00 0.00 838,860

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 7,784 7,784 0 0
64K 128K 411 411 0 0
256K 512K 32 32 0 0
512K 1024K 1,434 1,434 0 0
1M 2M 1,132 1,132 0 0
2M 4M 3 3 0 0
4M 8M 4 2 2 0
16M 32M 120 120 0 0
64M 128M 240 240 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
1,024 0.13 169,884.08 547.26 100.00 0
2,048 0.25 169,884.08 547.26 100.00 0
4,096 0.50 169,884.08 547.26 100.00 0
6,144 0.75 169,884.08 547.26 100.00 0
8,192 1.00 169,884.08 547.26 100.00 0
9,830 1.20 169,884.08 0.00 100.00 0
11,469 1.40 169,884.08 0.00 100.00 0
13,107 1.60 169,884.08 0.00 100.00 0
14,746 1.80 169,884.08 0.00 100.00 0
16,384 2.00 169,884.08 0.00 100.00 0
24,576 3.00 169,884.08 0.00 100.00 0
32,768 4.00 169,884.08 0.00 100.00 0
49,152 6.00 169,884.08 0.00 100.00 0
65,536 8.00 169,884.08 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)
1,408 0.19 807 41,559 36,179 0.99 4,011 1.09 6,280
2,144 0.29 1,536 54,856 36,391 1.00 3,799 1.03 6,299
2,880 0.39 2,268 72,799 36,438 1.00 3,752 1.02 6,304
3,616 0.50 3,003 86,892 36,463 1.00 3,727 1.01 6,308
4,352 0.60 3,738 104,089 36,478 1.00 3,712 1.00 6,310
5,088 0.70 4,471 118,994 36,487 1.00 3,703 1.00 6,311
5,824 0.80 5,206 137,069 36,490 1.00 3,700 1.00 6,312
6,560 0.90 5,941 154,768 36,494 1.00 3,696 1.00 6,312
7,296 1.00 6,676 170,084 36,496 1.00 3,694 1.00 6,313
8,032 1.10 7,411 184,824 36,498 1.00 3,692 1.00 6,313
8,768 1.20 8,146 203,491 36,500 1.00 3,690 1.00 6,314
9,504 1.30 8,881 216,414 36,502 1.00 3,688 1.00 6,314
10,240 1.40 9,616 229,007 36,504 1.00 3,686 1.00 6,315
10,976 1.50 10,351 244,087 36,506 1.00 3,684 1.00 6,315
11,712 1.61 11,086 265,427 36,508 1.00 3,682 1.00 6,315
12,448 1.71 11,821 282,587 36,510 1.00 3,680 1.00 6,316
13,184 1.81 12,556 302,406 36,513 1.00 3,677 1.00 6,316
13,920 1.91 13,291 314,893 36,515 1.00 3,675 0.99 6,317
14,656 2.01 14,656 379,687 36,536 1.00 3,654 0.99 6,320

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5,120 0.25 279,444 1,836,153
10,240 0.50 278,859 1,526,063
15,360 0.75 278,720 1,505,290
20,480 1.00 278,692 1,505,290
25,600 1.25 278,664 1,505,290
30,720 1.50 278,664 1,504,838
35,840 1.75 278,664 1,504,838
40,960 2.00 278,664 1,504,838

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 2 0 0
undo block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
CF-Controlfile Transaction 8,954 8,954 0 317 0 0.32
TT-Tablespace 307 307 0 139 0 0.50
TM-DML 2,124 2,124 0 148 0 0.41
PS-PX Process Reservation 535 535 0 177 0 0.23
JQ-Job Queue 60 60 0 15 0 0.67
SQ-Sequence Cache 2 2 0 1 0 10.00
TA-Instance Undo 12 12 0 12 0 0.00
WF-AWR Flush 20 20 0 9 0 0.00
TX-Transaction (row lock contention) 7 7 0 4 0 0.00
HW-Segment High Water Mark 1,307 1,307 0 3 0 0.00
FB-Format Block 2 2 0 2 0 0.00
MW-MWIN Schedule 2 2 0 2 0 0.00
WL-Being Written Redo Log 5 5 0 2 0 0.00
AF-Advisor Framework (task serialization) 7 7 0 1 0 0.00
JS-Job Scheduler (job run lock - synchronize) 2 2 0 1 0 0.00
UL-User-defined 2 2 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
5 0.24 1,297 127 3 15/17.1 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
14-Mar 10:10 36 282 0 3 16 0/0 0/0/0/0/0/0
14-Mar 10:00 65 173 0 3 15 0/0 0/0/0/0/0/0
14-Mar 09:50 10 152 0 1 15 0/0 0/0/0/0/0/0
14-Mar 09:40 8 117 0 1 15 0/0 0/0/0/0/0/0
14-Mar 09:30 16 158 127 2 17 0/0 0/0/0/0/0/0
14-Mar 09:20 15 114 0 3 15 0/0 0/0/0/0/0/0
14-Mar 09:10 89 301 0 3 15 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 allocation 150 0.00   0 0  
ASM db client latch 5,455 0.00   0 0  
ASM map headers 1,502 0.00   0 0  
ASM map load waiting list 374 0.00   0 0  
ASM map operation freelist 53 0.00   0 0  
ASM map operation hash table 1,516,245 0.00   0 0  
ASM network background latch 3,117 0.00   0 0  
AWR Alerted Metric Element list 22,535 0.00   0 0  
Consistent RBA 1,493 0.00   0 0  
FAL request queue 82 0.00   0 0  
FAL subheap alocation 82 0.00   0 0  
FIB s.o chain latch 30 0.00   0 0  
FOB s.o list latch 2,506 0.00   0 0  
JS broadcast add buf latch 2,988 0.00   0 0  
JS broadcast drop buf latch 2,989 0.00   0 0  
JS broadcast load blnc latch 2,885 0.00   0 0  
JS mem alloc latch 8 0.00   0 0  
JS queue access latch 8 0.00   0 0  
JS queue state obj latch 103,894 0.00   0 0  
JS slv state obj latch 52 0.00   0 0  
KCL gc element parent latch 28,803 0.01 0.50 0 119 0.00
KFK SGA context latch 7,254 0.00   0 0  
KFMD SGA 118 0.00   0 0  
KJC message pool free list 7,409 0.09 0.00 0 561 0.00
KJCT flow control latch 3,184,184 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 1,198 0.00   0 0  
KSXR large replies 2 0.00   0 0  
KTF sga latch 12 0.00   0 1,104 0.00
KWQMN job cache list latch 256 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 70 0.00
Memory Management Latch 0     0 1,198 0.00
OS process 7,389 0.00   0 0  
OS process allocation 6,122 0.07 0.00 0 0  
OS process: request allocation 4,840 0.00   0 0  
PL/SQL warning settings 2,628 0.00   0 0  
Reserved Space Latch 15 0.00   0 0  
SQL memory manager latch 1 0.00   0 1,157 0.00
SQL memory manager workarea list latch 90,434 0.00   0 0  
Shared B-Tree 130 0.00   0 0  
active checkpoint queue latch 11,489 0.03 0.00 0 0  
active service list 33,295 0.05 0.00 0 2,521 0.00
alert log latch 10 0.00   0 0  
archive control 135 0.00   0 0  
archive process latch 1,331 0.00   0 0  
begin backup scn array 10 0.00   0 0  
business card 156 0.00   0 0  
cache buffer handles 5,284 0.00   0 0  
cache buffers chains 23,833,235 0.01 0.01 0 28,446 0.01
cache buffers lru chain 9,741 0.03 0.00 0 28,636 0.01
channel handle pool latch 4,866 0.00   0 0  
channel operations parent latch 334,180 0.00 0.00 0 0  
checkpoint queue latch 779,032 0.00   0 2,174 0.00
client/application info 5,375 0.00   0 0  
compile environment latch 2,565 0.00   0 0  
dml lock allocation 4,280 0.00   0 0  
dummy allocation 5,132 0.04 0.00 0 0  
enqueue hash chains 263,640 0.00 0.00 0 11 0.00
enqueues 247,166 0.00 0.00 0 0  
error message lists 378 0.00   0 0  
event group latch 2,419 0.00   0 0  
file cache latch 1,986 0.00   0 0  
gcs opaque info freelist 3,926 0.00   0 0  
gcs partitioned table hash 272,129 0.00   0 0  
gcs remastering latch 44 0.00   0 0  
gcs resource freelist 41,624 0.00   0 43,578 0.00
gcs resource hash 107,459 0.01 0.10 0 0  
gcs shadows freelist 40,882 0.00   0 44,907 0.00
ges caches resource lists 16,946 0.11 0.00 0 47,813 0.01
ges deadlock list 234 0.00   0 0  
ges domain table 28,751 0.00   0 0  
ges enqueue table freelist 45,186 0.00   0 0  
ges group table 42,564 0.00   0 0  
ges process hash list 15,313 0.00   0 0  
ges process parent latch 93,620 0.00   0 0  
ges process table freelist 4,840 0.04 0.00 0 0  
ges resource hash list 94,582 0.04 0.21 0 5,214 0.17
ges resource scan list 38 0.00   0 0  
ges resource table freelist 8,110 0.00   0 0  
ges timeout list 1,752 0.00   0 1,228 0.00
global KZLD latch for mem in SGA 247 0.00   0 0  
hash table column usage latch 75 0.00   0 301,986 0.00
hash table modification latch 71 0.00   0 0  
interrupt manipulation 655 0.00   0 0  
job workq parent latch 0     0 124 0.00
job_queue_processes parameter latch 122 0.00   0 0  
kks stats 2,504 0.00   0 0  
kokc descriptor allocation latch 96 0.00   0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 21 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 1,957 0.00   0 0  
library cache 153,873 0.04 0.00 0 4,408 0.02
library cache load lock 40 0.00   0 0  
library cache lock 113,121 0.15 0.00 0 0  
library cache lock allocation 2,708 0.00   0 0  
library cache pin 46,961 0.00 0.00 0 0  
library cache pin allocation 438 0.00   0 0  
list of block allocation 180 0.00   0 0  
loader state object freelist 200 0.00   0 0  
logminer context allocation 1 0.00   0 0  
message pool operations parent latch 1,097 0.00   0 0  
messages 184,817 0.01 0.00 0 0  
mostly latch-free SCN 1,957 0.00   0 0  
msg queue 195 0.00   0 195 0.00
multiblock read objects 4,404 0.00   0 0  
name-service memory objects 24,160 0.00   0 0  
name-service namespace bucket 49,923 0.00   0 0  
name-service pending queue 3,898 0.00   0 0  
name-service request queue 45,684 0.00   0 0  
ncodef allocation latch 88 0.00   0 0  
object queue header heap 46,251 0.00   0 240 0.00
object queue header operation 62,449 0.07 0.02 0 0  
object stats modification 1 0.00   0 0  
parallel query alloc buffer 2,032 0.00   0 0  
parallel query stats 319 0.00   0 0  
parallel txn reco latch 5,640 0.00   0 0  
parameter list 9,913 0.01 0.00 0 0  
parameter table management 5,136 0.00   0 0  
post/wait queue 326 0.00   0 211 0.00
process allocation 42,086 0.10 0.86 0 2,415 0.17
process group creation 4,840 0.06 0.00 0 0  
process queue 849 0.00   0 0  
process queue reference 14,122 0.00   0 1,365 0.00
qmn task queue latch 508 0.00   0 0  
query server freelists 704 0.00   0 0  
queued dump request 17,976 0.00   0 0  
redo allocation 9,391 0.05 0.00 0 9,942 0.00
redo copy 0     0 9,942 0.04
redo writing 18,385 0.01 0.00 0 0  
reservation so alloc latch 10 0.00   0 0  
resmgr group change latch 721 0.00   0 0  
resmgr:active threads 5,117 0.00   0 0  
resmgr:actses change group 396 0.00   0 0  
resmgr:free threads list 5,116 0.10 0.00 0 0  
resmgr:resource group CPU method 398 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 1,008,750 0.04 0.00 0 44 0.00
rules engine rule set statistics 100 0.00   0 0  
segmented array pool 30 0.00   0 0  
sequence cache 7,401 0.07 0.00 0 0  
session allocation 12,109 0.61 0.07 0 0  
session idle bit 45,102 0.00   0 0  
session state list latch 846 0.00   0 0  
session switching 12,193 0.02 0.00 0 0  
session timer 1,849 0.00   0 0  
shared pool 151,172 0.09 0.02 0 0  
shared pool sim alloc 4 0.00   0 0  
shared pool simulator 6,707 0.00   0 0  
simulator hash latch 793,633 0.00   0 0  
simulator lru latch 0     0 793,563 0.02
slave class 593 0.00   0 0  
slave class create 2,632 0.04 1.00 0 0  
sort extent pool 153 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
threshold alerts latch 1,197 0.00   0 0  
transaction allocation 182 0.00   0 0  
transaction branch allocation 1,849 0.00   0 0  
undo global data 39,622 0.00   0 0  
user lock 7,582 0.53 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 23,833,235 3,235 38 3,197 0 0 0
shared pool 151,172 137 3 135 0 0 0
session allocation 12,109 74 5 69 0 0 0
process allocation 42,086 44 38 6 0 0 0
object queue header operation 62,449 42 1 41 0 0 0
ges resource hash list 94,582 34 7 27 0 0 0
gcs resource hash 107,459 10 1 9 0 0 0
KCL gc element parent latch 28,803 2 1 1 0 0 0
slave class create 2,632 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 kclhngcbk1 0 1 0
active service list kswslogon: session logout 0 6 6
cache buffers chains kcbgtcr: kslbegin excl 0 247 191
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 2 0
gcs resource hash kjbcropen:affinity 0 1 0
ges resource hash list kjakcai: search for resp by resname 0 3 0
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 3 0
ges resource hash list kjrmas1: lookup master node 0 1 0
object queue header operation kcbo_switch_mq_bg 0 7 0
process allocation ksucrp 0 35 0
process allocation ksufap: active procs 0 3 7
session allocation ksuxds: KSUSFCLC not set 0 5 4
shared pool kghfrunp: alloc: session dur 0 2 0
shared pool kghalo 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
YTGPS WZT YTO_MID_ROAD   TABLE 3,796,912 30.99
YTGPS WZT YTO_MID_ROAD_NUM   TABLE 2,524,240 20.60
YTGPS WZT YTO_AUDIT_RECORD   TABLE 1,518,528 12.39
YTGPS WZT YTO_AUDIT_DETAIL   TABLE 1,281,008 10.45
YTGPS WZT YTO_JINGANG_STATION   TABLE 1,190,336 9.71

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
YTGPS WZT PK_YTO_AUDIT_DETAIL   INDEX 215 9.89
YTGPS WZT YTO_MID_ROAD_NUM_INDEX1   INDEX 114 5.24
YTGPS WZT PK_YTO_AUDIT_RECORD   INDEX 106 4.88
YTGPS WZT YTO_MID_ROAD_PK   INDEX 98 4.51
YTGPS WZT PK_ROAD   INDEX 89 4.09

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
YTGPS WZT PK_YTO_AUDIT_RECORD   INDEX 25 96.15
YTGPS WZT YTO_MID_ROAD_PK   INDEX 1 3.85

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
YTGPS WZT YTO_AUDIT_RECORD   TABLE 1 50.00
YTGPS WZT YTO_JINGANG_USER   TABLE 1 50.00

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
YTGPS WZT YTO_AUDIT_DETAIL   TABLE 452 22.65
YTGPS WZT YTO_AUDIT_RECORD   TABLE 406 20.34
YTGPS WZT YTO_AUDIT_STATISTICS   TABLE 295 14.78
YTGPS WZT YTO_MID_ROAD_NUM   TABLE 104 5.21
YTGPS WZT YTO_MID_ROAD   TABLE 97 4.86

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
YTGPS WZT YTO_AUDIT_DETAIL   TABLE 106 13.93
YTGPS WZT YTO_AUDIT_RECORD   TABLE 97 12.75
YTGPS WZT YTO_AUDIT_STATISTICS   TABLE 96 12.61
SYS SYSTEM COL_USAGE$   TABLE 35 4.60
YTGPS WZT YTO_MID_ROAD_PK   INDEX 33 4.34

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 64 0.00 0   2 1
dc_database_links 2,646 0.00 0   0 1
dc_global_oids 269 0.00 0   0 120
dc_histogram_data 177,497 0.00 0   0 7,274
dc_histogram_defs 34,878 0.03 0   0 4,146
dc_object_ids 80,652 0.00 0   0 1,755
dc_objects 10,838 0.04 0   5 1,110
dc_profiles 311 0.00 0   0 1
dc_rollback_segments 10,284 0.00 0   0 472
dc_segments 33,932 0.01 0   2 9,792
dc_sequences 1 100.00 0   1 3
dc_tablespace_quotas 1 100.00 0   1 0
dc_tablespaces 43,938 0.00 0   0 50
dc_usernames 3,342 0.00 0   0 46
dc_users 55,285 0.00 0   0 75
outstanding_alerts 564 97.87 0   0 2

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 4 0 0
dc_histogram_defs 12 0 0
dc_object_ids 2 0 0
dc_objects 14 0 23
dc_segments 7 1 100
dc_sequences 2 1 0
dc_tablespace_quotas 2 1 0
outstanding_alerts 1,128 552 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,055 0.00 2,636 0.00 0 0
CLUSTER 3 0.00 9 0.00 0 0
SQL AREA 6,704 32.82 20,939 16.78 87 32
TABLE/PROCEDURE 322 0.31 26,474 0.08 13 0
TRIGGER 34 0.00 184 0.00 0 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 9 0 1 0 0
TABLE/PROCEDURE 6,631 17 5 12 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 369.24   4.50 4.67 16 16 82 82
  Freeable 45.56 0.00 1.47 1.50 6   31 31
  SQL 0.41 0.10 0.01 0.02 0 88 42 36
  PL/SQL 0.29 0.09 0.00 0.01 0 0 80 80
E Other 371.66   4.65 4.68 16 16 80 80
  Freeable 44.56 0.00 1.39 1.52 6   32 32
  SQL 0.44 0.11 0.01 0.02 0 89 40 34
  PL/SQL 0.29 0.09 0.00 0.01 0 0 78 78

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 13,706,985,472  
Fixed Size 2,134,704  
Redo Buffers 48,193,536  
Variable Size 7,717,522,768  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 32.00 32.00 0.00
large ASM map operations hashta 0.38 0.38 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.60 14.60 0.00
shared CCursor 131.05 134.47 2.61
shared PCursor 193.01 191.54 -0.76
shared db_block_hash_buckets 90.00 90.00 0.00
shared free memory 4,014.91 3,939.62 -1.88
shared gcs resources 334.35 334.35 0.00
shared gcs shadows 166.03 166.03 0.00
shared library cache 202.98 205.84 1.41
shared sql area 1,753.58 1,824.10 4.02
streams free memory 32.00 32.00 0.00
  buffer_cache 13,072.00 13,072.00 0.00
  fixed_sga 2.04 2.04 0.00
  log_buffer 45.96 45.96 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 0 0 0
QMON Coordinator 0 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 1,357,854 1,451,673 1794039 1794039


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_kghdsidx_count 3   
audit_file_dest /opt/app/oracle/admin/gpsdb/adump   
background_dump_dest /opt/app/oracle/admin/gpsdb/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.5.0   
control_files +DATADG/gpsdb/control01.ctl, +DATADG/gpsdb/control02.ctl, +DATADG/gpsdb/control03.ctl   
core_dump_dest /opt/app/oracle/admin/gpsdb/cdump   
db_block_size 8192   
db_cache_size 12884901888   
db_domain yto.com.cn   
db_file_multiblock_read_count 16   
db_name gpsdb   
db_recovery_file_dest +FLASHAREA_DG   
db_recovery_file_dest_size 1152642973696   
dispatchers (PROTOCOL=TCP) (SERVICE=gpsdbXDB)   
instance_number 2   
java_pool_size 33554432   
job_queue_processes 10   
large_pool_size 16777216   
local_listener (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.198.51)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.198.52)(PORT=1521)))   
log_archive_dest_1 LOCATION=USE_DB_RECOVERY_FILE_DEST   
log_archive_format %t_%s_%r.arc   
open_cursors 300   
pga_aggregate_target 8589934592   
processes 500   
remote_listener LISTENERS_GPSDB   
remote_login_passwordfile EXCLUSIVE   
sessions 555   
sga_max_size 21474836480   
sga_target 21474836480   
shared_pool_size 7516192768   
spfile +DATADG/gpsdb/spfilegpsdb.ora   
streams_pool_size 33554432   
thread 2   
undo_management AUTO   
undo_tablespace UNDOTBS2   
user_dump_dest /opt/app/oracle/admin/gpsdb/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 1,560,840 434.05 1,958.39
acks for commit broadcast(logical) 1,562,165 434.42 1,960.06
broadcast msgs on commit(actual) 1,458 0.41 1.83
broadcast msgs on commit(logical) 1,488 0.41 1.87
broadcast msgs on commit(wasted) 33 0.01 0.04
broadcast on commit wait time(ms) 1 0.00 0.00
broadcast on commit waits 19 0.01 0.02
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 1,374 0.38 1.72
gcs ast xid 0 0.00 0.00
gcs blocked converts 1,059 0.29 1.33
gcs blocked cr converts 2,000 0.56 2.51
gcs compatible basts 8 0.00 0.01
gcs compatible cr basts (global) 286 0.08 0.36
gcs compatible cr basts (local) 889 0.25 1.12
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 178 0.05 0.22
gcs dbwr write request msgs 210 0.06 0.26
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 832 0.23 1.04
gcs immediate (null) converts 43,675 12.15 54.80
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 463 0.13 0.58
gcs indirect ast 44,638 12.41 56.01
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 91 0.03 0.11
gcs msgs process time(ms) 8,721 2.43 10.94
gcs msgs received 1,657,399 460.90 2,079.55
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 0 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 0 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 0 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 1,891 0.53 2.37
gcs side channel msgs logical 3,249 0.90 4.08
gcs stale cr 0 0.00 0.00
gcs undo cr 1 0.00 0.00
gcs write notification msgs 3 0.00 0.00
gcs writes refused 2 0.00 0.00
ges msgs process time(ms) 286 0.08 0.36
ges msgs received 17,715 4.93 22.23
global posts dropped 0 0.00 0.00
global posts queue time 0 0.00 0.00
global posts queued 0 0.00 0.00
global posts requested 0 0.00 0.00
global posts sent 0 0.00 0.00
implicit batch messages received 23,676 6.58 29.71
implicit batch messages sent 8,040 2.24 10.09
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 6,399 1.78 8.03
messages queue sent actual 35,622 9.91 44.70
messages queue sent logical 44,400 12.35 55.71
messages received actual 1,626,672 452.36 2,040.99
messages received logical 1,675,112 465.83 2,101.77
messages sent directly 4,524 1.26 5.68
messages sent indirectly 17,585 4.89 22.06
messages sent not implicit batched 27,582 7.67 34.61
messages sent pbatched 1,592,719 442.92 1,998.39
msgs causing lmd to send msgs 7,528 2.09 9.45
msgs causing lms(s) to send msgs 3,016 0.84 3.78
msgs received queue time (ms) 17,760 4.94 22.28
msgs received queued 1,675,113 465.83 2,101.77
msgs sent queue time (ms) 764 0.21 0.96
msgs sent queue time on ksxp (ms) 138,632 38.55 173.94
msgs sent queued 44,106 12.27 55.34
msgs sent queued on ksxp 1,590,323 442.25 1,995.39
number of ges deadlock detected 0 0.00 0.00
process batch messages received 8,538 2.37 10.71
process batch messages sent 1,571,514 437.02 1,971.79


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 2,153
CURRENT Block Requests 131
Data Block Requests 2,156
Undo Block Requests 1
TX Block Requests 27
Current Results 2,261
Private results 15
Zero Results 8
Disk Read Results 0
Fail Results 0
Fairness Down Converts 475
Fairness Clears 0
Free GC Elements 0
Flushes 36
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 0
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 2,780 100.00 0.00 0.00 0.00 0.00
Flushes 2 100.00 0.00 0.00 0.00 0.00
Writes 264 77.27 20.45 0.00 0.76 1.52


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 1,800 99.56 0.17 0.28 681 99.85 0.15 0.00
1 Others 179 100.00 0.00 0.00 62 100.00 0.00 0.00
1 undo header 14 100.00 0.00 0.00 6 100.00 0.00 0.00


Back to Top

End of Report