WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ZDCOMORA996850667zdcomora2210.2.0.1.0YESora02

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:262407-Aug-12 13:00:4377 10.7
End Snap:262507-Aug-12 14:00:3486 10.6
Elapsed:  59.84 (mins)  
DB Time:  402.42 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 7,328M 7,328MStd Block Size: 8K
Shared Pool Size: 2,080M 2,080MLog Buffer: 14,392K

Load Profile

Per SecondPer Transaction
Redo size: 553,721.95 8,295.53
Logical reads: 59,077.58 885.06
Block changes: 3,001.32 44.96
Physical reads: 4.25 0.06
Physical writes: 93.88 1.41
User calls: 359.29 5.38
Parses: 10.51 0.16
Hard parses: 2.89 0.04
Sorts: 13.93 0.21
Logons: 0.40 0.01
Executes: 288.25 4.32
Transactions: 66.75 

% Blocks changed per Read: 5.08Recursive Call %: 24.97
Rollback per transaction %: 0.33Rows per Sort: 795.30

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.99In-memory Sort %: 100.00
Library Hit %: 98.15Soft Parse %: 72.49
Execute to Parse %: 96.35Latch Hit %: 99.98
Parse CPU to Parse Elapsd %: 0.06% Non-Parse CPU: 99.30

Shared Pool Statistics

BeginEnd
Memory Usage %: 96.00 95.24
% SQL with executions>1: 58.48 68.62
% Memory for SQL w/exec>1: 49.78 62.53

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
row cache lock 4,300 11,481 2,670 47.5Concurrency
buffer busy waits 5,303 4,956 935 20.5Concurrency
gc buffer busy 4,710 4,598 976 19.0Cluster
CPU time  1,265  5.2 
library cache pin 407 958 2,354 4.0Concurrency

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 2.24 0.03
Global Cache blocks served: 21.36 0.32
GCS/GES messages received: 118.49 1.78
GCS/GES messages sent: 112.01 1.68
DBWR Fusion writes: 0.34 0.01
Estd Interconnect traffic (KB) 233.81 

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

Buffer access - local cache %: 99.99
Buffer access - remote cache %: 0.00
Buffer access - disk %: 0.01

