WORKLOAD REPOSITORY report for

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2102613-Mar-14 15:00:5272 .8
End Snap:2102713-Mar-14 16:00:4277 .8
Elapsed:  59.83 (mins)  
DB Time:  7.94 (mins)  

Report Summary

Cache Sizes

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

Load Profile

Per SecondPer Transaction
Redo size: 793.54 3,699.82
Logical reads: 3,487.02 16,257.90
Block changes: 3.28 15.31
Physical reads: 0.41 1.91
Physical writes: 0.44 2.04
User calls: 6.62 30.87
Parses: 3.24 15.11
Hard parses: 0.40 1.87
Sorts: 2.53 11.79
Logons: 0.96 4.49
Executes: 4.51 21.03
Transactions: 0.21 

% Blocks changed per Read: 0.09Recursive Call %: 71.63
Rollback per transaction %: 8.70Rows per Sort: 1984.42

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 92.47Soft Parse %: 87.60
Execute to Parse %: 28.15Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 102.59% Non-Parse CPU: 97.24

Shared Pool Statistics

BeginEnd
Memory Usage %: 58.47 59.68
% SQL with executions>1: 95.23 95.21
% Memory for SQL w/exec>1: 95.20 95.11

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  574  120.5 
control file sequential read 12,345 4 0 .8System I/O
db file sequential read 312 2 5 .3User I/O
control file parallel write 1,378 2 1 .3System I/O
log file parallel write 1,474 1 0 .1System I/O

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 1.01 4.71
Global Cache blocks served: 0.58 2.73
GCS/GES messages received: 456.51 2,128.44
GCS/GES messages sent: 440.97 2,055.99
DBWR Fusion writes: 0.05 0.24
Estd Interconnect traffic (KB) 188.05 

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

