WORKLOAD REPOSITORY report for

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2103213-Mar-14 21:00:4672 .8
End Snap:2103313-Mar-14 22:00:2472 1.3
Elapsed:  59.63 (mins)  
DB Time:  6.92 (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: 1,100.62 4,485.12
Logical reads: 3,076.52 12,537.10
Block changes: 4.63 18.88
Physical reads: 3.98 16.21
Physical writes: 0.38 1.54
User calls: 6.67 27.18
Parses: 4.02 16.38
Hard parses: 0.48 1.95
Sorts: 2.47 10.07
Logons: 0.71 2.90
Executes: 5.65 23.04
Transactions: 0.25 

% Blocks changed per Read: 0.15Recursive Call %: 84.75
Rollback per transaction %: 26.65Rows per Sort: 82.17

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.88In-memory Sort %: 100.00
Library Hit %: 92.14Soft Parse %: 88.07
Execute to Parse %: 28.92Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 99.29% Non-Parse CPU: 96.47

Shared Pool Statistics

BeginEnd
Memory Usage %: 60.62 58.67
% SQL with executions>1: 70.79 94.79
% Memory for SQL w/exec>1: 70.69 94.49

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  474  114.3 
control file parallel write 1,348 60 45 14.5System I/O
db file sequential read 2,659 5 2 1.2User I/O
gc cr multi block request 25,176 4 0 1.0Cluster
control file sequential read 12,145 4 0 .9System I/O

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 9.60 39.13
Global Cache blocks served: 0.40 1.61
GCS/GES messages received: 479.97 1,955.93
GCS/GES messages sent: 470.76 1,918.37
DBWR Fusion writes: 0.02 0.09
Estd Interconnect traffic (KB) 265.68 

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

Buffer access - local cache %: 99.57
Buffer access - remote cache %: 0.31
Buffer access - disk %: 0.12

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1
Avg global cache cr block receive time (ms): 0.9
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.1
Global cache log flushes for cr blocks served %: 0.9
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.6
Avg global cache current block flush time (ms): 0.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.1
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 16.76
% of indirect sent messages: 47.38
% of flow controlled messages: 35.86


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 474.47 114.33
sql execute elapsed time 385.19 92.81
parse time elapsed 19.90 4.79
hard parse elapsed time 18.61 4.49
connection management call elapsed time 2.78 0.67
PL/SQL execution elapsed time 0.98 0.24
PL/SQL compilation elapsed time 0.12 0.03
hard parse (sharing criteria) elapsed time 0.06 0.01
repeated bind elapsed time 0.00 0.00
DB time 415.00  
background cpu time 192.11  
background elapsed time 191.22  

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     474   114.33
System I/O 15,848   65 4 15.63
User I/O 6,009   9 2 2.27
Cluster 30,446   5 0 1.28
Other 54,615 79 3 0 0.61
Concurrency 3,302   2 0 0.39
Application 149   0 0 0.01
Network 20,656   0 0 0.01
Commit 73   0 0 0.00
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
control file parallel write 1,348   60 45 1.54
db file sequential read 2,659   5 2 3.03
gc cr multi block request 25,176   4 0 28.67
control file sequential read 12,145   4 0 13.83
db file scattered read 1,814   3 2 2.07
db file parallel read 184   1 5 0.21
row cache lock 2,994   1 0 3.41
reliable message 244   1 3 0.28
gc cr block 2-way 3,489   1 0 3.97
os thread startup 25   1 28 0.03
log file parallel write 1,451   1 0 1.65
latch free 32   0 11 0.04
rdbms ipc reply 4,541   0 0 5.17
db file parallel write 846   0 0 0.96
direct path read 1,052   0 0 1.20
DFS lock handle 1,428   0 0 1.63
CGS wait for IPC msg 30,437 99 0 0 34.67
gc cr grant 2-way 1,044   0 0 1.19
ksxr poll remote instances 13,048 71 0 0 14.86
enq: CF - contention 511   0 0 0.58
log file sequential read 22   0 4 0.03
gc current grant busy 113   0 1 0.13
gc current block 2-way 292   0 0 0.33
library cache lock 200   0 0 0.23
enq: PS - contention 173   0 0 0.20
PX Deq: reap credit 3,648 92 0 0 4.15
gc current grant 2-way 255   0 0 0.29
enq: TM - contention 148   0 0 0.17
gc current block busy 5   0 7 0.01
direct path write 290   0 0 0.33
enq: TT - contention 145   0 0 0.17
log file sync 73   0 0 0.08
SQL*Net message to client 19,296   0 0 21.98
gc current multi block request 68   0 0 0.08
CSS operation: query 6   0 2 0.01
SQL*Net more data from client 1,360   0 0 1.55
library cache pin 65   0 0 0.07
PX Deq: Signal ACK 122 21 0 0 0.14
PX Deq Credit: send blkd 152 80 0 0 0.17
enq: TX - index contention 1   0 7 0.00
gc current split 1   0 7 0.00
gcs log flush sync 18   0 0 0.02
IPC send completion sync 33 100 0 0 0.04
enq: JQ - contention 16   0 0 0.02
Log archive I/O 28   0 0 0.03
enq: WF - contention 10   0 0 0.01
enq: TA - contention 12   0 0 0.01
latch: shared pool 8   0 0 0.01
log file single write 8   0 0 0.01
enq: JS - queue lock 1   0 2 0.00
CSS initialization 2   0 1 0.00
CSS operation: action 6   0 0 0.01
gc buffer busy 2   0 0 0.00
enq: WL - contention 2   0 0 0.00
enq: MW - contention 2   0 0 0.00
gc cr disk read 1   0 0 0.00
utl_file I/O 10   0 0 0.01
enq: JS - job run lock - synchronize 3   0 0 0.00
latch: ges resource hash list 7   0 0 0.01
buffer busy waits 2   0 0 0.00
enq: AF - task serialization 1   0 0 0.00
latch: session allocation 6   0 0 0.01
enq: UL - contention 1   0 0 0.00
latch: cache buffers chains 7   0 0 0.01
enq: HW - contention 1   0 0 0.00
latch: gcs resource hash 3   0 0 0.00
KJC: Wait for msg sends to complete 2   0 0 0.00
LGWR wait for redo copy 4   0 0 0.00
SQL*Net message from client 21,668   55,860 2578 24.68
gcs remote message 2,766,020 41 55,816 20 3,150.36
class slave wait 1,328 85 6,912 5205 1.51
jobq slave wait 1,318 80 3,598 2730 1.50
ASM background timer 1,544   3,495 2264 1.76
DIAG idle wait 17,887   3,494 195 20.37
PX Idle Wait 1,471 93 3,494 2375 1.68
ges remote message 79,144 54 3,492 44 90.14
Streams AQ: qmn slave idle wait 126   3,464 27489 0.14
Streams AQ: qmn coordinator idle wait 253 50 3,464 13690 0.29
virtual circuit status 119 100 3,463 29099 0.14
Streams AQ: waiting for time management or cleanup tasks 1 100 339 339284 0.00
KSV master wait 191   15 77 0.22
PX Deq: Execution Msg 356 6 0 1 0.41
PX Deq: Join ACK 228 34 0 0 0.26
PX Deq: Parse Reply 205 38 0 0 0.23
PX Deq: Execute Reply 178 35 0 0 0.20
PX Deq: Msg Fragment 135 1 0 0 0.15
Streams AQ: RAC qmn coordinator idle wait 253 100 0 0 0.29

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write 1,348   60 45 1.54
control file sequential read 11,480   3 0 13.08
events in waitclass Other 45,548 86 1 0 51.88
os thread startup 25   1 28 0.03
log file parallel write 1,451   1 0 1.65
db file parallel write 846   0 0 0.96
direct path read 1,052   0 0 1.20
log file sequential read 22   0 4 0.03
enq: TM - contention 122   0 0 0.14
direct path write 277   0 0 0.32
row cache lock 77   0 0 0.09
gc cr block 2-way 65   0 0 0.07
gc current block 2-way 53   0 0 0.06
db file scattered read 2   0 6 0.00
library cache lock 34   0 0 0.04
gc cr multi block request 26   0 0 0.03
Log archive I/O 28   0 0 0.03
log file single write 8   0 0 0.01
gc current grant busy 6   0 0 0.01
library cache pin 2   0 0 0.00
buffer busy waits 2   0 0 0.00
gc current multi block request 4   0 0 0.00
latch: cache buffers chains 1   0 0 0.00
rdbms ipc message 86,621 61 73,024 843 98.66
gcs remote message 2,766,060 41 55,816 20 3,150.41
class slave wait 1,320 86 6,912 5236 1.50
ASM background timer 1,544   3,495 2264 1.76
DIAG idle wait 17,886   3,494 195 20.37
ges remote message 79,146 54 3,492 44 90.14
pmon timer 1,877 100 3,491 1860 2.14
Streams AQ: qmn slave idle wait 126   3,464 27489 0.14
Streams AQ: qmn coordinator idle wait 253 50 3,464 13690 0.29
smon timer 17   3,363 197815 0.02
Streams AQ: waiting for time management or cleanup tasks 1 100 339 339284 0.00
KSV master wait 191   15 77 0.22
Streams AQ: RAC qmn coordinator idle wait 253 100 0 0 0.29

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 103,585
IDLE_TIME 22,794,864
IOWAIT_TIME 7,453
NICE_TIME 41
SYS_TIME 33,934
USER_TIME 65,192
LOAD 1
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 322,434,048
VM_OUT_BYTES 432,909,312
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 390.70 460.00 176 10,813,006
SYS$USERS 24.40 14.50 12,944 158,264
SYS$BACKGROUND 0.00 0.00 1,107 36,727
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 154 0 101 0 0 0 15325 0
SYS$USERS 4319 9 2455 1 0 0 142 0
SYS$BACKGROUND 1540 1 745 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
21 11 0   5.15 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
13 13 62 0.21 3.14 fw268s02gfmpb JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
10 3 1 9.67 2.33 a8u21vgds1tkf DBMS_SCHEDULER select substrb(dump(val, 16, 0...
9 9 73 0.12 2.06 bk575wxmq6nkc JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
5 4 1 4.64 1.12 d2vhun1bqg4dg DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
5 2 1 4.59 1.11 5qkwd1quhpn9z DBMS_SCHEDULER select /*+ no_parallel(t) no_...
4 4 15 0.26 0.93 3wmz23p8fsvvn JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
2 2 1 2.44 0.59 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
2 2 10 0.23 0.55 53w19918z0xyv JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
2 2 3 0.72 0.52 43uvh6zzd4559   SELECT vst.sql_id, vst.sql_fu...

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
13 13 62 0.21 2.81 3.14 fw268s02gfmpb JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
11 21 0   2.26 5.15 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
9 9 73 0.12 1.84 2.06 bk575wxmq6nkc JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
4 5 1 4.15 0.87 1.12 d2vhun1bqg4dg DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
4 4 15 0.26 0.84 0.93 3wmz23p8fsvvn JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
3 10 1 2.84 0.60 2.33 a8u21vgds1tkf DBMS_SCHEDULER select substrb(dump(val, 16, 0...
2 2 1 2.40 0.50 0.59 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
2 2 10 0.23 0.49 0.55 53w19918z0xyv JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
2 2 3 0.73 0.46 0.52 43uvh6zzd4559   SELECT vst.sql_id, vst.sql_fu...
2 5 1 1.99 0.42 1.11 5qkwd1quhpn9z DBMS_SCHEDULER select /*+ no_parallel(t) no_...

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
439,022 62 7,081.00 3.99 13.32 13.01 fw268s02gfmpb JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
268,421 73 3,677.00 2.44 8.75 8.55 bk575wxmq6nkc JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
171,590 10 17,159.00 1.56 1.89 1.85 68ddx7zxvxubr JDBC Thin Client select count(*) from (select d...
156,213 9 17,357.00 1.42 1.08 1.06 frr9vmmcsadhb JDBC Thin Client select * from ( select distinc...
125,800 0   1.14 10.71 21.36 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
115,680 15 7,712.00 1.05 3.96 3.87 3wmz23p8fsvvn JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
80,256 22 3,648.00 0.73 1.68 1.64 du5yw0cqjr4hj JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
75,670 10 7,567.00 0.69 2.34 2.28 53w19918z0xyv JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
73,500 20 3,675.00 0.67 1.77 1.72 9qkxr4qhujs7s JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...
47,424 13 3,648.00 0.43 1.95 1.90 bvkpprhsjx5j3 JDBC Thin Client SELECT DISTINCT D.NAME, TRIM(S...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
12,931 0   90.86 10.71 21.36 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
12,225 1 12,225.00 85.90 2.84 9.67 a8u21vgds1tkf DBMS_SCHEDULER select substrb(dump(val, 16, 0...
608 1 608.00 4.27 1.99 4.59 5qkwd1quhpn9z DBMS_SCHEDULER select /*+ no_parallel(t) no_...
130 130 1.00 0.91 1.27 2.06 42pgj3syb4tcn JDBC Thin Client select m1.device_id, m1.latitu...
34 1 34.00 0.24 0.42 0.75 4p7v0nxa2awyv DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
15 1 15.00 0.11 2.40 2.44 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
10 1 10.00 0.07 0.04 0.05 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
10 1 10.00 0.07 4.15 4.64 d2vhun1bqg4dg DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
6 1 6.00 0.04 0.32 0.37 1b28hzmjun5t0 DBMS_SCHEDULER MERGE INTO SYS.MON_MODS_ALL$ M...
0 44 0.00 0.00 0.01 0.01 04xtrk7uyhknh   select obj#, type#, ctime, mti...

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
2,139 2,139 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
776 1,812 2.34 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
553 0 0.00 0.00 0.00 c4nhd1ntptxq7 MMON_SLAVE select message_level, sequence...
313 313 1.00 0.00 0.00 18naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
295 776 2.63 0.00 0.00 0k8522rmdzg4k   select privilege# from sysauth...
284 0 0.00 0.00 0.00 az33m61ym46y4   SELECT NULL AS table_cat, o.ow...
282 282 1.00 0.00 0.00 6xvp6nxs4a9n4   select nvl(sum(space), 0) from...
282 0 0.00 0.00 0.00 csnp95dz2r8ss   select file#, block# from recy...
264 264 1.00 0.00 0.00 5kyb5bvnu3s04 SEVERITY EVALUATION SELECT DISTINCT METRIC_GUID FR...
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...
224 223 1.00 0.00 0.00 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
224 224 1.00 0.00 0.00 459f3z9u4fb3u   select value$ from props$ wher...
224 224 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
2,139 2,139 14.88 2ym6hhaq30r73   select type#, blocks, extents,...
776 776 5.40 0h6b2sajwb74n   select privilege#, level from ...
553 553 3.85 c4nhd1ntptxq7 MMON_SLAVE select message_level, sequence...
295 295 2.05 0k8522rmdzg4k   select privilege# from sysauth...
285 284 1.98 az33m61ym46y4   SELECT NULL AS table_cat, o.ow...
282 282 1.96 6xvp6nxs4a9n4   select nvl(sum(space), 0) from...
282 282 1.96 csnp95dz2r8ss   select file#, block# from recy...
224 224 1.56 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
224 224 1.56 459f3z9u4fb3u   select value$ from props$ wher...
224 224 1.56 5ur69atw3vfhj   select decode(failover_method,...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,475,659 1 0.03 d2vhun1bqg4dg DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...

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
3.67 17.17 21.36 10.71 0 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
2.16 22.31 9.67 2.84 1 a8u21vgds1tkf DBMS_SCHEDULER select substrb(dump(val, 16, 0...
1.15 25.01 4.59 1.99 1 5qkwd1quhpn9z DBMS_SCHEDULER select /*+ no_parallel(t) no_...
1.13 54.85 2.06 1.27 130 42pgj3syb4tcn JDBC Thin Client select m1.device_id, m1.latitu...
0.13 17.58 0.75 0.42 1 4p7v0nxa2awyv DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
0.07 2.86 2.44 2.40 1 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
0.04 0.85 4.64 4.15 1 d2vhun1bqg4dg DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
0.01 0.36 1.85 1.89 10 68ddx7zxvxubr JDBC Thin Client select count(*) from (select d...
0.01 3.25 0.17 0.18 2,139 2ym6hhaq30r73   select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
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))
1b28hzmjun5t0MERGE INTO SYS.MON_MODS_ALL$ MM USING ( SELECT /*+ ordered */ DISTINCT TAB.OBJ# FROM (SELECT T.OBJ# OBJ#, T.OBJ# BO#, T.ANALYZETIME FROM SYS.TAB$ T WHERE BITAND(T.FLAGS, 16) = 16 UNION ALL SELECT T.OBJ# OBJ#, T.BO# BO#, T.ANALYZETIME FROM SYS.TABPART$ T WHERE BITAND(T.FLAGS, 2) = 2 UNION ALL SELECT T.OBJ# OBJ#, T.BO# BO#, T.ANALYZETIME FROM SYS.TABCOMPART$ T WHERE BITAND(T.FLAGS, 2) = 2 UNION ALL SELECT T.OBJ# OBJ#, TCP.BO# BO#, T.ANALYZETIME FROM SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP WHERE BITAND(T.FLAGS, 2) = 2 AND T.POBJ# = TCP.OBJ# ) TAB, OBJ$ O, SYS.COL$ C WHERE TAB.BO# = O.OBJ# AND TAB.ANALYZETIME < O.MTIME AND C.OBJ# = TAB.BO# AND C.TYPE# IN ( 1, 2, 12, 23, 69, 96, 100, 101, 178, 179, 180, 181, 182, 183, 231) AND BITAND(C.PROPERTY, 16384+32768) = 0 AND NOT (BITAND(C.PROPERTY, 32+65536+131072) = 32+65536 AND C.DEFAULT$ IS NULL ) AND NOT EXISTS (SELECT /*+ unnest */ NULL FROM HIST_HEAD$ HH WHERE HH.OBJ# = TAB.OBJ# AND HH.INTCOL# = C.INTCOL#) ) MCS ON (MM.OBJ# = MCS.OBJ#) WHEN MATCHED THEN UPDATE SET FLAGS = FLAGS + 4 WHERE BITAND(FLAGS, 4) = 0 WHEN NOT MATCHED THEN INSERT (OBJ#, INSERTS, UPDATES, DELETES, TIMESTAMP, FLAGS, DROP_SEGMENTS) VALUES(MCS.OBJ#, 0, 0, 0, :B1 , 4, 0)
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
3wmz23p8fsvvn SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = 'Îâ½­ÊÐ' /*OR B.ALIAS1='Îâ½­ÊÐ' OR B.ALIAS2='Îâ½­ÊÐ' OR B.ALIAS3='Îâ½­ÊÐ'*/ OR B.NAME like'%½­ËÕÊ¡%' /* OR B.ALIAS1='½­ËÕÊ¡' OR B.ALIAS2='½­ËÕÊ¡' OR B.ALIAS3='½­ËÕÊ¡'*/ OR B.NAME ='Îâ' /* OR B.ALIAS1='Îâ' OR B.ALIAS2='Îâ' OR B.ALIAS3='Îâ'*/ OR B.NAME like'%½­É½%' /* OR B.ALIAS1='½­É½' OR B.ALIAS2='½­É½' OR B.ALIAS3='½­É½'*/ OR B.NAME ='ºþ' /*OR B.ALIAS1='ºþ' OR B.ALIAS2='ºþ' OR B.ALIAS3='ºþ'*/ OR B.NAME like'%»¨Ô°%' /* OR B.ALIAS1='»¨Ô°' OR B.ALIAS2='»¨Ô°' OR B.ALIAS3='»¨Ô°'*/ OR B.NAME like'%3Çø%' /* OR B.ALIAS1='3Çø' OR B.ALIAS2='3Çø' OR B.ALIAS3='3Çø'*/ OR B.NAME like'%60%' /* OR B.ALIAS1='60' OR B.ALIAS2='60' OR B.ALIAS3='60'*/ OR B.NAME like'%ºÅ%' /* OR B.ALIAS1='ºÅ' OR B.ALIAS2='ºÅ' OR B.ALIAS3='ºÅ'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='Îâ½­ÊÐ' OR B.NAME like'%½­ËÕÊ¡%' /* OR B.ALIAS1='½­ËÕÊ¡' OR B.ALIAS2='½­ËÕ Ê¡' OR B.ALIAS3='½­ËÕÊ¡'*/ OR B.NAME ='Îâ' /* OR B.ALIAS1='Îâ' OR B.ALIAS2= 'Îâ' OR B.ALIAS3='Îâ'*/ OR B.NAME like'%½­É½%' /* OR B.ALIAS1='½­É½' OR B.ALIAS2='½­É½' OR B.ALIAS3='½­É½'*/ OR B.NAME ='ºþ' /*OR B.ALIAS1='ºþ' OR B.ALIAS2='ºþ' OR B.ALIAS3='ºþ'*/ OR B.NAME like'%»¨Ô°%' /* OR B.ALIAS1='»¨Ô°' OR B.ALIAS2='»¨Ô°' OR B.ALIAS3='»¨Ô°'*/ OR B.NAME like'%3Çø%' /* OR B.ALIAS1='3Çø' OR B.ALIAS2='3Çø' OR B.ALIAS3='3Çø'*/ OR B.NAME like'%60%' /* OR B.ALIAS1='60' OR B.ALIAS2='60' OR B.ALIAS3='60'*/ OR B.NAME like'%ºÅ%' /* OR B.ALIAS1='ºÅ' OR B.ALIAS2='ºÅ' OR B.ALIAS3='ºÅ'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ')
42pgj3syb4tcn 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 ('13721878691')) 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 = y 32.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(+)
43uvh6zzd4559 SELECT vst.sql_id, vst.sql_fulltext FROM V$SQLSTATS vst WHERE vst.sql_id IN (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10) AND vst.plan_hash_value = :phv
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
4p7v0nxa2awyv select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), sum(sys_op_opnsize("ID")), substrb(dump(min(substrb("ID", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ID", 1, 32)), 16, 0, 32), 1, 120), count("DEVICE_ID"), sum(sys_op_opnsize("DEVICE_ID")), count("LATITUDE"), count(distinct "LATITUDE"), sum(sys_op_opnsize("LATITUDE")), substrb(dump(min("LATITUDE"), 16, 0, 32), 1, 120), substrb(dump(max("LATITUDE"), 16, 0, 32), 1, 120), count("LONGITUDE"), count(distinct "LONGITUDE"), sum(sys_op_opnsize("LONGITUDE")), substrb(dump(min("LONGITUDE"), 16, 0, 32), 1, 120), substrb(dump(max("LONGITUDE"), 16, 0, 32), 1, 120), count("JMX"), count(distinct "JMX"), sum(sys_op_opnsize("JMX")), substrb(dump(min("JMX"), 16, 0, 32), 1, 120), substrb(dump(max("JMX"), 16, 0, 32), 1, 120), count("JMY"), count(distinct "JMY"), sum(sys_op_opnsize("JMY")), substrb(dump(min("JMY"), 16, 0, 32), 1, 120), substrb(dump(max("JMY"), 16, 0, 32), 1, 120), count("SPEED"), count(distinct "SPEED"), sum(sys_op_opnsize("SPEED")), substrb(dump(min("SPEED"), 16, 0, 32), 1, 120), substrb(dump(max("SPEED"), 16, 0, 32), 1, 120), co unt("DIRECTION"), count(distinct "DIRECTION"), sum(sys_op_opnsize("DIRECTION")), substrb(dump(min("DIRECTION"), 16, 0, 32), 1, 120), substrb(dump(max("DIRECTION"), 16, 0, 32), 1, 120), count("HEIGHT"), count(distinct "HEIGHT"), sum(sys_op_opnsize("HEIGHT")), substrb(dump(min("HEIGHT"), 16, 0, 32), 1, 120), substrb(dump(max("HEIGHT"), 16, 0, 32), 1, 120), count("DISTANCE"), count(distinct "DISTANCE"), sum(sys_op_opnsize("DISTANCE")), substrb(dump(min("DISTANCE"), 16, 0, 32), 1, 120), substrb(dump(max("DISTANCE"), 16, 0, 32), 1, 120), count("STATLLITE_NUM"), count(distinct "STATLLITE_NUM"), sum(sys_op_opnsize("STATLLITE_NUM")), substrb(dump(min("STATLLITE_NUM"), 16, 0, 32), 1, 120), substrb(dump(max("STATLLITE_NUM"), 16, 0, 32), 1, 120), count("GPSTIME"), count("INPUTDATE"), count(distinct "INPUTDATE"), substrb(dump(min("INPUTDATE"), 16, 0, 32), 1, 120), substrb(dump(max("INPUTDATE"), 16, 0, 32), 1, 120), count("LOCATE_TYPE"), count(distinct "LOCATE_TYPE"), sum(sys_op_opnsize("LOCATE_TYPE")), substrb(dump(min("LOCATE_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("LOCATE_TYPE"), 16, 0, 32), 1, 120), count("COORD_TYPE"), count(distinct "COORD_TYPE"), sum(sys_op_opns ize("COORD_TYPE")), substrb(dump(min("COORD_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("COORD_TYPE"), 16, 0, 32), 1, 120), count("STATE"), count(distinct "STATE"), sum(sys_op_opnsize("STATE")), substrb(dump(min("STATE"), 16, 0, 32), 1, 120), substrb(dump(max("STATE"), 16, 0, 32), 1, 120), count("POS_DESC"), count(distinct "POS_DESC"), sum(sys_op_opnsize("POS_DESC")), substrb(dump(min(substrb("POS_DESC", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("POS_DESC", 1, 32)), 16, 0, 32), 1, 120), count("OBJ_ID"), count(distinct "OBJ_ID"), sum(sys_op_opnsize("OBJ_ID")), substrb(dump(min(substrb("OBJ_ID", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("OBJ_ID", 1, 32)), 16, 0, 32), 1, 120), count("OBJ_TYPE"), count(distinct "OBJ_TYPE"), sum(sys_op_opnsize("OBJ_TYPE")), substrb(dump(min("OBJ_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("OBJ_TYPE"), 16, 0, 32), 1, 120), count("SENDED"), count("DEVICE_MANTISSA"), sum(sys_op_opnsize("DEVICE_MANTISSA")) from "YTGPS"."GPS_LOCRECORD_SHOW" t
53w19918z0xyv SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = 'ÎâÖÐÇø' /*OR B.ALIAS1='ÎâÖÐÇø' OR B.ALIAS2='ÎâÖÐÇø' OR B.ALIAS3='ÎâÖÐÇø'*/ OR B.NAME like'%ËÕÖÝ%' /* OR B.ALIAS1='ËÕÖÝ' OR B.ALIAS2='ËÕÖÝ' OR B.ALIAS3='ËÕÖÝ'*/ OR B.NAME like'%¹¤ÒµÔ°Çø%' /* OR B.ALIAS1='¹¤ÒµÔ°Çø' OR B.ALIAS2='¹¤ÒµÔ°Çø' OR B.ALIAS3='¹¤ÒµÔ°Çø'*/ OR B.NAME like'%¸ß¶û·ò»¨Ô°%' /* OR B.ALIAS1='¸ß¶û·ò»¨Ô°' OR B.ALIAS2='¸ß¶û·ò»¨Ô°' OR B.ALIAS3='¸ß¶û·ò»¨Ô°'*/ OR B.NAME like'%28%' /* OR B.ALIAS1='28' OR B.ALIAS2='28' OR B.ALIAS3='28'*/ OR B.NAME ='´±' /*OR B.ALIAS1='´±' OR B.ALIAS2='´±' OR B.ALIAS3='´±'*/ OR B.NAME like'%1305%' /* OR B.ALIAS1='1305' OR B.ALIAS2='1305' OR B.ALIAS3='1305'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='ÎâÖÐÇø' OR B.NAME like'%ËÕÖÝ%' /* OR B.ALIAS1='ËÕÖÝ' OR B.ALIAS2='ËÕÖÝ' OR B.ALIAS3='ËÕÖÝ'*/ OR B.NAME like'%¹¤ÒµÔ°Çø%' /* OR B.ALIAS1='¹¤ÒµÔ°Çø' OR B.ALIAS2='¹¤ÒµÔ°Çø' OR B.ALIAS3='¹¤Òµ Ô°Çø'*/ OR B.NAME like'%¸ß¶û·ò»¨Ô°%' /* OR B.ALIAS1='¸ß¶û·ò»¨Ô°' OR B.ALIAS2='¸ß¶û·ò»¨Ô°' OR B.ALIAS3='¸ß¶û ·ò»¨Ô°'*/ OR B.NAME like'%28%' /* OR B.ALIAS1='28' OR B.ALIAS2='28' OR B.ALIAS3='28'*/ OR B.NAME ='´±' /*OR B.ALIAS1='´±' OR B.ALIAS2='´±' OR B.ALIAS3='´±'*/ OR B.NAME like'%1305%' /* OR B.ALIAS1='1305' OR B.ALIAS2='1305' OR B.ALIAS3='1305'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ')
5kyb5bvnu3s04SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
5qkwd1quhpn9z select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*) from "YTGPS"."GPS_LOCRECORD_SHOW" t
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 ))
6xvp6nxs4a9n4select nvl(sum(space), 0) from recyclebin$ where ts# = :1
9qkxr4qhujs7sSELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = '²×ÀËÇø' /*OR B.ALIAS1='²×ÀËÇø' OR B.ALIAS2='²×ÀËÇø' OR B.ALIAS3='²×ÀËÇø'*/ OR B.NAME like'%ËÕÖÝÊÐ%' /* OR B.ALIAS1='ËÕÖÝÊÐ' OR B.ALIAS2='ËÕÖÝÊÐ' OR B.ALIAS3='ËÕÖÝÊÐ'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='²×ÀËÇø' OR B.NAME like'%ËÕÖÝÊÐ%' /* OR B.ALIAS1='ËÕÖÝÊÐ' OR B.ALIAS2='ËÕÖÝÊÐ' OR B.ALIAS3='ËÕÖÝÊÐ'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ')
a8u21vgds1tkfselect substrb(dump(val, 16, 0, 32), 1, 120) ep, cnt from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"GPSTIME" val, count(*) cnt from "YTGPS"."GPS_LOCRECORD_SHOW" t where "GPSTIME" is not null group by "GPSTIME") order by val
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
b6usrg82hwsa3call dbms_stats.gather_database_stats_job_proc ( )
bk575wxmq6nkc SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = 'Îâ½­ÊÐ' /*OR B.ALIAS1='Îâ½­ÊÐ' OR B.ALIAS2='Îâ½­ÊÐ' OR B.ALIAS3='Îâ½­ÊÐ'*/ OR B.NAME ='ÍÍ' /* OR B.ALIAS1='ÍÍ' OR B.ALIAS2='ÍÍ' OR B.ALIAS3='ÍÍ'*/ OR B.NAME ='´å' /* OR B.ALIAS1='´å' OR B.ALIAS2='´å' OR B.ALIAS3='´å'*/ OR B.NAME like'%ÉçÇø%' /* OR B.ALIAS1='ÉçÇø' OR B.ALIAS2='ÉçÇø' OR B.ALIAS3='ÉçÇø'*/ OR B.NAME ='Çñ' /*OR B.ALIAS1='Çñ' OR B.ALIAS2='Çñ' OR B.ALIAS3='Çñ'*/ OR B.NAME ='Éá' /*OR B.ALIAS1='Éá' OR B.ALIAS2='Éá' OR B.ALIAS3='Éá'*/ OR B.NAME like'%¿ª·¢Çø%' /* OR B.ALIAS1='¿ª·¢Çø' OR B.ALIAS2='¿ª·¢Çø' OR B.ALIAS3='¿ª·¢Çø'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='Îâ½­ÊÐ' OR B.NAME ='ÍÍ' /* OR B.ALIAS1='ÍÍ' OR B.ALIAS2='ÍÍ' OR B.ALIAS3='ÍÍ'*/ OR B.NAME ='´å' /* OR B.ALIAS1='´å' OR B.ALIAS2='´å' OR B.ALIAS3='´å'*/ OR B.NAME like'%ÉçÇø%' /* OR B.ALIAS1='ÉçÇø' OR B.ALIAS2='ÉçÇø' OR B.ALIAS3='ÉçÇø'*/ OR B.NAME ='Çñ' /*OR B.ALIAS1='Çñ' OR B.ALIAS2='Çñ' OR B.ALIAS3='Çñ'*/ OR B.NAME ='Éá' /*O R B.ALIAS1='Éá' OR B.ALIAS2='Éá' OR B.ALIAS3='Éá'*/ OR B.NAME like'%¿ª·¢Çø%' /* OR B.ALIAS1='¿ª·¢Çø' OR B.ALIAS2='¿ª·¢Çø' OR B.ALIAS3='¿ª·¢Çø'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ')
bvkpprhsjx5j3 SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = 'Ì«²ÖÊÐ' /*OR B.ALIAS1='Ì«²ÖÊÐ' OR B.ALIAS2='Ì«²ÖÊÐ' OR B.ALIAS3='Ì«²ÖÊÐ'*/ OR B.NAME like'%Ì«²ÖÊÐ%' /* OR B.ALIAS1='Ì«²ÖÊÐ' OR B.ALIAS2='Ì«²ÖÊÐ' OR B.ALIAS3='Ì«²ÖÊÐ'*/ OR B.NAME like'%ɳϪÕò%' /* OR B.ALIAS1='ɳϪÕò' OR B.ALIAS2='ɳϪÕò' OR B.ALIAS3='ɳϪÕò'*/ OR B.NAME ='Áõ' /*OR B.ALIAS1='Áõ' OR B.ALIAS2='Áõ' OR B.ALIAS3='Áõ'*/ OR B.NAME ='Ì©' /*OR B.ALIAS1='Ì©' OR B.ALIAS2='Ì©' OR B.ALIAS3='Ì©'*/ OR B.NAME like'%´ú¹º%' /* OR B.ALIAS1='´ú¹º' OR B.ALIAS2='´ú¹º' OR B.ALIAS3='´ú¹º'*/ OR B.NAME ='²¿' /*OR B.ALIAS1='²¿' OR B.ALIAS2='²¿' OR B.ALIAS3='²¿'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='Ì«²ÖÊÐ' OR B.NAME like'%Ì«²ÖÊÐ%' /* OR B.ALIAS1='Ì«²ÖÊÐ' OR B.ALIAS2='Ì«²ÖÊÐ' OR B.ALIAS3='Ì«²ÖÊÐ'*/ OR B.NAME like'%ɳϪÕò%' /* OR B.ALIAS1='ɳϪÕò' OR B.ALIAS2='ɳϪÕò' OR B.ALIAS3='ɳϪÕò'*/ OR B.NAME ='Áõ' /*OR B.ALIAS1='Áõ' OR B.ALIAS2='Áõ' OR B.ALIAS3='Áõ'*/ OR B.NAME ='Ì©' /*OR B.ALIAS1='Ì©' OR B.ALIAS2='Ì©' OR B.ALI AS3='Ì©'*/ OR B.NAME like'%´ú¹º%' /* OR B.ALIAS1='´ú¹º' OR B.ALIAS2='´ú¹º' OR B.ALIAS3='´ú¹º'*/ OR B.NAME ='²¿' /*OR B.ALIAS1='²¿' OR B.ALIAS2='²¿' OR B.ALIAS3='²¿'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ')
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
csnp95dz2r8ssselect file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
d2vhun1bqg4dg MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN STALENESS > .5 THEN 128 ELSE 0 END + AFLAGS AFLAGS, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN T.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, NULL, NULL) WHEN S.TYPE# = 5 THEN DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) ELSE NULL END * NVL(TS.BLOCKSIZE, :B4 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, NULL BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M WHERE :B1 IS NOT NULL AND O.TYPE# = 2 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE#(+) AND T.BLOCK# = S.BLOCK#(+) AND T.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.PROPERTY, 64+512) = 0 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(O .FLAGS, 128) != 128 AND BITAND(T.PROPERTY, 2147483648) = 0 AND (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608) AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME = 'SUMDELTA$') AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABPART$ T, SYS.TAB$ TAB, SYS. OBJ$ OT, SYS.MON_MODS_ALL$ M WHERE O.TYPE# = 19 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(TAB.PROPERTY, 512) != 512 AND BITAND(TAB.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 2) != 2)) UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, O.SUBNAME, NULL) * :B4 OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO# FROM SYS.OBJ$ O, SYS.USER$ U, SYS.TABCOMPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M WHERE O.TYPE# = 19 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AN D BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 2) != 2)) ) WHERE :B5 IS NOT NULL UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 64 ELSE 0 END + CASE WHEN ROW_NUMBER() OVER (PARTITION BY (SELECT TCP0.BO# FROM TABCOMPART$ TCP0 WHERE TCP0.OBJ#=ST0.BO#) ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, PART#, BO# FROM (SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.SUBPART# PART#, T.POBJ# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.PARTOBJ$ PO WHERE O.TYPE# = 3 4 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND TCP.OBJ# = T.POBJ# AND TCP.BO# = TAB.OBJ# AND PO.OBJ# = TAB.OBJ# AND ((:B7 IS NOT NULL AND BITAND(PO.SPARE2, 255) = 2) OR (:B6 IS NOT NULL AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND BITAND(TCP.FLAGS, 32) != 32 AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 2) != 2))) ST0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(I.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(CM.TRUNC, 1, GREATEST(CM.ROWCNT, CM.INSERTS), CM.TOT_MODS/(CM.ROWCNT + 0.01))))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, I.BO# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.IND$ I, (SELECT BOBJ#, SUM(BITAND(T.TRIGFLAG, 67108864)/67108864) LOCKED, SUM(BITAND(M.FLAGS, 1))/COUNT(M.FLAGS) TRUNC, SUM(M.INSERTS+M.DELETES) TOT_MODS, SUM(M.INSERTS) INSERTS, SUM(T .ROWCNT) ROWCNT FROM MON_MODS_ALL$ M, TAB$ T WHERE M.OBJ#(+) = T.OBJ# AND T.CLUCOLS IS NOT NULL GROUP BY BOBJ#) CM WHERE (:B8 IS NOT NULL) AND O.TYPE# = 1 AND S.TYPE# = 6 AND I.TYPE# = 3 AND I.OBJ# = O.OBJ# AND I.BO# = CM.BOBJ#(+) AND I.FILE# = S.FILE# AND I.BLOCK# = S.BLOCK# AND I.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(O.FLAGS, 128) != 128 AND (BITAND(I.FLAGS, 2) = 0 OR (BITAND(I.FLAGS, 2) != 0 AND (CM.TRUNC > 0 OR CM.TOT_MODS > .1 * CM.ROWCNT))) AND CM.LOCKED = 0 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN I.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_INDEX_BLOCK_COUNT(U.NAME, OI.NAME, NULL, NULL) WHEN S.TYPE# = 6 THEN DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), I.DATAOBJ#, S.BLOCKS) ELSE NULL END * NVL(TS.BLOCKSIZE, :B4 ) OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, NULL BO# FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OBJ$ OI WHERE :B1 IS NOT NULL AND I.TYPE# = 4 AND I.BO# = OT.OB J# AND BITAND(OT.FLAGS, 128) != 128 AND OT.OWNER# = U.USER# AND M.OBJ#(+) = OT.OBJ# AND I.FILE# = S.FILE#(+) AND I.BLOCK# = S.BLOCK#(+) AND I.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND T.OBJ# = OT.OBJ# AND I.OBJ# = OI.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT /*+ leading(i t) no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, PART#, BO# FROM (SELECT DECODE(BITAND(TP.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(TP.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(TP.ROWCNT, (TP.ROWCNT + M.INSERTS - M.DELETES)))) / (TP.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(IP.TS#, IP.FILE#, IP.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), IP.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, TP.PART# PART#, TP.BO# BO# FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.INDPART$ IP, SYS.TABPART$ TP, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T WHERE I.TYPE# = 4 AND S.TYPE# = 6 AND OT.OWNER# = U.USER# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND TP.OBJ# = OT.OBJ# AND I.BO# = TP.BO# AND BITAND(OT.FLAGS, 128) != 128 AND M.OBJ#(+) = OT.OBJ# AND IP.FILE# = S.FILE# AND IP.BLOCK# = S.BLOCK# AND IP.TS# = S.TS# AND TS.TS# = S.TS# AND I.BO# = T.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(TP.FLAGS, 32) != 32 AND ((BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * TP.ROWCNT)))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(TP.FLAGS, 2) != 2))) WHERE :B5 IS NOT NULL UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B4 OSIZE, I.OBJ# OBJ#, 1 TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, I.BO# BO# FROM SYS.IND$ I, SYS.TAB$ T, SYS.OBJ$ O, USER$ U WHERE (:B8 IS NOT NULL) AND :B1 IS NOT NULL AND BITAND(I.PROPERTY, 32) != 32 AND BITAND(I.PROPERTY, 64) != 64 AND BITAND(I.FLAGS, 2) != 2 AND I.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 16) = 16 AND I.OBJ# = O.OBJ# AND I.TYPE# != 4 AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND BITAND(O.FLAGS, 128) != 128 AND O.OWNER# = U.USER# AND NOT (U.NAME = 'SYS' AND O.NAME = 'I_SUMDELTA$') UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B4 OSIZE, I.OBJ# OBJ#, 20 TYPE#, 64 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, I.PART# PART#, I .BO# BO# FROM (SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) I, SYS.IND$ IND, SYS.TAB$ T, SYS.OBJ$ OI WHERE (:B8 IS NOT NULL) AND :B5 IS NOT NULL AND I.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B4 OSIZE, I.OBJ# OBJ#, 35 TYPE#, 0 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, I.SUBPART# PART#, I.POBJ# BO# FROM SYS.INDSUBPART$ I, SYS.INDCOMPART$ ICP, SYS.IND$ IND, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OI WHERE (:B8 IS NOT NULL) AND BITAND(I.FLAGS, 2) != 2 AND I.POBJ# = ICP.OBJ# AND ICP.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = PO.OBJ# AND ((:B7 IS NOT NULL AND BITAND(PO.SPARE2, 255) = 2) OR (:B6 IS NOT NULL AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 ) WHERE OSIZE IS NOT NULL ) NEW ON (ST.OBJ# = NEW.OBJ#) WHEN MATCHED THEN UPDATE SET ST.STALENESS = CASE WHEN BITAND(ST.FLAGS, 7) > 1 THEN GREATEST(NEW.STALENESS, -0.5) + ROUND(BITAND(ST.FLAGS, 7)*0.15, 1) ELSE NEW.STALENESS END, ST.OSIZE = NEW.OSIZE * DECODE(BITAND(ST.FLA GS, 7), 0, 1, 2), ST.FLAGS = ST.FLAGS - BITAND(ST.FLAGS, 32+64+128) + NEW.AFLAGS, ST.STATUS = 0, ST.TYPE# = NEW.TYPE#, ST.PART# = NEW.PART#, ST.BO# = NEW.BO#, ST.SID = NEW.SID, ST.SERIAL# = NEW.SERIAL# WHEN NOT MATCHED THEN INSERT (ST.STALENESS, ST.OSIZE, ST.OBJ#, ST.TYPE#, ST.FLAGS, ST.STATUS, ST.SID, ST.SERIAL#, ST.PART#, ST.BO#) VALUES (NEW.STALENESS, NEW.OSIZE, NEW.OBJ#, NEW.TYPE#, NEW.AFLAGS, NEW.STATUS, :B3 , :B2 , NEW.PART#, NEW.BO#)
d92h3rjp0y217begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
du5yw0cqjr4hjSELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = '³£ÊìÊÐ' /*OR B.ALIAS1='³£ÊìÊÐ' OR B.ALIAS2='³£ÊìÊÐ' OR B.ALIAS3='³£ÊìÊÐ'*/ OR B.NAME like'%½­ËÕÊ¡%' /* OR B.ALIAS1='½­ËÕÊ¡' OR B.ALIAS2='½­ËÕÊ¡' OR B.ALIAS3='½­ËÕÊ¡'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='³£ÊìÊÐ' OR B.NAME like'%½­ËÕÊ¡%' /* OR B.ALIAS1='½­ËÕÊ¡' OR B.ALIAS2='½­ËÕÊ¡' OR B.ALIAS3='½­ËÕÊ¡'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ')
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
fw268s02gfmpb SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = 'ÎâÖÐÇø' /*OR B.ALIAS1='ÎâÖÐÇø' OR B.ALIAS2='ÎâÖÐÇø' OR B.ALIAS3='ÎâÖÐÇø'*/ OR B.NAME like'%ËÕÖÝÊÐ%' /* OR B.ALIAS1='ËÕÖÝÊÐ' OR B.ALIAS2='ËÕÖÝÊÐ' OR B.ALIAS3='ËÕÖÝÊÐ'*/ OR B.NAME like'%ÎâÖÐÇø%' /* OR B.ALIAS1='ÎâÖÐÇø' OR B.ALIAS2='ÎâÖÐÇø' OR B.ALIAS3='ÎâÖÐÇø'*/ OR B.NAME ='ËÕ' /*OR B.ALIAS1='ËÕ' OR B.ALIAS2='ËÕ' OR B.ALIAS3='ËÕ'*/ OR B.NAME ='ÒÍ' /*OR B.ALIAS1='ÒÍ' OR B.ALIAS2='ÒÍ' OR B.ALIAS3='ÒÍ'*/ OR B.NAME ='·' /*OR B.ALIAS1='·' OR B.ALIAS2='·' OR B.ALIAS3='·'*/ OR B.NAME ='5' /*OR B.ALIAS1='5' OR B.ALIAS2='5' OR B.ALIAS3='5'*/ OR B.NAME like'%1ºÅ%' /* OR B.ALIAS1='1ºÅ' OR B.ALIAS2='1ºÅ' OR B.ALIAS3='1ºÅ'*/ OR B.NAME like'%ÓÀ³Ç%' /* OR B.ALIAS1='ÓÀ³Ç' OR B.ALIAS2='ÓÀ³Ç' OR B.ALIAS3='ÓÀ³Ç'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='ÎâÖÐÇø' OR B.NAME like'%ËÕÖÝÊÐ%' /* OR B.ALIAS1='ËÕÖÝÊÐ' OR B.ALIAS2='ËÕÖÝÊÐ' OR B.AL IAS3='ËÕÖÝÊÐ'*/ OR B.NAME like'%ÎâÖÐÇø%' /* OR B.ALIAS1='ÎâÖÐÇø' OR B.ALIAS2='ÎâÖÐÇø' OR B.ALIAS3='ÎâÖÐÇø'*/ OR B.NAME ='ËÕ' /*OR B.ALIAS1='ËÕ' OR B.ALIAS2='ËÕ' OR B.ALIAS3='ËÕ'*/ OR B.NAME ='ÒÍ' /*OR B.ALIAS1='ÒÍ' OR B.ALIAS2='ÒÍ' OR B.ALIAS3='ÒÍ'*/ OR B.NAME ='·' /*OR B.ALIAS1='·' OR B.ALIAS2='·' OR B.ALIAS3='·'*/ OR B.NAME ='5' /*OR B.ALIAS1='5' OR B.ALIAS2='5' OR B.ALIAS3='5'*/ OR B.NAME like'%1ºÅ%' /* OR B.ALIAS1='1ºÅ' OR B.ALIAS2='1ºÅ' OR B.ALIAS3='1ºÅ'*/ OR B.NAME like'%ÓÀ³Ç%' /* OR B.ALIAS1='ÓÀ³Ç' OR B.ALIAS2='ÓÀ³Ç' OR B.ALIAS3='ÓÀ³Ç'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ')

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 40,373 11.28 45.98
CPU used when call started 39,112 10.93 44.55
CR blocks created 36 0.01 0.04
Cached Commit SCN referenced 44 0.01 0.05
Commit SCN cached 1 0.00 0.00
DB time 404,199 112.97 460.36
DBWR checkpoint buffers written 983 0.27 1.12
DBWR checkpoints 4 0.00 0.00
DBWR fusion writes 83 0.02 0.09
DBWR transaction table writes 62 0.02 0.07
DBWR undo block writes 196 0.05 0.22
DFO trees parallelized 78 0.02 0.09
PX local messages recv'd 420 0.12 0.48
PX local messages sent 420 0.12 0.48
PX remote messages recv'd 196 0.05 0.22
PX remote messages sent 320 0.09 0.36
Parallel operations not downgraded 78 0.02 0.09
RowCR - row contention 0 0.00 0.00
RowCR attempts 158 0.04 0.18
RowCR hits 158 0.04 0.18
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 14,105 3.94 16.06
active txn count during cleanout 91 0.03 0.10
application wait time 4 0.00 0.00
background checkpoints completed 4 0.00 0.00
background checkpoints started 4 0.00 0.00
background timeouts 22,402 6.26 25.51
buffer is not pinned count 279,062 78.00 317.84
buffer is pinned count 919,846 257.09 1,047.66
bytes received via SQL*Net from client 6,997,323 1,955.69 7,969.62
bytes sent via SQL*Net to client 5,743,911 1,605.37 6,542.04
calls to get snapshot scn: kcmgss 65,977 18.44 75.14
calls to kcmgas 3,445 0.96 3.92
calls to kcmgcs 142 0.04 0.16
change write time 28 0.01 0.03
cleanout - number of ktugct calls 609 0.17 0.69
cleanouts and rollbacks - consistent read gets 2 0.00 0.00
cleanouts only - consistent read gets 452 0.13 0.51
cluster key scan block gets 24,368 6.81 27.75
cluster key scans 9,383 2.62 10.69
cluster wait time 575 0.16 0.65
commit batch/immediate performed 0 0.00 0.00
commit batch/immediate requested 0 0.00 0.00
commit cleanout failures: block lost 15 0.00 0.02
commit cleanout failures: callback failure 74 0.02 0.08
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 2,171 0.61 2.47
commit cleanouts successfully completed 2,082 0.58 2.37
commit immediate performed 0 0.00 0.00
commit immediate requested 0 0.00 0.00
commit txn count during cleanout 594 0.17 0.68
concurrency wait time 159 0.04 0.18
consistent changes 67 0.02 0.08
consistent gets 10,992,111 3,072.20 12,519.49
consistent gets - examination 105,505 29.49 120.17
consistent gets direct 10 0.00 0.01
consistent gets from cache 10,992,101 3,072.20 12,519.48
current blocks converted for CR 0 0.00 0.00
cursor authentications 145 0.04 0.17
data blocks consistent reads - undo records applied 21 0.01 0.02
db block changes 16,573 4.63 18.88
db block gets 15,461 4.32 17.61
db block gets direct 10 0.00 0.01
db block gets from cache 15,451 4.32 17.60
deferred (CURRENT) block cleanout applications 1,255 0.35 1.43
dirty buffers inspected 0 0.00 0.00
enqueue conversions 1,245 0.35 1.42
enqueue releases 52,687 14.73 60.01
enqueue requests 52,689 14.73 60.01
enqueue timeouts 1 0.00 0.00
enqueue waits 844 0.24 0.96
exchange deadlocks 1 0.00 0.00
execute count 20,230 5.65 23.04
free buffer inspected 39,146 10.94 44.59
free buffer requested 85,111 23.79 96.94
gc CPU used by this session 17,650 4.93 20.10
gc blocks lost 0 0.00 0.00
gc cr block build time 2 0.00 0.00
gc cr block flush time 0 0.00 0.00
gc cr block receive time 2,934 0.82 3.34
gc cr block send time 3 0.00 0.00
gc cr blocks received 33,860 9.46 38.56
gc cr blocks served 580 0.16 0.66
gc current block flush time 0 0.00 0.00
gc current block pin time 0 0.00 0.00
gc current block receive time 21 0.01 0.02
gc current block send time 2 0.00 0.00
gc current blocks received 499 0.14 0.57
gc current blocks served 836 0.23 0.95
gc local grants 6,318 1.77 7.20
gc remote grants 7,230 2.02 8.23
gcs messages sent 1,657,629 463.29 1,887.96
ges messages sent 26,702 7.46 30.41
global enqueue get time 402 0.11 0.46
global enqueue gets async 9,769 2.73 11.13
global enqueue gets sync 19,691 5.50 22.43
global enqueue releases 21,429 5.99 24.41
heap block compress 62 0.02 0.07
hot buffers moved to head of LRU 2,606 0.73 2.97
immediate (CR) block cleanout applications 454 0.13 0.52
immediate (CURRENT) block cleanout applications 267 0.07 0.30
index crx upgrade (positioned) 2,121 0.59 2.42
index fast full scans (full) 8 0.00 0.01
index fetch by key 25,296 7.07 28.81
index scans kdiixs1 311,482 87.06 354.76
leaf node 90-10 splits 9 0.00 0.01
leaf node splits 16 0.00 0.02
lob reads 204 0.06 0.23
lob writes 88 0.02 0.10
lob writes unaligned 88 0.02 0.10
logons cumulative 2,544 0.71 2.90
messages received 9,859 2.76 11.23
messages sent 9,859 2.76 11.23
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 10,841,900 3,030.22 12,348.41
opened cursors cumulative 15,227 4.26 17.34
parse count (failures) 5 0.00 0.01
parse count (hard) 1,716 0.48 1.95
parse count (total) 14,379 4.02 16.38
parse time cpu 1,676 0.47 1.91
parse time elapsed 1,688 0.47 1.92
physical read IO requests 5,886 1.65 6.70
physical read bytes 116,588,544 32,585.48 132,788.77
physical read total IO requests 18,191 5.08 20.72
physical read total bytes 320,514,048 89,580.89 365,050.17
physical read total multi block requests 1,822 0.51 2.08
physical reads 14,232 3.98 16.21
physical reads cache 13,170 3.68 15.00
physical reads cache prefetch 8,682 2.43 9.89
physical reads direct 1,062 0.30 1.21
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 8,498 2.38 9.68
physical write IO requests 1,137 0.32 1.29
physical write bytes 11,042,816 3,086.37 12,577.24
physical write total IO requests 6,647 1.86 7.57
physical write total bytes 83,140,608 23,237.08 94,693.18
physical write total multi block requests 1,000 0.28 1.14
physical writes 1,348 0.38 1.54
physical writes direct 290 0.08 0.33
physical writes direct (lob) 10 0.00 0.01
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 1,058 0.30 1.21
physical writes non checkpoint 568 0.16 0.65
pinned buffers inspected 0 0.00 0.00
pinned cursors current 8 0.00 0.01
prefetch warmup blocks aged out before use 4 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 86 0.02 0.10
process last non-idle time 3,574 1.00 4.07
queries parallelized 78 0.02 0.09
recursive calls 132,616 37.07 151.04
recursive cpu usage 2,338 0.65 2.66
redo blocks written 8,919 2.49 10.16
redo buffer allocation retries 0 0.00 0.00
redo entries 11,035 3.08 12.57
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 139 0.04 0.16
redo size 3,937,932 1,100.62 4,485.12
redo subscn max counts 337 0.09 0.38
redo synch time 2 0.00 0.00
redo synch writes 67 0.02 0.08
redo wastage 463,124 129.44 527.48
redo write broadcast ack time 0 0.00 0.00
redo write time 59 0.02 0.07
redo writer latching time 0 0.00 0.00
redo writes 1,452 0.41 1.65
rollback changes - undo records applied 0 0.00 0.00
rollbacks only - consistent read gets 12 0.00 0.01
rows fetched via callback 14,694 4.11 16.74
session connect time 0 0.00 0.00
session cursor cache hits 6,496 1.82 7.40
session logical reads 11,007,570 3,076.52 12,537.10
shared hash latch upgrades - no wait 2,813 0.79 3.20
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 8,844 2.47 10.07
sorts (rows) 726,673 203.10 827.65
sql area evicted 3,900 1.09 4.44
sql area purged 5 0.00 0.01
summed dirty queue length 0 0.00 0.00
switch current to new buffer 47 0.01 0.05
table fetch by rowid 383,977 107.32 437.33
table fetch continued row 136 0.04 0.15
table scan blocks gotten 10,267,145 2,869.58 11,693.79
table scan rows gotten 552,284,828 154,358.80 629,026.00
table scans (long tables) 0 0.00 0.00
table scans (short tables) 8,815 2.46 10.04
total number of times SMON posted 17 0.00 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 0 0.00 0.00
transaction tables consistent read rollbacks 1 0.00 0.00
transaction tables consistent reads - undo records applied 1 0.00 0.00
undo change vector size 1,166,392 326.00 1,328.46
user I/O wait time 944 0.26 1.08
user calls 23,865 6.67 27.18
user commits 644 0.18 0.73
user rollbacks 234 0.07 0.27
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 7,569 2.12 8.62
write clones created in background 0 0.00 0.00
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 13,841,865,088 14,217,900,192
session cursor cache count 115,089 118,528
session uga memory 8.5E+12 8.7E+12
opened cursors current 54 90
logons current 72 72
session uga memory max 22,887,613,384 23,442,272,176
session pga memory 10,900,182,080 11,281,542,656

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 4 4.02

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 4,952 1 1.53 2.68 106 0 0 0.00
SYSAUX 55 0 4.36 1.51 608 0 0 0.00
UNDOTBS2 26 0 0.00 1.00 147 0 2 0.00
SYSTEM 33 0 5.76 1.00 87 0 0 0.00
TS_IDX_YTMOT 40 0 0.00 1.00 20 0 0 0.00
HIS_GPS_02_2 50 0 0.00 1.00 7 0 0 0.00
HIS_GPS_02_1 46 0 0.00 1.00 5 0 0 0.00
HIS_GPS_01_1 45 0 0.00 1.00 5 0 0 0.00
HIS_GPS_01_2 45 0 0.00 1.00 5 0 0 0.00
HIS_GPS_12_3 36 0 0.00 1.00 6 0 0 0.00
HIS_GPS_10_3 31 0 0.00 1.00 7 0 0 0.00
HIS_GPS_03_1 31 0 0.00 1.00 6 0 0 0.00
HIS_GPS_03_2 31 0 0.00 1.00 6 0 0 0.00
HIS_GPS_03_3 31 0 0.00 1.00 6 0 0 0.00
HIS_GPS_01_3 27 0 0.00 1.00 3 0 0 0.00
HIS_GPS_02_3 27 0 0.00 1.00 3 0 0 0.00
HIS_GPS_12_1 26 0 0.00 1.00 4 0 0 0.00
HIS_GPS_12_2 26 0 0.00 1.00 4 0 0 0.00
HIS_GPS_09_2 23 0 0.00 1.00 5 0 0 0.00
HIS_GPS_10_2 23 0 0.00 1.00 5 0 0 0.00
HIS_GPS_11_2 23 0 0.00 1.00 5 0 0 0.00
HIS_GPS_11_3 23 0 0.00 1.00 5 0 0 0.00
HIS_GPS_08_3 18 0 0.00 1.00 6 0 0 0.00
HIS_GPS_08_1 14 0 0.00 1.00 6 0 0 0.00
UNDOTBS1 14 0 0.00 1.00 6 0 0 0.00
HIS_GPS_09_1 14 0 0.00 1.00 4 0 0 0.00
HIS_GPS_09_3 14 0 0.00 1.00 4 0 0 0.00
HIS_GPS_10_1 14 0 0.00 1.00 4 0 0 0.00
HIS_GPS_11_1 14 0 0.00 1.00 4 0 0 0.00
HIS_GPS_07_3 10 0 0.00 1.00 4 0 0 0.00
HIS_GPS_08_2 10 0 0.00 1.00 4 0 0 0.00
HIS_GPS_04_1 11 0 0.00 1.00 2 0 0 0.00
HIS_GPS_04_2 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_04_3 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_05_1 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_05_2 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_05_3 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_1 8 0 0.00 1.00 4 0 0 0.00
HIS_GPS_06_2 8 0 0.00 1.00 4 0 0 0.00
HIS_GPS_06_3 8 0 0.00 1.00 4 0 0 0.00
HIS_GPS_07_1 8 0 0.00 1.00 4 0 0 0.00
HIS_GPS_07_2 8 0 0.00 1.00 4 0 0 0.00
HIS_GPS_20130501 2 0 0.00 1.00 2 0 0 0.00
HIS_GPS_20130502 2 0 0.00 1.00 2 0 0 0.00
HIS_GPS_20130503 2 0 0.00 1.00 2 0 0 0.00
SPLEX_TSP 2 0 0.00 1.00 2 0 0 0.00
USERS 2 0 0.00 1.00 2 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_01.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_1.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_11.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_21.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_1 +DATADG/gpsdb/dbf_01_31.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_02.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_12.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_2.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_22.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_2 +DATADG/gpsdb/dbf_01_32.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_3 +DATADG/gpsdb/dbf_01_03.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_3 +DATADG/gpsdb/dbf_01_13.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_01_3 +DATADG/gpsdb/dbf_01_3.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_01.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_1.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_11.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_21.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_1 +DATADG/gpsdb/dbf_02_31.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_02.dbf 10 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_12.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_2.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_22.dbf 11 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_2 +DATADG/gpsdb/dbf_02_32.dbf 11 0 0.00 1.00 2 0 0 0.00
HIS_GPS_02_3 +DATADG/gpsdb/dbf_02_03.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_3 +DATADG/gpsdb/dbf_02_13.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_02_3 +DATADG/gpsdb/dbf_02_3.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_03_1 +DATADG/gpsdb/dbf_03_1 11 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_1 +DATADG/gpsdb/dbf__03_01.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_1 +DATADG/gpsdb/dbf__03_11.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_2 +DATADG/gpsdb/dbf_03_02.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_2 +DATADG/gpsdb/dbf_03_12.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_2 +DATADG/gpsdb/dbf_03_2 11 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_3 +DATADG/gpsdb/dbf_03_03.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_3 +DATADG/gpsdb/dbf_03_13.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_03_3 +DATADG/gpsdb/dbf_03_3 11 0 0.00 1.00 2 0 0 0.00
HIS_GPS_04_1 +DATADG/gpsdb/dbf_04_1 11 0 0.00 1.00 2 0 0 0.00
HIS_GPS_04_2 +DATADG/gpsdb/dbf_04_2 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_04_3 +DATADG/gpsdb/dbf_04_3 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_05_1 +DATADG/gpsdb/dbf_05_1 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_05_2 +DATADG/gpsdb/dbf_05_2 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_05_3 +DATADG/gpsdb/dbf_05_3 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_1 +DATADG/gpsdb/dbf_06_1.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_1 +DATADG/gpsdb/dbf_06_1b.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_2 +DATADG/gpsdb/dbf_06_2.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_2 +DATADG/gpsdb/dbf_06_2b.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_3 +DATADG/gpsdb/dbf_06_3.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_06_3 +DATADG/gpsdb/dbf_06_3b.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_1 +DATADG/gpsdb/dbf_07_1.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_1 +DATADG/gpsdb/dbf_07_1b.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_2 +DATADG/gpsdb/dbf_07_2.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_2 +DATADG/gpsdb/dbf_07_2b.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_3 +DATADG/gpsdb/dbf_07_3.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_07_3 +DATADG/gpsdb/dbf_07_3b.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_1 +DATADG/gpsdb/dbf_08_1.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_1 +DATADG/gpsdb/dbf_08_1b.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_1 +FLASHAREA_DG/gpsdb/dbf_08_2.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_2 +DATADG/gpsdb/dbf_08_2.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_2 +DATADG/gpsdb/dbf_08_2b.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_3 +DATADG/gpsdb/dbf_08_3.dbf 4 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_3 +DATADG/gpsdb/dbf_08_3b.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_08_3 +DATADG/gpsdb/dbf_08_3c.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_1 +DATADG/gpsdb/dbf_09_1.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_1 +DATADG/gpsdb/dbf_09_1_01.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_2 +DATADG/gpsdb/dbf_09_2.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_2 +DATADG/gpsdb/dbf_09_2b.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_2 +DATADG/gpsdb/dbf_10_2_03.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_09_3 +DATADG/gpsdb/dbf_09_3.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_09_3 +DATADG/gpsdb/dbf_09_3b.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_1 +DATADG/gpsdb/dbf_10_1.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_1 +DATADG/gpsdb/dbf_10_1_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_2 +DATADG/gpsdb/dbf_10_2.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_2 +DATADG/gpsdb/dbf_10_2_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_2 +DATADG/gpsdb/dbf_10_2_12.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_10_3 +DATADG/gpsdb/dbf_10_3.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_3 +DATADG/gpsdb/dbf_10_3_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_3 +DATADG/gpsdb/dbf_10_3_03.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_10_3 +DATADG/gpsdb/dbf_10_3_13.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_11_1 +DATADG/gpsdb/dbf_11_1.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_1 +DATADG/gpsdb/dbf_11_1_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_2 +DATADG/gpsdb/dbf_11_2.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_2 +DATADG/gpsdb/dbf_11_2_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_2 +DATADG/gpsdb/dbf_11_2_12.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_11_3 +DATADG/gpsdb/dbf_11_3.dbf 6 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_3 +DATADG/gpsdb/dbf_11_3_02.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_11_3 +DATADG/gpsdb/dbf_11_3_03.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_12_1 +DATADG/gpsdb/dbf_12_01.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_12_1 +DATADG/gpsdb/dbf_12_1.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_1 +DATADG/gpsdb/dbf_12_11.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_12_2 +DATADG/gpsdb/dbf_12_02.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_12_2 +DATADG/gpsdb/dbf_12_12.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_12_2 +DATADG/gpsdb/dbf_12_2.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_3 +DATADG/gpsdb/dbf_12_03.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_12_3 +DATADG/gpsdb/dbf_12_23.dbf 10 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_3 +DATADG/gpsdb/dbf_12_3.dbf 8 0 0.00 1.00 2 0 0 0.00
HIS_GPS_12_3 +DATADG/gpsdb/dbf_12_3_13.dbf 9 0 0.00 1.00 1 0 0 0.00
HIS_GPS_20130501 +DATADG/gpsdb/dbf_130501.dbf 2 0 0.00 1.00 2 0 0 0.00
HIS_GPS_20130502 +DATADG/gpsdb/dbf_130502.dbf 2 0 0.00 1.00 2 0 0 0.00
HIS_GPS_20130503 +DATADG/gpsdb/dbf_130503.dbf 2 0 0.00 1.00 2 0 0 0.00
SPLEX_TSP +DATADG/gpsdb/splex_tbs_01.dbf 2 0 0.00 1.00 2 0 0 0.00
SYSAUX +DATADG/gpsdb/sysaux01.dbf 55 0 4.36 1.51 608 0 0 0.00
SYSTEM +DATADG/gpsdb/system01.dbf 33 0 5.76 1.00 87 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_01.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_02.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_03.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_04.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_05.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_06.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_07.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_08.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_09.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_IDX_YTMOT +DATADG/gpsdb/idx_ytmot_10.dbf 4 0 0.00 1.00 2 0 0 0.00
UNDOTBS1 +DATADG/gpsdb/undotbs01.dbf 2 0 0.00 1.00 2 0 0 0.00
UNDOTBS1 +DATADG/gpsdb/undotbs03.dbf 6 0 0.00 1.00 2 0 0 0.00
UNDOTBS1 +DATADG/gpsdb/undotbs05.dbf 6 0 0.00 1.00 2 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs02.dbf 2 0 0.00 1.00 71 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs04.dbf 6 0 0.00 1.00 14 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs06.dbf 6 0 0.00 1.00 52 0 2 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs07.dbf 6 0 0.00 1.00 2 0 0 0.00
UNDOTBS2 +DATADG/gpsdb/undotbs08.dbf 6 0 0.00 1.00 8 0 0 0.00
USERS +DATADG/gpsdb/users01.dbf 2 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_01.dbf 52 0 2.12 1.10 4 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_02.dbf 74 0 1.89 1.01 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_03.dbf 62 0 4.03 1.08 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_04.dbf 82 0 2.68 1.04 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_05.dbf 76 0 2.11 1.13 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_06.dbf 528 0 1.34 2.27 4 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_07.dbf 8 0 1.25 1.00 5 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_08.dbf 17 0 2.35 1.00 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_09.dbf 156 0 1.73 2.87 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_10.dbf 286 0 1.43 2.36 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_11.dbf 167 0 1.38 2.26 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_12.dbf 409 0 1.12 2.41 4 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_13.dbf 325 0 1.85 3.22 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_14.dbf 324 0 1.45 3.23 4 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_15.dbf 322 0 1.83 3.24 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_16.dbf 312 0 1.73 3.31 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_17.dbf 315 0 1.30 3.29 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_18.dbf 321 0 1.18 3.21 5 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_19.dbf 325 0 1.63 3.21 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_20.dbf 352 0 1.28 2.73 4 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_21.dbf 242 0 1.94 3.10 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_22.dbf 4 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_23.dbf 4 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_24.dbf 12 0 1.67 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_25.dbf 50 0 2.60 1.02 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_26.dbf 6 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_27.dbf 8 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_28.dbf 8 0 0.00 1.00 3 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_29.dbf 8 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_30.dbf 8 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_31.dbf 8 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_32.dbf 8 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_33.dbf 10 0 0.00 1.00 5 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_34.dbf 10 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_35.dbf 10 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_36.dbf 10 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_37.dbf 9 0 0.00 1.00 1 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_38.dbf 10 0 0.00 1.00 2 0 0 0.00
WZT +DATADG/gpsdb/wzt_tbs_39.dbf 10 0 0.00 1.00 2 0 0 0.00
WZT +FLASHAREA_DG/gpsdb/wzt_tbs_26.dbf 4 0 0.00 1.00 2 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 11,007,477 13,171 1,058 0 0 2


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 321 1596 2934 2831130 2934  
E 0 0 775 2679 3433 2831130 3433  

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

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 431 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,097 394.50 0.00 0.00 0.00 0.00 838,860
E 8,192 7,096 420.72 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 6,942 6,942 0 0
64K 128K 186 186 0 0
128K 256K 6 6 0 0
512K 1024K 368 368 0 0
1M 2M 65 65 0 0
4M 8M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
1,024 0.13 134,358.02 327.42 100.00 0
2,048 0.25 134,358.02 327.42 100.00 0
4,096 0.50 134,358.02 327.42 100.00 0
6,144 0.75 134,358.02 327.42 100.00 0
8,192 1.00 134,358.02 327.42 100.00 0
9,830 1.20 134,358.02 0.00 100.00 0
11,469 1.40 134,358.02 0.00 100.00 0
13,107 1.60 134,358.02 0.00 100.00 0
14,746 1.80 134,358.02 0.00 100.00 0
16,384 2.00 134,358.02 0.00 100.00 0
24,576 3.00 134,358.02 0.00 100.00 0
32,768 4.00 134,358.02 0.00 100.00 0
49,152 6.00 134,358.02 0.00 100.00 0
65,536 8.00 134,358.02 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 861 40,032 30,727 0.99 3,908 1.09 5,714
2,128 0.29 1,581 56,248 30,936 1.00 3,699 1.03 5,733
2,864 0.39 2,311 70,438 30,980 1.00 3,655 1.02 5,738
3,600 0.49 3,045 88,514 31,004 1.00 3,631 1.01 5,741
4,336 0.60 3,775 101,821 31,019 1.00 3,616 1.00 5,743
5,072 0.70 4,508 117,777 31,026 1.00 3,609 1.00 5,745
5,808 0.80 5,243 135,116 31,029 1.00 3,606 1.00 5,745
6,544 0.90 5,978 155,062 31,033 1.00 3,602 1.00 5,746
7,280 1.00 6,713 168,514 31,035 1.00 3,600 1.00 5,746
8,016 1.10 7,448 188,456 31,037 1.00 3,598 1.00 5,747
8,752 1.20 8,183 201,246 31,039 1.00 3,596 1.00 5,747
9,488 1.30 8,918 213,552 31,041 1.00 3,594 1.00 5,747
10,224 1.40 9,653 225,846 31,043 1.00 3,592 1.00 5,748
10,960 1.51 10,388 246,642 31,045 1.00 3,590 1.00 5,748
11,696 1.61 11,123 265,538 31,047 1.00 3,588 1.00 5,749
12,432 1.71 11,858 281,902 31,049 1.00 3,586 1.00 5,749
13,168 1.81 12,593 300,104 31,052 1.00 3,583 1.00 5,749
13,904 1.91 13,328 311,486 31,053 1.00 3,582 1.00 5,750
14,640 2.01 14,640 379,947 31,072 1.00 3,563 0.99 5,753

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 275,470 1,045,601
10,240 0.50 275,305 963,809
15,360 0.75 275,223 962,269
20,480 1.00 275,195 962,269
25,600 1.25 275,167 962,269
30,720 1.50 275,167 962,269
35,840 1.75 275,167 962,269
40,960 2.00 275,167 962,269

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

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
CF-Controlfile Transaction 8,920 8,919 1 339 0 0.47
PS-PX Process Reservation 535 535 0 172 0 0.41
TT-Tablespace 306 306 0 140 0 0.50
TM-DML 1,775 1,775 0 145 0 0.41
JQ-Job Queue 60 60 0 16 0 0.00
TA-Instance Undo 12 12 0 12 0 0.00
WF-AWR Flush 21 21 0 10 0 0.00
JS-Job Scheduler (job run lock - synchronize) 6 6 0 2 0 0.00
MW-MWIN Schedule 2 2 0 2 0 0.00
WL-Being Written Redo Log 4 4 0 2 0 0.00
AF-Advisor Framework (task serialization) 7 7 0 1 0 0.00
HW-Segment High Water Mark 1,307 1,307 0 1 0 0.00
JS-Job Scheduler (queue lock) 16,567 16,567 0 1 0 0.00
TX-Transaction (index contention) 1 1 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 2.95 2,918 1,336 3 15/42.3 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 22:10 2,878 2,114 118 3 17 0/0 0/0/0/0/0/0
13-Mar 22:00 39 180 0 3 15 0/0 0/0/0/0/0/0
13-Mar 21:50 7 102 0 1 15 0/0 0/0/0/0/0/0
13-Mar 21:40 7 134 0 1 15 0/0 0/0/0/0/0/0
13-Mar 21:30 8 108 0 3 18 0/0 0/0/0/0/0/0
13-Mar 21:20 12 192 0 3 42 0/0 0/0/0/0/0/0
13-Mar 21:10 3 88 1,336 1 33 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 120 0.00   0 0  
ASM db client latch 9,849 0.00   0 0  
ASM map headers 1,485 0.00   0 0  
ASM map load waiting list 373 0.00   0 0  
ASM map operation freelist 41 0.00   0 0  
ASM map operation hash table 1,522,887 0.00   0 0  
ASM network background latch 3,090 0.00   0 0  
AWR Alerted Metric Element list 22,265 0.00   0 0  
Consistent RBA 1,457 0.00   0 0  
FAL request queue 79 0.00   0 0  
FAL subheap alocation 79 0.00   0 0  
FIB s.o chain latch 24 0.00   0 0  
FOB s.o list latch 2,422 0.00   0 0  
JS Sh mem access 2 0.00   0 0  
JS broadcast add buf latch 1,022 0.00   0 0  
JS broadcast drop buf latch 1,022 0.00   0 0  
JS broadcast kill buf latch 1 0.00   0 0  
JS broadcast load blnc latch 912 0.00   0 0  
JS mem alloc latch 25 0.00   0 0  
JS queue access latch 25 0.00   0 0  
JS queue state obj latch 33,134 0.00   0 0  
JS slv state obj latch 3,896 0.00   0 0  
KCL gc element parent latch 238,855 0.00 0.00 0 56 0.00
KFK SGA context latch 7,184 0.00   0 0  
KFMD SGA 82 0.00   0 0  
KJC message pool free list 14,939 0.21 0.00 0 3,003 0.03
KJCT flow control latch 3,213,030 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 1,193 0.00   0 0  
KSXR large replies 4 0.00   0 0  
KTF sga latch 12 0.00   0 1,124 0.00
KWQMN job cache list latch 258 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,193 0.00
OS process 7,326 0.00   0 0  
OS process allocation 6,076 0.00   0 0  
OS process: request allocation 4,788 0.00   0 0  
PL/SQL warning settings 2,609 0.00   0 0  
Reserved Space Latch 12 0.00   0 0  
SQL memory manager latch 1 0.00   0 1,171 0.00
SQL memory manager workarea list latch 86,982 0.00   0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 10,516 0.00   0 0  
active service list 17,480 0.07 0.00 0 2,547 0.00
alert log latch 8 0.00   0 0  
archive control 134 0.00   0 0  
archive process latch 1,337 0.00   0 0  
begin backup scn array 10 0.00   0 0  
business card 156 0.00   0 0  
cache buffer handles 6,096 0.00   0 0  
cache buffers chains 22,282,558 0.00 0.01 0 161,328 0.00
cache buffers lru chain 83,050 0.01 0.00 0 131,587 0.00
cache table scan latch 0     0 15 0.00
channel handle pool latch 4,814 0.02 0.00 0 0  
channel operations parent latch 434,125 0.00 0.00 0 0  
checkpoint queue latch 772,684 0.00   0 1,671 0.00
client/application info 5,267 0.00   0 0  
commit callback allocation 4 0.00   0 0  
compile environment latch 2,544 0.00   0 0  
dictionary lookup 2 0.00   0 0  
dml lock allocation 3,639 0.00   0 0  
dummy allocation 5,088 0.02 0.00 0 0  
enqueue hash chains 115,521 0.01 0.00 0 4 0.00
enqueues 102,555 0.00 0.00 0 0  
error message lists 378 0.00   0 0  
event group latch 2,394 0.00   0 0  
file cache latch 1,937 0.00   0 0  
gcs opaque info freelist 1,430 0.00   0 0  
gcs partitioned table hash 579,990 0.00   0 118 0.00
gcs remastering latch 39 0.00   0 0  
gcs resource freelist 51,337 0.00   0 44,306 0.00
gcs resource hash 234,735 0.02 0.06 0 1 0.00
gcs resource scan list 2 0.00   0 0  
gcs shadows freelist 53,261 0.00   0 44,765 0.00
ges caches resource lists 17,120 0.37 0.00 0 47,272 0.06
ges deadlock list 364 0.00   0 0  
ges domain table 30,544 0.00   0 0  
ges enqueue table freelist 55,476 0.00   0 0  
ges group table 45,081 0.00   0 0  
ges process hash list 19,185 0.00   0 0  
ges process parent latch 122,271 0.00   0 0  
ges process table freelist 4,788 0.04 0.00 0 0  
ges resource hash list 133,789 0.03 0.16 0 6,531 0.02
ges resource scan list 62 0.00   0 0  
ges resource table freelist 14,888 0.00   0 0  
ges timeout list 4,166 0.00   0 2,403 0.00
global KZLD latch for mem in SGA 224 0.00   0 0  
hash table column usage latch 71 0.00   0 437,409 0.00
hash table modification latch 89 0.00   0 0  
interrupt manipulation 655 0.00   0 0  
job workq parent latch 0     0 132 0.00
job_queue_processes free list latch 1 0.00   0 0  
job_queue_processes parameter latch 126 0.00   0 0  
kks stats 10,790 0.00   0 0  
kokc descriptor allocation latch 98 0.00   0 0  
ksuosstats global area 241 0.00   0 0  
ktm global data 17 0.00   0 0  
kwqbsn:qsga 128 0.00   0 0  
lgwr LWN SCN 1,984 0.00   0 0  
library cache 188,842 0.02 0.00 0 15,408 0.00
library cache load lock 324 0.00   0 0  
library cache lock 134,346 0.06 0.00 0 0  
library cache lock allocation 2,658 0.00   0 0  
library cache pin 51,760 0.00 0.00 0 0  
library cache pin allocation 466 0.00   0 0  
list of block allocation 176 0.00   0 0  
loader state object freelist 228 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,099 0.00   0 0  
messages 200,100 0.01 0.00 0 0  
mostly latch-free SCN 1,986 0.05 0.00 0 0  
msg queue 191 0.00   0 191 0.00
multiblock read objects 20,835 0.00 0.00 0 0  
name-service memory objects 23,428 0.00   0 0  
name-service namespace bucket 50,344 0.00   0 0  
name-service pending queue 3,104 0.00   0 0  
name-service request queue 44,681 0.00   0 0  
ncodef allocation latch 89 0.00   0 0  
object queue header heap 42,307 0.00   0 252 0.00
object queue header operation 186,690 0.01 0.00 0 0  
object stats modification 4 0.00   0 0  
parallel query alloc buffer 2,036 0.00   0 0  
parallel query stats 319 0.00   0 0  
parallel txn reco latch 5,640 0.00   0 0  
parameter list 9,765 0.01 0.00 0 0  
parameter table management 5,095 0.00   0 0  
post/wait queue 140 0.00   0 93 0.00
process allocation 42,810 0.09 0.82 0 2,388 0.25
process group creation 4,788 0.00   0 0  
process queue 849 0.00   0 0  
process queue reference 13,756 0.00   0 1,365 0.00
qmn task queue latch 504 0.00   0 0  
query server freelists 704 0.00   0 0  
queued dump request 17,886 0.00   0 0  
redo allocation 9,448 0.07 0.00 0 11,057 0.00
redo copy 0     0 11,057 0.05
redo writing 17,330 0.01 0.00 0 0  
reservation so alloc latch 8 0.00   0 0  
resmgr group change latch 709 0.00   0 0  
resmgr:active threads 5,074 0.00   0 0  
resmgr:actses change group 377 0.00   0 0  
resmgr:actses change state 2 0.00   0 0  
resmgr:free threads list 5,072 0.08 0.00 0 0  
resmgr:resource group CPU method 377 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 1,369,358 0.03 0.00 0 51 0.00
rules engine aggregate statistics 2 0.00   0 0  
rules engine rule set statistics 104 0.00   0 0  
segmented array pool 24 0.00   0 0  
sequence cache 7,416 0.00   0 0  
session allocation 12,181 0.39 0.13 0 0  
session idle bit 48,523 0.00   0 0  
session state list latch 823 0.00   0 0  
session switching 12,059 0.02 0.00 0 0  
session timer 1,877 0.00   0 0  
shared pool 204,091 0.06 0.07 0 0  
shared pool sim alloc 2 0.00   0 0  
shared pool simulator 20,585 0.00   0 0  
simulator hash latch 700,729 0.00   0 0  
simulator lru latch 0     0 698,467 0.00
slave class 581 0.00   0 0  
slave class create 2,612 0.04 1.00 0 0  
sort extent pool 142 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
threshold alerts latch 1,200 0.00   0 0  
transaction allocation 185 0.00   0 0  
transaction branch allocation 1,877 0.00   0 0  
undo global data 35,801 0.00   0 0  
user lock 7,512 0.28 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 22,282,558 516 7 509 0 0 0
shared pool 204,091 122 8 114 0 0 0
gcs resource hash 234,735 53 3 50 0 0 0
session allocation 12,181 48 6 42 0 0 0
ges resource hash list 133,789 44 7 37 0 0 0
process allocation 42,810 38 31 7 0 0 0
slave class create 2,612 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
active service list kswslogon: session logout 0 5 6
active service list kswslogon: session login 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 146 128
cache buffers chains kcbget: pin buffer 0 1 0
cache buffers chains kcbgtcr: fast path 0 1 0
cache buffers chains kcbzgb: scan from tail. nowait 0 1 0
gcs resource hash kjbopen:affinity 0 2 0
gcs resource hash kjbassume 0 1 0
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 5 0
ges resource hash list kjcvscn: remove from scan queue 0 1 0
ges resource hash list kjucvl: lock convert request 0 1 0
object queue header operation kcbo_switch_cq 0 2 0
object queue header operation kcbw_unlink_q 0 1 2
process allocation ksucrp 0 29 0
process allocation ksudlp 0 1 0
process allocation ksufap: active procs 0 1 13
session allocation ksuxds: KSUSFCLC not set 0 6 5
shared pool kghalo 0 8 5
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
YTGPS WZT YTO_MID_ROAD   TABLE 6,097,008 55.39
YTGPS WZT YTO_MID_ROAD_NUM   TABLE 2,667,504 24.23
YTGPS WZT YTO_MID_POI   TABLE 961,680 8.74
YTGPS WZT YTO_JINGANG_STATION   TABLE 535,120 4.86
YTGPS WZT INDEX_PGROUP_PARENTID   INDEX 214,048 1.94

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
YTGPS WZT GPS_LOCRECORD_SHOW_TIME_INDEX2   INDEX 12,225 85.90
YTGPS WZT PK_GPS_LOCRECORD_SHOW   INDEX 626 4.40
YTGPS WZT T_LAST_LOCRECORD   TABLE 130 0.91
YTGPS WZT PK_V_ID   INDEX 44 0.31
YTGPS WZT GPS_LOCRECORD_SHOW   TABLE 34 0.24

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
YTGPS WZT PK_GPS_LOCRECORD_SHOW   INDEX 15,728 46.45
YTGPS WZT T_TERM_STATUS_LAST_RECORD   TABLE 7,912 23.37
YTGPS WZT GPS_LOCRECORD_SHOW_TIME_INDEX2   INDEX 4,164 12.30
YTGPS WZT GPS_LOCRECORD_SHOW   TABLE 3,572 10.55
YTGPS WZT T_LAST_LOCRECORD   TABLE 296 0.87

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 166 33.27
YTGPS WZT YTO_LINE_SECTION   TABLE 36 7.21
SYS SYSTEM COL_USAGE$   TABLE 32 6.41
YTGPS WZT PK_V_ID   INDEX 28 5.61
SYS SYSAUX WRH$_SQLSTAT_INDEX 9363_21012 INDEX PARTITION 18 3.61

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 64 0.00 0   2 1
dc_database_links 2,596 0.00 0   0 1
dc_global_oids 262 0.00 0   0 113
dc_histogram_data 250,297 0.07 0   0 3,043
dc_histogram_defs 51,225 0.27 0   7 2,176
dc_object_ids 115,424 0.01 0   2 1,470
dc_objects 14,489 0.31 0   12 801
dc_profiles 295 0.00 0   0 1
dc_rollback_segments 10,597 0.63 0   0 472
dc_segments 49,841 4.29 0   0 3,507
dc_sequences 3 66.67 0   3 2
dc_tablespaces 52,665 0.00 0   0 50
dc_usernames 3,451 0.06 0   0 46
dc_users 65,646 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 146 0 148
dc_object_ids 15 0 2
dc_objects 67 0 7
dc_rollback_segments 67 0 0
dc_segments 2,139 1 2
dc_sequences 6 1 1
dc_usernames 2 0 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,073 0.47 2,626 0.23 0 0
CLUSTER 15 6.67 36 2.78 0 0
INDEX 1 100.00 5 40.00 0 0
SQL AREA 8,284 40.54 28,921 17.42 100 0
TABLE/PROCEDURE 617 9.40 34,379 0.45 92 0
TRIGGER 34 0.00 191 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 36 1 0 1 0
INDEX 5 3 1 2 0
TABLE/PROCEDURE 9,708 73 3 44 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 349.64   4.66 4.58 16 16 75 75
  Freeable 44.19 0.00 1.47 1.53 6   30 30
  SQL 0.45 0.09 0.01 0.02 0 90 34 26
  PL/SQL 0.28 0.09 0.00 0.01 0 0 73 73
E Other 374.29   4.99 5.36 29 29 75 75
  Freeable 45.50 0.00 1.57 1.57 6   29 29
  SQL 0.65 0.09 0.02 0.04 0 88 33 28
  PL/SQL 0.33 0.16 0.00 0.01 0 0 73 73

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 183.53 176.54 -3.81
shared PCursor 223.78 220.67 -1.39
shared db_block_hash_buckets 90.00 90.00 0.00
shared free memory 2,860.21 3,002.11 4.96
shared gcs resources 310.31 310.31 0.00
shared gcs shadows 166.03 166.03 0.00
shared library cache 227.50 224.90 -1.14
shared sql area 2,838.28 2,702.64 -4.78
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 0 0 0
QMON Coordinator 0 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 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,560,538 436.16 1,777.38
acks for commit broadcast(logical) 1,561,792 436.51 1,778.81
broadcast msgs on commit(actual) 1,409 0.39 1.60
broadcast msgs on commit(logical) 1,452 0.41 1.65
broadcast msgs on commit(wasted) 41 0.01 0.05
broadcast on commit wait time(ms) 0 0.00 0.00
broadcast on commit waits 19 0.01 0.02
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 455 0.13 0.52
gcs ast xid 1 0.00 0.00
gcs blocked converts 500 0.14 0.57
gcs blocked cr converts 14,576 4.07 16.60
gcs compatible basts 0 0.00 0.00
gcs compatible cr basts (global) 83 0.02 0.09
gcs compatible cr basts (local) 211 0.06 0.24
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 63 0.02 0.07
gcs dbwr write request msgs 53 0.01 0.06
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 1,254 0.35 1.43
gcs immediate (null) converts 43,837 12.25 49.93
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 6,665 1.86 7.59
gcs indirect ast 45,444 12.70 51.76
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 97 0.03 0.11
gcs msgs process time(ms) 8,253 2.31 9.40
gcs msgs received 1,688,719 471.98 1,923.37
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 2 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 0 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 0 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 1,685 0.47 1.92
gcs side channel msgs logical 35,026 9.79 39.89
gcs stale cr 3 0.00 0.00
gcs undo cr 1 0.00 0.00
gcs write notification msgs 3 0.00 0.00
gcs writes refused 0 0.00 0.00
ges msgs process time(ms) 451 0.13 0.51
ges msgs received 28,584 7.99 32.56
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 28,573 7.99 32.54
implicit batch messages sent 9,033 2.52 10.29
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 11,906 3.33 13.56
messages queue sent actual 43,322 12.11 49.34
messages queue sent logical 53,170 14.86 60.56
messages received actual 1,645,054 459.78 1,873.64
messages received logical 1,717,302 479.97 1,955.92
messages sent directly 5,564 1.56 6.34
messages sent indirectly 15,733 4.40 17.92
messages sent not implicit batched 34,289 9.58 39.05
messages sent pbatched 1,653,151 462.04 1,882.86
msgs causing lmd to send msgs 12,614 3.53 14.37
msgs causing lms(s) to send msgs 2,883 0.81 3.28
msgs received queue time (ms) 18,013 5.03 20.52
msgs received queued 1,717,308 479.97 1,955.93
msgs sent queue time (ms) 1,633 0.46 1.86
msgs sent queue time on ksxp (ms) 138,793 38.79 158.08
msgs sent queued 52,971 14.80 60.33
msgs sent queued on ksxp 1,608,690 449.61 1,832.22
number of ges deadlock detected 0 0.00 0.00
process batch messages received 13,763 3.85 15.68
process batch messages sent 1,586,577 443.43 1,807.04


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 495
CURRENT Block Requests 85
Data Block Requests 495
Undo Block Requests 1
TX Block Requests 59
Current Results 579
Private results 0
Zero Results 1
Disk Read Results 0
Fail Results 0
Fairness Down Converts 138
Fairness Clears 0
Free GC Elements 0
Flushes 5
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 9
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 836 100.00 0.00 0.00 0.00 0.00
Flushes 5 80.00 20.00 0.00 0.00 0.00
Writes 83 78.31 15.66 0.00 2.41 3.61


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 34,043 91.50 0.06 8.45 485 98.76 1.03 0.21
1 Others 162 100.00 0.00 0.00 30 100.00 0.00 0.00
1 undo header 26 100.00 0.00 0.00 4 100.00 0.00 0.00
1 undo block 1 100.00 0.00 0.00 0      


Back to Top

End of Report