Global Cache and Enqueue Services - Workload Characteristics

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1
Avg message sent queue time on ksxp (ms): 0.1
Avg message received queue time (ms): 1.3
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 7.54
% of indirect sent messages: 16.96
% of flow controlled messages: 75.50

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
parse time elapsed 12,484.70 51.71
hard parse elapsed time 11,497.50 47.62
sql execute elapsed time 11,308.88 46.84
DB CPU 1,264.62 5.24
failed parse elapsed time 877.66 3.63
repeated bind elapsed time 1.71 0.01
PL/SQL execution elapsed time 0.99 0.00
connection management call elapsed time 0.45 0.00
PL/SQL compilation elapsed time 0.41 0.00
hard parse (sharing criteria) elapsed time 0.16 0.00
sequence load elapsed time 0.04 0.00
hard parse (bind mismatch) elapsed time 0.02 0.00
DB time 24,145.21  
background elapsed time 236.40  
background cpu time 60.35  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Concurrency 12,785 72.93 17,399 1361 0.05
Cluster 33,447 14.07 4,604 138 0.14
Commit 238,088 0.10 317 1 0.99
System I/O 269,947 0.00 101 0 1.13
Other 212,446 74.01 79 0 0.89
User I/O 18,248 0.00 63 3 0.08
Application 20,825 0.00 1 0 0.09
Network 1,268,413 0.00 1 0 5.29
Configuration 113,422 99.94 1 0 0.47

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
row cache lock 4,300 91.14 11,481 2670 0.02
buffer busy waits 5,303 95.76 4,956 935 0.02
gc buffer busy 4,710 99.89 4,598 976 0.02
library cache pin 407 80.34 958 2354 0.00
log file sync 238,088 0.10 317 1 0.99
log file parallel write 241,060 0.00 91 0 1.01
Data file init write 2,996 0.00 36 12 0.01
db file sequential read 15,234 0.00 27 2 0.06
gcs log flush sync 1,301 68.79 25 19 0.01
DFS lock handle 2,424 1.07 13 5 0.01
reliable message 169 5.33 9 54 0.00
IPC send completion sync 80,537 98.85 8 0 0.34
db file parallel write 19,740 0.00 7 0 0.08
wait for scn ack 35,754 0.00 7 0 0.15
Streams AQ: qmn coordinator waiting for slave to start 1 100.00 6 6498 0.00
lms flush message acks 588 0.00 6 11 0.00
control file sequential read 7,530 0.00 2 0 0.03
enq: WF - contention 26 15.38 2 75 0.00
os thread startup 55 0.00 2 34 0.00
gc current block 2-way 6,373 0.00 2 0 0.03
gc cr grant 2-way 6,671 0.00 1 0 0.03
SQL*Net break/reset to client 20,544 0.00 1 0 0.09
gc current grant busy 2,673 0.00 1 0 0.01
latch: shared pool 528 0.00 1 2 0.00
gc current multi block request 9,956 0.01 1 0 0.04
name-service call wait 10 0.00 1 73 0.00
SQL*Net message to client 1,263,888 0.00 1 0 5.27
control file parallel write 1,581 0.00 1 0 0.01
gc cr block 2-way 1,557 0.00 1 0 0.01
enq: FB - contention 2,249 0.00 0 0 0.01
enq: PS - contention 1,562 0.00 0 0 0.01
CGS wait for IPC msg 34,624 100.00 0 0 0.14
log file switch completion 39 0.00 0 8 0.00
library cache lock 1,930 0.00 0 0 0.01
PX Deq: reap credit 26,618 96.78 0 0 0.11
latch: library cache 184 0.00 0 2 0.00
gc current grant 2-way 1,407 0.00 0 0 0.01
enq: US - contention 2,112 0.00 0 0 0.01
enq: HW - contention 19 0.00 0 11 0.00
undo segment extension 113,364 99.99 0 0 0.47
PX Deq: Signal ACK 159 33.33 0 1 0.00
LGWR wait for redo copy 6,828 0.00 0 0 0.03
latch free 8 0.00 0 9 0.00
ksxr poll remote instances 6,280 89.75 0 0 0.03
db file scattered read 9 0.00 0 5 0.00
enq: TM - contention 281 0.00 0 0 0.00
gc current block busy 8 0.00 0 4 0.00
SQL*Net more data to client 975 0.00 0 0 0.00
log file sequential read 18 0.00 0 1 0.00
enq: CF - contention 147 0.00 0 0 0.00
PX Deq Credit: send blkd 234 56.84 0 0 0.00
rdbms ipc reply 157 0.00 0 0 0.00
library cache load lock 1 0.00 0 15 0.00
gc cr multi block request 69 0.00 0 0 0.00
latch: cache buffers chains 77 0.00 0 0 0.00
enq: TT - contention 98 0.00 0 0 0.00
gc cr block busy 23 0.00 0 1 0.00
ksdxexeotherwait 10,169 100.00 0 0 0.04
enq: IR - contention 20 0.00 0 0 0.00
log file single write 18 0.00 0 0 0.00
enq: TD - KTF dump entries 18 0.00 0 0 0.00
local write wait 3 0.00 0 1 0.00
PX qref latch 308 100.00 0 0 0.00
SQL*Net message to dblink 3,407 0.00 0 0 0.01
SQL*Net more data from dblink 84 0.00 0 0 0.00
latch: cache buffers lru chain 11 0.00 0 0 0.00
enq: PI - contention 8 0.00 0 0 0.00
SQL*Net more data from client 59 0.00 0 0 0.00
enq: TO - contention 6 0.00 0 0 0.00
enq: JS - job run lock - synchronize 4 0.00 0 0 0.00
enq: DR - contention 4 0.00 0 0 0.00
enq: MW - contention 4 0.00 0 0 0.00
db file single write 1 0.00 0 0 0.00
latch: redo allocation 4 0.00 0 0 0.00
enq: SW - contention 2 0.00 0 0 0.00
ges inquiry response 2 0.00 0 0 0.00
direct path write 5 0.00 0 0 0.00
SQL*Net message from client 1,263,880 0.00 128,154 101 5.27
gcs remote message 1,037,183 76.57 13,976 13 4.33
PX Idle Wait 4,893 71.55 9,578 1958 0.02
SQL*Net message from dblink 3,407 0.00 9,002 2642 0.01
Streams AQ: qmn slave idle wait 129 0.78 3,564 27627 0.00
virtual circuit status 120 100.00 3,516 29297 0.00
ASM background timer 759 0.00 3,509 4623 0.00
DIAG idle wait 18,274 0.00 3,506 192 0.08
ges remote message 62,924 95.25 3,505 56 0.26
Streams AQ: waiting for messages in the queue 740 97.30 3,500 4730 0.00
Streams AQ: qmn coordinator idle wait 265 48.30 3,492 13177 0.00
jobq slave wait 1,128 99.82 3,299 2924 0.00
wait for unread message on broadcast channel 3,282 99.54 3,191 972 0.01
KSV master wait 808 98.89 2,344 2901 0.00
class slave wait 19 57.89 1,174 61810 0.00
Streams AQ: waiting for time management or cleanup tasks 1 100.00 309 309352 0.00
PX Deq: Execution Msg 7,914 32.18 25 3 0.03
PX Deq: Msg Fragment 4,581 44.53 0 0 0.02
PX Deq: Execute Reply 138 42.03 0 1 0.00
PX Deq: Join ACK 177 36.72 0 0 0.00
PX Deq: Parse Reply 183 32.24 0 0 0.00
single-task message 1 0.00 0 40 0.00
Streams AQ: RAC qmn coordinator idle wait 266 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 241,061 0.00 91 0 1.01
events in waitclass Other 167,244 70.05 54 0 0.70
db file parallel write 19,740 0.00 7 0 0.08
os thread startup 55 0.00 2 34 0.00
control file sequential read 4,730 0.00 1 0 0.02
control file parallel write 1,578 0.00 1 0 0.01
gc current grant busy 87 0.00 0 2 0.00
latch: shared pool 48 0.00 0 4 0.00
gc cr block 2-way 540 0.00 0 0 0.00
db file sequential read 9 0.00 0 11 0.00
gc current block 2-way 312 0.00 0 0 0.00
enq: TM - contention 271 0.00 0 0 0.00
row cache lock 105 0.00 0 0 0.00
log file sequential read 18 0.00 0 1 0.00
library cache lock 32 0.00 0 0 0.00
log file single write 18 0.00 0 0 0.00
latch: library cache 3 0.00 0 1 0.00
enq: HW - contention 10 0.00 0 0 0.00
gc current grant 2-way 2 0.00 0 1 0.00
buffer busy waits 49 0.00 0 0 0.00
gc current multi block request 21 0.00 0 0 0.00
gc current block busy 2 0.00 0 1 0.00
latch: cache buffers chains 2 0.00 0 0 0.00
direct path write 2 0.00 0 0 0.00
rdbms ipc message 306,634 18.68 45,445 148 1.28
gcs remote message 1,037,188 76.57 13,976 13 4.33
ASM background timer 759 0.00 3,509 4623 0.00
DIAG idle wait 18,275 0.00 3,506 192 0.08
ges remote message 62,926 95.25 3,505 56 0.26
Streams AQ: qmn slave idle wait 126 0.00 3,505 27819 0.00
pmon timer 1,393 100.00 3,504 2515 0.01
smon timer 63 19.05 3,501 55579 0.00
Streams AQ: qmn coordinator idle wait 265 48.30 3,492 13177 0.00
class slave wait 16 50.00 1,160 72484 0.00
Streams AQ: waiting for time management or cleanup tasks 1 100.00 309 309352 0.00
PX Deq: Join ACK 27 44.44 0 1 0.00
KSV master wait 2 0.00 0 5 0.00
PX Deq: Parse Reply 28 39.29 0 0 0.00
PX Deq: Execute Reply 23 26.09 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 266 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 16,033
AVG_IDLE_TIME 342,846
AVG_IOWAIT_TIME 190
AVG_SYS_TIME 3,500
AVG_USER_TIME 12,423
BUSY_TIME 258,337
IDLE_TIME 5,487,330
IOWAIT_TIME 4,942
SYS_TIME 57,658
USER_TIME 200,679
LOAD 0
OS_CPU_WAIT_TIME 415,200
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 33,151,778,816
NUM_CPUS 16
NUM_CPU_CORES 8

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
zdcomora 24,102.80 1,241.40 15,207 211,676,423
SYS$USERS 42.10 23.10 3 306,906
SYS$BACKGROUND 0.00 0.00 50 102,721
zdcomoraXDB 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
zdcomora 18161 6255 11783 1739638 0 0 1264200 72
SYS$USERS 5 3 685 14 0 0 4060 3
SYS$BACKGROUND 82 26 317 212 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
2,375 0 1,718 1.38 9.84 84jtsaytwuj7s zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_CA_S...
2,322 11 49,382 0.05 9.62 1dk3s4t7krtba zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_L...
2,147 10 49,650 0.04 8.89 b8ba5qu9kamvv zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_A...
1,798 1 1 1797.66 7.45 dh3jwjjuvv05s oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A2"."O_LINENAME", "A2"...
1,664 13 47,524 0.04 6.89 73au7dwyj84gr zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_I...
1,599 9 1 1599.24 6.62 fntd7rg27f287 oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A1"."O_BUSNAME", "A1"....
1,382 1 1 1382.12 5.72 41xs2kx0w2ut9 oraclezdcomora2@ora02 (TNS V1-V3) SELECT "A2"."O_LINENAME", "A2"...
1,088 4 11,914 0.09 4.51 5c40vy9sk0gak zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_O...
1,011 9 1 1010.59 4.19 8ppv9jynjjmrr oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A1"."O_BUSNAME", "A1"....
919 0 1 919.49 3.81 d0a01dp25v1zy oraclezdcomora1@ora01 (TNS V1-V3) SELECT DISTINCT "A1"."O_NORMAL...
890 547 9,005 0.10 3.69 2a0ph5at9q6r5 zdcomddbagent@localhost.localdomain (TNS V1-V3) UPDATE T_DM_DDB201208 set O_BU...
797 0 1 797.02 3.30 gzxm11mcrwqhs oraclezdcomora2@ora02 (TNS V1-V3) SELECT "A3"."O_FILIALENAME", "...
683 0 1 682.67 2.83 b06t4cpf098j0 oraclezdcomora2@ora02 (TNS V1-V3) SELECT DISTINCT "A1"."O_NORMAL...
671 0 1 670.82 2.78 a4yac83c2jy30 oraclezdcomora1@ora01 (TNS V1-V3) SELECT DISTINCT "A1"."O_NORMAL...
643 1 1 642.68 2.66 c1dj399cdv6d2 oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A2"."O_LINENAME", "A2"...
596 0 1 596.30 2.47 2vrdr0swt308n oraclezdcomora2@ora02 (TNS V1-V3) SELECT "A3"."O_FILIALENAME", "...
557 0 2 278.57 2.31 1c69jk5t7zb3n oraclezdcomora2@ora02 (TNS V1-V3) SELECT DISTINCT "A1"."O_NORMAL...
503 1 1 502.95 2.08 0uxfkkxf9509b oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A2"."O_LINENAME", "A2"...
265 0 2 132.48 1.10 97dar9kxvy2b9 oraclezdcomora1@ora01 (TNS V1-V3) SELECT DISTINCT "A1"."O_NORMAL...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
547 890 9,005 0.06 3.69 2a0ph5at9q6r5 zdcomddbagent@localhost.localdomain (TNS V1-V3) UPDATE T_DM_DDB201208 set O_BU...
98 147 726,726 0.00 0.61 c8tgp3m6g0mw5 zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_F...
63 98 1 62.66 0.40 gmvhjssqt6jcq oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A1"."O_BUSNAME", "A1"....
57 89 1 57.46 0.37 4vxcbdffx7v5v oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A1"."O_BUSNAME", "A1"....
32 51 218 0.15 0.21 4mkxat916hu62 httpd@localhost.localdomain (TNS V1-V3) select o_xlmc, max(o_pbrq) fro...
24 37 2 11.93 0.15 379chut8hh1y7 oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A1"."O_BUSNAME", "A1"....
14 22 251 0.05 0.09 59bujuvt3914u zdcomddbagent@localhost.localdomain (TNS V1-V3) update T_DM_DDB201208 set O_RE...
13 1,664 47,524 0.00 6.89 73au7dwyj84gr zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_I...
11 2,322 49,382 0.00 9.62 1dk3s4t7krtba zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_L...
10 2,147 49,650 0.00 8.89 b8ba5qu9kamvv zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_A...
9 1,599 1 9.32 6.62 fntd7rg27f287 oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A1"."O_BUSNAME", "A1"....
9 1,011 1 9.24 4.19 8ppv9jynjjmrr oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A1"."O_BUSNAME", "A1"....
4 1,088 11,914 0.00 4.51 5c40vy9sk0gak zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_O...
1 503 1 0.77 2.08 0uxfkkxf9509b oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A2"."O_LINENAME", "A2"...
1 1,798 1 0.77 7.45 dh3jwjjuvv05s oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A2"."O_LINENAME", "A2"...
1 1,382 1 0.64 5.72 41xs2kx0w2ut9 oraclezdcomora2@ora02 (TNS V1-V3) SELECT "A2"."O_LINENAME", "A2"...
1 643 1 0.63 2.66 c1dj399cdv6d2 oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A2"."O_LINENAME", "A2"...
0 2,375 1,718 0.00 9.84 84jtsaytwuj7s zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_CA_S...
0 797 1 0.39 3.30 gzxm11mcrwqhs oraclezdcomora2@ora02 (TNS V1-V3) SELECT "A3"."O_FILIALENAME", "...
0 265 2 0.09 1.10 97dar9kxvy2b9 oraclezdcomora1@ora01 (TNS V1-V3) SELECT DISTINCT "A1"."O_NORMAL...
0 596 1 0.16 2.47 2vrdr0swt308n oraclezdcomora2@ora02 (TNS V1-V3) SELECT "A3"."O_FILIALENAME", "...
0 683 1 0.09 2.83 b06t4cpf098j0 oraclezdcomora2@ora02 (TNS V1-V3) SELECT DISTINCT "A1"."O_NORMAL...
0 671 1 0.08 2.78 a4yac83c2jy30 oraclezdcomora1@ora01 (TNS V1-V3) SELECT DISTINCT "A1"."O_NORMAL...
0 919 1 0.08 3.81 d0a01dp25v1zy oraclezdcomora1@ora01 (TNS V1-V3) SELECT DISTINCT "A1"."O_NORMAL...
0 557 2 0.01 2.31 1c69jk5t7zb3n oraclezdcomora2@ora02 (TNS V1-V3) SELECT DISTINCT "A1"."O_NORMAL...

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
126,273,678 9,005 14,022.62 59.53 546.73 890.25 2a0ph5at9q6r5 zdcomddbagent@localhost.localdomain (TNS V1-V3) UPDATE T_DM_DDB201208 set O_BU...
13,551,079 1 13,551,079.00 6.39 62.66 97.77 gmvhjssqt6jcq oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A1"."O_BUSNAME", "A1"....
13,550,221 1 13,550,221.00 6.39 57.46 89.48 4vxcbdffx7v5v oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A1"."O_BUSNAME", "A1"....
10,795,957 726,726 14.86 5.09 98.21 147.17 c8tgp3m6g0mw5 zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_F...
3,496,847 251 13,931.66 1.65 13.50 22.07 59bujuvt3914u zdcomddbagent@localhost.localdomain (TNS V1-V3) update T_DM_DDB201208 set O_RE...
2,990,221 2 1,495,110.50 1.41 9.89 15.68 6u5vf6468t51n oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A1"."O_DATE", "A1"."O_...
2,101,404 2 1,050,702.00 0.99 23.86 36.92 379chut8hh1y7 oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A1"."O_BUSNAME", "A1"....
1,504,910 1 1,504,910.00 0.71 9.32 1599.24 fntd7rg27f287 oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A1"."O_BUSNAME", "A1"....
1,487,271 1 1,487,271.00 0.70 9.24 1010.59 8ppv9jynjjmrr oraclezdcomora1@ora01 (TNS V1-V3) SELECT "A1"."O_BUSNAME", "A1"....
1,004,171 47,524 21.13 0.47 13.20 1664.02 73au7dwyj84gr zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_I...

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
10,577 1 10,577.00 69.30 1.04 12.63 2d4997td63ctu oraclezdcomora1@ora01 (TNS V1-V3) SELECT DISTINCT "A1"."O_NORMAL...
857 47,524 0.02 5.61 13.20 1664.02 73au7dwyj84gr zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_I...
588 29,109 0.02 3.85 8.36 8.74 5gd1br52bdc0k zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_D...
174 11,914 0.01 1.14 4.07 1088.09 5c40vy9sk0gak zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_O...
42 9,309 0.00 0.28 1.75 1.92 as0scjdgw8h5h zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_SEND...
22 1,718 0.01 0.14 0.45 2375.18 84jtsaytwuj7s zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_CA_S...
7 1 7.00 0.05 0.01 0.02 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
7 9,005 0.00 0.05 546.73 890.25 2a0ph5at9q6r5 zdcomddbagent@localhost.localdomain (TNS V1-V3) UPDATE T_DM_DDB201208 set O_BU...
3 57 0.05 0.02 0.03 0.03 04xtrk7uyhknh   select obj#, type#, ctime, mti...
3 6 0.50 0.02 0.03 0.04 6v5w9k2k7m5b3 OMS SELECT credential_set_column, ...

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
726,726 723,172 1.00 0.00 0.00 c8tgp3m6g0mw5 zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_F...
49,650 49,581 1.00 0.00 0.04 b8ba5qu9kamvv zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_A...
49,382 49,334 1.00 0.00 0.05 1dk3s4t7krtba zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_L...
47,524 45,576 0.96 0.00 0.04 73au7dwyj84gr zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_I...
29,109 26,157 0.90 0.00 0.00 5gd1br52bdc0k zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_D...
17,945 17,920 1.00 0.00 0.00 byjfsrn96m568 zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_A...
11,914 11,905 1.00 0.00 0.09 5c40vy9sk0gak zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_O...
10,179 10,180 1.00 0.00 0.00 7gtztzv329wg0   select c.name, u.name from co...
9,309 9,309 1.00 0.00 0.00 as0scjdgw8h5h zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_SEND...
9,309 9,309 1.00 0.00 0.00 fxvw7arf33nba zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_T...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
10,180 10,179 26.97 7gtztzv329wg0   select c.name, u.name from co...
655 655 1.74 bsa0wjtftg3uw   select file# from file$ where ...
580 579 1.54 grwydz59pu6mc   select text from view$ where r...
522 0 1.38 g5mxy4vcrwy1y emagent@ora01 (TNS V1-V3) /* OracleOEM */ SELEC...
512 512 1.36 5zuzmh83csg6t httpd@localhost.localdomain (TNS V1-V3) ALTER SESSION SET NLS_DATE_FOR...
434 434 1.15 6rm31asvubywx OMS alter session set NLS_NUMERIC_...
434 434 1.15 a4ct9tx8f9d4a OMS begin execute immediate 'alter...
402 402 1.06 6129566gyvx21 OEM.SystemPool SELECT INSTANTIABLE, supertyp...
218 218 0.58 4mkxat916hu62 httpd@localhost.localdomain (TNS V1-V3) select o_xlmc, max(o_pbrq) fro...
204 204 0.54 350f5yrnnmshs   lock table sys.mon_mods$ in ex...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
920.17 42.86 2,147.00 10.43 49,650 b8ba5qu9kamvv zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_A...
919.79 38.72 2,375.18 0.45 1,718 84jtsaytwuj7s zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_CA_S...
919.67 55.27 1,664.02 13.20 47,524 73au7dwyj84gr zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_I...
919.63 39.60 2,322.24 11.36 49,382 1dk3s4t7krtba zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_L...
919.59 84.51 1,088.09 4.07 11,914 5c40vy9sk0gak zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_O...
1.38 10.93 12.63 1.04 1 2d4997td63ctu oraclezdcomora1@ora01 (TNS V1-V3) SELECT DISTINCT "A1"."O_NORMAL...
0.67 0.46 147.17 98.21 726,726 c8tgp3m6g0mw5 zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_F...
0.20 0.02 890.25 546.73 9,005 2a0ph5at9q6r5 zdcomddbagent@localhost.localdomain (TNS V1-V3) UPDATE T_DM_DDB201208 set O_BU...
0.10 33.43 0.29 0.27 110 cydnuss99swtd OEM.SystemPool BEGIN EM_PING.RECORD_BATCH_HEA...
0.06 0.74 8.74 8.36 29,109 5gd1br52bdc0k zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_D...
0.04 0.07 51.40 32.49 218 4mkxat916hu62 httpd@localhost.localdomain (TNS V1-V3) select o_xlmc, max(o_pbrq) fro...
0.02 0.11 22.07 13.50 251 59bujuvt3914u zdcomddbagent@localhost.localdomain (TNS V1-V3) update T_DM_DDB201208 set O_RE...
0.02 0.56 3.28 3.18 17,945 byjfsrn96m568 zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_JK_A...
0.01 0.52 1.92 1.75 9,309 as0scjdgw8h5h zdcomddbagent@localhost.localdomain (TNS V1-V3) INSERT /*+APPEND*/ INTO T_SEND...
0.01 15.11 0.07 0.07 549 3c1kubcdjnppq   update sys.col_usage$ set eq...
0.01 35.03 0.02 0.02 66 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...
0.01 21.89 0.03 0.03 57 04xtrk7uyhknh   select obj#, type#, ctime, mti...

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
0uxfkkxf9509b SELECT "A2"."O_LINENAME", "A2"."O_LINENO", "A2"."O_TERMINALNO", "A2"."O_BUSNAME", "A2"."O_DRIVERNO", "A2"."O_ARRIVEDATETIME", "A2"."O_ARRIVEDATE", "A2"."O_ARRIVETIME", "A2"."O_LEAVEDATETIME", "A2"."O_LEAVEDATE", "A2"."O_LEAVETIME", "A2"."O_RUNSTATUS", "A2"."O_MIDDOOR", "A2"."O_REARDOOR", "A2"."O_FRONTDOOR", "A2"."O_UP", "A2"."O_RUN", "A2"."O_STATIONNO", "A2"."O_ONNUM", "A2"."O_OFFNUM", "A2"."O_HISTORYDATA", "A2"."O_TRIGGERTYPE", "A2"."O_RESERVED", "A2"."O_SENDTIME", "A2"."O_RECEIVETIME", "A1"."O_LINENO", "A1"."O_STATIONNAME", "A1"."O_STATIONNO", "A1"."O_DIRECTION", DECODE("A2"."O_UP", 0, '上行', 1, '下行'), DECODE("A2"."O_RESERVED", 0, '正常', 1, '无效：不在线路列表', 2, '无效：不在线路列表', 3, '无效：数据包时间与系统时间差大于预设参数', 4, '无效：数据包时间与系统时间差小于预设参数', 5, '无效：GPS全零', 6, '无效：纬度大于范围', 7, '无效：经度大于范围', 10, '无效：无线路信息', 99, '历史数据'), CASE WHEN "A2"."O_RUNSTATUS"=0 THEN '未运营' ELSE '运营中' END , ROUND(("A2"."O_LEAVEDATETIME"-"A2"."O_ARRIVEDATETIME")*24*60*60) FROM "T_JK_LEAVESTATION20120807" "A2", "T_DM_STATIONINF" "A1" WHERE ROUND(("A2"."O_LEAVEDATETIME"-"A2"."O_ARRIVEDATETIME")*24*60*60)<9 AND "A2"."O_UP"="A1"."O_DIRECTION"(+) AND "A2"."O_STATIONNO"="A1"."O_STATIONNO"(+) AND "A2"."O_LINENO"="A1"."O_LINENO"(+) AND "A2"."O_LINENAME"='512' AND ("A2"."O_RESERVED"='0' OR "A2"."O_RESERVED"='1' OR "A2"."O_RESERVED"='2' OR "A2"."O_RESERVED"='3' OR "A2"."O_RESERVED"='4' OR "A2"."O_RESERVED"='5' OR "A2"."O_RESERVED"='6' OR "A2"."O_RESERVED"='7' OR "A2"."O_RESERVED"='10' OR "A2"."O_RESERVED"='99') AND "A2"."O_LEAVETIME"&g t;='00:00:00' AND "A2"."O_LEAVETIME"<='23:59:00' ORDER BY "A2"."O_LEAVETIME"
1c69jk5t7zb3nSELECT DISTINCT "A1"."O_NORMALSPEED" FROM "T_JK_OVERSPEED201208" "A1" WHERE "A1"."O_LINENAME"='296' AND "A1"."O_DATE"='2012-08-06' AND "A1"."O_FLAG"='0' ORDER BY "A1"."O_NORMALSPEED" DESC
1dk3s4t7krtbaINSERT /*+APPEND*/ INTO T_JK_LEAVESTATION20120807 (O_LINENO, O_LINENAME, O_TERMINALNO, O_BUSNAME, O_DRIVERNO, O_ARRIVEDATETIME, O_ARRIVEDATE, O_ARRIVETIME, O_LEAVEDATETIME, O_LEAVEDATE, O_LEAVETIME, O_RUNSTATUS, O_MIDDOOR, O_REARDOOR, O_FRONTDOOR, O_UP, O_RUN, O_STATIONNO, O_ONNUM, O_OFFNUM, O_RESERVED, O_TRIGGERTYPE, O_HISTORYDATA, O_SENDTIME, O_RECEIVETIME) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)
2a0ph5at9q6r5UPDATE T_DM_DDB201208 set O_BUSNO_JH = :1, O_JHFCSJC_JH = :2, O_JHFCSJC_DD = :3, O_SJFCSJC = :4, O_JHDDSJC_DD = :5, O_SJDDSJC = :6, O_GH_JH = :7, O_CWY_Q_ID_JH = :8, O_CWY_Z_ID_JH = :9, O_CWY_H_ID_JH = :10, O_RUNTYPE_JH = :11, O_RECORD_STATE = :12, O_GLGS = :13, O_BUSNO = :14, O_TJRQ = :15, O_IS_CHANGELINE = :16, O_LINENO_TJ = :17, O_LINENO_SRC = :18, O_BC = :19, O_BB = :20, O_BCBS = :21, O_TC = :22, O_GH = :23, O_CWY_Q_ID = :24, O_CWY_Z_ID = :25, O_CWY_H_ID = :26, O_FCZD = :27, O_DDZD = :28, O_SCDDSJC = :29, O_RUNTYPE = :30, O_RUNTIMESCOEF = :31, O_ISEMPTY = :32, O_YXGL = :33, O_XLMC = :34, O_CLMC = :35, O_SJ = :36, O_CWY_H_NAME = :37, O_CWY_Q_NAME = :38, O_CWY_Z_NAME = :39, O_FCZDNAME = :40, O_DDZDNAME = :41, O_DOWNLINE = :42, O_JHFCSJC = :43, O_JHFCSJ = :44, O_JHDDSJ = :45, O_SJFCSJ = :46, O_SJDDSJ = :47, O_SCDDRQ = :48, O_SCDDSJ = :49, O_RUNTYPEFLAG = :50, O_YXLX = :51, O_SJYXGL = :52, O_MANUALTAG = :53, O_SCMDKIND = :54, O_ECMDKIND = :55, O_MAKEUP = :56, O_MANUALTAG_REASION = :57, O_ISCROSS = :58, O_CROSSSTATION = :59, O_JHBC = :60, O_YSJHTC = :61, O_JHTC = :62 where O_RQ = :63 and O_LINENO = :64 and O_YXFX = :65 and O_INDEX = :66
2d4997td63ctuSELECT DISTINCT "A1"."O_NORMALSPEED" FROM "T_JK_OVERSPEED201207" "A1" WHERE "A1"."O_LINENAME"='9' AND "A1"."O_DATE"='2012-07-20' AND "A1"."O_FLAG"='0' ORDER BY "A1"."O_NORMALSPEED" DESC
2vrdr0swt308nSELECT "A3"."O_FILIALENAME", "A2"."O_LINENAME", "A2"."O_BUSNAME", "A2"."O_DATE", "A2"."O_TIME", 1, DECODE("A2"."O_UP", 1, '下行', '上行'), "A2"."O_STATIONNO", "A1"."O_STATIONNAME" FROM "T_DM_LINEID" "A3", "T_JK_ARRIVESTATION20120807" "A2", "T_DM_STATIONINF" "A1" WHERE "A3"."O_LINENAME"='290' AND "A3"."O_LINENAME"="A2"."O_LINENAME" AND "A1"."O_LINENAME"="A3"."O_LINENAME" AND "A1"."O_STATIONNO"="A2"."O_STATIONNO" AND "A1"."O_DIRECTION"="A2"."O_UP" AND "A2"."O_DATE"='2012-08-07' AND "A2"."O_STATIONNO"=3 AND "A2"."O_UP"=0 AND "A2"."O_TIME">='07:00' AND "A2"."O_TIME"<='10:00' ORDER BY "A2"."O_TIME"
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
379chut8hh1y7SELECT "A1"."O_BUSNAME", "A1"."O_LINENAME" FROM "T_DM_BUSID" "A1" WHERE "A1"."O_BUSNAME"<>ALL (SELECT DISTINCT "A3"."O_CLMC" FROM "T_DM_DDB201208" "A3" WHERE "A3"."O_XLMC"=ANY (SELECT "A4"."O_LINENAME" FROM "T_DM_LINEID" "A4" WHERE "A4"."O_FILIALENAME"='一公司') AND "A3"."O_RQ"='2012-08-06' AND "A3"."O_SJFCSJ" IS NOT NULL AND "A3"."O_SJFCSJ">='00:00' AND "A3"."O_SJFCSJ"<='23:59') AND "A1"."O_LINENAME"=ANY (SELECT "A2"."O_LINENAME" FROM "T_DM_LINEID" "A2" WHERE "A2"."O_FILIALENAME"='一公司') ORDER BY "A1"."O_LINENAME"
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
41xs2kx0w2ut9 SELECT "A2"."O_LINENAME", "A2"."O_LINENO", "A2"."O_TERMINALNO", "A2"."O_BUSNAME", "A2"."O_DATETIME", "A2"."O_DATE", "A2"."O_TIME", "A2"."O_RUNSTATUS", "A2"."O_MIDDOOR", "A2"."O_REARDOOR", "A2"."O_FRONTDOOR", "A2"."O_UP", "A2"."O_RUN", "A2"."O_STATIONNO", "A2"."O_HISTORYDATA", "A2"."O_TRIGGERTYPE", "A2"."O_RESERVED", "A2"."O_SENDTIME", "A2"."O_RECEIVETIME", "A1"."O_LINENO", "A1"."O_STATIONNAME", "A1"."O_STATIONNO", "A1"."O_DIRECTION", DECODE("A2"."O_UP", 0, '上行', 1, '下行'), DECODE("A2"."O_RESERVED", 0, '正常', 1, '无效：不在线路列表', 2, '无效：不在线路列表', 3, '无效：数据包时间与系统时间差大于预设参数', 4, '无效：数据包时间与系统时间差小于预设参数', 5, '无效：GPS全零', 6, '无效：纬度大于范围', 7, '无效：经度大于范围', 10, '无效：无线路信息', 99, '历史数据'), CASE WHEN "A2"."O_RUNSTATUS"=0 THEN '未运营' ELSE '运营中' END FROM "T_JK_ARRIVESTATION20120807" "A2", "T_DM_STATIONINF" "A1" WHERE "A2"."O_UP"="A1"."O_DIRECTION"(+) AND "A2"."O_STATIONNO"="A1"."O_STATIONNO"(+) AND "A2"."O_LINENO"="A1"."O_LINENO"(+) AND "A2"."O_LINENAME"='537' AND "A2"."O_BUSNAME"='5072' AND "A2"."O_TIME">='00:00:00' AND "A2"."O_TIME"<='23:59:00' AND ("A2"."O_RESERVED"='0' OR "A2"."O_RESERVED"='1' OR "A2"."O_RESERVED"='2' OR "A2"."O_RESERVED"='3' OR "A2"."O_RESERVED"='4' OR "A2"."O_RESERVED"='5' OR "A2"."O_RESERVED"='6' OR "A2"."O_RESERVED"='7' OR "A2"."O_RESERVED"='10' OR "A2"."O_RESERVED"='99') ORDER BY "A2"."O_TIME"
4mkxat916hu62select o_xlmc, max(o_pbrq) from T_DM_PAIBAN group by o_xlmc having max(o_pbrq)>'1991-01-01'
4vxcbdffx7v5vSELECT "A1"."O_BUSNAME", "A1"."O_LINENAME" FROM "T_DM_BUSID" "A1" WHERE "A1"."O_BUSNAME"<>ALL (SELECT DISTINCT "A3"."O_CLMC" FROM "T_DM_DDB201208" "A3" WHERE "A3"."O_XLMC"=ANY (SELECT "A4"."O_LINENAME" FROM "T_DM_LINEID" "A4" WHERE "A4"."O_FILIALENAME"='一公司') AND "A3"."O_RQ"='2012-08-07' AND "A3"."O_SJFCSJ" IS NOT NULL AND "A3"."O_SJFCSJ">='05:30' AND "A3"."O_SJFCSJ"<='09:02') AND "A1"."O_LINENAME"=ANY (SELECT "A2"."O_LINENAME" FROM "T_DM_LINEID" "A2" WHERE "A2"."O_FILIALENAME"='一公司') ORDER BY "A1"."O_LINENAME"
59bujuvt3914uupdate T_DM_DDB201208 set O_RECORD_STATE =:V1 where O_RQ=:V2 and O_LINENO=:V3 and O_YXFX=:V4 and O_INDEX=:V5
5c40vy9sk0gakINSERT /*+APPEND*/ INTO T_JK_OVERSPEED201208(O_LINENO, O_LINENAME, O_TERMINALNO, O_BUSNAME, O_DATETIME, O_DATE, O_TIME, O_LONGITUDE, O_LATITUDE, O_SPEED, O_DIRECTION, O_HEIGHT, O_RUNSTATUS, O_MIDDOOR, O_REARDOOR, O_FRONTDOOR, O_UP, O_RUN, O_NORMALSPEED, O_FLAG, O_TIMETAKEN, O_PRESTATIONNO, O_RESERVED, O_HISTORYDATA, O_DRIVERNO) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)
5gd1br52bdc0kINSERT /*+APPEND*/ INTO T_JK_DOORWARNING201208 (O_LINENO, O_LINENAME, O_TERMINALNO, O_BUSNAME, O_DATETIME, O_DATE, O_TIME, O_LONGITUDE, O_LATITUDE, O_SPEED, O_DIRECTION, O_RUNSTATUS, O_MIDDOOR, O_REARDOOR, O_FRONTDOOR, O_UP, O_RUN, O_FLAG, O_PRESTATIONNO, O_HISTORYDATA) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20)
5zuzmh83csg6tALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD'
6129566gyvx21SELECT INSTANTIABLE, supertype_owner, supertype_name, LOCAL_ATTRIBUTES FROM all_types WHERE type_name = :1 AND owner = :2
6rm31asvubywxalter session set NLS_NUMERIC_CHARACTERS = '., '
6u5vf6468t51nSELECT "A1"."O_DATE", "A1"."O_LINENAME", "A1"."O_BUSNAME", COUNT(*) FROM "T_JK_FULLGPSDATA20120807" "A1" WHERE "A1"."O_DATE"=NVL(:1, :2) AND "A1"."O_LINENAME"=SYS_OP_C2C(:3) GROUP BY "A1"."O_DATE", "A1"."O_LINENAME", "A1"."O_BUSNAME"
6v5w9k2k7m5b3SELECT credential_set_column, decode(credential_value, null, null, decrypt(credential_value)) "VALUE" FROM MGMT_TARGET_CREDENTIALS tc, MGMT_CREDENTIALS2 c, MGMT_TARGETS t WHERE t.target_guid=tc.target_guid AND tc.credential_guid=c.credential_guid AND t.target_name=:1 AND t.target_type=:2 AND tc.credential_set_name=:3 AND tc.user_name=:4 ORDER BY credential_set_column
73au7dwyj84grINSERT /*+APPEND*/ INTO T_JK_INSTRUCTREPLY201208 (O_LINENO, O_LINENAME, O_TERMINALNO, O_BUSNAME, O_INSTRUCTDATETIME, O_DATE, O_TIME, O_LONGITUDE, O_LATITUDE, O_INSTRUCTNO, O_ACKINSTRUCT) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)
7gtztzv329wg0select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
84jtsaytwuj7sINSERT /*+APPEND*/ INTO T_CA_STARTENDINF201208(O_TERMINALNO, O_BUSNAME, O_LINENO, O_LINENAME, O_UP , O_SSTATIONNO, O_SSTATIONNOC, O_SSTATIONNAME, O_STARTTIME, O_SDATE, O_STIME, O_SCMDKIND, O_RUNNUMBER, O_BANNUMBER, O_DOWNLINE) VALUES (:V1, :V2, :V3, :V4, :V5, :V6, :V7, :V8, :V9, :V10, :V11, :V12, :V13, :V14, :V15)
8ppv9jynjjmrr SELECT "A1"."O_BUSNAME", "A1"."O_LINENAME", "A1"."O_DATE", "A1"."O_TIME", DECODE("A1"."O_RUN", 0, '未运营', 1, '运营中'), "A1"."O_LONGITUDE", "A1"."O_LATITUDE", "A1"."O_SPEED", DECODE("A1"."O_UP", 0, '上行', 1, '下行'), (SELECT "A2"."O_STATIONNAME" FROM "T_DM_STATIONINF" "A2" WHERE "A1"."O_LINENAME"="A2"."O_LINENAME" AND "A1"."O_UP"="A2"."O_DIRECTION" AND ("A1"."O_NEXTSTATIONNO">1 AND "A1"."O_NEXTSTATIONNO"-1="A2"."O_STATIONNO" OR "A1"."O_NEXTSTATIONNO"<=1 AND "A2"."O_STATIONNO"=1)), "A1"."O_DISTANCE", "A1"."O_INDOORTEMP", "A1"."O_MOTORTEMP", "A1"."O_FRONTDOOR", "A1"."O_MIDDOOR", "A1"."O_REARDOOR", "A1"."O_DIRECTION", "A1"."O_HEIGHT", DECODE("A1"."O_RESERVED", 0, '正常', 1, '无效：不在线路列表', 2, '无效：不在线路列表', 3, '无效：数据包时间与系统时间差大于预设参数', 4, '无效：数据包时间与系统时间差小于预设参数', 5, '无效：GPS全零', 6, '无效：纬度大于范围', 7, '无效：经度大于范围', 10, '无效：无线路信息', 99, '历史数据'), DECODE("A1"."O_HISTORYDATA", 1, '历史数据', 0, '非历史数据') FROM "T_JK_FULLGPSDATA20120807" "A1" WHERE "A1"."O_LINENAME"='507' AND "A1"."O_BUSNAME"='2876' AND "A1"."O_TIME">='00:00:00' AND "A1"."O_TIME"<='23:59:00' AND ("A1"."O_RESERVED"='0' OR "A1"."O_RESERVED"='1' OR "A1"."O_RESERVED"='2' OR "A1"."O_RESERVED"='3' OR "A1"."O_RESERVED"='4' OR "A1"."O_RESERVED"='5' OR "A1"."O_RESERVED"='6' OR "A1"."O_RESERVED"='7' OR "A1"."O_RESERVED"='10' OR "A1"."O_RESERVED"='99') ORDER BY "A1"."O_TIME"
97dar9kxvy2b9SELECT DISTINCT "A1"."O_NORMALSPEED" FROM "T_JK_OVERSPEED201208" "A1" WHERE "A1"."O_LINENAME"='535' AND "A1"."O_DATE"='2012-08-07' AND "A1"."O_FLAG"='0' ORDER BY "A1"."O_NORMALSPEED" DESC
9qgtwh66xg6nzupdate seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
a4ct9tx8f9d4abegin execute immediate 'alter session set NLS_NUMERIC_CHARACTERS = ''., '''; end;
a4yac83c2jy30SELECT DISTINCT "A1"."O_NORMALSPEED" FROM "T_JK_OVERSPEED201208" "A1" WHERE "A1"."O_LINENAME"='537' AND "A1"."O_DATE"='2012-08-07' AND "A1"."O_FLAG"='0' ORDER BY "A1"."O_NORMALSPEED" DESC
as0scjdgw8h5hINSERT /*+APPEND*/ INTO T_SENDINSTRUCT201208 (O_INSTRUCTNO, O_USERNO, O_CMD, O_CMDORDER, O_LINENO, O_LINENAME, O_TERMINALNO, O_BUSNAME , O_LINKDATETIME, O_LINKDATE, O_LINKTIME , O_ITEMNUM)VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
b06t4cpf098j0SELECT DISTINCT "A1"."O_NORMALSPEED" FROM "T_JK_OVERSPEED201208" "A1" WHERE "A1"."O_LINENAME"='615' AND "A1"."O_DATE"='2012-08-07' AND "A1"."O_FLAG"='0' ORDER BY "A1"."O_NORMALSPEED" DESC
b8ba5qu9kamvvINSERT /*+APPEND*/ INTO T_JK_ARRIVESTATION20120807 (O_LINENO, O_LINENAME, O_TERMINALNO, O_BUSNAME, O_DATETIME, O_DATE, O_TIME, O_RUNSTATUS, O_MIDDOOR, O_REARDOOR, O_FRONTDOOR, O_UP, O_RUN, O_STATIONNO, O_RESERVED, O_TRIGGERTYPE, O_HISTORYDATA, O_SENDTIME, O_RECEIVETIME)VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19)
bsa0wjtftg3uwselect file# from file$ where ts#=:1
byjfsrn96m568INSERT /*+APPEND*/ INTO T_JK_ARRIVELEAVEPOINT20120807 (O_LINENO, O_LINENAME, O_TERMINALNO, O_BUSNAME, O_TIMELABEL, O_DATE, O_TIME, O_LONGITUDE, O_LATITUDE, O_SPEED, O_DIRECTION, O_HEIGHT, O_POINTTYPE, O_POINTNO, O_ARRIVELEAVE, O_TRIGGERTYPE, O_HISTORYDATA) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)
c1dj399cdv6d2 SELECT "A2"."O_LINENAME", "A2"."O_LINENO", "A2"."O_TERMINALNO", "A2"."O_BUSNAME", "A2"."O_DATETIME", "A2"."O_DATE", "A2"."O_TIME", "A2"."O_RUNSTATUS", "A2"."O_MIDDOOR", "A2"."O_REARDOOR", "A2"."O_FRONTDOOR", "A2"."O_UP", "A2"."O_RUN", "A2"."O_STATIONNO", "A2"."O_HISTORYDATA", "A2"."O_TRIGGERTYPE", "A2"."O_RESERVED", "A2"."O_SENDTIME", "A2"."O_RECEIVETIME", "A1"."O_LINENO", "A1"."O_STATIONNAME", "A1"."O_STATIONNO", "A1"."O_DIRECTION", DECODE("A2"."O_UP", 0, '上行', 1, '下行'), DECODE("A2"."O_RESERVED", 0, '正常', 1, '无效：不在线路列表', 2, '无效：不在线路列表', 3, '无效：数据包时间与系统时间差大于预设参数', 4, '无效：数据包时间与系统时间差小于预设参数', 5, '无效：GPS全零', 6, '无效：纬度大于范围', 7, '无效：经度大于范围', 10, '无效：无线路信息', 99, '历史数据'), CASE WHEN "A2"."O_RUNSTATUS"=0 THEN '未运营' ELSE '运营中' END FROM "T_JK_ARRIVESTATION20120807" "A2", "T_DM_STATIONINF" "A1" WHERE "A2"."O_UP"="A1"."O_DIRECTION"(+) AND "A2"."O_STATIONNO"="A1"."O_STATIONNO"(+) AND "A2"."O_LINENO"="A1"."O_LINENO"(+) AND "A2"."O_LINENAME"='537' AND "A2"."O_BUSNAME"='5047' AND "A2"."O_TIME">='00:00:00' AND "A2"."O_TIME"<='23:59:00' AND ("A2"."O_RESERVED"='0' OR "A2"."O_RESERVED"='1' OR "A2"."O_RESERVED"='2' OR "A2"."O_RESERVED"='3' OR "A2"."O_RESERVED"='4' OR "A2"."O_RESERVED"='5' OR "A2"."O_RESERVED"='6' OR "A2"."O_RESERVED"='7' OR "A2"."O_RESERVED"='10' OR "A2"."O_RESERVED"='99') ORDER BY "A2"."O_TIME"
c8tgp3m6g0mw5INSERT /*+APPEND*/ INTO T_JK_FULLGPSDATA20120807 (O_LINENO, O_LINENAME, O_TERMINALNO, O_BUSNAME, O_GPSDATETIME, O_DATE, O_TIME, O_LONGITUDE, O_LATITUDE, O_SPEED, O_DIRECTION, O_HEIGHT, O_RUNSTATUS, O_MIDDOOR, O_REARDOOR, O_FRONTDOOR, O_UP, O_RUN, O_NEXTSTATIONNO, O_MOTORTEMP, O_INDOORTEMP, O_DISTANCE, O_RESERVED, O_HISTORYDATA, O_SENDTIME, O_RECEIVETIME, O_TOTALMILE) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27)
cydnuss99swtdBEGIN EM_PING.RECORD_BATCH_HEARTBEAT(:1, :2, :3); END;
d0a01dp25v1zySELECT DISTINCT "A1"."O_NORMALSPEED" FROM "T_JK_OVERSPEED201208" "A1" WHERE "A1"."O_LINENAME"='291' AND "A1"."O_DATE"='2012-08-07' AND "A1"."O_FLAG"='0' ORDER BY "A1"."O_NORMALSPEED" DESC
dh3jwjjuvv05s SELECT "A2"."O_LINENAME", "A2"."O_LINENO", "A2"."O_TERMINALNO", "A2"."O_BUSNAME", "A2"."O_DRIVERNO", "A2"."O_ARRIVEDATETIME", "A2"."O_ARRIVEDATE", "A2"."O_ARRIVETIME", "A2"."O_LEAVEDATETIME", "A2"."O_LEAVEDATE", "A2"."O_LEAVETIME", "A2"."O_RUNSTATUS", "A2"."O_MIDDOOR", "A2"."O_REARDOOR", "A2"."O_FRONTDOOR", "A2"."O_UP", "A2"."O_RUN", "A2"."O_STATIONNO", "A2"."O_ONNUM", "A2"."O_OFFNUM", "A2"."O_HISTORYDATA", "A2"."O_TRIGGERTYPE", "A2"."O_RESERVED", "A2"."O_SENDTIME", "A2"."O_RECEIVETIME", "A1"."O_LINENO", "A1"."O_STATIONNAME", "A1"."O_STATIONNO", "A1"."O_DIRECTION", DECODE("A2"."O_UP", 0, '上行', 1, '下行'), DECODE("A2"."O_RESERVED", 0, '正常', 1, '无效：不在线路列表', 2, '无效：不在线路列表', 3, '无效：数据包时间与系统时间差大于预设参数', 4, '无效：数据包时间与系统时间差小于预设参数', 5, '无效：GPS全零', 6, '无效：纬度大于范围', 7, '无效：经度大于范围', 10, '无效：无线路信息', 99, '历史数据'), CASE WHEN "A2"."O_RUNSTATUS"=0 THEN '未运营' ELSE '运营中' END , ROUND(("A2"."O_LEAVEDATETIME"-"A2"."O_ARRIVEDATETIME")*24*60*60) FROM "T_JK_LEAVESTATION20120807" "A2", "T_DM_STATIONINF" "A1" WHERE "A2"."O_UP"="A1"."O_DIRECTION"(+) AND "A2"."O_STATIONNO"="A1"."O_STATIONNO"(+) AND "A2"."O_LINENO"="A1"."O_LINENO"(+) AND "A2"."O_LINENAME"='537' AND ("A2"."O_RESERVED"='0' OR "A2"."O_RESERVED"='1' OR "A2"."O_RESERVED"='2' OR "A2"."O_RESERVED"='3' OR "A2"."O_RESERVED"='4' OR "A2"."O_RESERVED"='5' OR "A2"."O_RESERVED"='6' OR "A2"."O_RESERVED"='7' OR "A2"."O_RESERVED"='10' OR "A2"."O_RESERVED"='99') AND "A2"."O_LEAVETIME">='00:00:00' AND "A2"."O_LEAVETIME"<='23:59:00' ORDER BY "A2"."O_LEAVE TIME"
fntd7rg27f287 SELECT "A1"."O_BUSNAME", "A1"."O_LINENAME", "A1"."O_DATE", "A1"."O_TIME", DECODE("A1"."O_RUN", 0, '未运营', 1, '运营中'), "A1"."O_LONGITUDE", "A1"."O_LATITUDE", "A1"."O_SPEED", DECODE("A1"."O_UP", 0, '上行', 1, '下行'), (SELECT "A2"."O_STATIONNAME" FROM "T_DM_STATIONINF" "A2" WHERE "A1"."O_LINENAME"="A2"."O_LINENAME" AND "A1"."O_UP"="A2"."O_DIRECTION" AND ("A1"."O_NEXTSTATIONNO">1 AND "A1"."O_NEXTSTATIONNO"-1="A2"."O_STATIONNO" OR "A1"."O_NEXTSTATIONNO"<=1 AND "A2"."O_STATIONNO"=1)), "A1"."O_DISTANCE", "A1"."O_INDOORTEMP", "A1"."O_MOTORTEMP", "A1"."O_FRONTDOOR", "A1"."O_MIDDOOR", "A1"."O_REARDOOR", "A1"."O_DIRECTION", "A1"."O_HEIGHT", DECODE("A1"."O_RESERVED", 0, '正常', 1, '无效：不在线路列表', 2, '无效：不在线路列表', 3, '无效：数据包时间与系统时间差大于预设参数', 4, '无效：数据包时间与系统时间差小于预设参数', 5, '无效：GPS全零', 6, '无效：纬度大于范围', 7, '无效：经度大于范围', 10, '无效：无线路信息', 99, '历史数据'), DECODE("A1"."O_HISTORYDATA", 1, '历史数据', 0, '非历史数据') FROM "T_JK_FULLGPSDATA20120807" "A1" WHERE "A1"."O_LINENAME"='606' AND "A1"."O_BUSNAME"='6142' AND "A1"."O_TIME">='00:00:00' AND "A1"."O_TIME"<='23:59:00' AND ("A1"."O_RESERVED"='0' OR "A1"."O_RESERVED"='1' OR "A1"."O_RESERVED"='2' OR "A1"."O_RESERVED"='3' OR "A1"."O_RESERVED"='4' OR "A1"."O_RESERVED"='5' OR "A1"."O_RESERVED"='6' OR "A1"."O_RESERVED"='7' OR "A1"."O_RESERVED"='10' OR "A1"."O_RESERVED"='99') ORDER BY "A1"."O_TIME"
fxvw7arf33nbaINSERT /*+APPEND*/ INTO T_JK_TASKASSIGNING201208 (O_INSTRUCTNO, O_ITEMNO, O_KIND, O_INSTDES, O_MANUREP , O_DISPPOS, O_DISPTIME)VALUES (:1, :2, :3, :4, :5, :6, :7)
g5mxy4vcrwy1y /* OracleOEM */ SELECT TO_CHAR(CAST(md.end_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, md.user_wait_time_pct, md.db_time_ps db_time_users, md.cpu_time_ps db_cpu_users, DECODE(:1, 'TRUE', md.host_cpu_usage_pct, 0)/p.instCount host_cpu_usage_pct, wcd.users userio_users, md.load_average load_average, p.cpu max_cpu_cnt FROM (SELECT DISTINCT wait_class_id FROM v$event_name WHERE wait_class = 'User I/O' AND :2 = 'TRUE') wcn, (SELECT wait_class_id, min(end_time) end_time, sum(time_waited / intsize_csec) users FROM gv$waitclassmetric_history WHERE end_time >= SYSDATE - 1/(60*24) AND intsize_csec > 5900 GROUP BY wait_class_id ) wcd, (SELECT sum(value) cpu, count(*) instCount from gv$parameter where name='cpu_count' )p, (SELECT min(end_time) end_time, SUM(CASE WHEN metric_name = 'Database Wait Time Ratio' THEN value ELSE 0 END) user_wait_time_pct, SUM(CASE WHEN metric_name = 'Database Time Per Sec' TH EN value / 100 ELSE 0 END) db_time_ps, SUM(CASE WHEN metric_name = 'CPU Usage Per Sec' THEN value / 100 ELSE 0 END) cpu_time_ps, SUM(CASE WHEN metric_name = 'Host CPU Utilization (%)' THEN value ELSE 0 END) host_cpu_usage_pct, SUM(CASE WHEN metric_name = 'Current OS Load' THEN value else 0 END) load_average FROM gv$sysmetric_history WHERE metric_name IN ('Database Wait Time Ratio', 'Database Time Per Sec', 'CPU Usage Per Sec', 'Host CPU Utilization (%)', 'Current OS Load') AND group_id = 2 AND end_time >= SYSDATE - 1/(60*24) AND intsize_csec > 5900 ) md WHERE wcn.wait_class_id = wcd.wait_class_id AND :3 != 'BASIC'
gmvhjssqt6jcqSELECT "A1"."O_BUSNAME", "A1"."O_LINENAME" FROM "T_DM_BUSID" "A1" WHERE "A1"."O_BUSNAME"<>ALL (SELECT DISTINCT "A3"."O_CLMC" FROM "T_DM_DDB201208" "A3" WHERE "A3"."O_XLMC"=ANY (SELECT "A4"."O_LINENAME" FROM "T_DM_LINEID" "A4" WHERE "A4"."O_FILIALENAME"='一公司') AND "A3"."O_RQ"='2012-08-07' AND "A3"."O_SJFCSJ" IS NOT NULL AND "A3"."O_SJFCSJ">='00:00' AND "A3"."O_SJFCSJ"<='23:59') AND "A1"."O_LINENAME"=ANY (SELECT "A2"."O_LINENAME" FROM "T_DM_LINEID" "A2" WHERE "A2"."O_FILIALENAME"='一公司') ORDER BY "A1"."O_LINENAME"
grwydz59pu6mcselect text from view$ where rowid=:1
gzxm11mcrwqhsSELECT "A3"."O_FILIALENAME", "A2"."O_LINENAME", "A2"."O_BUSNAME", "A2"."O_DATE", "A2"."O_TIME", 1, DECODE("A2"."O_UP", 1, '下行', '上行'), "A2"."O_STATIONNO", "A1"."O_STATIONNAME" FROM "T_DM_LINEID" "A3", "T_JK_ARRIVESTATION20120807" "A2", "T_DM_STATIONINF" "A1" WHERE "A3"."O_LINENAME"='537' AND "A3"."O_LINENAME"="A2"."O_LINENAME" AND "A1"."O_LINENAME"="A3"."O_LINENAME" AND "A1"."O_STATIONNO"="A2"."O_STATIONNO" AND "A1"."O_DIRECTION"="A2"."O_UP" AND "A2"."O_DATE"='2012-08-07' AND "A2"."O_STATIONNO"=14 AND "A2"."O_UP"=1 AND "A2"."O_TIME">='00:00' AND "A2"."O_TIME"<='23:59' ORDER BY "A2"."O_TIME"

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 96,860 26.98 0.40
CPU used when call started 96,707 26.94 0.40
CR blocks created 3,056 0.85 0.01
Cached Commit SCN referenced 60 0.02 0.00
Commit SCN cached 1 0.00 0.00
DB time 4,657,981 1,297.39 19.44
DBWR checkpoint buffers written 334,548 93.18 1.40
DBWR checkpoints 9 0.00 0.00
DBWR fusion writes 1,234 0.34 0.01
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 148,687 41.41 0.62
DBWR transaction table writes 154 0.04 0.00
DBWR undo block writes 98,963 27.56 0.41
DFO trees parallelized 67 0.02 0.00
IPC CPU used by this session 5,440 1.52 0.02
PX local messages recv'd 305 0.08 0.00
PX local messages sent 305 0.08 0.00
PX remote messages recv'd 5,880 1.64 0.02
PX remote messages sent 2,856 0.80 0.01
Parallel operations not downgraded 67 0.02 0.00
RowCR - row contention 65 0.02 0.00
RowCR attempts 2,461 0.69 0.01
RowCR hits 2,411 0.67 0.01
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 47 0.01 0.00
SQL*Net roundtrips to/from client 1,263,796 352.01 5.27
SQL*Net roundtrips to/from dblink 3,407 0.95 0.01
active txn count during cleanout 24,714 6.88 0.10
application wait time 133 0.04 0.00
background checkpoints completed 9 0.00 0.00
background checkpoints started 9 0.00 0.00
background timeouts 14,997 4.18 0.06
branch node splits 79 0.02 0.00
buffer is not pinned count 163,403,898 45,513.08 681.85
buffer is pinned count 1,509,172,867 420,351.74 6,297.46
bytes received via SQL*Net from client 354,990,803 98,876.02 1,481.30
bytes received via SQL*Net from dblink 2,136,825 595.17 8.92
bytes sent via SQL*Net to client 89,952,007 25,054.44 375.35
bytes sent via SQL*Net to dblink 587,983 163.77 2.45
calls to get snapshot scn: kcmgss 440,307 122.64 1.84
calls to kcmgas 436,176 121.49 1.82
calls to kcmgcs 16,808 4.68 0.07
change write time 4,388 1.22 0.02
cleanout - number of ktugct calls 39,609 11.03 0.17
cleanouts and rollbacks - consistent read gets 984 0.27 0.00
cleanouts only - consistent read gets 435 0.12 0.00
cluster key scan block gets 18,212 5.07 0.08
cluster key scans 11,077 3.09 0.05
cluster wait time 460,382 128.23 1.92
commit batch performed 6 0.00 0.00
commit batch requested 6 0.00 0.00
commit batch/immediate performed 4,972 1.38 0.02
commit batch/immediate requested 4,972 1.38 0.02
commit cleanout failures: block lost 2 0.00 0.00
commit cleanout failures: buffer being written 65 0.02 0.00
commit cleanout failures: callback failure 1,716 0.48 0.01
commit cleanout failures: cannot pin 2 0.00 0.00
commit cleanouts 3,422,977 953.41 14.28
commit cleanouts successfully completed 3,421,192 952.91 14.28
commit immediate performed 4,966 1.38 0.02
commit immediate requested 4,966 1.38 0.02
commit txn count during cleanout 26,131 7.28 0.11
concurrency wait time 1,739,865 484.61 7.26
consistent changes 28,380 7.90 0.12
consistent gets 196,896,032 54,841.69 821.61
consistent gets - examination 204,148 56.86 0.85
consistent gets direct 0 0.00 0.00
consistent gets from cache 196,896,889 54,841.93 821.61
cursor authentications 4,005 1.12 0.02
data blocks consistent reads - undo records applied 7,405 2.06 0.03
db block changes 10,775,519 3,001.32 44.96
db block gets 15,207,937 4,235.89 63.46
db block gets direct 76 0.02 0.00
db block gets from cache 15,208,553 4,236.06 63.46
deferred (CURRENT) block cleanout applications 3,201,265 891.65 13.36
dirty buffers inspected 415 0.12 0.00
enqueue conversions 13,804 3.84 0.06
enqueue deadlocks 0 0.00 0.00
enqueue releases 580,592 161.71 2.42
enqueue requests 580,854 161.79 2.42
enqueue timeouts 260 0.07 0.00
enqueue waits 3,995 1.11 0.02
exchange deadlocks 0 0.00 0.00
execute count 1,034,888 288.25 4.32
free buffer inspected 101,473 28.26 0.42
free buffer requested 158,070 44.03 0.66
gc CPU used by this session 4,501 1.25 0.02
gc cr block build time 46 0.01 0.00
gc cr block flush time 2,788 0.78 0.01
gc cr block receive time 54 0.02 0.00
gc cr block send time 312 0.09 0.00
gc cr blocks received 1,642 0.46 0.01
gc cr blocks served 72,613 20.22 0.30
gc current block flush time 0 0.00 0.00
gc current block pin time 92,020 25.63 0.38
gc current block receive time 203 0.06 0.00
gc current block send time 17 0.00 0.00
gc current blocks received 6,406 1.78 0.03
gc current blocks served 4,065 1.13 0.02
gcs messages sent 381,871 106.36 1.59
ges messages sent 20,270 5.65 0.08
global enqueue CPU used by this session 391 0.11 0.00
global enqueue get time 3,189 0.89 0.01
global enqueue gets async 1,725 0.48 0.01
global enqueue gets sync 296,132 82.48 1.24
global enqueue releases 296,153 82.49 1.24
heap block compress 7,205 2.01 0.03
hot buffers moved to head of LRU 120,024 33.43 0.50
immediate (CR) block cleanout applications 1,419 0.40 0.01
immediate (CURRENT) block cleanout applications 69,098 19.25 0.29
index fast full scans (full) 132 0.04 0.00
index fetch by key 45,031 12.54 0.19
index scans kdiixs1 45,818 12.76 0.19
leaf node 90-10 splits 132 0.04 0.00
leaf node splits 18,090 5.04 0.08
lob reads 5 0.00 0.00
lob writes 52 0.01 0.00
lob writes unaligned 52 0.01 0.00
logons cumulative 1,436 0.40 0.01
messages received 261,890 72.94 1.09
messages sent 261,890 72.94 1.09
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 196,560,050 54,748.11 820.20
opened cursors cumulative 37,910 10.56 0.16
parse count (failures) 0 0.00 0.00
parse count (hard) 10,386 2.89 0.04
parse count (total) 37,749 10.51 0.16
parse time cpu 885 0.25 0.00
parse time elapsed 1,437,967 400.52 6.00
physical read IO requests 15,217 4.24 0.06
physical read bytes 125,050,880 34,830.57 521.81
physical read total IO requests 22,802 6.35 0.10
physical read total bytes 248,673,280 69,263.27 1,037.66
physical read total multi block requests 9 0.00 0.00
physical reads 15,263 4.25 0.06
physical reads cache 15,265 4.25 0.06
physical reads cache prefetch 48 0.01 0.00
physical reads direct 0 0.00 0.00
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 181,327 50.51 0.76
physical write bytes 2,761,220,096 769,085.96 11,521.98
physical write total IO requests 420,662 117.17 1.76
physical write total bytes 5,954,255,872 1,658,446.06 24,845.84
physical write total multi block requests 268,013 74.65 1.12
physical writes 337,063 93.88 1.41
physical writes direct 76 0.02 0.00
physical writes direct (lob) 0 0.00 0.00
physical writes from cache 336,987 93.86 1.41
physical writes non checkpoint 113,829 31.70 0.47
pinned buffers inspected 1 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 0 0.00 0.00
process last non-idle time 8,663 2.41 0.04
queries parallelized 67 0.02 0.00
recursive calls 429,253 119.56 1.79
recursive cpu usage 2,553 0.71 0.01
redo blocks written 4,137,772 1,152.50 17.27
redo buffer allocation retries 34 0.01 0.00
redo entries 5,473,202 1,524.46 22.84
redo log space requests 40 0.01 0.00
redo log space wait time 28 0.01 0.00
redo ordering marks 82,132 22.88 0.34
redo size 1,988,006,876 553,721.95 8,295.53
redo synch time 32,530 9.06 0.14
redo synch writes 249,148 69.40 1.04
redo wastage 61,497,576 17,128.99 256.62
redo write time 11,282 3.14 0.05
redo writer latching time 11 0.00 0.00
redo writes 241,067 67.14 1.01
rollback changes - undo records applied 10,578 2.95 0.04
rollbacks only - consistent read gets 1,856 0.52 0.01
rows fetched via callback 20,570 5.73 0.09
session connect time 0 0.00 0.00
session cursor cache hits 17,451 4.86 0.07
session logical reads 212,103,980 59,077.58 885.06
session pga memory 2,700,669,384 752,220.70 11,269.32
session pga memory max 7,354,152,712 2,048,361.01 30,687.31
session uga memory 44,838,472 12,488.91 187.10
session uga memory max 588,706,512 163,973.13 2,456.55
shared hash latch upgrades - no wait 42,365 11.80 0.18
shared hash latch upgrades - wait 9 0.00 0.00
sorts (memory) 50,024 13.93 0.21
sorts (rows) 39,784,061 11,081.10 166.01
sql area purged 0 0.00 0.00
summed dirty queue length 471 0.13 0.00
switch current to new buffer 12,225 3.41 0.05
table fetch by rowid 803,900,527 223,911.38 3,354.51
table fetch continued row 64,723,491 18,027.51 270.08
table scan blocks gotten 29,364,002 8,178.79 122.53
table scan rows gotten 3,300,714,903 919,352.10 13,773.18
table scans (direct read) 0 0.00 0.00
table scans (long tables) 0 0.00 0.00
table scans (short tables) 12,504 3.48 0.05
total number of times SMON posted 51 0.01 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 4,972 1.38 0.02
transaction tables consistent read rollbacks 46 0.01 0.00
transaction tables consistent reads - undo records applied 20,719 5.77 0.09
undo change vector size 660,023,972 183,837.27 2,754.14
user I/O wait time 6,284 1.75 0.03
user calls 1,289,933 359.29 5.38
user commits 238,858 66.53 1.00
user rollbacks 790 0.22 0.00
workarea executions - optimal 10,749 2.99 0.04
write clones created in background 2 0.00 0.00
write clones created in foreground 533 0.15 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 40,195 42,094
opened cursors current 825 915
logons current 77 86

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 9 9.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)
TSTEST 15,002 4 1.72 1.00 145,526 41 9,793 999.02
UNDOTBS2 1 0 0.00 1.00 34,166 10 220 1.32
SYSAUX 87 0 6.21 1.55 1,533 0 0 0.00
SYSTEM 121 0 4.88 1.00 102 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)
SYSAUX +DATA/zdcomora/datafile/sysaux.257.780884719 87 0 6.21 1.55 1,533 0 0 0.00
SYSTEM +DATA/zdcomora/datafile/system.256.780884719 121 0 4.88 1.00 102 0 0 0.00
TSTEST +DATA/zdcomora/datafile/tstest_01.dbf 0 0     56 0 0 0.00
TSTEST +DATA/zdcomora/datafile/tstest_02.dbf 3 0 6.67 1.00 162 0 0 0.00
TSTEST +DATA/zdcomora/datafile/tstest_07.dbf 4 0 0.00 1.00 5 0 0 0.00
TSTEST +DATA/zdcomora/datafile/tstest_10.dbf 0 0     6 0 0 0.00
TSTEST +DATA/zdcomora/datafile/tstest_12.dbf 403 0 1.41 1.00 0 0 0 0.00
TSTEST +DATA/zdcomora/datafile/tstest_13.dbf 520 0 1.19 1.00 0 0 0 0.00
TSTEST +DATA/zdcomora/datafile/tstest_14.dbf 333 0 1.26 1.00 0 0 0 0.00
TSTEST +DATA/zdcomora/datafile/tstest_15.dbf 621 0 1.21 1.00 0 0 0 0.00
TSTEST +DATA/zdcomora/datafile/tstest_16.dbf 1,793 0 1.00 1.00 5 0 0 0.00
TSTEST +DATA/zdcomora/datafile/tstest_17.dbf 1,547 0 0.94 1.00 0 0 0 0.00
TSTEST +DATA/zdcomora/datafile/tstest_18.dbf 1,380 0 1.06 1.00 0 0 0 0.00
TSTEST +DATA/zdcomora/datafile/tstest_19.dbf 1,227 0 3.26 1.00 44,539 12 9,788 999.53
TSTEST +DATA/zdcomora/datafile/tstest_20.dbf 1,778 0 2.72 1.00 44,045 12 1 0.00
TSTEST +DATA/zdcomora/datafile/tstest_21.dbf 2,402 1 1.80 1.00 7,967 2 0 0.00
TSTEST +DATA/zdcomora/datafile/tstest_22.dbf 2,991 1 1.84 1.00 48,741 14 4 0.00
UNDOTBS2 +DATA/zdcomora/datafile/undotbs2.264.780884797 1 0 0.00 1.00 34,166 10 220 1.32

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 881,614 100 212,073,179 15,260 336,987 0 0 10,013


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 83 43748 485796 921600 921600 2912058  
E 0 85 46906 543473 921600 921600 2829489  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 720 0.10 86,625 5.53 12,469,099
D 1,440 0.20 173,250 3.29 7,425,643
D 2,160 0.29 259,875 2.56 5,775,629
D 2,880 0.39 346,500 2.11 4,764,447
D 3,600 0.49 433,125 1.80 4,057,165
D 4,320 0.59 519,750 1.48 3,338,466
D 5,040 0.69 606,375 1.31 2,962,887
D 5,760 0.79 693,000 1.19 2,675,721
D 6,480 0.88 779,625 1.09 2,458,158
D 7,200 0.98 866,250 1.01 2,277,764
D 7,328 1.00 881,650 1.00 2,253,908
D 7,920 1.08 952,875 0.96 2,154,815
D 8,640 1.18 1,039,500 0.93 2,091,774
D 9,360 1.28 1,126,125 0.91 2,055,343
D 10,080 1.38 1,212,750 0.90 2,030,869
D 10,800 1.47 1,299,375 0.89 2,014,619
D 11,520 1.57 1,386,000 0.88 1,987,148
D 12,240 1.67 1,472,625 0.87 1,962,783
D 12,960 1.77 1,559,250 0.87 1,951,879
D 13,680 1.87 1,645,875 0.86 1,936,312
D 14,400 1.97 1,732,500 0.85 1,912,358

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 1,020 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 3,151 2,621 440.10 0.00 0.00 0.00 0.00 322,660
E 3,151 2,607 484.54 0.00 0.00 0.00 0.00 322,660

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 9,711 9,711 0 0
64K 128K 37 37 0 0
128K 256K 6 6 0 0
256K 512K 12 12 0 0
512K 1024K 911 911 0 0
1M 2M 48 48 0 0
2M 4M 1 1 0 0
4M 8M 20 20 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
394 0.13 38,693.39 0.00 100.00 0
788 0.25 38,693.39 0.00 100.00 0
1,576 0.50 38,693.39 0.00 100.00 0
2,363 0.75 38,693.39 0.00 100.00 0
3,151 1.00 38,693.39 0.00 100.00 0
3,781 1.20 38,693.39 0.00 100.00 0
4,411 1.40 38,693.39 0.00 100.00 0
5,042 1.60 38,693.39 0.00 100.00 0
5,672 1.80 38,693.39 0.00 100.00 0
6,302 2.00 38,693.39 0.00 100.00 0
9,453 3.00 38,693.39 0.00 100.00 0
12,604 4.00 38,693.39 0.00 100.00 0
18,906 6.00 38,693.39 0.00 100.00 0
25,208 8.00 38,693.39 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
1,872 0.90 240 26,739 678,623 1.00 73,617 1.05 34,587,080
2,080 1.00 445 46,555 682,034 1.00 70,206 1.00 34,621,977
2,288 1.10 652 67,851 682,958 1.00 69,282 0.99 34,647,125
2,496 1.20 859 91,272 684,053 1.00 68,187 0.97 34,654,679
2,704 1.30 1,066 114,542 685,136 1.00 67,104 0.96 34,657,799
2,912 1.40 1,273 138,582 685,228 1.00 67,012 0.95 34,660,227
3,120 1.50 1,480 163,095 685,242 1.00 66,998 0.95 34,661,876
3,328 1.60 1,687 184,245 685,247 1.00 66,993 0.95 34,663,758
3,536 1.70 1,894 200,111 685,250 1.00 66,990 0.95 34,665,076
3,744 1.80 2,101 214,334 685,301 1.00 66,939 0.95 34,666,617
3,952 1.90 2,308 227,075 685,452 1.01 66,788 0.95 34,668,004
4,160 2.00 2,515 239,372 685,678 1.01 66,562 0.95 34,669,902

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
4,728 0.50 369,305 5,295,840
7,092 0.75 363,870 3,060,640
9,456 1.00 362,312 2,253,453
11,820 1.25 361,334 1,975,152
14,184 1.50 361,116 1,861,578
16,548 1.75 361,009 1,799,382
18,912 2.00 360,936 1,753,412

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

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)
file header block 9,803 9,784 998
undo header 202 0 0
data block 5 0 0
undo block 3 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
FB-Format Block 2,227 2,227 0 1,108 1 0.48
PS-PX Process Reservation 1,739 1,735 4 1,426 0 0.29
US-Undo Segment 2,142 2,142 0 1,057 0 0.23
HW-Segment High Water Mark 1,374 1,374 0 12 0 17.25
TM-DML 252,212 252,209 0 212 0 0.25
CF-Controlfile Transaction 5,960 5,704 256 74 0 0.38
TT-Tablespace 762 762 0 52 0 0.35
IR-Instance Recovery 289 289 0 19 0 0.42
WF-AWR Flush 21 20 0 11 0 0.55
JS-Job Scheduler (job run lock - synchronize) 2 2 0 2 0 1.50
TD-KTF map table enqueue (KTF dump entries) 9 9 0 9 0 0.22
PI-Remote PX Process Spawn Status 4 4 0 4 0 0.25
DR-Distributed Recovery 2 2 0 2 0 0.50
MW-MWIN Schedule 2 2 0 2 0 0.50
TO-Temp Object 4 4 0 3 0 0.00
SW-Suspend Writes 1 1 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 127.00 389,938 904 32 15/47.15 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
07-Aug 14:08 26,884 100,492 17 19 15 0/0 0/0/0/0/0/0
07-Aug 13:58 26,488 92,671 17 18 15 0/0 0/0/0/0/0/0
07-Aug 13:48 62,194 135,038 904 31 47 0/0 0/0/0/0/0/0
07-Aug 13:38 73 1,853 0 32 15 0/0 0/0/0/0/0/0
07-Aug 13:28 315 7,873 0 30 15 0/0 0/0/0/0/0/0
07-Aug 13:18 1,284 16,977 0 27 15 0/0 0/0/0/0/0/0
07-Aug 13:08 9,760 35,034 138 26 15 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM allocation 19 0.00   0 0  
ASM map headers 58 0.00   0 0  
ASM map load waiting list 30 0.00   0 0  
ASM map operation freelist 70 0.00   0 0  
ASM map operation hash table 991,932 0.00 0.00 0 0  
ASM network background latch 1,519 0.00   0 0  
AWR Alerted Metric Element list 18,887 0.00   0 0  
Consistent RBA 241,105 0.01 0.00 0 0  
FIB s.o chain latch 20 0.00   0 0  
FOB s.o list latch 210 0.00   0 0  
JS broadcast add buf latch 823 0.00   0 0  
JS broadcast drop buf latch 823 0.00   0 0  
JS broadcast load blnc latch 716 0.00   0 0  
JS mem alloc latch 6 0.00   0 0  
JS queue access latch 6 0.00   0 0  
JS queue state obj latch 25,986 0.00   0 0  
JS slv state obj latch 131 0.00   0 0  
KCL gc element parent latch 982,362 0.03 0.00 0 1,182 0.08
KFK SGA context latch 635 0.00   0 0  
KFMD SGA 38 0.00   0 0  
KJC message pool free list 247,491 0.00 0.00 0 11,313 0.02
KJCT flow control latch 729,795 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 1,197 0.00   0 0  
KSXR large replies 2 0.00   0 0  
KTF sga latch 18 0.00   0 1,132 0.00
KWQMN job cache list latch 367 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 0     0 1,197 0.00
OS process 546 0.00   0 0  
OS process allocation 1,571 0.00   0 0  
OS process: request allocation 170 0.00   0 0  
PL/SQL warning settings 2,899 0.00   0 0  
SGA IO buffer pool latch 29,359 0.00   0 29,359 0.04
SQL memory manager latch 1 0.00   0 1,196 0.00
SQL memory manager workarea list latch 92,949 0.00   0 0  
Shared B-Tree 132 0.00   0 0  
active checkpoint queue latch 22,345 0.09 0.00 0 0  
active service list 18,552 0.01 0.00 0 1,393 0.00
archive control 158 0.00   0 0  
begin backup scn array 4 0.00   0 0  
business card 134 0.00   0 0  
cache buffer handles 49,587 0.01 0.00 0 0  
cache buffers chains 453,631,465 0.02 0.00 0 228,253 0.01
cache buffers lru chain 1,041,518 0.11 0.01 0 262,097 0.03
cache table scan latch 0     0 9 0.00
channel handle pool latch 187 0.00   0 0  
channel operations parent latch 285,833 0.00 0.00 0 0  
checkpoint queue latch 872,140 0.02 0.00 0 340,140 0.01
client/application info 8,036 0.00   0 0  
commit callback allocation 134 0.00   0 0  
compile environment latch 258,955 0.00   0 0  
dml lock allocation 504,489 0.07 0.00 0 0  
dummy allocation 2,869 0.00   0 0  
enqueue hash chains 1,702,896 0.01 0.00 0 493 0.00
enqueues 387,719 0.06 0.00 0 0  
error message lists 323 0.00   0 0  
event group latch 90 0.00   0 0  
event range base latch 4 0.00   0 0  
file cache latch 1,462 0.00   0 0  
gcs drop object freelist 1,848 0.54 0.00 0 0  
gcs opaque info freelist 10,568 0.01 0.00 0 0  
gcs partitioned table hash 580,614 0.00   0 0  
gcs remastering latch 17 0.00   0 0  
gcs resource freelist 77,481 0.00   0 0  
gcs resource hash 808,465 0.01 0.00 0 18 0.00
gcs resource scan list 36 0.00   0 0  
gcs shadows freelist 14,767 0.00   0 0  
ges caches resource lists 297,967 0.04 0.00 0 58,786 0.04
ges deadlock list 2,214 0.00   0 2 0.00
ges domain table 591,680 0.00   0 0  
ges enqueue table freelist 605,202 0.00 0.00 0 0  
ges group table 879,895 0.00 0.00 0 0  
ges process hash list 6,417 0.00   0 0  
ges process parent latch 1,209,570 0.00   0 0  
ges process table freelist 170 0.00   0 0  
ges resource hash list 686,478 0.01 0.00 0 19,997 0.03
ges resource scan list 1,673 0.00   0 0  
ges resource table freelist 33,102 0.01 0.00 0 0  
ges timeout list 2,677 0.00   0 2,107 0.00
global KZLD latch for mem in SGA 34 0.00   0 0  
global hanganlyze operation 142 0.00   0 0  
global tx hash mapping 7,700 0.00   0 0  
hash table column usage latch 270 0.00   0 54,470 0.00
hash table modification latch 104 0.00   0 0  
job workq parent latch 0     0 4 0.00
job_queue_processes parameter latch 61 0.00   0 0  
kks stats 42,972 0.07 0.03 0 0  
ksuosstats global area 245 0.00   0 0  
ktm global data 158 0.00   0 0  
kwqbsn:qsga 132 0.00   0 0  
lgwr LWN SCN 241,557 0.05 0.00 0 0  
library cache 3,351,230 0.05 0.11 0 59,975 0.57
library cache load lock 1,286 0.00   0 0  
library cache lock 184,613 0.00 0.00 0 0  
library cache lock allocation 1,075 0.00   0 0  
library cache pin 2,233,066 0.00 0.00 0 1,162 0.00
library cache pin allocation 523 0.00   0 0  
list of block allocation 158,633 0.00 0.00 0 0  
loader state object freelist 2 0.00   0 0  
message pool operations parent latch 8,729 0.00   0 0  
messages 919,197 0.03 0.00 0 0  
mostly latch-free SCN 242,929 0.49 0.00 0 0  
msg queue 8 0.00   0 8 0.00
multiblock read objects 10,528 0.00   0 0  
name-service memory objects 14,620 0.00   0 0  
name-service namespace bucket 40,010 0.00   0 0  
name-service pending queue 7,226 0.00   0 0  
name-service request 20 0.00   0 0  
name-service request queue 45,320 0.00   0 0  
ncodef allocation latch 66 0.00   0 0  
object queue header heap 623 0.00   0 843 0.00
object queue header operation 1,419,827 0.01 0.00 0 0  
object stats modification 10 0.00   0 0  
parallel query alloc buffer 11,977 0.00   0 0  
parallel query stats 1,549 0.00   0 0  
parallel txn reco latch 2,085 0.00   0 0  
parameter list 226 0.00   0 0  
parameter table allocation management 2,166 0.09 1.00 0 0  
post/wait queue 393,007 0.02 0.00 0 239,395 0.04
process allocation 32,190 0.00   0 90 0.00
process group creation 170 0.00   0 0  
process queue 4,557 0.00   0 0  
process queue reference 102,291 0.00   0 9,398 3.28
qmn state object latch 2 0.00   0 0  
qmn task queue latch 508 0.00   0 0  
query server freelists 3,160 0.00   0 0  
query server process 4 0.00   0 3 0.00
queued dump request 17,707 0.00   0 0  
redo allocation 753,038 0.25 0.00 0 5,467,866 0.27
redo copy 0     0 5,473,093 0.12
redo writing 772,115 0.00 0.00 0 0  
resmgr group change latch 1,836 0.00   0 0  
resmgr:actses active list 3,095 0.00   0 0  
resmgr:actses change group 1,847 0.00   0 0  
resmgr:free threads list 2,862 0.00   0 0  
resmgr:schema config 3 0.00   0 0  
row cache objects 677,716 0.03 0.00 0 14,529 0.01
rules engine aggregate statistics 16 0.00   0 0  
rules engine rule set statistics 32 0.00   0 0  
segmented array pool 4 0.00   0 0  
sequence cache 315 0.00   0 0  
session allocation 559,940 0.08 0.00 0 0  
session idle bit 2,837,364 0.01 0.00 0 0  
session state list latch 2,899 0.14 0.00 0 0  
session switching 66 0.00   0 0  
session timer 1,393 0.00   0 0  
shared pool 1,336,997 0.09 0.46 1 0  
simulator hash latch 12,996,681 0.00 0.00 0 0  
simulator lru latch 12,973,468 0.07 0.00 0 8,883 0.00
slave class 27 0.00   0 0  
slave class create 32 3.13 1.00 0 0  
sort extent pool 189 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 140 0.00   0 0  
temporary table state object allocation 1 0.00   0 0  
threshold alerts latch 252 0.00   0 0  
trace latch 7 0.00   0 0  
transaction allocation 111,887 0.00   0 0  
transaction branch allocation 7,751 0.00   0 0  
undo global data 1,102,268 0.02 0.00 0 114 0.00
user lock 123 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 453,631,465 78,335 77 78,267 0 0 0
simulator lru latch 12,973,468 8,531 4 8,527 0 0 0
redo allocation 753,038 1,846 4 1,842 0 0 0
library cache 3,351,230 1,609 184 1,433 0 0 0
shared pool 1,336,997 1,143 528 672 0 0 0
cache buffers lru chain 1,041,518 1,139 11 1,128 0 0 0
kks stats 42,972 30 1 29 0 0 0
parameter table allocation management 2,166 2 2 0 0 0 0
slave class create 32 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclrwrite 0 2 1
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 81 84
cache buffers chains kcbgtcr: kslbegin excl 0 65 63
cache buffers chains kcbrls: kslbegin 0 18 46
cache buffers chains kcbnew: new latch again 0 12 1
cache buffers chains kcbzgb: scan from tail. nowait 0 10 0
cache buffers chains kclcls_3 0 10 0
cache buffers chains kcbgcur: kslbegin 0 8 11
cache buffers chains kcbgtcr: fast path 0 8 2
cache buffers chains kcbbxsv 0 3 2
cache buffers chains kcbget: pin buffer 0 2 4
cache buffers chains kcbget: exchange rls 0 1 0
cache buffers chains kclbla 0 1 0
cache buffers chains kclwrt 0 1 0
cache buffers lru chain kcbkubc 0 5 6
cache buffers lru chain kcbzgws 0 4 0
cache buffers lru chain kcbbxsv: move to being written 0 2 4
kks stats kks stats alloc/free 0 1 1
library cache kglobpn: child: 0 13 2
library cache kgldte: child 0 0 12 29
library cache kglrtl 0 12 0
library cache kglhdgc: child: 0 10 1
library cache kglukp: child 0 9 19
library cache kglpndl: child: before processing 0 7 25
library cache kglpnc: child 0 5 91
library cache kglpin 0 1 0
library cache kglpndl: child: after processing 0 1 0
parameter table allocation management ksp_param_table_free 0 2 2
redo allocation kcrfw_redo_gen: redo allocation 1 0 4 0
shared pool kghfrunp: alloc: cursor dur 0 235 0
shared pool kghalo 0 195 56
shared pool kghupr1 0 80 434
shared pool kghfrunp: clatch: nowait 0 68 0
shared pool kghfrunp: clatch: wait 0 46 9
shared pool kghfre 0 10 36
shared pool kghalp 0 8 1
simulator lru latch kcbs_simulate: simulate set 0 4 4
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
ZDCOM TSTEST T_DM_DDB201208   TABLE 155,555,856 73.34
ZDCOM TSTEST T_DM_YXSJBJBA   TABLE 21,198,896 9.99
ZDCOM TSTEST T_DM_PAIBAN   TABLE 7,086,944 3.34
ZDCOM TSTEST T_JK_FULLGPSDATA20120807   TABLE 6,631,200 3.13
ZDCOM TSTEST I_DM_DDB_DATE201208   INDEX 3,233,776 1.52

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
ZDCOM TSTEST T_JK_OVERSPEED201207   TABLE 10,495 68.76
ZDCOM TSTEST T_JK_LEAVESTATION20120806   TABLE 1,450 9.50
ZDCOM TSTEST PK_JK_INSTRUCTREPLY201208   INDEX 453 2.97
ZDCOM TSTEST T_JK_FULLGPSDATA20120806   TABLE 412 2.70
ZDCOM TSTEST I_JK_DOORWARNING_BN201208   INDEX 344 2.25

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
ZDCOM TSTEST I_FGPSDATA_D20120807   INDEX 480 17.37
ZDCOM TSTEST T_JK_FULLGPSDATA20120807   INDEX 378 13.68
ZDCOM TSTEST I_FGPSDATA_BN20120807   INDEX 198 7.16
ZDCOM TSTEST I_FGPSDATA_LN20120807   INDEX 168 6.08
ZDCOM TSTEST I_JK_INSTRREPLY_DATE201208   INDEX 156 5.64

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
ZDCOM TSTEST I_BCANL_D20120807   INDEX 2 22.22
ZDCOM TSTEST I_FGPSDATA_D20120807   INDEX 2 22.22
ZDCOM TSTEST I_JK_OVERSPEED_DATE201208   INDEX 2 22.22
ZDCOM TSTEST PK_JK_TASKASSIGNING201208   INDEX 2 22.22
ZDCOM TSTEST PK_T_SENDINSTRUCT201208   INDEX 1 11.11

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
ZDCOM TSTEST I_FGPSDATA_D20120807   INDEX 4 100.00

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
SYS SYSTEM JOB$   TABLE 225 13.70
SYS SYSTEM I_JOB_NEXT   INDEX 220 13.40
SYSMAN SYSAUX MGMT_CURRENT_AVAILABILITY   TABLE 144 8.77
ZDCOM TSTEST T_DM_PAIBAN   TABLE 122 7.43
ZDCOM TSTEST T_SSO_LOG   TABLE 87 5.30

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
ZDCOM TSTEST T_JK_FULLGPSDATA20120806   TABLE 3,469 54.15
ZDCOM TSTEST T_JK_OVERSPEED201207   TABLE 954 14.89
ZDCOM TSTEST I_DM_DDB_DATE201208   INDEX 312 4.87
SYSMAN SYSAUX MGMT_METRICS_RAW_PK   INDEX 210 3.28
ZDCOM TSTEST I_JK_OVERSPEED_LN201208   INDEX 169 2.64

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 69 1.45 0   1 1
dc_database_links 7,900 0.00 0   0 2
dc_global_oids 5,618 0.00 0   0 169
dc_histogram_data 89,951 0.02 0   0 21,053
dc_histogram_defs 33,300 0.23 0   0 36,853
dc_object_grants 6 0.00 0   0 117
dc_object_ids 44,106 0.03 0   0 6,687
dc_objects 21,328 0.27 0   0 3,637
dc_profiles 53 0.00 0   0 2
dc_rollback_segments 5,497 0.00 0   0 142
dc_segments 33,988 0.06 0   62 8,014
dc_sequences 33 39.39 0   33 7
dc_tablespace_quotas 51 1.96 0   51 2
dc_tablespaces 22,717 0.00 0   0 8
dc_usernames 436 0.00 0   0 17
dc_users 18,659 0.00 0   0 43
outstanding_alerts 108 63.89 0   16 2

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 3 1 0
dc_histogram_defs 77 0 0
dc_object_ids 12 0 0
dc_objects 57 2 6
dc_segments 140 9 0
dc_sequences 66 11 1
dc_tablespace_quotas 93 1 0
outstanding_alerts 193 61 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 204 0.00 7,287 0.11 7 0
CLUSTER 15 0.00 18 5.56 1 0
INDEX 1 0.00 10 0.00 0 0
SQL AREA 10,089 97.46 1,061,799 1.93 535 0
TABLE/PROCEDURE 1,670 4.31 71,825 0.88 293 0
TRIGGER 6 0.00 519 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 18 0 0 0 0
INDEX 10 0 0 0 0
TABLE/PROCEDURE 22,677 79 370 41 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 386.86   4.78 5.96 26 26 81 81
  Freeable 49.81 0.00 0.89 0.38 3   56 56
  SQL 2.37 0.91 0.04 0.05 0 12 60 56
  PL/SQL 1.08 0.54 0.01 0.02 0 0 79 77
