WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ORCL1283715724orcl110.2.0.4.0NOntyddb3

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1920216-Sep-13 12:00:35271 5.9
End Snap:1920316-Sep-13 13:14:14279 6.3
Elapsed:  73.65 (mins)  
DB Time:  14,235.50 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 23,552M 23,552MStd Block Size: 8K
Shared Pool Size: 6,144M 6,144MLog Buffer: 14,288K

Load Profile

Per SecondPer Transaction
Redo size: 1,245,612.74 26,669.29
Logical reads: 98,688.22 2,112.97
Block changes: 8,915.27 190.88
Physical reads: 6,120.05 131.03
Physical writes: 453.94 9.72
User calls: 59.74 1.28
Parses: 390.09 8.35
Hard parses: 47.62 1.02
Sorts: 85.40 1.83
Logons: 0.58 0.01
Executes: 715.81 15.33
Transactions: 46.71 

% Blocks changed per Read: 9.03Recursive Call %: 96.81
Rollback per transaction %: 96.73Rows per Sort: 266.91

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97Redo NoWait %: 100.00
Buffer Hit %: 98.20In-memory Sort %: 100.00
Library Hit %: 99.69Soft Parse %: 87.79
Execute to Parse %: 45.50Latch Hit %: 99.81
Parse CPU to Parse Elapsd %: 0.99% Non-Parse CPU: 93.29

Shared Pool Statistics

