WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
GPSRAC88403155gpsrac1110.2.0.5.0YESdwptdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2277630-Dec-13 13:00:15149 4.4
End Snap:2277730-Dec-13 14:00:01155 4.2
Elapsed:  59.78 (mins)  
DB Time:  136.36 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 5,936M 5,936MStd Block Size: 8K
Shared Pool Size: 1,984M 1,984MLog Buffer: 47,088K

Load Profile

Per SecondPer Transaction
Redo size: 1,497,079.79 2,046.02
Logical reads: 38,927.30 53.20
Block changes: 8,009.28 10.95
Physical reads: 38.68 0.05
Physical writes: 205.24 0.28
User calls: 94.13 0.13
Parses: 730.16 1.00
Hard parses: 421.63 0.58
Sorts: 128.85 0.18
Logons: 0.19 0.00
Executes: 2,484.67 3.40
Transactions: 731.70 

% Blocks changed per Read: 20.57Recursive Call %: 98.06
Rollback per transaction %: 0.01Rows per Sort: 23.17

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.92In-memory Sort %: 100.00
Library Hit %: 79.46Soft Parse %: 42.26
Execute to Parse %: 70.61Latch Hit %: 99.89
Parse CPU to Parse Elapsd %: 90.17% Non-Parse CPU: 89.58

Shared Pool Statistics

BeginEnd
Memory Usage %: 56.07 56.15
% SQL with executions>1: 50.59 45.81
% Memory for SQL w/exec>1: 50.48 46.19

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  6,397  78.2 
db file sequential read 133,248 826 6 10.1User I/O
library cache lock 686,846 532 1 6.5Concurrency
log file parallel write 2,466,281 489 0 6.0System I/O
log file sync 176,813 345 2 4.2Commit

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 9.34 0.01
Global Cache blocks served: 209.99 0.29
GCS/GES messages received: 1,153.14 1.58
GCS/GES messages sent: 1,178.91 1.61
DBWR Fusion writes: 8.87 0.01
Estd Interconnect traffic (KB) 2,210.07 

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