E Other 423.50   4.65 5.69 26 26 91 91
  Freeable 57.19 0.00 0.89 0.38 3   64 64
  SQL 2.59 1.00 0.04 0.05 0 12 69 64
  PL/SQL 1.28 0.67 0.01 0.02 0 0 89 86

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 7,683,964,928  
Fixed Size 2,037,128  
Redo Buffers 14,737,408  
Variable Size 2,214,595,192  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.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 ASH buffers 29.00 29.00 0.00
shared CCursor 122.06 122.26 0.16
shared KQR L PO 53.94 54.08 0.27
shared PCursor 106.46 104.07 -2.24
shared db_block_hash_buckets 33.63 33.63 0.00
shared free memory 83.27 99.02 18.91
shared gcs resources 144.17 144.17 0.00
shared gcs shadows 90.81 90.81 0.00
shared kglsim heap 32.28 32.28 0.00
shared kglsim object batch 85.64 85.64 0.00
shared library cache 503.44 476.12 -5.43
shared sql area 446.18 458.87 2.84
  buffer_cache 7,328.00 7,328.00 0.00
  fixed_sga 1.94 1.94 0.00
  log_buffer 14.05 14.05 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 695,268 905,677 981460 981460


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /oracle/admin/zdcomora/adump   
background_dump_dest /oracle/admin/zdcomora/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.1.0   
control_files +DATA/zdcomora/controlfile/current.260.780884779   
core_dump_dest /oracle/admin/zdcomora/cdump   
db_block_size 8192   
db_create_file_dest +DATA   
db_domain      
db_file_multiblock_read_count 16   
db_name zdcomora   
dispatchers (PROTOCOL=TCP) (SERVICE=zdcomoraXDB)   
instance_number 2   
job_queue_processes 10   
log_archive_dest_1 LOCATION=+DATA/zdcomora/   
log_archive_format %t_%s_%r.dbf   
open_cursors 300   
pga_aggregate_target 3304062976   
processes 150   
remote_listener LISTENERS_ZDCOMORA   
remote_login_passwordfile EXCLUSIVE   
sga_target 9915334656   
spfile +DATA/zdcomora/spfilezdcomora.ora   
thread 2   
undo_management AUTO   
undo_tablespace UNDOTBS2   
user_dump_dest /oracle/admin/zdcomora/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 53,841 15.00 0.22
acks for commit broadcast(logical) 56,378 15.70 0.24
broadcast msgs on commit(actual) 240,922 67.10 1.01
broadcast msgs on commit(logical) 241,070 67.15 1.01
broadcast msgs on commit(wasted) 1,589 0.44 0.01
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 2 0.00 0.00
flow control messages sent 1 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 1,966 0.55 0.01
gcs ast xid 0 0.00 0.00
gcs blocked converts 1,827 0.51 0.01
gcs blocked cr converts 35,917 10.00 0.15
gcs compatible basts 2 0.00 0.00
gcs compatible cr basts (global) 400 0.11 0.00
gcs compatible cr basts (local) 3,950 1.10 0.02
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 695 0.19 0.00
gcs dbwr write request msgs 777 0.22 0.00
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 544 0.15 0.00
gcs immediate (null) converts 20,158 5.61 0.08
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 8,615 2.40 0.04
gcs indirect ast 21,389 5.96 0.09
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 75 0.02 0.00
gcs msgs process time(ms) 5,519 1.54 0.02
gcs msgs received 403,200 112.30 1.68
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 3 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,604 0.45 0.01
gcs side channel msgs logical 16,931 4.72 0.07
gcs undo cr 10 0.00 0.00
gcs write notification msgs 13 0.00 0.00
gcs writes refused 1 0.00 0.00
ges msgs process time(ms) 215 0.06 0.00
ges msgs received 22,207 6.19 0.09
global posts dropped 0 0.00 0.00
global posts queue time 8 0.00 0.00
global posts queued 17 0.00 0.00
global posts requested 17 0.00 0.00
global posts sent 17 0.00 0.00
implicit batch messages received 2,373 0.66 0.01
implicit batch messages sent 13,878 3.87 0.06
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 242,416 67.52 1.01
messages queue sent actual 281,062 78.28 1.17
messages queue sent logical 302,214 84.18 1.26
messages received actual 397,388 110.68 1.66
messages received logical 425,414 118.49 1.78
messages sent directly 24,221 6.75 0.10
messages sent indirectly 54,461 15.17 0.23
messages sent not implicit batched 267,183 74.42 1.11
messages sent pbatched 88,766 24.72 0.37
msgs causing lmd to send msgs 7,258 2.02 0.03
msgs causing lms(s) to send msgs 57,816 16.10 0.24
msgs received queue time (ms) 572,010 159.32 2.39
msgs received queued 425,442 118.50 1.78
msgs sent queue time (ms) 16,271 4.53 0.07
msgs sent queue time on ksxp (ms) 43,982 12.25 0.18
msgs sent queued 302,037 84.13 1.26
msgs sent queued on ksxp 360,466 100.40 1.50
process batch messages received 245,412 68.35 1.02
process batch messages sent 68,040 18.95 0.28


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 72,495
CURRENT Block Requests 136
Data Block Requests 72,495
Undo Block Requests 10
TX Block Requests 126
Current Results 72,383
Private results 40
Zero Results 206
Disk Read Results 1
Fail Results 0
Fairness Down Converts 6,514
Fairness Clears 0
Free GC Elements 0
Flushes 337
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 6
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 4,071 100.00 0.00 0.00 0.00 0.00
Flushes 7 100.00 0.00 0.00 0.00 0.00
Writes 1,234 43.11 50.08 4.38 1.30 1.13


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 1,553 98.52 1.48 0.00 6,312 99.87 0.13 0.00
1 Others 96 100.00 0.00 0.00 100 100.00 0.00 0.00
1 undo header 2 100.00 0.00 0.00 5 100.00 0.00 0.00


Back to Top

End of Report