BeginEnd
Memory Usage %: 88.43 87.68
% SQL with executions>1: 63.19 87.14
% Memory for SQL w/exec>1: 58.74 86.75

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
latch free 3,447,742 976,595 283 114.3Other
latch: library cache 1,793,091 525,062 293 61.5Concurrency
latch: shared pool 641,676 185,892 290 21.8Concurrency
latch: session allocation 514,471 150,578 293 17.6Other
db file scattered read 582,742 13,670 23 1.6User I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
connection management call elapsed time 619,966.03 72.58
sql execute elapsed time 136,423.88 15.97
parse time elapsed 77,184.91 9.04
hard parse elapsed time 23,430.18 2.74
DB CPU 11,147.13 1.31
PL/SQL execution elapsed time 4,969.79 0.58
failed parse elapsed time 3,750.51 0.44
sequence load elapsed time 315.66 0.04
PL/SQL compilation elapsed time 182.62 0.02
hard parse (sharing criteria) elapsed time 24.86 0.00
hard parse (bind mismatch) elapsed time 24.40 0.00
repeated bind elapsed time 0.02 0.00
DB time 854,130.27  
background elapsed time 29,279.97  
background cpu time 116.07  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Other 21,613,914 5.63 1,137,841 53 104.72
Concurrency 9,382,180 8.86 721,446 77 45.46
User I/O 2,313,551 0.00 30,232 13 11.21
Network 3,921,066 0.00 3,105 1 19.00
System I/O 39,049 0.00 383 10 0.19
Configuration 5,594 96.25 206 37 0.03
Commit 2,881 5.52 20 7 0.01
Application 828 0.00 2 2 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
latch free 3,447,742 0.20 976,595 283 16.70
latch: library cache 1,793,091 0.00 525,062 293 8.69
latch: shared pool 641,676 0.20 185,892 290 3.11
latch: session allocation 514,471 0.00 150,578 293 2.49
db file scattered read 582,742 0.00 13,670 23 2.82
db file sequential read 323,918 0.00 8,646 27 1.57
cursor: pin S wait on X 829,007 100.00 8,110 10 4.02
PX Deq Credit: send blkd 4,407,757 0.07 7,426 2 21.36
direct path read 1,128,139 0.00 4,454 4 5.47
SQL*Net more data from dblink 2,504,844 0.00 3,074 1 12.14
read by other session 122,451 0.04 2,083 17 0.59
latch: checkpoint queue latch 4,636 0.00 1,340 289 0.02
direct path read temp 101,591 0.00 1,246 12 0.49
latch: cache buffers lru chain 4,806 0.00 1,071 223 0.02
os thread startup 936 97.97 898 960 0.00
latch: cache buffers chains 7,479 0.00 709 95 0.04
latch: row cache objects 2,288 0.00 622 272 0.01
db file parallel write 17,429 0.00 295 17 0.08
latch: object queue header operation 1,146 0.00 227 198 0.01
latch: redo allocation 753 0.00 193 257 0.00
LGWR wait for redo copy 18,034 93.02 165 9 0.09
PX Deq: Signal ACK 1,769 90.50 153 86 0.01
enq: SQ - contention 49 95.92 138 2810 0.00
direct path write temp 53,212 0.00 131 2 0.26
latch: library cache lock 345 0.00 97 282 0.00
buffer busy waits 693 5.63 45 65 0.00
log file switch completion 133 19.55 41 307 0.00
control file parallel write 2,100 0.00 36 17 0.01
control file sequential read 6,473 0.00 30 5 0.03
SQL*Net more data to client 1,194,374 0.00 30 0 5.79
kksfbc child completion 581 100.00 28 49 0.00
latch: enqueue hash chains 89 0.00 26 289 0.00
log file parallel write 13,003 0.00 21 2 0.06
log file sync 2,881 5.52 20 7 0.01
latch: redo writing 61 0.00 16 268 0.00
rdbms ipc reply 282 2.13 12 43 0.00
log file switch (checkpoint incomplete) 25 20.00 11 450 0.00
cursor: pin S 11,290,427 0.00 9 0 54.70
enq: JD - contention 3 66.67 8 2574 0.00
latch: In memory undo latch 238 0.00 5 22 0.00
Streams AQ: qmn coordinator waiting for slave to start 2 50.00 5 2443 0.00
cursor: mutex S 5,057,705 0.00 4 0 24.51
direct path write 1,475 0.00 2 2 0.01
PX qref latch 1,513,481 51.48 2 0 7.33
enq: RO - fast object reuse 67 0.00 2 25 0.00
reliable message 71 1.41 1 18 0.00
cursor: mutex X 1,048,722 0.00 1 0 5.08
enq: CF - contention 2 0.00 1 384 0.00
ksdxexeotherwait 407,820 100.00 1 0 1.98
db file parallel read 5 0.00 0 55 0.00
SQL*Net break/reset to client 599 0.00 0 0 0.00
SQL*Net message to client 196,009 0.00 0 0 0.95
SQL*Net more data from client 612 0.00 0 0 0.00
SQL*Net more data to dblink 1,128 0.00 0 0 0.01
latch: cache buffer handles 2 0.00 0 32 0.00
local write wait 18 0.00 0 3 0.00
latch: parallel query alloc buffer 2 0.00 0 25 0.00
log file sequential read 22 0.00 0 2 0.00
SQL*Net message to dblink 24,099 0.00 0 0 0.12
undo segment extension 5,326 99.62 0 0 0.03
log file single write 22 0.00 0 0 0.00
SQL*Net break/reset to dblink 161 0.00 0 0 0.00
enq: PS - contention 38 0.00 0 0 0.00
enq: KO - fast object checkpoint 1 0.00 0 0 0.00
SQL*Net message from client 196,016 0.00 178,413 910 0.95
jobq slave wait 3,735 62.41 9,228 2471 0.02
PX Idle Wait 3,805 97.79 7,319 1923 0.02
PX Deq: Execution Msg 7,255 46.67 6,711 925 0.04
virtual circuit status 149 100.00 4,350 29198 0.00
PX Deq: Table Q Normal 1,975,647 0.09 3,936 2 9.57
Streams AQ: waiting for time management or cleanup tasks 1 100.00 3,853 3852771 0.00
PX Deq: Execute Reply 102,350 0.98 3,380 33 0.50
Streams AQ: qmn slave idle wait 92 1.09 2,561 27842 0.00
Streams AQ: qmn coordinator idle wait 186 51.61 2,503 13456 0.00
PX Deq Credit: need buffer 845,563 0.12 2,099 2 4.10
SQL*Net message from dblink 24,100 0.00 1,725 72 0.12
wait for unread message on broadcast channel 1,567 100.00 1,530 977 0.01
single-task message 1,034 0.00 58 56 0.01
PX Deq: Parse Reply 61 0.00 0 1 0.00
PX Deq: Join ACK 73 0.00 0 0 0.00
PX Deq: Msg Fragment 34 0.00 0 0 0.00
class slave wait 5 0.00 0 2 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 449,285 96.07 6,656 15 2.18
latch: shared pool 5,813 21.59 1,687 290 0.03
latch: library cache 3,603 0.00 1,062 295 0.02
os thread startup 926 99.03 898 970 0.00
db file parallel write 17,429 0.00 295 17 0.08
db file sequential read 368 0.00 50 137 0.00
control file parallel write 2,101 0.00 36 17 0.01
buffer busy waits 95 30.53 29 308 0.00
control file sequential read 3,137 0.00 28 9 0.02
log file parallel write 13,009 0.00 21 2 0.06
latch: redo writing 61 0.00 16 268 0.00
db file scattered read 7 0.00 14 1954 0.00
direct path read 3,795 0.00 7 2 0.02
latch: library cache lock 21 0.00 6 283 0.00
latch: cache buffers chains 49 0.00 2 51 0.00
direct path write 1,383 0.00 2 2 0.01
latch: row cache objects 6 0.00 0 10 0.00
log file sequential read 22 0.00 0 2 0.00
log file single write 22 0.00 0 0 0.00
rdbms ipc message 45,114 22.80 29,337 650 0.22
Streams AQ: waiting for time management or cleanup tasks 1 100.00 3,853 3852771 0.00
Streams AQ: qmn coordinator idle wait 186 51.61 2,503 13456 0.00
pmon timer 665 97.59 1,770 2662 0.00
smon timer 46 0.00 1,539 33446 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 28,663
AVG_IDLE_TIME 419,570
AVG_IOWAIT_TIME 219,581
AVG_SYS_TIME 2,855
AVG_USER_TIME 25,726
BUSY_TIME 919,885
IDLE_TIME 13,428,848
IOWAIT_TIME 7,029,325
SYS_TIME 93,977
USER_TIME 825,908
LOAD 0
OS_CPU_WAIT_TIME 1,831,700
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 65,766,686,720
NUM_CPUS 32
NUM_CPU_CORES 16

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 781,099.50 9,928.50 24,871,074 406,953,723
orcl 72,172.80 1,217.50 2,349,470 30,701,492
SYS$BACKGROUND 0.00 0.00 5,557 75,712
orclXDB 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 1888499 2487200 2166974 18252497 0 0 208953 51960
orcl 419017 524086 5503164 3699261 0 0 3712090 258911
SYS$BACKGROUND 7010 11230 11339 391834 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
9,698 234 1 9697.73 1.14 f7j4rubxmnwtp   create table ry_a_20680_xxt_cr...
5,992 32 132 45.39 0.70 45xfyfh8c9vm8   select count(1) from t_priv_re...
5,034 98 0   0.59 dhmd30cd96rrn   DECLARE job BINARY_INTEGER := ...
5,031 102 0   0.59 gdv4g80r81f29   DECLARE job BINARY_INTEGER := ...
5,030 3,026 0   0.59 1ht7b33257v1y   update (select /*+bypass_ujvc+...
5,030 3,026 0   0.59 dcb64w4mcsc62   DECLARE job BINARY_INTEGER := ...
5,030 3,026 0   0.59 dfy72pkc8brty   begin p_ry_g_kd_zhxq(to_char(s...
5,028 98 0   0.59 49yq7kw53mvtg   BEGIN P_RY_H_JT_YWFZ(TO_NUMBER...
5,025 155 0   0.59 61g38ybyzpx20   begin p_ry_k_xwq(to_char(sysda...
5,025 155 0   0.59 c1ws06z4trq47   DECLARE job BINARY_INTEGER := ...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
3,026 5,030 0   0.59 1ht7b33257v1y   update (select /*+bypass_ujvc+...
3,026 5,030 0   0.59 dcb64w4mcsc62   DECLARE job BINARY_INTEGER := ...
3,026 5,030 0   0.59 dfy72pkc8brty   begin p_ry_g_kd_zhxq(to_char(s...
1,680 5,022 1 1679.93 0.59 b40udps9qvq9n   DECLARE job BINARY_INTEGER := ...
523 3,048 0   0.36 935611xpxd3qt   DECLARE job BINARY_INTEGER := ...
509 889 1 508.80 0.10 9wvctftx1tf52   begin p_ry_a_qf(to_char(sysdat...
456 525 2 228.24 0.06 g2xzw32agj81u   begin p_ry_h_area_kpi_2013_fin...
380 417 1 379.69 0.05 ff1k2y1kp476s   begin p_ry_h_area_kpi_2013_fin...
330 4,143 43 7.68 0.49 0rvkkbzcqbf75   DECLARE job BINARY_INTEGER := ...
283 286 961 0.29 0.03 5z02f6r1yv7kz   INSERT INTO RY_KPI_DATA_SCORE ...
234 9,698 1 234.24 1.14 f7j4rubxmnwtp   create table ry_a_20680_xxt_cr...

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
232,690,646 0   53.36 3026.12 5030.28 1ht7b33257v1y   update (select /*+bypass_ujvc+...
232,690,646 0   53.36 3026.12 5030.28 dcb64w4mcsc62   DECLARE job BINARY_INTEGER := ...
232,690,646 0   53.36 3026.12 5030.28 dfy72pkc8brty   begin p_ry_g_kd_zhxq(to_char(s...
72,311,381 1 72,311,381.00 16.58 1679.93 5022.22 b40udps9qvq9n   DECLARE job BINARY_INTEGER := ...
51,722,709 0   11.86 522.76 3047.99 935611xpxd3qt   DECLARE job BINARY_INTEGER := ...
48,317,602 1 48,317,602.00 11.08 508.80 888.89 9wvctftx1tf52   begin p_ry_a_qf(to_char(sysdat...
34,343,201 43 798,679.09 7.88 330.06 4142.57 0rvkkbzcqbf75   DECLARE job BINARY_INTEGER := ...
32,734,282 210,671 155.38 7.51 229.56 1031.82 cn1gtsav2d5jh   BEGIN BEGIN IF (xdb.DBMS...
18,830,940 421,367 44.69 4.32 98.72 216.69 78m9ryygp65v5   SELECT /*+ ALL_ROWS */ COUNT(*...
17,420,033 1,349 12,913.29 3.99 207.71 468.01 7fc6c24bpu61q   INSERT INTO RY_KPI_DATA_INFO S...
16,770,015 2 8,385,007.50 3.85 456.49 524.73 g2xzw32agj81u   begin p_ry_h_area_kpi_2013_fin...
14,134,275 1 14,134,275.00 3.24 379.69 417.16 ff1k2y1kp476s   begin p_ry_h_area_kpi_2013_fin...
11,874,837 0   2.72 154.70 5025.07 61g38ybyzpx20   begin p_ry_k_xwq(to_char(sysda...
11,874,837 0   2.72 154.70 5025.07 c1ws06z4trq47   DECLARE job BINARY_INTEGER := ...
10,138,726 1,433 7,075.18 2.32 136.61 393.93 g2nwjrkq2npvz   DELETE FROM RY_KPI_DATA_INFO A...
9,313,612 1 9,313,612.00 2.14 248.49 248.49 g8uburr9g6s87   begin p_ry_h_area_kpi_2013_fin...
9,290,940 1 9,290,940.00 2.13 251.77 3476.27 21w9ttmdxdcx4   begin p_ry_h_area_kpi_2013_fin...
9,290,845 1 9,290,845.00 2.13 251.52 259.74 d7gqwrngrd96c   begin p_ry_h_area_kpi_2013_fin...
6,729,792 0   1.54 51.10 4792.33 fbpv5kqs2vjfb   DECLARE job BINARY_INTEGER := ...
6,608,287 961 6,876.47 1.52 282.83 285.86 5z02f6r1yv7kz   INSERT INTO RY_KPI_DATA_SCORE ...
6,531,583 210,695 31.00 1.50 25.92 42.30 bdv0rkkssq2jm   SELECT count(*) FROM user_poli...
6,287,730 0   1.44 31.01 4552.40 d610x36nt7vpp   DECLARE job BINARY_INTEGER := ...
6,286,443 0   1.44 31.00 4551.68 ba54drmmbfj20   begin P_RY_I_JQYXGZ(TO_CHAR(SY...
6,051,671 880 6,876.90 1.39 259.27 263.10 7bsugwyy2795x   INSERT INTO RY_KPI_DATA_INFO S...
5,984,593 0   1.37 37.04 4210.99 frwr5apszdu3z   BEGIN p_ry_d_dx_llf(to_char(sy...
5,329,153 775 6,876.33 1.22 227.79 2237.69 2qccbf012qr9x   INSERT INTO RY_KPI_DATA_SCORE ...
5,184,627 754 6,876.16 1.19 221.37 223.11 artdmw2cbtcs2   INSERT INTO RY_KPI_DATA_SCORE ...

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
6,233,292 0   23.05 31.01 4552.40 d610x36nt7vpp   DECLARE job BINARY_INTEGER := ...
6,233,264 0   23.05 31.00 4551.68 ba54drmmbfj20   begin P_RY_I_JQYXGZ(TO_CHAR(SY...
3,130,285 0   11.57 522.76 3047.99 935611xpxd3qt   DECLARE job BINARY_INTEGER := ...
2,663,353 0   9.85 51.10 4792.33 fbpv5kqs2vjfb   DECLARE job BINARY_INTEGER := ...
2,662,379 0   9.84 12.43 4169.78 08n79d46cpavm   DECLARE job BINARY_INTEGER := ...
2,662,369 0   9.84 12.31 4169.18 0stmzhszj5d32   begin p_ry_f_mm_jh_user(to_num...
2,638,037 1 2,638,037.00 9.75 4.38 3867.63 cytpm07dzgxk7   begin p_ry_f_gjgot_my(to_char(...
2,619,148 0   9.68 37.04 4210.99 frwr5apszdu3z   BEGIN p_ry_d_dx_llf(to_char(sy...
2,313,227 0   8.55 62.73 4958.86 47j3a12qax2ty   begin p_ry_g_dt_rate_view(to_c...
2,313,227 0   8.55 62.73 4958.86 8948ut5f4fa96   DECLARE job BINARY_INTEGER := ...
2,277,932 0   8.42 101.84 5030.85 gdv4g80r81f29   DECLARE job BINARY_INTEGER := ...
2,253,609 0   8.33 87.91 4941.41 crp4xg06p6czx   create table ry_b_deal_21024_9...
2,253,292 0   8.33 87.91 4935.95 15330pc1zak42   BEGIN p_ywjk_98_tc_two(to_char...
709,389 1 709,389.00 2.62 140.65 2088.74 6rhha6tvqr2bb PL/SQL Developer create table tmp_ry_f_0916_mon...
474,435 1 474,435.00 1.75 508.80 888.89 9wvctftx1tf52   begin p_ry_a_qf(to_char(sysdat...
368,386 0   1.36 154.70 5025.07 61g38ybyzpx20   begin p_ry_k_xwq(to_char(sysda...
368,386 0   1.36 154.70 5025.07 c1ws06z4trq47   DECLARE job BINARY_INTEGER := ...
321,209 0   1.19 98.28 5028.17 49yq7kw53mvtg   BEGIN P_RY_H_JT_YWFZ(TO_NUMBER...
321,209 0   1.19 98.29 5034.27 dhmd30cd96rrn   DECLARE job BINARY_INTEGER := ...

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
421,367 421,367 1.00 0.00 0.00 78m9ryygp65v5   SELECT /*+ ALL_ROWS */ COUNT(*...
210,695 210,695 1.00 0.00 0.00 bdv0rkkssq2jm   SELECT count(*) FROM user_poli...
210,671 210,671 1.00 0.00 0.00 cn1gtsav2d5jh   BEGIN BEGIN IF (xdb.DBMS...
210,654 0 0.00 0.00 0.00 52p6wm9z96c00   SELECT topology FROM SDO_T...
210,654 210,654 1.00 0.00 0.00 g8pzupt99fuzd   select dummy from dual where ...
210,643 210,643 1.00 0.00 0.00 63nj8b2r2t1xv   DECLARE cnt NUMBER;...
210,626 210,626 1.00 0.00 0.00 fy9ta5zgkwqmp   SELECT count(*) FROM user_poli...
210,580 210,580 1.00 0.00 0.00 bnrdkcuhnnyk5   declare stmt varchar2(200);...
9,997 9,996 1.00 0.01 0.02 grwydz59pu6mc   select text from view$ where r...
9,634 9,634 1.00 0.00 0.00 8chzv222jcp4m w3wp.exe SELECT * FROM NTSYS_COUNTY WHE...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
210,695 210,695 12.22 bdv0rkkssq2jm   SELECT count(*) FROM user_poli...
210,672 210,671 12.22 cn1gtsav2d5jh   BEGIN BEGIN IF (xdb.DBMS...
210,654 210,654 12.22 52p6wm9z96c00   SELECT topology FROM SDO_T...
210,654 210,654 12.22 g8pzupt99fuzd   select dummy from dual where ...
210,643 210,643 12.22 63nj8b2r2t1xv   DECLARE cnt NUMBER;...
210,626 210,626 12.22 fy9ta5zgkwqmp   SELECT count(*) FROM user_poli...
210,580 210,580 12.22 bnrdkcuhnnyk5   declare stmt varchar2(200);...
9,997 9,997 0.58 grwydz59pu6mc   select text from view$ where r...
9,634 9,634 0.56 8chzv222jcp4m w3wp.exe SELECT * FROM NTSYS_COUNTY WHE...
7,146 7,146 0.41 b0bs4tpbuqpmg w3wp.exe select t.* from (select a.* ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
4,030,182 4 0.06 bzcu3fq1yzjz8   create table ry_g_20371_swhy_t...
1,100,337 1 0.02 5vhvu2jmjvjbd   create table ry_h_20371_sjydfe...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
177 2,320 c19ja72sbfg1r   SELECT /* OPT_DYN_SAMP */ /*+ ...
119 4 bzcu3fq1yzjz8   create table ry_g_20371_swhy_t...
91 2,320 6uw5q0vynq9xd   SELECT /* OPT_DYN_SAMP */ /*+ ...
39 60 6x848xrx3cb6u   SELECT /* OPT_DYN_SAMP */ /*+ ...
29 1 5vhvu2jmjvjbd   create table ry_h_20371_sjydfe...
28 1 19w2zt78gpw71   create table ry_h_20371_swhy_t...
28 2,338 bv6m1k794wx68   SELECT /* OPT_DYN_SAMP */ /*+ ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
08n79d46cpavmDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN job_zzyw_total; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
0rvkkbzcqbf75DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN job_a_zdjh; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
0stmzhszj5d32begin p_ry_f_mm_jh_user(to_number(to_char(sysdate, 'yyyymmdd'))); end;
15330pc1zak42BEGIN p_ywjk_98_tc_two(to_char(sysdate-1, 'yyyymmdd')); END;
19w2zt78gpw71create table ry_h_20371_swhy_tmp as select a.county_id, (case when a.YEAR_ZJ<0 then 2 else 0 end)+(case when c.YEAR_ZJ<0 then 2 else 0 end) score from ry_f_21115_group_act_rpt c, ry_f_21115_jtw_act_rpt a where a.report_date = 20130914 and a.report_date = c.report_date and a.county_id = c.county_id and a.region_id is null
1ht7b33257v1yupdate (select /*+bypass_ujvc+*/ a.expire_month a_1, a.is_xf a_2, a.xf_date a_3, b.expire_month b_1, b.is_xf b_2, b.xf_date b_3 from ry_g_21118_zjuser_tmp a, (select * from (select row_number() over(partition by c.internet_user_id order by c.expire_month desc) rank, c.* from ry_h_20393_dq_detail_rpt c where c.report_date=20130915) where rank = 1) b where (a.internet_user_id=b.internet_user_id or a.internet_user_id=b.gsm_user_id)) set a_1 = b_1, a_2 = b_2, a_3 = b_3
21w9ttmdxdcx4begin p_ry_h_area_kpi_2013_finish(to_char(sysdate-3, 'yyyymmdd')); end;
2qccbf012qr9xINSERT INTO RY_KPI_DATA_SCORE SELECT REPORT_DATE, A.COUNTY_ID, A.BRANCH_ID, A.REGION_ID, A.ORG_ID, A.ORG_LEVEL, A.KPI_ID, :B10 , (CASE WHEN SUM(CASE WHEN A.DATA_ID =3 THEN NVL(A.DATA_VALUE, 0) END)<SUM(CASE WHEN A.DATA_ID =:B5 THEN NVL(A.DATA_VALUE, 0) END)*:B9 *:B8 THEN :B7 *:B6 END) FROM RY_KPI_DATA_INFO A WHERE A.DATA_ID IN (:B5 , 3) AND A.REPORT_DATE = :B4 AND A.KPI_ID = :B3 AND A.COUNTY_ID = :B2 AND A.ORG_LEVEL = :B1 GROUP BY A.REPORT_DATE, A.COUNTY_ID, A.BRANCH_ID, A.REGION_ID, A.ORG_ID, A.ORG_LEVEL, A.KPI_ID
45xfyfh8c9vm8select count(1) from t_priv_regiter_info a where 1=1 and a.privid = '46' and a.status=1 and a.msisdn=:1
47j3a12qax2tybegin p_ry_g_dt_rate_view(to_char(sysdate-1, 'yyyymmdd')); end;
49yq7kw53mvtgBEGIN P_RY_H_JT_YWFZ(TO_NUMBER(TO_CHAR(SYSDATE-1, 'YYYYMMDD'))); END;
52p6wm9z96c00SELECT topology FROM SDO_TOPO_METADATA_TABLE a, TABLE(a.Topo_Geometry_Layers) b WHERE b.owner = :owner AND b.table_name = :tab
5vhvu2jmjvjbdcreate table ry_h_20371_sjydfe_tmp as select * from (select a.county_id, a.yd_rate_j, rank() over(order by a.yd_rate_j desc) rk from ry_k_20784_sjydfe_new2_rpt a where a.report_date = 20130914 and a.branch_id is null and a.county_id not in(7777, 9999) and type = 2) where rk <= 3 and yd_rate_j>=0.66
5z02f6r1yv7kzINSERT INTO RY_KPI_DATA_SCORE SELECT REPORT_DATE, A.COUNTY_ID, A.BRANCH_ID, A.REGION_ID, A.ORG_ID, A.ORG_LEVEL, A.KPI_ID, :B13 , (CASE WHEN SUM(CASE WHEN A.DATA_ID =3 THEN NVL(A.DATA_VALUE, 0) END)>SUM(CASE WHEN A.DATA_ID =:B6 THEN NVL(A.DATA_VALUE, 0) END)*:B8 *:B7 AND SUM(CASE WHEN A.DATA_ID =3 THEN NVL(A.DATA_VALUE, 0) END)<SUM(CASE WHEN A.DATA_ID =:B5 THEN NVL(A.DATA_VALUE, 0) END)*:B8 *:B9 THEN ROUND(:B11 *:B10 + (:B11 *:B12 -:B11 *:B10 ) /(SUM(CASE WHEN A.DATA_ID =:B5 THEN NVL(A.DATA_VALUE, 0) END)*:B8 *:B9 - SUM(CASE WHEN A.DATA_ID =:B6 THEN NVL(A.DATA_VALUE, 0) END)*:B8 *:B7 ) *(SUM(CASE WHEN A.DATA_ID =3 THEN NVL(A.DATA_VALUE, 0) END)-SUM(CASE WHEN A.DATA_ID =:B6 THEN NVL(A.DATA_VALUE, 0) END)*:B8 *:B7 ), 2) END) FROM RY_KPI_DATA_INFO A WHERE A.DATA_ID IN (:B6 , :B5 , 3) AND A.REPORT_DATE = :B4 AND A.KPI_ID = :B3 AND A.COUNTY_ID = :B2 AND A.ORG_LEVEL = :B1 GROUP BY A.REPORT_DATE, A.COUNTY_ID, A.BRANCH_ID, A.REGION_ID, A.ORG_ID, A.ORG_LEVEL, A.KPI_ID
61g38ybyzpx20begin p_ry_k_xwq(to_char(sysdate-1, 'yyyymmdd')); end;
63nj8b2r2t1xvDECLARE cnt NUMBER; stmt VARCHAR(500); topology VARCHAR(100); REG_TBL EXCEPTION; BEGIN stmt := 'SELECT topology ' || ' FROM SDO_TOPO_METADATA_TABLE a, TABLE(a.Topo_Geometry_Layers) b ' || ' WHERE b.owner = :owner AND b.table_name = :tab ' ; EXECUTE IMMEDIATE stmt into topology USING ORA_DICT_OBJ_OWNER, ORA_DICT_OBJ_NAME; RAISE REG_TBL; EXCEPTION WHEN REG_TBL THEN MDSYS.MDERR.raise_md_error( 'MD', 'SDO', -13199, 'Need use delete_topo_geometry_layer() to deregister table ' || ORA_DICT_OBJ_NAME || ' from topology ' || topology || ' before drop it'); WHEN OTHERS THEN RETURN; END;
6rhha6tvqr2bbcreate table tmp_ry_f_0916_mon8_zh nologging as select a.user_id, a.other_party, a.cnt_call, a.duration60 from dm_rej_user_gsm_serial_mon_01@to_bascm1 a, tmp_ry_f_0916_home_user1 b where a.mon_number =8 and a.user_id =b.home_user_id
6uw5q0vynq9xdSELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_00"), NVL(SUM(C2), :"SYS_B_01"), NVL(SUM(C3), :"SYS_B_02"), NVL(SUM(C4), :"SYS_B_03") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("SUBSCRIBER") FULL("SUBSCRIBER") NO_PARALLEL_INDEX("SUBSCRIBER") */ :"SYS_B_04" AS C1, CASE WHEN "SUBSCRIBER"."SERVNUMBER"=:"SYS_B_05" AND "SUBSCRIBER"."ACTIVE"=:"SYS_B_06" AND "SUBSCRIBER"."NETTYPE"=:"SYS_B_07" THEN :"SYS_B_08" ELSE :"SYS_B_09" END AS C2, CASE WHEN "SUBSCRIBER"."NETTYPE"=:"SYS_B_10" THEN :"SYS_B_11" ELSE :"SYS_B_12" END AS C3, CASE WHEN "SUBSCRIBER"."SERVNUMBER"=:"SYS_B_13" THEN :"SYS_B_14" ELSE :"SYS_B_15" END AS C4 FROM "NGRC"."SUBSCRIBER" SAMPLE BLOCK (:"SYS_B_16" , :"SYS_B_17") SEED (:"SYS_B_18") "SUBSCRIBER") SAMPLESUB
6x848xrx3cb6uSELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("A") FULL("A") NO_PARALLEL_INDEX("A") */ :"SYS_B_2" AS C1, CASE WHEN "A"."MSISDN"=:"SYS_B_3" THEN :"SYS_B_4" ELSE :"SYS_B_5" END AS C2 FROM "NGRC"."USER_NEW_ADD" SAMPLE BLOCK (:"SYS_B_6" , :"SYS_B_7") SEED (:"SYS_B_8") "A") SAMPLESUB
78m9ryygp65v5SELECT /*+ ALL_ROWS */ COUNT(*) FROM ALL_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND V.OBJECT_NAME = :B2 AND (POLICY_NAME LIKE '%xdbrls%' OR POLICY_NAME LIKE '%$xd_%') AND V.FUNCTION = :B1
7bsugwyy2795xINSERT INTO RY_KPI_DATA_INFO SELECT A.REPORT_DATE, A.COUNTY_ID, A.BRANCH_ID, A.REGION_ID, A.ORG_ID, A.ORG_LEVEL, A.KPI_ID, :B5 , ROUND(F_DIV(SUM(CASE WHEN A.DATA_ID =3 THEN A.DATA_VALUE END), SUM(CASE WHEN A.DATA_ID =DECODE(:B5 , 4, 1, 6, 2) THEN A.DATA_VALUE END)), 4) FROM RY_KPI_DATA_INFO A WHERE A.DATA_ID IN (DECODE(:B5 , 4, 1, 6, 2) , 3) AND A.REPORT_DATE = :B4 AND A.KPI_ID = :B3 AND A.COUNTY_ID = :B2 AND A.ORG_LEVEL = :B1 GROUP BY A.REPORT_DATE, A.COUNTY_ID, A.BRANCH_ID, A.REGION_ID, A.ORG_ID, A.ORG_LEVEL, A.KPI_ID
7fc6c24bpu61qINSERT INTO RY_KPI_DATA_INFO SELECT :B4 , A.COUNTY_ID, A.BRANCH_ID, A.REGION_ID, A.ORG_ID, A.ORG_LEVEL, A.KPI_ID, :B5 , A.KPI_VALUE FROM RY_KPI_VALUE A WHERE A.REPORT_DATE = :B4 AND A.KPI_ID = :B3 AND A.COUNTY_ID = :B2 AND A.ORG_LEVEL = :B1
8948ut5f4fa96DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN JOB_G_TOTAL; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
8chzv222jcp4mSELECT * FROM NTSYS_COUNTY WHERE COUNTY_ID=:COUNTY_ID
935611xpxd3qtDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN JOB_OTHER_TOTAL; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
9wvctftx1tf52begin p_ry_a_qf(to_char(sysdate-1, 'yyyymmdd')); end;
artdmw2cbtcs2INSERT INTO RY_KPI_DATA_SCORE SELECT REPORT_DATE, A.COUNTY_ID, A.BRANCH_ID, A.REGION_ID, A.ORG_ID, A.ORG_LEVEL, A.KPI_ID, :B10 , (CASE WHEN SUM(CASE WHEN A.DATA_ID =3 THEN NVL(A.DATA_VALUE, 0) END)>SUM(CASE WHEN A.DATA_ID =:B5 THEN NVL(A.DATA_VALUE, 0) END)*:B9 *:B8 THEN :B7 *:B6 END) FROM RY_KPI_DATA_INFO A WHERE A.DATA_ID IN (:B5 , 3) AND A.REPORT_DATE = :B4 AND A.KPI_ID = :B3 AND A.COUNTY_ID = :B2 AND A.ORG_LEVEL = :B1 GROUP BY A.REPORT_DATE, A.COUNTY_ID, A.BRANCH_ID, A.REGION_ID, A.ORG_ID, A.ORG_LEVEL, A.KPI_ID
b0bs4tpbuqpmgselect t.* from (select a.* from t_message_info a where to_char(sysdate, 'yyyy-mm-dd') between to_char(a.start_time, 'yyyy-mm-dd') and to_char(a.end_date, 'yyyy-mm-dd') and a.status = 1 and a.county_id = '20' and a.show_flag = 1 order by operator_date desc) t where rownum <= 4
b40udps9qvq9nDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN JOB_KPI_TOTAL; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
ba54drmmbfj20begin P_RY_I_JQYXGZ(TO_CHAR(SYSDATE-1, 'YYYYMMDD')); end;
bdv0rkkssq2jmSELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPF'
bnrdkcuhnnyk5declare stmt varchar2(200); rdf_exception EXCEPTION; pragma exception_init(rdf_exception, -20000); BEGIN if dictionary_obj_type = 'USER' THEN BEGIN EXECUTE IMMEDIATE 'begin ' || 'mdsys.rdf_apis_internal.' || 'notify_drop_user( :don ); ' || 'end;' USING dbms_assert.QUALIFIED_SQL_NAME(dictionary_obj_name); EXCEPTION WHEN rdf_exception THEN RAISE; WHEN OTHERS THEN NULL; END; end if; end;
bv6m1k794wx68SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_00"), NVL(SUM(C2), :"SYS_B_01"), NVL(SUM(C3), :"SYS_B_02") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("A") FULL("A") NO_PARALLEL_INDEX("A") */ :"SYS_B_03" AS C1, CASE WHEN "A"."MSISDN"=:"SYS_B_04" AND ("A"."VIP_GRADE"=:"SYS_B_05" OR "A"."VIP_GRADE"=:"SYS_B_06" OR "A"."VIP_GRADE"=:"SYS_B_07") AND "A"."USER_STATUS"<:"SYS_B_08" THEN :"SYS_B_09" ELSE :"SYS_B_10" END AS C2, CASE WHEN "A"."MSISDN"=:"SYS_B_11" THEN :"SYS_B_12" ELSE :"SYS_B_13" END AS C3 FROM "NGRC"."USER_NEW_ADD" SAMPLE BLOCK (:"SYS_B_14" , :"SYS_B_15") SEED (:"SYS_B_16") "A") SAMPLESUB
bzcu3fq1yzjz8create table ry_g_20371_swhy_tmp as select a.county_id, a.YEAR_ZJ jtw_zj, c.YEAR_ZJ group_zj, (case when a.YEAR_ZJ<0 then -2 else 0 end) + (case when c.YEAR_ZJ<0 then -2 else 0 end) score from ry_f_21115_group_act_rpt c, ry_f_21115_jtw_act_rpt a where a.report_date = 20130914 and a.report_date = c.report_date and a.county_id = c.county_id and a.region_id is null
c19ja72sbfg1rSELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("A") FULL("A") NO_PARALLEL_INDEX("A") */ :"SYS_B_2" AS C1, CASE WHEN "A"."MSISDN"=:"SYS_B_3" THEN :"SYS_B_4" ELSE :"SYS_B_5" END AS C2 FROM "NGRC"."RY_A_20756_ZKZGD" SAMPLE BLOCK (:"SYS_B_6" , :"SYS_B_7") SEED (:"SYS_B_8") "A") SAMPLESUB
c1ws06z4trq47DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN job_threenet_total; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
cn1gtsav2d5jhBEGIN BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner)) THEN xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; END;
crp4xg06p6czxcreate table ry_b_deal_21024_98_tc_tmp as select /*+first_rows*/subsid, prodid, applyoperid, applydate, cast(null as number) county_id, cast(null as varchar2(32)) county_name, cast(null as number) org_id, cast(null as varchar2(128)) org_name, 0 kd_flag, 0 jtw_flag, 0 jty_flag from ngrc.subs_product a where a.prodid in ('2000003692', '2000003702', '2000003694', '2000003695', '2000003696', '2000003697', '2000003698', '2000003704', '2000003707', '2000003708') and nvl(a.enddate, a.startdate + 1) > a.startdate and nvl(a.enddate, sysdate + 1) > sysdate and to_char(a.applydate, 'yyyymmdd')=20130915
cytpm07dzgxk7begin p_ry_f_gjgot_my(to_char(sysdate-1, 'yyyymmdd')); end;
d610x36nt7vppDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN JOB_MARKET_TOTAL; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
d7gqwrngrd96cbegin p_ry_h_area_kpi_2013_finish(to_char(sysdate-5, 'yyyymmdd')); end;
dcb64w4mcsc62DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN JOB_INTERNET_TOTAL; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
dfy72pkc8brtybegin p_ry_g_kd_zhxq(to_char(sysdate-1, 'yyyymmdd')); end;
dhmd30cd96rrnDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN P_RY_HOME_TOTAL; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
f7j4rubxmnwtpcreate table ry_a_20680_xxt_crm as select /*+parallel(a, 3) parallel(b, 3) use_hash(a, b)*/ a.subsid, wm_concat(b.prodname) prodname, sum(b.prodvalue) payment from ry_a_20680_xxt_user a, ry_a_20680_xxt_prod b where a.prodid = b.prodid group by a.subsid
fbpv5kqs2vjfbDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN job_zzyw_total2; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
ff1k2y1kp476sbegin p_ry_h_area_kpi_2013_finish(to_char(sysdate-1, 'yyyymmdd')); end;
frwr5apszdu3zBEGIN p_ry_d_dx_llf(to_char(sysdate-1, 'yyyymmdd')); END;
fy9ta5zgkwqmpSELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPROPF'
g2nwjrkq2npvzDELETE FROM RY_KPI_DATA_INFO A WHERE A.REPORT_DATE=:B4 AND A.KPI_ID=:B3 AND A.ORG_LEVEL=:B2 AND A.COUNTY_ID=:B1
g2xzw32agj81ubegin p_ry_h_area_kpi_2013_finish(to_char(sysdate-2, 'yyyymmdd')); end;
g8pzupt99fuzdselect dummy from dual where ora_dict_obj_type = 'TABLE'
g8uburr9g6s87begin p_ry_h_area_kpi_2013_finish(to_char(sysdate-4, 'yyyymmdd')); end;
gdv4g80r81f29DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN JOB_YWJK_TOTAL; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
grwydz59pu6mcselect text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 575,231 130.17 2.79
CPU used when call started 287,067 64.96 1.39
CR blocks created 35,048 7.93 0.17
Cached Commit SCN referenced 491,417 111.21 2.38
Commit SCN cached 46 0.01 0.00
DB time 82,770,784 18,730.68 401.03
DBWR checkpoint buffers written 676,187 153.02 3.28
DBWR checkpoints 82 0.02 0.00
DBWR object drop buffers written 107 0.02 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR revisited being-written buffer 91 0.02 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 392,249 88.76 1.90
DBWR transaction table writes 373 0.08 0.00
DBWR undo block writes 307,274 69.53 1.49
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 19 0.00 0.00
IMU CR rollbacks 51 0.01 0.00
IMU Flushes 1,465 0.33 0.01
IMU Redo allocation size 13,292,376 3,008.01 64.40
IMU bind flushes 0 0.00 0.00
IMU commits 4,557 1.03 0.02
IMU contention 237 0.05 0.00
IMU ktichg flush 0 0.00 0.00
IMU pool not allocated 467 0.11 0.00
IMU recursive-transaction flush 0 0.00 0.00
IMU undo allocation size 69,450,736 15,716.41 336.50
IMU- failed to get a private strand 467 0.11 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 9,548,973 2,160.89 46.27
PX local messages sent 9,548,971 2,160.89 46.27
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 19 0.00 0.00
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for undo segment recovery 1 0.00 0.00
SMON posted for undo segment shrink 10 0.00 0.00
SQL*Net roundtrips to/from client 190,755 43.17 0.92
SQL*Net roundtrips to/from dblink 24,059 5.44 0.12
active txn count during cleanout 497,704 112.63 2.41
application wait time 190 0.04 0.00
auto extends on undo tablespace 0 0.00 0.00
background checkpoints completed 14 0.00 0.00
background checkpoints started 11 0.00 0.00
background timeouts 10,436 2.36 0.05
branch node splits 75 0.02 0.00
buffer is not pinned count 38,791,157 8,778.28 187.95
buffer is pinned count 199,492,325 45,144.29 966.57
bytes received via SQL*Net from client 22,788,306 5,156.90 110.41
bytes received via SQL*Net from dblink 4,968,114,317 1,124,263.65 24,071.14
bytes sent via SQL*Net to client 2,418,419,269 547,278.24 11,717.55
bytes sent via SQL*Net to dblink 6,169,733 1,396.18 29.89
calls to get snapshot scn: kcmgss 8,854,124 2,003.65 42.90
calls to kcmgas 41,379 9.36 0.20
calls to kcmgcs 597,049 135.11 2.89
change write time 76,560 17.33 0.37
cleanout - number of ktugct calls 503,194 113.87 2.44
cleanouts and rollbacks - consistent read gets 3,009 0.68 0.01
cleanouts only - consistent read gets 5,421 1.23 0.03
cluster key scan block gets 3,212,268 726.92 15.56
cluster key scans 2,004,113 453.52 9.71
commit batch performed 948 0.21 0.00
commit batch requested 948 0.21 0.00
commit batch/immediate performed 964 0.22 0.00
commit batch/immediate requested 964 0.22 0.00
commit cleanout failures: block lost 89 0.02 0.00
commit cleanout failures: buffer being written 223 0.05 0.00
commit cleanout failures: callback failure 1,020 0.23 0.00
commit cleanout failures: cannot pin 231 0.05 0.00
commit cleanouts 467,964 105.90 2.27
commit cleanouts successfully completed 466,401 105.54 2.26
commit immediate performed 16 0.00 0.00
commit immediate requested 16 0.00 0.00
commit txn count during cleanout 22,736 5.15 0.11
concurrency wait time 22,145,433 5,011.42 107.30
consistent changes 145,304 32.88 0.70
consistent gets 410,413,212 92,874.81 1,988.50
consistent gets - examination 23,244,761 5,260.19 112.62
consistent gets direct 17,610,473 3,985.18 85.32
consistent gets from cache 392,802,728 88,889.63 1,903.18
cursor authentications 1,295 0.29 0.01
data blocks consistent reads - undo records applied 145,146 32.85 0.70
db block changes 39,396,517 8,915.27 190.88
db block gets 25,689,225 5,813.36 124.47
db block gets direct 363,595 82.28 1.76
db block gets from cache 25,325,630 5,731.08 122.71
deferred (CURRENT) block cleanout applications 235,742 53.35 1.14
dirty buffers inspected 26,649 6.03 0.13
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 51,668 11.69 0.25
enqueue deadlocks 0 0.00 0.00
enqueue releases 164,602 37.25 0.80
enqueue requests 165,220 37.39 0.80
enqueue timeouts 633 0.14 0.00
enqueue waits 102 0.02 0.00
exchange deadlocks 0 0.00 0.00
execute count 3,163,139 715.81 15.33
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 8,518,422 1,927.68 41.27
free buffer requested 8,418,363 1,905.04 40.79
global undo segment hints helped 0 0.00 0.00
global undo segment hints were stale 0 0.00 0.00
heap block compress 5,612,992 1,270.20 27.20
hot buffers moved to head of LRU 1,228,343 277.97 5.95
immediate (CR) block cleanout applications 8,430 1.91 0.04
immediate (CURRENT) block cleanout applications 49,541 11.21 0.24
index crx upgrade (found) 285 0.06 0.00
index crx upgrade (positioned) 9,114 2.06 0.04
index fast full scans (full) 58 0.01 0.00
index fetch by key 8,279,625 1,873.64 40.12
index scans kdiixs1 4,510,882 1,020.79 21.86
leaf node 90-10 splits 342 0.08 0.00
leaf node splits 16,588 3.75 0.08
lob reads 18 0.00 0.00
lob writes 128 0.03 0.00
lob writes unaligned 128 0.03 0.00
local undo segment hints helped 0 0.00 0.00
local undo segment hints were stale 0 0.00 0.00
logons cumulative 2,561 0.58 0.01
messages received 51,524 11.66 0.25
messages sent 51,524 11.66 0.25
no buffer to keep pinned count 3 0.00 0.00
no work - consistent read gets 380,629,238 86,134.82 1,844.20
opened cursors cumulative 1,721,698 389.61 8.34
parse count (failures) 756 0.17 0.00
parse count (hard) 210,415 47.62 1.02
parse count (total) 1,723,789 390.09 8.35
parse time cpu 74,795 16.93 0.36
parse time elapsed 7,580,844 1,715.51 36.73
physical read IO requests 2,137,269 483.66 10.36
physical read bytes ############### 50,135,488.10 1,073,429.92
physical read total IO requests 2,143,914 485.16 10.39
physical read total bytes ############### 50,159,979.67 1,073,954.30
physical read total multi block requests 1,807,519 409.03 8.76
physical reads 27,044,485 6,120.05 131.03
physical reads cache 7,839,169 1,773.97 37.98
physical reads cache prefetch 6,935,777 1,569.54 33.60
physical reads direct 19,205,316 4,346.08 93.05
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 1,591,274 360.10 7.71
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 293,252 66.36 1.42
physical write bytes 16,432,807,936 3,718,676.23 79,619.02
physical write total IO requests 316,032 71.52 1.53
physical write total bytes 22,243,446,272 5,033,599.56 107,772.29
physical write total multi block requests 149,155 33.75 0.72
physical writes 2,005,958 453.94 9.72
physical writes direct 1,268,759 287.11 6.15
physical writes direct (lob) 4 0.00 0.00
physical writes direct temporary tablespace 903,783 204.52 4.38
physical writes from cache 737,199 166.83 3.57
physical writes non checkpoint 1,787,352 404.47 8.66
pinned buffers inspected 1,269 0.29 0.01
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 1,300 0.29 0.01
process last non-idle time 4,476 1.01 0.02
queries parallelized 19 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 8,020,948 1,815.11 38.86
recursive cpu usage 419,851 95.01 2.03
redo blocks written 11,146,801 2,522.47 54.01
redo buffer allocation retries 106 0.02 0.00
redo entries 19,650,731 4,446.88 95.21
redo log space requests 189 0.04 0.00
redo log space wait time 5,333 1.21 0.03
redo ordering marks 294 0.07 0.00
redo size 5,504,355,228 1,245,612.74 26,669.29
redo subscn max counts 2,968 0.67 0.01
redo synch time 2,005 0.45 0.01
redo synch writes 2,739 0.62 0.01
redo wastage 5,101,952 1,154.55 24.72
redo write time 2,378 0.54 0.01
redo writer latching time 16,858 3.81 0.08
redo writes 13,028 2.95 0.06
rollback changes - undo records applied 396,455 89.72 1.92
rollbacks only - consistent read gets 32,010 7.24 0.16
rows fetched via callback 6,041,188 1,367.10 29.27
session connect time 250,551 56.70 1.21
session cursor cache hits 1,469,615 332.57 7.12
session logical reads 436,102,664 98,688.22 2,112.97
session pga memory max ############### 248,557,754.28 5,321,765.88
session uga memory ############### 1,120,227,728.07 23,984,726.27
session uga memory max 14,797,161,704 3,348,536.27 71,694.11
shared hash latch upgrades - no wait 11,234 2.54 0.05
shared hash latch upgrades - wait 286 0.06 0.00
sorts (disk) 7 0.00 0.00
sorts (memory) 377,393 85.40 1.83
sorts (rows) 100,732,016 22,795.24 488.06
space was found by tune down 0 0.00 0.00
space was not found by tune down 0 0.00 0.00
sql area evicted 8,646 1.96 0.04
sql area purged 913 0.21 0.00
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 74,556 16.87 0.36
switch current to new buffer 258,260 58.44 1.25
table fetch by rowid 95,959,255 21,715.18 464.93
table fetch continued row 6,176,929 1,397.81 29.93
table scan blocks gotten 349,088,964 78,997.38 1,691.38
table scan rows gotten 30,369,900,103 6,872,582.34 147,145.98
table scans (direct read) 1,468 0.33 0.01
table scans (long tables) 7,300 1.65 0.04
table scans (rowid ranges) 2,744 0.62 0.01
table scans (short tables) 2,419,443 547.51 11.72
total number of times SMON posted 46 0.01 0.00
transaction rollbacks 964 0.22 0.00
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 1,889,849,524 427,665.10 9,156.56
user I/O wait time 3,019,552 683.31 14.63
user calls 264,000 59.74 1.28
user commits 6,754 1.53 0.03
user rollbacks 199,639 45.18 0.97
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 19 0.00 0.00
workarea executions - optimal 319,907 72.39 1.55
write clones created in background 23 0.01 0.00
write clones created in foreground 1,996 0.45 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 139,089,657 139,112,030
opened cursors current 1,605 1,757
workarea memory allocated 5,471,295 3,669,995
logons current 271 279

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 11 8.96

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)
TBS_MARKET_NG 1,553,638 352 25.86 13.92 100 0 121,528 17.09
TBS_MARKET_DEAL 223,643 51 44.80 11.27 176,808 40 254 52.83
TEMP 113,846 26 24.25 14.02 59,076 13 0 0.00
TBS_MARKET_NTJKRC 152,536 35 19.54 4.09 207 0 239 1.80
TBS_MARKET_BACKUP 54,870 12 18.05 11.08 450 0 0 0.00
UNDOTBS1 14 0 130.00 1.00 54,688 12 351 68.15
TBS_MARKET_QTTJ 46,990 11 6.80 5.78 1,191 0 335 49.19
SYSTEM 3,936 1 12.71 1.01 1,133 0 335 137.01
SYSAUX 1,963 0 60.96 1.09 497 0 3 3.33
TBS_MARKET_XDL 201 0 28.36 1.00 63 0 0 0.00
USERS 11 0 125.45 1.00 11 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SYSAUX /dev/rsysaux01 1,963 0 60.96 1.09 497 0 3 3.33
SYSTEM /dev/rsystem01 3,936 1 12.71 1.01 1,133 0 335 137.01
TBS_MARKET_BACKUP /dev/rvg02_20g_dat001 1,159 0 5.38 11.54 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat002 1,150 0 6.27 11.64 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat003 1,551 0 4.24 10.79 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat004 1,565 0 3.16 10.68 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat005 969 0 5.90 12.94 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat006 1,553 0 4.29 10.78 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat007 1,196 0 4.57 11.60 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat008 1,267 0 35.63 9.12 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat009 837 0 8.70 8.55 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat010 1,339 0 4.01 8.96 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat011 1,623 0 4.50 10.23 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat012 1,805 0 4.56 9.06 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat013 1,434 0 4.21 7.69 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat014 1,778 0 3.28 9.18 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat015 1,954 0 2.71 8.36 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat016 1,892 0 1.72 8.08 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat017 1,406 0 3.53 10.09 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat018 1,070 0 4.50 11.16 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat019 1,527 0 2.10 10.32 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat020 1,376 0 4.02 11.57 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat021 1,310 0 3.92 11.59 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat022 1,253 0 2.43 12.00 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat023 1,287 0 4.23 11.66 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat024 1,094 0 4.46 11.39 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat025 1,058 0 3.10 10.56 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat026 1,117 0 5.28 11.61 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat027 856 0 5.70 10.12 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat028 1,261 0 2.69 12.11 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat029 1,036 0 4.87 13.04 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat030 1,022 0 5.15 13.26 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat031 1,033 0 3.06 13.36 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat032 871 0 6.02 11.96 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat033 1,096 0 4.77 13.07 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat034 1,016 0 3.42 13.35 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat035 999 0 37.73 13.58 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat036 796 0 206.65 12.53 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat037 971 0 224.79 14.02 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat038 806 0 269.53 12.30 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat039 1,083 0 34.16 10.89 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg02_20g_dat040 1,121 0 21.97 11.45 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg03_20g_dat007 969 0 18.10 14.05 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg03_20g_dat008 1,033 0 15.49 13.08 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg03_20g_dat009 1,144 0 9.93 11.70 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg03_20g_dat010 1,065 0 13.80 12.66 10 0 0 0.00
TBS_MARKET_BACKUP /dev/rvg03_20g_dat011 1,122 0 11.38 11.95 10 0 0 0.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat001 3,891 1 91.52 11.28 2,280 1 8 25.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat002 3,208 1 84.00 12.70 2,317 1 9 67.78
TBS_MARKET_DEAL /dev/rvg01_20g_dat003 3,745 1 102.27 11.73 1,888 0 8 91.25
TBS_MARKET_DEAL /dev/rvg01_20g_dat004 3,591 1 93.69 13.54 1,920 0 8 33.75
TBS_MARKET_DEAL /dev/rvg01_20g_dat005 3,468 1 52.87 11.09 2,098 0 8 105.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat006 3,853 1 24.09 11.16 2,572 1 8 62.50
TBS_MARKET_DEAL /dev/rvg01_20g_dat007 3,683 1 41.33 10.50 3,792 1 8 11.25
TBS_MARKET_DEAL /dev/rvg01_20g_dat008 3,195 1 42.07 10.60 3,383 1 8 67.50
TBS_MARKET_DEAL /dev/rvg01_20g_dat009 3,552 1 18.75 11.54 2,696 1 8 52.50
TBS_MARKET_DEAL /dev/rvg01_20g_dat010 4,735 1 97.03 11.29 2,758 1 11 19.09
TBS_MARKET_DEAL /dev/rvg01_20g_dat011 3,789 1 78.95 10.62 2,499 1 10 66.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat012 3,875 1 41.16 10.93 2,788 1 8 67.50
TBS_MARKET_DEAL /dev/rvg01_20g_dat013 3,182 1 9.94 11.00 2,732 1 10 19.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat014 4,369 1 17.83 10.44 2,514 1 8 75.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat015 4,001 1 18.30 11.17 3,234 1 9 26.67
TBS_MARKET_DEAL /dev/rvg01_20g_dat016 3,721 1 9.03 11.08 2,883 1 9 11.11
TBS_MARKET_DEAL /dev/rvg01_20g_dat017 5,242 1 36.28 9.87 5,032 1 7 91.43
TBS_MARKET_DEAL /dev/rvg01_20g_dat018 5,951 1 221.82 8.99 5,865 1 0 0.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat019 4,599 1 187.99 10.19 5,129 1 0 0.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat020 5,816 1 22.52 8.53 3,840 1 0 0.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat021 6,127 1 18.17 9.10 4,262 1 2 40.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat022 4,455 1 11.45 10.44 3,142 1 3 20.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat023 5,608 1 24.63 11.03 2,761 1 1 30.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat024 4,383 1 44.41 11.05 3,001 1 1 50.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat025 4,838 1 41.87 9.58 2,598 1 1 30.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat026 5,038 1 57.87 11.10 4,241 1 1 30.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat027 4,818 1 57.17 12.02 3,280 1 1 310.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat028 4,872 1 62.60 10.63 4,998 1 1 10.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat029 4,086 1 118.40 11.88 3,342 1 1 20.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat030 4,567 1 26.86 10.81 3,739 1 1 110.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat031 4,040 1 17.49 11.23 3,494 1 1 30.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat032 4,557 1 26.01 11.54 4,404 1 1 10.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat033 4,422 1 39.04 11.60 3,382 1 1 60.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat034 4,803 1 50.30 12.18 3,985 1 1 20.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat035 5,699 1 16.49 10.17 4,038 1 1 50.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat036 4,360 1 19.53 11.33 2,722 1 1 110.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat037 4,947 1 49.13 12.38 4,791 1 1 40.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat038 3,677 1 22.10 12.73 3,293 1 8 65.00
TBS_MARKET_DEAL /dev/rvg01_20g_dat039 3,692 1 56.63 11.80 3,330 1 8 113.75
TBS_MARKET_DEAL /dev/rvg01_20g_dat040 2,932 1 48.43 12.46 2,639 1 3 60.00
TBS_MARKET_DEAL /dev/rvg03_20g_dat015 4,839 1 9.38 11.98 5,354 1 8 10.00
TBS_MARKET_DEAL /dev/rvg03_20g_dat016 5,287 1 17.35 11.84 4,546 1 5 98.00
TBS_MARKET_DEAL /dev/rvg03_20g_dat017 4,896 1 6.96 13.75 4,252 1 3 23.33
TBS_MARKET_DEAL /dev/rvg03_20g_dat018 4,375 1 68.09 11.78 3,923 1 8 51.25
TBS_MARKET_DEAL /dev/rvg03_20g_dat019 5,387 1 9.34 11.04 4,835 1 8 43.75
TBS_MARKET_DEAL /dev/rvg03_20g_dat020 5,506 1 7.66 11.68 4,731 1 8 82.50
TBS_MARKET_DEAL /dev/rvg03_20g_dat021 5,222 1 10.81 13.44 4,679 1 6 43.33
TBS_MARKET_DEAL /dev/rvg03_20g_dat022 5,128 1 13.42 12.78 3,047 1 8 58.75
TBS_MARKET_DEAL /dev/rvg03_20g_dat023 4,743 1 11.47 12.27 3,924 1 8 37.50
TBS_MARKET_DEAL /dev/rvg03_20g_dat024 4,873 1 6.24 12.47 3,855 1 8 36.25
TBS_MARKET_NG /dev/rvg01_20g_dat041 149,709 34 40.47 13.97 10 0 10,359 24.39
TBS_MARKET_NG /dev/rvg01_20g_dat042 164,599 37 27.19 13.92 10 0 13,095 19.66
TBS_MARKET_NG /dev/rvg01_20g_dat043 153,860 35 9.80 14.01 10 0 10,643 7.81
TBS_MARKET_NG /dev/rvg01_20g_dat044 162,033 37 29.36 13.93 10 0 12,900 27.29
TBS_MARKET_NG /dev/rvg01_20g_dat045 161,240 36 33.92 13.96 10 0 12,196 24.31
TBS_MARKET_NG /dev/rvg01_20g_dat046 164,745 37 15.48 13.90 10 0 13,711 4.44
TBS_MARKET_NG /dev/rvg01_20g_dat047 154,093 35 28.03 13.77 10 0 14,358 21.51
TBS_MARKET_NG /dev/rvg01_20g_dat048 147,348 33 24.66 13.89 10 0 11,524 15.02
TBS_MARKET_NG /dev/rvg01_20g_dat049 148,945 34 10.33 13.81 10 0 12,971 5.85
TBS_MARKET_NG /dev/rvg01_20g_dat050 147,066 33 39.94 14.03 10 0 9,771 22.10
TBS_MARKET_NTJKRC /dev/rvg02_20g_dat051 26,772 6 22.34 3.94 28 0 47 2.55
TBS_MARKET_NTJKRC /dev/rvg02_20g_dat052 25,914 6 31.17 4.10 17 0 41 1.46
TBS_MARKET_NTJKRC /dev/rvg02_20g_dat053 25,926 6 11.90 3.94 17 0 53 1.89
TBS_MARKET_NTJKRC /dev/rvg02_20g_dat054 27,339 6 20.48 3.86 19 0 54 1.85
TBS_MARKET_NTJKRC /dev/rvg02_20g_dat055 27,104 6 18.04 3.90 16 0 44 1.14
TBS_MARKET_NTJKRC /dev/rvg03_20g_dat004 6,029 1 11.77 5.61 42 0 0 0.00
TBS_MARKET_NTJKRC /dev/rvg03_20g_dat005 5,890 1 12.59 5.54 30 0 0 0.00
TBS_MARKET_NTJKRC /dev/rvg03_20g_dat006 7,562 2 9.47 4.23 38 0 0 0.00
TBS_MARKET_QTTJ /dev/rvg02_20g_dat041 3,530 1 11.04 7.57 114 0 37 168.65
TBS_MARKET_QTTJ /dev/rvg02_20g_dat042 3,471 1 4.04 7.64 104 0 25 4.80
TBS_MARKET_QTTJ /dev/rvg02_20g_dat043 3,392 1 5.44 7.80 129 0 30 5.33
TBS_MARKET_QTTJ /dev/rvg02_20g_dat044 3,883 1 6.64 6.95 97 0 28 2.14
TBS_MARKET_QTTJ /dev/rvg02_20g_dat045 5,594 1 5.02 5.05 103 0 28 34.29
TBS_MARKET_QTTJ /dev/rvg02_20g_dat046 6,376 1 12.50 4.34 152 0 41 4.63
TBS_MARKET_QTTJ /dev/rvg02_20g_dat047 5,124 1 9.87 5.17 138 0 24 7.50
TBS_MARKET_QTTJ /dev/rvg02_20g_dat048 5,795 1 4.57 4.69 126 0 27 8.89
TBS_MARKET_QTTJ /dev/rvg02_20g_dat049 5,746 1 3.76 5.02 117 0 62 131.13
TBS_MARKET_QTTJ /dev/rvg02_20g_dat050 4,079 1 3.92 6.49 111 0 33 6.06
TBS_MARKET_XDL /dev/rvg03_20g_dat001 32 0 29.69 1.00 10 0 0 0.00
TBS_MARKET_XDL /dev/rvg03_20g_dat002 32 0 76.56 1.00 10 0 0 0.00
TBS_MARKET_XDL /dev/rvg03_20g_dat003 32 0 25.63 1.00 10 0 0 0.00
TBS_MARKET_XDL /dev/rvg03_20g_dat012 35 0 12.86 1.00 11 0 0 0.00
TBS_MARKET_XDL /dev/rvg03_20g_dat013 35 0 16.57 1.00 11 0 0 0.00
TBS_MARKET_XDL /dev/rvg03_20g_dat014 35 0 12.86 1.00 11 0 0 0.00
TEMP /dev/rtemp01 113,846 26 24.25 14.02 59,076 13 0  
UNDOTBS1 /dev/rundotbs01 14 0 130.00 1.00 54,688 12 351 68.15
USERS /dev/rusers01 11 0 125.45 1.00 11 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 2,913,088 98 418,264,539 7,849,057 737,488 0 0 123,137


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 49 89333 2765578 2764800 2764800 6123706  
E 0 13 15519 170578 215067 2764800 215067  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 2,352 0.10 290,913 1.29 69,935,206,932
D 4,704 0.20 581,826 1.16 62,513,865,176
D 7,056 0.30 872,739 1.11 59,811,335,552
D 9,408 0.40 1,163,652 1.08 58,225,781,970
D 11,760 0.50 1,454,565 1.06 57,123,414,726
D 14,112 0.60 1,745,478 1.04 56,273,135,960
D 16,464 0.70 2,036,391 1.03 55,588,572,367
D 18,816 0.80 2,327,304 1.02 55,016,324,965
D 21,168 0.90 2,618,217 1.01 54,504,047,863
D 23,520 1.00 2,909,130 1.00 54,069,182,770
D 23,552 1.00 2,913,088 1.00 54,063,613,090
D 25,872 1.10 3,200,043 0.99 53,672,335,340
D 28,224 1.20 3,490,956 0.99 53,318,087,281
D 30,576 1.30 3,781,869 0.98 53,010,668,590
D 32,928 1.40 4,072,782 0.98 52,742,684,536
D 35,280 1.50 4,363,695 0.97 52,504,841,019
D 37,632 1.60 4,654,608 0.97 52,291,749,279
D 39,984 1.70 4,945,521 0.96 52,097,042,401
D 42,336 1.80 5,236,434 0.96 51,919,646,077
D 44,688 1.90 5,527,347 0.96 51,751,100,308
D 47,040 2.00 5,818,260 0.94 50,797,876,599

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
83.63 39,977 7,827

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 8,192 7,128 5,480.25 2,079.61 37.95 100.00 0.00 838,860
E 8,192 7,152 821.65 320.09 38.96 99.92 0.08 838,860

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 307,663 307,663 0 0
64K 128K 101 101 0 0
128K 256K 222 222 0 0
256K 512K 258 258 0 0
512K 1024K 7,016 7,016 0 0
1M 2M 4,008 4,008 0 0
2M 4M 84 84 0 0
4M 8M 272 272 0 0
8M 16M 167 165 2 0
16M 32M 22 20 2 0
32M 64M 37 31 6 0
64M 128M 28 23 5 0
128M 256M 9 7 2 0
256M 512M 1 1 0 0
2G 4G 8 6 2 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
1,024 0.13 96,679,601.09 18,310,159.39 84.00 247
2,048 0.25 96,679,601.09 16,330,635.08 86.00 86
4,096 0.50 96,679,601.09 16,323,314.58 86.00 86
6,144 0.75 96,679,601.09 16,323,100.13 86.00 85
8,192 1.00 96,679,601.09 8,031,106.12 92.00 85
9,830 1.20 96,679,601.09 7,125,237.97 93.00 85
11,469 1.40 96,679,601.09 7,125,237.97 93.00 85
13,107 1.60 96,679,601.09 7,125,204.40 93.00 0
14,746 1.80 96,679,601.09 7,125,038.71 93.00 0
16,384 2.00 96,679,601.09 7,125,038.71 93.00 0
24,576 3.00 96,679,601.09 7,125,038.71 93.00 0
32,768 4.00 96,679,601.09 7,125,038.71 93.00 0
49,152 6.00 96,679,601.09 7,125,038.71 93.00 0
65,536 8.00 96,679,601.09 7,125,038.71 93.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
1,792 0.29 689 83,872 1,024,976,000 1.00 13,917,497 1.55 1,820,617,878
2,416 0.39 1,303 114,086 1,027,351,423 1.00 11,542,074 1.29 1,840,628,977
3,040 0.49 1,923 156,468 1,028,185,901 1.00 10,707,596 1.19 1,842,396,348
3,664 0.59 2,544 198,360 1,029,044,301 1.00 9,849,196 1.10 1,843,419,710
4,288 0.70 3,167 232,232 1,029,458,398 1.00 9,435,099 1.05 1,844,200,166
4,912 0.80 3,790 285,217 1,029,646,363 1.00 9,247,134 1.03 1,844,797,621
5,536 0.90 4,413 346,208 1,029,811,514 1.00 9,081,983 1.01 1,845,267,649
6,160 1.00 5,036 387,507 1,029,912,581 1.00 8,980,916 1.00 1,845,605,786
6,784 1.10 5,659 426,728 1,030,004,148 1.00 8,889,349 0.99 1,845,987,078
7,408 1.20 6,282 461,249 1,030,090,769 1.00 8,802,728 0.98 1,846,235,492
8,032 1.30 6,905 492,081 1,030,162,152 1.00 8,731,345 0.97 1,846,514,181
8,656 1.41 7,528 528,183 1,030,207,030 1.00 8,686,467 0.97 1,846,772,572
9,280 1.51 8,151 570,097 1,030,249,707 1.00 8,643,790 0.96 1,846,989,162
9,904 1.61 8,774 608,858 1,030,329,767 1.00 8,563,730 0.95 1,847,193,677
10,528 1.71 9,397 643,677 1,030,369,475 1.00 8,524,022 0.95 1,847,384,590
11,152 1.81 10,020 692,584 1,030,396,476 1.00 8,497,021 0.95 1,847,565,545
11,776 1.91 10,643 729,754 1,030,444,551 1.00 8,448,946 0.94 1,847,740,943
12,400 2.01 11,266 759,329 1,030,472,041 1.00 8,421,456 0.94 1,847,915,155

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

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

Java Pool Size(M)JP 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
32 0.25 3 71 1 1.00 8,980,954 1.00 74
48 0.38 4 74 1 1.00 8,980,954 1.00 74
64 0.50 4 74 1 1.00 8,980,954 1.00 74
80 0.63 4 74 1 1.00 8,980,954 1.00 74
96 0.75 4 74 1 1.00 8,980,954 1.00 74
112 0.88 4 74 1 1.00 8,980,954 1.00 74
128 1.00 4 74 1 1.00 8,980,954 1.00 74
144 1.13 4 74 1 1.00 8,980,954 1.00 74
160 1.25 4 74 1 1.00 8,980,954 1.00 74
176 1.38 4 74 1 1.00 8,980,954 1.00 74
192 1.50 4 74 1 1.00 8,980,954 1.00 74
208 1.63 4 74 1 1.00 8,980,954 1.00 74
224 1.75 4 74 1 1.00 8,980,954 1.00 74
240 1.88 4 74 1 1.00 8,980,954 1.00 74
256 2.00 4 74 1 1.00 8,980,954 1.00 74
272 2.13 4 74 1 1.00 8,980,954 1.00 74

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 122,673 2,152 18
undo header 348 24 69
segment header 3 0 57
undo block 3 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
SQ-Sequence Cache 53 53 0 2 141 70,509.00
JD-Job Queue Date 1,500 1,500 0 1 8 7,907.00
RO-Multiple Object Reuse (fast object reuse) 621 621 0 67 2 25.15
CF-Controlfile Transaction 1,750 1,750 0 1 1 787.00
PS-PX Process Reservation 547 400 147 29 0 0.14
KO-Multiple Object Checkpoint (fast object checkpoint) 9 9 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 391.53 31,266 5,599 26 64.6/116.7 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
16-Sep 13:17 6,127 1,517 5,599 26 117 0/0 0/0/0/0/0/0
16-Sep 13:07 149 13 4,970 14 108 0/0 0/0/0/0/0/0
16-Sep 12:57 307 57 4,359 24 100 0/0 0/0/0/0/0/0
16-Sep 12:47 103 6 3,752 17 92 0/0 0/0/0/0/0/0
16-Sep 12:37 396 19 3,028 20 83 0/0 0/0/0/0/0/0
16-Sep 12:27 21,413 1,563 2,374 25 75 0/0 0/0/0/0/0/0
16-Sep 12:17 193,667 22,900 1,774 26 67 0/0 0/0/0/0/0/0
16-Sep 12:07 169,369 5,191 1,173 26 65 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,772 0.00   0 0  
AWR Alerted Metric Element list 30,839 0.00   0 0  
Consistent RBA 13,021 0.12 0.00 0 0  
FIB s.o chain latch 2 0.00   0 0  
FOB s.o list latch 2,416 0.25 0.00 0 0  
In memory undo latch 96,467 0.26 0.96 5 8,526 2.57
JS mem alloc latch 6 0.00   0 0  
JS queue access latch 6 0.00   0 0  
JS queue state obj latch 28,710 0.00   0 0  
JS slv state obj latch 14 0.00   0 0  
KMG MMAN ready and startup request latch 1,488 0.00   0 0  
KTF sga latch 5 0.00   0 1,299 0.00
KWQMN job cache list latch 6 0.00   0 0  
MQL Tracking Latch 0     0 76 0.00
Memory Management Latch 0     0 1,488 0.00
OS process 4,050 0.00   0 0  
OS process allocation 3,963 19.81 86.75 19864 0  
OS process: request allocation 2,612 16.69 380.90 48595 0  
PL/SQL warning settings 605,118 0.00   0 0  
SGA IO buffer pool latch 443,129 0.16 5.93 1174 451,926 0.30
SQL memory manager latch 14 0.00   0 1,175 0.00
SQL memory manager workarea list latch 1,714,043 0.00 0.00 0 0  
Shared B-Tree 92 0.00   0 0  
active checkpoint queue latch 41,026 5.47 0.00 0 0  
active service list 15,504 0.88 0.01 0 2,045 0.00
archive control 8 0.00   0 0  
begin backup scn array 14,553 0.01 0.00 0 0  
cache buffer handles 36,182 0.02 0.33 0 0  
cache buffers chains 889,302,651 0.03 0.03 714 19,820,974 0.00
cache buffers lru chain 2,002,216 0.76 0.31 1072 30,552,035 0.37
cache table scan latch 0     0 578,581 0.54
channel handle pool latch 2,672 3.71 10.51 294 0  
channel operations parent latch 20,357 0.04 0.00 0 0  
checkpoint queue latch 2,063,649 0.06 3.95 1340 608,823 0.02
client/application info 7,170 0.00   0 0  
commit callback allocation 224 0.00   0 0  
compile environment latch 2,562 0.00   0 0  
constraint object allocation 10 0.00   0 0  
dictionary lookup 73 0.00   0 0  
dml lock allocation 31,286 1.12 0.00 0 0  
dummy allocation 5,130 1.05 1.39 18 0  
enqueue hash chains 381,207 0.10 0.24 26 10,903 0.00
enqueues 252,364 0.19 0.00 0 0  
error message lists 231 6.06 0.00 0 0  
event group latch 1,312 0.00   0 0  
file cache latch 2,927 0.03 0.00 0 0  
global KZLD latch for mem in SGA 76 0.00   0 0  
global tx hash mapping 42,869 0.00 0.00 0 6 0.00
hash table column usage latch 481 0.00   0 108,356 0.00
hash table modification latch 101 0.00   0 0  
internal temp table object number allocation latc 3 0.00   0 0  
job workq parent latch 2 100.00 0.00 0 1,874 17.29
job_queue_processes free list latch 3 0.00   0 0  
job_queue_processes parameter latch 341 0.00   0 0  
kks stats 64,802 0.30 139.48 7931 0  
kokc descriptor allocation latch 120 0.00   0 0  
ksuosstats global area 166 0.00   0 0  
ktm global data 76 0.00   0 0  
kwqbsn:qsga 92 0.00   0 0  
lgwr LWN SCN 13,228 0.32 0.00 0 0  
library cache 18,969,395 0.05 178.95 525032 100,233 9.47
library cache load lock 1,214 0.00   0 4 0.00
library cache lock 6,782,723 0.02 0.24 97 465 0.00
library cache lock allocation 12,608 0.07 0.78 0 0  
library cache pin 8,983,585 0.01 0.00 0 0  
library cache pin allocation 4,357 0.00   0 0  
list of block allocation 44,478 0.35 0.29 12 0  
loader state object freelist 3,942 0.05 0.00 0 0  
longop free list parent 2,525 0.00   0 289 0.00
message pool operations parent latch 282 0.35 30.00 9 0  
messages 164,640 1.08 0.00 0 0  
mostly latch-free SCN 13,734 3.88 0.00 0 0  
multiblock read objects 1,521,873 0.11 0.00 0 0  
ncodef allocation latch 44 0.00   0 0  
object queue header heap 4,421 0.00   0 4,545 0.00
object queue header operation 19,010,896 0.03 0.24 227 0  
object stats modification 89 0.00   0 0  
parallel query alloc buffer 2,298 0.78 0.11 0 0  
parallel query stats 165 9.09 0.00 0 0  
parameter list 625 0.00   0 0  
parameter table allocation management 5,170 0.04 1.00 0 0  
post/wait queue 4,523 0.00   0 3,033 0.00
process allocation 2,631 9.01 488.47 1133 1,299 1.00
process group creation 2,612 0.88 0.00 0 0  
process queue 1,208 1.82 0.00 0 0  
process queue reference 162,572,775 1.17 0.00 0 15,831,122 9.56
qmn state object latch 2 0.00   0 0  
qmn task queue latch 369 0.00   0 0  
query server freelists 993 6.14 0.00 0 0  
query server process 10 0.00   0 16 0.00
redo allocation 74,728 1.71 0.59 193 19,644,607 0.07
redo copy 0     0 19,646,133 0.09
redo writing 89,665 2.03 0.03 16 0  
resmgr group change latch 1,409 0.00   0 0  
resmgr:active threads 5,115 0.00   0 0  
resmgr:actses change group 1,329 0.00   0 0  
resmgr:free threads list 5,114 11.93 84.33 14983 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 15,748,655 0.09 0.15 622 686 0.00
rules engine aggregate statistics 5 0.00   0 0  
rules engine rule set statistics 10 0.00   0 0  
sequence cache 9,034 8.66 0.00 0 0  
session allocation 439,999 0.73 160.70 150577 0  
session idle bit 540,457 0.00 0.00 0 6 0.00
session state list latch 5,377 1.58 0.04 0 0  
session switching 44 0.00   0 0  
session timer 660 0.00   0 0  
shared pool 4,890,508 0.28 47.70 185865 0  
shared pool simulator 7,777,792 0.00 7.63 585 0  
simulator hash latch 31,119,919 0.00 0.25 54 0  
simulator lru latch 738,084 0.52 0.22 231 28,297,282 0.65
slave class 5 0.00   0 0  
slave class create 27 22.22 536.17 941 0  
sort extent pool 7,064 0.03 32.00 18 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
threshold alerts latch 296 0.00   0 0  
trace latch 804 41.17 56.65 5473 0  
transaction allocation 2,641 0.08 0.00 0 0  
transaction branch allocation 35,430 0.02 0.00 0 0  
undo global data 2,042,895 0.00 0.00 0 0  
user lock 5,010 52.85 1126.13 875275 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
process queue reference 162,572,775 1,902,258 84 1,902,175 0 0 0
cache buffers chains 889,302,651 232,500 7,854 227,361 0 0 0
cache buffers lru chain 2,002,216 15,314 4,810 13,974 0 0 0
row cache objects 15,748,655 14,913 2,288 14,707 0 0 0
shared pool 4,890,508 13,452 641,721 2,129 0 0 0
library cache 18,969,395 10,014 1,792,039 6,515 0 0 0
object queue header operation 19,010,896 4,824 1,148 4,395 0 0 0
simulator lru latch 738,084 3,825 826 3,767 0 0 0
session allocation 439,999 3,201 514,407 1,152 0 0 0
user lock 5,010 2,648 2,982,003 218 0 0 0
active checkpoint queue latch 41,026 2,246 4 2,242 0 0 0
redo writing 89,665 1,820 61 1,811 0 0 0
multiblock read objects 1,521,873 1,606 3 1,603 0 0 0
library cache lock 6,782,723 1,462 345 1,441 0 0 0
redo allocation 74,728 1,278 753 1,150 0 0 0
checkpoint queue latch 2,063,649 1,173 4,636 1,066 0 0 0
simulator hash latch 31,119,919 903 229 846 0 0 0
OS process allocation 3,963 785 68,098 31 0 0 0
SGA IO buffer pool latch 443,129 692 4,105 526 0 0 0
resmgr:free threads list 5,114 610 51,440 47 0 0 0
OS process: request allocation 2,612 436 166,071 6 0 0 0
enqueue hash chains 381,207 375 89 372 0 0 0
trace latch 804 331 18,750 53 0 0 0
shared pool simulator 7,777,792 268 2,045 208 0 0 0
In memory undo latch 96,467 247 236 30 0 0 0
process allocation 2,631 237 115,767 3 0 0 0
kks stats 64,802 195 27,198 41 0 0 0
list of block allocation 44,478 154 44 152 0 0 0
active service list 15,504 136 2 134 0 0 0
channel handle pool latch 2,672 99 1,040 10 0 0 0
session state list latch 5,377 85 3 82 0 0 0
dummy allocation 5,130 54 75 38 0 0 0
parallel query alloc buffer 2,298 18 2 16 0 0 0
library cache lock allocation 12,608 9 7 2 0 0 0
cache buffer handles 36,182 6 2 4 0 0 0
slave class create 27 6 3,217 0 0 0 0
parameter table allocation management 5,170 2 2 0 0 0 0
sort extent pool 7,064 2 64 0 0 0 0
message pool operations parent latch 282 1 30 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch ktiFlush: child 0 197 60
In memory undo latch kticmt: child 0 54 174
In memory undo latch ktichg: child 0 1 0
OS process allocation kso_new_process:2 0 67,728 63,923
OS process allocation ksoreq_submit 0 246 189
OS process allocation kso_delete_process:1 0 79 1,069
OS process allocation ksosp_scrub:1 0 28 2,364
OS process allocation ksoreq_cancel:1 0 3 360
OS process allocation ksosp_forknew 0 3 0
OS process allocation kso_new_process:1 0 2 132
OS process: request allocation kso_new_process 0 166,058 164,293
OS process: request allocation ksoreqholder_delete 0 12 1,777
SGA IO buffer pool latch ksfd_free_sgabuffer 0 3,183 4,119
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 936 0
active checkpoint queue latch kcbbacq: scan active checkpoints 0 2 4
active checkpoint queue latch kcbo_add_ckpt: Add last obj ckpt 0 1 0
active checkpoint queue latch kcbo_add_ckpt: Add object ckpt 1 0 1 0
active service list ksws_event: ksws event 0 22 21
active service list kswsgsnp: get service name ptr 0 2 3
cache buffer handles kcbzfs 0 1 1
cache buffer handles kcbzgs 0 1 1
cache buffers chains kcbgtcr: kslbegin excl 0 11,778 12,491
cache buffers chains kcbrls: kslbegin 0 2,569 2,679
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 451 100
cache buffers chains kcbbxsv 0 266 68
cache buffers chains kcbbic1 0 168 12
cache buffers chains kcbzwb 0 87 66
cache buffers chains kcbgcur: kslbegin 0 52 11
cache buffers chains kcbzib: multi-block read: nowait 0 30 0
cache buffers chains kcbbic2 0 24 1
cache buffers chains kcbnew: new latch again 0 12 1
cache buffers chains kcbgtcr: fast path 0 9 1
cache buffers chains kcbzgb: scan from tail. nowait 0 9 0
cache buffers chains kcbnlc 0 1 4
cache buffers lru chain kcbzgws 0 4,133 0
cache buffers lru chain kcbbxsv: move to being written 0 363 3,346
cache buffers lru chain kcbzgb: posted for free bufs 0 186 894
cache buffers lru chain kcbzgm 0 70 0
cache buffers lru chain kcbzswcu 0 35 56
cache buffers lru chain kcbbic2 0 16 512
cache buffers lru chain kcbzar: KSLNBEGIN 0 8 0
cache buffers lru chain kcbo_link_q 0 2 0
cache buffers lru chain kcbbwlru 0 1 0
channel handle pool latch ksrchconnect() 0 1,041 1,041
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 3,999 0
checkpoint queue latch kcbkubc 0 326 1,505
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 250 0
checkpoint queue latch kcbswcu: Switch buffers 0 53 273
checkpoint queue latch kcbkllrba: compute lowest lrba 0 8 2,858
cost function kzulgt: find user res 0 2,312,591 2,107,321
cost function kzulrl 0 676,059 881,386
dummy allocation ktcscnfy 0 75 74
enqueue hash chains ksqgtl3 0 68 89
enqueue hash chains ksqrcl 0 21 0
event range base latch No latch 0 1 0
kks stats kks stats alloc/free 0 27,199 27,199
library cache kgldte: child 0 0 1,211,644 1,668,224
library cache kglScanDependency 0 439,303 171
library cache kgldti: 2child 0 96,538 6,526
library cache kglpndl: child: before processing 0 13,018 21,009
library cache kglobpn: child: 0 4,402 22,139
library cache kglhdgn: child: 0 2,577 38,090
library cache kglukp: child 0 1,641 6,496
library cache kglpin 0 1,465 3,347
library cache kglpndl: child: after processing 0 938 50
library cache kglpnp: child 0 717 4,052
library cache kglhdgc: child: 0 702 1,057
library cache kglLockCursor 0 526 5,109
library cache kglati 0 35 3
library cache kglhdiv0: parent: invalidate 0 11 7
library cache kglhdiv: child 0 7 1
library cache kglobld 0 7 457
library cache kglprg: child 0 5 2,254
library cache kgldtld: 2child 0 2 1
library cache kglic 0 1 220
library cache kglini: child 0 1 0
library cache kglpin: child: KGLMX 0 1 0
library cache lock kgllkdl: child: no lock handle 0 13,093 8,465
library cache lock kgllkdl: child: cleanup 0 331 63
library cache lock kgllkal: child: multiinstance 0 14 282
library cache lock allocation kgllkget 0 7 7
list of block allocation ktlabl 0 44 34
message pool operations parent latch ksrmalloc() 0 30 30
multiblock read objects kcbzib: normal mbr free 0 2 3
multiblock read objects kcbzib: mbr get 0 1 0
object queue header operation kcbw_unlink_q 0 613 231
object queue header operation kcbo_switch_cq 0 306 335
object queue header operation kcbo_switch_q_bg 0 112 78
object queue header operation kcbo_swap_buf 0 55 98
object queue header operation kcbo_switch_mq_bg 0 54 354
object queue header operation kcbo_write_q 0 7 0
object queue header operation kcbw_link_q 0 4 33
object queue header operation kcbw_unlink_q_bg 0 1 14
parallel query alloc buffer kxfpbfre 0 2 2
parameter table allocation management ksp_param_table_free 0 1 0
process allocation ksuapc 0 115,540 115,765
process allocation ksucrp 0 224 0
process queue reference kxfpqrsnd 0 83 0
process queue reference kxfprifdb1: KSLBEGIN 0 1 3
redo allocation kcrfw_redo_gen: redo allocation 1 0 734 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 10 68
redo allocation kcrfw_redo_write: more space 0 5 218
redo allocation kcrfw_redo_write: before write 0 3 467
redo allocation kcrfw_redo_gen: redo allocation 2 0 1 0
redo writing kcrfw_post: after write 0 52 0
redo writing kcrfw_post: rba scn pair 0 9 0
resmgr:free threads list kgskthrcreate 0 51,339 48,494
resmgr:free threads list kgskthrsod 0 101 2,946
row cache objects kqrpre: find obj 0 1,249 1,784
row cache objects kqrso 0 542 264
row cache objects kqreqd 0 366 179
row cache objects kqreqd: reget 0 131 59
session allocation ksucrp 0 507,773 237,554
session allocation ksuprc 0 3,653 2,424
session allocation ksuxds: KSUSFCLC not set 0 1,885 3,870
session allocation ksucri 0 830 245,452
session allocation ksudlp 0 202 3,082
session allocation ksuxds: not user session 0 67 17,857
session allocation ksudlc 0 16 3,545
session allocation ksursi 0 6 1
session allocation ksufap: active sessions 0 4 228
session allocation ksusroll 0 4 1
session allocation ksuxds: KSUSFCLC set 0 1 444
session state list latch kpseqd 0 3 0
shared pool kghalo 0 580,301 557,565
shared pool kghfrunp: alloc: wait 0 41,529 1,180
shared pool kghfre 0 9,965 48,738
shared pool kghupr1 0 7,172 21,161
shared pool kghfrunp: clatch: wait 0 4,408 5,094
shared pool kghfrunp: clatch: nowait 0 1,791 0
shared pool kghalp 0 1,488 12,288
shared pool kghfrh 0 1,247 75
shared pool kghasp 0 35 729
shared pool simulator kglsim_unpin_simhp 0 1,951 5
shared pool simulator kglsim_upd_newhp 0 68 265
shared pool simulator kglsim_unpin_simhp: fast path 0 12 1,036
shared pool simulator kglsim_chg_simhp_inval 0 7 0
shared pool simulator kglsim_scan_lru: scan 0 7 740
shared pool simulator kglsim_chg_simhp_free 0 1 0
simulator hash latch kcbs_lookup_setid: lookup dba 0 167 5
simulator hash latch kcbs_get_or_extract_simbufseq 0 29 0
simulator hash latch kcbsacc: lookup dba 0 29 224
simulator hash latch kcbsacc: insert dba 0 2 0
simulator hash latch kcbsacc: remove dba 0 2 0
simulator lru latch kcbs_simulate: simulate set 0 585 0
simulator lru latch kcbs_lookup_setid 0 214 0
simulator lru latch kcbs_simbufseq 0 27 826
slave class create ksvcreate 0 3,217 1,170
sort extent pool ktstdt: return extent 0 63 0
sort extent pool ktatobjstats 0 1 35
trace latch kstipg 0 18,756 18,756

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
NGRC TBS_MARKET_DEAL RY_G_21118_ZJUSER_TMP   TABLE 197,150,928 45.21
NGRC TBS_MARKET_DEAL OPERATOR_NT   TABLE 41,090,800 9.42
NGRC TBS_MARKET_DEAL RY_KPI_DATA_INFO   TABLE 27,536,640 6.31
NGRC TBS_MARKET_NG SUBS_PRODUCT20130915   TABLE 17,968,624 4.12
NGRC TBS_MARKET_DEAL RY_K_21070_XTYX_MBYH_MID   TABLE 13,725,968 3.15

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
NGRC TBS_MARKET_NG SUBS_PRODUCT20130915   TABLE 17,909,985 66.22
SCRC TBS_MARKET_NTJKRC RY_E_20029_USER_NEW_RPT   TABLE 333,772 1.23
NGRC TBS_MARKET_DEAL RY_K_21070_XTYX_MBYH_MID   TABLE 147,651 0.55
NGRC TBS_MARKET_DEAL RY_G_20609_ACTIVITY_AIM_MID   TABLE 53,111 0.20
SCRC TBS_MARKET_NTJKRC RY_H_20503_XRW_RPT   TABLE 50,399 0.19

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SYS SYSAUX WRH$_SERVICE_STAT_PK 5724_19191 INDEX PARTITION 2 50.00
SYS SYSAUX WRH$_SERVICE_WAIT_CLASS_PK 5724_19191 INDEX PARTITION 2 50.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYS SYSTEM JOB$   TABLE 261 77.45
YWFZ TBS_MARKET_QTTJ T_LOGHISTORY_INFO   TABLE 30 8.90
YWFZ TBS_MARKET_QTTJ T_PROD_SALE_CUSTOMER_IDX1   INDEX 19 5.64
QTTJ TBS_MARKET_QTTJ T_LOGHISTORY_INFO   TABLE 16 4.75
SYS SYSTEM I_JOB_NEXT   INDEX 10 2.97

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 33 0.00 0   2 1
dc_constraints 246 67.48 0   246 405
dc_database_links 6,808 0.00 0   0 43
dc_global_oids 3,012 0.03 0   0 85
dc_histogram_data 49,839 0.36 0   0 9,372
dc_histogram_defs 52,312 1.55 0   3 30,319
dc_object_grants 294 0.00 0   0 180
dc_object_ids 100,259 0.14 0   47 3,357
dc_objects 40,728 0.91 0   392 4,330
dc_profiles 1,238 0.00 0   0 2
dc_rollback_segments 2,218 0.00 0   0 154
dc_segments 88,893 0.11 0   2,323 8,024
dc_sequences 82 2.44 0   82 34
dc_table_scns 30 0.00 0   0 4
dc_tablespace_quotas 2,042 0.00 0   0 8
dc_tablespaces 1,248,042 0.00 0   0 12
dc_usernames 10,475 0.00 0   0 57
dc_users 3,678,563 0.00 0   0 86
global database name 10 0.00 0   0 1
outstanding_alerts 135 2.96 0   5 26


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 1,282 0.00 805,012 0.00 1 0
CLUSTER 14 0.00 16 0.00 0 0
INDEX 14 64.29 50 28.00 2 0
JAVA RESOURCE 3 33.33 4 25.00 0 0
JAVA SOURCE 3 33.33 4 25.00 0 0
SQL AREA 267,341 85.16 6,413,723 0.49 1,184 382
TABLE/PROCEDURE 214,411 0.07 2,127,009 0.04 263 0
TRIGGER 1,484 0.07 1,199,012 0.00 0 0


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 Freeable 2,931.50 0.00 18.44 80.30 600   159 159
  SQL 2,117.75 2,113.06 8.02 65.48 678 1,276 264 215
  Other 424.65   1.55 2.96 23 82 274 274
  PL/SQL 5.63 3.58 0.02 0.03 0 10 272 272
E Other 380.08   1.31 1.93 22 87 290 290
  SQL 330.43 325.91 1.18 7.66 73 6,045 279 229
  Freeable 102.25 0.00 0.73 0.58 6   141 141
  PL/SQL 6.43 4.11 0.02 0.03 0 10 287 287

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 24,696,061,952  
Fixed Size 2,143,032  
Redo Buffers 14,630,912  
Variable Size 7,499,418,824  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 122.23 122.23 0.00
java joxlod exec hp 5.58 5.58 0.00
large free memory 128.00 128.00 0.00
shared CCursor 706.79 685.98 -2.94
shared Cursor Stats 108.55 108.55 0.00
shared PCursor 666.96 627.54 -5.91
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 710.76 757.23 6.54
shared kglsim heap 127.90 127.90 0.00
shared kglsim object batch 204.61 204.61 0.00
shared library cache 390.80 374.88 -4.08
shared sql area 2,628.70 2,642.40 0.52
  buffer_cache 23,552.00 23,552.00 0.00
  fixed_sga 2.04 2.04 0.00
  log_buffer 13.95 13.95 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
processes 291 1,485 1500 1500
sessions 309 1,524 1655 1655


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_external_scn_logging_threshold_seconds 21600   
_external_scn_rejection_threshold_hours 480   
audit_file_dest /oracle/admin/orcl/adump   
background_dump_dest /oracle/admin/orcl/bdump   
compatible 10.2.0.3.0   
control_files /dev/rcontrol01, /dev/rcontrol02, /dev/rcontrol03   
core_dump_dest /oracle/admin/orcl/cdump   
db_block_size 8192   
db_cache_size 24696061952   
db_domain      
db_file_multiblock_read_count 16   
db_files 1000   
db_name orcl   
db_recovery_file_dest /oracle/flash_recovery_area   
db_recovery_file_dest_size 2147483648   
dispatchers (PROTOCOL=TCP) (SERVICE=orclXDB)   
java_pool_size 134217728   
job_queue_processes 20   
large_pool_size 134217728   
open_cursors 300   
open_links 10   
open_links_per_instance 10   
pga_aggregate_target 8589934592   
processes 1500   
remote_login_passwordfile EXCLUSIVE   
resource_limit TRUE   
sessions 1655   
sga_max_size 32212254720   
sga_target 0   
shared_pool_size 6442450944   
spfile /dev/rspfileorcl   
undo_management AUTO   
undo_retention 10800   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/admin/orcl/udump   


Back to Top

End of Report