WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
SFSNSRDB1163726650SFSNSRDB110.2.0.5.0NOSFSNSR01

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:145923-Jul-12 09:00:41113 .5
End Snap:146223-Jul-12 12:00:19114 .5
Elapsed:  179.62 (mins)  
DB Time:  2.44 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 17,312M 17,312MStd Block Size: 8K
Shared Pool Size: 3,072M 3,072MLog Buffer: 63,476K

Load Profile

Per SecondPer Transaction
Redo size: 7,514.56 19,245.56
Logical reads: 181.49 464.82
Block changes: 34.50 88.37
Physical reads: 0.09 0.24
Physical writes: 1.65 4.23
User calls: 34.86 89.29
Parses: 17.35 44.43
Hard parses: 2.83 7.26
Sorts: 1.05 2.69
Logons: 0.03 0.07
Executes: 17.80 45.58
Transactions: 0.39 

% Blocks changed per Read: 19.01Recursive Call %: 26.13
Rollback per transaction %: 4.97Rows per Sort: 78.62

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.95In-memory Sort %: 100.00
Library Hit %: 78.70Soft Parse %: 83.66
Execute to Parse %: 2.52Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 88.37% Non-Parse CPU: 73.75

Shared Pool Statistics

BeginEnd
Memory Usage %: 79.66 82.55
% SQL with executions>1: 96.97 77.56
% Memory for SQL w/exec>1: 94.83 80.20

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
imm op 225 204 909 139.7Other
Backup: sbtbackup 2 168 83,913 114.7Administrative
CPU time  146  100.1 
Backup: sbtclose2 2 20 9,922 13.6Administrative
io done 16,011 12 1 8.5System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU 146.42 100.07
sql execute elapsed time 72.39 49.48
parse time elapsed 43.61 29.81
hard parse elapsed time 32.83 22.44
failed parse elapsed time 0.79 0.54
connection management call elapsed time 0.68 0.47
PL/SQL execution elapsed time 0.28 0.19
RMAN cpu time (backup/restore) 0.20 0.14
PL/SQL compilation elapsed time 0.09 0.06
hard parse (sharing criteria) elapsed time 0.07 0.05
inbound PL/SQL rpc elapsed time 0.01 0.00
repeated bind elapsed time 0.00 0.00
DB time 146.31  
background elapsed time 468.29  
background cpu time 42.51  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
Other 278 72 206 740 140.59
Administrative 569   189 331 128.85
CPU time     146   100.07
System I/O 52,307 0 29 1 20.02
Commit 4,018   5 1 3.59
Concurrency 52 2 3 54 1.94
Network 242,521   1 0 0.83
User I/O 845   0 0 0.04
Application 430   0 0 0.02

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
imm op 225 88 204 909 0.05
Backup: sbtbackup 2   168 83913 0.00
Backup: sbtclose2 2   20 9922 0.00
io done 16,011 0 12 1 3.80
control file parallel write 3,820   7 2 0.91
log file parallel write 4,603   6 1 1.09
log file sync 4,018   5 1 0.95
os thread startup 49   3 57 0.01
log file sequential read 144   2 13 0.03
db file parallel write 10,484   2 0 2.49
slave exit 3 67 1 330 0.00
SQL*Net more data to client 33,847   1 0 8.04
Backup: sbtinfo2 2   1 254 0.00
control file sequential read 17,092   0 0 4.06
Log archive I/O 134   0 3 0.03
Backup: sbtwrite2 551   0 1 0.13
latch free 5   0 49 0.00
SQL*Net more data from client 11,850   0 0 2.82
control file single write 10   0 20 0.00
SQL*Net message to client 196,824   0 0 46.77
db file sequential read 806   0 0 0.19
switch logfile command 4   0 11 0.00
SGA: allocation forcing component growth 2 50 0 17 0.00
SQL*Net break/reset to client 430   0 0 0.10
cursor: pin S wait on X 1 100 0 19 0.00
Backup: sbtinit 2   0 5 0.00
log file single write 4   0 2 0.00
db file scattered read 31   0 0 0.01
latch: shared pool 2   0 4 0.00
db file single write 8   0 0 0.00
RMAN backup & recovery I/O 5   0 1 0.00
LGWR wait for redo copy 39   0 0 0.01
enq: CF - contention 2   0 0 0.00
Backup: sbtend 2   0 0 0.00
Backup: sbtcommand 2   0 0 0.00
cursor: pin S 2   0 0 0.00
Backup: sbtinit2 2   0 0 0.00
i/o slave wait 442,155 50 231,801 524 105.07
SQL*Net message from client 197,030   145,517 739 46.82
Streams AQ: qmn slave idle wait 372   10,514 28262 0.09
Streams AQ: qmn coordinator idle wait 907 59 10,513 11591 0.22
virtual circuit status 360 100 10,507 29187 0.09
Streams AQ: waiting for time management or cleanup tasks 3 100 7,542 2513940 0.00
jobq slave wait 120 100 353 2939 0.03
class slave wait 24   0 1 0.01

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
io done 15,750   12 1 3.74
control file parallel write 3,741   7 2 0.89
log file parallel write 4,603   6 1 1.09
os thread startup 30   2 77 0.01
db file parallel write 10,484   2 0 2.49
control file sequential read 8,195   0 0 1.95
log file single write 4   0 2 0.00
db file single write 8   0 0 0.00
events in waitclass Other 42   0 0 0.01
db file sequential read 8   0 0 0.00
log file sequential read 8   0 0 0.00
i/o slave wait 440,967 50 231,496 525 104.79
rdbms ipc message 38,709 89 113,224 2925 9.20
pmon timer 3,592 100 10,517 2928 0.85
Streams AQ: qmn slave idle wait 372   10,514 28262 0.09
Streams AQ: qmn coordinator idle wait 907 59 10,513 11591 0.22
smon timer 35 100 10,073 287805 0.01
Streams AQ: waiting for time management or cleanup tasks 3 100 7,542 2513940 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 4,680
AVG_IDLE_TIME 1,072,278
AVG_IOWAIT_TIME 1,459
AVG_SYS_TIME 3,302
AVG_USER_TIME 1,038
BUSY_TIME 402,917
IDLE_TIME 85,811,367
IOWAIT_TIME 143,711
SYS_TIME 292,535
USER_TIME 110,382
LOAD 0
OS_CPU_WAIT_TIME 8,207,300,500
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 351,895,520
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES 1.7E+11
NUM_CPUS 80
NUM_CPU_SOCKETS 80

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SFSNSRDB 94.90 96.10 772 1,827,810
SYS$USERS 51.50 50.30 217 89,985
SFSNSRDBXDB 0.00 0.00 0 0
SYS$BACKGROUND 0.00 0.00 0 38,290

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
SFSNSRDB 588 0 3 0 0 0 233896 1
SYS$USERS 217 0 19 0 4 0 7962 0
SYS$BACKGROUND 40 0 30 2 565 188 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
7 7 6 1.09 4.46 c7yrqkffcmvxv SQL*Plus select 'DATAPOINT redo_copy_ge...
7 6 6 1.08 4.45 5a04f8xcw52dt SQL*Plus select 'DATAPOINT redo_allocat...
6 6 6 1.08 4.44 d0n9k00unpy6v SQL*Plus select 'DATAPOINT redo_allocat...
6 6 6 1.08 4.43 8npuvpzyutpy7 SQL*Plus select 'DATAPOINT sga_latch_ge...
6 6 6 1.08 4.43 243qg0fzu4q0g SQL*Plus select 'DATAPOINT sga_latch_mi...
6 6 6 1.08 4.42 86nbcz0tya1fp SQL*Plus select 'DATAPOINT redo_copy_mi...
4 4 3 1.47 3.02 84qubbrsr0kfn   insert into wrh$_latch (snap_i...
4 4 3 1.47 3.00 bunssq950snhf   insert into wrh$_sga_target_ad...
3 3 4,127 0.00 1.77 gsdjff9jckg3y documentum@SFSNSR01 (TNS V1-V3) select a.r_object_id from dmi_...
2 2 6 0.31 1.26 5va5scm0mug74 documentum@SFSNSR01 (TNS V1-V3) select a.type_name, a.attr_nam...
2 2 4,067 0.00 1.18 gpuq908z67vnd documentum@SFSNSR01 (TNS V1-V3) INSERT INTO imagesys.DM_SYSOBJ...
2 1 9,477 0.00 1.16 bzr24dsp3ypk2 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM CMBC_IMAGE_METAD...
2 0 2 0.83 1.14 86ds8fsfpxp3j rman@SFSNSR01 (TNS V1-V3) begin sys . dbms_backup_restor...

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
7 7 6 1.08 4.44 4.46 c7yrqkffcmvxv SQL*Plus select 'DATAPOINT redo_copy_ge...
6 6 6 1.08 4.41 4.44 d0n9k00unpy6v SQL*Plus select 'DATAPOINT redo_allocat...
6 7 6 1.08 4.41 4.45 5a04f8xcw52dt SQL*Plus select 'DATAPOINT redo_allocat...
6 6 6 1.07 4.38 4.43 243qg0fzu4q0g SQL*Plus select 'DATAPOINT sga_latch_mi...
6 6 6 1.07 4.38 4.42 86nbcz0tya1fp SQL*Plus select 'DATAPOINT redo_copy_mi...
6 6 6 1.07 4.38 4.43 8npuvpzyutpy7 SQL*Plus select 'DATAPOINT sga_latch_ge...
4 4 3 1.49 3.06 3.00 bunssq950snhf   insert into wrh$_sga_target_ad...
4 4 3 1.48 3.03 3.02 84qubbrsr0kfn   insert into wrh$_latch (snap_i...
3 3 4,127 0.00 1.71 1.77 gsdjff9jckg3y documentum@SFSNSR01 (TNS V1-V3) select a.r_object_id from dmi_...
2 2 6 0.31 1.27 1.26 5va5scm0mug74 documentum@SFSNSR01 (TNS V1-V3) select a.type_name, a.attr_nam...
2 2 4,067 0.00 1.09 1.18 gpuq908z67vnd documentum@SFSNSR01 (TNS V1-V3) INSERT INTO imagesys.DM_SYSOBJ...

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
433,854 6 72,309.00 22.18 1.86 1.84 5va5scm0mug74 documentum@SFSNSR01 (TNS V1-V3) select a.type_name, a.attr_nam...
193,969 4,127 47.00 9.92 2.51 2.59 gsdjff9jckg3y documentum@SFSNSR01 (TNS V1-V3) select a.r_object_id from dmi_...
113,951 9,477 12.02 5.83 1.07 1.70 bzr24dsp3ypk2 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM CMBC_IMAGE_METAD...
70,634 4,067 17.37 3.61 1.60 1.72 gpuq908z67vnd documentum@SFSNSR01 (TNS V1-V3) INSERT INTO imagesys.DM_SYSOBJ...
66,473 16,618 4.00 3.40 1.02 1.03 2kg6yxyx1myu4 documentum@SFSNSR01 (TNS V1-V3) select r_object_type, i_vstamp...
65,976 32,988 2.00 3.37 1.09 1.28 agmz1qj12d0v1 documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.R_OBJECT_...
55,733 11,146 5.00 2.85 0.99 0.95 d5zvak9ah5z4z documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_ACL_RV dm_dba...
42,708 10,677 4.00 2.18 0.68 0.69 6hbzst7gfnzw1 documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.R_OBJECT_...
36,657 4,073 9.00 1.87 0.71 0.85 bgamdkp40bbp7 documentum@SFSNSR01 (TNS V1-V3) select all dm_folder.r_object_...
34,920 36 970.00 1.79 0.26 0.38 5d2tffwu9wuf9 SQL*Plus select owner||'|'||index_name|...
22,292 11,146 2.00 1.14 0.53 0.58 86s5qzz23mw7k documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.R_OBJECT_...
21,060 36 585.00 1.08 1.12 0.95 2anpc942uq2g5 SQL*Plus select owner||'|'||object_name...

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
599 1,000 0.60 60.51 0.20 0.22 grwydz59pu6mc   select text from view$ where r...
36 6 6.00 3.64 0.11 0.09 0kzfy7f1jtzak SQL*Plus select /*NORULE */ 'DATA:'||A....
36 6 6.00 3.64 0.18 0.19 8tgrhvcdw4kfm SQL*Plus select /*NORULE */ 'DATA:'||A....
36 6 6.00 3.64 0.03 0.07 a12b5292h48vq SQL*Plus select /*NORULE */ 'DATAPOINT ...
36 6 6.00 3.64 0.21 0.21 d4r4wjv6rswnn SQL*Plus select 'DATAPOINT( ' bpb, a.ta...
22 1,869 0.01 2.22 0.19 0.25 2uz0a9jnq7p3c documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DMR_CONTENT_RV d...
17 9,477 0.00 1.72 1.07 1.70 bzr24dsp3ypk2 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM CMBC_IMAGE_METAD...
13 4,067 0.00 1.31 1.60 1.72 gpuq908z67vnd documentum@SFSNSR01 (TNS V1-V3) INSERT INTO imagesys.DM_SYSOBJ...
8 6 1.33 0.81 0.49 0.50 8xp8rujc75tsm documentum@SFSNSR01 (TNS V1-V3) select all dm_document.r_objec...
2 6,174 0.00 0.20 0.33 0.28 12nfgxcd41rwj documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.I_TYPE FR...

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
32,988 32,988 1.00 0.00 0.00 agmz1qj12d0v1 documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.R_OBJECT_...
16,618 16,618 1.00 0.00 0.00 2kg6yxyx1myu4 documentum@SFSNSR01 (TNS V1-V3) select r_object_type, i_vstamp...
11,830 7,688 0.65 0.00 0.00 6nvxnk9rtsh39 documentum@SFSNSR01 (TNS V1-V3) select s.is_dynamic, s.group_c...
11,146 11,146 1.00 0.00 0.00 86s5qzz23mw7k documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.R_OBJECT_...
11,146 33,384 3.00 0.00 0.00 d5zvak9ah5z4z documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_ACL_RV dm_dba...
10,677 10,668 1.00 0.00 0.00 6hbzst7gfnzw1 documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.R_OBJECT_...
9,477 18,954 2.00 0.00 0.00 bzr24dsp3ypk2 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM CMBC_IMAGE_METAD...
6,174 6,174 1.00 0.00 0.00 12nfgxcd41rwj documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.I_TYPE FR...
4,142 0 0.00 0.00 0.00 0j4na4z6judmg documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.R_OBJECT_...
4,127 4,127 1.00 0.00 0.00 gsdjff9jckg3y documentum@SFSNSR01 (TNS V1-V3) select a.r_object_id from dmi_...
4,073 4,073 1.00 0.00 0.00 bgamdkp40bbp7 documentum@SFSNSR01 (TNS V1-V3) select all dm_folder.r_object_...
4,067 8,134 2.00 0.00 0.00 gpuq908z67vnd documentum@SFSNSR01 (TNS V1-V3) INSERT INTO imagesys.DM_SYSOBJ...
3,974 3,974 1.00 0.00 0.00 4rnugm1tgb6d6 documentum@SFSNSR01 (TNS V1-V3) select r_link_cnt from dm_syso...
2,277 2,277 1.00 0.00 0.00 9babjv8yq8ru3 SQL*Plus BEGIN DBMS_OUTPUT.GET_LINES(:L...
2,155 2,155 1.00 0.00 0.00 0a024djafzbx7 documentum@SFSNSR01 (TNS V1-V3) UPDATE imagesys.DM_SYSOBJECT_S...
2,155 0 0.00 0.00 0.00 btqx5836c7w30 documentum@SFSNSR01 (TNS V1-V3) select r_object_id, r_workflow...
2,155 0 0.00 0.00 0.00 c6u1g74vugzxz documentum@SFSNSR01 (TNS V1-V3) UPDATE /*+ USE_NL(dmi_workitem...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
32,988 32,988 17.64 agmz1qj12d0v1 documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.R_OBJECT_...
16,618 16,618 8.89 2kg6yxyx1myu4 documentum@SFSNSR01 (TNS V1-V3) select r_object_type, i_vstamp...
11,830 11,830 6.33 6nvxnk9rtsh39 documentum@SFSNSR01 (TNS V1-V3) select s.is_dynamic, s.group_c...
11,146 11,146 5.96 86s5qzz23mw7k documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.R_OBJECT_...
11,146 11,146 5.96 d5zvak9ah5z4z documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_ACL_RV dm_dba...
10,677 10,677 5.71 6hbzst7gfnzw1 documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.R_OBJECT_...
9,477 9,477 5.07 bzr24dsp3ypk2 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM CMBC_IMAGE_METAD...
6,174 6,174 3.30 12nfgxcd41rwj documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.I_TYPE FR...
4,142 4,142 2.22 0j4na4z6judmg documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.R_OBJECT_...
4,127 4,127 2.21 gsdjff9jckg3y documentum@SFSNSR01 (TNS V1-V3) select a.r_object_id from dmi_...
4,073 4,073 2.18 bgamdkp40bbp7 documentum@SFSNSR01 (TNS V1-V3) select all dm_folder.r_object_...
4,067 4,067 2.18 gpuq908z67vnd documentum@SFSNSR01 (TNS V1-V3) INSERT INTO imagesys.DM_SYSOBJ...
3,974 3,974 2.13 4rnugm1tgb6d6 documentum@SFSNSR01 (TNS V1-V3) select r_link_cnt from dm_syso...
2,277 2,277 1.22 9babjv8yq8ru3 SQL*Plus BEGIN DBMS_OUTPUT.GET_LINES(:L...
2,155 2,155 1.15 0a024djafzbx7 documentum@SFSNSR01 (TNS V1-V3) UPDATE imagesys.DM_SYSOBJECT_S...
2,155 2,155 1.15 btqx5836c7w30 documentum@SFSNSR01 (TNS V1-V3) select r_object_id, r_workflow...
2,155 2,155 1.15 c6u1g74vugzxz documentum@SFSNSR01 (TNS V1-V3) UPDATE /*+ USE_NL(dmi_workitem...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
4,409,488 36 0.14 8h98pqa1s2hvf documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_JOB_RV dm_dba...
4,162,118 9 0.13 cdjqrz2j2hw87 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_DOCBASE_CONFI...
3,610,494 6 0.11 4wsgbqzy6kwtp documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_ACS_CONFIG_RV...
3,540,880 6 0.11 10xj8nynmpqtq   SELECT dbin.db_name, dbin.inst...
3,509,118 3 0.11 6skskvty9hvf9 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_REGISTERED_RV...
3,472,630 9 0.11 68rabpntu68a5 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_METHOD_RV dm_...
3,334,692 18 0.10 1zc8g9758krs6 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_CLIENT_RIGHTS...
3,334,680 45 0.10 gyr0zxqh8dsg3 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_CABINET_RV dm...
3,196,774 54 0.10 96f0wx3bbs7pq documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_FOLDER_RV dm_...
3,058,902 18 0.09 dprg7r21712pz documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_PUBLIC_KEY_CE...
3,058,898 6 0.09 cg1r9tkms1zfp documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_CONT_TRANSFER...
2,920,994 18 0.09 fjxhdgrg0tgrg documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_DOCUMENT_RV d...
2,783,116 148 0.09 aqxqv86gv23dt documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_SYSOBJECT_RV ...
2,462,116 3 0.08 akh9zqqkx3wj7   select 1, max(id) from sys.wri...
2,362,457 3 0.07 31a13pnjps7j3   SELECT source, (case when time...
2,065,563 3 0.06 76natvnhtqqhw   INSERT INTO SYS.WRI$_ADV_TASKS...
1,927,056 3 0.06 79uvsz1g1c168   insert into wrh$_buffer_pool_s...
1,810,948 40 0.06 9pudktzqq9ywb   select a.obj# OBJOID, a.class_...
1,768,356 25 0.05 34jb3jdzvw8d2 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_FILESTORE_RV ...
1,719,057 6 0.05 8s6gxj2w0byd1 documentum@SFSNSR01 (TNS V1-V3) select * from dm_resync_dd_typ...
1,452,785 3 0.05 37m1fvjg52hqm   insert into wrh$_undostat (beg...
1,452,091 3 0.05 f318xdxdn0pdc   insert into wrh$_log (snap_id,...
1,335,783 3 0.04 bqnn4c3gjtmgu   insert into wrh$_bg_event_summ...
1,335,415 6 0.04 d4r4wjv6rswnn SQL*Plus select 'DATAPOINT( ' bpb, a.ta...
1,295,103 6 0.04 a12b5292h48vq SQL*Plus select /*NORULE */ 'DATAPOINT ...
1,293,670 79 0.04 a9vpk93gt1btv documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_STORE_S dm_db...
1,179,584 3 0.04 gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...
1,179,580 3 0.04 298ppdduqr7wm   SELECT status FROM sys.wri$_ad...
1,135,984 3 0.04 4rcrxkvaqt37f   insert into wrh$_shared_pool_a...
1,115,107 6 0.03 4pxua9j5qfw8b SQL*Plus select 'DATAPOINT', nvl(min(nv...
1,109,559 6 0.03 8tgrhvcdw4kfm SQL*Plus select /*NORULE */ 'DATA:'||A....
1,101,862 6 0.03 5va5scm0mug74 documentum@SFSNSR01 (TNS V1-V3) select a.type_name, a.attr_nam...
1,085,223 6 0.03 8tgrhvcdw4kfm SQL*Plus select /*NORULE */ 'DATA:'||A....
1,085,013 6 0.03 0kzfy7f1jtzak SQL*Plus select /*NORULE */ 'DATA:'||A....
1,084,989 6 0.03 0kzfy7f1jtzak SQL*Plus select /*NORULE */ 'DATA:'||A....
1,081,493 3 0.03 14566d856s6hs   SELECT owner# FROM sys.wri$_ad...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
78 6 10xj8nynmpqtq   SELECT dbin.db_name, dbin.inst...
72 3 14566d856s6hs   SELECT owner# FROM sys.wri$_ad...
72 3 14566d856s6hs   SELECT owner# FROM sys.wri$_ad...
72 3 298ppdduqr7wm   SELECT status FROM sys.wri$_ad...
72 3 gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...
71 3 76natvnhtqqhw   INSERT INTO SYS.WRI$_ADV_TASKS...
66 3 akh9zqqkx3wj7   select 1, max(id) from sys.wri...
41 6 gyg5wucwun752 documentum@SFSNSR01 (TNS V1-V3) UPDATE imagesys.DM_JOB_S dm_db...
40 36 8h98pqa1s2hvf documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_JOB_RV dm_dba...
39 6 03wqjzz2tj5v4 SQL*Plus insert into P$AUTOEXTENDEDLINK...
39 7 05kt7p1yzufvs SQL*Plus delete from P$AUTOEXTENDEDLINK...
39 6 2g9qjuvr2hju9 DBMS_SCHEDULER update sys.scheduler$_job set ...
39 3 2xn8yx0uz75fm   SELECT S.SNAP_ID, S.BEGIN_INTE...
39 25 34jb3jdzvw8d2 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_FILESTORE_RV ...
39 450 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
39 3 37m1fvjg52hqm   insert into wrh$_undostat (beg...
39 3 4rcrxkvaqt37f   insert into wrh$_shared_pool_a...
39 3 79uvsz1g1c168   insert into wrh$_buffer_pool_s...
39 40 9pudktzqq9ywb   select a.obj# OBJOID, a.class_...
39 3 9rfkm1bf915a0   UPDATE WRH$_SEG_STAT_OBJ SET s...
39 12 9uwr8b5y49gda SQL*Plus select 'DATA ' bpb, link from ...
39 79 a9vpk93gt1btv documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_STORE_S dm_db...
39 3 bqnn4c3gjtmgu   insert into wrh$_bg_event_summ...
39 12 czunzy04xj2vw SQL*Plus select 'DATA ' bpb, link from ...
39 3 f318xdxdn0pdc   insert into wrh$_log (snap_id,...
39 6 f6y537gy0p982   update sys.scheduler$_job set ...
39 3 g6wf9na8zs5hb   insert into wrh$_sysmetric_sum...
34 2,155 0a024djafzbx7 documentum@SFSNSR01 (TNS V1-V3) UPDATE imagesys.DM_SYSOBJECT_S...
34 18 1zc8g9758krs6 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_CLIENT_RIGHTS...
34 6 4wsgbqzy6kwtp documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_ACS_CONFIG_RV...
34 9 68rabpntu68a5 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_METHOD_RV dm_...
34 10,677 6hbzst7gfnzw1 documentum@SFSNSR01 (TNS V1-V3) SELECT dm_dbalias_B.R_OBJECT_...
34 3 6skskvty9hvf9 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_REGISTERED_RV...
34 6 8s6gxj2w0byd1 documentum@SFSNSR01 (TNS V1-V3) select * from dm_resync_dd_typ...
34 6 8s6gxj2w0byd1 documentum@SFSNSR01 (TNS V1-V3) select * from dm_resync_dd_typ...
34 6 8s6gxj2w0byd1 documentum@SFSNSR01 (TNS V1-V3) select * from dm_resync_dd_typ...
34 6 8xp8rujc75tsm documentum@SFSNSR01 (TNS V1-V3) select all dm_document.r_objec...
34 6 8xp8rujc75tsm documentum@SFSNSR01 (TNS V1-V3) select all dm_document.r_objec...
34 6 8xp8rujc75tsm documentum@SFSNSR01 (TNS V1-V3) select all dm_document.r_objec...
34 6 8xp8rujc75tsm documentum@SFSNSR01 (TNS V1-V3) select all dm_document.r_objec...
34 6 8xp8rujc75tsm documentum@SFSNSR01 (TNS V1-V3) select all dm_document.r_objec...
34 6 8xp8rujc75tsm documentum@SFSNSR01 (TNS V1-V3) select all dm_document.r_objec...
34 6 8xp8rujc75tsm documentum@SFSNSR01 (TNS V1-V3) select all dm_document.r_objec...
34 6 8xp8rujc75tsm documentum@SFSNSR01 (TNS V1-V3) select all dm_document.r_objec...
34 54 96f0wx3bbs7pq documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_FOLDER_RV dm_...
34 148 aqxqv86gv23dt documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_SYSOBJECT_RV ...
34 9 cdjqrz2j2hw87 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_DOCBASE_CONFI...
34 6 cg1r9tkms1zfp documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_CONT_TRANSFER...
34 18 dprg7r21712pz documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_PUBLIC_KEY_CE...
34 18 fjxhdgrg0tgrg documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_DOCUMENT_RV d...
34 45 gyr0zxqh8dsg3 documentum@SFSNSR01 (TNS V1-V3) SELECT * FROM DM_CABINET_RV dm...
32 385 c0m0j9uy53fpz documentum@SFSNSR01 (TNS V1-V3) select all cmbc_typever_metada...
26 3 31a13pnjps7j3   SELECT source, (case when time...
24 3 0v3dvmc22qnam   insert into sys.col_usage$ (ob...
24 450 g00cj285jmgsw   update sys.mon_mods$ set inser...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
03wqjzz2tj5v4insert into P$AUTOEXTENDEDLINKS values('dest', '/oracle/product/admin/SFSNSRDB/cdump', '/oracle')
05kt7p1yzufvsdelete from P$AUTOEXTENDEDLINKS where type = 'dest'
0a024djafzbx7UPDATE imagesys.DM_SYSOBJECT_S dm_dbalias_B SET I_VSTAMP = 0 WHERE (dm_dbalias_B.R_OBJECT_ID=:handle AND dm_dbalias_B.I_VSTAMP=:version)
0j4na4z6judmg SELECT dm_dbalias_B.R_OBJECT_ID FROM imagesys.DM_GROUP_S dm_dbalias_B WHERE dm_dbalias_B.GROUP_NAME=:valp
0kzfy7f1jtzak select /*NORULE */ 'DATA:'||A.FILE#||':'||A.BLOCK#||':' || A.MAX_EXT_SIZE||':'||B.MAX_BLOCKS_FREE||':'||A.TS#||':' NOHEAD from (SELECT /*NORULE */ TS#, FILE#, BLOCK#, MAX(EXTSIZE) MAX_EXT_SIZE FROM SYS.SEG$ where TYPE# !=9 GROUP BY TS#, FILE#, BLOCK#) A, (SELECT /*NORULE */ VB.NAME TABLESPACE_NAME, VB.TS#, MAX(nvl(VA.BLOCKS, 0)) MAX_BLOCKS_FREE FROM DBA_FREE_SPACE VA, SYS.TS$ VB WHERE VB.NAME = VA.TABLESPACE_NAME (+) AND VB.ONLINE$ != 3 GROUP BY VB.NAME, VB.TS#) B, (SELECT TS#, FILE#, BLOCK# FROM P$OBJ_EXCLUSION WHERE TS# IS NOT NULL AND FILE# IS NULL AND BLOCK# IS NULL) C, (SELECT TS#, FILE#, BLOCK# FROM P$OBJ_EXCLUSION WHERE TS# IS NOT NULL AND FILE# IS NOT NULL AND BLOCK# IS NOT NULL) S, (SELECT /*NORULE */ UA.TS# TS#, UA.FILE# FILE#, UA.BLOCK# BLOCK# FROM SYS.SEG$ UA, P$OBJ_EXCLUSION UB WHERE UB.USER# IS NOT NULL AND UA.USER# = UB.USER#) U, ( SELECT /*NORULE */ TABLESPACE_NAME FROM DBA_TABLESPACES WHERE STATUS = 'ONLINE' AND CONTENTS = 'PERMANENT' AND (EXTENT_MANAGEMENT = 'LOCAL' AND ALLOCATION_TYPE IN ('UNIFORM', 'USER') OR EXTENT_MANAGEMENT = 'DICTIONARY') ) E WHERE A.TS# = B.TS# AND A.MAX_EXT_SIZE > B.MAX_BLOCKS_FREE AND B.MAX_BLOCKS_FREE > 0 AND A.TS# = C.TS#(+) AND C.TS# IS NULL AND A.TS# = S.TS# (+) AND A.FILE# = S.FILE# (+) AND A.BLOCK# = S.BLOCK# (+) AND S.TS# IS NULL AND S.FILE# IS NULL AND S.BLOCK# IS NULL AND A.TS# = U.TS# (+) AND A.FILE# = U.FILE# (+) AND A.BLOCK# = U.BLOCK# (+) AND U.TS# IS NULL AND U.FILE# IS NULL AND U.BLOCK# IS NULL AND B.TABLESPACE_NAME = E.TABLESPACE_NAME
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)
10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
12nfgxcd41rwj SELECT dm_dbalias_B.I_TYPE FROM imagesys.DMI_OBJECT_TYPE dm_dbalias_B WHERE dm_dbalias_B.R_OBJECT_ID=:handle
14566d856s6hsSELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
1zc8g9758krs6SELECT * FROM DM_CLIENT_RIGHTS_RV dm_dbalias_B , DM_CLIENT_RIGHTS_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
243qg0fzu4q0gselect 'DATAPOINT sga_latch_misses' bpb, nvl(sum(MISSES), 0) from V$LATCH
298ppdduqr7wmSELECT status FROM sys.wri$_adv_tasks WHERE id = :1
2anpc942uq2g5select owner||'|'||object_name||'|'||object_type||'|'||status from dba_objects where status='INVALID'
2g9qjuvr2hju9update sys.scheduler$_job set next_run_date = :1, run_count = :2, retry_count = :3, running_instance = :4, running_slave = :5, job_status = :6, last_end_date = :7 where obj# = :8
2kg6yxyx1myu4select r_object_type, i_vstamp, i_antecedent_id, i_branch_cnt, i_direct_dsc, r_immutable_flag, r_has_events, i_cabinet_id, r_link_cnt, r_frzn_assembly_cnt, r_access_date, i_latest_flag from dm_sysobject_s where r_object_id = :ID
2uz0a9jnq7p3cSELECT * FROM DMR_CONTENT_RV dm_dbalias_B , DMR_CONTENT_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
2xn8yx0uz75fmSELECT S.SNAP_ID, S.BEGIN_INTERVAL, S.END_INTERVAL FROM (SELECT SS.SNAP_ID, CAST(SS.BEGIN_INTERVAL_TIME AS DATE) AS BEGIN_INTERVAL, CAST(SS.END_INTERVAL_TIME AS DATE) AS END_INTERVAL FROM WRM$_SNAPSHOT SS WHERE SS.DBID = :B3 AND SS.INSTANCE_NUMBER = :B2 AND SS.SNAP_ID <= :B1 ORDER BY SS.DBID, SS.INSTANCE_NUMBER, SS.SNAP_ID DESC) S WHERE ROWNUM <= 2
31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
34jb3jdzvw8d2SELECT * FROM DM_FILESTORE_RV dm_dbalias_B , DM_FILESTORE_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
37m1fvjg52hqminsert into wrh$_undostat (begin_time, end_time, dbid, instance_number, snap_id, undotsn, undoblks, txncount, maxquerylen, maxquerysqlid, maxconcurrency, unxpstealcnt, unxpblkrelcnt, unxpblkreucnt, expstealcnt, expblkrelcnt, expblkreucnt, ssolderrcnt, nospaceerrcnt, activeblks, unexpiredblks, expiredblks, tuned_undoretention, status, spcprs_retention, runawayquerysqlid) select to_date(ktusmstrbegtime, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), to_date(ktusmstrendtime, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), max(:dbid), max(:instance_number), max(:snap_id), max(KTUSMSTTSN), sum(KTUSMSTUSU), sum(KTUSMSTTCT), max(KTUSMSTMQL), max(KTUSMSTRMQI), max(KTUSMSTMTC), sum(KTUSMSTUAC), sum(KTUSMSTUBS), sum(KTUSMSTUBR), sum(KTUSMSTXAC), sum(KTUSMSTXBS), sum(KTUSMSTXBR), sum(KTUSMSTSOC), sum(KTUSMSTOOS), max(KTUSMSTABK), max(KTUSMSTUBK), max(KTUSMSTEBK), max(KTUSMSTTUR), max(KTUSMSTFLG), max(KTUSMSTSPR), max(KTUSMSTRQSID) from X$KTUSMST2 group by ktusmstrbegtime, ktusmstrendtime
4pxua9j5qfw8bselect 'DATAPOINT', nvl(min(nvl(b.bytes, 0)/1048576), 11) minfreespace, nvl(min(nvl(b.bytes, 0)/c.bytes*100), 111) minfreespacepct from (select distinct e.ts#, f.name from sys.seg$ e, sys.ts$ f where e.ts# = f.ts# and e.ts# > 0 and e.TYPE# = 1 and f.online$ = 1 ) a, (select tablespace_name, sum(bytes) bytes from dba_free_space group by tablespace_name ) b, (select tablespace_name, sum(bytes) bytes from dba_data_files group by tablespace_name ) c, (select ts# from p$obj_exclusion where file# is null and block# is null and user# is null ) d, (select tablespace_name from dba_rollback_segs where status = 'ONLINE' ) h where a.name = b.tablespace_name(+) and a.name = c.tablespace_name and a.name = h.tablespace_name and a.ts# = d.ts#(+) and d.ts# is null
4rcrxkvaqt37finsert into wrh$_shared_pool_advice (snap_id, dbid, instance_number, shared_pool_size_for_estimate, shared_pool_size_factor, estd_lc_size, estd_lc_memory_objects, estd_lc_time_saved, estd_lc_time_saved_factor, estd_lc_load_time, estd_lc_load_time_factor, estd_lc_memory_object_hits) select :snap_id, :dbid, :instance_number, shared_pool_size_for_estimate, shared_pool_size_factor, estd_lc_size, estd_lc_memory_objects, estd_lc_time_saved, estd_lc_time_saved_factor, estd_lc_load_time, estd_lc_load_time_factor, estd_lc_memory_object_hits from v$shared_pool_advice
4rnugm1tgb6d6select r_link_cnt from dm_sysobject_s where r_object_id= '0b0000648004cb80'
4wsgbqzy6kwtpSELECT * FROM DM_ACS_CONFIG_RV dm_dbalias_B , DM_ACS_CONFIG_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
5a04f8xcw52dtselect 'DATAPOINT redo_allocation_gets' bpb, GETS from V$LATCH where NAME = 'redo allocation'
5d2tffwu9wuf9select owner||'|'||index_name||'|'||table_name||'|'||index_type||'|'||status from dba_indexes where status='UNUSABLE'
5va5scm0mug74select a.type_name, a.attr_name, a.policy_id, a.state_name, a.type_id from (dm_dd_policies_for_attrs a left outer join dmi_dd_attr_info_dden d on a.type_name = d.type_name AND a.policy_id = d.business_policy_id AND a.state_name = d.state_name AND a.attr_name = d.attr_name ) WHERE d.type_name is null and a.type_id IN (SELECT e.r_type_id FROM dmi_type_info_s e WHERE (BITAND(e.i_type_features, 256) = 0)) UNION ALL select a.type_name, a.attr_name, a.business_policy_id, a.state_name, '0000000000000000' from dmi_dd_attr_info_sv a where a.resync_needed = 1 and nls_key='en' UNION ALL select a.type_name, b.attr_name, a.policy_id, a.state_name, a.type_id from dm_dd_policies_for_type a, dm_dd_special_attrs b where not exists (select 1 from dmi_dd_attr_info_sv e where e.type_name = a.type_name and e.attr_name = b.attr_name and e.business_policy_id = a.policy_id and e.state_name = a.state_name and e.nls_key = 'en') and a.type_id IN (SELECT e.r_type_id FROM dmi_type_info_s e WHERE (BITAND(e.i_type_features, 256) = 0)) order by 5 asc, 3 asc
68rabpntu68a5SELECT * FROM DM_METHOD_RV dm_dbalias_B , DM_METHOD_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
6hbzst7gfnzw1 SELECT dm_dbalias_B.R_OBJECT_ID FROM imagesys.DM_SYSOBJECT_S dm_dbalias_B WHERE (dm_dbalias_B.R_OBJECT_ID=:objectp AND dm_dbalias_B.I_VSTAMP=:versionp)
6nvxnk9rtsh39select s.is_dynamic, s.group_class from dm_group_s s where s.group_name = :p0
6skskvty9hvf9SELECT * FROM DM_REGISTERED_RV dm_dbalias_B , DM_REGISTERED_SV dm_dbalias_C WHERE ((dm_dbalias_C.TABLE_NAME=:p00 AND dm_dbalias_C.TABLE_OWNER=:p01) AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
76natvnhtqqhwINSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , SYSDATE, SYSDATE, 0, 0, :B3 , NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 )
79uvsz1g1c168insert into wrh$_buffer_pool_statistics (snap_id, dbid, instance_number, id, name, block_size, set_msize, cnum_repl, cnum_write, cnum_set, buf_got, sum_write, sum_scan, free_buffer_wait, write_complete_wait, buffer_busy_wait, free_buffer_inspected, dirty_buffers_inspected, db_block_change, db_block_gets, consistent_gets, physical_reads, physical_writes) select :snap_id, :dbid, :instance_number, id, name, block_size, set_msize, cnum_repl, cnum_write, cnum_set, buf_got, sum_write, sum_scan, free_buffer_wait, write_complete_wait, buffer_busy_wait, free_buffer_inspected, dirty_buffers_inspected, db_block_change, db_block_gets, consistent_gets, physical_reads, physical_writes from v$buffer_pool_statistics
84qubbrsr0kfninsert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
86ds8fsfpxp3jbegin sys . dbms_backup_restore . deviceCommand ( :local_command , :local_parms:local_parmsni ) ; end ;
86nbcz0tya1fpselect 'DATAPOINT redo_copy_misses' bpb, IMMEDIATE_MISSES from V$LATCH where NAME = 'redo copy'
86s5qzz23mw7k SELECT dm_dbalias_B.R_OBJECT_ID FROM imagesys.DM_ACL_S dm_dbalias_B WHERE (dm_dbalias_B.OWNER_NAME=:p00 AND dm_dbalias_B.OBJECT_NAME=:p01)
8h98pqa1s2hvfSELECT * FROM DM_JOB_RV dm_dbalias_B , DM_JOB_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
8npuvpzyutpy7select 'DATAPOINT sga_latch_gets' bpb, nvl(sum(GETS), 0) from V$LATCH
8s6gxj2w0byd1select * from dm_resync_dd_type_info order by type_id asc, policy_id asc
8tgrhvcdw4kfm select /*NORULE */ 'DATA:'||A.FILE#||':'||A.BLOCK#||':' || A.MAX_EXT_SIZE||':'||B.MAX_BLOCKS_FREE||':'||A.TS#||':' NOHEAD from (SELECT /*NORULE */ TS#, FILE#, BLOCK#, MAX(decode(1, sign(trunc(blocks*8192 / (1048576*1024))), 67108864, sign(trunc(blocks*8192 / (67108864))), 8388608, sign(trunc(blocks*8192 / (1048576))), 1048576, sign(trunc(blocks*8192 / (65536))), 65536))/8192 MAX_EXT_SIZE FROM SYS.SEG$ GROUP BY TS#, FILE#, BLOCK#) A, (SELECT /*NORULE */ VB.NAME TABLESPACE_NAME, VB.TS#, MAX(nvl(VA.BLOCKS, 0)) MAX_BLOCKS_FREE FROM DBA_FREE_SPACE VA, SYS.TS$ VB WHERE VB.NAME = VA.TABLESPACE_NAME (+) AND VB.ONLINE$ != 3 GROUP BY VB.NAME, VB.TS#) B, (SELECT TS#, FILE#, BLOCK# FROM P$OBJ_EXCLUSION WHERE TS# IS NOT NULL AND FILE# IS NULL AND BLOCK# IS NULL) C, (SELECT TS#, FILE#, BLOCK# FROM P$OBJ_EXCLUSION WHERE TS# IS NOT NULL AND FILE# IS NOT NULL AND BLOCK# IS NOT NULL) S, (SELECT /*NORULE */ UA.TS# TS#, UA.FILE# FILE#, UA.BLOCK# BLOCK# FROM SYS.SEG$ UA, P$OBJ_EXCLUSION UB WHERE UB.USER# IS NOT NULL AND UA.USER# = UB.USER#) U, (SELECT /*NORULE */ TABLESPACE_NAME FROM DBA_TABLESPACES WHERE STATUS = 'ONLINE' AND CONTENTS = 'PERMANENT' AND (EXTENT_MANAGEMENT = 'LOCAL' AND ALLOCATION_TYPE = 'SYSTEM')) E WHERE A.TS# = B.TS# AND A.MAX_EXT_SIZE > B.MAX_BLOCKS_FREE AND B. MAX_BLOCKS_FREE > 0 AND A.TS# = C.TS#(+) AND C.TS# IS NULL AND A.TS# = S.TS# (+) AND A.FILE# = S.FILE# (+) AND A.BLOCK# = S.BLOCK# (+) AND S.TS# IS NULL AND S.FILE# IS NULL AND S.BLOCK# IS NULL AND A.TS# = U.TS# (+) AND A.FILE# = U.FILE# (+) AND A.BLOCK# = U.BLOCK# (+) AND U.TS# IS NULL AND U.FILE# IS NULL AND U.BLOCK# IS NULL AND B.TABLESPACE_NAME = E.TABLESPACE_NAME
8xp8rujc75tsmselect all dm_document.r_object_id from dm_document_sp dm_document where ((dm_document.object_name='DataDictionaryPublisher') and dm_document.r_object_id in (select r_object_id from dm_sysobject_r where i_folder_id='0b00006480000345')) and (dm_document.i_has_folder = 1 and dm_document.i_is_deleted = 0)
96f0wx3bbs7pqSELECT * FROM DM_FOLDER_RV dm_dbalias_B , DM_FOLDER_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
9babjv8yq8ru3BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); 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
9rfkm1bf915a0UPDATE WRH$_SEG_STAT_OBJ SET snap_id = :lah_snap_id WHERE dbid = :dbid AND (OBJ#, DATAOBJ#) IN (SELECT NUM1_KEWRATTR, NUM2_KEWRATTR FROM X$KEWRATTRSTALE)
9uwr8b5y49gdaselect 'DATA ' bpb, link from P$AUTOEXTENDEDLINKS where path = '/oracle' and type = 'dest'
a12b5292h48vqselect /*NORULE */ 'DATAPOINT free_space ' bpb, decode(min((a.BYTES_FREE / b.BYTES) * 100), '', 'NULL', min((a.BYTES_FREE / b.BYTES) * 100)) from (select /*NORULE */ tfs_b.name tablespace_name, tfs_b.ts# ts#, sum(nvl(tfs_a.bytes, 0)) bytes_free from dba_free_space tfs_a, sys.ts$ tfs_b where tfs_b.name = tfs_a.tablespace_name (+) and tfs_b.online$ != 3 group by tfs_b.name, tfs_b.ts#) a, (select /*NORULE */ e.tablespace_name, sum(e.bytes) bytes from dba_data_files e, (select /*NORULE */ tablespace_name from dba_data_files where autoextensible = 'YES') f where e.tablespace_name = f.tablespace_name(+) and f.tablespace_name is null and e.autoextensible = 'NO' group by e.tablespace_name) b, DBA_TABLESPACES c, (SELECT /*NORULE */ TS# FROM P$OBJ_EXCLUSION WHERE OBJECT_TYPE = 'TABLE' AND FILE# IS NULL AND BLOCK# IS NULL) d where a.TABLESPACE_NAME = b.TABLESPACE_NAME and b.TABLESPACE_NAME = c.TABLESPACE_NAME and c.CONTENTS != 'TEMPORARY' and c.status = 'ONLINE' and a.TS# = d.TS#(+) and d.TS# is NULL and c.TABLESPACE_NAME != 'SYSTEM'
a9vpk93gt1btvSELECT * FROM DM_STORE_S dm_dbalias_B WHERE dm_dbalias_B.R_OBJECT_ID=:handlep FOR UPDATE OF dm_dbalias_B.R_OBJECT_ID
agmz1qj12d0v1 SELECT dm_dbalias_B.R_OBJECT_ID FROM imagesys.DM_ACL_S dm_dbalias_B WHERE (dm_dbalias_B.R_OBJECT_ID=:objectp AND dm_dbalias_B.I_VSTAMP=:versionp)
akh9zqqkx3wj7select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1
aqxqv86gv23dtSELECT * FROM DM_SYSOBJECT_RV dm_dbalias_B , DM_SYSOBJECT_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
bgamdkp40bbp7select all dm_folder.r_object_id from dm_folder_sp dm_folder where (dm_folder.r_object_id in (select r_object_id from dm_folder_r where r_folder_path='/cmbc_imagesys/cmbc/2012/7/23')) and (dm_folder.i_has_folder = 1 and dm_folder.i_is_deleted = 0)
bqnn4c3gjtmguinsert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select /*+ ordered use_nl(e) */ :snap_id, :dbid, :instance_number, e.event_id, sum(e.total_waits), sum(e.total_timeouts), sum(e.time_waited_micro) from v$session bgsids, v$session_event e where bgsids.type = 'BACKGROUND' and bgsids.sid = e.sid group by e.event_id
btqx5836c7w30select r_object_id, r_workflow_id from dmi_workitem_s where r_runtime_state in (0, 1) and r_auto_method_id > '0000000000000000' and a_wq_name = :p0
bunssq950snhfinsert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
bzr24dsp3ypk2SELECT * FROM CMBC_IMAGE_METADATA_RV dm_dbalias_B , CMBC_IMAGE_METADATA_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
c0m0j9uy53fpzselect all cmbc_typever_metadata.version_no from cmbc_typever_metadata_sp cmbc_typever_metadata where (cmbc_typever_metadata.i_has_folder = 1 and cmbc_typever_metadata.i_is_deleted = 0)
c6u1g74vugzxzUPDATE /*+ USE_NL(dmi_workitem_s) */ dmi_workitem_s SET a_wq_name = :p0 WHERE r_object_id = ANY (SELECT /*+ CARDINALITY(1) */ wis2.r_object_id FROM (SELECT wis3.r_object_id AS r_object_id FROM (SELECT /*+ CARDINALITY(1) */ wis.r_object_id AS r_object_id FROM dmi_workitem_s wis WHERE wis.r_runtime_state >= 0 AND wis.r_runtime_state <= 1 AND wis.r_auto_method_id > '0000000000000000' AND wis.a_wq_name = ' ' AND wis.r_next_retry_date < SYSDATE order by r_creation_date asc ) wis3 WHERE rownum <= 90 ) wis2 )
c7yrqkffcmvxvselect 'DATAPOINT redo_copy_gets' bpb, IMMEDIATE_GETS from V$LATCH where NAME = 'redo copy'
cdjqrz2j2hw87SELECT * FROM DM_DOCBASE_CONFIG_RV dm_dbalias_B , DM_DOCBASE_CONFIG_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
cg1r9tkms1zfpSELECT * FROM DM_CONT_TRANSFER_CONFIG_RV dm_dbalias_B , DM_CONT_TRANSFER_CONFIG_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
czunzy04xj2vwselect 'DATA ' bpb, link from P$AUTOEXTENDEDLINKS where path = '/oracle/product/admin/SFSNSRDB/bdump' and type = 'dest'
d0n9k00unpy6vselect 'DATAPOINT redo_allocation_misses' bpb, MISSES from V$LATCH where NAME = 'redo allocation'
d4r4wjv6rswnnselect 'DATAPOINT( ' bpb, a.tablespace_name, sum(nvl(b.bytes, 0)) freespace from dba_tablespaces a, dba_free_space b where a.tablespace_name = b.tablespace_name(+) and EXISTS ( SELECT 'X' FROM P$TSMON WHERE TABLESPACE_NAME = a.TABLESPACE_NAME and TABLESPACE_TYPE =3) and a.contents != 'UNDO' group by a.TABLESPACE_NAME union select 'DATAPOINT( ' bpb, tablespace_name, sum(bytes_free) freespace from ( select a.tablespace_name, sum(nvl(b.bytes, 0)) bytes_free from dba_tablespaces a, dba_free_space b where a.tablespace_name = b.tablespace_name(+) and a.contents = 'UNDO' and EXISTS ( SELECT 'X' FROM P$TSMON WHERE TABLESPACE_NAME = a.TABLESPACE_NAME and TABLESPACE_TYPE =3) group by a.tablespace_name union all select c.tablespace_name, sum(nvl(c.bytes, 0)) bytes_free from dba_undo_extents c where c.status != 'ACTIVE' and EXISTS ( SELECT 'X' FROM P$TSMON WHERE TABLESPACE_NAME = c.TABLESPACE_NAME and TABLESPACE_TYPE =3) group by c.tablespace_name ) group by tablespace_name
d5zvak9ah5z4zSELECT * FROM DM_ACL_RV dm_dbalias_B , DM_ACL_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
dprg7r21712pzSELECT * FROM DM_PUBLIC_KEY_CERTIFICATE_RV dm_dbalias_B , DM_PUBLIC_KEY_CERTIFICATE_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
f318xdxdn0pdcinsert into wrh$_log (snap_id, dbid, instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time) select :snap_id, :dbid, :instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time from v$log
f6y537gy0p982update sys.scheduler$_job set running_instance = :1, running_slave = :2, job_status = :3, last_start_date = :4 where obj# = :5
fjxhdgrg0tgrgSELECT * FROM DM_DOCUMENT_RV dm_dbalias_B , DM_DOCUMENT_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g6wf9na8zs5hbinsert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minval, average, standard_deviation) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min, avg, std FROM x$kewmsmdv WHERE groupid = 2
gdn3ysuyssf82SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gpuq908z67vndINSERT INTO imagesys.DM_SYSOBJECT_R VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20)
grwydz59pu6mcselect text from view$ where rowid=:1
gsdjff9jckg3yselect a.r_object_id from dmi_index_s a where a.index_type = :p0 and exists (select 1 from dmi_index_r b where b.r_object_id = a.r_object_id and b.attribute = :p1 and b.i_position = -1)
gyg5wucwun752UPDATE imagesys.DM_JOB_S dm_dbalias_B SET A_CURRENT_STATUS = 'DataDictionaryPublisher Completed.' WHERE dm_dbalias_B.R_OBJECT_ID=:handle
gyr0zxqh8dsg3SELECT * FROM DM_CABINET_RV dm_dbalias_B , DM_CABINET_SV dm_dbalias_C WHERE (dm_dbalias_C.R_OBJECT_ID=:handle AND dm_dbalias_C.R_OBJECT_ID=dm_dbalias_B.R_OBJECT_ID) ORDER BY dm_dbalias_B.R_OBJECT_ID, dm_dbalias_B.I_POSITION

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 14,095 1.31 3.35
CPU used when call started 13,005 1.21 3.09
CR blocks created 64 0.01 0.02
Cached Commit SCN referenced 0 0.00 0.00
Commit SCN cached 0 0.00 0.00
DB time 49,767 4.62 11.83
DBWR checkpoint buffers written 17,817 1.65 4.23
DBWR checkpoints 2 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 274 0.03 0.07
DBWR undo block writes 4,779 0.44 1.14
IMU CR rollbacks 0 0.00 0.00
IMU Flushes 113 0.01 0.03
IMU Redo allocation size 2,905,832 269.63 690.55
IMU commits 3,890 0.36 0.92
IMU contention 1 0.00 0.00
IMU ktichg flush 1 0.00 0.00
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 2 0.00 0.00
IMU undo allocation size 13,242,784 1,228.79 3,147.05
IMU- failed to get a private strand 0 0.00 0.00
Misses for writing mapping 0 0.00 0.00
RowCR - row contention 47 0.00 0.01
RowCR attempts 1,680 0.16 0.40
RowCR hits 1,641 0.15 0.39
SQL*Net roundtrips to/from client 196,168 18.20 46.62
active txn count during cleanout 2,019 0.19 0.48
application wait time 3 0.00 0.00
background checkpoints completed 2 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 34,526 3.20 8.20
branch node splits 11 0.00 0.00
buffer is not pinned count 839,838 77.93 199.58
buffer is pinned count 586,440 54.42 139.36
bytes received via SQL*Net from client 123,671,076 11,475.34 29,389.51
bytes sent via SQL*Net to client 158,185,768 14,677.92 37,591.67
calls to get snapshot scn: kcmgss 227,491 21.11 54.06
calls to kcmgas 11,395 1.06 2.71
calls to kcmgcs 1,044 0.10 0.25
change write time 165 0.02 0.04
cleanout - number of ktugct calls 2,462 0.23 0.59
cleanouts and rollbacks - consistent read gets 3 0.00 0.00
cleanouts only - consistent read gets 229 0.02 0.05
cluster key scan block gets 9,108 0.85 2.16
cluster key scans 6,828 0.63 1.62
commit batch/immediate performed 3 0.00 0.00
commit batch/immediate requested 3 0.00 0.00
commit cleanout failures: block lost 0 0.00 0.00
commit cleanout failures: buffer being written 1 0.00 0.00
commit cleanout failures: callback failure 345 0.03 0.08
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 19,402 1.80 4.61
commit cleanouts successfully completed 19,056 1.77 4.53
commit immediate performed 3 0.00 0.00
commit immediate requested 3 0.00 0.00
commit txn count during cleanout 4,705 0.44 1.12
concurrency wait time 283 0.03 0.07
consistent changes 98 0.01 0.02
consistent gets 1,424,468 132.18 338.51
consistent gets - examination 846,635 78.56 201.20
consistent gets direct 0 0.00 0.00
consistent gets from cache 1,424,468 132.18 338.51
cursor authentications 550 0.05 0.13
data blocks consistent reads - undo records applied 98 0.01 0.02
db block changes 371,843 34.50 88.37
db block gets 531,514 49.32 126.31
db block gets direct 0 0.00 0.00
db block gets from cache 531,514 49.32 126.31
deferred (CURRENT) block cleanout applications 5,729 0.53 1.36
doubling up with imu segment 0 0.00 0.00
enqueue conversions 5,747 0.53 1.37
enqueue releases 135,268 12.55 32.15
enqueue requests 135,272 12.55 32.15
enqueue timeouts 4 0.00 0.00
enqueue waits 2 0.00 0.00
exchange deadlocks 0 0.00 0.00
execute count 191,789 17.80 45.58
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 0 0.00 0.00
free buffer requested 7,732 0.72 1.84
heap block compress 47 0.00 0.01
hot buffers moved to head of LRU 0 0.00 0.00
immediate (CR) block cleanout applications 232 0.02 0.06
immediate (CURRENT) block cleanout applications 3,373 0.31 0.80
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 28,353 2.63 6.74
index fast full scans (full) 41 0.00 0.01
index fetch by key 328,951 30.52 78.17
index scans kdiixs1 82,299 7.64 19.56
leaf node 90-10 splits 171 0.02 0.04
leaf node splits 1,121 0.10 0.27
lob reads 0 0.00 0.00
lob writes 6 0.00 0.00
lob writes unaligned 6 0.00 0.00
logons cumulative 305 0.03 0.07
messages received 15,323 1.42 3.64
messages sent 15,323 1.42 3.64
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 481,509 44.68 114.43
opened cursors cumulative 186,953 17.35 44.43
parse count (failures) 214 0.02 0.05
parse count (hard) 30,551 2.83 7.26
parse count (total) 186,961 17.35 44.43
parse time cpu 3,844 0.36 0.91
parse time elapsed 4,350 0.40 1.03
physical read IO requests 806 0.07 0.19
physical read bytes 8,110,080 752.53 1,927.30
physical read total IO requests 18,243 1.69 4.34
physical read total bytes 576,342,016 53,478.29 136,963.41
physical read total multi block requests 317 0.03 0.08
physical reads 990 0.09 0.24
physical reads cache 990 0.09 0.24
physical reads cache prefetch 184 0.02 0.04
physical reads direct 0 0.00 0.00
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 184 0.02 0.04
physical write IO requests 10,484 0.97 2.49
physical write bytes 145,981,440 13,545.50 34,691.41
physical write total IO requests 26,734 2.48 6.35
physical write total bytes 562,451,456 52,189.40 133,662.42
physical write total multi block requests 2,528 0.23 0.60
physical writes 17,820 1.65 4.23
physical writes direct 0 0.00 0.00
physical writes direct (lob) 0 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 17,820 1.65 4.23
physical writes non checkpoint 6,900 0.64 1.64
pinned buffers inspected 0 0.00 0.00
pinned cursors current 0 0.00 0.00
process last non-idle time 10,533 0.98 2.50
recursive calls 132,892 12.33 31.58
recursive cpu usage 4,438 0.41 1.05
redo blocks written 82,583 7.66 19.63
redo buffer allocation retries 0 0.00 0.00
redo entries 189,437 17.58 45.02
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 4,581 0.43 1.09
redo size 80,985,312 7,514.56 19,245.56
redo subscn max counts 8,074 0.75 1.92
redo synch time 346 0.03 0.08
redo synch writes 4,020 0.37 0.96
redo wastage 2,131,736 197.80 506.59
redo write time 396 0.04 0.09
redo writer latching time 0 0.00 0.00
redo writes 4,604 0.43 1.09
rollback changes - undo records applied 99 0.01 0.02
rollbacks only - consistent read gets 52 0.00 0.01
root node splits 0 0.00 0.00
rows fetched via callback 304,293 28.24 72.31
session connect time 0 0.00 0.00
session cursor cache hits 147,725 13.71 35.11
session logical reads 1,955,982 181.49 464.82
shared hash latch upgrades - no wait 30,075 2.79 7.15
shared hash latch upgrades - wait 0 0.00 0.00
sorts (memory) 11,318 1.05 2.69
sorts (rows) 889,765 82.56 211.45
sql area evicted 26,693 2.48 6.34
sql area purged 244 0.02 0.06
switch current to new buffer 6 0.00 0.00
table fetch by rowid 588,565 54.61 139.87
table fetch continued row 0 0.00 0.00
table scan blocks gotten 246,828 22.90 58.66
table scan rows gotten 7,907,370 733.72 1,879.13
table scans (long tables) 0 0.00 0.00
table scans (short tables) 6,982 0.65 1.66
total number of times SMON posted 0 0.00 0.00
transaction rollbacks 3 0.00 0.00
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 27,926,544 2,591.28 6,636.54
user I/O wait time 7 0.00 0.00
user calls 375,716 34.86 89.29
user commits 3,999 0.37 0.95
user rollbacks 209 0.02 0.05
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 7,480 0.69 1.78
write clones created in background 0 0.00 0.00
write clones created in foreground 1 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 4,514,535,264 4,520,622,488
session cursor cache count 758,108 761,559
session uga memory 1.0E+13 1.0E+13
opened cursors current 55 56
logons current 113 114
session uga memory max 67,305,514,112 67,519,712,912
session pga memory 2,831,551,040 2,837,441,656

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 2 0.67

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)
ICMS_IMAGESYS_DATA 159 0 0.06 1.25 5,013 0 0 0.00
ICMS_IMAGESYS_IDX 46 0 0.65 4.15 3,980 0 0 0.00
UNDOTBS1 0 0 0.00 0.00 806 0 0 0.00
SYSTEM 600 0 0.07 1.00 177 0 0 0.00
SYSAUX 0 0 0.00 0.00 502 0 0 0.00
PATROL_DATA 0 0 0.00 0.00 6 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)
ICMS_IMAGESYS_DATA /imgsys/oracledata/SFSNSRDB/icms_imagesys_data_1.dbf 159 0 0.06 1.25 5,013 0 0 0.00
ICMS_IMAGESYS_IDX /imgsys/oracledata/SFSNSRDB/icms_imagesys_idx_1.dbf 46 0 0.65 4.15 3,980 0 0 0.00
PATROL_DATA /imgsys/oracledata/SFSNSRDB/patrol_data.dbf 0 0     6 0 0 0.00
SYSAUX /imgsys/oracledata/SFSNSRDB/sysaux01.dbf 0 0     502 0 0 0.00
SYSTEM /imgsys/oracledata/SFSNSRDB/system01.dbf 600 0 0.07 1.00 177 0 0 0.00
UNDOTBS1 /imgsys/oracledata/SFSNSRDB/undotbs01.dbf 0 0     806 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,141,278 100 1,956,034 990 17,820 0 0 0


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 13 396 738 3276 3774870 3276  
E 0 14 320 826 12488 3774870 12488  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 1,728 0.10 213,732 1.13 765,801
D 3,456 0.20 427,464 1.01 680,513
D 5,184 0.30 641,196 1.00 678,349
D 6,912 0.40 854,928 1.00 677,808
D 8,640 0.50 1,068,660 1.00 677,305
D 10,368 0.60 1,282,392 1.00 676,865
D 12,096 0.70 1,496,124 1.00 676,865
D 13,824 0.80 1,709,856 1.00 676,865
D 15,552 0.90 1,923,588 1.00 676,865
D 17,280 1.00 2,137,320 1.00 676,865
D 17,312 1.00 2,141,278 1.00 676,865
D 19,008 1.10 2,351,052 1.00 676,865
D 20,736 1.20 2,564,784 1.00 676,865
D 22,464 1.30 2,778,516 1.00 676,865
D 24,192 1.40 2,992,248 1.00 676,865
D 25,920 1.50 3,205,980 1.00 676,865
D 27,648 1.60 3,419,712 1.00 676,865
D 29,376 1.70 3,633,444 1.00 676,865
D 31,104 1.80 3,847,176 1.00 676,865
D 32,832 1.90 4,060,908 1.00 676,865
D 34,560 2.00 4,274,640 1.00 676,865

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 347 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,778 108.27 0.00 0.00 0.00 0.00 209,710
E 2,048 1,777 109.16 0.00 0.00 0.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 6,994 6,994 0 0
64K 128K 141 141 0 0
512K 1024K 264 264 0 0
1M 2M 81 81 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 135,518.47 1,040.91 99.00 0
512 0.25 135,518.47 1,040.91 99.00 0
1,024 0.50 135,518.47 1,040.91 99.00 0
1,536 0.75 135,518.47 1,040.91 99.00 0
2,048 1.00 135,518.47 1,040.91 99.00 0
2,458 1.20 135,518.47 0.00 100.00 0
2,867 1.40 135,518.47 0.00 100.00 0
3,277 1.60 135,518.47 0.00 100.00 0
3,686 1.80 135,518.47 0.00 100.00 0
4,096 2.00 135,518.47 0.00 100.00 0
6,144 3.00 135,518.47 0.00 100.00 0
8,192 4.00 135,518.47 0.00 100.00 0
12,288 6.00 135,518.47 0.00 100.00 0
16,384 8.00 135,518.47 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
848 0.27 366 45,687 168,406 0.99 6,256 1.31 24,753
1,168 0.38 681 63,078 169,020 0.99 5,642 1.18 24,838
1,488 0.48 1,000 80,227 169,219 1.00 5,443 1.14 24,869
1,808 0.59 1,319 97,409 169,307 1.00 5,355 1.12 24,885
2,128 0.69 1,638 112,162 169,434 1.00 5,228 1.09 24,907
2,448 0.79 1,957 127,561 169,579 1.00 5,083 1.06 24,931
2,768 0.90 2,276 145,850 169,720 1.00 4,942 1.04 24,956
3,088 1.00 2,595 163,670 169,887 1.00 4,775 1.00 24,986
3,408 1.10 2,914 180,697 170,075 1.00 4,587 0.96 25,019
3,728 1.21 3,233 199,474 170,226 1.00 4,436 0.93 25,045
4,048 1.31 3,552 217,116 170,317 1.00 4,345 0.91 25,060
4,368 1.41 3,871 233,706 170,349 1.00 4,313 0.90 25,066
4,688 1.52 4,190 251,877 170,364 1.00 4,298 0.90 25,069
5,008 1.62 4,509 269,833 170,379 1.00 4,283 0.90 25,072
5,328 1.73 4,828 287,603 170,403 1.00 4,259 0.89 25,077
5,648 1.83 5,147 305,577 170,437 1.00 4,225 0.88 25,084
5,968 1.93 5,466 323,113 170,477 1.00 4,185 0.88 25,093
6,288 2.04 5,785 341,387 170,519 1.00 4,143 0.87 25,102

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5,120 0.25 32,436 765,804
10,240 0.50 31,784 680,519
15,360 0.75 31,784 677,338
20,480 1.00 31,784 676,864
25,600 1.25 31,784 676,864
30,720 1.50 31,784 676,864
35,840 1.75 31,784 676,864
40,960 2.00 31,784 676,864

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

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
CF-Controlfile Transaction 4,980 4,980 0 2 0 0.50

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 4.74 6,314 0 3 113084.3/116707.9 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
23-Jul 12:07 194 322 0 3 115,151 0/0 0/0/0/0/0/0
23-Jul 11:57 169 201 0 2 115,006 0/0 0/0/0/0/0/0
23-Jul 11:47 359 417 0 2 114,728 0/0 0/0/0/0/0/0
23-Jul 11:37 308 416 0 2 115,588 0/0 0/0/0/0/0/0
23-Jul 11:27 417 360 0 2 115,187 0/0 0/0/0/0/0/0
23-Jul 11:17 183 230 0 2 116,708 0/0 0/0/0/0/0/0
23-Jul 11:07 184 320 0 3 116,400 0/0 0/0/0/0/0/0
23-Jul 10:57 177 213 0 2 116,585 0/0 0/0/0/0/0/0
23-Jul 10:47 283 254 0 2 116,491 0/0 0/0/0/0/0/0
23-Jul 10:37 51 209 0 2 116,379 0/0 0/0/0/0/0/0
23-Jul 10:27 220 215 0 2 114,841 0/0 0/0/0/0/0/0
23-Jul 10:17 50 236 0 2 115,399 0/0 0/0/0/0/0/0
23-Jul 10:07 760 888 0 3 113,084 0/0 0/0/0/0/0/0
23-Jul 09:57 584 479 0 2 114,076 0/0 0/0/0/0/0/0
23-Jul 09:47 249 272 0 2 115,364 0/0 0/0/0/0/0/0
23-Jul 09:37 189 339 0 2 114,986 0/0 0/0/0/0/0/0
23-Jul 09:27 121 258 0 2 115,097 0/0 0/0/0/0/0/0
23-Jul 09:17 121 309 0 2 114,055 0/0 0/0/0/0/0/0
23-Jul 09:07 122 376 0 3 113,209 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 7,163 0.00   0 0  
AWR Alerted Metric Element list 55,378 0.00   0 0  
Consistent RBA 4,605 0.00   0 0  
FAL request queue 218 0.00   0 0  
FAL subheap alocation 218 0.00   0 0  
FIB s.o chain latch 72 0.00   0 0  
FOB s.o list latch 664 0.00   0 0  
In memory undo latch 26,718 0.00   0 6,343 0.00
JS mem alloc latch 15 0.00   0 0  
JS queue access latch 15 0.00   0 0  
JS queue state obj latch 77,610 0.00   0 0  
JS slv state obj latch 12 0.00   0 0  
KMG MMAN ready and startup request latch 3,583 0.00   0 0  
KMG resize request state object freelist 4 0.00   0 0  
KSFQ 10 0.00   0 0  
KTF sga latch 28 0.00   0 2,254 0.00
KWQMN job cache list latch 3 0.00   0 0  
MQL Tracking Latch 0     0 212 0.00
Memory Management Latch 44 0.00   0 3,582 0.00
OS process 1,110 0.00   0 0  
OS process allocation 4,322 0.00   0 0  
OS process: request allocation 597 0.00   0 0  
PL/SQL warning settings 2,779 0.00   0 0  
SGA IO buffer pool latch 31 0.00   0 31 0.00
SQL memory manager latch 3 0.00   0 3,581 0.00
SQL memory manager workarea list latch 300,736 0.00   0 0  
Shared B-Tree 372 0.00   0 0  
X$KSFQP 14 0.00   0 0  
active checkpoint queue latch 14,071 0.00   0 0  
active service list 23,101 0.00 0.00 0 11,424 0.00
alert log latch 4 0.00   0 0  
archive control 506 0.00   0 0  
archive process latch 4,023 0.00   0 0  
buffer pool 4 0.00   0 0  
cache buffer handles 2,874 0.00   0 0  
cache buffers chains 4,016,999 0.00 0.00 0 12,142 0.01
cache buffers lru chain 38,224 0.00   0 10,868 0.00
channel handle pool latch 597 0.00   0 0  
channel operations parent latch 51,241 0.00   0 0  
checkpoint queue latch 4,078,404 0.00 0.00 0 19,714 0.00
client/application info 2,332 0.00   0 0  
compile environment latch 305 0.00   0 0  
direct msg latch 15,829 0.00   0 0  
dml lock allocation 16,695 0.00   0 0  
done queue latch 15,334 0.00   0 15,782 0.00
dummy allocation 609 0.00   0 0  
enqueue hash chains 276,330 0.00   0 0  
enqueues 256,623 0.00 0.00 0 0  
event group latch 299 0.00   0 0  
file cache latch 512 0.00   0 0  
global KZLD latch for mem in SGA 255 0.00   0 0  
hash table column usage latch 317 0.00   0 45,536 0.00
hash table modification latch 205 0.00   0 0  
i/o slave adaptor 19 0.00   0 0  
interrupt manipulation 10 0.00   0 0  
job workq parent latch 0     0 12 0.00
job_queue_processes parameter latch 185 0.00   0 0  
kks stats 163,195 0.00 0.50 0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 12 0.00   0 0  
krbmrosl 59 0.00   0 0  
ksfv messages 31,116 0.00   0 0  
ksfv subheap 42 0.00   0 0  
ksuosstats global area 725 0.00   0 0  
ktm global data 35 0.00   0 0  
kwqbsn:qsga 372 0.00   0 0  
lgwr LWN SCN 6,072 0.02 0.00 0 0  
library cache 911,833 0.00 0.00 0 118,726 0.01
library cache load lock 10 0.00   0 0  
library cache lock 643,590 0.00 0.00 0 0  
library cache lock allocation 1,849 0.00   0 0  
library cache pin 216,965 0.00   0 0  
library cache pin allocation 156 0.00   0 0  
list of block allocation 1,262 0.00   0 0  
longop free list parent 8 0.00   0 8 0.00
messages 104,176 0.00 0.00 0 0  
mostly latch-free SCN 6,065 0.02 0.00 0 0  
msg queue latch 1,142 0.00   0 30,621 3.52
multiblock read objects 98 0.00   0 0  
ncodef allocation latch 171 0.00   0 0  
object queue header heap 563,222 0.00   0 252 0.00
object queue header operation 625,119 0.00 0.00 0 1,976 0.00
object stats modification 3 0.00   0 0  
parallel query alloc buffer 1,432 0.00   0 0  
parameter list 1,445 0.00   0 0  
parameter table management 623 0.00   0 0  
post/wait queue 6,130 0.00   0 4,022 0.00
process allocation 597 0.00   0 299 0.00
process group creation 597 0.00   0 0  
qmn task queue latch 1,488 0.27 0.25 0 0  
redo allocation 48,891 0.01 0.00 0 189,525 0.00
redo copy 0     0 189,525 0.02
redo writing 35,425 0.00   0 0  
resmgr group change latch 479 0.00   0 0  
resmgr:active threads 552 0.00   0 0  
resmgr:actses change group 269 0.00   0 0  
resmgr:free threads list 549 0.00   0 0  
resmgr:resource group CPU method 268 0.00   0 0  
resmgr:schema config 3 0.00   0 0  
row cache objects 1,513,307 0.00 0.00 0 449 0.00
sequence cache 826 0.00   0 0  
session allocation 30,415 0.02 0.00 0 0  
session idle bit 769,013 0.00   0 0  
session queue latch 15,811 0.00   0 0  
session state list latch 570 0.00   0 0  
session switching 1,661 0.00   0 0  
session timer 3,592 0.00   0 0  
shared pool 1,224,147 0.00 0.06 0 0  
shared pool sim alloc 65 0.00   0 0  
shared pool simulator 200,622 0.00   0 0  
simulator hash latch 131,252 0.00   0 0  
simulator lru latch 18,863 0.00   0 112,596 0.00
slave class 24 0.00   0 0  
slave class create 96 3.13 1.00 0 0  
sort extent pool 260 0.00   0 0  
state object free list 6 0.00   0 0  
statistics aggregation 1,680 0.00   0 0  
threshold alerts latch 538 0.00   0 0  
transaction allocation 1,477,938 0.00   0 0  
transaction branch allocation 3,592 0.00   0 0  
undo global data 76,532 0.00   0 0  
user lock 1,030 0.10 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
shared pool 1,224,147 34 2 32 0 0 0
qmn task queue latch 1,488 4 1 3 0 0 0
slave class create 96 3 3 0 0 0 0
kks stats 163,195 2 1 1 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffers chains kcbgtcr: kslbegin excl 0 2 1
event range base latch No latch 0 1 1
kks stats kks stats alloc/free 0 1 1
shared pool kghalo 0 1 1
shared pool kghfrunp: alloc: session dur 0 1 0
slave class create ksvcreate 0 3 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
IMAGESYS ICMS_IMAGESYS_IDX D_1F0000648000010B   INDEX 198,016 10.12
IMAGESYS ICMS_IMAGESYS_DATA DMI_DD_COMMON_INFO_S   TABLE 167,088 8.54
IMAGESYS ICMS_IMAGESYS_IDX D_1F00006480000136   INDEX 154,448 7.90
IMAGESYS ICMS_IMAGESYS_DATA DMI_INDEX_S   TABLE 151,968 7.77
IMAGESYS ICMS_IMAGESYS_DATA DMI_DD_ATTR_INFO_S   TABLE 109,056 5.58

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
IMAGESYS ICMS_IMAGESYS_IDX D_1F00006480000271   INDEX 42 4.24
IMAGESYS ICMS_IMAGESYS_DATA DM_SYSOBJECT_R   TABLE 26 2.63
IMAGESYS ICMS_IMAGESYS_IDX D_1F00006480000043   INDEX 22 2.22
IMAGESYS ICMS_IMAGESYS_DATA DMR_CONTENT_S   TABLE 18 1.82
IMAGESYS ICMS_IMAGESYS_IDX D_1F00006480000163   INDEX 18 1.82

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SYS SYSTEM SMON_SCN_TIME   TABLE 6 100.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 194 0.00 0   6 1
dc_database_links 532 0.00 0   0 1
dc_files 400 0.00 0   0 8
dc_global_oids 6,918 0.00 0   0 70
dc_histogram_data 18,358 0.00 0   0 3,745
dc_histogram_defs 26,255 0.00 0   0 4,052
dc_object_grants 24 0.00 0   0 8
dc_object_ids 205,693 0.01 0   0 1,775
dc_objects 62,487 0.00 0   15 1,102
dc_profiles 267 0.00 0   0 1
dc_rollback_segments 5,870 0.00 0   0 83
dc_segments 156,436 0.00 0   26 1,294
dc_sequences 2 0.00 0   2 3
dc_tablespace_quotas 18 0.00 0   11 3
dc_tablespaces 8,695 0.00 0   0 11
dc_usernames 1,176 0.00 0   0 35
dc_users 27,633 0.00 0   0 54
outstanding_alerts 162 0.00 0   0 9


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 193 0.00 2,700 0.00 0 0
CLUSTER 24 0.00 24 0.00 0 0
SQL AREA 69,427 87.10 259,610 35.18 305 78
TABLE/PROCEDURE 1,560 0.00 166,477 0.00 5 0
TRIGGER 24 0.00 48 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 Other 91.02   0.79 1.72 11 11 115 115
  Freeable 16.31 0.00 0.86 0.38 2   19 19
  SQL 0.66 0.11 0.01 0.02 0 5 83 30
  PL/SQL 0.30 0.09 0.00 0.00 0 0 113 113
E Other 91.33   0.79 1.71 11 11 116 116
  Freeable 16.88 0.00 0.89 0.39 2   19 19
  SQL 0.67 0.11 0.01 0.02 0 5 84 31
  PL/SQL 0.30 0.09 0.00 0.00 0 0 114 114

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 18,152,947,712  
Fixed Size 2,106,232  
Redo Buffers 64,999,424  
Variable Size 3,254,783,112  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared ASH buffers 68.00 68.00 0.00
shared CCursor 245.11 254.31 3.75
shared PCursor 209.98 224.61 6.97
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 624.78 536.07 -14.20
shared kglsim object batch 49.81 49.95 0.30
shared library cache 153.81 156.97 2.06
shared sql area 1,318.85 1,385.49 5.05
  buffer_cache 17,312.00 17,312.00 0.00
  fixed_sga 2.01 2.01 0.00
  log_buffer 61.99 61.99 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

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /oracle/product/admin/SFSNSRDB/adump   
background_dump_dest /oracle/product/admin/SFSNSRDB/bdump   
backup_tape_io_slaves TRUE   
compatible 10.2.0.5.0   
control_files /imgsys/oracledata/SFSNSRDB/control01.ctl, /imgsys/oracledata/SFSNSRDB/control02.ctl, /imgsys/oracledata/SFSNSRDB/control03.ctl   
core_dump_dest /oracle/product/admin/SFSNSRDB/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name SFSNSRDB   
dbwr_io_slaves 20   
disk_asynch_io FALSE   
dispatchers (PROTOCOL=TCP) (SERVICE=SFSNSRDBXDB)   
job_queue_processes 10   
log_archive_dest_1 LOCATION=/archlog   
log_archive_dest_state_1 ENABLE   
open_cursors 1000   
pga_aggregate_target 2147483648   
processes 1000   
remote_login_passwordfile EXCLUSIVE   
sessions 1131   
sga_target 21474836480   
spfile /imgsys/oracledata/SFSNSRDB/spfileSFSNSRDB.ora   
tape_asynch_io FALSE   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/product/admin/SFSNSRDB/udump   


Back to Top

End of Report