Buffer access - local cache %: 99.97
Buffer access - remote cache %: 0.03
Buffer access - disk %: 0.00

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1
Avg global cache cr block receive time (ms): 0.6
Avg global cache current block receive time (ms): 0.6
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 0.9
Avg global cache cr block flush time (ms): 1.8
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.1
Global cache log flushes for current blocks served %: 0.2
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: 13.86
% of indirect sent messages: 56.25
% of flow controlled messages: 29.90


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 574.18 120.47
sql execute elapsed time 444.78 93.32
parse time elapsed 16.06 3.37
hard parse elapsed time 14.77 3.10
connection management call elapsed time 3.69 0.77
PL/SQL execution elapsed time 0.69 0.14
sequence load elapsed time 0.01 0.00
hard parse (sharing criteria) elapsed time 0.00 0.00
repeated bind elapsed time 0.00 0.00
DB time 476.62  
background cpu time 185.23  
background elapsed time 132.98  

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     574   120.47
System I/O 16,327   6 0 1.35
User I/O 1,701   3 2 0.54
Other 53,890 81 2 0 0.45
Concurrency 711   1 1 0.19
Cluster 3,631   1 0 0.17
Commit 132   0 0 0.01
Application 140   0 0 0.01
Network 20,381   0 0 0.01
Configuration 4   0 0 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file sequential read 12,345   4 0 16.03
db file sequential read 312   2 5 0.41
control file parallel write 1,378   2 1 1.79
log file parallel write 1,474   1 0 1.91
os thread startup 20   1 29 0.03
latch free 52   1 11 0.07
rdbms ipc reply 6,218   0 0 8.08
db file parallel write 1,073   0 0 1.39
db file scattered read 57   0 7 0.07
gc cr block 2-way 1,458   0 0 1.89
reliable message 250   0 1 0.32
row cache lock 587   0 0 0.76
direct path read 1,018   0 0 1.32
CGS wait for IPC msg 30,784 99 0 0 39.98
log file sequential read 21   0 11 0.03
db file parallel read 26   0 8 0.03
gc cr multi block request 1,155   0 0 1.50
ksxr poll remote instances 10,980 89 0 0 14.26
gc current block 2-way 509   0 0 0.66
DFS lock handle 493   0 0 0.64
gc current grant busy 330   0 0 0.43
enq: CF - contention 549   0 0 0.71
log file sync 132   0 0 0.17
enq: PS - contention 168   0 0 0.22
PX Deq: reap credit 3,802 93 0 0 4.94
enq: TM - contention 136   0 0 0.18
gc current multi block request 127   0 0 0.16
enq: TT - contention 141   0 0 0.18
PX Deq Credit: send blkd 197 75 0 0 0.26
direct path write 288   0 0 0.37
library cache lock 81   0 0 0.11
SQL*Net message to client 18,886   0 0 24.53
SQL*Net more data from client 1,471   0 0 1.91
CSS operation: query 6   0 2 0.01
gcs log flush sync 27   0 0 0.04
PX Deq: Signal ACK 125 18 0 0 0.16
gc current grant 2-way 40   0 0 0.05
Log archive I/O 28   0 0 0.04
IPC send completion sync 30 100 0 0 0.04
enq: TA - contention 11   0 0 0.01
log file single write 8   0 0 0.01
enq: WF - contention 9   0 0 0.01
enq: JQ - contention 10   0 0 0.01
CSS initialization 2   0 1 0.00
gc cr grant 2-way 6   0 0 0.01
gc cr block busy 2   0 1 0.00
enq: HW - contention 4   0 0 0.01
library cache pin 7   0 0 0.01
CSS operation: action 6   0 0 0.01
gc current block unknown 3   0 0 0.00
latch: cache buffers chains 15   0 0 0.02
SQL*Net more data to client 24   0 0 0.03
enq: WL - contention 2   0 0 0.00
enq: MW - 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 8   0 0 0.01
SQL*Net break/reset to client 2   0 0 0.00
gc buffer busy 1   0 0 0.00
enq: TX - row lock contention 1   0 0 0.00
enq: UL - contention 1   0 0 0.00
enq: JS - job run lock - synchronize 1   0 0 0.00
enq: FB - contention 1   0 0 0.00
KJC: Wait for msg sends to complete 2   0 0 0.00
latch: row cache objects 1   0 0 0.00
cursor: pin S 2   0 0 0.00
LGWR wait for redo copy 3   0 0 0.00
latch: object queue header operation 1   0 0 0.00
gcs remote message 2,841,457 45 56,004 20 3,690.20
SQL*Net message from client 22,174   54,952 2478 28.80
class slave wait 1,350 83 6,955 5152 1.75
Streams AQ: qmn slave idle wait 127   3,505 27601 0.16
Streams AQ: qmn coordinator idle wait 254 50 3,505 13800 0.33
DIAG idle wait 17,946   3,505 195 23.31
PX Idle Wait 1,503 94 3,505 2332 1.95
ges remote message 64,078 67 3,504 55 83.22
ASM background timer 1,664   3,502 2105 2.16
virtual circuit status 120 100 3,492 29102 0.16
jobq slave wait 1,270 79 3,473 2735 1.65
Streams AQ: waiting for time management or cleanup tasks 1 100 839 839457 0.00
KSV master wait 219   17 77 0.28
PX Deq: Execution Msg 354 7 0 1 0.46
PX Deq: Join ACK 227 34 0 0 0.29
PX Deq: Parse Reply 213 37 0 0 0.28
PX Deq: Execute Reply 189 34 0 0 0.25
PX Deq: Msg Fragment 142 2 0 0 0.18
Streams AQ: RAC qmn coordinator idle wait 254 100 0 0 0.33

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file sequential read 11,791   3 0 15.31
control file parallel write 1,378   2 1 1.79
events in waitclass Other 42,974 93 1 0 55.81
log file parallel write 1,473   1 0 1.91
os thread startup 20   1 29 0.03
db file parallel write 1,073   0 0 1.39
direct path read 1,018   0 0 1.32
log file sequential read 21   0 11 0.03
enq: TM - contention 133   0 0 0.17
direct path write 279   0 0 0.36
gc current block 2-way 49   0 0 0.06
Log archive I/O 28   0 0 0.04
library cache lock 23   0 0 0.03
gc cr block 2-way 19   0 0 0.02
log file single write 8   0 0 0.01
gc cr multi block request 14   0 0 0.02
latch: row cache objects 1   0 0 0.00
rdbms ipc message 82,393 64 73,202 888 107.00
gcs remote message 2,841,442 45 56,004 20 3,690.18
class slave wait 1,342 84 6,950 5179 1.74
Streams AQ: qmn slave idle wait 127   3,505 27601 0.16
Streams AQ: qmn coordinator idle wait 254 50 3,505 13800 0.33
DIAG idle wait 17,946   3,505 195 23.31
ges remote message 64,086 67 3,504 55 83.23
ASM background timer 1,664   3,502 2105 2.16
pmon timer 1,915 100 3,501 1828 2.49
smon timer 19   3,155 166047 0.02
Streams AQ: waiting for time management or cleanup tasks 1 100 839 839457 0.00
KSV master wait 219   17 77 0.28
Streams AQ: RAC qmn coordinator idle wait 254 100 0 0 0.33

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 106,730
IDLE_TIME 22,862,676
IOWAIT_TIME 767
NICE_TIME 41
SYS_TIME 30,599
USER_TIME 71,825
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 220,743,680
VM_OUT_BYTES 450,514,944
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 473.60 570.40 408 12,451,593
SYS$USERS 2.70 3.50 1 30,575
SYS$BACKGROUND 0.00 0.10 1,069 33,534
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 207 1 70 0 0 0 13119 0
SYS$USERS 1 0 25 0 0 0 152 0
SYS$BACKGROUND 1497 1 616 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
34 35 14 2.43 7.15 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
25 26 12 2.08 5.24 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
23 23 151 0.15 4.78 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
22 22 138 0.16 4.61 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
6 6 71 0.08 1.19 ak9um20829hhf JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
5 5 91 0.05 0.97 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
3 3 2 1.52 0.64 g6mrfm9yr0y4x JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
3 3 1 2.61 0.55 0suvf6uupkfv4 JDBC Thin Client SELECT T.AUDIT_ID , M.ROAD_ID ...
2 3 15 0.17 0.52 396ga4w3na138 JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
2 2 29 0.07 0.44 7bwxgqjqqwn1y JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...

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
35 34 14 2.49 6.07 7.15 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
26 25 12 2.13 4.45 5.24 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
23 23 151 0.15 4.05 4.78 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
22 22 138 0.16 3.91 4.61 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
6 6 71 0.08 1.01 1.19 ak9um20829hhf JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
5 5 91 0.05 0.82 0.97 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
3 3 2 1.56 0.54 0.64 g6mrfm9yr0y4x JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
3 3 1 2.67 0.46 0.55 0suvf6uupkfv4 JDBC Thin Client SELECT T.AUDIT_ID , M.ROAD_ID ...
3 2 15 0.17 0.44 0.52 396ga4w3na138 JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
2 2 29 0.07 0.37 0.44 7bwxgqjqqwn1y JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...

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,167,428 138 8,459.62 9.33 22.44 21.96 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
1,103,149 151 7,305.62 8.81 23.28 22.77 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
298,200 71 4,200.00 2.38 5.83 5.69 ak9um20829hhf JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
291,708 91 3,205.58 2.33 4.69 4.62 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
181,104 14 12,936.00 1.45 34.85 34.07 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
175,920 29 6,066.21 1.41 2.12 2.08 7bwxgqjqqwn1y JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
166,192 26 6,392.00 1.33 1.84 1.82 2h79jm9f76rau JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
157,765 12 13,147.08 1.26 25.56 24.99 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
60,048 8 7,506.00 0.48 1.80 1.76 bp4krvud9bjpn JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
54,810 15 3,654.00 0.44 2.55 2.49 396ga4w3na138 JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...

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
120 1 120.00 8.17 0.48 0.99 bpu82rmw6n4rc JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
36 62 0.58 2.45 0.05 0.12 54g344fvq2153 JDBC Thin Client SELECT T6.DISTRICT_NAMES , T1....
9 1 9.00 0.61 1.66 1.68 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
8 91 0.09 0.54 4.69 4.62 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
2 14 0.14 0.14 34.85 34.07 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
1 60 0.02 0.07 1.62 1.59 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
1 12 0.08 0.07 25.56 24.99 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
0 1 0.00 0.00 0.00 0.00 04xtrk7uyhknh   select obj#, type#, ctime, mti...
0 60 0.00 0.00 0.00 0.00 089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
0 1 0.00 0.00 0.03 0.04 0dwr2vd6vbqzs   SELECT count(*) over () as tot...

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
724 1,612 2.23 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
552 0 0.00 0.00 0.00 c4nhd1ntptxq7 MMON_SLAVE select message_level, sequence...
329 724 2.20 0.00 0.00 0k8522rmdzg4k   select privilege# from sysauth...
315 315 1.00 0.00 0.00 18naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
306 0 0.00 0.00 0.00 az33m61ym46y4   SELECT NULL AS table_cat, o.ow...
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...
270 270 1.00 0.00 0.00 5kyb5bvnu3s04 SEVERITY EVALUATION SELECT DISTINCT METRIC_GUID FR...
265 265 1.00 0.00 0.00 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
265 265 1.00 0.00 0.00 459f3z9u4fb3u   select value$ from props$ wher...
265 265 1.00 0.00 0.00 5ur69atw3vfhj   select decode(failover_method,...
240 240 1.00 0.00 0.00 b0320g1xasbx7 SEVERITY EVALUATION SELECT TIMEZONE_REGION FROM MG...
240 240 1.00 0.00 0.00 c3hhngpbpvvmk SEVERITY EVALUATION SELECT MARKER_TIMESTAMP FROM M...
240 240 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
724 724 6.22 0h6b2sajwb74n   select privilege#, level from ...
552 552 4.74 c4nhd1ntptxq7 MMON_SLAVE select message_level, sequence...
329 329 2.83 0k8522rmdzg4k   select privilege# from sysauth...
305 306 2.62 az33m61ym46y4   SELECT NULL AS table_cat, o.ow...
282 282 2.42 6xvp6nxs4a9n4   select nvl(sum(space), 0) from...
282 282 2.42 csnp95dz2r8ss   select file#, block# from recy...
265 265 2.28 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
265 265 2.28 459f3z9u4fb3u   select value$ from props$ wher...
265 265 2.28 5ur69atw3vfhj   select decode(failover_method,...
151 151 1.30 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
138 138 1.19 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
124 124 1.07 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
124 124 1.07 g00cj285jmgsw   update sys.mon_mods$ set inser...
120 240 1.03 c3hhngpbpvvmk SEVERITY EVALUATION SELECT MARKER_TIMESTAMP FROM M...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,453,223 1 0.02 8f1sjvfxuup9w PL/SQL Developer select t.*, o.*, m.comments fr...

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.15 15.47 0.99 0.48 1 bpu82rmw6n4rc JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
0.06 0.27 21.96 22.44 138 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
0.05 1.15 4.62 4.69 91 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
0.04 0.19 22.77 23.28 151 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
0.04 0.11 34.07 34.85 14 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
0.03 0.11 24.99 25.56 12 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
0.02 1.08 1.68 1.66 1 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
0.02 3.65 0.48 0.47 13 6wsph5c17t4kb JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
0.02 3.58 0.48 0.48 14 ajzh5n7z4wgxh JDBC Thin Client SELECT * FROM (SELECT AUDIT_AL...
0.02 14.32 0.12 0.05 62 54g344fvq2153 JDBC Thin Client SELECT T6.DISTRICT_NAMES , T1....
0.01 0.32 2.08 2.12 29 7bwxgqjqqwn1y JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
0.01 0.32 1.82 1.84 26 2h79jm9f76rau JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
0.01 0.93 0.54 0.55 1 84qubbrsr0kfn   insert into wrh$_latch (snap_i...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
089dbukv1aanhSELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
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
0suvf6uupkfv4 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 , 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
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')
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))
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
396ga4w3na138 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 ='Ī' /* 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 ='·' /*OR B.ALIAS1='·' OR B.ALIAS2='·' OR B.ALIAS3='·'*/ OR B.NAME like'%2ºÅ%' /* OR B.ALIAS1='2ºÅ' OR B.ALIAS2='2ºÅ' OR B.ALIAS3='2ºÅ'*/ OR B.NAME ='À³' /*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='³£ÊìÊÐ' OR B.NAME ='Ī' /* OR B.ALIAS1='Ī' OR B.ALIAS2='Ī' OR B.ALIAS3 ='Ī'*/ OR B.NAME like'%³ÇÕò%' /* OR B.ALIAS1='³ÇÕò' OR B.ALIAS2='³ÇÕò' OR B.AL IAS3='³ÇÕò'*/ 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 ='·' /*OR B.ALIAS1='·' OR B.ALIAS2='·' OR B.ALIAS3='·'*/ OR B.NAME like'%2ºÅ%' /* OR B.ALIAS1='2ºÅ' OR B.ALIAS2='2ºÅ' OR B.ALIAS3='2ºÅ'*/ OR B.NAME ='À³' /*OR B.ALIAS1='À³' 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='ËÕÖÝÊÐ')
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'
5kyb5bvnu3s04SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
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||'%'
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
8f1sjvfxuup9wselect t.*, o.*, m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null
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
ak9um20829hhfSELECT 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='ËÕÖÝ'*/ ) 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.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='ËÕÖÝÊÐ')
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
b0320g1xasbx7SELECT TIMEZONE_REGION FROM MGMT_TARGETS WHERE TARGET_GUID = :B1
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 )
bp4krvud9bjpn 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'%3ºÅ%' /* OR B.ALIAS1='3ºÅ' OR B.ALIAS2='3ºÅ' OR B.ALIAS3='3ºÅ'*/ 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'%3ºÅ%' /* OR B.ALIAS1='3ºÅ' OR B.ALIAS2='3ºÅ' OR B.ALIAS3='3ºÅ'*/ OR B.NAME like'%³£ÖÝ%' /* OR B.ALIAS1='³£ÖÝ' OR B.ALIAS2='³£ÖÝ' O R 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 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='ËÕÖÝÊÐ')
bpu82rmw6n4rcSELECT COUNT(1) FROM ( SELECT T2.BASE_DATE_ID, T1.LEVEL_ID, T2.ORG_PROVINCES, T2.ORG_NAME, T2.ORG_CODE, T2.PRINCIPAL_NAME, T2.PRINCIPAL_CODE, T1.PRINCIPAL_PHONE, T1.ORG_ADDRESS, T1.DISPATCH_IN, T1.DISPATCH_OUT, T1.AUDIT_STATUS, T1.AUDIT_ADVICE, T1.MODIFY_TIME, T3.USER_NAME MODIFY_USER_NAME, T1.MODIFY_USER_CODE, T4.CODE, T4.NAME, T1.XY_LOCATION, T1.OUT_DISPLAY_NAME , T1.CSMANAGER_NAME, T1.CSMANAGER_PHONE , T1.DAILY_AFFAIRS_NAME , T1.DAILY_AFFAIRS_PHONE FROM YTO_ORG_BASE_DATE T2 LEFT JOIN YTO_ORG_LEVEL_AUDIT T1 ON T1.BASE_DATE_ID = T2.BASE_DATE_ID LEFT JOIN YTO_JINGANG_USER T3 ON T3.USER_CODE = T1.MODIFY_USER_CODE LEFT JOIN YTO_JINGANG_STATION T4 ON T4.CODE = T3.USER_ORG_CODE WHERE 1 = 1 AND T2.ORG_CODE IN (SELECT G.CODE FROM YTO_JINGANG_STATION G START WITH G.CODE = :1 CONNECT BY PRIOR G.ID = G.PARENT_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
d92h3rjp0y217begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
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
g6mrfm9yr0y4x 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 AND M.NAME LIKE '%'||:3||'%' )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 47,776 13.31 62.05
CPU used when call started 47,368 13.19 61.52
CR blocks created 34 0.01 0.04
Cached Commit SCN referenced 0 0.00 0.00
Commit SCN cached 0 0.00 0.00
DB time 404,287 112.61 525.05
DBWR checkpoint buffers written 1,149 0.32 1.49
DBWR checkpoints 4 0.00 0.01
DBWR fusion writes 181 0.05 0.24
DBWR transaction table writes 67 0.02 0.09
DBWR undo block writes 194 0.05 0.25
DFO trees parallelized 78 0.02 0.10
PX local messages recv'd 420 0.12 0.55
PX local messages sent 420 0.12 0.55
PX remote messages recv'd 216 0.06 0.28
PX remote messages sent 342 0.10 0.44
Parallel operations not downgraded 78 0.02 0.10
RowCR - row contention 1 0.00 0.00
RowCR attempts 204 0.06 0.26
RowCR hits 203 0.06 0.26
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 11,786 3.28 15.31
active txn count during cleanout 48 0.01 0.06
application wait time 4 0.00 0.01
background checkpoints completed 5 0.00 0.01
background checkpoints started 4 0.00 0.01
background timeouts 22,838 6.36 29.66
buffer is not pinned count 494,579 137.76 642.31
buffer is pinned count 2,010,808 560.11 2,611.44
bytes received via SQL*Net from client 6,747,918 1,879.62 8,763.53
bytes sent via SQL*Net to client 4,252,248 1,184.45 5,522.40
calls to get snapshot scn: kcmgss 74,753 20.82 97.08
calls to kcmgas 4,563 1.27 5.93
calls to kcmgcs 91 0.03 0.12
change write time 15 0.00 0.02
cleanout - number of ktugct calls 188 0.05 0.24
cleanouts and rollbacks - consistent read gets 5 0.00 0.01
cleanouts only - consistent read gets 82 0.02 0.11
cluster key scan block gets 8,477 2.36 11.01
cluster key scans 256 0.07 0.33
cluster wait time 82 0.02 0.11
commit batch/immediate performed 2 0.00 0.00
commit batch/immediate requested 2 0.00 0.00
commit cleanout failures: block lost 19 0.01 0.02
commit cleanout failures: callback failure 111 0.03 0.14
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 2,511 0.70 3.26
commit cleanouts successfully completed 2,381 0.66 3.09
commit immediate performed 2 0.00 0.00
commit immediate requested 2 0.00 0.00
commit txn count during cleanout 189 0.05 0.25
concurrency wait time 88 0.02 0.11
consistent changes 52 0.01 0.07
consistent gets 12,506,263 3,483.59 16,241.90
consistent gets - examination 477,946 133.13 620.71
consistent gets direct 8 0.00 0.01
consistent gets from cache 12,506,255 3,483.59 16,241.89
current blocks converted for CR 0 0.00 0.00
cursor authentications 184 0.05 0.24
data blocks consistent reads - undo records applied 8 0.00 0.01
db block changes 11,788 3.28 15.31
db block gets 12,323 3.43 16.00
db block gets direct 8 0.00 0.01
db block gets from cache 12,315 3.43 15.99
deferred (CURRENT) block cleanout applications 1,430 0.40 1.86
dirty buffers inspected 0 0.00 0.00
enqueue conversions 1,606 0.45 2.09
enqueue releases 65,249 18.17 84.74
enqueue requests 65,250 18.18 84.74
enqueue timeouts 1 0.00 0.00
enqueue waits 828 0.23 1.08
exchange deadlocks 0 0.00 0.00
execute count 16,194 4.51 21.03
free buffer inspected 1,919 0.53 2.49
free buffer requested 5,251 1.46 6.82
gc CPU used by this session 17,057 4.75 22.15
gc blocks lost 0 0.00 0.00
gc cr block build time 3 0.00 0.00
gc cr block flush time 2 0.00 0.00
gc cr block receive time 140 0.04 0.18
gc cr block send time 3 0.00 0.00
gc cr blocks received 2,483 0.69 3.22
gc cr blocks served 1,283 0.36 1.67
gc current block flush time 0 0.00 0.00
gc current block pin time 1 0.00 0.00
gc current block receive time 73 0.02 0.09
gc current block send time 5 0.00 0.01
gc current blocks received 1,144 0.32 1.49
gc current blocks served 817 0.23 1.06
gc local grants 340 0.09 0.44
gc remote grants 385 0.11 0.50
gcs messages sent 1,568,354 436.86 2,036.82
ges messages sent 14,758 4.11 19.17
global enqueue get time 217 0.06 0.28
global enqueue gets async 4,870 1.36 6.32
global enqueue gets sync 18,693 5.21 24.28
global enqueue releases 19,984 5.57 25.95
heap block compress 29 0.01 0.04
hot buffers moved to head of LRU 27 0.01 0.04
immediate (CR) block cleanout applications 87 0.02 0.11
immediate (CURRENT) block cleanout applications 323 0.09 0.42
index crx upgrade (positioned) 1,899 0.53 2.47
index fast full scans (full) 451 0.13 0.59
index fetch by key 208,760 58.15 271.12
index scans kdiixs1 109,446 30.49 142.14
leaf node 90-10 splits 12 0.00 0.02
leaf node splits 20 0.01 0.03
lob reads 0 0.00 0.00
lob writes 33 0.01 0.04
lob writes unaligned 33 0.01 0.04
logons cumulative 3,459 0.96 4.49
messages received 9,370 2.61 12.17
messages sent 9,370 2.61 12.17
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 11,968,708 3,333.85 15,543.78
opened cursors cumulative 11,680 3.25 15.17
parse count (failures) 0 0.00 0.00
parse count (hard) 1,443 0.40 1.87
parse count (total) 11,635 3.24 15.11
parse time cpu 1,582 0.44 2.05
parse time elapsed 1,542 0.43 2.00
physical read IO requests 1,316 0.37 1.71
physical read bytes 12,025,856 3,349.77 15,617.99
physical read total IO requests 13,843 3.86 17.98
physical read total bytes 218,834,432 60,955.77 284,200.56
physical read total multi block requests 60 0.02 0.08
physical reads 1,468 0.41 1.91
physical reads cache 442 0.12 0.57
physical reads cache prefetch 216 0.06 0.28
physical reads direct 1,026 0.29 1.33
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 194 0.05 0.25
physical write IO requests 1,361 0.38 1.77
physical write bytes 12,853,248 3,580.24 16,692.53
physical write total IO requests 6,987 1.95 9.07
physical write total bytes 85,121,024 23,710.24 110,546.78
physical write total multi block requests 1,034 0.29 1.34
physical writes 1,569 0.44 2.04
physical writes direct 288 0.08 0.37
physical writes direct (lob) 8 0.00 0.01
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 1,281 0.36 1.66
physical writes non checkpoint 727 0.20 0.94
pinned buffers inspected 0 0.00 0.00
pinned cursors current 2 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 24 0.01 0.03
process last non-idle time 3,599 1.00 4.67
queries parallelized 78 0.02 0.10
recursive calls 60,017 16.72 77.94
recursive cpu usage 2,234 0.62 2.90
redo blocks written 6,561 1.83 8.52
redo buffer allocation retries 0 0.00 0.00
redo entries 8,130 2.26 10.56
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 118 0.03 0.15
redo size 2,848,860 793.54 3,699.82
redo subscn max counts 297 0.08 0.39
redo synch time 5 0.00 0.01
redo synch writes 129 0.04 0.17
redo wastage 458,768 127.79 595.80
redo write broadcast ack time 0 0.00 0.00
redo write time 70 0.02 0.09
redo writer latching time 0 0.00 0.00
redo writes 1,473 0.41 1.91
rollback changes - undo records applied 5 0.00 0.01
rollbacks only - consistent read gets 3 0.00 0.00
rows fetched via callback 67,158 18.71 87.22
session connect time 0 0.00 0.00
session cursor cache hits 3,032 0.84 3.94
session logical reads 12,518,586 3,487.02 16,257.90
shared hash latch upgrades - no wait 2,540 0.71 3.30
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 9,082 2.53 11.79
sorts (rows) 18,022,545 5,020.13 23,405.90
sql area evicted 247 0.07 0.32
sql area purged 0 0.00 0.00
summed dirty queue length 0 0.00 0.00
switch current to new buffer 44 0.01 0.06
table fetch by rowid 1,041,875 290.21 1,353.08
table fetch continued row 379 0.11 0.49
table scan blocks gotten 11,262,391 3,137.11 14,626.48
table scan rows gotten 600,987,898 167,403.63 780,503.76
table scans (long tables) 0 0.00 0.00
table scans (short tables) 10,018 2.79 13.01
total number of times SMON posted 19 0.01 0.02
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 2 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 922,624 256.99 1,198.21
user I/O wait time 254 0.07 0.33
user calls 23,767 6.62 30.87
user commits 703 0.20 0.91
user rollbacks 67 0.02 0.09
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 11,109 3.09 14.43
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 11,266,883,072 11,824,984,672
session cursor cache count 94,400 98,115
session uga memory 6.9E+12 7.1E+12
opened cursors current 60 62
logons current 72 77
session uga memory max 18,372,384,480 19,369,400,640
session pga memory 8,835,742,560 9,186,112,096

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 4 4.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 474 0 2.47 1.30 445 0 1 0.00
SYSAUX 40 0 5.00 1.38 495 0 0 0.00
UNDOTBS2 26 0 0.00 1.00 146 0 0 0.00
SYSTEM 2 0 0.00 1.00 79 0 0 0.00
HIS_GPS_02_1 52 0 0.00 1.00 10 0 0 0.00
HIS_GPS_01_1 50 0 0.00 1.00 10 0 0 0.00
HIS_GPS_01_2 50 0 0.00 1.00 10 0 0 0.00
TS_IDX_YTMOT 40 0 0.00 1.00 20 0 0 0.00
HIS_GPS_02_2 44 0 0.00 1.00 10 0 0 0.00
HIS_GPS_12_3 33 0 0.00 1.00 8 0 0 0.00
HIS_GPS_10_3 32 0 0.00 1.00 7 0 0 0.00
HIS_GPS_01_3 30 0 0.00 1.00 6 0 0 0.00
HIS_GPS_02_3 30 0 0.00 1.00 6 0 0 0.00
HIS_GPS_12_1 28 0 0.00 1.00 6 0 0 0.00
HIS_GPS_12_2 28 0 0.00 1.00 6 0 0 0.00
HIS_GPS_09_2 24 0 0.00 1.00 5 0 0 0.00
HIS_GPS_10_2 24 0 0.00 1.00 5 0 0 0.00
HIS_GPS_11_2 24 0 0.00 1.00 5 0 0 0.00
HIS_GPS_11_3 24 0 0.00 1.00 5 0 0 0.00
HIS_GPS_08_3 19 0 0.00 1.00 4 0 0 0.00
HIS_GPS_03_1 16 0 0.00 1.00 6 0 0 0.00
HIS_GPS_03_2 16 0 0.00 1.00 6 0 0 0.00
HIS_GPS_03_3 16 0 0.00 1.00 6 0 0 0.00
HIS_GPS_08_1 16 0 0.00 1.00 3 0 0 0.00
UNDOTBS1 14 0 0.00 1.00 4 0 0 0.00
HIS_GPS_09_1 14 0 0.00 1.00 3 0 0 0.00
HIS_GPS_09_3 14 0 0.00 1.00 3 0 0 0.00
HIS_GPS_10_1 14 0 0.00 1.00 3 0 0 0.00
HIS_GPS_11_1 14 0 0.00 1.00 3 0 0 0.00
HIS_GPS_07_3 11 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_2 11 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_1 9 0 0.00 1.00 3 0 0 0.00
HIS_GPS_06_2 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_3 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_1 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_2 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_04_1 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_04_2 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_04_3 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_05_1 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_05_2 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_05_3 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_20130501 2 0 0.00 1.00 2 0 0 0.00
HIS_GPS_20130502 2 0 0.00 1.00 2 0 0 0.00
HIS_GPS_20130503 2 0 0.00 1.00 2 0 0 0.00
SPLEX_TSP 2 0 0.00 1.00 2 0 0 0.00
USERS 2 0 0.00 1.00 2 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 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_1.dbf 10 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 2 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_21.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_31.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_02.dbf 10 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 2 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_2.dbf 10 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 2 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_32.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_3 +DATADG/gpsdb/dbf_01_03.dbf 10 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 2 0 0 0.00
HIS_GPS_01_3 +DATADG/gpsdb/dbf_01_3.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_01.dbf 12 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_1.dbf 10 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 2 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_21.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_31.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_02.dbf 12 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_12.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_2.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_22.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_32.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_3 +DATADG/gpsdb/dbf_02_03.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_3 +DATADG/gpsdb/dbf_02_13.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_3 +DATADG/gpsdb/dbf_02_3.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_1 +DATADG/gpsdb/dbf_03_1 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_1 +DATADG/gpsdb/dbf__03_01.dbf 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_1 +DATADG/gpsdb/dbf__03_11.dbf 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_2 +DATADG/gpsdb/dbf_03_02.dbf 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_2 +DATADG/gpsdb/dbf_03_12.dbf 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_2 +DATADG/gpsdb/dbf_03_2 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_3 +DATADG/gpsdb/dbf_03_03.dbf 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_3 +DATADG/gpsdb/dbf_03_13.dbf 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_3 +DATADG/gpsdb/dbf_03_3 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_04_1 +DATADG/gpsdb/dbf_04_1 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_04_2 +DATADG/gpsdb/dbf_04_2 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_04_3 +DATADG/gpsdb/dbf_04_3 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_05_1 +DATADG/gpsdb/dbf_05_1 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_05_2 +DATADG/gpsdb/dbf_05_2 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_05_3 +DATADG/gpsdb/dbf_05_3 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_1 +DATADG/gpsdb/dbf_06_1.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_1 +DATADG/gpsdb/dbf_06_1b.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_2 +DATADG/gpsdb/dbf_06_2.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_2 +DATADG/gpsdb/dbf_06_2b.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_3 +DATADG/gpsdb/dbf_06_3.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_3 +DATADG/gpsdb/dbf_06_3b.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_07_1 +DATADG/gpsdb/dbf_07_1.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_07_1 +DATADG/gpsdb/dbf_07_1b.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_07_2 +DATADG/gpsdb/dbf_07_2.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_07_2 +DATADG/gpsdb/dbf_07_2b.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_07_3 +DATADG/gpsdb/dbf_07_3.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_07_3 +DATADG/gpsdb/dbf_07_3b.dbf 6 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_1 +DATADG/gpsdb/dbf_08_1.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_1 +DATADG/gpsdb/dbf_08_1b.dbf 6 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_1 +FLASHAREA_DG/gpsdb/dbf_08_2.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_2 +DATADG/gpsdb/dbf_08_2.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_2 +DATADG/gpsdb/dbf_08_2b.dbf 6 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_3 +DATADG/gpsdb/dbf_08_3.dbf 5 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_3 +DATADG/gpsdb/dbf_08_3b.dbf 6 0 0.00 1.00 1 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 1 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 1 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 10 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 1 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 1 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 1 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 10 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 1 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 10 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 1 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 1 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 10 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 1 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 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_1 +DATADG/gpsdb/dbf_12_01.dbf 10 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 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_2 +DATADG/gpsdb/dbf_12_02.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_2 +DATADG/gpsdb/dbf_12_12.dbf 10 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 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_3 +DATADG/gpsdb/dbf_12_23.dbf 5 0 0.00 1.00 2 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 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_20130501 +DATADG/gpsdb/dbf_130501.dbf 2 0 0.00 1.00 2 0 0 0.00
HIS_GPS_20130502 +DATADG/gpsdb/dbf_130502.dbf 2 0 0.00 1.00 2 0 0 0.00
HIS_GPS_20130503 +DATADG/gpsdb/dbf_130503.dbf 2 0 0.00 1.00 2 0 0 0.00
SPLEX_TSP +DATADG/gpsdb/splex_tbs_01.dbf 2 0 0.00 1.00 2 0 0 0.00
SYSAUX +DATADG/gpsdb/sysaux01.dbf 40 0 5.00 1.38 495 0 0 0.00
SYSTEM +DATADG/gpsdb/system01.dbf 2 0 0.00 1.00 79 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_01.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_02.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_03.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_04.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_05.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_06.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_07.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_08.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_09.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_10.dbf 4 0 0.00 1.00 2 0 0 0.00
UNDOTBS1 +DATADG/gpsdb/undotbs01.dbf 2 0 0.00 1.00 2 0 0 0.00
UNDOTBS1 +DATADG/gpsdb/undotbs03.dbf 6 0 0.00 1.00 1 0 0 0.00
UNDOTBS1 +DATADG/gpsdb/undotbs05.dbf 6 0 0.00 1.00 1 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs02.dbf 2 0 0.00 1.00 95 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs04.dbf 6 0 0.00 1.00 8 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs06.dbf 6 0 0.00 1.00 41 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs07.dbf 6 0 0.00 1.00 1 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs08.dbf 6 0 0.00 1.00 1 0 0 0.00
USERS +DATADG/gpsdb/users01.dbf 2 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_01.dbf 19 0 1.58 1.11 13 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_02.dbf 3 0 0.00 1.00 6 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_03.dbf 8 0 2.50 1.63 7 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_04.dbf 10 0 0.00 1.00 5 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_05.dbf 3 0 3.33 1.00 6 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_06.dbf 15 0 5.33 1.33 26 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_07.dbf 26 0 1.92 1.42 20 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_08.dbf 7 0 8.57 2.00 12 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_09.dbf 23 0 3.48 1.48 35 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_10.dbf 5 0 4.00 2.40 9 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_11.dbf 23 0 3.04 1.09 22 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_12.dbf 30 0 3.33 1.23 40 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_13.dbf 13 0 3.08 1.38 18 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_14.dbf 22 0 3.18 2.00 25 0 1 0.00
WZT +DATADG/gpsdb/wzt_tbs_15.dbf 19 0 4.74 1.11 18 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_16.dbf 7 0 8.57 1.86 15 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_17.dbf 12 0 5.00 1.08 8 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_18.dbf 19 0 2.63 1.47 10 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_19.dbf 20 0 3.50 1.40 11 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_20.dbf 19 0 5.26 1.68 16 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_21.dbf 15 0 5.33 1.73 24 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_22.dbf 6 0 1.67 1.00 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_23.dbf 6 0 1.67 2.00 9 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_24.dbf 8 0 0.00 1.00 7 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_25.dbf 5 0 0.00 1.00 5 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_26.dbf 6 0 0.00 1.00 6 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_27.dbf 8 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_28.dbf 8 0 0.00 1.00 20 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_29.dbf 8 0 0.00 1.00 2 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 12 0 0.00 1.00 20 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_34.dbf 14 0 0.71 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_35.dbf 12 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_36.dbf 12 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_37.dbf 10 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_38.dbf 5 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_39.dbf 5 0 0.00 1.00 2 0 0 0.00
WZT +FLASHAREA_DG/gpsdb/wzt_tbs_26.dbf 7 0 0.00 1.57 7 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 1,568,106 100 12,518,502 444 1,281 0 0 1


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 277 1233 2156 2831130 2156  
E 0 0 292 1341 3099 2831130 3099  

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.13 1,080,590
D 2,592 0.20 310,554 1.08 1,034,766
D 3,888 0.30 465,831 1.07 1,024,022
D 5,184 0.40 621,108 1.06 1,015,976
D 6,480 0.50 776,385 1.05 1,009,307
D 7,776 0.59 931,662 1.00 961,880
D 9,072 0.69 1,086,939 1.00 960,465
D 10,368 0.79 1,242,216 1.00 960,465
D 11,664 0.89 1,397,493 1.00 960,465
D 12,960 0.99 1,552,770 1.00 960,465
D 13,088 1.00 1,568,106 1.00 960,465
D 14,256 1.09 1,708,047 1.00 960,465
D 15,552 1.19 1,863,324 1.00 960,465
D 16,848 1.29 2,018,601 1.00 960,465
D 18,144 1.39 2,173,878 1.00 960,465
D 19,440 1.49 2,329,155 1.00 960,465
D 20,736 1.58 2,484,432 1.00 960,465
D 22,032 1.68 2,639,709 1.00 960,465
D 23,328 1.78 2,794,986 1.00 960,465
D 24,624 1.88 2,950,263 1.00 960,465
D 25,920 1.98 3,105,540 1.00 960,465

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 6,046 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 8,192 7,101 389.11 0.00 0.00 0.00 0.00 838,860
E 8,192 7,095 397.79 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 8,892 8,892 0 0
64K 128K 27 27 0 0
128K 256K 12 12 0 0
256K 512K 2 2 0 0
512K 1024K 1,539 1,539 0 0
1M 2M 550 550 0 0
2M 4M 7 7 0 0
4M 8M 4 4 0 0
16M 32M 26 26 0 0
64M 128M 50 50 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 119,268.94 327.42 100.00 0
2,048 0.25 119,268.94 327.42 100.00 0
4,096 0.50 119,268.94 327.42 100.00 0
6,144 0.75 119,268.94 327.42 100.00 0
8,192 1.00 119,268.94 327.42 100.00 0
9,830 1.20 119,268.94 0.00 100.00 0
11,469 1.40 119,268.94 0.00 100.00 0
13,107 1.60 119,268.94 0.00 100.00 0
14,746 1.80 119,268.94 0.00 100.00 0
16,384 2.00 119,268.94 0.00 100.00 0
24,576 3.00 119,268.94 0.00 100.00 0
32,768 4.00 119,268.94 0.00 100.00 0
49,152 6.00 119,268.94 0.00 100.00 0
65,536 8.00 119,268.94 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,392 0.19 825 37,270 26,820 0.99 3,454 1.07 5,067
2,128 0.29 1,554 51,551 26,977 1.00 3,297 1.03 5,081
2,864 0.39 2,289 70,480 27,013 1.00 3,261 1.01 5,084
3,600 0.49 3,024 88,748 27,032 1.00 3,242 1.01 5,087
4,336 0.60 3,759 103,227 27,045 1.00 3,229 1.00 5,089
5,072 0.70 4,494 122,017 27,051 1.00 3,223 1.00 5,090
5,808 0.80 5,229 135,101 27,054 1.00 3,220 1.00 5,090
6,544 0.90 5,964 147,157 27,058 1.00 3,216 1.00 5,091
7,280 1.00 6,699 159,599 27,060 1.00 3,214 1.00 5,091
8,016 1.10 7,434 183,411 27,062 1.00 3,212 1.00 5,092
8,752 1.20 8,169 201,061 27,064 1.00 3,210 1.00 5,092
9,488 1.30 8,904 221,031 27,066 1.00 3,208 1.00 5,093
10,224 1.40 9,639 233,876 27,068 1.00 3,206 1.00 5,093
10,960 1.51 10,374 245,069 27,070 1.00 3,204 1.00 5,094
11,696 1.61 11,109 257,382 27,072 1.00 3,202 1.00 5,094
12,432 1.71 11,844 277,271 27,073 1.00 3,201 1.00 5,094
13,168 1.81 12,579 290,174 27,076 1.00 3,198 1.00 5,095
13,904 1.91 13,314 318,460 27,077 1.00 3,197 0.99 5,095
14,640 2.01 14,640 387,524 27,095 1.00 3,179 0.99 5,097

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 264,835 1,034,795
10,240 0.50 264,703 961,897
15,360 0.75 264,623 960,456
20,480 1.00 264,597 960,456
25,600 1.25 264,571 960,456
30,720 1.50 264,571 960,456
35,840 1.75 264,571 960,456
40,960 2.00 264,571 960,456

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 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 9,030 9,029 1 350 0 0.20
PS-PX Process Reservation 534 534 0 168 0 0.24
TT-Tablespace 306 306 0 137 0 0.29
TM-DML 1,928 1,928 0 130 0 0.31
JQ-Job Queue 60 60 0 10 0 1.00
TA-Instance Undo 11 11 0 11 0 0.00
WF-AWR Flush 20 20 0 9 0 0.00
HW-Segment High Water Mark 1,308 1,308 0 4 0 0.00
MW-MWIN Schedule 2 2 0 2 0 0.00
WL-Being Written Redo Log 4 4 0 2 0 0.00
AF-Advisor Framework (task serialization) 7 7 0 1 0 0.00
FB-Format Block 1 1 0 1 0 0.00
JS-Job Scheduler (job run lock - synchronize) 2 2 0 1 0 0.00
TX-Transaction (row lock contention) 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.21 1,105 18 3 15/15 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
13-Mar 16:10 74 184 0 3 15 0/0 0/0/0/0/0/0
13-Mar 16:00 33 169 0 3 15 0/0 0/0/0/0/0/0
13-Mar 15:50 12 137 18 2 15 0/0 0/0/0/0/0/0
13-Mar 15:40 11 162 0 1 15 0/0 0/0/0/0/0/0
13-Mar 15:30 10 111 0 2 15 0/0 0/0/0/0/0/0
13-Mar 15:20 10 190 0 3 15 0/0 0/0/0/0/0/0
13-Mar 15:10 58 152 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 122 0.00   0 0  
ASM db client latch 6,751 0.00   0 0  
ASM map headers 1,708 0.00   0 0  
ASM map load waiting list 428 0.00   0 0  
ASM map operation freelist 81 0.00   0 0  
ASM map operation hash table 1,746,317 0.00   0 0  
ASM network background latch 3,333 0.00   0 0  
AWR Alerted Metric Element list 21,033 0.00   0 0  
Consistent RBA 1,477 0.00   0 0  
FAL request queue 79 0.00   0 0  
FAL subheap alocation 79 0.00   0 0  
FIB s.o chain latch 24 0.00   0 0  
FOB s.o list latch 2,506 0.00   0 0  
JS broadcast add buf latch 1,358 0.00   0 0  
JS broadcast drop buf latch 1,359 0.00   0 0  
JS broadcast load blnc latch 1,256 0.00   0 0  
JS mem alloc latch 4 0.00   0 0  
JS queue access latch 4 0.00   0 0  
JS queue state obj latch 45,248 0.00   0 0  
JS slv state obj latch 48 0.00   0 0  
KCL gc element parent latch 20,193 0.00   0 95 0.00
KFK SGA context latch 6,979 0.00   0 0  
KFMD SGA 120 0.00   0 0  
KJC message pool free list 8,467 0.21 0.00 0 645 0.00
KJCT flow control latch 3,106,059 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 1,196 0.00   0 0  
KSXR large replies 2 0.00   0 0  
KTF sga latch 12 0.00   0 1,136 0.00
KWQMN job cache list latch 255 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 0     0 1,196 0.00
OS process 10,044 0.00   0 0  
OS process allocation 7,897 0.04 0.00 0 0  
OS process: request allocation 6,621 0.00   0 0  
PL/SQL warning settings 3,536 0.00   0 0  
Reserved Space Latch 12 0.00   0 0  
SQL memory manager latch 1 0.00   0 1,196 0.00
SQL memory manager workarea list latch 92,513 0.00   0 0  
Shared B-Tree 130 0.00   0 0  
active checkpoint queue latch 10,867 0.03 0.00 0 0  
active service list 22,998 0.06 0.08 0 2,593 0.00
alert log latch 8 0.00   0 0  
archive control 132 0.00   0 0  
archive process latch 1,362 0.00   0 0  
begin backup scn array 8 0.00   0 0  
business card 156 0.00   0 0  
cache buffer handles 10,420 0.00   0 0  
cache buffers chains 24,720,737 0.00 0.02 0 25,693 0.00
cache buffers lru chain 7,104 0.01 0.00 0 27,842 0.01
cache table scan latch 0     0 6 0.00
channel handle pool latch 6,647 0.02 0.00 0 0  
channel operations parent latch 371,162 0.00 0.00 0 0  
checkpoint queue latch 788,255 0.00   0 1,509 0.00
client/application info 6,337 0.00   0 0  
compile environment latch 3,459 0.00   0 0  
dml lock allocation 3,901 0.00   0 0  
dummy allocation 6,913 0.03 0.00 0 0  
enqueue hash chains 141,318 0.00 0.00 0 5 0.00
enqueues 128,185 0.00 0.00 0 0  
error message lists 378 0.00   0 0  
event group latch 3,313 0.00   0 0  
file cache latch 2,746 0.00   0 0  
gcs opaque info freelist 2,460 0.00   0 0  
gcs partitioned table hash 284,779 0.00   0 99 0.00
gcs remastering latch 67 0.00   0 0  
gcs resource freelist 38,245 0.00   0 50,195 0.00
gcs resource hash 107,141 0.03 0.00 0 0  
gcs shadows freelist 38,663 0.00   0 50,668 0.00
ges caches resource lists 16,670 0.04 0.00 0 47,135 0.01
ges deadlock list 138 0.00   0 0  
ges domain table 28,730 0.00   0 0  
ges enqueue table freelist 45,862 0.00   0 0  
ges group table 42,538 0.00   0 0  
ges process hash list 17,371 0.00   0 0  
ges process parent latch 98,174 0.00   0 0  
ges process table freelist 6,621 0.02 0.00 0 0  
ges resource hash list 93,774 0.03 0.25 0 4,549 0.00
ges resource scan list 16 0.00   0 0  
ges resource table freelist 6,652 0.00   0 0  
ges timeout list 1,776 0.00   0 1,205 0.00
global KZLD latch for mem in SGA 265 0.00   0 0  
hash table column usage latch 40 0.00   0 299,934 0.00
hash table modification latch 72 0.00   0 0  
interrupt manipulation 648 0.00   0 0  
job workq parent latch 0     0 124 0.00
job_queue_processes parameter latch 121 0.00   0 0  
kks stats 3,821 0.00   0 0  
kokc descriptor allocation latch 100 0.00   0 0  
ksuosstats global area 241 0.00   0 0  
ktm global data 19 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 1,961 0.00   0 0  
library cache 176,707 0.03 0.00 0 4,973 0.00
library cache lock 118,145 0.08 0.00 0 0  
library cache lock allocation 2,687 0.00   0 0  
library cache pin 52,172 0.00 0.00 0 0  
library cache pin allocation 440 0.00   0 0  
list of block allocation 167 0.00   0 0  
loader state object freelist 216 0.00   0 0  
logminer context allocation 1 0.00   0 0  
message pool operations parent latch 1,094 0.00   0 0  
messages 197,297 0.01 0.00 0 0  
mostly latch-free SCN 1,963 0.05 0.00 0 0  
msg queue 219 0.00   0 219 0.00
multiblock read objects 4,218 0.00   0 0  
name-service memory objects 24,138 0.00   0 0  
name-service namespace bucket 49,743 0.00   0 0  
name-service pending queue 4,076 0.00   0 0  
name-service request queue 45,824 0.00   0 0  
ncodef allocation latch 91 0.00   0 0  
object queue header heap 43,617 0.00   0 172 0.00
object queue header operation 56,610 0.06 0.03 0 0  
object stats modification 1 0.00   0 0  
parallel query alloc buffer 2,040 0.00   0 0  
parallel query stats 318 0.00   0 0  
parallel txn reco latch 5,170 0.00   0 0  
parameter list 12,959 0.00   0 0  
parameter table management 6,921 0.00   0 0  
post/wait queue 231 0.00   0 158 0.00
process allocation 43,689 0.13 0.89 1 3,308 0.15
process group creation 6,621 0.05 0.00 0 0  
process queue 846 0.00   0 0  
process queue reference 14,193 0.01 0.00 0 1,408 0.00
qmn task queue latch 508 0.00   0 0  
query server freelists 702 0.00   0 0  
queued dump request 17,946 0.00   0 0  
redo allocation 9,377 0.03 0.00 0 8,091 0.00
redo copy 0     0 8,091 0.04
redo writing 17,802 0.01 0.00 0 0  
reservation so alloc latch 8 0.00   0 0  
resmgr group change latch 739 0.00   0 0  
resmgr:active threads 6,898 0.00   0 0  
resmgr:actses change group 411 0.00   0 0  
resmgr:free threads list 6,897 0.07 0.00 0 0  
resmgr:resource group CPU method 406 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 1,105,466 0.03 0.00 0 0  
rules engine rule set statistics 100 0.00   0 0  
segmented array pool 24 0.00   0 0  
sequence cache 10,142 0.08 0.00 0 0  
session allocation 15,646 0.41 0.13 0 0  
session idle bit 48,281 0.00   0 0  
session state list latch 875 0.11 0.00 0 0  
session switching 16,631 0.01 0.00 0 0  
session timer 1,915 0.00   0 0  
shared pool 187,841 0.05 0.00 0 0  
shared pool sim alloc 18 0.00   0 0  
shared pool simulator 5,959 0.00   0 0  
simulator hash latch 800,235 0.00   0 0  
simulator lru latch 0     0 800,217 0.00
slave class 665 0.00   0 0  
slave class create 2,654 0.04 1.00 0 0  
sort extent pool 146 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 177 0.00   0 0  
transaction branch allocation 1,915 0.00   0 0  
undo global data 39,958 0.00   0 0  
user lock 10,274 0.20 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 24,720,737 619 15 604 0 0 0
row cache objects 1,105,466 358 1 357 0 0 0
session allocation 15,646 64 8 56 0 0 0
process allocation 43,689 56 50 9 0 0 0
object queue header operation 56,610 32 1 31 0 0 0
ges resource hash list 93,774 28 7 21 0 0 0
active service list 22,998 13 1 12 0 0 0
slave class create 2,654 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
active service list kswslogon: session logout 0 6 6
cache buffers chains kcbgtcr: kslbegin excl 0 148 111
cache buffers chains kcbrls: kslbegin 0 1 38
ges resource hash list kjakcai: search for resp by resname 0 4 0
ges resource hash list kjrmas1: lookup master node 0 2 0
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 1 0
object queue header operation kcbo_switch_mq_bg 0 8 0
process allocation ksucrp 0 42 0
process allocation ksudlp 0 4 6
process allocation ksuapc 0 3 32
process allocation ksufap: active procs 0 1 12
row cache objects kqrigt 0 1 0
session allocation ksuxds: KSUSFCLC not set 0 8 6
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 5,251,696 41.95
YTGPS WZT YTO_MID_ROAD_NUM   TABLE 3,436,720 27.45
YTGPS WZT YTO_JINGANG_STATION   TABLE 1,234,800 9.86
YTGPS WZT YTO_MID_POI   TABLE 793,488 6.34
YTGPS WZT YTO_AUDIT_RECORD   TABLE 436,592 3.49

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
YTGPS WZT YTO_JINGANG_USER   TABLE 123 8.38
YTGPS WZT PK_YTO_AUDIT_DETAIL   INDEX 116 7.90
YTGPS WZT YTO_MID_ROAD_NUM_INDEX1   INDEX 71 4.84
YTGPS WZT PK_YTO_AUDIT_RECORD   INDEX 62 4.22
YTGPS WZT YTO_MID_ROAD_UK   INDEX 12 0.82

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 100.00

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_JINGANG_USER   TABLE 1 100.00

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
YTGPS WZT YTO_JINGANG_USER   TABLE 962 38.74
YTGPS WZT YTO_AUDIT_STATISTICS   TABLE 168 6.77
YTGPS WZT YTO_AUDIT_RECORD   TABLE 165 6.65
YTGPS WZT PK_YTO_AUDIT_VALUE   INDEX 164 6.60
YTGPS WZT YTO_AUDIT_DETAIL   TABLE 121 4.87

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
YTGPS WZT YTO_JINGANG_USER   TABLE 569 49.74
YTGPS WZT YTO_AUDIT_STATISTICS   TABLE 56 4.90
YTGPS WZT PK_YTO_AUDIT_VALUE   INDEX 44 3.85
YTGPS WZT YTO_AUDIT_RECORD   TABLE 39 3.41
YTGPS WZT YTO_AUDIT_DETAIL   TABLE 31 2.71

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 3,560 0.00 0   0 1
dc_global_oids 271 0.00 0   0 118
dc_histogram_data 215,406 0.00 0   0 3,042
dc_histogram_defs 41,985 0.02 0   0 3,030
dc_object_ids 98,984 0.00 0   0 1,493
dc_objects 13,549 0.01 0   5 875
dc_profiles 329 0.00 0   0 1
dc_rollback_segments 9,760 0.00 0   0 472
dc_segments 41,683 0.00 0   1 1,416
dc_sequences 4 50.00 0   4 3
dc_tablespaces 34,112 0.00 0   0 50
dc_usernames 4,297 0.00 0   0 44
dc_users 47,569 0.00 0   0 76
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 10 0 0
dc_objects 11 0 0
dc_segments 2 1 0
dc_sequences 8 2 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,065 0.00 2,637 0.00 0 0
CLUSTER 2 0.00 2 0.00 0 0
SQL AREA 7,577 37.72 21,802 19.81 13 0
TABLE/PROCEDURE 276 0.00 32,716 0.00 0 0
TRIGGER 34 0.00 198 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 2 0 0 0 0
TABLE/PROCEDURE 8,439 14 1 10 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 346.80   4.62 4.61 16 16 75 75
  Freeable 41.44 0.00 1.53 1.61 6   27 27
  SQL 0.59 0.14 0.02 0.03 0 88 34 30
  PL/SQL 0.33 0.14 0.00 0.01 0 0 73 73
E Other 353.12   4.41 4.54 16 16 80 80
  Freeable 43.81 0.00 1.46 1.54 6   30 30
  SQL 0.52 0.11 0.01 0.02 0 88 39 30
  PL/SQL 0.40 0.20 0.01 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,723,762,688  
Fixed Size 2,134,704  
Redo Buffers 48,193,536  
Variable Size 7,700,745,552  

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 172.35 176.67 2.50
shared PCursor 235.86 240.83 2.11
shared db_block_hash_buckets 90.00 90.00 0.00
shared free memory 3,016.99 2,929.01 -2.92
shared gcs resources 310.31 310.31 0.00
shared gcs shadows 166.03 166.03 0.00
shared library cache 221.37 221.68 0.14
shared sql area 2,682.74 2,760.93 2.91
streams free memory 32.00 32.00 0.00
  buffer_cache 13,088.00 13,088.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 87,987 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

No data exists for this section of the report.


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,524,163 424.55 1,979.43
acks for commit broadcast(logical) 1,525,519 424.93 1,981.19
broadcast msgs on commit(actual) 1,439 0.40 1.87
broadcast msgs on commit(logical) 1,472 0.41 1.91
broadcast msgs on commit(wasted) 27 0.01 0.04
broadcast on commit wait time(ms) 1 0.00 0.00
broadcast on commit waits 10 0.00 0.01
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 478 0.13 0.62
gcs ast xid 0 0.00 0.00
gcs blocked converts 759 0.21 0.99
gcs blocked cr converts 2,044 0.57 2.65
gcs compatible basts 2 0.00 0.00
gcs compatible cr basts (global) 169 0.05 0.22
gcs compatible cr basts (local) 480 0.13 0.62
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 121 0.03 0.16
gcs dbwr write request msgs 138 0.04 0.18
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 909 0.25 1.18
gcs immediate (null) converts 43,707 12.17 56.76
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 6,689 1.86 8.69
gcs indirect ast 51,236 14.27 66.54
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 70 0.02 0.09
gcs msgs process time(ms) 8,171 2.28 10.61
gcs msgs received 1,621,255 451.60 2,105.53
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,352 0.38 1.76
gcs side channel msgs logical 3,816 1.06 4.96
gcs stale cr 0 0.00 0.00
gcs undo cr 1 0.00 0.00
gcs write notification msgs 4 0.00 0.01
gcs writes refused 1 0.00 0.00
ges msgs process time(ms) 273 0.08 0.35
ges msgs received 17,644 4.91 22.91
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,455 6.53 30.46
implicit batch messages sent 6,076 1.69 7.89
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 7,569 2.11 9.83
messages queue sent actual 30,484 8.49 39.59
messages queue sent logical 36,960 10.30 48.00
messages received actual 1,587,903 442.31 2,062.21
messages received logical 1,638,904 456.51 2,128.45
messages sent directly 3,508 0.98 4.56
messages sent indirectly 14,240 3.97 18.49
messages sent not implicit batched 24,408 6.80 31.70
messages sent pbatched 1,558,556 434.13 2,024.10
msgs causing lmd to send msgs 6,635 1.85 8.62
msgs causing lms(s) to send msgs 2,990 0.83 3.88
msgs received queue time (ms) 17,303 4.82 22.47
msgs received queued 1,638,910 456.51 2,128.45
msgs sent queue time (ms) 797 0.22 1.04
msgs sent queue time on ksxp (ms) 133,875 37.29 173.86
msgs sent queued 36,846 10.26 47.85
msgs sent queued on ksxp 1,552,412 432.42 2,016.12
number of ges deadlock detected 0 0.00 0.00
process batch messages received 8,852 2.47 11.50
process batch messages sent 1,534,223 427.35 1,992.50


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 1,213
CURRENT Block Requests 34
Data Block Requests 1,213
Undo Block Requests 1
TX Block Requests 11
Current Results 1,241
Private results 1
Zero Results 5
Disk Read Results 0
Fail Results 0
Fairness Down Converts 279
Fairness Clears 0
Free GC Elements 0
Flushes 11
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 766 100.00 0.00 0.00 0.00 0.00
Flushes 2 100.00 0.00 0.00 0.00 0.00
Writes 181 84.53 14.36 0.00 1.10 0.00


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 2,381 99.12 0.08 0.80 1,090 98.26 0.00 1.74
1 Others 93 100.00 0.00 0.00 38 100.00 0.00 0.00
1 undo header 7 100.00 0.00 0.00 3 100.00 0.00 0.00


Back to Top

End of Report