Buffer access - local cache %: 99.89
Buffer access - remote cache %: 0.02
Buffer access - disk %: 0.08

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1
Avg global cache cr block receive time (ms): 1.8
Avg global cache current block receive time (ms): 1.4
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 0.1
Avg global cache cr block flush time (ms): 13.8
Avg global cache current block pin time (ms): 164.4
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.0
Avg global cache current block flush time (ms): 76,292.8

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): -348.6
Avg message sent queue time on ksxp (ms): 0.6
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: 19.89
% of indirect sent messages: 20.48
% of flow controlled messages: 59.63

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 7,625.69 93.20
DB CPU 6,397.37 78.19
parse time elapsed 2,250.05 27.50
hard parse elapsed time 1,975.19 24.14
PL/SQL execution elapsed time 1,070.22 13.08
hard parse (sharing criteria) elapsed time 7.88 0.10
hard parse (bind mismatch) elapsed time 7.66 0.09
sequence load elapsed time 6.69 0.08
connection management call elapsed time 2.98 0.04
repeated bind elapsed time 2.55 0.03
PL/SQL compilation elapsed time 1.85 0.02
failed parse elapsed time 0.16 0.00
DB time 8,181.85  
background elapsed time 1,767.63  
background cpu time 1,628.87  

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     6,397   78.19
User I/O 151,835   835 5 10.20
Concurrency 807,795   594 1 7.26
System I/O 2,540,623   577 0 7.05
Commit 176,813 0 345 2 4.22
Cluster 191,864 0 194 1 2.37
Other 1,233,163 75 192 0 2.35
Network 465,158   16 0 0.20
Configuration 3,743 0 6 1 0.07
Application 3,066   1 0 0.02

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 133,248   826 6 0.05
library cache lock 686,846   532 1 0.26
log file parallel write 2,466,281   489 0 0.94
log file sync 176,813 0 345 2 0.07
wait for scn ack 97,455   143 1 0.04
control file sequential read 72,456   85 1 0.03
gc current grant 2-way 88,664   80 1 0.03
gc current grant busy 65,638   67 1 0.03
row cache lock 83,335   41 0 0.03
gc current block 2-way 27,590   35 1 0.01
Streams AQ: qmn coordinator waiting for slave to start 4 100 21 5280 0.00
SQL*Net more data from client 152,979   15 0 0.06
latch: shared pool 32,205   15 0 0.01
CGS wait for IPC msg 872,331 99 10 0 0.33
gc cr block 2-way 5,037   8 2 0.00
direct path write 12,811   7 1 0.00
gcs log flush sync 832 9 5 6 0.00
enq: HW - contention 3,384   3 1 0.00
control file parallel write 1,838   2 1 0.00
enq: TX - index contention 524   2 5 0.00
PX Deq Credit: send blkd 319 47 2 7 0.00
log file switch completion 61   2 37 0.00
os thread startup 71   2 31 0.00
LGWR wait for redo copy 99,204   2 0 0.04
reliable message 503 0 2 4 0.00
latch free 1,081   2 2 0.00
latch: library cache 1,065   2 2 0.00
ksxr poll remote instances 132,622 37 2 0 0.05
read by other session 212   1 6 0.00
enq: TM - contention 912   1 1 0.00
direct path read 5,557   1 0 0.00
gc cr multi block request 897   1 1 0.00
gc cr grant 2-way 1,563   1 1 0.00
gc buffer busy 49 14 1 17 0.00
gc current multi block request 2,329   1 0 0.00
SQL*Net message to client 290,584   1 0 0.11
DFS lock handle 418   1 1 0.00
enq: WF - contention 12 8 1 45 0.00
KJC: Wait for msg sends to complete 637   1 1 0.00
name-service call wait 12   0 41 0.00
gc current block busy 78   0 5 0.00
enq: FB - contention 488   0 1 0.00
library cache pin 702   0 0 0.00
SQL*Net more data to client 21,595   0 0 0.01
rdbms ipc reply 598   0 0 0.00
SQL*Net break/reset to client 2,153   0 0 0.00
IPC send completion sync 227 99 0 1 0.00
gc cr block busy 17   0 9 0.00
enq: PS - contention 237   0 1 0.00
log file sequential read 24   0 5 0.00
PX Deq: reap credit 6,932 93 0 0 0.00
buffer busy waits 1,989   0 0 0.00
enq: SQ - contention 291   0 0 0.00
undo segment extension 1 100 0 99 0.00
latch: cache buffers chains 818   0 0 0.00
latch: row cache objects 197   0 0 0.00
enq: TQ - TM contention 43   0 1 0.00
latch: redo allocation 162   0 0 0.00
cursor: pin S 18,289   0 0 0.01
PX Deq: Signal ACK 183 32 0 0 0.00
db file scattered read 6   0 6 0.00
latch: enqueue hash chains 190   0 0 0.00
enq: TX - contention 1   0 29 0.00
latch: ges resource hash list 208   0 0 0.00
enq: TT - contention 41   0 0 0.00
CSS operation: query 6   0 3 0.00
global enqueue expand wait 1 100 0 11 0.00
enq: TA - contention 5   0 2 0.00
enq: TX - allocate ITL entry 2   0 4 0.00
latch: library cache lock 40   0 0 0.00
enq: TD - KTF dump entries 7   0 1 0.00
log file single write 24   0 0 0.00
latch: messages 50   0 0 0.00
enq: US - contention 2   0 1 0.00
CSS initialization 2   0 1 0.00
enq: JQ - contention 3   0 1 0.00
enq: PI - contention 4   0 0 0.00
enq: DR - contention 2   0 1 0.00
db file parallel read 1   0 1 0.00
latch: redo writing 4   0 0 0.00
CSS operation: action 4   0 0 0.00
gc current split 2   0 0 0.00
latch: cache buffers lru chain 4   0 0 0.00
latch: gcs resource hash 6   0 0 0.00
latch: library cache pin 3   0 0 0.00
latch: KCL gc element parent latch 7   0 0 0.00
enq: TX - row lock contention 1   0 0 0.00
enq: AF - task serialization 1   0 0 0.00
latch: undo global data 2   0 0 0.00
PX qref latch 23 100 0 0 0.00
buffer deadlock 4 100 0 0 0.00
latch: checkpoint queue latch 1   0 0 0.00
SQL*Net message from client 291,061   325,345 1118 0.11
gcs remote message 5,329,984 2 13,646 3 2.03
PX Idle Wait 2,106 92 4,944 2347 0.00
jobq slave wait 1,311 100 3,836 2926 0.00
Streams AQ: qmn slave idle wait 144 3 3,734 25931 0.00
DIAG idle wait 17,934   3,503 195 0.01
ASM background timer 717   3,500 4881 0.00
Streams AQ: waiting for messages in the queue 382 94 3,496 9152 0.00
Streams AQ: qmn coordinator idle wait 258 49 3,477 13475 0.00
class slave wait 42 71 3,470 82630 0.00
ges remote message 799,096 0 3,451 4 0.30
Streams AQ: waiting for time management or cleanup tasks 240 88 3,379 14080 0.00
i/o slave wait 33,987   15 0 0.01
PX Deq: Execution Msg 732 20 9 13 0.00
PX Deq: Parse Reply 177 38 1 3 0.00
PX Deq: Execute Reply 897 31 0 0 0.00
PX Deq: Join ACK 196 34 0 1 0.00
PX Deq: Msg Fragment 332 37 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 258 100 0 0 0.00
PX Deq Credit: need buffer 17   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 2,466,327   489 0 0.94
events in waitclass Other 1,203,692 76 185 0 0.46
control file sequential read 72,109   85 1 0.03
row cache lock 5,806   3 1 0.00
control file parallel write 1,838   2 1 0.00
os thread startup 66   2 30 0.00
library cache lock 1,594   1 1 0.00
enq: TM - contention 911   1 1 0.00
gc current grant busy 22   1 44 0.00
gc cr block 2-way 403   1 2 0.00
gc current block 2-way 215   0 2 0.00
latch: shared pool 486   0 0 0.00
log file sequential read 24   0 5 0.00
library cache pin 125   0 0 0.00
gc cr block busy 2   0 7 0.00
buffer busy waits 101   0 0 0.00
log file single write 24   0 0 0.00
latch: library cache 3   0 1 0.00
gc current multi block request 15   0 0 0.00
latch: redo writing 4   0 0 0.00
latch: row cache objects 5   0 0 0.00
enq: TX - index contention 1   0 0 0.00
latch: cache buffers chains 1   0 0 0.00
rdbms ipc message 4,704,188 2 44,177 9 1.79
gcs remote message 5,329,989 2 13,646 3 2.03
DIAG idle wait 17,934   3,503 195 0.01
ASM background timer 717   3,500 4881 0.00
pmon timer 1,297 100 3,500 2698 0.00
smon timer 19   3,497 184039 0.00
Streams AQ: qmn coordinator idle wait 258 49 3,477 13475 0.00
class slave wait 30 100 3,470 115682 0.00
ges remote message 799,137 0 3,451 4 0.30
Streams AQ: waiting for time management or cleanup tasks 240 88 3,379 14080 0.00
Streams AQ: RAC qmn coordinator idle wait 258 100 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 824,051
IDLE_TIME 4,912,543
IOWAIT_TIME 123,037
NICE_TIME 43
SYS_TIME 122,453
USER_TIME 670,543
LOAD 2
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 2,330,242,048
VM_OUT_BYTES 12,582,185,984
PHYSICAL_MEMORY_BYTES 16,818,921,472
NUM_CPUS 16
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
gpsrac 8,152.80 6,372.80 137,443 138,488,503
SYS$USERS 27.90 24.50 320 112,667
SYS$BACKGROUND 0.10 0.10 907 1,015,989

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
gpsrac 150448 828 790753 582 0 0 460680 16
SYS$USERS 319 1 4869 3 0 0 2125 0
SYS$BACKGROUND 1046 6 12153 9 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
6,998 5,690 89,730 0.08 85.52 dpv463nz97byz WriteLog2.exe BEGIN SP_INSERT_TRCK_LOG_PRO(:...
1,270 1,263 2,599,936 0.00 15.52 6phc1ku32n2nv WriteLog2.exe SELECT B.CAR_ID, B.SIM_PHONE_N...
453 355 2,048,841 0.00 5.53 bb8csfdg2csnw WriteLog2.exe UPDATE GK_T_CARINFO SET LAST_L...
133 108 63,785 0.00 1.62 6zxmhyh4j6tw5 WriteLog.exe BEGIN SP_INSERT_EXTRA_LOG(:1, ...
89 66 389,637 0.00 1.08 csn11pnw68jrw WriteLog_Pro1.exe UPDATE GK_T_CARINFO SET LAST_L...
84 32 199,139 0.00 1.03 c9vtqdyxmru0z WriteLog2.exe INSERT INTO CW_T_GPSERROR (ERR...
39 30 199,139 0.00 0.48 g922ffvw9tj2v WriteLog.exe UPDATE GK_T_CARINFO SET RECEIV...
34 33 1,366 0.02 0.42 gx95dv43tmzhm OperationServer1.exe begin SP_EXEC_OPERATION(:V0000...
33 2 3,581 0.01 0.40 2ms9kbc7fh7q2 WriteLog1.exe INSERT INTO GJ_T_ONLINE_STATUS...
24 24 151,193 0.00 0.29 db78fxqxwxt7r   select /*+ rule */ bucket, end...

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
5,690 6,998 89,730 0.06 88.95 85.52 dpv463nz97byz WriteLog2.exe BEGIN SP_INSERT_TRCK_LOG_PRO(:...
1,263 1,270 2,599,936 0.00 19.74 15.52 6phc1ku32n2nv WriteLog2.exe SELECT B.CAR_ID, B.SIM_PHONE_N...
355 453 2,048,841 0.00 5.54 5.53 bb8csfdg2csnw WriteLog2.exe UPDATE GK_T_CARINFO SET LAST_L...
108 133 63,785 0.00 1.68 1.62 6zxmhyh4j6tw5 WriteLog.exe BEGIN SP_INSERT_EXTRA_LOG(:1, ...
66 89 389,637 0.00 1.03 1.08 csn11pnw68jrw WriteLog_Pro1.exe UPDATE GK_T_CARINFO SET LAST_L...
33 34 1,366 0.02 0.52 0.42 gx95dv43tmzhm OperationServer1.exe begin SP_EXEC_OPERATION(:V0000...
32 84 199,139 0.00 0.50 1.03 c9vtqdyxmru0z WriteLog2.exe INSERT INTO CW_T_GPSERROR (ERR...
30 39 199,139 0.00 0.47 0.48 g922ffvw9tj2v WriteLog.exe UPDATE GK_T_CARINFO SET RECEIV...
24 24 151,193 0.00 0.37 0.29 db78fxqxwxt7r   select /*+ rule */ bucket, end...
21 21 173 0.12 0.33 0.25 aatu8xtnnv2kr OperationServer1.exe select a.bill_id, a.bill_no, a...

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
116,903,391 89,730 1,302.84 83.73 5690.50 6997.50 dpv463nz97byz WriteLog2.exe BEGIN SP_INSERT_TRCK_LOG_PRO(:...
67,158,675 2,599,936 25.83 48.10 1262.56 1269.74 6phc1ku32n2nv WriteLog2.exe SELECT B.CAR_ID, B.SIM_PHONE_N...
10,667,174 2,048,841 5.21 7.64 354.55 452.50 bb8csfdg2csnw WriteLog2.exe UPDATE GK_T_CARINFO SET LAST_L...
4,397,621 1,366 3,219.34 3.15 33.36 33.99 gx95dv43tmzhm OperationServer1.exe begin SP_EXEC_OPERATION(:V0000...
2,888,915 173 16,698.93 2.07 20.87 20.57 aatu8xtnnv2kr OperationServer1.exe select a.bill_id, a.bill_no, a...
2,010,540 389,637 5.16 1.44 65.62 88.66 csn11pnw68jrw WriteLog_Pro1.exe UPDATE GK_T_CARINFO SET LAST_L...
1,721,689 63,785 26.99 1.23 107.57 132.77 6zxmhyh4j6tw5 WriteLog.exe BEGIN SP_INSERT_EXTRA_LOG(:1, ...
1,447,124 716 2,021.12 1.04 10.00 9.87 bn8xd39szdc47 OperationServer2.exe SELECT MAX(START_TIME) FROM CL...
1,446,512 716 2,020.27 1.04 10.34 10.17 df9gxkxu4s4d8 OperationServer2.exe UPDATE CL_T_VIDEO_RUNING SET E...
1,445,998 716 2,019.55 1.04 10.85 10.65 6mu0aapzu0b12 OperationServer2.exe SELECT COUNT(*) FROM CL_T_VIDE...

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
100,372 89,730 1.12 72.35 5690.50 6997.50 dpv463nz97byz WriteLog2.exe BEGIN SP_INSERT_TRCK_LOG_PRO(:...
6,079 199,139 0.03 4.38 32.24 84.20 c9vtqdyxmru0z WriteLog2.exe INSERT INTO CW_T_GPSERROR (ERR...
4,265 3,581 1.19 3.07 1.69 32.64 2ms9kbc7fh7q2 WriteLog1.exe INSERT INTO GJ_T_ONLINE_STATUS...
2,150 63,785 0.03 1.55 107.57 132.77 6zxmhyh4j6tw5 WriteLog.exe BEGIN SP_INSERT_EXTRA_LOG(:1, ...
553 13,327 0.04 0.40 2.89 7.47 3m03z4yx23pcj WriteLog_Pro1.exe INSERT INTO GJ_T_ALARM (CAR_ID...
283 63,610 0.00 0.20 6.29 10.52 4s03h5rggscv7 WriteLog2.exe INSERT INTO GJ_T_STATUS_CHANGE...
281 63,844 0.00 0.20 6.38 10.64 02351xuthccan WriteLog2.exe INSERT INTO GJ_T_STATUS_CHANGE...
69 2,490 0.03 0.05 0.54 1.11 g0yh4cb7k2pvk WriteLog2.exe insert into gj_t_track_37(CAR_...
60 1,366 0.04 0.04 33.36 33.99 gx95dv43tmzhm OperationServer1.exe begin SP_EXEC_OPERATION(:V0000...
39 151,193 0.00 0.03 23.87 23.56 db78fxqxwxt7r   select /*+ rule */ bucket, end...

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,599,936 2,573,808 0.99 0.00 0.00 6phc1ku32n2nv WriteLog2.exe SELECT B.CAR_ID, B.SIM_PHONE_N...
2,048,841 1,991,689 0.97 0.00 0.00 bb8csfdg2csnw WriteLog2.exe UPDATE GK_T_CARINFO SET LAST_L...
389,637 360,801 0.93 0.00 0.00 csn11pnw68jrw WriteLog_Pro1.exe UPDATE GK_T_CARINFO SET LAST_L...
199,139 199,139 1.00 0.00 0.00 c9vtqdyxmru0z WriteLog2.exe INSERT INTO CW_T_GPSERROR (ERR...
199,139 188,926 0.95 0.00 0.00 g922ffvw9tj2v WriteLog.exe UPDATE GK_T_CARINFO SET RECEIV...
151,193 2,825,889 18.69 0.00 0.00 db78fxqxwxt7r   select /*+ rule */ bucket, end...
89,730 89,729 1.00 0.06 0.08 dpv463nz97byz WriteLog2.exe BEGIN SP_INSERT_TRCK_LOG_PRO(:...
65,318 65,318 1.00 0.00 0.00 9k1twv42zm4w1 WriteLog_Pro1.exe SELECT B.CAR_ID, B.SIM_PHONE_N...
63,846 63,846 1.00 0.00 0.00 5nx71dzmgzrqa WriteLog2.exe UPDATE GK_T_CARINFO SET PRE_ST...
63,844 63,844 1.00 0.00 0.00 02351xuthccan WriteLog2.exe INSERT INTO GJ_T_STATUS_CHANGE...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
41,281 41,281 1.58 2jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
10,037 10,037 0.38 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
5,134 60,898 0.20 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
4,414 151,193 0.17 db78fxqxwxt7r   select /*+ rule */ bucket, end...
3,415 3,415 0.13 2ym6hhaq30r73   select type#, blocks, extents,...
2,967 2,967 0.11 520mkxqpf15q8   select 1 from dual
2,732 1,366 0.10 gx95dv43tmzhm OperationServer1.exe begin SP_EXEC_OPERATION(:V0000...
2,490 2,490 0.10 g0yh4cb7k2pvk WriteLog2.exe insert into gj_t_track_37(CAR_...
2,166 3,831 0.08 83taa7kaw59c1   select name, intcol#, segcol#,...
2,123 3,639 0.08 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,128,380 12 0.10 9pudktzqq9ywb   select a.obj# OBJOID, a.class_...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
656 1,689 1gu8t96d0bdmu   select t.ts#, t.file#, t.block...
436 852 32bhha21dkv0v   select col#, intcol#, charseti...
336 2 05sghzkq6r6yv   select ts#, file#, block#, col...
208 1,260 451q2032pshqm   select owner#, name, namespace...
206 3,415 2ym6hhaq30r73   select type#, blocks, extents,...
197 2,768 a73wbv1yu8x5c   select con#, type#, condlength...
95 4 3g7sxtj9d6zd3   select privilege#, nvl(col#, 0...
94 4,049 5ngzsfstg8tmy   select o.owner#, o.name, o.nam...
83 18 9m7787camwh4m PL/SQL Developer begin :id := sys.dbms_transact...
80 2,768 f8pavn1bvsj7t   select con#, obj#, rcon#, enab...
72 3,639 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
69 21 g3wrkmxkxzhf2   select cols, audit$, textlengt...
67 1,260 8swypbbr0m372   select order#, columns, types ...
65 2 bydf32qgqdwdu PL/SQL Developer begin sys.dbms_output.get_line...
65 1,366 gx95dv43tmzhm OperationServer1.exe begin SP_EXEC_OPERATION(:V0000...
64 16 1mjd9xp80vuqa   select node, owner, name from ...
64 41,281 2jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
62 3,027 2q93zsrvbdw48   select grantee#, privilege#, n...
62 3,027 6aq34nj2zb2n7   select col#, grantee#, privile...
61 13,772 53saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
60 363 9g485acn2n30m   select col#, intcol#, reftyp, ...
59 4,807 6769wyy3yf66f   select pos#, intcol#, col#, sp...
59 363 9rfqm06xmuwu0   select intcol#, toid, version#...
59 363 f3g84j69n0tjh   select col#, intcol#, ntab# fr...
54 1,363 0h6b2sajwb74n   select privilege#, level from ...
53 4,180 04xtrk7uyhknh   select obj#, type#, ctime, mti...
50 852 0fr8zhn4ymu3v   select intcol#, type, flags, l...
48 444 5ur69atw3vfhj   select decode(failover_method,...
47 454 0k8522rmdzg4k   select privilege# from sysauth...
46 158 39m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
46 3,831 83taa7kaw59c1   select name, intcol#, segcol#,...
44 108 c6awqs517jpj0   select /*+ index(idl_char$ i_i...
42 852 7nuw4xwrnuwxq   select col#, intcol#, toid, ve...
41 158 ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...
38 56 b1wc53ddd6h3p   select audit$, options from pr...
33 108 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
30 2,517 3c1kubcdjnppq   update sys.col_usage$ set equa...
29 92 cjk1ffy5kmm5s   select obj# from oid$ where us...
24 108 grwydz59pu6mc   select text from view$ where r...
22 852 6qz82dptj0qr7   select l.col#, l.intcol#, l.lo...
22 684 asvzxj61dc5vs   select timestamp, flags from f...
22 34 axmdf8vq7k1rh   select increment$, minvalue, m...
21 60,898 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...

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
145.55 2.08 6,997.50 5,690.50 89,730 dpv463nz97byz WriteLog2.exe BEGIN SP_INSERT_TRCK_LOG_PRO(:...
90.07 19.90 452.50 354.55 2,048,841 bb8csfdg2csnw WriteLog2.exe UPDATE GK_T_CARINFO SET LAST_L...
21.26 23.98 88.66 65.62 389,637 csn11pnw68jrw WriteLog_Pro1.exe UPDATE GK_T_CARINFO SET LAST_L...
9.09 23.10 39.35 30.13 199,139 g922ffvw9tj2v WriteLog.exe UPDATE GK_T_CARINFO SET RECEIV...
1.77 29.06 6.09 4.27 100 26sa46gsq676k BS_AutoSvr4.exe select t.car_id, t.work_begin,...
1.62 28.92 5.60 4.08 126 bz3hgzm395m49 BS_AutoSvr3.exe select t.car_id, t.work_begin,...
1.62 1.92 84.20 32.24 199,139 c9vtqdyxmru0z WriteLog2.exe INSERT INTO CW_T_GPSERROR (ERR...
1.39 13.85 10.02 8.72 106 1knd0w1tt5gyf BS_AutoSvr.exe select t.car_id, t.work_begin,...
1.37 1.03 132.77 107.57 63,785 6zxmhyh4j6tw5 WriteLog.exe BEGIN SP_INSERT_EXTRA_LOG(:1, ...
1.23 8.30 14.77 13.76 126 2w3a3xq7n75xr BS_AutoSvr3.exe select t1.car_id, t2.sim_phone...
1.04 8.21 12.66 11.71 100 2k4a2vagdc4q7 BS_AutoSvr4.exe select t1.car_id, t2.sim_phone...
0.92 5.58 16.53 15.87 106 acam1smv56c80 BS_AutoSvr.exe select t1.car_id, t2.sim_phone...
0.88 2.69 32.64 1.69 3,581 2ms9kbc7fh7q2 WriteLog1.exe INSERT INTO GJ_T_ONLINE_STATUS...
0.55 1.63 33.99 33.36 1,366 gx95dv43tmzhm OperationServer1.exe begin SP_EXEC_OPERATION(:V0000...
0.33 4.37 7.47 2.89 13,327 3m03z4yx23pcj WriteLog_Pro1.exe INSERT INTO GJ_T_ALARM (CAR_ID...
0.12 19.30 0.60 0.46 2,517 3c1kubcdjnppq   update sys.col_usage$ set equa...
0.11 1.02 10.52 6.29 63,610 4s03h5rggscv7 WriteLog2.exe INSERT INTO GJ_T_STATUS_CHANGE...
0.10 4.08 2.53 2.48 10,037 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
0.10 0.01 1,269.74 1,262.56 2,599,936 6phc1ku32n2nv WriteLog2.exe SELECT B.CAR_ID, B.SIM_PHONE_N...
0.09 0.38 23.56 23.87 151,193 db78fxqxwxt7r   select /*+ rule */ bucket, end...
0.08 0.72 10.64 6.38 63,844 02351xuthccan WriteLog2.exe INSERT INTO GJ_T_STATUS_CHANGE...
0.03 0.88 3.55 4.62 60,898 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
0.03 11.67 0.22 0.16 1,260 8swypbbr0m372   select order#, columns, types ...
0.02 47.65 0.05 0.03 108 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
0.02 0.20 10.65 10.85 716 6mu0aapzu0b12 OperationServer2.exe SELECT COUNT(*) FROM CL_T_VIDE...
0.02 7.06 0.29 0.32 3,415 2ym6hhaq30r73   select type#, blocks, extents,...
0.02 0.20 9.87 10.00 716 bn8xd39szdc47 OperationServer2.exe SELECT MAX(START_TIME) FROM CL...
0.02 3.09 0.49 0.33 1,260 451q2032pshqm   select owner#, name, namespace...
0.01 2.22 0.66 0.33 1,570 b1hgs0rhyhhzd WriteLog2.exe insert into gj_t_track_46(CAR_...
0.01 14.63 0.09 0.02 158 39m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
0.01 0.18 7.01 6.01 63,611 f261qh5gy6rrw WriteLog1.exe UPDATE GK_T_CARINFO SET PRE_ST...
0.01 28.93 0.04 0.03 158 ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...
0.01 0.12 10.17 10.34 716 df9gxkxu4s4d8 OperationServer2.exe UPDATE CL_T_VIDEO_RUNING SET E...
0.01 0.96 1.11 0.54 2,490 g0yh4cb7k2pvk WriteLog2.exe insert into gj_t_track_37(CAR_...
0.01 25.24 0.04 0.04 13 0v3dvmc22qnam   insert into sys.col_usage$ (ob...
0.01 0.13 5.74 5.82 20 1v9rbax20f59b serverMonitor.exe select t1.middle_no||case when...
0.01 6.52 0.10 0.04 34 axmdf8vq7k1rh   select increment$, minvalue, m...
0.01 2.04 0.32 0.38 4,049 5ngzsfstg8tmy   select o.owner#, o.name, o.nam...
0.01 0.34 1.49 1.49 20 4czh68g5wyhm4 serverMonitor.exe select t2.employee_no, sum(cas...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
02351xuthccanINSERT INTO GJ_T_STATUS_CHANGE (TRACK_TIME, STATUS_TYPE, PRE_VALUE, CUR_VALUE, CAR_ID, LNG, LAT, STATUS, MILEAGE, SPEED) VALUES (:B7 , '008', '1', '0', :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
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
05sghzkq6r6yvselect ts#, file#, block#, cols, nvl(size$, -1), pctfree$, pctused$, initrans, maxtrans, hashkeys, func, extind, avgchn, nvl(degree, 1), nvl(instances, 1), nvl(flags, 0), nvl(spare1, 0)from clu$ where obj#=:1
0fr8zhn4ymu3vselect intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc
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
0v3dvmc22qnaminsert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1knd0w1tt5gyfselect t.car_id, t.work_begin, t.work_end from GK_T_BS_SECTION t where exists (select t1.car_id from GK_T_BS_PARAM T1, GK_T_CARINFO T2 where t1.car_id=t2.car_id(+) and t1.valid_time<=sysdate and (t1.invalid_time>=sysdate or t1.invalid_time is null) and t2.delete_flag='0' and t1.sta_id='001' and t.car_id=t1.car_id ) order by t.car_id, t.work_begin
1mjd9xp80vuqaselect node, owner, name from syn$ where obj#=:1
1v9rbax20f59bselect t1.middle_no||case when t1.middle_type='' or t1.middle_type=0 then '(³µÔØ)' else '(¸öÈË)' end as newMiddle_no , t1.middle_type, sum(case when (sysdate - t.RECEIVE_TIME)<=6/24/60 then 1 else 0 end) onl, sum(case when t.RECEIVE_TIME=NULL then 1 else 0 end) newl, count(*) allcount from gk_t_carinfo t, gk_t_middle_part t1, gk_t_mdtinfo t2 where t.delete_flag = '0' and t.mdt_id = t2.mdt_id and t2.middle_id = t1.middle_id and t1.Is_use in (0 , 2)group by (t1.middle_no, t1.middle_type) order by newMiddle_no
26sa46gsq676kselect t.car_id, t.work_begin, t.work_end from GK_T_BS_SECTION t where exists (select t1.car_id from GK_T_BS_PARAM T1, GK_T_CARINFO T2 where t1.car_id=t2.car_id(+) and t1.valid_time<=sysdate and (t1.invalid_time>=sysdate or t1.invalid_time is null) and t2.delete_flag='0' and t1.sta_id='004' and t.car_id=t1.car_id ) order by t.car_id, t.work_begin
2jfqzrxhrm93bselect /*+ rule */ 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#
2k4a2vagdc4q7select t1.car_id, t2.sim_phone_no as sim_phone_no, t1.last_time, t1.loc_interval, last_time+loc_interval/24/3600 as next_time, work_begin, work_end, loc_type, noc , t3.mdt_no, t4.middle_no from GK_T_BS_PARAM T1, GK_T_CARINFO T2, GK_T_MDTINFO T3, GK_T_MIDDLE_PART T4 where t1.car_id=t2.car_id(+) AND t3.mdt_id=t2.mdt_id and t4.middle_id=t3.middle_id and t2.delete_flag='0' and t1.valid_time<=sysdate and (t1.invalid_time>=sysdate or t1.invalid_time is null) and t1.sta_id='004' order by sim_phone_no
2ms9kbc7fh7q2INSERT INTO GJ_T_ONLINE_STATUS (STATUS_TYPE, CAR_ID, MOBIL_NO, EQUIPMENT_NO, TRACK_TIME, LONGITUDE, LATITUDE, SPEED, DIRECTION, STATUS, COMPUTER_TIME, RECEIVE_TIME, ACC, MILE_SUM, STATUS_PARAM) VALUES ('0', :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , SYSDATE, :B4 , :B3 , :B2 , :B1 )
2q93zsrvbdw48select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2w3a3xq7n75xrselect t1.car_id, t2.sim_phone_no as sim_phone_no, t1.last_time, t1.loc_interval, last_time+loc_interval/24/3600 as next_time, work_begin, work_end, loc_type, noc , t3.mdt_no, t4.middle_no from GK_T_BS_PARAM T1, GK_T_CARINFO T2, GK_T_MDTINFO T3, GK_T_MIDDLE_PART T4 where t1.car_id=t2.car_id(+) AND t3.mdt_id=t2.mdt_id and t4.middle_id=t3.middle_id and t2.delete_flag='0' and t1.valid_time<=sysdate and (t1.invalid_time>=sysdate or t1.invalid_time is null) and t1.sta_id='003' order by sim_phone_no
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
32bhha21dkv0vselect col#, intcol#, charsetid, charsetform from col$ where obj#=:1 order by intcol# asc
39m4sx9k63ba2select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
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
3g7sxtj9d6zd3select privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 and grantee#=:2 group by privilege#, nvl(col#, 0)
3m03z4yx23pcjINSERT INTO GJ_T_ALARM (CAR_ID, MOBIL_NO, EQUIPMENT_NO, TRACK_TIME, LONGITUDE, LATITUDE, SPEED, DIRECTION, ALARM, COMPUTER_TIME, HEIGH) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , SYSDATE, :B1 )
451q2032pshqmselect owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
4czh68g5wyhm4select t2.employee_no, sum(case when (sysdate - t.RECEIVE_TIME) <=6/24/60 then 1 else 0 end) onl, sum(case when t.RECEIVE_TIME = NULL then 1 else 0 end) newl, count(*) allcount from gk_t_carinfo t, CL_T_USER_PRIVILEGE t1, rs_t_employee t2 where t.delete_flag = '0' and t1.car_id = t.car_id and t1.user_id = t2.user_id and t2.employee_no in ('fzshwl', 'fzhxczc') group by t2.employee_no
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4s03h5rggscv7INSERT INTO GJ_T_STATUS_CHANGE (TRACK_TIME, STATUS_TYPE, PRE_VALUE, CUR_VALUE, CAR_ID, LNG, LAT, STATUS, MILEAGE, SPEED) VALUES (:B7 , '008', '0', '1', :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
520mkxqpf15q8select 1 from dual
53saa2zkr6wc3select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5ngzsfstg8tmyselect o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
5nx71dzmgzrqaUPDATE GK_T_CARINFO SET PRE_STOP_TIME = :B2 , COMMON_FLAG=COMMON_FLAG - BITAND(COMMON_FLAG, 2) WHERE CAR_ID=:B1
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6769wyy3yf66fselect pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6aq34nj2zb2n7select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6mu0aapzu0b12SELECT COUNT(*) FROM CL_T_VIDEO_RUNING WHERE CAR_ID=:B6 AND CAM_ID=:B5 AND USER_ID=:B4 AND LAN_IP=:B3 AND WAN_IP=:B2 AND END_TIME>:B1 -1/180/12
6phc1ku32n2nvSELECT B.CAR_ID, B.SIM_PHONE_NO, A.MDT_ID, B.LAST_REPORT_TIME, B.LAST_LONGITUDE, B.LAST_LATITUDE, B.RECEIVE_TIME, B.FIRST_BACK, B.SERVICE_DATE, B.MILEAGE, B.LAST_ALARM_ID, C.MIDDLE_NO, B.LAST_SPEED FROM GK_T_MDTINFO A, GK_T_CARINFO B, GK_T_MIDDLE_PART C WHERE A.MDT_NO = :B1 AND C.MIDDLE_ID = A.MIDDLE_ID AND A.MDT_ID = B.MDT_ID AND B.DELETE_FLAG = '0' AND ROWNUM = 1
6qz82dptj0qr7select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc
6zxmhyh4j6tw5BEGIN SP_INSERT_EXTRA_LOG(:1, :2, :3); END;
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7nuw4xwrnuwxqselect col#, intcol#, toid, version#, packed, intcols, intcol#s, flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc
83taa7kaw59c1select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9g485acn2n30mselect col#, intcol#, reftyp, stabid, expctoid from refcon$ where obj#=:1 order by intcol# asc
9k1twv42zm4w1SELECT B.CAR_ID, B.SIM_PHONE_NO, A.MDT_ID, B.LAST_REPORT_TIME, B.LAST_LONGITUDE, B.LAST_LATITUDE, B.RECEIVE_TIME, B.FIRST_BACK, B.SERVICE_DATE, B.MILEAGE, B.COMPANY_ID, B.DRIVER_NO, B.LAST_ALARM_ID, B.LAST_SPEED, B.COMMON_FLAG FROM GK_T_MDTINFO A, GK_T_CARINFO B, GK_T_MIDDLE_PART C WHERE C.MIDDLE_NO = :B2 AND A.MDT_NO = :B1 AND C.MIDDLE_ID = A.MIDDLE_ID AND A.MDT_ID = B.MDT_ID AND B.DELETE_FLAG = '0' AND ROWNUM = 1
9m7787camwh4mbegin :id := sys.dbms_transaction.local_transaction_id; end;
9pudktzqq9ywbselect a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.class_oid is not null and a.class_oid in (select b.obj# from scheduler$_class b where bitand(b.flags, :4) <> 0 and lower(b.affinity) = lower(:5)) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
9rfqm06xmuwu0select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc
a73wbv1yu8x5cselect con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1
aatu8xtnnv2krselect a.bill_id, a.bill_no, a.carton_num from YH_T_COSCO_BILLOFLADING A left join RS_T_DEPARTMENT C on A.TRAILER_COMPANY = C.DEPARTMENT_ID where a.trailer_company in(select department_id from rs_t_department t start with t.DEPARTMENT_ID = 60142 connect by t.FATHER_DEPARTMENT = prior t.DEPARTMENT_ID) and not exists (select bill_id from YH_T_COSCO_TOW_PLAN T where a.bill_id = t.bill_id)
acam1smv56c80select t1.car_id, t2.sim_phone_no as sim_phone_no, t1.last_time, t1.loc_interval, last_time+loc_interval/24/3600 as next_time, work_begin, work_end, loc_type, noc , t3.mdt_no, t4.middle_no from GK_T_BS_PARAM T1, GK_T_CARINFO T2, GK_T_MDTINFO T3, GK_T_MIDDLE_PART T4 where t1.car_id=t2.car_id(+) AND t3.mdt_id=t2.mdt_id and t4.middle_id=t3.middle_id and t2.delete_flag='0' and t1.valid_time<=sysdate and (t1.invalid_time>=sysdate or t1.invalid_time is null) and t1.sta_id='001' order by sim_phone_no
asvzxj61dc5vsselect timestamp, flags from fixed_obj$ where obj#=:1
axmdf8vq7k1rhselect increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
b1hgs0rhyhhzdinsert into gj_t_track_46(CAR_ID, MOBIL_NO, EQUIPMENT_NO, TRACK_TIME, LONGITUDE, LATITUDE, SPEED, DIRECTION, STATUS, COMPUTER_TIME, HEIGH, RECEIVE_TIME, ACC, MILE_SUM, STATUS_PARAM) values (299046, '13328740146', '13328740146', :sTRACKTIME , 116.892397, 25.132512, 0, 144, '103', sysdate, 456, :dRecvTime, :ACC, 38236.756236, 1 )
b1wc53ddd6h3pselect audit$, options from procedure$ where obj#=:1
bb8csfdg2csnwUPDATE GK_T_CARINFO SET LAST_LONGITUDE = :B11 , LAST_LATITUDE = :B10 , LAST_REPORT_TIME = :B1 , LAST_SPEED = :B9 , HEIGH = :B8 , LAST_DIRCTION = :B7 , LAST_STATUS_ID = :B6 , LAST_ALARM_ID = :B5 , RECEIVE_TIME = :B4 , MILEAGE = :B3 , ACC_OPEN_TIME = :B1 WHERE CAR_ID = :B2 AND ((LAST_REPORT_TIME IS NULL) OR (LAST_REPORT_TIME < :B1 ))
bn8xd39szdc47SELECT MAX(START_TIME) FROM CL_T_VIDEO_RUNING WHERE CAR_ID=:B6 AND CAM_ID=:B5 AND USER_ID=:B4 AND LAN_IP=:B3 AND WAN_IP=:B2 AND END_TIME>:B1 -1/180/12
bydf32qgqdwdubegin sys.dbms_output.get_line(line => :line, status => :status); end;
bz3hgzm395m49select t.car_id, t.work_begin, t.work_end from GK_T_BS_SECTION t where exists (select t1.car_id from GK_T_BS_PARAM T1, GK_T_CARINFO T2 where t1.car_id=t2.car_id(+) and t1.valid_time<=sysdate and (t1.invalid_time>=sysdate or t1.invalid_time is null) and t2.delete_flag='0' and t1.sta_id='003' and t.car_id=t1.car_id ) order by t.car_id, t.work_begin
c6awqs517jpj0select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
c9vtqdyxmru0zINSERT INTO CW_T_GPSERROR (ERROR_ID, MDT_ID, GPS_TIME, IS_VALID, LONGITUDE, LATITUDE, HEIGHT, DIRECTION, SPEED, RECEIVE_TIME, ERROR_REMARK, INPUT_TIME) VALUES (CW_S_GPSERROR.NEXTVAL, :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 , SYSDATE)
cjk1ffy5kmm5sselect obj# from oid$ where user#=:1 and oid$=:2
csn11pnw68jrwUPDATE GK_T_CARINFO SET LAST_LONGITUDE = :B11 , LAST_LATITUDE = :B10 , LAST_REPORT_TIME = :B1 , LAST_SPEED = :B9 , HEIGH = :B8 , LAST_DIRCTION = :B7 , LAST_STATUS_ID = :B6 , LAST_ALARM_ID = :B5 , RECEIVE_TIME = :B4 , MILEAGE = :B3 WHERE CAR_ID = :B2 AND ((LAST_REPORT_TIME IS NULL) OR (LAST_REPORT_TIME < :B1 ))
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
df9gxkxu4s4d8UPDATE CL_T_VIDEO_RUNING SET END_TIME=:B7 WHERE CAR_ID=:B6 AND CAM_ID=:B5 AND USER_ID=:B4 AND LAN_IP=:B3 AND WAN_IP=:B2 AND START_TIME=:B1
dpv463nz97byzBEGIN SP_INSERT_TRCK_LOG_PRO(:1, :2, :3); END;
f261qh5gy6rrwUPDATE GK_T_CARINFO SET PRE_STOP_TIME = :B2 , COMMON_FLAG=COMMON_FLAG + 2 - BITAND(COMMON_FLAG, 2) WHERE CAR_ID=:B1
f3g84j69n0tjhselect col#, intcol#, ntab# from ntab$ where obj#=:1 order by intcol# asc
f8pavn1bvsj7tselect con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1
g0yh4cb7k2pvkinsert into gj_t_track_37(CAR_ID, MOBIL_NO, EQUIPMENT_NO, TRACK_TIME, LONGITUDE, LATITUDE, SPEED, DIRECTION, STATUS, COMPUTER_TIME, HEIGH, RECEIVE_TIME, ACC, MILE_SUM, STATUS_PARAM) values (266837, '18050579031', '9151312011944', :sTRACKTIME , 118.966312, 25.707523, 0, 310, '103', sysdate, 274, :dRecvTime, :ACC, 75529.044, 1 )
g3wrkmxkxzhf2select cols, audit$, textlength, intcols, property, flags, rowid from view$ where obj#=:1
g922ffvw9tj2vUPDATE GK_T_CARINFO SET RECEIVE_TIME = :B1 WHERE CAR_ID = :B2 AND ((RECEIVE_TIME IS NULL) OR (RECEIVE_TIME < :B1 ))
ga9j9xk5cy9s0select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
grwydz59pu6mcselect text from view$ where rowid=:1
gx95dv43tmzhmbegin SP_EXEC_OPERATION(:V00001, :V00002, :V00003); end;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 636,162 177.37 0.24
CPU used when call started 635,250 177.12 0.24
CR blocks created 138,782 38.70 0.05
Cached Commit SCN referenced 2,988 0.83 0.00
Commit SCN cached 2 0.00 0.00
DB time 1,591,359 443.70 0.61
DBWR checkpoint buffers written 686,054 191.29 0.26
DBWR checkpoints 12 0.00 0.00
DBWR fusion writes 31,829 8.87 0.01
DBWR object drop buffers written 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 134 0.04 0.00
DBWR undo block writes 271,928 75.82 0.10
DFO trees parallelized 72 0.02 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 810 0.23 0.00
PX local messages sent 810 0.23 0.00
PX remote messages recv'd 848 0.24 0.00
PX remote messages sent 474 0.13 0.00
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 72 0.02 0.00
RowCR - row contention 5 0.00 0.00
RowCR attempts 4,834 1.35 0.00
RowCR hits 4,507 1.26 0.00
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment shrink 3 0.00 0.00
SQL*Net roundtrips to/from client 289,130 80.62 0.11
active txn count during cleanout 558,426 155.70 0.21
application wait time 138 0.04 0.00
background checkpoints completed 12 0.00 0.00
background checkpoints started 12 0.00 0.00
background timeouts 15,052 4.20 0.01
branch node splits 116 0.03 0.00
buffer is not pinned count 28,535,852 7,956.36 10.87
buffer is pinned count 14,627,544 4,078.45 5.57
bytes received via SQL*Net from client 428,875,962 119,579.07 163.43
bytes sent via SQL*Net to client 137,809,300 38,423.95 52.51
calls to get snapshot scn: kcmgss 11,567,905 3,225.36 4.41
calls to kcmgas 4,268,547 1,190.16 1.63
calls to kcmgcs 64,810 18.07 0.02
change write time 23,294 6.49 0.01
cleanout - number of ktugct calls 195,992 54.65 0.07
cleanouts and rollbacks - consistent read gets 1,591 0.44 0.00
cleanouts only - consistent read gets 213 0.06 0.00
cluster key scan block gets 251,918 70.24 0.10
cluster key scans 215,935 60.21 0.08
cluster wait time 19,322 5.39 0.01
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 41,673 11.62 0.02
commit batch/immediate requested 41,673 11.62 0.02
commit cleanout failures: block lost 58 0.02 0.00
commit cleanout failures: buffer being written 17 0.00 0.00
commit cleanout failures: callback failure 65,335 18.22 0.02
commit cleanout failures: cannot pin 415 0.12 0.00
commit cleanouts 10,828,266 3,019.13 4.13
commit cleanouts successfully completed 10,762,441 3,000.78 4.10
commit immediate performed 41,673 11.62 0.02
commit immediate requested 41,673 11.62 0.02
commit txn count during cleanout 1,618,130 451.17 0.62
concurrency wait time 59,393 16.56 0.02
consistent changes 248,415 69.26 0.09
consistent gets 100,787,121 28,101.44 38.41
consistent gets - examination 26,078,928 7,271.32 9.94
consistent gets direct 22,376 6.24 0.01
consistent gets from cache 100,764,745 28,095.20 38.40
current blocks converted for CR 0 0.00 0.00
cursor authentications 78,716 21.95 0.03
data blocks consistent reads - undo records applied 229,015 63.85 0.09
db block changes 28,725,662 8,009.28 10.95
db block gets 38,827,466 10,825.86 14.80
db block gets direct 13,199 3.68 0.01
db block gets from cache 38,814,266 10,822.18 14.79
deferred (CURRENT) block cleanout applications 4,693,553 1,308.66 1.79
dirty buffers inspected 54 0.02 0.00
enqueue conversions 1,026 0.29 0.00
enqueue releases 9,871,767 2,752.44 3.76
enqueue requests 9,871,888 2,752.48 3.76
enqueue timeouts 119 0.03 0.00
enqueue waits 5,759 1.61 0.00
exchange deadlocks 6 0.00 0.00
execute count 8,911,401 2,484.67 3.40
failed probes on index block reclamation 6 0.00 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 589,364 164.33 0.22
free buffer requested 741,249 206.67 0.28
gc CPU used by this session 88,661 24.72 0.03
gc blocks corrupt 0 0.00 0.00
gc blocks lost 0 0.00 0.00
gc cr block build time 1,353 0.38 0.00
gc cr block flush time 525 0.15 0.00
gc cr block receive time 1,003 0.28 0.00
gc cr block send time 2,655 0.74 0.00
gc cr blocks received 5,653 1.58 0.00
gc cr blocks served 660,222 184.08 0.25
gc current block flush time 190,732 53.18 0.07
gc current block pin time 1,527,360 425.86 0.58
gc current block receive time 3,776 1.05 0.00
gc current block send time 394 0.11 0.00
gc current blocks received 27,840 7.76 0.01
gc current blocks served 92,901 25.90 0.04
gc local grants 360,420 100.49 0.14
gc remote grants 123,247 34.36 0.05
gcs messages sent 2,828,237 788.57 1.08
ges messages sent 1,399,971 390.34 0.53
global enqueue get time 73,360 20.45 0.03
global enqueue gets async 84,101 23.45 0.03
global enqueue gets sync 7,193,262 2,005.62 2.74
global enqueue releases 7,256,281 2,023.19 2.77
heap block compress 691,138 192.70 0.26
hot buffers moved to head of LRU 143,203 39.93 0.05
immediate (CR) block cleanout applications 1,804 0.50 0.00
immediate (CURRENT) block cleanout applications 180,333 50.28 0.07
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 12,863 3.59 0.00
index fast full scans (full) 2,630 0.73 0.00
index fetch by key 11,801,281 3,290.43 4.50
index scans kdiixs1 2,881,816 803.51 1.10
leaf node 90-10 splits 1,798 0.50 0.00
leaf node splits 33,884 9.45 0.01
lob reads 5,088 1.42 0.00
lob writes 10,998 3.07 0.00
lob writes unaligned 5,450 1.52 0.00
logons cumulative 695 0.19 0.00
messages received 5,081,093 1,416.71 1.94
messages sent 5,081,093 1,416.71 1.94
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 71,618,497 19,968.65 27.29
opened cursors cumulative 397,696 110.89 0.15
parse count (failures) 150 0.04 0.00
parse count (hard) 1,512,203 421.63 0.58
parse count (total) 2,618,767 730.16 1.00
parse time cpu 66,645 18.58 0.03
parse time elapsed 73,912 20.61 0.03
physical read IO requests 138,705 38.67 0.05
physical read bytes 1,136,500,736 316,878.81 433.07
physical read total IO requests 211,328 58.92 0.08
physical read total bytes 2,324,738,048 648,182.79 885.85
physical read total multi block requests 6 0.00 0.00
physical reads 138,733 38.68 0.05
physical reads cache 120,018 33.46 0.05
physical reads cache prefetch 31 0.01 0.00
physical reads direct 18,715 5.22 0.01
physical reads direct (lob) 5,548 1.55 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 330,658 92.19 0.13
physical write bytes 6,030,155,776 1,681,326.29 2,297.82
physical write total IO requests 2,907,429 810.65 1.11
physical write total bytes 12,336,088,576 3,439,544.66 4,700.74
physical write total multi block requests 2,496,052 695.95 0.95
physical writes 736,103 205.24 0.28
physical writes direct 13,199 3.68 0.01
physical writes direct (lob) 13,171 3.67 0.01
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 722,904 201.56 0.28
physical writes non checkpoint 409,480 114.17 0.16
pinned buffers inspected 5 0.00 0.00
prefetch clients - default 0 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 3,519 0.98 0.00
queries parallelized 36 0.01 0.00
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 17,019,688 4,745.42 6.49
recursive cpu usage 498,729 139.06 0.19
redo blocks written 12,257,437 3,417.62 4.67
redo buffer allocation retries 78 0.02 0.00
redo entries 14,957,711 4,170.50 5.70
redo log space requests 86 0.02 0.00
redo log space wait time 227 0.06 0.00
redo ordering marks 245,522 68.46 0.09
redo size 5,369,347,040 1,497,079.79 2,046.02
redo subscn max counts 31,408 8.76 0.01
redo synch time 35,565 9.92 0.01
redo synch writes 177,562 49.51 0.07
redo wastage 704,304,924 196,374.10 268.38
redo write broadcast ack time 145,924 40.69 0.06
redo write time 69,457 19.37 0.03
redo writer latching time 255 0.07 0.00
redo writes 2,466,305 687.65 0.94
rollback changes - undo records applied 42,541 11.86 0.02
rollbacks only - consistent read gets 137,076 38.22 0.05
root node splits 0 0.00 0.00
rows fetched via callback 7,095,417 1,978.34 2.70
session connect time 0 0.00 0.00
session cursor cache hits 310,962 86.70 0.12
session logical reads 139,614,604 38,927.30 53.20
shared hash latch upgrades - no wait 300,484 83.78 0.11
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 462,135 128.85 0.18
sorts (rows) 10,707,716 2,985.52 4.08
sql area evicted 1,511,534 421.45 0.58
sql area purged 150 0.04 0.00
summed dirty queue length 172 0.05 0.00
switch current to new buffer 8,387 2.34 0.00
table fetch by rowid 15,738,029 4,388.07 6.00
table fetch continued row 448,650 125.09 0.17
table scan blocks gotten 7,891,575 2,200.33 3.01
table scan rows gotten 503,689,073 140,438.44 191.93
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 0 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 17,424 4.86 0.01
total number of times SMON posted 19 0.01 0.00
transaction lock background get time 0 0.00 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 41,673 11.62 0.02
transaction tables consistent read rollbacks 12 0.00 0.00
transaction tables consistent reads - undo records applied 1,249 0.35 0.00
undo change vector size 1,697,422,484 473,274.85 646.81
user I/O wait time 83,527 23.29 0.03
user calls 337,584 94.13 0.13
user commits 2,624,077 731.64 1.00
user rollbacks 212 0.06 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 299,397 83.48 0.11
write clones created in background 3 0.00 0.00
write clones created in foreground 28 0.01 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 5.5E+12 5.5E+12
session cursor cache count 24,304,895 24,313,860
session uga memory 6.2E+14 6.2E+14
opened cursors current 654 648
workarea memory allocated 2,246 184
logons current 149 155
session uga memory max 3.1E+12 3.1E+12
session pga memory 2.1E+12 2.1E+12

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 12 12.05

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)
FJSATCOM_TRCK_IDX 53,087 15 6.88 1.00 179,477 50 507 0.08
FJSATCOMNOR 84,162 23 5.37 1.00 130,515 36 465 3.12
UNDOTBS1 0 0 0.00 0.00 19,222 5 1,261 0.05
SYSAUX 1,029 0 5.10 1.02 503 0 0 0.00
FJSATCOM_OTHER_IDX 139 0 6.76 1.00 834 0 0 0.00
SYSTEM 215 0 5.67 1.05 190 0 0 0.00
TEMP 0 0 0.00   27 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)
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor01.dbf 965 0 6.05 1.00 1,265 0 5 4.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor02.dbf 1,074 0 5.43 1.00 1,278 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor03.dbf 857 0 6.14 1.00 1,065 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor04.dbf 1,504 0 6.74 1.00 1,629 0 3 3.33
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor05.dbf 932 0 5.87 1.00 1,162 0 1 10.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor06.dbf 1,122 0 5.44 1.00 1,465 0 4 5.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor07.dbf 676 0 5.27 1.00 1,004 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor08.dbf 1,382 0 5.91 1.00 1,759 0 3 6.67
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor09.dbf 788 0 5.81 1.00 1,087 0 2 10.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor10.dbf 1,308 0 5.98 1.00 1,279 0 8 5.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor11.dbf 961 0 4.72 1.00 810 0 17 6.47
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor12.dbf 948 0 6.01 1.00 1,442 0 2 5.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor13.dbf 824 0 5.41 1.00 1,123 0 7 10.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor14.dbf 919 0 5.90 1.00 1,259 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor15.dbf 980 0 4.84 1.00 1,177 0 3 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor16.dbf 964 0 6.13 1.00 1,227 0 7 2.86
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor17.dbf 506 0 5.08 1.00 798 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor18.dbf 1,050 0 6.31 1.00 1,072 0 2 5.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor19.dbf 902 0 5.42 1.00 1,574 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor20.dbf 868 0 6.41 1.00 1,112 0 4 7.50
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor21.dbf 1,313 0 5.50 1.00 1,294 0 2 5.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor22.dbf 672 0 5.94 1.00 1,144 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor23.dbf 685 0 5.26 1.00 1,085 0 4 5.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor24.dbf 1,397 0 5.31 1.00 1,509 0 3 10.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor25.dbf 1,313 0 5.42 1.00 1,258 0 2 5.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor26.dbf 1,274 0 6.81 1.00 3,094 1 4 2.50
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor27.dbf 674 0 6.71 1.00 961 0 4 17.50
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor28.dbf 938 0 6.27 1.00 1,352 0 4 17.50
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor29.dbf 828 0 5.21 1.00 928 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor30.dbf 861 0 5.60 1.00 1,235 0 9 2.22
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor31.dbf 968 0 4.35 1.00 6,969 2 29 2.07
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor32.dbf 1,127 0 4.38 1.00 968 0 24 2.92
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor33.dbf 107 0 6.17 1.00 144 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor34.dbf 1,253 0 4.98 1.00 983 0 12 4.17
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor35.dbf 748 0 4.53 1.00 7,067 2 23 0.43
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor36.dbf 794 0 4.06 1.00 763 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor37.dbf 873 0 4.07 1.00 7,139 2 32 0.63
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor38.dbf 705 0 4.88 1.00 742 0 1 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor39.dbf 40 0 7.75 1.00 56 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor40.dbf 1,387 0 5.35 1.00 1,076 0 17 9.41
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor41.dbf 850 0 3.68 1.00 578 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor42.dbf 1,039 0 4.41 1.00 931 0 1 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor43.dbf 822 0 4.89 1.00 658 0 1 10.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor44.dbf 560 0 3.29 1.00 495 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor45.dbf 575 0 4.10 1.00 514 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor46.dbf 1,306 0 5.02 1.00 1,213 0 2 5.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor47.dbf 1,693 0 3.76 1.00 1,174 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor48.dbf 1,690 0 3.27 1.00 1,169 0 2 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor49.dbf 1,171 0 3.93 1.00 971 0 1 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor50.dbf 1,300 0 3.17 1.00 984 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor51.dbf 2,027 1 5.74 1.00 9,731 3 15 3.33
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor52.dbf 1,089 0 6.47 1.00 8,020 2 37 0.81
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor53.dbf 1,057 0 6.18 1.00 1,375 0 4 2.50
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor54.dbf 1,060 0 6.74 1.00 1,141 0 3 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor55.dbf 1,682 0 5.05 1.00 1,385 0 8 3.75
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor56.dbf 1,770 0 4.64 1.00 1,482 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor57.dbf. 1,365 0 5.53 1.00 1,365 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor58.dbf 970 0 5.36 1.00 1,110 0 1 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor59.dbf 1,563 0 5.36 1.00 1,283 0 5 6.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor60.dbf 1,840 1 4.97 1.00 1,572 0 9 2.22
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor61.dbf 1,536 0 5.31 1.00 1,194 0 5 10.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor62.dbf 743 0 5.32 1.00 1,048 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor63.dbf 871 0 4.98 1.00 1,120 0 1 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor64.dbf 1,210 0 5.44 1.00 1,262 0 10 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor65.dbf 1,423 0 5.66 1.00 1,576 0 16 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor66.dbf 1,458 0 6.89 1.00 1,617 0 21 0.48
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor67.dbf 1,254 0 5.09 1.00 987 0 17 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor68.dbf 931 0 5.20 1.00 1,020 0 9 1.11
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor69.dbf 1,216 0 6.13 1.00 1,404 0 7 4.29
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor70.dbf 1,707 0 4.99 1.00 1,497 0 5 2.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor71.dbf 1,314 0 5.15 1.00 5,926 2 18 1.11
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor72.dbf 735 0 5.40 1.00 718 0 1 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor73.dbf 607 0 6.31 1.00 594 0 0 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor74.dbf 524 0 4.92 1.00 525 0 1 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor75.dbf 1,101 0 4.08 1.00 548 0 5 2.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor76.dbf 921 0 6.57 1.00 1,048 0 2 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor77.dbf 849 0 5.11 1.00 909 0 1 0.00
FJSATCOMNOR +DG/gpsrac/datafile/fjsatcomnor78.dbf 2,846 1 7.45 1.00 6,017 2 19 6.32
FJSATCOM_OTHER_IDX +DG/gpsrac/datafile/fjsatcom_other_idx01bf 95 0 6.95 1.00 474 0 0 0.00
FJSATCOM_OTHER_IDX +DG/gpsrac/datafile/fjsatcom_other_idx02.dbf 44 0 6.36 1.00 360 0 0 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx01.dbf 1,085 0 6.55 1.00 4,373 1 0 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx02.dbf 883 0 7.17 1.00 3,063 1 15 0.67
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx03.dbf 869 0 6.57 1.00 2,874 1 12 0.83
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx04.dbf 719 0 6.88 1.00 3,066 1 2 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx05.dbf 958 0 6.51 1.00 2,165 1 8 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx06.dbf 1,133 0 6.68 1.00 3,211 1 12 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx07.dbf 952 0 7.38 1.00 3,476 1 2 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx08.dbf 1,131 0 6.98 1.00 4,368 1 0 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx09.dbf 763 0 6.83 1.00 2,667 1 9 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx10.dbf 1,036 0 7.10 1.00 3,623 1 19 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx11.dbf 1,216 0 7.36 1.00 3,201 1 19 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx12.dbf 753 0 7.69 1.00 3,161 1 0 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx13.dbf 1,241 0 7.07 1.00 4,287 1 5 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx14.dbf 801 0 6.29 1.00 2,710 1 4 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx15.dbf 802 0 7.14 1.00 2,889 1 0 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx16.dbf 742 0 7.24 1.00 3,469 1 7 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx17.dbf 875 0 6.67 1.00 2,591 1 9 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx18.dbf 617 0 5.93 1.00 2,149 1 0 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx19.dbf 1,150 0 7.09 1.00 3,402 1 14 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx20.dbf 694 0 6.53 1.00 2,550 1 11 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx21.dbf 422 0 6.59 1.00 2,263 1 4 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx22.dbf 607 0 7.51 1.00 2,332 1 3 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx23.dbf 663 0 6.24 1.00 2,144 1 1 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx24.dbf 828 0 7.11 1.00 2,855 1 3 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx25.dbf 604 0 6.95 1.00 2,735 1 16 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx26.dbf 854 0 6.80 1.00 2,787 1 2 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx27.dbf 561 0 6.15 1.00 1,416 0 0 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx28.dbf 610 0 6.75 1.00 2,270 1 10 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx29.dbf 658 0 7.19 1.00 2,709 1 12 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx30.dbf 566 0 5.11 1.00 2,318 1 6 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx31.dbf 765 0 6.73 1.00 2,502 1 5 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx33.dbf 308 0 6.07 1.00 1,111 0 0 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx34.dbf 1,155 0 7.37 1.00 3,343 1 21 0.48
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx35.dbf 904 0 7.01 1.00 2,642 1 0 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx36.dbf 1,034 0 6.42 1.00 2,482 1 19 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx37.dbf 895 0 6.64 1.00 2,451 1 2 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx38.dbf 924 0 6.06 1.00 2,956 1 0 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx39.dbf 777 0 7.53 1.00 2,548 1 25 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx40.dbf 1,314 0 6.48 1.00 3,197 1 30 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx41.dbf 1,003 0 6.97 1.00 3,027 1 9 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx42.dbf 612 0 6.27 1.00 2,625 1 2 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx43.dbf 766 0 7.00 1.00 2,522 1 5 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx44.dbf 794 0 7.10 1.00 2,774 1 9 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx45.dbf. 850 0 6.82 1.00 3,274 1 0 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx46.dbf 650 0 7.00 1.00 2,670 1 0 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx47.dbf 747 0 6.25 1.00 2,110 1 8 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx48.dbf 861 0 6.76 1.00 3,019 1 23 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx49.dbf 1,254 0 6.90 1.00 3,733 1 24 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx50.dbf 1,341 0 6.75 1.00 3,240 1 20 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx51.dbf 747 0 6.96 1.00 2,398 1 4 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx52.dbf 1,032 0 6.96 1.00 3,328 1 3 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx53.dbf 1,095 0 6.84 1.00 3,257 1 2 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx54.dbf 590 0 7.08 1.00 2,211 1 16 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx55.dbf 715 0 7.33 1.00 2,358 1 8 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx56.dbf 630 0 7.57 1.00 2,141 1 9 1.11
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx57.dbf 397 0 6.85 1.00 1,693 0 0 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx58.dbf 982 0 7.46 1.00 3,610 1 24 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx59.dbf 686 0 6.75 1.00 2,622 1 1 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx60.dbf 585 0 6.79 1.00 2,058 1 6 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx61.dbf 991 0 7.07 1.00 4,589 1 8 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx62.dbf 643 0 7.57 1.00 2,355 1 7 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx63.dbf 632 0 6.91 1.00 2,341 1 6 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx64.dbf 698 0 7.34 1.00 1,872 1 2 0.00
FJSATCOM_TRCK_IDX +DG/gpsrac/datafile/fjsatcom_trck_idx65.dbf 917 0 7.04 1.00 3,294 1 4 0.00
SYSAUX +DG/gpsrac/datafile/sysaux.267.752152641 1,029 0 5.10 1.02 503 0 0 0.00
SYSTEM +DG/gpsrac/datafile/system.265.752152633 215 0 5.67 1.05 190 0 0 0.00
TEMP +DG/gpsrac/tempfile/temp.268.752152643 0 0     27 0 0  
UNDOTBS1 +DG/gpsrac/datafile/undotbs1.266.752152639 0 0     19,222 5 1,261 0.05

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 711,184 100 139,576,479 119,985 723,370 0 0 2,234


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 28 59431 1039140 6451200 6451200 7301019  
E 0 23 51793 815979 5852939 6451200 5852939  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 592 0.10 70,929 3.86 32,758,606,234
D 1,184 0.20 141,858 3.35 28,499,075,026
D 1,776 0.30 212,787 2.91 24,696,458,929
D 2,368 0.40 283,716 2.51 21,330,031,891
D 2,960 0.50 354,645 2.16 18,364,133,123
D 3,552 0.60 425,574 1.86 15,774,333,452
D 4,144 0.70 496,503 1.59 13,529,408,463
D 4,736 0.80 567,432 1.36 11,595,616,186
D 5,328 0.90 638,361 1.17 9,939,905,467
D 5,920 1.00 709,290 1.00 8,530,419,889
D 5,936 1.00 711,207 1.00 8,496,625,869
D 6,512 1.10 780,219 0.86 7,336,527,896
D 7,104 1.20 851,148 0.74 6,329,217,322
D 7,696 1.30 922,077 0.65 5,481,214,406
D 8,288 1.40 993,006 0.56 4,766,941,871
D 8,880 1.50 1,063,935 0.49 4,162,550,530
D 9,472 1.60 1,134,864 0.43 3,645,626,924
D 10,064 1.70 1,205,793 0.38 3,194,970,965
D 10,656 1.80 1,276,722 0.33 2,790,445,225
D 11,248 1.89 1,347,651 0.28 2,412,678,000
D 11,840 1.99 1,418,580 0.24 2,043,188,148

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 7,704 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 2,048 1,485 658.53 2.19 0.33 100.00 0.00 209,710
E 2,048 1,493 647.59 0.18 0.03 100.00 0.00 209,710

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 293,287 293,287 0 0
64K 128K 301 301 0 0
128K 256K 565 565 0 0
256K 512K 868 868 0 0
512K 1024K 1,164 1,164 0 0
1M 2M 2,004 2,004 0 0
2M 4M 1,183 1,183 0 0
4M 8M 25 25 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
256 0.13 41,140,810.08 24,651,208.60 63.00 1,437,150
512 0.25 41,140,810.08 3,998,129.91 91.00 136,208
1,024 0.50 41,140,810.08 562,285.86 99.00 0
1,536 0.75 41,140,810.08 562,087.82 99.00 0
2,048 1.00 41,140,810.08 561,412.33 99.00 0
2,458 1.20 41,140,810.08 321,643.60 99.00 0
2,867 1.40 41,140,810.08 321,643.60 99.00 0
3,277 1.60 41,140,810.08 321,643.60 99.00 0
3,686 1.80 41,140,810.08 321,643.60 99.00 0
4,096 2.00 41,140,810.08 321,643.60 99.00 0
6,144 3.00 41,140,810.08 321,643.60 99.00 0
8,192 4.00 41,140,810.08 321,643.60 99.00 0
12,288 6.00 41,140,810.08 321,643.60 99.00 0
16,384 8.00 41,140,810.08 321,643.60 99.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)
736 0.37 232 21,786 499,141,454 1.00 4,308,621 1.27 3,254,493
944 0.48 433 34,891 499,353,509 1.00 4,096,566 1.21 3,312,645
1,152 0.58 639 48,651 499,542,878 1.00 3,907,197 1.15 3,363,971
1,360 0.69 846 62,838 499,698,586 1.00 3,751,489 1.11 3,405,122
1,568 0.79 1,053 77,059 499,830,002 1.00 3,620,073 1.07 3,438,724
1,776 0.90 1,260 91,375 499,948,068 1.00 3,502,007 1.03 3,468,108
1,984 1.00 1,467 105,375 500,057,962 1.00 3,392,113 1.00 3,495,033
2,192 1.10 1,674 119,533 500,161,135 1.00 3,288,940 0.97 3,520,068
2,400 1.21 1,881 133,815 500,257,926 1.00 3,192,149 0.94 3,543,386
2,608 1.31 2,088 148,075 500,348,519 1.00 3,101,556 0.91 3,565,095
2,816 1.42 2,295 162,610 500,433,153 1.00 3,016,922 0.89 3,585,309
3,024 1.52 2,502 176,758 500,512,149 1.00 2,937,926 0.87 3,604,121
3,232 1.63 2,709 191,141 500,585,885 1.00 2,864,190 0.84 3,621,608
3,440 1.73 2,916 205,446 500,654,819 1.00 2,795,256 0.82 3,637,862
3,648 1.84 3,123 219,691 500,719,525 1.00 2,730,550 0.81 3,653,022
3,856 1.94 3,330 234,100 500,780,692 1.00 2,669,383 0.79 3,667,273
4,064 2.05 3,537 248,631 500,839,093 1.00 2,610,982 0.77 3,680,829

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2,000 0.25 143,105,464 38,258,599,844
4,000 0.50 106,013,927 24,652,955,372
6,000 0.75 75,616,113 13,343,948,444
8,000 1.00 62,036,355 8,496,624,288
10,000 1.25 55,776,887 6,399,657,414
12,000 1.50 54,970,414 6,399,657,414
14,000 1.75 54,753,287 4,289,095,941
16,000 2.00 54,709,861 2,742,710,320

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)
data block 936 1 2
undo header 1,026 0 0
undo block 236 0 0
1st level bmb 34 0 0
2nd level bmb 1 0 0
segment header 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
HW-Segment High Water Mark 8,198 8,190 8 3,250 4 1.10
TX-Transaction (index contention) 9,957 9,957 0 522 2 4.66
TM-DML 5,481,504 5,481,458 0 900 1 1.40
WF-AWR Flush 20 20 0 11 1 50.91
FB-Format Block 952 952 0 468 0 0.81
PS-PX Process Reservation 669 561 108 216 0 0.93
TQ-Queue table enqueue (TM contention) 106 106 0 43 0 1.86
SQ-Sequence Cache 10,329 10,329 0 291 0 0.17
TX-Transaction 2,730,016 2,730,211 0 1 0 30.00
TT-Tablespace 276 276 0 40 0 0.25
TA-Instance Undo 12 12 0 4 0 2.50
US-Undo Segment 3 3 0 2 0 5.00
TX-Transaction (allocate ITL entry) 236 236 0 1 0 10.00
TD-KTF map table enqueue (KTF dump entries) 7 7 0 7 0 0.00
PI-Remote PX Process Spawn Status 8 8 0 4 0 0.00
JQ-Job Queue 5 2 3 3 0 0.00
DR-Distributed Recovery 2 2 0 2 0 0.00
AF-Advisor Framework (task serialization) 7 7 0 1 0 0.00
TX-Transaction (row lock contention) 4 4 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
1 273.62 2,798,181 1,928 10 180/180 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
30-Dec 13:54 40,851 411,700 1,928 10 180 0/0 0/0/0/0/0/0
30-Dec 13:44 45,839 483,160 1,329 9 180 0/0 0/0/0/0/0/0
30-Dec 13:34 45,919 484,916 728 8 180 0/0 0/0/0/0/0/0
30-Dec 13:24 47,685 481,657 1,095 9 180 0/0 0/0/0/0/0/0
30-Dec 13:14 47,391 475,139 495 9 180 0/0 0/0/0/0/0/0
30-Dec 13:04 45,930 461,609 1,376 9 180 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 db client latch 2,445 0.00   0 0  
ASM map operation freelist 138 0.00   0 0  
ASM map operation hash table 6,319,854 0.00 0.00 0 0  
ASM network background latch 1,436 0.00   0 0  
AWR Alerted Metric Element list 26,102 0.00   0 0  
Consistent RBA 2,467,355 0.01 0.01 0 0  
FOB s.o list latch 3,131 0.00   0 0  
JS broadcast add buf latch 820 0.00   0 0  
JS broadcast drop buf latch 820 0.00   0 0  
JS broadcast load blnc latch 717 0.00   0 0  
JS queue state obj latch 21,510 0.00   0 0  
JS slv state obj latch 216 0.00   0 0  
KCL gc element parent latch 3,107,388 0.01 0.03 0 21,659 0.01
KFK SGA context latch 3,049 0.00   0 0  
KFMD SGA 148 0.00   0 0  
KJC message pool free list 2,609,864 0.01 0.01 0 85,662 0.04
KJCT flow control latch 7,064,476 0.00 0.01 0 0  
KMG MMAN ready and startup request latch 1,195 0.00   0 0  
KSXR large replies 240 0.00   0 0  
KTF sga latch 13 0.00   0 1,202 0.00
KWQMN job cache list latch 740 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 0     0 1,195 0.00
OS process 2,067 0.00   0 0  
OS process allocation 2,578 0.00   0 0  
OS process: request allocation 1,103 0.00   0 0  
PL/SQL warning settings 5,897 0.00   0 0  
SGA IO buffer pool latch 111,828 0.00 0.00 0 111,828 0.00
SQL memory manager latch 1 0.00   0 1,193 0.00
SQL memory manager workarea list latch 103,963 0.00   0 0  
Shared B-Tree 127 0.00   0 0  
active checkpoint queue latch 309,551 0.02 0.00 0 0  
active service list 10,076 0.00   0 437,050 0.00
archive control 31 0.00   0 0  
begin backup scn array 12,942 0.00   0 0  
business card 144 0.00   0 0  
cache buffer handles 22,584 0.00   0 0  
cache buffers chains 325,102,005 0.02 0.01 0 1,079,429 0.01
cache buffers lru chain 1,854,740 0.01 0.02 0 1,046,502 0.02
cache table scan latch 0     0 6 0.00
channel handle pool latch 1,119 0.00   0 0  
channel operations parent latch 3,487,052 0.00 0.00 0 0  
checkpoint queue latch 4,946,843 0.00 0.01 0 864,991 0.00
client/application info 3,569 0.00   0 0  
commit callback allocation 62 0.00   0 0  
compile environment latch 699 0.00   0 0  
dml lock allocation 10,963,389 0.26 0.00 0 0  
dummy allocation 1,393 0.00   0 0  
enqueue hash chains 30,750,758 0.26 0.00 0 1,814 0.06
enqueues 3,384,011 0.12 0.00 0 0  
error message lists 312 0.00   0 0  
event group latch 554 0.00   0 0  
file cache latch 2,110 0.00   0 0  
gcs opaque info freelist 137,458 0.01 0.00 0 0  
gcs partitioned table hash 3,321,947 0.00   0 341,530 0.00
gcs remastering latch 79,691 0.00   0 0  
gcs resource freelist 213,301 0.00 0.00 0 78,578 0.00
gcs resource hash 2,551,933 0.01 0.04 0 14 0.00
gcs resource scan list 28 0.00   0 0  
gcs shadows freelist 158,077 0.00   0 132,693 0.00
ges caches resource lists 3,985,715 0.09 0.07 0 2,234,204 0.08
ges deadlock list 1,308,764 0.00 0.00 0 22 0.00
ges domain table 19,653,103 0.00 0.00 0 0  
ges enqueue table freelist 19,677,934 0.04 0.00 0 0  
ges group table 21,545,600 0.02 0.00 0 0  
ges process hash list 15,545 0.00   0 0  
ges process parent latch 34,982,630 0.00 0.00 0 0  
ges process table freelist 1,103 0.00   0 0  
ges resource hash list 22,369,209 0.16 0.01 0 1,465,104 0.03
ges resource scan list 1,094 0.00   0 0  
ges resource table freelist 2,837,172 0.02 0.00 0 0  
ges timeout list 69,958 0.01 0.25 0 38,916 0.00
global KZLD latch for mem in SGA 480 0.00   0 0  
global hanganlyze operation 2 0.00   0 0  
hash table column usage latch 1,146 0.00   0 2,442,326 0.00
hash table modification latch 84 0.00   0 0  
internal temp table object number allocation latc 36 0.00   0 0  
interrupt manipulation 1,028 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 10,727,682 0.06 0.04 0 0  
kokc descriptor allocation latch 532 0.00   0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 25 0.00   0 0  
kwqbsn:qsga 127 0.00   0 0  
lgwr LWN SCN 2,469,330 0.03 0.00 0 0  
library cache 47,949,043 0.21 0.01 2 6,106,503 0.30
library cache load lock 27,220 0.00   0 0  
library cache lock 36,707,139 0.02 0.01 0 0  
library cache lock allocation 27,400 0.00   0 0  
library cache pin 10,254,002 0.01 0.00 0 1 0.00
library cache pin allocation 1,422 0.00   0 0  
list of block allocation 23,413 0.00 0.00 0 0  
loader state object freelist 59,800 0.00   0 0  
message pool operations parent latch 1,444 0.00   0 0  
messages 15,529,665 0.11 0.00 0 0  
mostly latch-free SCN 2,499,121 0.50 0.00 0 0  
multiblock read objects 9,434 0.00   0 0  
name-service memory objects 27,344 0.00   0 0  
name-service namespace bucket 49,553 0.00   0 0  
name-service pending queue 19,472 0.00   0 0  
name-service request 24 0.00   0 0  
name-service request queue 87,855 0.00   0 0  
ncodef allocation latch 61 0.00   0 0  
object queue header heap 1,128 0.00   0 1,123 0.00
object queue header operation 3,551,398 0.01 0.00 0 0  
object stats modification 1 0.00   0 0  
parallel query alloc buffer 2,440 0.00   0 0  
parallel query stats 305 0.00   0 0  
parallel txn reco latch 1,104 0.00   0 0  
parameter list 4,821 0.00   0 0  
parameter table management 1,393 0.00   0 0  
post/wait queue 531,781 0.06 0.01 0 177,729 0.01
process allocation 36,373 0.01 0.00 0 554 0.00
process group creation 1,103 0.00   0 0  
process queue 983 0.00   0 0  
process queue reference 26,791 0.05 0.00 0 2,646 0.87
qmn state object latch 8 0.00   0 0  
qmn task queue latch 544 0.00   0 0  
query server freelists 786 0.00   0 0  
query server process 4 0.00   0 4 0.00
queued dump request 17,922 0.00   0 0  
redo allocation 7,544,338 0.27 0.01 0 14,926,750 0.66
redo copy 0     0 14,960,097 0.66
redo writing 7,821,951 0.01 0.00 0 0  
resmgr group change latch 735 0.00   0 0  
resmgr:active threads 1,370 0.00   0 0  
resmgr:actses change group 629 0.00   0 0  
resmgr:free threads list 1,369 0.00   0 0  
resmgr:resource group CPU method 624 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 44,152,832 0.34 0.00 0 77,532 0.19
sequence cache 622,403 0.01 0.00 0 0  
session allocation 183,357 0.03 0.00 0 0  
session idle bit 759,274 0.00 0.00 0 0  
session state list latch 507 0.00   0 0  
session switching 2,806 0.00   0 0  
session timer 1,298 0.00   0 0  
shared pool 62,918,955 0.52 0.10 15 0  
shared pool simulator 10,360,743 0.01 0.31 1 0  
simulator hash latch 8,873,156 0.00 0.00 0 0  
simulator lru latch 0     0 8,823,197 0.03
slave class 12 0.00   0 0  
slave class create 48 2.08 1.00 0 0  
sort extent pool 131 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 336 0.00   0 0  
temp lob duration state obj allocation 5 0.00   0 0  
threshold alerts latch 286 0.00   0 0  
transaction allocation 23,419 0.00   0 0  
transaction branch allocation 1,298 0.00   0 0  
undo global data 9,269,736 0.01 0.00 0 0  
user lock 1,914 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
shared pool 62,918,955 327,672 32,223 295,792 0 0 0
row cache objects 44,152,832 148,887 197 148,690 0 0 0
library cache 47,949,043 101,920 1,066 100,857 0 0 0
enqueue hash chains 30,750,758 80,713 190 80,523 0 0 0
cache buffers chains 325,102,005 56,077 818 55,260 0 0 0
ges resource hash list 22,369,209 36,518 208 36,310 0 0 0
dml lock allocation 10,963,389 28,398 59 28,339 0 0 0
redo allocation 7,544,338 20,558 162 20,397 0 0 0
messages 15,529,665 17,322 50 17,273 0 0 0
mostly latch-free SCN 2,499,121 12,552 16 12,536 0 0 0
ges enqueue table freelist 19,677,934 8,034 13 8,021 0 0 0
library cache lock 36,707,139 7,741 40 7,701 0 0 0
kks stats 10,727,682 6,932 263 6,672 0 0 0
enqueues 3,384,011 4,036 9 4,027 0 0 0
ges caches resource lists 3,985,715 3,481 247 3,247 0 0 0
ges group table 21,545,600 3,297 12 3,285 0 0 0
shared pool simulator 10,360,743 1,447 450 1,000 0 0 0
undo global data 9,269,736 1,153 2 1,151 0 0 0
redo writing 7,821,951 1,055 4 1,051 0 0 0
library cache pin 10,254,002 679 3 676 0 0 0
ges resource table freelist 2,837,172 587 2 585 0 0 0
KJCT flow control latch 7,064,476 312 3 309 0 0 0
post/wait queue 531,781 308 2 306 0 0 0
KJC message pool free list 2,609,864 279 2 277 0 0 0
cache buffers lru chain 1,854,740 237 4 233 0 0 0
KCL gc element parent latch 3,107,388 226 7 219 0 0 0
Consistent RBA 2,467,355 193 1 192 0 0 0
gcs resource hash 2,551,933 171 6 165 0 0 0
checkpoint queue latch 4,946,843 91 1 90 0 0 0
ges timeout list 69,958 4 1 3 0 0 0
slave class create 48 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 kclgcr 0 4 2
KCL gc element parent latch kclnfnd 0 2 1
KCL gc element parent latch kclnfndnewm 0 2 0
KCL gc element parent latch kclplz 0 2 3
KCL gc element parent latch KCLUNLNK 0 1 3
KCL gc element parent latch kcllkopesc 0 1 1
KCL gc element parent latch kclrwrite 0 1 1
KCL gc element parent latch kclshrsplit 0 1 0
KCL gc element parent latch kclulb 0 1 1
KJC message pool free list kjcsmpav: allocate a msg buffer 0 1 2
KJC message pool free list kjcspfmbq: free vector of msg buffers 0 1 0
KJCT flow control latch kjctcsnd: send normal message 0 1 0
KJCT flow control latch kjcts_sedeqv: dequeue a vector of msgs 0 1 2
KJCT flow control latch kjcts_sqenq: queue a message 0 1 1
cache buffers chains kcbgtcr: kslbegin excl 0 965 729
cache buffers chains kcbrls: kslbegin 0 210 435
cache buffers chains kcbgtcr: fast path 0 143 11
cache buffers chains kcbgcur: kslbegin 0 20 13
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 6 25
cache buffers chains kcbnlc 0 6 7
cache buffers chains kcbzwb 0 4 0
cache buffers chains kcbzgb: scan from tail. nowait 0 3 0
cache buffers chains kcbbxsv 0 2 1
cache buffers chains kcbchg: kslbegin: call CR func 0 2 144
cache buffers chains kcbget: exchange 0 2 0
cache buffers chains kcbget: exchange rls 0 2 1
cache buffers chains kclcls_3 0 2 0
cache buffers chains kcbbic1 0 1 1
cache buffers chains kcbget: pin buffer 0 1 2
cache buffers chains kclwrt 0 1 0
cache buffers lru chain kcbzgws 0 4 0
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 1 0
dml lock allocation ktaidm 0 34 25
dml lock allocation ktaiam 0 25 34
enqueue hash chains ksqrcl 0 78 83
enqueue hash chains ksqgtl3 0 64 80
enqueue hash chains ksqcmi: if lk mode not requested 0 29 12
enqueue hash chains ksqcmi: if lk mode requested 0 19 15
enqueues ksqdel 0 6 3
enqueues ksqgel: create enqueue 0 3 5
event range base latch No latch 0 28 35
gcs resource hash kjbassume 0 2 0
gcs resource hash kclrwrite 0 1 2
gcs resource hash kjblocalfile_nolock 0 1 0
gcs resource hash kjbmpocr:iclose 0 1 0
gcs resource hash kjbmpopen 0 1 1
ges enqueue table freelist kjlfr: remove lock from parent object 0 10 8
ges enqueue table freelist kjlalc: lock allocation 0 3 5
ges group table kjgdgll: move a lock from group lock list to process lock list 0 7 9
ges group table kjgagll: move a lock from process lock list to group lock list 0 5 3
ges resource hash list kjakcai: search for resp by resname 0 121 12
ges resource hash list kjrmas1: lookup master node 0 47 0
ges resource hash list kjlrlr: remove lock from resource queue 0 26 41
ges resource hash list kjrref: find matched resource 0 7 29
ges resource hash list kjcvscn: remove from scan queue 0 4 0
ges resource hash list kjucvl: lock convert request 0 3 126
ges resource table freelist kjruch: cached obj cleanup 0 166 0
ges resource table freelist kjrchc: cached obj cleanup 0 73 0
ges resource table freelist kjrm2c: move resource to cache 0 6 247
ges resource table freelist kjrchc2: cached obj cleanup 0 2 0
ges resource table freelist kjralc: resource allocation 0 1 2
ges resource table freelist kjrfr: remove from resource table 0 1 0
ges timeout list kjtscn: try to lock timer queue 0 1 0
kks stats kks stats alloc/free 0 263 263
lgwr LWN SCN kcs023 0 3 0
library cache kgldti: 2child 0 147 47
library cache kglobpn: child: 0 105 151
library cache kglic 0 104 54
library cache kglpndl: child: after processing 0 68 4
library cache kglukp: child 0 50 92
library cache kglhdgn: child: 0 21 259
library cache kglpin 0 18 35
library cache kglati 0 6 0
library cache kglLockCursor 0 4 16
library cache kglhdgc: child: 0 4 1
library cache kglpnp: child 0 4 38
library cache kglpndl: child: before processing 0 3 84
library cache kgldte: child 0 0 2 10
library cache kglobld 0 1 11
library cache kqlmbfre: child: in loop 0 1 0
library cache lock kgllkdl: child: no lock handle 0 280 188
library cache lock kgllkal: child: multiinstance 0 7 3
library cache lock kgllkdl: child: cleanup 0 5 2
library cache pin kglpnal: child: alloc space 0 2 1
library cache pin kglpnp: child 0 1 1
messages ksaamb: after wakeup 0 30 34
messages ksarcv 0 12 14
messages ksarcv: after wait 0 8 2
mostly latch-free SCN kcslcu3 0 13 16
mostly latch-free SCN kcsnew_scn_rba 0 1 0
object queue header operation kcbo_switch_cq 0 1 1
object queue header operation kcbw_link_q 0 1 0
post/wait queue ksliwat:add:nowait 0 2 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 162 0
redo writing kcrfw_post: rba scn pair 0 4 0
row cache objects kqreqd: reget 0 179 8
row cache objects kqrpre: find obj 0 9 172
row cache objects kqreqd 0 5 10
row cache objects kqrigt 0 1 0
shared pool kghalo 0 23,660 13,951
shared pool kghfrunp: alloc: wait 0 3,759 10
shared pool kghupr1 0 3,358 6,191
shared pool kghalp 0 923 8,055
shared pool kghfre 0 434 2,315
shared pool kghfrunp: clatch: nowait 0 214 0
shared pool kghasp 0 94 1,707
shared pool kghfrunp: clatch: wait 0 37 75
shared pool kghfrh 0 2 0
shared pool simulator kglsim_unpin_simhp 0 428 104
shared pool simulator kglsim_chg_simhp_free 0 9 67
shared pool simulator kglsim_upd_newhp 0 9 99
shared pool simulator kglsim_scan_lru: scan 0 3 129
shared pool simulator kglsim_chg_simhp_noob 0 1 50
slave class create ksvcreate 0 1 0
undo global data ktudba: KSLBEGIN 0 1 1
undo global data ktudnx:child 0 1 1

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
FJDXGPS FJSATCOM_OTHER_IDX GK_I_MDTINFO   INDEX 52,122,432 37.33
FJDXGPS FJSATCOMNOR GK_T_CARINFO   TABLE 12,479,008 8.94
FJDXGPS FJSATCOM_OTHER_IDX SYS_C0015412   INDEX 7,065,136 5.06
FJDXGPS FJSATCOM_OTHER_IDX CAR_INFO_MDT_ID   INDEX 5,330,496 3.82
FJDXGPS FJSATCOMNOR CL_T_VIDEO_RUNING   TABLE 4,313,344 3.09

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
FJDXGPS FJSATCOMNOR GJ_T_TRACK_08   TABLE 5,486 3.95
FJDXGPS FJSATCOMNOR GPSERROR_MDT_ID   INDEX 4,008 2.89
FJDXGPS FJSATCOMNOR SYS_C0032221   INDEX 3,884 2.80
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 3,000 2.16
FJDXGPS FJSATCOMNOR CW_T_GPSERROR   TABLE 2,071 1.49

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
FJDXGPS FJSATCOMNOR PK_T_STATUS_CHANGE   INDEX 343 8.16
FJDXGPS FJSATCOM_TRCK_IDX IND_TRACK_TIME_13   INDEX 157 3.74
FJDXGPS FJSATCOM_TRCK_IDX IND_TRACK_TIME_37   INDEX 144 3.43
FJDXGPS FJSATCOM_TRCK_IDX IND_TRACK_TIME_59   INDEX 144 3.43
FJDXGPS FJSATCOM_TRCK_IDX IND_TRACK_TIME_33   INDEX 139 3.31

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
FJDXGPS FJSATCOM_TRCK_IDX IND_TRACK_TIME_42   INDEX 10 7.25
FJDXGPS FJSATCOM_TRCK_IDX IND_TRACK_TIME_23   INDEX 9 6.52
FJDXGPS FJSATCOM_TRCK_IDX IND_TRACK_TIME_73   INDEX 8 5.80
FJDXGPS FJSATCOM_TRCK_IDX IND_TRACK_TIME_13   INDEX 7 5.07
FJDXGPS FJSATCOM_TRCK_IDX IND_TRACK_TIME_18   INDEX 6 4.35

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
FJDXGPS FJSATCOMNOR GK_T_CARINFO   TABLE 95 21.84
FJDXGPS FJSATCOMNOR PK_T_STATUS_CHANGE   INDEX 44 10.11
FJDXGPS FJSATCOM_TRCK_IDX IND_TRACK_TIME_33   INDEX 34 7.82
FJDXGPS FJSATCOMNOR GJ_T_STATUS_CHANGE   TABLE 28 6.44
FJDXGPS FJSATCOM_TRCK_IDX IND_TRACK_TIME_13   INDEX 15 3.45

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
FJDXGPS FJSATCOMNOR GK_T_BS_PARAM   TABLE 24 80.00
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 2 6.67
FJDXGPS FJSATCOMNOR CW_T_GPSERROR   TABLE 2 6.67
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 1 3.33
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 1 3.33

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
FJDXGPS FJSATCOMNOR GK_T_BS_PARAM   TABLE 4,010 70.94
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 291 5.15
SYS SYSTEM I_JOB_NEXT   INDEX 236 4.17
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 232 4.10
SYS SYSTEM JOB$   TABLE 59 1.04

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 10,297 36.99
FJDXGPS FJSATCOMNOR GJ_T_TRACK_08   TABLE 3,300 11.85
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 2,085 7.49
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 1,919 6.89
FJDXGPS FJSATCOMNOR GJ_T_TRACK_27   TABLE 1,901 6.83

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 96.88 0   1 1
dc_database_links 966 0.10 0   0 1
dc_global_oids 489 75.05 0   0 7
dc_histogram_data 822,135 18.41 0   0 2,640
dc_histogram_defs 369,818 16.48 0   0 1,357
dc_object_grants 1,270 20.47 0   0 2
dc_object_ids 4,964,736 0.08 0   0 659
dc_objects 3,047,349 0.14 0   0 400
dc_profiles 482 0.41 0   0 1
dc_rollback_segments 14,082 0.00 0   0 95
dc_segments 4,636,364 0.07 0   38 785
dc_sequences 10,037 0.72 0   10,037 1
dc_tablespace_quotas 26 92.31 0   26 0
dc_tablespaces 532,091 0.01 0   0 7
dc_usernames 5,560 0.49 0   0 6
dc_users 575,578 0.01 0   0 31
outstanding_alerts 110 100.00 0   0 0

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 64 0 62
dc_database_links 1 0 1
dc_global_oids 367 0 360
dc_histogram_defs 60,929 0 60,921
dc_object_ids 4,052 0 4,028
dc_objects 4,194 0 4,188
dc_profiles 2 0 2
dc_segments 3,493 4 3,339
dc_sequences 20,074 14 58
dc_tablespace_quotas 52 0 24
dc_tablespaces 65 0 65
dc_usernames 27 0 27
dc_users 30 0 28
outstanding_alerts 218 16 94

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 46 65.22 153,900 0.07 80 0
CLUSTER 477 4.19 855 2.69 3 0
INDEX 83 28.92 174 13.79 0 0
SQL AREA 3,669,057 68.56 12,865,221 33.89 258,923 7,309
TABLE/PROCEDURE 1,256,535 0.07 8,268,979 0.16 8,559 0
TRIGGER 24 8.33 61 31.15 17 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 855 20 20 20 0
INDEX 174 24 24 24 0
TABLE/PROCEDURE 1,675,978 550 494 359 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 519.90   3.47 3.46 20 28 150 150
  Freeable 92.88 0.00 0.77 0.55 5   120 120
  SQL 41.13 27.45 0.31 0.25 2 54 133 129
  PL/SQL 3.16 2.25 0.02 0.02 0 0 150 150
E Other 512.42   3.28 3.46 20 28 156 156
  Freeable 93.44 0.00 0.77 0.54 5   122 122
  SQL 38.88 25.28 0.28 0.20 1 37 139 134
  PL/SQL 2.95 2.20 0.02 0.02 0 0 156 156

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 6,224,347,136  
Fixed Size 2,109,544  
Redo Buffers 48,218,112  
Variable Size 2,113,933,208  

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 ASM extent pointer array 20.87 20.87 0.00
shared CCursor 105.04 105.63 0.56
shared Cursor Stats 25.14 25.14 0.00
shared KGH: NO ACCESS 63.62 63.62 0.00
shared PCursor 60.55 60.43 -0.20
shared db_block_hash_buckets 45.00 45.00 0.00
shared free memory 871.58 870.00 -0.18
shared gcs resources 178.63 178.63 0.00
shared gcs shadows 74.57 74.57 0.00
shared kglsim heap 30.18 30.18 0.00
shared kglsim object batch 52.46 52.46 0.00
shared library cache 57.88 58.68 1.39
shared sql area 248.79 249.03 0.10
  buffer_cache 5,936.00 5,936.00 0.00
  fixed_sga 2.01 2.01 0.00
  log_buffer 45.98 45.98 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 622,336 1,156,032 805797 805797
gcs_shadows 545,655 652,167 805797 805797


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /oracle/app/oracle/admin/gpsrac/adump   
background_dump_dest /oracle/app/oracle/admin/gpsrac/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.5.0   
control_files +DG/gpsrac/controlfile/current.256.752152599   
core_dump_dest /oracle/app/oracle/admin/gpsrac/cdump   
db_block_size 8192   
db_create_file_dest +DG   
db_domain      
db_file_multiblock_read_count 16   
db_files 1000   
db_name gpsrac   
instance_number 1   
job_queue_processes 10   
local_listener (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.112)(PORT=1521))   
log_buffer 46756864   
open_cursors 1000   
optimizer_index_caching 90   
optimizer_index_cost_adj 20   
pga_aggregate_target 2147483648   
processes 800   
remote_listener      
remote_login_passwordfile EXCLUSIVE   
session_cached_cursors 100   
sessions 885   
sga_target 8388608000   
shared_pool_reserved_size 209715200   
shared_pool_size 2080374784   
spfile +DG/gpsrac/spfilegpsrac.ora   
thread 1   
undo_management AUTO   
undo_retention 10800   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/app/oracle/admin/gpsrac/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 4,433 1.24 0.00
acks for commit broadcast(logical) 6,547 1.83 0.00
broadcast msgs on commit(actual) 2,465,958 687.56 0.94
broadcast msgs on commit(logical) 2,466,436 687.69 0.94
broadcast msgs on commit(wasted) 87,242 24.32 0.03
broadcast on commit wait time(ms) -2,196,766,360 -612,501.76 -837.09
broadcast on commit waits 2,320,475 646.99 0.88
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 41,339 11.53 0.02
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 54,789 15.28 0.02
gcs ast xid 1 0.00 0.00
gcs blocked converts 33,128 9.24 0.01
gcs blocked cr converts 344,587 96.08 0.13
gcs compatible basts 141 0.04 0.00
gcs compatible cr basts (global) 30,005 8.37 0.01
gcs compatible cr basts (local) 37,390 10.43 0.01
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 15,234 4.25 0.01
gcs dbwr write request msgs 15,032 4.19 0.01
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 54,121 15.09 0.02
gcs immediate (null) converts 33,609 9.37 0.01
gcs immediate cr (compatible) converts 2 0.00 0.00
gcs immediate cr (null) converts 78,305 21.83 0.03
gcs indirect ast 82,165 22.91 0.03
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 55 0.02 0.00
gcs msgs process time(ms) 84,174 23.47 0.03
gcs msgs received 3,417,371 952.83 1.30
gcs out-of-order msgs 8 0.00 0.00
gcs pings refused 11 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 6 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 1 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 31,480 8.78 0.01
gcs side channel msgs logical 149,785 41.76 0.06
gcs stale cr 2 0.00 0.00
gcs undo cr 1,489 0.42 0.00
gcs write notification msgs 31 0.01 0.00
gcs writes refused 0 0.00 0.00
ges msgs process time(ms) 17,387 4.85 0.01
ges msgs received 718,433 200.31 0.27
global posts dropped 0 0.00 0.00
global posts queue time 19,910,886 5,551.55 7.59
global posts queued 31 0.01 0.00
global posts requested 31 0.01 0.00
global posts sent 31 0.01 0.00
implicit batch messages received 77,962 21.74 0.03
implicit batch messages sent 57,364 15.99 0.02
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 2,506,561 698.88 0.96
messages queue sent actual 2,677,660 746.58 1.02
messages queue sent logical 2,788,861 777.59 1.06
messages received actual 3,452,829 962.72 1.32
messages received logical 4,135,798 1,153.14 1.58
messages sent directly 835,951 233.08 0.32
messages sent indirectly 860,952 240.05 0.33
messages sent not implicit batched 2,620,291 730.59 1.00
messages sent pbatched 792,215 220.89 0.30
msgs causing lmd to send msgs 12,629 3.52 0.00
msgs causing lms(s) to send msgs 43,798 12.21 0.02
msgs received queue time (ms) 72,766 20.29 0.03
msgs received queued 4,135,800 1,153.14 1.58
msgs sent queue time (ms) -962,448,564 -268,349.63 -366.75
msgs sent queue time on ksxp (ms) 2,180,646 608.01 0.83
msgs sent queued 2,760,689 769.73 1.05
msgs sent queued on ksxp 3,519,009 981.17 1.34
number of ges deadlock detected 0 0.00 0.00
process batch messages received 3,103,911 865.43 1.18
process batch messages sent 165,912 46.26 0.06


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 658,811
CURRENT Block Requests 1,527
Data Block Requests 658,933
Undo Block Requests 1,489
TX Block Requests 16
Current Results 540,540
Private results 0
Zero Results 119,981
Disk Read Results 0
Fail Results 0
Fairness Down Converts 163,749
Fairness Clears 0
Free GC Elements 0
Flushes 380
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 92,903 100.00 0.00 0.00 0.00 0.00
Flushes 25 96.00 0.00 4.00 0.00 0.00
Writes 28,072 59.72 27.01 0.99 0.25 12.02


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 5,426 99.82 0.18 0.00 26,816 99.78 0.22 0.00
2 undo header 22 86.36 13.64 0.00 697 99.71 0.29 0.00
2 Others 190 99.47 0.53 0.00 341 100.00 0.00 0.00


Back to Top

End of Report Report written to awrrpt_1_22776_22777.html SQL>