WORKLOAD REPOSITORY report for

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2102013-Mar-14 09:00:5269 .8
End Snap:2102113-Mar-14 10:00:4271 .8
Elapsed:  59.83 (mins)  
DB Time:  7.90 (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: 771.10 2,641.48
Logical reads: 3,672.72 12,581.21
Block changes: 3.25 11.13
Physical reads: 0.40 1.37
Physical writes: 0.39 1.32
User calls: 7.26 24.87
Parses: 3.17 10.87
Hard parses: 0.47 1.60
Sorts: 2.49 8.52
Logons: 0.81 2.79
Executes: 4.52 15.49
Transactions: 0.29 

% Blocks changed per Read: 0.09Recursive Call %: 70.50
Rollback per transaction %: 35.21Rows per Sort: 2234.28

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 91.57Soft Parse %: 85.28
Execute to Parse %: 29.84Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 96.68% Non-Parse CPU: 96.91

Shared Pool Statistics

BeginEnd
Memory Usage %: 55.40 56.00
% SQL with executions>1: 97.56 94.77
% Memory for SQL w/exec>1: 97.55 94.70

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  547  115.4 
SQL*Net more data to client 70,444 8 0 1.6Network
control file sequential read 12,482 4 0 .8System I/O
gc cr multi block request 20,236 3 0 .7Cluster
control file parallel write 1,378 2 1 .3System I/O

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 6.94 23.76
Global Cache blocks served: 0.95 3.25
GCS/GES messages received: 495.47 1,697.28
GCS/GES messages sent: 461.18 1,579.81
DBWR Fusion writes: 0.04 0.13
Estd Interconnect traffic (KB) 249.91 

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

Buffer access - local cache %: 99.81
Buffer access - remote cache %: 0.19
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.7
Avg global cache current block receive time (ms): 0.4
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.8
Avg global cache cr block flush time (ms): 0.0
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.4
Avg global cache current block flush time (ms): 1.3

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.65
% of indirect sent messages: 53.10
% of flow controlled messages: 33.25


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 546.87 115.42
sql execute elapsed time 441.43 93.17
parse time elapsed 18.59 3.92
hard parse elapsed time 17.27 3.65
connection management call elapsed time 3.17 0.67
PL/SQL execution elapsed time 0.73 0.15
sequence load elapsed time 0.01 0.00
hard parse (sharing criteria) elapsed time 0.01 0.00
repeated bind elapsed time 0.00 0.00
failed parse elapsed time 0.00 0.00
DB time 473.80  
background cpu time 196.29  
background elapsed time 139.57  

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     547   115.42
Network 92,899   8 0 1.67
System I/O 16,346   7 0 1.39
Cluster 23,190   4 0 0.86
Other 52,165 82 2 0 0.50
User I/O 1,620   2 1 0.38
Concurrency 814   1 1 0.20
Commit 121   0 0 0.01
Application 131   0 0 0.01
Configuration 1   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
SQL*Net more data to client 70,444   8 0 67.22
control file sequential read 12,482   4 0 11.91
gc cr multi block request 20,236   3 0 19.31
control file parallel write 1,378   2 1 1.31
db file sequential read 540   1 2 0.52
os thread startup 21   1 29 0.02
reliable message 253   1 2 0.24
log file parallel write 1,431   1 0 1.37
latch free 46   0 11 0.04
gc cr block 2-way 1,938   0 0 1.85
db file parallel write 984   0 0 0.94
rdbms ipc reply 5,194   0 0 4.96
db file scattered read 49   0 8 0.05
row cache lock 624   0 1 0.60
direct path read 813   0 0 0.78
CGS wait for IPC msg 30,696 99 0 0 29.29
db file parallel read 15   0 11 0.01
gc current block 2-way 559   0 0 0.53
DFS lock handle 749   0 0 0.71
ksxr poll remote instances 10,075 87 0 0 9.61
log file sequential read 26   0 5 0.02
enq: CF - contention 596   0 0 0.57
SQL*Net more data from client 1,309   0 0 1.25
gc current grant busy 299   0 0 0.29
enq: PS - contention 168   0 0 0.16
log file sync 121   0 0 0.12
PX Deq: reap credit 3,774 93 0 0 3.60
enq: TM - contention 122   0 0 0.12
enq: TT - contention 144   0 0 0.14
library cache lock 133   0 0 0.13
CSS operation: query 12   0 3 0.01
gc current multi block request 81   0 0 0.08
PX Deq Credit: send blkd 185 77 0 0 0.18
direct path write 203   0 0 0.19
SQL*Net message to client 21,146   0 0 20.18
gc buffer busy 1   0 20 0.00
gcs log flush sync 30   0 0 0.03
PX Deq: Signal ACK 148 24 0 0 0.14
gc current grant 2-way 62   0 0 0.06
Log archive I/O 35   0 0 0.03
IPC send completion sync 33 100 0 0 0.03
CSS initialization 4   0 1 0.00
gc cr block busy 5   0 1 0.00
latch: shared pool 1   0 4 0.00
log file single write 10   0 0 0.01
enq: WF - contention 10   0 0 0.01
enq: JQ - contention 12   0 0 0.01
enq: TA - contention 11   0 0 0.01
library cache pin 11   0 0 0.01
gc cr grant 2-way 7   0 0 0.01
gc current block busy 2   0 1 0.00
CSS operation: action 8   0 0 0.01
SQL*Net break/reset to client 6   0 0 0.01
latch: cache buffers chains 24   0 0 0.02
enq: AF - task serialization 1   0 0 0.00
enq: TX - row lock contention 2   0 0 0.00
enq: MW - contention 2   0 0 0.00
latch: session allocation 6   0 0 0.01
enq: WL - contention 2   0 0 0.00
enq: HW - contention 1   0 0 0.00
latch: gcs resource hash 2   0 0 0.00
enq: UL - contention 1   0 0 0.00
enq: JS - job run lock - synchronize 1   0 0 0.00
KJC: Wait for msg sends to complete 1   0 0 0.00
latch: object queue header operation 1   0 0 0.00
LGWR wait for redo copy 1   0 0 0.00
gcs remote message 2,862,686 43 55,999 20 2,731.57
SQL*Net message from client 23,898   54,920 2298 22.80
class slave wait 1,472 83 8,290 5632 1.40
jobq slave wait 1,268 84 3,535 2788 1.21
DIAG idle wait 17,947   3,505 195 17.13
PX Idle Wait 1,455 93 3,505 2409 1.39
ges remote message 71,121 61 3,504 49 67.86
ASM background timer 1,770   3,503 1979 1.69
Streams AQ: qmn slave idle wait 127   3,501 27567 0.12
Streams AQ: qmn coordinator idle wait 255 50 3,501 13730 0.24
virtual circuit status 120 100 3,492 29104 0.11
Streams AQ: waiting for time management or cleanup tasks 1 100 1,340 1339631 0.00
KSV master wait 241   18 75 0.23
PX Deq: Execution Msg 358 7 0 1 0.34
PX Deq: Join ACK 227 34 0 1 0.22
PX Deq: Parse Reply 217 36 0 0 0.21
PX Deq: Execute Reply 193 34 0 0 0.18
PX Deq: Msg Fragment 133 1 0 0 0.13
Streams AQ: RAC qmn coordinator idle wait 255 100 0 0 0.24

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,775   4 0 11.24
control file parallel write 1,378   2 1 1.31
events in waitclass Other 42,291 92 1 0 40.35
os thread startup 21   1 29 0.02
log file parallel write 1,431   1 0 1.37
db file parallel write 984   0 0 0.94
direct path read 812   0 0 0.77
log file sequential read 26   0 5 0.02
enq: TM - contention 117   0 0 0.11
db file sequential read 4   0 6 0.00
direct path write 200   0 0 0.19
gc current block 2-way 52   0 0 0.05
gc cr block 2-way 52   0 0 0.05
library cache lock 25   0 0 0.02
Log archive I/O 35   0 0 0.03
log file single write 10   0 0 0.01
gc cr multi block request 22   0 0 0.02
gc current multi block request 10   0 0 0.01
gc current grant busy 6   0 0 0.01
row cache lock 4   0 0 0.00
gc current grant 2-way 1   -0 -0 0.00
rdbms ipc message 84,271 63 73,050 867 80.41
gcs remote message 2,862,702 43 55,999 20 2,731.59
DIAG idle wait 17,947   3,505 195 17.13
ges remote message 71,124 61 3,504 49 67.87
ASM background timer 1,770   3,503 1979 1.69
pmon timer 1,934 100 3,501 1810 1.85
Streams AQ: qmn slave idle wait 127   3,501 27567 0.12
Streams AQ: qmn coordinator idle wait 255 50 3,501 13730 0.24
class slave wait 1,321 82 3,176 2405 1.26
smon timer 19   2,947 155082 0.02
Streams AQ: waiting for time management or cleanup tasks 1 100 1,340 1339631 0.00
KSV master wait 241   18 75 0.23
Streams AQ: RAC qmn coordinator idle wait 255 100 0 0 0.24

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 110,947
IDLE_TIME 22,868,830
IOWAIT_TIME 845
NICE_TIME 40
SYS_TIME 34,918
USER_TIME 71,435
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 223,242,240
VM_OUT_BYTES 432,048,128
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 470.90 543.20 536 13,107,363
SYS$USERS 2.80 3.60 0 30,045
SYS$BACKGROUND 0.00 0.00 897 44,498
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 405 1 124 0 0 0 86788 8
SYS$USERS 0 0 31 0 0 0 144 0
SYS$BACKGROUND 1215 1 659 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
37 38 23 1.62 7.86 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
23 23 17 1.33 4.77 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
11 4 1 11.48 2.42 c30y4ycz6yt7v oracle@repsrv (TNS V1-V3) SELECT "ZIP_NO_SEQ", "ADDR", "...
10 10 57 0.18 2.15 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
10 10 62 0.16 2.07 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
7 5 270 0.02 1.40 g1u8jnzfm96nx JDBC Thin Client select m1.device_id, m1.latitu...
6 6 12 0.53 1.34 a49zwfctq8r84 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
6 6 11 0.52 1.21 5fj2t8gc6yagr JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
4 4 85 0.05 0.86 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
3 3 1 2.65 0.56 dxdwxhrp87q6z JDBC Thin Client SELECT * FROM (SELECT YTO_POI_...

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
38 37 23 1.66 6.97 7.86 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
23 23 17 1.36 4.23 4.77 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
10 10 57 0.18 1.90 2.15 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
10 10 62 0.16 1.83 2.07 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
6 6 12 0.54 1.19 1.34 a49zwfctq8r84 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
6 6 11 0.53 1.07 1.21 5fj2t8gc6yagr JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
5 7 270 0.02 0.83 1.40 g1u8jnzfm96nx JDBC Thin Client select m1.device_id, m1.latitu...
4 4 85 0.05 0.75 0.86 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
4 11 1 4.07 0.74 2.42 c30y4ycz6yt7v oracle@repsrv (TNS V1-V3) SELECT "ZIP_NO_SEQ", "ADDR", "...
3 3 1 2.71 0.50 0.56 dxdwxhrp87q6z JDBC Thin Client SELECT * FROM (SELECT YTO_POI_...

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
883,191 12 73,599.25 6.70 6.49 6.35 a49zwfctq8r84 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
808,950 11 73,540.91 6.14 5.86 5.73 5fj2t8gc6yagr JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
610,792 57 10,715.65 4.63 10.39 10.18 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
518,161 62 8,357.44 3.93 9.99 9.79 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
268,950 85 3,164.12 2.04 4.11 4.06 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
242,998 14 17,357.00 1.84 1.71 1.70 frr9vmmcsadhb JDBC Thin Client select * from ( select distinc...
240,227 14 17,159.07 1.82 2.23 2.22 68ddx7zxvxubr JDBC Thin Client select count(*) from (select d...
218,784 23 9,512.35 1.66 38.10 37.26 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
160,932 17 9,466.59 1.22 23.13 22.60 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
106,920 270 396.00 0.81 4.55 6.63 g1u8jnzfm96nx JDBC Thin Client select m1.device_id, m1.latitu...

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
270 270 1.00 18.80 4.55 6.63 g1u8jnzfm96nx JDBC Thin Client select m1.device_id, m1.latitu...
12 85 0.14 0.84 4.11 4.06 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
9 15 0.60 0.63 0.59 0.60 dbq0pds6kwqju JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
8 23 0.35 0.56 38.10 37.26 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
7 5 1.40 0.49 0.01 0.02 cnpy92sm9tavb JDBC Thin Client SELECT ROAD_ID FROM YTO_MID_RO...
6 1 6.00 0.42 0.56 0.60 84qubbrsr0kfn   insert into wrh$_latch (snap_i...
4 1 4.00 0.28 0.00 0.00 casn5xxbk9tah   SELECT nvl(v.first_val, 0), nv...
3 1 3.00 0.21 2.52 2.48 809zdnzb6nwwg JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
3 17 0.18 0.21 23.13 22.60 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
1 16 0.06 0.07 0.71 0.72 6wsph5c17t4kb JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...

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
641 1,564 2.44 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
553 0 0.00 0.00 0.00 c4nhd1ntptxq7 MMON_SLAVE select message_level, sequence...
318 0 0.00 0.00 0.00 az33m61ym46y4   SELECT NULL AS table_cat, o.ow...
310 310 1.00 0.00 0.00 18naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
289 642 2.22 0.00 0.00 0k8522rmdzg4k   select privilege# from sysauth...
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...
270 1,350 5.00 0.02 0.02 g1u8jnzfm96nx JDBC Thin Client select m1.device_id, m1.latitu...
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...
225 225 1.00 0.00 0.00 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
225 225 1.00 0.00 0.00 459f3z9u4fb3u   select value$ from props$ wher...
225 225 1.00 0.00 0.00 5ur69atw3vfhj   select decode(failover_method,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
642 641 5.64 0h6b2sajwb74n   select privilege#, level from ...
553 553 4.86 c4nhd1ntptxq7 MMON_SLAVE select message_level, sequence...
319 318 2.80 az33m61ym46y4   SELECT NULL AS table_cat, o.ow...
289 289 2.54 0k8522rmdzg4k   select privilege# from sysauth...
282 282 2.48 6xvp6nxs4a9n4   select nvl(sum(space), 0) from...
282 282 2.48 csnp95dz2r8ss   select file#, block# from recy...
270 270 2.37 g1u8jnzfm96nx JDBC Thin Client select m1.device_id, m1.latitu...
225 225 1.98 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
225 225 1.98 459f3z9u4fb3u   select value$ from props$ wher...
225 225 1.98 5ur69atw3vfhj   select decode(failover_method,...
149 149 1.31 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
149 149 1.31 g00cj285jmgsw   update sys.mon_mods$ set inser...
120 240 1.05 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 2 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
2.97 44.76 6.63 4.55 270 g1u8jnzfm96nx JDBC Thin Client select m1.device_id, m1.latitu...
0.35 3.06 11.48 4.07 1 c30y4ycz6yt7v oracle@repsrv (TNS V1-V3) SELECT "ZIP_NO_SEQ", "ADDR", "...
0.06 2.59 2.22 2.23 14 68ddx7zxvxubr JDBC Thin Client select count(*) from (select d...
0.04 0.97 4.06 4.11 85 cg2fjydbr0u8m JDBC Thin Client UPDATE YTO_AUDIT_STATISTICS T ...
0.04 0.34 10.18 10.39 57 9g8rftjc929u0 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
0.03 1.94 1.70 1.71 14 frr9vmmcsadhb JDBC Thin Client select * from ( select distinc...
0.03 0.33 9.79 9.99 62 an9ph1jq3g7fd JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
0.03 3.92 0.72 0.71 16 6wsph5c17t4kb JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
0.03 0.07 37.26 38.10 23 dknnjdqsdhb73 JDBC Thin Client SELECT * FROM (SELECT YTO_ROAD...
0.03 2.25 1.17 1.17 33 5qg0cz6q69b6r JDBC Thin Client SELECT * FROM (SELECT YTO_AUDI...
0.02 2.22 1.02 1.03 26 832bswus1k5s4 JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
0.01 0.20 6.35 6.49 12 a49zwfctq8r84 JDBC Thin Client SELECT * FROM (SELECT A.*, ROW...
0.01 0.05 22.60 23.13 17 bk5k8x08y0wfw JDBC Thin Client SELECT COUNT(1) FROM ( SELECT ...
0.01 0.20 5.73 5.86 11 5fj2t8gc6yagr JDBC Thin Client SELECT COUNT(1) FROM YTO_MID_R...
0.01 16.75 0.04 0.03 149 g00cj285jmgsw   update sys.mon_mods$ set inser...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
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))
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
5fj2t8gc6yagrSELECT 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') LEFT JOIN (SELECT T8.COMMENTS , T8.AUDIT_ID FROM YTO_AUDIT_DETAIL T8 , (SELECT T9.AUDIT_ID , MAX(T9.AUDIT_TIME)AUDIT_TIME FROM YTO_AUDIT_DETAIL T9 WHERE T9.STATE = 0 GROUP BY T9.AUDIT_ID) T10 WHERE T8.STATE = 0 AND T8.AUDIT_ID = T10.AUDIT_ID AND T8.AUDIT_TIME = T10.AUDIT_TIME )T11 ON T5.AUDIT_ID = T11.AUDIT_ID 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 T5.STATE = :2
5kyb5bvnu3s04SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
5qg0cz6q69b6rSELECT * FROM (SELECT YTO_AUDIT_STATISTICS.*, ROWNUM RN FROM( SELECT P.STATION_CODE GID , P.STATION_NAME G_NAME , P.ROAD_NUM V_NUM_ROAD , P.POI_NUM V_NUM_POI , P.DIS_NUM V_NUM_DISTRICT FROM YTO_AUDIT_STATISTICS P WHERE P.AUDIT_STATE = :1 AND NVL(ROAD_NUM, 0)+NVL(POI_NUM, 0)+NVL(DIS_NUM, 0)>0 AND P.STATION_CODE IN( SELECT G.CODE FROM YTO_JINGANG_STATION G WHERE G.STATUS = 'VALID' START WITH G.CODE = (SELECT USER_ORG_CODE FROM YTO_JINGANG_USER WHERE USER_CODE = :2) CONNECT BY PRIOR G.ID = G.PARENT_ID ) ) YTO_AUDIT_STATISTICS WHERE ROWNUM <=:3) WHERE RN >= :4
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
68ddx7zxvxubrselect count(*) from (select distinct a.id, a.task_id, a.later_status, a.lazy_time, a.vehicle_no, a.line_name, to_char(a.gps_time, 'yyyy-MM-dd HH24:mi:ss'), a.is_disposal, b.name, c.device_id from t_later_info a, yto_org_node b, yto_in_out_area_s c, (select g.gid from t_privilage_group g start with g.gid = (select gid from ref_user_group where user_id = (select id from t_user where user_account = '00002578'))connect by prior g.gid = g.parent_id) d where a.task_id = c.task_id and b.org_id = ( case a.later_status when 1 then c.start_org_code else c.end_org_code end)and a.is_disposal = 0 and sysdate - a.gps_time < 5 and (c.start_org_code = d.gid or c.end_org_code = d.gid ))
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
809zdnzb6nwwg SELECT COUNT(1) FROM ( SELECT T.AUDIT_ID , M.POI_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(T.AUDIT_TYPE, '1', 'ÐÂÔö', '2', 'ÐÞ¸Ä', '3', 'ɾ³ý') AUDIT_TYPE , TO_CHAR(CAST(T.CREATE_TIME AS DATE), 'YYYY-MM-DD HH24:MI:SS')CREATE_TIME , NVL(N.DATA_VALUE, '1-9999') DATA_VALUE , NVL(SUBSTR(N.DATA_VALUE, INSTR(N.DATA_VALUE, '-')+1), 9999)DATA_VALUE_MAX , NVL(SUBSTR(N.DATA_VALUE, 0, INSTR(N.DATA_VALUE, '-')-1), 1)DATA_VALUE_MIN , G.CODE CGCODE , G.NAME CGNAME , M.CREATER CREATER_CODE , U.USER_NAME CREATER_NAME , CASE WHEN T.COMMENTS IS NULL THEN DECODE(T.STATE, '10', '²Ý¸å', '20', '·Ö¹«Ë¾ÉóºËÖÐ', '30', '·Ö¹«Ë¾ÉóºËͨ¹ý', '40', 'Ê¡¹«Ë¾ÉóºËͨ¹ý', '50', '¹ÜÀíÇøÉóºËͨ¹ý', '60', '×ܹ«Ë¾ÉóºË ͨ¹ý', '70', 'ÉÏ´ÎÉóºËδͨ¹ý') ELSE T.COMMENTS END COMMENTS , '' NEW_RELEASE , T.AUDIT_ORG_ID , T.AUDIT_ORG_NAME , T.AUDITOR_ID , T.AUDITOR_NAME , T.AUDIT_TIME FROM YTO_MID_POI M LEFT JOIN YTO_MID_POI_DTL N ON M.POI_ID = N.POI_ID , ( 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 T.AUDIT_VALUE = N.POI_DTL_ID AND G.STATUS = 'VALID' AND T.OUTLET_ID = G.CODE AND U.USER_CODE = T.CREATOR_ID AND M.DISTRICT_ID = Y.DISTRICT_ID )
832bswus1k5s4SELECT COUNT(1) FROM ( SELECT P.STATION_CODE GID , P.STATION_NAME G_NAME , P.ROAD_NUM V_NUM_ROAD , P.POI_NUM V_NUM_POI , P.DIS_NUM V_NUM_DISTRICT FROM YTO_AUDIT_STATISTICS P WHERE P.AUDIT_STATE = :1 AND NVL(ROAD_NUM, 0)+NVL(POI_NUM, 0)+NVL(DIS_NUM, 0)>0 AND P.STATION_CODE IN( SELECT G.CODE FROM YTO_JINGANG_STATION G WHERE G.STATUS = 'VALID' START WITH G.CODE = (SELECT USER_ORG_CODE FROM YTO_JINGANG_USER WHERE USER_CODE = :2) CONNECT BY PRIOR G.ID = G.PARENT_ID ) )
84qubbrsr0kfninsert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
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
a49zwfctq8r84 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 , T11.COMMENTS NOPASSREASON FROM YTO_M ID_ROAD T1 LEFT JOIN (SELECT A.*, B.DATA_VALUE_M IN||'-'||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') LEFT JOIN (SELECT T8.COMMENTS , T8.AUDIT_ID FROM YTO_AUDIT_DETAIL T8 , (SELECT T9.AUDIT_ID , MAX(T9.AUDIT_TIME)AUDIT_TIME FROM YTO_AUDIT_DETAIL T9 WHERE T9.STATE = 0 GROUP BY T9.AUDIT_ID) T10 WHERE T8.STATE = 0 AND T8.AUDIT_ID = T10.AUDIT_ID AND T8.AUDIT_TIME = T10.AUDIT_TIME )T11 ON T5.AUDIT_ID = T11.AUDIT_ID 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 T5.STATE = :2 ORDER BY T1.CREATE_TIME DESC) A WHERE ROWNUM <=:3) WHERE RN >= :4
an9ph1jq3g7fdSELECT COUNT(1) FROM YTO_MID_ROAD T1 LEFT JOIN YTO_MID_ROAD_NUM T2 ON T1.ROAD_ID = T2.ROAD_ID LEFT JOIN YTO_JINGANG_STATION T3 ON (T1.CREATE_STATION_CODE = T3.CODE AND T3.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER T4 ON T1.CREATER = T4.USER_CODE LEFT JOIN YTO_AUDIT_RECORD T5 ON T2.ROAD_NUM_ID = T5.AUDIT_VALUE LEFT JOIN YTO_MID_DISTRICT T6 ON T1.DISTRICT_ID = T6.DISTRICT_ID LEFT JOIN YTO_JINGANG_STATION T7 ON (T1.CREATE_STATION_CODE = T7.CODE AND T7.STATUS = 'VALID') WHERE T2.ISDELETE = '0' AND T1.OWNER IN (SELECT CODE FROM YTO_JINGANG_STATION WHERE STATUS = 'VALID' START WITH CODE = :1 CONNECT BY PRIOR ID = PARENT_ID) AND T2.ROAD_NUM_ID IS NOT NULL
az33m61ym46y4SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name
bk5k8x08y0wfw SELECT COUNT(1) FROM ( SELECT T.AUDIT_ID , M.ROAD_ID , N.ROAD_NUM_ID , M.NAME , TRIM('£¬' FROM M.ALIAS1||'£¬'||DECODE(M.ALIAS2, '', '', M.ALIAS2, M.ALIAS2||'£¬')||M.ALIAS3) ALIAS , DECODE(NVL(N.IS_REACH, M.IS_REACH), '1', 'ÅÉËÍ', '0', '²»ÅÉËÍ')IS_REACH , M.OWNER , (SELECT TT.NAME FROM YTO_JINGANG_STATION TT WHERE TT.CODE = M.OWNER AND TT.STATUS = 'VALID') OGNAME , M.DISTRICT_ID , Y.DISTRICT_NAMES DIS_NAME , T.AUDIT_VALUE_TYPE , DECODE(T.STATE, '10', '²Ý¸å', '20', '·Ö¹«Ë¾ÉóºËÖÐ', '30', 'Ê¡ÇøÉóºËÖÐ', '40', '¹ÜÀíÇøÉóºËÖÐ', '50', '×ܹ«Ë¾ÉóºËÖÐ', '60', 'ÉóºËͨ¹ý', '70', 'ÉóºË²»Í¨¹ý' ) STATE , T.STATE AUDIT_STATE_NUM , DECODE(N.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T.AUDIT_TYPE, '1', 'ÐÂÔö', '2', 'ÐÞ¸Ä', '3', 'ɾ³ý') AUDIT_TYPE , TO_CHAR(CAST(T.CREATE_TIME AS DATE), 'YYYY-MM-DD HH24:MI:SS')CREATE_TIME , TO_CHAR(NVL(N.DATA_VALUE_MIN, 1)) || '-' ||TO_CHAR(NVL(SUBSTR(N.DATA_VALUE_MAX, INSTR(N.DATA_VALUE_MAX, ')')+1, length(N.DATA_VALUE_MAX)), 9999)) DATA_VALUE , N.DATA_VALUE_MAX , N.DATA_VALUE_MIN , G.CODE CGCODE , G.NAME CGNAME , M.CREATER CREATER_CODE , U.USER_NAME CREATER_NAME , T.COMMENTS , '' NEW_RELEASE , T.AUDIT_ORG_ID , T.AUDIT_ORG_NAME , T.AUDITOR_ID , T.AUDITOR_NAME , T.AUD IT_TIME , DECODE(N.IS_SINGLE, '0', '·ñ' , ' 1' , 'ÊÇ') IS_SINGLE , N.FLOOR_VALUE FROM YTO_MID_ROAD M , (SELECT A.*, B.DATA_VALUE_MIN||'-'||B.DATA_VALUE_MIN FLOOR_VALUE FROM YTO_MID_ROAD_NUM A LEFT JOIN YTO_MID_POI_DTL B ON A.ROAD_NUM_ID = B.ROAD_NUM_ID) N , ( SELECT A.* , B.COMMENTS , B.AUDIT_ORG_ID , S.NAME AUDIT_ORG_NAME , B.AUDITOR_ID , TO_CHAR(B.AUDIT_TIME, 'YYYY-MM-DD HH24:MI:SS') AUDIT_TIME , U.USER_NAME AUDITOR_NAME FROM (SELECT P.* FROM YTO_AUDIT_RECORD P WHERE P.OUTLET_ID = :1 AND P.STATE = :2 ) A LEFT JOIN (SELECT Q.*, ROW_NUMBER() OVER(PARTITION BY Q.AUDIT_ID ORDER BY Q.AUDIT_TIME DESC) RN FROM YTO_AUDIT_DETAIL Q) B ON A.AUDIT_ID = B.AUDIT_ID AND B.RN = 1 LEFT JOIN YTO_JINGANG_STATION S ON (S.CODE = B.AUDIT_ORG_ID AND S.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER U ON U.USER_CODE = B.AUDITOR_ID ) T , YTO_JINGANG_STATION G , YTO_JINGANG_USER U , YTO_MID_DISTRICT Y WHERE N.ISDELETE = 0 AND M.ROAD_ID = N.ROAD_ID AND G.STATUS = 'VALID' AND N.ROAD_NUM_ID = T.AUDIT_VALUE AND T.OUTLET_ID = G.CODE AND U.USER_CODE = T.CREATOR_ID AND M.DISTRICT_ID = Y.DISTRICT_ID )
c30y4ycz6yt7vSELECT "ZIP_NO_SEQ", "ADDR", "ADDR_DTL", "LRGN_NM", "MRGN_NM", "SRGN_NM", "IS_SERVICE" FROM "TB_AZ012_W0228_RESULT" "TB_AZ012_W0228_RESULT"
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
casn5xxbk9tah SELECT nvl(v.first_val, 0), nvl(v.last_val, 0), nvl(v.delta_val, 0), decode(v.stat_id, NULL, 0, 1), decode(osmap.required, 'N', 0, 1), osmap.statistic_hash, osmap.keh_id FROM ( SELECT b.value as first_val, e.value as last_val, (e.value - b.value) as delta_val, b.stat_id FROM (SELECT t1.* FROM WRH$_OSSTAT 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$_OSSTAT_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) b , (SELECT t1.* FROM WRH$_OSSTAT 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$_OSSTAT_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) e WHERE b.dbid = :dbid and e.dbid = :dbid2 and b.instance_number = :instance_number and e.instance_number = :instance_number2 and b.snap_id = :begin_snap_id and e.snap_id = :end_snap_id and b.stat_id = e.stat_id ) v, X$KEHOSM AP osmap WHERE osmap.statistic_hash = v.stat_id(+) ORDER BY osmap.keh_id ASC
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
cnpy92sm9tavbSELECT ROAD_ID FROM YTO_MID_ROAD WHERE NAME=:1 AND DISTRICT_ID=:2 AND OWNER=:3 UNION ALL SELECT T1.ROAD_ID FROM YTO_MID_ROAD_NUM T1 INNER JOIN YTO_MID_ROAD T2 ON T1.ROAD_ID=T2.ROAD_ID WHERE T2.NAME=:4 AND DISTRICT_ID=:5 AND T1.OWNER=:6 AND T1.DATA_VALUE_MIN=:7 AND T1.DATA_VALUE_MAX=:8
csnp95dz2r8ssselect file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
dbq0pds6kwqjuUPDATE YTO_AUDIT_STATISTICS T SET POI_NUM = NVL((SELECT COUNT(1) FROM YTO_AUDIT_RECORD A, YTO_MID_POI_DTL B WHERE A.AUDIT_VALUE = B.POI_DTL_ID AND T.STATION_CODE = A.OUTLET_ID AND T.AUDIT_STATE = A.STATE AND B.ISDELETE = 0 AND B.ROAD_NUM_ID IS NULL GROUP BY A.AUDIT_VALUE_TYPE, A.OUTLET_ID, A.STATE), 0) WHERE T.AUDIT_STATE = :1 AND T.STATION_CODE = :2
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
dxdwxhrp87q6z SELECT * FROM (SELECT YTO_POI_AUDIT.*, ROWNUM RN FROM( SELECT T.AUDIT_ID , M.POI_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(T.AUDIT_TYPE, '1', 'ÐÂÔö', '2', 'ÐÞ¸Ä', '3', 'ɾ³ý') AUDIT_TYPE , TO_CHAR(CAST(T.CREATE_TIME AS DATE), 'YYYY-MM-DD HH24:MI:SS')CREATE_TIME , NVL(N.DATA_VALUE, '1-9999') DATA_VALUE , NVL(SUBSTR(N.DATA_VALUE, INSTR(N.DATA_VALUE, '-')+1), 9999)DATA_VALUE_MAX , NVL(SUBSTR(N.DATA_VALUE, 0, INSTR(N.DATA_VALUE, '-')-1), 1)DATA_VALUE_MIN , G.CODE CGCODE , G.NAME CGNAME , M.CREATER CREATER_CODE , U.USER_NAME CREATER_NAME , CASE WHEN T.COMMENTS IS NULL THEN DECODE(T.STATE, '10', '²Ý¸å', '20', '·Ö¹«Ë¾ÉóºËÖÐ', '30', '·Ö¹«Ë¾ÉóºËͨ¹ý', '40', 'Ê¡¹«Ë¾ÉóºËͨ¹ý', '50', '¹Ü ÀíÇøÉóºËͨ¹ý', '60', '×ܹ«Ë¾ÉóºËͨ¹ý', '70', 'ÉÏ´ÎÉóºËδͨ¹ý') ELSE T.COMMENTS END COMMENTS , '' NEW_RELEASE , T.AUDIT_ORG_ID , T.AUDIT_ORG_NAME , T.AUDITOR_ID , T.AUDITOR_NAME , T.AUDIT_TIME FROM YTO_MID_POI M LEFT JOIN YTO_MID_POI_DTL N ON M.POI_ID = N.POI_ID , ( 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 T.AUDIT_VALUE = N.POI_DTL_ID AND G.STATUS = 'VALID' AND T.OUTLET_ID = G.CODE AND U.USER_CODE = T.CREATOR_ID AND M.DISTRICT_ID = Y.DISTRICT_ID )YTO_POI_AUDIT WHERE ROWNUM <=:3) WHERE RN >= :4
frr9vmmcsadhbselect * from ( select distinct a.id, a.task_id, a.later_status, a.lazy_time, a.vehicle_no, a.line_name, to_char(a.gps_time, 'yyyy-MM-dd HH24:mi:ss'), a.is_disposal, b.name, c.device_id from t_later_info a, yto_org_node b, yto_in_out_area_s c, (select g.gid from t_privilage_group g start with g.gid = (select gid from ref_user_group where user_id = (select id from t_user where user_account = '00002578'))connect by prior g.gid = g.parent_id) d where a.task_id = c.task_id and b.org_id = ( case a.later_status when 1 then c.start_org_code else c.end_org_code end)and a.is_disposal = 0 and sysdate - a.gps_time < 5 and (c.start_org_code = d.gid or c.end_org_code = d.gid ) ) where rownum <= :1
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
g1u8jnzfm96nx select m1.device_id, m1.latitude, m1.longitude, m1.speed, m1.direction, m1.gpstime, m1.stop_car, m1.engine, m2.vehicle_id, m2.line_no, m2.next_org_code, m2.is_lazy, m2.EXPECTED_END_DATE, m2.task_id, m2.sdate, m2.edate, m1.fictitious_line_name from (select t1.device_id as device_id, t2.latitude as latitude, t2.longitude as longitude, t2.speed as speed, t2.direction as direction, to_char(t2.gpstime, 'yyyy-MM-dd HH24:mi:ss') as gpstime, t3.stop_car as stop_car, t3.flame_out as engine, t4.fictitious_line_name from t_terminal t1, t_last_locrecord t2, t_term_status_last_record t3, ( select b.tid, h.fictitious_line_name from ref_vehicle_terminal b, yto_vehicle_ref g, yto_fictitious_line h where b.vid = g.id(+) and g.fictitious_line_id = h.fictitious_line_id(+) ) t4 where t1.device_id = t2.device_id and t1.device_id = t3.device_id(+) and t1.device_id = t4.tid(+) and t1.device_id in ('13721982074', '13721878525', '13721986854', '13721986940', '14782232230')) m1, (select y1.termial_id as device_id , y1.vehicle_id as vehicle_id, y1.line_no as line_no, y1.next_org_code as next_org_code, y2.is_lazy as is_lazy, to_char(y2.EXPECTED_END_DATE, 'yyyy-MM-dd HH24:mi:ss') as EXPECTED_END_DATE, y1.task_id, to_char(y4.sdate, 'yyyy-MM-dd HH24:mi:ss') sdate, to_char(y4.edate, 'yyyy-MM-dd HH24:mi:ss') edate from yto_task y1, yto_task_dtl y2, ( select yy3.task_id, y3.real_start_date sdate, y32.real_end_date edate from yto_task yy3, yto_task_dtl y3, yto_task _dtl y32 where yy3.task_id = y3.task_id and yy3.task_id = y32.task_id and yy3.start_org_code = y3.start_org_code and yy3.end_org_code = y32.end_org_code ) y4, t_last_locrecord y5 where y1.task_id = y2.task_id and y1.next_org_code = y2.end_org_code and y1.task_id = y4.task_id and y1.termial_id = y5.device_id and y1.create_date <= y5.gpstime+1 and y1.is_over = 0) m2 where m1.device_id = m2.device_id(+)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 46,479 12.95 44.35
CPU used when call started 45,975 12.81 43.87
CR blocks created 95 0.03 0.09
Cached Commit SCN referenced 0 0.00 0.00
Commit SCN cached 0 0.00 0.00
DB time 410,626 114.38 391.82
DBWR checkpoint buffers written 1,069 0.30 1.02
DBWR checkpoints 5 0.00 0.00
DBWR fusion writes 139 0.04 0.13
DBWR transaction table writes 63 0.02 0.06
DBWR undo block writes 189 0.05 0.18
DFO trees parallelized 78 0.02 0.07
PX local messages recv'd 420 0.12 0.40
PX local messages sent 420 0.12 0.40
PX remote messages recv'd 220 0.06 0.21
PX remote messages sent 344 0.10 0.33
Parallel operations not downgraded 78 0.02 0.07
RowCR - row contention 4 0.00 0.00
RowCR attempts 239 0.07 0.23
RowCR hits 242 0.07 0.23
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 15,209 4.24 14.51
active txn count during cleanout 48 0.01 0.05
application wait time 4 0.00 0.00
background checkpoints completed 4 0.00 0.00
background checkpoints started 5 0.00 0.00
background timeouts 24,546 6.84 23.42
buffer is not pinned count 1,405,506 391.50 1,341.13
buffer is pinned count 3,518,236 980.01 3,357.10
bytes received via SQL*Net from client 6,841,166 1,905.61 6,527.83
bytes sent via SQL*Net to client 147,022,726 40,953.26 140,288.86
calls to get snapshot scn: kcmgss 67,544 18.81 64.45
calls to kcmgas 5,056 1.41 4.82
calls to kcmgcs 98 0.03 0.09
change write time 12 0.00 0.01
cleanout - number of ktugct calls 277 0.08 0.26
cleanouts and rollbacks - consistent read gets 0 0.00 0.00
cleanouts only - consistent read gets 181 0.05 0.17
cluster key scan block gets 23,813 6.63 22.72
cluster key scans 389 0.11 0.37
cluster wait time 406 0.11 0.39
commit batch/immediate performed 2 0.00 0.00
commit batch/immediate requested 2 0.00 0.00
commit cleanout failures: block lost 16 0.00 0.02
commit cleanout failures: callback failure 107 0.03 0.10
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 2,344 0.65 2.24
commit cleanouts successfully completed 2,221 0.62 2.12
commit immediate performed 2 0.00 0.00
commit immediate requested 2 0.00 0.00
commit txn count during cleanout 286 0.08 0.27
concurrency wait time 96 0.03 0.09
consistent changes 106 0.03 0.10
consistent gets 13,173,087 3,669.37 12,569.74
consistent gets - examination 1,507,584 419.94 1,438.53
consistent gets direct 4 0.00 0.00
consistent gets from cache 13,173,083 3,669.37 12,569.74
current blocks converted for CR 0 0.00 0.00
cursor authentications 88 0.02 0.08
data blocks consistent reads - undo records applied 3 0.00 0.00
db block changes 11,666 3.25 11.13
db block gets 12,018 3.35 11.47
db block gets direct 3 0.00 0.00
db block gets from cache 12,015 3.35 11.46
deferred (CURRENT) block cleanout applications 1,230 0.34 1.17
dirty buffers inspected 0 0.00 0.00
enqueue conversions 3,367 0.94 3.21
enqueue releases 128,743 35.86 122.85
enqueue requests 128,745 35.86 122.85
enqueue timeouts 2 0.00 0.00
enqueue waits 890 0.25 0.85
exchange deadlocks 0 0.00 0.00
execute count 16,232 4.52 15.49
free buffer inspected 10,990 3.06 10.49
free buffer requested 33,821 9.42 32.27
gc CPU used by this session 18,172 5.06 17.34
gc blocks lost 0 0.00 0.00
gc cr block build time 3 0.00 0.00
gc cr block flush time 0 0.00 0.00
gc cr block receive time 1,629 0.45 1.55
gc cr block send time 4 0.00 0.00
gc cr blocks received 23,882 6.65 22.79
gc cr blocks served 1,436 0.40 1.37
gc current block flush time 1 0.00 0.00
gc current block pin time 1 0.00 0.00
gc current block receive time 41 0.01 0.04
gc current block send time 7 0.00 0.01
gc current blocks received 1,015 0.28 0.97
gc current blocks served 1,966 0.55 1.88
gc local grants 152 0.04 0.15
gc remote grants 642 0.18 0.61
gcs messages sent 1,636,544 455.86 1,561.59
ges messages sent 19,095 5.32 18.22
global enqueue get time 310 0.09 0.30
global enqueue gets async 7,308 2.04 6.97
global enqueue gets sync 20,924 5.83 19.97
global enqueue releases 23,100 6.43 22.04
heap block compress 58 0.02 0.06
hot buffers moved to head of LRU 40 0.01 0.04
immediate (CR) block cleanout applications 181 0.05 0.17
immediate (CURRENT) block cleanout applications 230 0.06 0.22
index crx upgrade (positioned) 1,909 0.53 1.82
index fast full scans (full) 196 0.05 0.19
index fetch by key 529,924 147.61 505.65
index scans kdiixs1 412,728 114.97 393.82
leaf node 90-10 splits 9 0.00 0.01
leaf node splits 16 0.00 0.02
lob reads 4 0.00 0.00
lob writes 41 0.01 0.04
lob writes unaligned 41 0.01 0.04
logons cumulative 2,923 0.81 2.79
messages received 8,332 2.32 7.95
messages sent 8,332 2.32 7.95
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 11,612,988 3,234.80 11,081.10
opened cursors cumulative 11,517 3.21 10.99
parse count (failures) 1 0.00 0.00
parse count (hard) 1,676 0.47 1.60
parse count (total) 11,388 3.17 10.87
parse time cpu 1,690 0.47 1.61
parse time elapsed 1,748 0.49 1.67
physical read IO requests 1,297 0.36 1.24
physical read bytes 11,763,712 3,276.79 11,224.92
physical read total IO requests 13,959 3.89 13.32
physical read total bytes 221,107,200 61,589.53 210,980.15
physical read total multi block requests 56 0.02 0.05
physical reads 1,436 0.40 1.37
physical reads cache 620 0.17 0.59
physical reads cache prefetch 182 0.05 0.17
physical reads direct 816 0.23 0.78
physical reads direct (lob) 1 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 182 0.05 0.17
physical write IO requests 1,189 0.33 1.13
physical write bytes 11,354,112 3,162.69 10,834.08
physical write total IO requests 6,826 1.90 6.51
physical write total bytes 83,778,560 23,336.56 79,941.37
physical write total multi block requests 1,007 0.28 0.96
physical writes 1,386 0.39 1.32
physical writes direct 203 0.06 0.19
physical writes direct (lob) 3 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 1,183 0.33 1.13
physical writes non checkpoint 525 0.15 0.50
pinned buffers inspected 0 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 51 0.01 0.05
process last non-idle time 3,635 1.01 3.47
queries parallelized 78 0.02 0.07
recursive calls 62,299 17.35 59.45
recursive cpu usage 2,300 0.64 2.19
redo blocks written 6,623 1.84 6.32
redo buffer allocation retries 0 0.00 0.00
redo entries 7,951 2.21 7.59
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 117 0.03 0.11
redo size 2,768,276 771.10 2,641.48
redo subscn max counts 361 0.10 0.34
redo synch time 2 0.00 0.00
redo synch writes 112 0.03 0.11
redo wastage 459,144 127.89 438.11
redo write broadcast ack time 0 0.00 0.00
redo write time 74 0.02 0.07
redo writer latching time 0 0.00 0.00
redo writes 1,483 0.41 1.42
rollback changes - undo records applied 6 0.00 0.01
rollbacks only - consistent read gets 3 0.00 0.00
rows fetched via callback 431,199 120.11 411.45
session connect time 0 0.00 0.00
session cursor cache hits 3,119 0.87 2.98
session logical reads 13,185,105 3,672.72 12,581.21
shared hash latch upgrades - no wait 2,543 0.71 2.43
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 8,933 2.49 8.52
sorts (rows) 19,958,812 5,559.54 19,044.67
sql area evicted 1,139 0.32 1.09
sql area purged 1 0.00 0.00
summed dirty queue length 0 0.00 0.00
switch current to new buffer 18 0.01 0.02
table fetch by rowid 1,748,758 487.12 1,668.66
table fetch continued row 182 0.05 0.17
table scan blocks gotten 10,596,340 2,951.62 10,111.01
table scan rows gotten 572,396,828 159,441.44 546,180.18
table scans (long tables) 0 0.00 0.00
table scans (short tables) 9,378 2.61 8.95
total number of times SMON posted 21 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 900,848 250.93 859.59
user I/O wait time 179 0.05 0.17
user calls 26,063 7.26 24.87
user commits 679 0.19 0.65
user rollbacks 369 0.10 0.35
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 10,341 2.88 9.87
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 8,500,790,592 9,253,094,496
session cursor cache count 71,679 75,066
session uga memory 5.3E+12 5.5E+12
opened cursors current 57 57
logons current 69 71
session uga memory max 13,405,519,176 14,436,127,720
session pga memory 6,790,021,792 7,132,494,976

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 5 5.01

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
WZT 587 0 1.64 1.16 324 0 1 20.00
SYSAUX 51 0 4.51 1.73 484 0 0 0.00
UNDOTBS2 17 0 0.00 1.00 136 0 0 0.00
SYSTEM 1 0 0.00 1.00 98 0 0 0.00
HIS_GPS_02_2 43 0 0.00 1.00 6 0 0 0.00
HIS_GPS_01_1 40 0 0.00 1.00 7 0 0 0.00
HIS_GPS_01_2 40 0 0.00 1.00 7 0 0 0.00
HIS_GPS_02_1 41 0 0.00 1.00 6 0 0 0.00
HIS_GPS_12_3 30 0 0.00 1.00 7 0 0 0.00
HIS_GPS_10_3 24 0 0.00 1.00 7 0 0 0.00
TS_IDX_YTMOT 20 0 0.00 1.00 10 0 0 0.00
HIS_GPS_01_3 24 0 0.00 1.00 5 0 0 0.00
HIS_GPS_02_3 24 0 0.00 1.00 4 0 0 0.00
HIS_GPS_03_1 25 0 0.00 1.00 3 0 0 0.00
HIS_GPS_03_2 25 0 0.00 1.00 3 0 0 0.00
HIS_GPS_03_3 25 0 0.00 1.00 3 0 0 0.00
HIS_GPS_12_1 22 0 0.00 1.00 6 0 0 0.00
HIS_GPS_12_2 22 0 0.00 1.00 6 0 0 0.00
HIS_GPS_09_2 18 0 0.00 1.00 5 0 0 0.00
HIS_GPS_10_2 18 0 0.00 1.00 5 0 0 0.00
HIS_GPS_11_2 18 0 0.00 1.00 5 0 0 0.00
HIS_GPS_11_3 18 0 0.00 1.00 5 0 0 0.00
HIS_GPS_08_3 13 0 0.00 1.00 4 0 0 0.00
HIS_GPS_08_1 10 0 0.00 1.00 3 0 0 0.00
HIS_GPS_09_1 10 0 0.00 1.00 3 0 0 0.00
HIS_GPS_09_3 10 0 0.00 1.00 3 0 0 0.00
HIS_GPS_10_1 10 0 0.00 1.00 3 0 0 0.00
HIS_GPS_11_1 10 0 0.00 1.00 3 0 0 0.00
UNDOTBS1 9 0 0.00 1.00 3 0 0 0.00
HIS_GPS_04_1 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_04_2 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_04_3 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_05_1 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_05_2 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_05_3 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_07_3 7 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_2 7 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_2 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_3 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_1 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_2 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_1 5 0 0.00 1.00 2 0 0 0.00
HIS_GPS_20130501 1 0 0.00 1.00 1 0 0 0.00
HIS_GPS_20130502 1 0 0.00 1.00 1 0 0 0.00
HIS_GPS_20130503 1 0 0.00 1.00 1 0 0 0.00
SPLEX_TSP 1 0 0.00 1.00 1 0 0 0.00
USERS 1 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_01.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_1.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_11.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_21.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_31.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_12.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_2.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_22.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_32.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_3 +DATADG/gpsdb/dbf_01_03.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_01_3 +DATADG/gpsdb/dbf_01_13.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_3 +DATADG/gpsdb/dbf_01_3.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_01.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_1.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_11.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_21.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_31.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_02.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_12.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_2.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_22.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_32.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_3 +DATADG/gpsdb/dbf_02_03.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_3 +DATADG/gpsdb/dbf_02_13.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_3 +DATADG/gpsdb/dbf_02_3.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_1 +DATADG/gpsdb/dbf_03_1 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_1 +DATADG/gpsdb/dbf__03_01.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_1 +DATADG/gpsdb/dbf__03_11.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_2 +DATADG/gpsdb/dbf_03_02.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_2 +DATADG/gpsdb/dbf_03_12.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_2 +DATADG/gpsdb/dbf_03_2 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_3 +DATADG/gpsdb/dbf_03_03.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_3 +DATADG/gpsdb/dbf_03_13.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_3 +DATADG/gpsdb/dbf_03_3 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_04_1 +DATADG/gpsdb/dbf_04_1 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_04_2 +DATADG/gpsdb/dbf_04_2 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_04_3 +DATADG/gpsdb/dbf_04_3 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_05_1 +DATADG/gpsdb/dbf_05_1 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_05_2 +DATADG/gpsdb/dbf_05_2 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_05_3 +DATADG/gpsdb/dbf_05_3 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_1 +DATADG/gpsdb/dbf_06_1.dbf 2 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_1 +DATADG/gpsdb/dbf_06_1b.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_2 +DATADG/gpsdb/dbf_06_2.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_2 +DATADG/gpsdb/dbf_06_2b.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_3 +DATADG/gpsdb/dbf_06_3.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_06_3 +DATADG/gpsdb/dbf_06_3b.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_07_1 +DATADG/gpsdb/dbf_07_1.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_07_1 +DATADG/gpsdb/dbf_07_1b.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_07_2 +DATADG/gpsdb/dbf_07_2.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_07_2 +DATADG/gpsdb/dbf_07_2b.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_07_3 +DATADG/gpsdb/dbf_07_3.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_07_3 +DATADG/gpsdb/dbf_07_3b.dbf 4 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_1 +DATADG/gpsdb/dbf_08_1.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_1 +DATADG/gpsdb/dbf_08_1b.dbf 4 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_1 +FLASHAREA_DG/gpsdb/dbf_08_2.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_2 +DATADG/gpsdb/dbf_08_2.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_2 +DATADG/gpsdb/dbf_08_2b.dbf 4 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_3 +DATADG/gpsdb/dbf_08_3.dbf 3 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_3 +DATADG/gpsdb/dbf_08_3b.dbf 4 0 0.00 1.00 1 0 0 0.00
HIS_GPS_08_3 +DATADG/gpsdb/dbf_08_3c.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_1 +DATADG/gpsdb/dbf_09_1.dbf 4 0 0.00 1.00 1 0 0 0.00
HIS_GPS_09_1 +DATADG/gpsdb/dbf_09_1_01.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_2 +DATADG/gpsdb/dbf_09_2.dbf 4 0 0.00 1.00 1 0 0 0.00
HIS_GPS_09_2 +DATADG/gpsdb/dbf_09_2b.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_2 +DATADG/gpsdb/dbf_10_2_03.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_3 +DATADG/gpsdb/dbf_09_3.dbf 4 0 0.00 1.00 1 0 0 0.00
HIS_GPS_09_3 +DATADG/gpsdb/dbf_09_3b.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_1 +DATADG/gpsdb/dbf_10_1.dbf 4 0 0.00 1.00 1 0 0 0.00
HIS_GPS_10_1 +DATADG/gpsdb/dbf_10_1_02.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_2 +DATADG/gpsdb/dbf_10_2.dbf 4 0 0.00 1.00 1 0 0 0.00
HIS_GPS_10_2 +DATADG/gpsdb/dbf_10_2_02.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_2 +DATADG/gpsdb/dbf_10_2_12.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_3 +DATADG/gpsdb/dbf_10_3.dbf 4 0 0.00 1.00 1 0 0 0.00
HIS_GPS_10_3 +DATADG/gpsdb/dbf_10_3_02.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_3 +DATADG/gpsdb/dbf_10_3_03.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_3 +DATADG/gpsdb/dbf_10_3_13.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_1 +DATADG/gpsdb/dbf_11_1.dbf 4 0 0.00 1.00 1 0 0 0.00
HIS_GPS_11_1 +DATADG/gpsdb/dbf_11_1_02.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_2 +DATADG/gpsdb/dbf_11_2.dbf 4 0 0.00 1.00 1 0 0 0.00
HIS_GPS_11_2 +DATADG/gpsdb/dbf_11_2_02.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_2 +DATADG/gpsdb/dbf_11_2_12.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_3 +DATADG/gpsdb/dbf_11_3.dbf 4 0 0.00 1.00 1 0 0 0.00
HIS_GPS_11_3 +DATADG/gpsdb/dbf_11_3_02.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_3 +DATADG/gpsdb/dbf_11_3_03.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_1 +DATADG/gpsdb/dbf_12_01.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_1 +DATADG/gpsdb/dbf_12_1.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_1 +DATADG/gpsdb/dbf_12_11.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_2 +DATADG/gpsdb/dbf_12_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_2 +DATADG/gpsdb/dbf_12_12.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_2 +DATADG/gpsdb/dbf_12_2.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_3 +DATADG/gpsdb/dbf_12_03.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_3 +DATADG/gpsdb/dbf_12_23.dbf 8 0 0.00 1.00 1 0 0 0.00
HIS_GPS_12_3 +DATADG/gpsdb/dbf_12_3.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_3 +DATADG/gpsdb/dbf_12_3_13.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_20130501 +DATADG/gpsdb/dbf_130501.dbf 1 0 0.00 1.00 1 0 0 0.00
HIS_GPS_20130502 +DATADG/gpsdb/dbf_130502.dbf 1 0 0.00 1.00 1 0 0 0.00
HIS_GPS_20130503 +DATADG/gpsdb/dbf_130503.dbf 1 0 0.00 1.00 1 0 0 0.00
SPLEX_TSP +DATADG/gpsdb/splex_tbs_01.dbf 1 0 0.00 1.00 1 0 0 0.00
SYSAUX +DATADG/gpsdb/sysaux01.dbf 51 0 4.51 1.73 484 0 0 0.00
SYSTEM +DATADG/gpsdb/system01.dbf 1 0 0.00 1.00 98 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_01.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_02.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_03.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_04.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_05.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_06.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_07.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_08.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_09.dbf 2 0 0.00 1.00 1 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_10.dbf 2 0 0.00 1.00 1 0 0 0.00
UNDOTBS1 +DATADG/gpsdb/undotbs01.dbf 1 0 0.00 1.00 1 0 0 0.00
UNDOTBS1 +DATADG/gpsdb/undotbs03.dbf 4 0 0.00 1.00 1 0 0 0.00
UNDOTBS1 +DATADG/gpsdb/undotbs05.dbf 4 0 0.00 1.00 1 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs02.dbf 1 0 0.00 1.00 74 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs04.dbf 4 0 0.00 1.00 16 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs06.dbf 4 0 0.00 1.00 39 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs07.dbf 4 0 0.00 1.00 1 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs08.dbf 4 0 0.00 1.00 6 0 0 0.00
USERS +DATADG/gpsdb/users01.dbf 1 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_01.dbf 11 0 2.73 1.82 9 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_02.dbf 3 0 6.67 1.00 4 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_03.dbf 3 0 6.67 1.67 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_04.dbf 2 0 0.00 1.00 5 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_05.dbf 6 0 11.67 2.17 12 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_06.dbf 8 0 7.50 1.13 16 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_07.dbf 21 0 2.86 1.24 15 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_08.dbf 10 0 1.00 1.00 7 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_09.dbf 16 0 1.25 1.00 26 0 1 20.00
WZT +DATADG/gpsdb/wzt_tbs_10.dbf 3 0 3.33 1.00 7 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_11.dbf 13 0 5.38 1.00 20 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_12.dbf 12 0 6.67 1.58 32 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_13.dbf 6 0 3.33 3.83 22 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_14.dbf 277 0 0.29 1.00 10 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_15.dbf 9 0 5.56 1.11 6 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_16.dbf 8 0 10.00 1.75 9 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_17.dbf 10 0 4.00 1.50 5 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_18.dbf 9 0 3.33 1.44 13 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_19.dbf 9 0 2.22 1.56 5 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_20.dbf 7 0 7.14 2.00 4 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_21.dbf 12 0 5.83 1.92 19 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_22.dbf 3 0 0.00 1.00 5 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_23.dbf 4 0 2.50 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_24.dbf 7 0 4.29 2.29 8 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_25.dbf 8 0 1.25 1.00 5 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_26.dbf 4 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_27.dbf 6 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_28.dbf 6 0 0.00 1.00 14 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_29.dbf 7 0 1.43 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_30.dbf 6 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_31.dbf 6 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_32.dbf 6 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_33.dbf 9 0 0.00 1.00 18 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_34.dbf 12 0 0.83 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_35.dbf 9 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_36.dbf 9 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_37.dbf 8 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_38.dbf 8 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_39.dbf 8 0 0.00 1.00 1 0 0 0.00
WZT +FLASHAREA_DG/gpsdb/wzt_tbs_26.dbf 6 0 0.00 1.00 6 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 13,185,044 624 1,183 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 249 906 1912 2831130 1912  
E 0 0 310 1012 1678 2831130 1678  

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

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,607 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,100 389.22 0.31 0.08 100.00 0.00 838,860
E 8,192 7,100 389.61 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,162 8,162 0 0
64K 128K 291 291 0 0
512K 1024K 944 944 0 0
1M 2M 744 744 0 0
2M 4M 60 60 0 0
4M 8M 58 58 0 0
16M 32M 28 28 0 0
64M 128M 54 54 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 84,143.85 327.42 100.00 0
2,048 0.25 84,143.85 327.42 100.00 0
4,096 0.50 84,143.85 327.42 100.00 0
6,144 0.75 84,143.85 327.42 100.00 0
8,192 1.00 84,143.85 327.42 100.00 0
9,830 1.20 84,143.85 0.00 100.00 0
11,469 1.40 84,143.85 0.00 100.00 0
13,107 1.60 84,143.85 0.00 100.00 0
14,746 1.80 84,143.85 0.00 100.00 0
16,384 2.00 84,143.85 0.00 100.00 0
24,576 3.00 84,143.85 0.00 100.00 0
32,768 4.00 84,143.85 0.00 100.00 0
49,152 6.00 84,143.85 0.00 100.00 0
65,536 8.00 84,143.85 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 830 36,700 23,897 0.99 3,357 1.08 4,836
2,128 0.29 1,564 54,581 24,050 1.00 3,204 1.03 4,849
2,864 0.39 2,299 73,960 24,086 1.00 3,168 1.02 4,853
3,600 0.49 3,034 88,003 24,105 1.00 3,149 1.01 4,856
4,336 0.60 3,769 107,362 24,118 1.00 3,136 1.00 4,857
5,072 0.70 4,504 120,180 24,124 1.00 3,130 1.00 4,858
5,808 0.80 5,239 132,464 24,127 1.00 3,127 1.00 4,859
6,544 0.90 5,974 144,758 24,131 1.00 3,123 1.00 4,860
7,280 1.00 6,709 165,553 24,133 1.00 3,121 1.00 4,860
8,016 1.10 7,444 185,469 24,135 1.00 3,119 1.00 4,860
8,752 1.20 8,179 206,374 24,136 1.00 3,118 1.00 4,861
9,488 1.30 8,914 219,061 24,138 1.00 3,116 1.00 4,861
10,224 1.40 9,648 230,420 24,139 1.00 3,115 1.00 4,862
10,960 1.51 10,381 242,581 24,141 1.00 3,113 1.00 4,862
11,696 1.61 11,115 261,211 24,142 1.00 3,112 1.00 4,862
12,432 1.71 11,849 274,821 24,143 1.00 3,111 1.00 4,863
13,168 1.81 12,584 297,212 24,145 1.00 3,109 1.00 4,863
13,904 1.91 13,319 316,876 24,146 1.00 3,108 1.00 4,863
14,640 2.01 14,640 386,628 24,161 1.00 3,093 0.99 4,865

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 262,303 1,030,199
10,240 0.50 262,172 959,022
15,360 0.75 262,067 957,968
20,480 1.00 262,067 957,968
25,600 1.25 262,041 957,968
30,720 1.50 262,041 957,968
35,840 1.75 262,041 957,968
40,960 2.00 262,041 957,968

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 20

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,062 9,060 2 379 0 0.32
PS-PX Process Reservation 535 535 0 167 0 0.48
TM-DML 1,848 1,848 0 122 0 0.49
TT-Tablespace 304 304 0 136 0 0.29
JQ-Job Queue 60 60 0 12 0 0.83
TA-Instance Undo 11 11 0 11 0 0.00
WF-AWR Flush 21 21 0 10 0 0.00
MW-MWIN Schedule 2 2 0 2 0 0.00
TX-Transaction (row lock contention) 4 4 0 2 0 0.00
WL-Being Written Redo Log 5 5 0 2 0 0.00
AF-Advisor Framework (task serialization) 7 7 0 1 0 0.00
HW-Segment High Water Mark 1,299 1,299 0 1 0 0.00
JS-Job Scheduler (job run lock - synchronize) 2 2 0 1 0 0.00
UL-User-defined 2 2 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
5 0.16 1,073 2,278 3 30.8/51 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 10:10 16 140 1,666 3 41 0/0 0/0/0/0/0/0
13-Mar 10:00 92 261 1,066 3 31 0/0 0/0/0/0/0/0
13-Mar 09:50 9 106 466 3 45 0/0 0/0/0/0/0/0
13-Mar 09:40 8 140 0 1 49 0/0 0/0/0/0/0/0
13-Mar 09:30 8 107 0 1 39 0/0 0/0/0/0/0/0
13-Mar 09:20 16 212 2,278 3 51 0/0 0/0/0/0/0/0
13-Mar 09:10 8 107 1,581 1 39 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM allocation 150 0.00   0 0  
ASM db client latch 9,658 0.00   0 0  
ASM map headers 1,873 0.00   0 0  
ASM map load waiting list 475 0.00   0 0  
ASM map operation freelist 59 0.00   0 0  
ASM map operation hash table 1,902,383 0.00   0 0  
ASM network background latch 3,544 0.00   0 0  
AWR Alerted Metric Element list 21,309 0.00   0 0  
Consistent RBA 1,437 0.00   0 0  
FAL request queue 81 0.00   0 0  
FAL subheap alocation 81 0.00   0 0  
FIB s.o chain latch 30 0.00   0 0  
FOB s.o list latch 2,548 0.00   0 0  
JS broadcast add buf latch 3,066 0.00   0 0  
JS broadcast drop buf latch 3,067 0.00   0 0  
JS broadcast load blnc latch 2,963 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 106,702 0.00   0 0  
JS slv state obj latch 52 0.00   0 0  
KCL gc element parent latch 110,620 0.00   0 78 0.00
KFK SGA context latch 7,012 0.00   0 0  
KFMD SGA 132 0.00   0 0  
KJC message pool free list 12,990 0.27 0.00 0 2,134 0.09
KJCT flow control latch 3,196,089 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 1,197 0.00   0 0  
KSXR large replies 2 0.00   0 0  
KTF sga latch 16 0.00   0 1,117 0.00
KWQMN job cache list latch 260 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,197 0.00
OS process 8,448 0.00   0 0  
OS process allocation 6,830 0.03 0.00 0 0  
OS process: request allocation 5,550 0.00   0 0  
PL/SQL warning settings 3,008 0.00   0 0  
Reserved Space Latch 15 0.00   0 0  
SQL memory manager latch 1 0.00   0 1,196 0.00
SQL memory manager workarea list latch 92,674 0.00   0 0  
Shared B-Tree 130 0.00   0 0  
active checkpoint queue latch 10,748 0.01 0.00 0 0  
active service list 34,998 0.05 0.17 0 2,649 0.04
alert log latch 10 0.00   0 0  
archive control 135 0.00   0 0  
archive process latch 1,368 0.00   0 0  
begin backup scn array 3 0.00   0 0  
business card 156 0.00   0 0  
cache buffer handles 6,257 0.00   0 0  
cache buffers chains 25,191,146 0.00 0.03 0 95,094 0.00
cache buffers lru chain 22,964 0.00   0 111,899 0.00
channel handle pool latch 5,575 0.00   0 0  
channel operations parent latch 377,718 0.00 0.00 0 0  
checkpoint queue latch 787,525 0.00   0 1,459 0.00
client/application info 5,654 0.00   0 0  
commit callback allocation 4 0.00   0 0  
compile environment latch 2,923 0.00   0 0  
dml lock allocation 3,860 0.00   0 0  
dummy allocation 5,844 0.07 0.00 0 0  
enqueue hash chains 269,828 0.00 0.00 0 5 0.00
enqueues 255,051 0.00 0.00 0 0  
error message lists 378 0.00   0 0  
event group latch 2,776 0.00   0 0  
file cache latch 2,744 0.00   0 0  
gcs opaque info freelist 2,734 0.00   0 0  
gcs partitioned table hash 600,383 0.00   0 0  
gcs remastering latch 28 0.00   0 0  
gcs resource freelist 124,486 0.00   0 48,230 0.00
gcs resource hash 261,698 0.06 0.01 0 0  
gcs shadows freelist 125,939 0.00   0 49,107 0.00
ges caches resource lists 18,452 0.19 0.00 0 47,155 0.01
ges deadlock list 260 0.00   0 0  
ges domain table 33,334 0.00   0 0  
ges enqueue table freelist 52,208 0.00   0 0  
ges group table 49,458 0.00 0.00 0 0  
ges process hash list 15,189 0.00   0 0  
ges process parent latch 114,816 0.00   0 0  
ges process table freelist 5,550 0.00   0 0  
ges resource hash list 108,483 0.02 0.00 0 4,769 0.04
ges resource scan list 22 0.00   0 0  
ges resource table freelist 7,111 0.00   0 0  
ges timeout list 1,878 0.00   0 1,225 0.00
global KZLD latch for mem in SGA 228 0.00   0 0  
global tx hash mapping 71 0.00   0 0  
hash table column usage latch 84 0.00   0 347,808 0.00
hash table modification latch 78 0.00   0 0  
internal temp table object number allocation latc 2 0.00   0 0  
interrupt manipulation 655 0.00   0 0  
job workq parent latch 0     0 124 0.00
job_queue_processes parameter latch 122 0.00   0 0  
kks stats 6,679 0.00   0 0  
kokc descriptor allocation latch 100 0.00   0 0  
ksuosstats global area 241 0.00   0 0  
ktm global data 21 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 1,925 0.00   0 0  
library cache 188,418 0.04 0.00 0 4,979 0.00
library cache load lock 42 0.00   0 0  
library cache lock 122,811 0.11 0.00 0 0  
library cache lock allocation 2,529 0.00   0 0  
library cache pin 55,575 0.01 0.00 0 0  
library cache pin allocation 420 0.00   0 0  
list of block allocation 165 0.00   0 0  
loader state object freelist 140 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 1 0.00   0 1 0.00
message pool operations parent latch 1,098 0.00   0 0  
messages 196,337 0.01 0.00 0 0  
mostly latch-free SCN 1,927 0.00   0 0  
msg queue 240 0.00   0 240 0.00
multiblock read objects 13,100 0.00   0 0  
name-service memory objects 24,174 0.00   0 0  
name-service namespace bucket 49,835 0.00   0 0  
name-service pending queue 3,886 0.00   0 0  
name-service request queue 45,545 0.00   0 0  
ncodef allocation latch 92 0.00   0 0  
object queue header heap 43,247 0.00   0 232 0.00
object queue header operation 109,627 0.02 0.04 0 0  
object stats modification 2 0.00   0 0  
parallel query alloc buffer 2,044 0.00   0 0  
parallel query stats 319 0.00   0 0  
parallel txn reco latch 5,640 0.00   0 0  
parameter list 11,027 0.00   0 0  
parameter table management 5,848 0.00   0 0  
post/wait queue 218 0.00   0 151 0.00
process allocation 42,692 0.11 0.85 0 2,770 0.22
process group creation 5,550 0.02 0.00 0 0  
process queue 849 0.00   0 0  
process queue reference 14,364 0.00   0 1,411 0.00
qmn task queue latch 508 0.00   0 0  
query server freelists 704 0.00   0 0  
queued dump request 17,947 0.00   0 0  
redo allocation 9,462 0.05 0.00 0 7,995 0.00
redo copy 0     0 7,995 0.01
redo writing 17,712 0.01 0.00 0 0  
reservation so alloc latch 10 0.00   0 0  
resmgr group change latch 698 0.00   0 0  
resmgr:active threads 5,828 0.00   0 0  
resmgr:actses change group 375 0.00   0 0  
resmgr:free threads list 5,827 0.09 0.00 0 0  
resmgr:resource group CPU method 372 0.27 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 1,320,813 0.02 0.00 0 3 0.00
rules engine aggregate statistics 2 0.00   0 0  
rules engine rule set statistics 104 0.00   0 0  
segmented array pool 30 0.00   0 0  
sequence cache 8,535 0.14 0.00 0 0  
session allocation 13,927 0.48 0.09 0 0  
session idle bit 53,089 0.00   0 0  
session state list latch 804 0.00   0 0  
session switching 13,962 0.00   0 0  
session timer 1,934 0.00   0 0  
shared pool 196,698 0.08 0.01 0 0  
shared pool sim alloc 14 0.00   0 0  
shared pool simulator 9,902 0.00   0 0  
simulator hash latch 913,604 0.00   0 0  
simulator lru latch 0     0 913,576 0.00
slave class 729 0.00   0 0  
slave class create 2,883 0.07 1.00 0 0  
sort extent pool 149 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
threshold alerts latch 1,199 0.00   0 0  
transaction allocation 180 0.00   0 0  
transaction branch allocation 2,003 0.00   0 0  
undo global data 38,431 0.00   0 0  
user lock 8,627 0.37 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 25,191,146 850 24 826 0 0 0
gcs resource hash 261,698 163 2 161 0 0 0
shared pool 196,698 163 1 162 0 0 0
session allocation 13,927 67 6 61 0 0 0
process allocation 42,692 48 41 7 0 0 0
object queue header operation 109,627 24 1 23 0 0 0
active service list 34,998 18 3 16 0 0 0
slave class create 2,883 2 2 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 10 10
active service list kswslogon: session login 0 1 0
active service list kswssyis: find service entry 1 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 157 125
cache buffers chains kcbrls: kslbegin 0 1 33
gcs resource hash kjbmpclose 0 1 1
gcs resource hash kjbopen:affinity 0 1 0
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 2 0
object queue header operation kcbo_switch_mq_bg 0 8 0
process allocation ksucrp 0 35 0
process allocation ksufap: active procs 0 5 13
process allocation ksudlp 0 1 3
session allocation ksuxds: KSUSFCLC not set 0 6 6
shared pool kghalo 0 1 0
slave class create ksvcreate 0 2 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 4,805,328 36.45
YTGPS WZT YTO_MID_ROAD_NUM   TABLE 2,767,968 20.99
YTGPS WZT YTO_JINGANG_STATION   TABLE 985,024 7.47
YTGPS WZT PK_YTO_AUDIT_VALUE   INDEX 942,896 7.15
YTGPS WZT YTO_AUDIT_RECORD   TABLE 881,728 6.69

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
YTGPS WZT T_LAST_LOCRECORD   TABLE 270 18.80
YTGPS WZT PK_YTO_AUDIT_DETAIL   INDEX 76 5.29
YTGPS WZT YTO_MID_ROAD_NUM_INDEX1   INDEX 44 3.06
YTGPS WZT YTO_JINGANG_USER   TABLE 29 2.02
YTGPS WZT PK_YTO_AUDIT_RECORD   INDEX 26 1.81

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 16 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 T_TERM_STATUS_LAST_RECORD   TABLE 16,720 70.01
YTGPS WZT TB_AZ012_W0228_RESULT   TABLE 4,307 18.03
YTGPS WZT T_LAST_LOCRECORD   TABLE 1,080 4.52
YTGPS WZT T_USER   TABLE 304 1.27
YTGPS WZT YTO_AUDIT_STATISTICS   TABLE 186 0.78

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
YTGPS WZT T_TERM_STATUS_LAST_RECORD   TABLE 360 35.47
YTGPS WZT T_USER   TABLE 76 7.49
YTGPS WZT YTO_AUDIT_STATISTICS   TABLE 63 6.21
YTGPS WZT YTO_AUDIT_DETAIL   TABLE 61 6.01
YTGPS WZT YTO_AUDIT_RECORD   TABLE 43 4.24

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 65 0.00 0   2 1
dc_database_links 2,985 0.00 0   0 1
dc_global_oids 211 0.00 0   0 118
dc_histogram_data 249,544 0.03 0   0 2,903
dc_histogram_defs 49,165 0.05 0   0 2,827
dc_object_ids 114,289 0.01 0   0 1,470
dc_objects 14,593 0.07 0   5 860
dc_profiles 292 0.00 0   0 1
dc_rollback_segments 10,246 0.00 0   0 472
dc_segments 47,908 0.01 0   0 1,389
dc_sequences 3 66.67 0   3 1
dc_tablespaces 49,649 0.00 0   0 50
dc_usernames 3,653 0.00 0   0 44
dc_users 63,189 0.00 0   0 75
outstanding_alerts 566 97.70 0   2 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 27 0 0
dc_object_ids 6 0 0
dc_objects 20 0 0
dc_segments 5 3 0
dc_sequences 6 2 0
outstanding_alerts 1,131 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,036 0.00 2,629 0.00 0 0
CLUSTER 5 0.00 5 0.00 0 0
SQL AREA 7,658 42.88 22,121 22.57 31 1
TABLE/PROCEDURE 286 1.40 34,542 0.06 10 0
TRIGGER 24 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 5 0 0 0 0
TABLE/PROCEDURE 9,163 18 0 11 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 345.78   4.80 4.63 16 16 72 72
  Freeable 42.25 0.00 1.51 1.58 6   28 28
  SQL 0.91 0.44 0.03 0.09 0 88 30 24
  PL/SQL 0.33 0.14 0.00 0.01 0 0 70 70
E Other 345.99   4.68 4.62 16 16 74 74
  Freeable 42.94 0.00 1.48 1.58 6   29 29
  SQL 0.45 0.08 0.01 0.02 0 88 33 26
  PL/SQL 0.29 0.12 0.00 0.01 0 0 72 72

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 164.46 165.92 0.89
shared PCursor 236.05 239.81 1.60
shared db_block_hash_buckets 90.00 90.00 0.00
shared free memory 3,239.87 3,196.08 -1.35
shared gcs resources 310.31 310.31 0.00
shared gcs shadows 166.03 166.03 0.00
shared library cache 220.10 222.56 1.11
shared sql area 2,469.91 2,505.75 1.45
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 112,983 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 2 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,559,297 434.34 1,487.88
acks for commit broadcast(logical) 1,561,137 434.86 1,489.63
broadcast msgs on commit(actual) 1,440 0.40 1.37
broadcast msgs on commit(logical) 1,483 0.41 1.42
broadcast msgs on commit(wasted) 48 0.01 0.05
broadcast on commit wait time(ms) 0 0.00 0.00
broadcast on commit waits 17 0.00 0.02
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 888 0.25 0.85
gcs ast xid 0 0.00 0.00
gcs blocked converts 763 0.21 0.73
gcs blocked cr converts 7,423 2.07 7.08
gcs compatible basts 4 0.00 0.00
gcs compatible cr basts (global) 177 0.05 0.17
gcs compatible cr basts (local) 581 0.16 0.55
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 97 0.03 0.09
gcs dbwr write request msgs 109 0.03 0.10
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 1,674 0.47 1.60
gcs immediate (null) converts 48,041 13.38 45.84
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 305 0.08 0.29
gcs indirect ast 50,026 13.93 47.73
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 193 0.05 0.18
gcs msgs process time(ms) 11,129 3.10 10.62
gcs msgs received 1,757,057 489.43 1,676.58
gcs out-of-order msgs 1 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 3,135 0.87 2.99
gcs side channel msgs logical 25,056 6.98 23.91
gcs stale cr 0 0.00 0.00
gcs undo cr 0 0.00 0.00
gcs write notification msgs 1 0.00 0.00
gcs writes refused 0 0.00 0.00
ges msgs process time(ms) 330 0.09 0.31
ges msgs received 21,695 6.04 20.70
global posts dropped 0 0.00 0.00
global posts queue time 0 0.00 0.00
global posts queued 2 0.00 0.00
global posts requested 2 0.00 0.00
global posts sent 2 0.00 0.00
implicit batch messages received 73,610 20.50 70.24
implicit batch messages sent 8,467 2.36 8.08
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 10,929 3.04 10.43
messages queue sent actual 38,219 10.65 36.47
messages queue sent logical 47,359 13.19 45.19
messages received actual 1,656,807 461.50 1,580.92
messages received logical 1,778,754 495.47 1,697.28
messages sent directly 4,485 1.25 4.28
messages sent indirectly 17,454 4.86 16.65
messages sent not implicit batched 29,752 8.29 28.39
messages sent pbatched 1,623,945 452.35 1,549.57
msgs causing lmd to send msgs 7,016 1.95 6.69
msgs causing lms(s) to send msgs 3,607 1.00 3.44
msgs received queue time (ms) 18,150 5.06 17.32
msgs received queued 1,778,748 495.47 1,697.28
msgs sent queue time (ms) 1,567 0.44 1.50
msgs sent queue time on ksxp (ms) 138,297 38.52 131.96
msgs sent queued 47,187 13.14 45.03
msgs sent queued on ksxp 1,597,821 445.07 1,524.64
number of ges deadlock detected 0 0.00 0.00
process batch messages received 10,732 2.99 10.24
process batch messages sent 1,575,140 438.76 1,503.00


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 1,348
CURRENT Block Requests 112
Data Block Requests 1,348
Undo Block Requests 0
TX Block Requests 38
Current Results 1,459
Private results 1
Zero Results 0
Disk Read Results 0
Fail Results 0
Fairness Down Converts 295
Fairness Clears 0
Free GC Elements 0
Flushes 12
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 1
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 2,023 100.00 0.00 0.00 0.00 0.00
Flushes 8 87.50 12.50 0.00 0.00 0.00
Writes 139 74.82 18.71 0.00 1.44 5.04


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 23,768 97.83 0.05 2.12 964 99.27 0.73 0.00
1 Others 99 100.00 0.00 0.00 42 100.00 0.00 0.00
1 undo header 14 92.86 7.14 0.00 5 100.00 0.00 0.00


Back to Top

End of Report