WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ORCL1308262999orcl110.2.0.5.0NOts-ora10gr2

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:714005-Feb-13 22:00:44121 12.7
End Snap:714105-Feb-13 23:00:24120 8.9
Elapsed:  59.66 (mins)  
DB Time:  637.44 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 3,024M 3,344MStd Block Size: 8K
Shared Pool Size: 2,912M 2,592MLog Buffer: 14,324K

Load Profile

Per SecondPer Transaction
Redo size: 1,535,123.31 361,140.58
Logical reads: 7,940.17 1,867.94
Block changes: 1,780.36 418.83
Physical reads: 52.70 12.40
Physical writes: 248.61 58.49
User calls: 151.44 35.63
Parses: 142.21 33.46
Hard parses: 18.78 4.42
Sorts: 53.38 12.56
Logons: 0.43 0.10
Executes: 239.50 56.34
Transactions: 4.25 

% Blocks changed per Read: 22.42Recursive Call %: 88.79
Rollback per transaction %: 14.19Rows per Sort: 239.76

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.94Redo NoWait %: 99.84
Buffer Hit %: 99.34In-memory Sort %: 100.00
Library Hit %: 91.82Soft Parse %: 86.79
Execute to Parse %: 40.62Latch Hit %: 99.91
Parse CPU to Parse Elapsd %: 16.89% Non-Parse CPU: 74.91

Shared Pool Statistics

BeginEnd
Memory Usage %: 62.28 49.16
% SQL with executions>1: 31.09 39.06
% Memory for SQL w/exec>1: 54.49 47.51

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
buffer busy waits 15,479 14,216 918 37.2Concurrency
log file switch (checkpoint incomplete) 6,954 5,652 813 14.8Configuration
enq: CI - contention 3,070 5,357 1,745 14.0Other
free buffer waits 358,455 3,989 11 10.4Configuration
log file sync 40,961 2,955 72 7.7Commit

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 34,721.82 90.78
connection management call elapsed time 12,468.18 32.60
parse time elapsed 1,053.92 2.76
DB CPU 644.21 1.68
hard parse elapsed time 518.78 1.36
hard parse (sharing criteria) elapsed time 196.42 0.51
PL/SQL compilation elapsed time 64.58 0.17
PL/SQL execution elapsed time 11.18 0.03
hard parse (bind mismatch) elapsed time 10.19 0.03
failed parse elapsed time 0.58 0.00
repeated bind elapsed time 0.44 0.00
DB time 38,246.67  
background elapsed time 8,670.67  
background cpu time 81.38  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
Concurrency 73,941 51 14,664 198 38.34
Configuration 366,741 98 10,386 28 27.15
Other 309,146 85 7,956 26 20.80
Commit 40,961 56 2,955 72 7.73
Application 6,137 12 2,425 395 6.34
User I/O 137,078 0 1,946 14 5.09
System I/O 43,877   1,897 43 4.96
CPU time     644   1.68
Network 2,248,248   111 0 0.29

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
buffer busy waits 15,479 94 14,216 918 1.02
log file switch (checkpoint incomplete) 6,954 63 5,652 813 0.46
enq: CI - contention 3,070 56 5,357 1745 0.20
free buffer waits 358,455 99 3,989 11 23.56
log file sync 40,961 56 2,955 72 2.69
rdbms ipc reply 4,610 24 2,575 559 0.30
enq: RO - fast object reuse 4,214 17 2,422 575 0.28
db file sequential read 127,150   1,724 14 8.36
log file parallel write 21,561   1,558 72 1.42
enq: HW - contention 158 94 446 2820 0.01
control file parallel write 1,672   333 199 0.11
cursor: pin S wait on X 23,001 100 256 11 1.51
log buffer space 520 11 173 333 0.03
db file scattered read 5,502   133 24 0.36
SQL*Net more data from client 1,605,213   108 0 105.50
latch: shared pool 10,092   105 10 0.66
latch: library cache 7,881   73 9 0.52
direct path sync 1,366   68 50 0.09
undo segment extension 421 99 41 98 0.03
log file switch (private strand flush incomplete) 95 18 37 385 0.01
write complete waits 29 83 26 905 0.00
log file switch completion 87 6 22 247 0.01
enq: CF - contention 24   14 584 0.00
read by other session 199 1 11 57 0.01
library cache load lock 19 16 11 563 0.00
reliable message 2,837 0 7 3 0.19
db file parallel read 96   7 72 0.01
control file sequential read 20,548   5 0 1.35
db file single write 360   3 8 0.02
SQL*Net more data to client 105,697   2 0 6.95
SQL*Net break/reset to client 1,884   2 1 0.12
latch free 211   2 8 0.01
enq: TX - index contention 20   1 58 0.00
log file single write 48   1 19 0.00
latch: row cache objects 115   1 7 0.01
os thread startup 27   1 26 0.00
SQL*Net message to client 537,338   1 0 35.31
kksfbc child completion 9 89 0 44 0.00
LGWR wait for redo copy 873   0 0 0.06
ksdxexeotherwait 260,983 100 0 0 17.15
cursor: pin S 36,206   0 0 2.38
log file sequential read 48   0 3 0.00
enq: TX - allocate ITL entry 21   0 6 0.00
latch: cache buffers chains 130   0 1 0.01
latch: cache buffers lru chain 171   0 1 0.01
enq: PF - contention 4   0 20 0.00
latch: In memory undo latch 17   0 4 0.00
wait list latch free 3   0 12 0.00
row cache lock 61   0 1 0.00
latch: library cache lock 36   0 1 0.00
latch: object queue header operation 68   0 0 0.00
enq: TX - contention 2   0 11 0.00
direct path write 2,367   0 0 0.16
cursor: mutex X 17,062   0 0 1.12
latch: cache buffer handles 1   0 7 0.00
latch: session allocation 18   0 0 0.00
enq: TX - row lock contention 39   0 0 0.00
latch: enqueue hash chains 6   0 1 0.00
kkdlgon 5   0 1 0.00
latch: redo allocation 7   0 0 0.00
latch: messages 8   0 0 0.00
buffer deadlock 30 100 0 0 0.00
latch: library cache pin 1   0 0 0.00
direct path write temp 19   0 0 0.00
direct path read temp 19   0 0 0.00
latch: redo writing 1   0 0 0.00
SQL*Net message from client 538,810   157,204 292 35.41
virtual circuit status 119 100 3,481 29255 0.01
Streams AQ: waiting for messages in the queue 716 97 3,463 4836 0.05
jobq slave wait 1,170 96 3,403 2909 0.08
class slave wait 6   0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 21,562   1,559 72 1.42
events in waitclass Other 1,790 27 1,437 803 0.12
buffer busy waits 753 97 719 955 0.05
enq: HW - contention 129 97 370 2868 0.01
log file switch (checkpoint incomplete) 404 65 357 885 0.03
control file parallel write 1,671   333 199 0.11
enq: RO - fast object reuse 23 61 50 2185 0.00
db file scattered read 2,142   31 15 0.14
db file sequential read 1,126   18 16 0.07
free buffer waits 986 99 11 11 0.06
control file sequential read 18,427   5 0 1.21
db file single write 360   3 8 0.02
latch: shared pool 128   2 15 0.01
latch: library cache 43   1 32 0.00
log file single write 48   1 19 0.00
os thread startup 27   1 26 0.00
log file sequential read 48   0 3 0.00
latch: cache buffers chains 3   0 2 0.00
latch: row cache objects 2   0 0 0.00
latch: redo writing 1   0 0 0.00
rdbms ipc message 42,575 20 24,049 565 2.80
pmon timer 1,527 83 3,478 2277 0.10
smon timer 43   1,923 44727 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 94,387
IDLE_TIME 1,323,430
IOWAIT_TIME 463,145
NICE_TIME 51
SYS_TIME 21,253
USER_TIME 65,747
LOAD 6
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 2,987,253,760
VM_OUT_BYTES 20,419,039,232
PHYSICAL_MEMORY_BYTES 12,128,718,848
NUM_CPUS 4
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 26,995.30 400.70 90,423 18,363,486
orcl 11,267.90 241.10 68,867 9,768,220
SYS$BACKGROUND 0.00 0.00 29,153 207,751
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 77326 1440 63344 12358 0 0 436397 4
orcl 53776 312 8816 1051 0 0 1804811 106
SYS$BACKGROUND 5824 187 1508 1248 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
12,307 0 677 18.18 32.18 54xx5x0knhwut emagent@ts-ora10gr2 (TNS V1-V3) INSERT INTO STATS$USER_LOG VAL...
12,302 1 677 18.17 32.17 7q5gzyfv6df8j emagent@ts-ora10gr2 (TNS V1-V3) BEGIN insert into stats$user_l...
625 3 12,672 0.05 1.63 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...
471 2 7,976 0.06 1.23 8a1pvy4cy8hgv   insert into histgrm$(obj#, int...
470 1 847 0.55 1.23 c92jnm2dx8dzn   INSERT INTO DSSMDOBJINFO VALUE...
453 0 51 8.87 1.18 aq8yqxyyb40nn   update sys.job$ set this_date=...
424 0 2 212.07 1.11 0jjf8qurxs1bb imp.exe DECLARE SREC DBMS_STATS.STATRE...
345 3 1,715 0.20 0.90 1bq4ugqsyghhd   INSERT INTO DSSMDOBJDEPN VALUE...
321 0 15 21.43 0.84 fd9hn33xa7bph   delete from WRI$_ALERT_OUTSTAN...
184 0 1 183.59 0.48 73r3q0kz0csbv   BEGIN UPDATE DSSMDOBJINFO SET ...

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
6 7 2,818 0.00 0.90 0.02 78v7q0w3uhjyu   SELECT /* OPT_DYN_SAMP */ /*+ ...
5 10 1,147 0.00 0.83 0.03 b8wt2n7mpv33q   SELECT OBJECT_ID, OBJECT_TYPE,...
3 3 1 3.29 0.51 0.01 gqnkks4yykvn7 DDTEK ODBC Oracle select pa0.REGION_ID WJXBFS0, ...
3 625 12,672 0.00 0.49 1.63 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...
3 3 2 1.50 0.47 0.01 g1knx73qsrjwm   select a19.QUARTER_ID QUARTER_...
3 345 1,715 0.00 0.43 0.90 1bq4ugqsyghhd   INSERT INTO DSSMDOBJDEPN VALUE...
2 9 95 0.02 0.29 0.02 ft0umzd66g74r   SELECT OBJECT_ID, TRUST_ID, RI...
2 65 4,305 0.00 0.28 0.17 33cmj01uf5zfb   delete from col$ where obj#=:1
2 22 12,947 0.00 0.26 0.06 9hx48pd7ujdxw   SELECT OBJECT_ID, OBJECT_TYPE,...
2 471 7,976 0.00 0.25 1.23 8a1pvy4cy8hgv   insert into histgrm$(obj#, int...

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
410,259 6,368 64.43 1.44 1.55 1.60 bsa0wjtftg3uw   select file# from file$ where ...
280,579 1,715 163.60 0.99 2.75 344.74 1bq4ugqsyghhd   INSERT INTO DSSMDOBJDEPN VALUE...
184,946 2,818 65.63 0.65 5.81 7.15 78v7q0w3uhjyu   SELECT /* OPT_DYN_SAMP */ /*+ ...
135,594 2,885 47.00 0.48 1.47 54.20 68dc1vk9n7n2n   INSERT INTO DSSMDOBJTRNS VALUE...
95,458 1,147 83.22 0.34 5.32 10.34 b8wt2n7mpv33q   SELECT OBJECT_ID, OBJECT_TYPE,...
93,638 12,672 7.39 0.33 3.14 624.73 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...
90,637 12,947 7.00 0.32 1.69 22.22 9hx48pd7ujdxw   SELECT OBJECT_ID, OBJECT_TYPE,...
88,239 95 928.83 0.31 1.88 8.69 ft0umzd66g74r   SELECT OBJECT_ID, TRUST_ID, RI...
87,599 4,305 20.35 0.31 1.80 65.28 33cmj01uf5zfb   delete from col$ where obj#=:1
84,523 7,976 10.60 0.30 1.59 470.97 8a1pvy4cy8hgv   insert into histgrm$(obj#, int...

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
26,348 2 13,174.00 13.97 0.78 32.72 8p23kcbgfqnk4   select file#, block#, ts# from...
2,667 1,222 2.18 1.41 0.84 49.22 4f4y46u98knyg   SELECT OBJECT_ID, DEFINITION, ...
2,550 8,540 0.30 1.35 1.10 96.96 58vnhm5gb5zg7   SELECT OBJECT_ID, DEFINITION, ...
2,181 1,715 1.27 1.16 2.75 344.74 1bq4ugqsyghhd   INSERT INTO DSSMDOBJDEPN VALUE...
1,927 1,094 1.76 1.02 1.31 74.75 8hrh400fdky0h   SELECT DISTINCT dep.DEPN_OBJID...
1,652 27 61.19 0.88 0.19 2.05 4a05x18wmmbx9   SELECT OBJECT_ID, PROPSET_ID, ...
911 25 36.44 0.48 0.72 28.47 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
891 15 59.40 0.47 0.16 3.11 4ausnuwfbf0c8   SELECT OBJECT_ID, DEFINITION, ...
836 2,768 0.30 0.44 0.73 60.36 75kq9j33p4ya5 DDTEK ODBC Oracle INSERT INTO DSSMDJRNOBJS VALUE...
824 2,110 0.39 0.44 0.87 86.61 bgksnz4njw2h7   INSERT INTO DSSMDOBJSECU VALUE...

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
12,947 12,465 0.96 0.00 0.00 9hx48pd7ujdxw   SELECT OBJECT_ID, OBJECT_TYPE,...
12,672 12,672 1.00 0.00 0.05 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...
12,157 0 0.00 0.00 0.00 9y7s2afnkqs9d   delete from idl_ub2$ where obj...
11,180 2 0.00 0.00 0.00 gafuu6h796zbk   SELECT OBJECT_ID, COMMENT_ID, ...
9,806 23,971 2.44 0.00 0.00 0vfhbcpctmxc0   SELECT OBJECT_ID, PROPSET_ID, ...
8,958 1,483 0.17 0.00 0.00 04xtrk7uyhknh   select obj#, type#, ctime, mti...
8,540 10,586 1.24 0.00 0.01 58vnhm5gb5zg7   SELECT OBJECT_ID, DEFINITION, ...
8,054 29,536 3.67 0.00 0.00 01w6sus3yg6yx   SELECT OBJECT_ID, TRUST_ID, RI...
7,976 11,123 1.39 0.00 0.06 8a1pvy4cy8hgv   insert into histgrm$(obj#, int...
7,900 22,756 2.88 0.00 0.00 bhc8mt70sfnq8   SELECT OBJECT_ID, PROPERTY, LO...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
12,672 12,672 2.49 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...
12,157 12,157 2.39 9y7s2afnkqs9d   delete from idl_ub2$ where obj...
7,631 7,631 1.50 gdhz78y24tvnz   delete from ncomp_dll$ where o...
7,628 7,628 1.50 d5jd9b2xct7xz   delete from idl_char$ where ob...
6,368 6,368 1.25 bsa0wjtftg3uw   select file# from file$ where ...
5,218 5,218 1.03 2wdrw5tqputaq   delete from cdef$ where obj#=:...
4,946 8,958 0.97 04xtrk7uyhknh   select obj#, type#, ctime, mti...
4,859 5,865 0.95 5ngzsfstg8tmy   select o.owner#, o.name, o.nam...
4,305 4,305 0.85 33cmj01uf5zfb   delete from col$ where obj#=:1
3,504 3,504 0.69 0h6b2sajwb74n   select privilege#, level from ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
73 361 aa1rjswptawut   SELECT DISTINCT info.OBJECT_ID...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...
67 296 22dd4vsyzpxm0   SELECT PROP_VAL FROM DSSMDSYSP...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
01w6sus3yg6yxSELECT OBJECT_ID, TRUST_ID, RIGHTS FROM DSSMDOBJSECU WHERE PROJECT_ID=:V1 AND OBJECT_ID=:V2 ORDER BY OBJECT_ID ASC
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0jjf8qurxs1bb DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3030353537393532344537343632384545304633363138433330343731434630'; SREC.MAXVAL := '4646374242334338313144353031463043303030353139313642393834393446'; SREC.EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY('005579524E74628EE0F3618C30471CF0', '02E782E94A32292C350870A601462CE6', '03085B6D432DC457F64025828977B412', '0763D59711D4372E100045B835B8F3A4', '0763D5A311D4372E100045B835B8F3A4', '0763D5B011D4372E100045B835B8F3A4', '0763D5B911D4372E100045B835B8F3A4', '0763D5C311D4372E100045B835B8F3A4', '07861D7711D50C21C0005ABE67AA5F4F', '07861DB811D50C21C0005ABE67AA5F4F', '087C289F27A24E929DFF7E879C07D75D', '08A1B5BA11D3E31E100008B827D1E3A4', '0ACE203C11D502C4C0005ABE67AA5F4F', '0ACE27AE11D502C4C0005ABE67AA5F4F', '0ACE2B4311D502C4C0005ABE67AA5F4F', '0ACE2BDA11D502C4C0005ABE67AA5F4F', '0ACE2D5811D502C4C0005ABE67AA5F4F', '0ACE2F7D11D502C4C0005ABE67AA5F4F', '0ACE374711D502C4C0005ABE67AA5F4F', '0ACE3BA311D502C4C0005ABE67AA5F4F', '0FFEBB5A4D9F7CB6C6ACF487E88DB1C6', '10F1143711D4D065B0007AB12AF56BD0', '11597D400E2611D3A00B00C04F8E7129', '11597D410E2611D3A00B00C04F8E7129', '11597D430E2611D3A00B00C04F8E7129', '11597D440E2611D3A00B00C04F8E7129', '11597D460E2611D3A00B00C04F8E7129', '11597D470E2611D3A00B00C04F8E7129', '11597D480E2611D3A00B00C04F8E7129', '11597D490E2611D3A00B00C04F8E7129', '11597D4B0E2611D3A00B00C04F8E7129', '11597D4C0E2611D3A00B00C04F8E7129', '11597D4D0E2611D3A00B00C04F8E7129', '11C3160F44697993F6D55783BBD29491', '12CB615611D456635 000DCA7F26061DA', '14E7DA4F11D44E8A100068B835B8F3A4', '177A899811D4319D10003EB835B8F3A4', '19B6B78C11D438E65000B6A7F26061DA', '1D076B30099F11D4800100C04F780688', '1D076B31099F11D4800100C04F780688', '1D076B32099F11D4800100C04F780688', '1D076B33099F11D4800100C04F780688', '1D076B34099F11D4800100C04F780688', '1D076B36099F11D4800100C04F780688', '1D076B37099F11D4800100C04F780688', '1D076B38099F11D4800100C04F780688', '1D076B39099F11D4800100C04F780688', '1D076B3B099F11D4800100C04F780688', '1D076B3C099F11D4800100C04F780688', '1D076B3D099F11D4800100C04F780688', '1D076B3E099F11D4800100C04F780688', '1D076B3F099F11D4800100C04F780688', '1D10CA0811D3AF381000BCA4A3CAA05A', '21FC03B411D437FA100047B835B8F3A4', '228DA09411D501F8C0005ABE67AA5F4F', '228DA0DE11D501F8C0005ABE67AA5F4F', '228DA12C11D501F8C0005ABE67AA5F4F', '228DA17211D501F8C0005ABE67AA5F4F', '228DBB4311D501F8C0005ABE67AA5F4F', '25B30D4B11D5083FB00064B1362A6ED0', '2883196B11D5119EC0005BBE67AA5F4F', '2ACCBA72CE754A9D8ADEEFEF1A71BF6D', '2B139D3111D67A19B000FBB1A5F27CD0', '2B2F9FD911D4F7B7C0005ABE67AA5F4F', '2CD832554B3B1D271EBF48B6BF4D349E', '2EDC5DCF11D438D65000B6A7F26061DA', '30B1DDF311D467E75000EDA7F26061DA', '30B1E52111D467E75000EDA7F26061DA', '314EE08448022A79CC1F69AE02FCCCCC', '330D294D4C52C13CBC4C2F945145689D', '38F387A18191493D8CBF8861BCAF7D41', '3A7795C2431804353B70C38DF9D52341', '417FA14411D4318D10003EB835B8F3A4', '42B82E0140771C51D19947932549D97C', '43E9808311D43639100043B835B8F3A4', '44B3C31511D51F03C0005CBE67AA5F4F', '44B3D D2F11D51F03C0005CBE67AA5F4F', '44B3DD6C11D51F03C0005CBE67AA5F4F', '44B3DDAD11D51F03C0005CBE67AA5F4F', '492B9B5A11D4316D10003EB835B8F3A4', '492B9DC411D4316D10003EB835B8F3A4', '4DB6351611D753E0B000A4B2A5F27CD0', '4F4111A04EBBC87CB1229797603CBF74', '5475630611D539B4C00053B13632F04F', '571497A211D464B95000ECA7F26061DA', '57173F9611D57AB9C00078B1E8DD3B4F', '580768B340085D85B4D978A46254ED08', '5823004411D431DA10003EB835B8F3A4', '5D1A83AF11D4492A10005DB835B8F3A4', '5E847DBE4782F5CC720093A2782782FE', '6001302011D4FBC4C0005ABE67AA5F4F', '600133D211D4FBC4C0005ABE67AA5F4F', '6001341C11D4FBC4C0005ABE67AA5F4F', '6001347D11D4FBC4C0005ABE67AA5F4F', '600134BF11D4FBC4C0005ABE67AA5F4F', '6001350511D4FBC4C0005ABE67AA5F4F', '6001354B11D4FBC4C0005ABE67AA5F4F', '6124E13C11D5197EC0005CB1498A504F', '63B96B1011D3A6701000B7A4A3CAA05A', '644F964211D485CE50000EA8F26061DA', '644F972611D485CE50000EA8F26061DA', '65EB9DAC11D438E95000B6A7F26061DA', '6738B0E9429FB1D1C92004BE3AABFE5C', '676806284F61982ECCF2BF8945EF5B6B', '68CD44308CF911D5804400C04F780688', '68CD44318CF911D5804400C04F780688', '68CD44328CF911D5804400C04F780688', '68CD44348CF911D5804400C04F780688', '68CD44368CF911D5804400C04F780688', '68CD44378CF911D5804400C04F780688', '68CD44398CF911D5804400C04F780688', '68CD443A8CF911D5804400C04F780688', '68CD443B8CF911D5804400C04F780688', '68CD443C8CF911D5804400C04F780688', '68CD443E8CF911D5804400C04F780688', '68CD443F8CF911D5804400C04F780688', '6ACB3DC611D5AC41C0006BBE67AA5F4F', '6BBD10E240794AF7B7ED1E2AA06F6 460', '6BBD10E250794AF7B7ED1E2AA06F6460', '6BBD10E260794AF7B7ED1E2AA06F6460', '6BBD10E280794AF7B7ED1E2AA06F6460', '6BBD10E2A0794AF7B7ED1E2AA06F6460', '6BBD10E2B0794AF7B7ED1E2AA06F6460', '6BBD10E2C0794AF7B7ED1E2AA06F6460', '6BBD10E2D0794AF7B7ED1E2AA06F6460', '6BBD10E2E0794AF7B7ED1E2AA06F6460', '6BBD10E300794AF7B7ED1E2AA06F6460', '6BBD10E310794AF7B7ED1E2AA06F6460', '6BBD10E320794AF7B7ED1E2AA06F6460', '6BBD10E330794AF7B7ED1E2AA06F6460', '6BBD10E340794AF7B7ED1E2AA06F6460', '6BBD10E3D0794AF7B7ED1E2AA06F6460', '6DDA3F3F11D5126CC0005AB1498A504F', '7216083711D438DC5000B6A7F26061DA', '7331BD1511D4476C100059B835B8F3A4', '7331C6FD11D4476C100059B835B8F3A4', '7331CDEA11D4476C100059B835B8F3A4', '737C5FA3424C802E5D34CAB6C3E23568', '73CE010D11D4389C100048B835B8F3A4', '74E75FB311D50394C0005ABE67AA5F4F', '74E7601D11D50394C0005ABE67AA5F4F', '74E7611211D50394C0005ABE67AA5F4F', '74E761CA11D50394C0005ABE67AA5F4F', '74E762B011D50394C0005ABE67AA5F4F', '74E7635011D50394C0005ABE67AA5F4F', '74E763DF11D50394C0005ABE67AA5F4F', '74E76A8911D50394C0005ABE67AA5F4F', '76F2927C4B80719752592B913FD24FA7', '78288B30EE3411D3BFF900C04F780688', '78288B31EE3411D3BFF900C04F780688', '78288B32EE3411D3BFF900C04F780688', '78288B33EE3411D3BFF900C04F780688', '78288B34EE3411D3BFF900C04F780688', '7E341C5C4021594B7E25AC82CD152105', '7E5571EF11D49615B000619F4E1578D0', '7E55720311D49615B000619F4E1578D0', '7FF6FE1D11D430AC10003DB835B8F3A4', '81CC12ED11D58AB3C00069BE67AA5F4F', '83EBF67911D4835D50000AA8F26061DA', '85FB022511D44DB71 00066B835B8F3A4', '870649A411D3E279100005B827D1E3A4', '87064A7C11D3E279100005B827D1E3A4', '87A6409411D52241C0005EBE67AA5F4F', '87A641C011D52241C0005EBE67AA5F4F', '895972C511D430E910003DB835B8F3A4', '8962389B11D3E3C310000AB827D1E3A4', '8BF73AC94317F191B07BFFA19ACFB817', '8F4068CB4BB538344D42DC9E8EEE3A2F', '930CA0EA11D44C41100062B835B8F3A4', '930CA95611D44C41100062B835B8F3A4', '954D630811D4804550000AA8F26061DA', '9598657311D522F4C0005EBE67AA5F4F', '9598660211D522F4C0005EBE67AA5F4F', '99D8CE4411D53B24500095A7BB3277DA', '99D8D12411D53B24500095A7BB3277DA', '99D8D95411D53B24500095A7BB3277DA', '9A487C7A11D431D510003EB835B8F3A4', '9AEF9DB111D4FC71C0005ABE67AA5F4F', '9B2BA2A242C6F8127C80D9944B255CDA', '9C65F88911D44CEB100064B835B8F3A4', 'A0A9E20F11D54EBAC000E5942CB91B4F', 'A43008FF11D513CEB000A2B12F6D45D0', 'A7B3ECB711D53DB0C000D1942CB91B4F', 'A9D8CF9662B344FD96569DAEC734A467', 'A9D8CF9662B344FD96569DAEC734A468', 'AC29830D11D431C110003EB835B8F3A4', 'AD48CE7E11D3D8E91000E6B727D1E3A4', 'AE833C5511D44B75100060B835B8F3A4', 'B16F8D062E2249A99D5419016AC1D19C', 'B260275C6C7E4A4EABC66D09BCDC8D47', 'B3B97BBE11D3DA761000EBB727D1E3A4', 'B4E14C094C7072700096319235C4E7BF', 'B536164311D3A8131000B8A4A3CAA05A', 'B53617B011D3A8131000B8A4A3CAA05A', 'B6D2F43511D4897C10004F899341E5A4', 'BCEF86C511D3DA6C1000EBB727D1E3A4', 'BD8A5AEB11D4F92CC0005ABE67AA5F4F', 'BD8A5C3C11D4F92CC0005ABE67AA5F4F', 'BD8A5E7611D4F92CC0005ABE67AA5F4F', 'BD8A5EBA11D4F92CC0005ABE67AA5F4F', 'BD8A5EFB11D4F92CC0005ABE67AA5F4F', 'BD8A6 1AB11D4F92CC0005ABE67AA5F4F', 'BD8A64EC11D4F92CC0005ABE67AA5F4F', 'BD8A652A11D4F92CC0005ABE67AA5F4F', 'BD8A65AD11D4F92CC0005ABE67AA5F4F', 'BD8A65EF11D4F92CC0005ABE67AA5F4F', 'BD8A663111D4F92CC0005ABE67AA5F4F', 'BD8A66B811D4F92CC0005ABE67AA5F4F', 'BD8A66F111D4F92CC0005ABE67AA5F4F', 'BD8A672F11D4F92CC0005ABE67AA5F4F', 'BE4D6B4D11D4CADC10004B86B56EF4A4', 'C0E87CA011D447AC100059B835B8F3A4', 'C4E90C0FF7734A978430ADE76D9D486D', 'C5525FAA11D44DEB100067B835B8F3A4', 'C99E901511D43243100040B835B8F3A4', 'CA2768784851D9A0C9498997E27127DB', 'CA578C3811D4B4DD50001FA8F26061DA', 'CC9828C711D3ACB01000BBA4A3CAA05A', 'D215229611D4575AB0002EAA24C812D0', 'D4E5113B41E4C3ABAB092688050DE43A', 'D965020811D3E348100009B827D1E3A4', 'D96502E011D3E348100009B827D1E3A4', 'DC1F8859401C5C76A09AF1A82225E215', 'DC2BCB5111D4572A5000DCA7F26061DA', 'DEEC6E8A11D3A6721000B7A4A3CAA05A', 'E00848554F9EA34916A7D8A541F854C1', 'E1AA0B3011D438C75000B6A7F26061DA', 'E4C4395811D4327D100040B835B8F3A4', 'E4CA16D911D3A6761000B7A4A3CAA05A', 'E502A90F471BA33B5D524388CE06BA64', 'E77F0185C9CD438F981DCBC91DA5CA56', 'E9CDD6C311D3E0B7100001B827D1E3A4', 'F003F93411D467DD5000EDA7F26061DA', 'F003FADF11D467DD5000EDA7F26061DA', 'F19FB03211D43237100040B835B8F3A4', 'F3713C6C11D51FCEC0005CBE67AA5F4F', 'F3713CBB11D51FCEC0005CBE67AA5F4F', 'F4052D5811D3E00B1000FEB727D1E3A4', 'F4759B7CA5844990882789514E7C0DF9', 'F710B97B11D488D2900099B141733F27', 'F710B9A711D488D2900099B141733F27', 'F74C2F6F41A13BEA55A6E5B79338F0EE', 'F83AFC2611D5039C1000F185E8DCC 5A4', 'F913260549D3BFA0F1DE27BC1375F15C', 'FF7BB3C811D501F0C00051916B98494F'); SREC.NOVALS := DBMS_STATS.NUMARRAY(250208020432727000000000000000000000, 250249853522681000000000000000000000, 250268472446805000000000000000000000, 250350075924842000000000000000000000, 250350075924842000000000000000000000, 250350075924842000000000000000000000, 250350075924842000000000000000000000, 250350075924842000000000000000000000, 250350235286723000000000000000000000, 250350235286724000000000000000000000, 250370442492622000000000000000000000, 250371229222846000000000000000000000, 250553935535937000000000000000000000, 250553935535970000000000000000000000, 250553935536022000000000000000000000, 250553935536022000000000000000000000, 250553935536032000000000000000000000, 250553935536041000000000000000000000, 250553935537179000000000000000000000, 250553935537231000000000000000000000, 250655585287871000000000000000000000, 255401662924807000000000000000000000, 255420600938857000000000000000000000, 255420600938857000000000000000000000, 255420600938857000000000000000000000, 255420600938857000000000000000000000, 255420600938857000000000000000000000, 255420600938857000000000000000000000, 255420600938857000000000000000000000, 255420600938857000000000000000000000, 255420600938857000000000000000000000, 255420600938857000000000000000000000, 255420600938857000000000000000000000, 255421708268903000000000000000000000, 255441995326803000000000000000000000, 255482715215000000000000000000000000, 255542456329841000 000000000000000000, 255583889266581000000000000000000000, 255805569960326000000000000000000000, 255805569960326000000000000000000000, 255805569960326000000000000000000000, 255805569960326000000000000000000000, 255805569960326000000000000000000000, 255805569960326000000000000000000000, 255805569960326000000000000000000000, 255805569960326000000000000000000000, 255805569960326000000000000000000000, 255805569960326000000000000000000000, 255805569960326000000000000000000000, 255805569960326000000000000000000000, 255805569960326000000000000000000000, 255805569960326000000000000000000000, 255805647037804000000000000000000000, 260614247762462000000000000000000000, 260633421307813000000000000000000000, 260633421307814000000000000000000000, 260633421307818000000000000000000000, 260633421307818000000000000000000000, 260633421309107000000000000000000000, 260695055536547000000000000000000000, 260755110484890000000000000000000000, 260938528653460000000000000000000000, 260957379993512000000000000000000000, 260957465101899000000000000000000000, 260979169278290000000000000000000000, 261019737504335000000000000000000000, 265785939752272000000000000000000000, 265785939753410000000000000000000000, 265805119158415000000000000000000000, 265845366732560000000000000000000000, 265948516546153000000000000000000000, 266129871049288000000000000000000000, 270997654006092000000000000000000000, 271018803574653000000000000000000000, 271039323985384000000000000000000000, 271059366866902000000000000000000000 , 271059366868191000000000000000000000, 271059366868191000000000000000000000, 271059366868192000000000000000000000, 271159515894577000000000000000000000, 271159515894587000000000000000000000, 271383886329682000000000000000000000, 271423340404753000000000000000000000, 276250792818903000000000000000000000, 276311164372900000000000000000000000, 276311165294172000000000000000000000, 276331368479174000000000000000000000, 276331525690268000000000000000000000, 276574839719825000000000000000000000, 276595672702132000000000000000000000, 281361404200305000000000000000000000, 281361404200319000000000000000000000, 281361404200324000000000000000000000, 281361404200324000000000000000000000, 281361404200324000000000000000000000, 281361404200329000000000000000000000, 281361404200329000000000000000000000, 281381846016454000000000000000000000, 281423680015633000000000000000000000, 281442857257837000000000000000000000, 281442857257841000000000000000000000, 281464485308329000000000000000000000, 281503620936547000000000000000000000, 281503858599302000000000000000000000, 281525174693665000000000000000000000, 281525174693665000000000000000000000, 281525174693665000000000000000000000, 281525174693665000000000000000000000, 281525174693665000000000000000000000, 281525174693665000000000000000000000, 281525174693665000000000000000000000, 281525174693665000000000000000000000, 281525174693665000000000000000000000, 281525174693665000000000000000000000, 281525174693665000000000000000000000, 2815251746936650 00000000000000000000, 281707715759995000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281727919557894000000000000000000000, 281768641907492000000000000000000000, 286594346650046000000000000000000000, 286614785990367000000000000000000000, 286614785991510000000000000000000000, 286614785991576000000000000000000000, 286615108458041000000000000000000000, 286616059808817000000000000000000000, 286636496348099000000000000000000000, 286636496349204000000000000000000000, 286636496349209000000000000000000000, 286636496349209000000000000000000000, 286636496349214000000000000000000000, 286636496349218000000000000000000000, 286636496349219000000000000000000000, 286636496349284000000000000000000000, 286677138852785000000000000000000000, 286716120964519000000000000000000000, 286716120964519000000000000000000000, 286716120964519000000000000000000000, 286716120964519000000000000000000000, 286716120964519000000000000000000000, 286979870271131000000000000000000000, 2869800290441100000000000000000000 00, 286980029044114000000000000000000000, 287001658660189000000000000000000000, 291767791230388000000000000000000000, 291808514221842000000000000000000000, 291849158242596000000000000000000000, 291887976333277000000000000000000000, 291887976333315000000000000000000000, 291889323211997000000000000000000000, 291889323212002000000000000000000000, 291928938225346000000000000000000000, 291929015282305000000000000000000000, 292112826166806000000000000000000000, 292192527535485000000000000000000000, 296999147592376000000000000000000000, 296999147592418000000000000000000000, 297040029620434000000000000000000000, 297040422047436000000000000000000000, 297040422047440000000000000000000000, 297122423211430000000000000000000000, 297122423212544000000000000000000000, 297122423212582000000000000000000000, 297283414823142000000000000000000000, 297284766037118000000000000000000000, 297303541883280000000000000000000000, 297324137188301000000000000000000000, 338478019020601000000000000000000000, 338558036654017000000000000000000000, 338620073259160000000000000000000000, 338660798079713000000000000000000000, 338660798079713000000000000000000000, 338862196364921000000000000000000000, 338882636934748000000000000000000000, 338903234690225000000000000000000000, 343689730786626000000000000000000000, 343710006380244000000000000000000000, 343731242319260000000000000000000000, 343751759933849000000000000000000000, 343770617780264000000000000000000000, 343770617780269000000000000000000000, 34379224585606 9000000000000000000000, 344056002581864000000000000000000000, 344075253474355000000000000000000000, 344075253474364000000000000000000000, 344075253474373000000000000000000000, 344075253474373000000000000000000000, 344075253474374000000000000000000000, 344075253475488000000000000000000000, 344075253475502000000000000000000000, 344075253475507000000000000000000000, 344075253475507000000000000000000000, 344075253475507000000000000000000000, 344075253475511000000000000000000000, 344075253475512000000000000000000000, 344075253475512000000000000000000000, 344075253475516000000000000000000000, 344095219900977000000000000000000000, 348862929323991000000000000000000000, 348944059263428000000000000000000000, 348963071862096000000000000000000000, 349044524298107000000000000000000000, 349206224641420000000000000000000000, 349206462328377000000000000000000000, 349247344362414000000000000000000000, 354094205503903000000000000000000000, 354136354885147000000000000000000000, 354236578509523000000000000000000000, 354236578509524000000000000000000000, 354439011735692000000000000000000000, 354439089739260000000000000000000000, 354481160187338000000000000000000000, 359245859245969000000000000000000000, 359267491314912000000000000000000000, 359328492980327000000000000000000000, 359328497001201000000000000000000000, 359347269452798000000000000000000000, 359388395038254000000000000000000000, 359429910000644000000000000000000000, 364438154578844000000000000000000000, 36443815457888200000000000000000 0000, 364459155917248000000000000000000000, 364499555762901000000000000000000000, 364499555762901000000000000000000000, 364519284812102000000000000000000000, 364519839417693000000000000000000000, 364580209740942000000000000000000000, 364580209740942000000000000000000000, 364580453286363000000000000000000000, 364600655872998000000000000000000000, 364620775469247000000000000000000000, 364884926824674000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 124, 126, 127, 129, 130, 131, 132, 133, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239 , 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254); SREC.EPC := 245; DBMS_STATS.SET_COLUMN_STATS(NULL, '"DSSMDOBJPROP"', '"OBJECT_ID"', NULL , NULL, NULL, 2574, .00143817001722815, 0, srec, 33, 6); END;
0vfhbcpctmxc0SELECT OBJECT_ID, PROPSET_ID, PROP_ID, PROP_VAL, PROP_TYPE FROM DSSMDOBJPROP WHERE PROJECT_ID=:V1 AND OBJECT_ID=:V2 ORDER BY OBJECT_ID ASC, PROPSET_ID ASC, PROP_ID ASC, VALUE_SEQ ASC
1bq4ugqsyghhdINSERT INTO DSSMDOBJDEPN VALUES (:V1, :V2, :V3, :V4, :V5, :V6)
22dd4vsyzpxm0SELECT PROP_VAL FROM DSSMDSYSPROP WHERE NAME=:V1
2wdrw5tqputaqdelete from cdef$ where obj#=:1
33cmj01uf5zfbdelete from col$ where obj#=:1
4a05x18wmmbx9SELECT OBJECT_ID, PROPSET_ID, PROP_ID, PROP_VAL, PROP_TYPE FROM DSSMDOBJPROP WHERE PROJECT_ID=:V1 AND OBJECT_ID IN (:V2, :V3, :V4, :V5, :V6, :V7, :V8, :V9, :V10, :V11, :V12, :V13, :V14, :V15, :V16, :V17, :V18, :V19, :V20, :V21, :V22, :V23, :V24, :V25, :V26, :V27, :V28, :V29, :V30, :V31, :V32, :V33, :V34, :V35, :V36, :V37, :V38, :V39, :V40, :V41, :V42, :V43, :V44, :V45, :V46, :V47, :V48, :V49, :V50, :V51, :V52, :V53, :V54, :V55, :V56, :V57, :V58, :V59, :V60, :V61, :V62, :V63, :V64, :V65, :V66, :V67, :V68, :V69, :V70, :V71, :V72, :V73, :V74, :V75, :V76, :V77, :V78, :V79, :V80, :V81, :V82, :V83, :V84, :V85, :V86, :V87, :V88, :V89, :V90, :V91, :V92, :V93, :V94, :V95, :V96, :V97, :V98, :V99, :V100, :V101, :V102, :V103, :V104, :V105, :V106, :V107, :V108, :V109, :V110, :V111, :V112, :V113, :V114, :V115, :V116, :V117, :V118, :V119, :V120, :V121, :V122, :V123, :V124, :V125, :V126, :V127, :V128, :V129) ORDER BY OBJECT_ID ASC, PROPSET_ID ASC, PROP_ID ASC, VALUE_SEQ ASC
4ausnuwfbf0c8SELECT OBJECT_ID, DEFINITION, DEFINITION_SEQ FROM DSSMDOBJDEF2 WHERE OBJECT_ID IN (:V1, :V2, :V3, :V4, :V5, :V6, :V7, :V8, :V9, :V10, :V11, :V12, :V13, :V14, :V15, :V16, :V17, :V18, :V19, :V20, :V21, :V22, :V23, :V24, :V25, :V26, :V27, :V28, :V29, :V30, :V31, :V32, :V33, :V34, :V35, :V36, :V37, :V38, :V39, :V40, :V41, :V42, :V43, :V44, :V45, :V46, :V47, :V48, :V49, :V50, :V51, :V52, :V53, :V54, :V55, :V56, :V57, :V58, :V59, :V60, :V61, :V62, :V63, :V64, :V65, :V66, :V67, :V68, :V69, :V70, :V71, :V72, :V73, :V74, :V75, :V76, :V77, :V78, :V79, :V80, :V81, :V82, :V83, :V84, :V85, :V86, :V87, :V88, :V89, :V90, :V91, :V92, :V93, :V94, :V95, :V96, :V97, :V98, :V99, :V100, :V101, :V102, :V103, :V104, :V105, :V106, :V107, :V108, :V109, :V110, :V111, :V112, :V113, :V114, :V115, :V116, :V117, :V118, :V119, :V120, :V121, :V122, :V123, :V124, :V125, :V126, :V127, :V128) AND PROJECT_ID=:V129 ORDER BY OBJECT_ID ASC, DEFINITION_SEQ ASC
4f4y46u98knygSELECT OBJECT_ID, DEFINITION, DEFINITION_SEQ FROM DSSMDOBJDEFN WHERE OBJECT_ID=:V1 AND PROJECT_ID=:V2 ORDER BY OBJECT_ID ASC, DEFINITION_SEQ ASC
54xx5x0knhwutINSERT INTO STATS$USER_LOG VALUES( USER, SYS_CONTEXT('USERENV', 'HOST'), SYSDATE )
58vnhm5gb5zg7SELECT OBJECT_ID, DEFINITION, DEFINITION_SEQ FROM DSSMDOBJDEF2 WHERE OBJECT_ID=:V1 AND PROJECT_ID=:V2 ORDER BY OBJECT_ID ASC, DEFINITION_SEQ ASC
5ngzsfstg8tmyselect o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
68dc1vk9n7n2nINSERT INTO DSSMDOBJTRNS VALUES (:V1, :V2, :V3, :V4, :V5)
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
73r3q0kz0csbvBEGIN UPDATE DSSMDOBJINFO SET SUBTYPE=768, VERSION_ID='922D6465413C4F6D1A4B82AC9E0572C1', ABBREVIATION=N'', DESCRIPTION=N'', HIDDEN=0, MOD_TIME=TO_TIMESTAMP('2013-02-06 03:43:14.284', 'YYYY-MM-DD HH24:MI:SS.FF'), OBJECT_STATE=0, LOCALE=1033, EXTENDED_TYPE=1, VIEW_MEDIA=0, ICON_PATH=N'' WHERE OBJECT_ID='99DA215A43B6E58640FDEB833A0BF47B' AND PROJECT_ID='B19DEDCC11D4E0EFC000EB9495D0F44F'; END;
75kq9j33p4ya5INSERT INTO DSSMDJRNOBJS VALUES (:V1, :V2, :V3, :V4)
78v7q0w3uhjyuSELECT /* 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"), COUNT(DISTINCT C4), NVL(SUM(CASE WHEN C4 IS NULL THEN :"SYS_B_03" ELSE :"SYS_B_04" END), :"SYS_B_05") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("DSSMDOBJINFO") FULL("DSSMDOBJINFO") NO_PARALLEL_INDEX("DSSMDOBJINFO") */ :"SYS_B_06" AS C1, CASE WHEN "DSSMDOBJINFO"."OBJECT_TYPE"=:"SYS_B_07" AND ("DSSMDOBJINFO"."PROJECT_ID"=:"SYS_B_08" OR "DSSMDOBJINFO"."PROJECT_ID"=:"SYS_B_09") THEN :"SYS_B_10" ELSE :"SYS_B_11" END AS C2, CASE WHEN "DSSMDOBJINFO"."OBJECT_TYPE"=:"SYS_B_12" THEN :"SYS_B_13" ELSE :"SYS_B_14" END AS C3, "DSSMDOBJINFO"."PARENT_ID" AS C4 FROM "DSSMDOBJINFO" SAMPLE BLOCK (:"SYS_B_15" , :"SYS_B_16") SEED (:"SYS_B_17") "DSSMDOBJINFO") SAMPLESUB
7q5gzyfv6df8jBEGIN insert into stats$user_log values( user, sys_context('USERENV', 'HOST'), sysdate ); END;
8a1pvy4cy8hgvinsert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue) values(:1, :2, :3, :4, :5, :6, :7)
8hrh400fdky0hSELECT DISTINCT dep.DEPN_OBJID, dep.DEPNOBJ_TYPE, info.VERSION_ID, info.OWNER_ID, dep.DEPN_PRJID, info.SUBTYPE, info.PARENT_ID, info.OBJECT_NAME, info.ABBREVIATION, info.DESCRIPTION, info.HIDDEN, info.OBJECT_STATE, info.CREATE_TIME, info.MOD_TIME, info.LOCALE, info.EXTENDED_TYPE, info.VIEW_MEDIA, info.ICON_PATH FROM DSSMDOBJINFO info RIGHT JOIN DSSMDOBJDEPN dep ON info.OBJECT_ID=dep.DEPN_OBJID AND info.PROJECT_ID=dep.DEPN_PRJID WHERE dep.OBJECT_ID=:V1 AND dep.PROJECT_ID IN (:V2, :V3) AND dep.DEPN_PRJID IN (:V4, :V5)
8p23kcbgfqnk4select file#, block#, ts# from seg$ where type# = 3
9hx48pd7ujdxwSELECT OBJECT_ID, OBJECT_TYPE, VERSION_ID, OWNER_ID, PROJECT_ID, SUBTYPE, PARENT_ID, OBJECT_NAME, ABBREVIATION, DESCRIPTION, HIDDEN, OBJECT_STATE, CREATE_TIME, MOD_TIME, LOCALE, EXTENDED_TYPE, VIEW_MEDIA, ICON_PATH FROM DSSMDOBJINFO WHERE PROJECT_ID=:V1 AND OBJECT_ID=:V2
9qgtwh66xg6nzupdate seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
9y7s2afnkqs9ddelete from idl_ub2$ where obj#=:1 and part=:2
aa1rjswptawutSELECT DISTINCT info.OBJECT_ID, info.PROJECT_ID, info.OBJECT_TYPE, COALESCE(otrns.TRANSLATION, info.OBJECT_UNAME) FROM DSSMDOBJINFO info LEFT JOIN DSSMDOBJTRNS otrns ON otrns.PROPERTY=1 AND otrns.LOCALE=1033 AND info.OBJECT_ID=otrns.OBJECT_ID AND info.PROJECT_ID=otrns.PROJECT_ID WHERE info.PROJECT_ID='38A062302D4411D28E71006008960167' AND info.OBJECT_TYPE=51 AND info.OBJECT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') AND info.PARENT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') ORDER BY 4, 1
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
b8wt2n7mpv33qSELECT OBJECT_ID, OBJECT_TYPE, VERSION_ID, OWNER_ID, PROJECT_ID, SUBTYPE, PARENT_ID, OBJECT_NAME, ABBREVIATION, DESCRIPTION, HIDDEN, OBJECT_STATE, CREATE_TIME, MOD_TIME, LOCALE, EXTENDED_TYPE, VIEW_MEDIA, ICON_PATH FROM DSSMDOBJINFO WHERE PROJECT_ID IN (:V1, :V2) AND PARENT_ID=:V3
bgksnz4njw2h7INSERT INTO DSSMDOBJSECU VALUES (:V1, :V2, :V3, :V4, :V5)
bhc8mt70sfnq8SELECT OBJECT_ID, PROPERTY, LOCALE, TRANSLATION FROM DSSMDOBJTRNS WHERE PROJECT_ID=:V1 AND OBJECT_ID=:V2 ORDER BY OBJECT_ID ASC, PROPERTY ASC
bsa0wjtftg3uwselect file# from file$ where ts#=:1
c92jnm2dx8dznINSERT INTO DSSMDOBJINFO VALUES (:V1, :V2, :V3, :V4, :V5, :V6, :V7, :V8, :V9, :V10, :V11, :V12, :V13, UPPER(:V14), :V15, :V16, :V17, :V18, :V19)
d5jd9b2xct7xzdelete from idl_char$ where obj#=:1 and part=:2
fd9hn33xa7bphdelete from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4 returning owner, object_name, subobject_name, sequence_id, error_instance_id, creation_time into :5, :6, :7, :8, :9, :10
ft0umzd66g74rSELECT OBJECT_ID, TRUST_ID, RIGHTS FROM DSSMDOBJSECU WHERE PROJECT_ID IN (:V1, :V2) AND OBJECT_ID IN (:V3, :V4, :V5, :V6, :V7, :V8, :V9, :V10, :V11, :V12, :V13, :V14, :V15, :V16, :V17, :V18, :V19, :V20, :V21, :V22, :V23, :V24, :V25, :V26, :V27, :V28, :V29, :V30, :V31, :V32, :V33, :V34) ORDER BY OBJECT_ID ASC
g1knx73qsrjwm select a19.QUARTER_ID QUARTER_ID, a113.QUARTER_DESC QUARTER_DESC, a14.COUNTRY_ID COUNTRY_ID, a111.COUNTRY_NAME COUNTRY_NAME, a18.CUST_REGION_ID CUST_REGION_ID, a112.CUST_REGION_NAME CUST_REGION_NAME, a13.CATEGORY_ID CATEGORY_ID, a110.CATEGORY_DESC CATEGORY_DESC, sum((a11.QTY_SOLD * (a11.UNIT_PRICE - a11.DISCOUNT))) REVENUE, sum((a11.QTY_SOLD * a11.UNIT_COST)) COST, sum((a11.QTY_SOLD * ((a11.UNIT_PRICE - a11.DISCOUNT) - a11.UNIT_COST))) PROFIT from ORDER_DETAIL a11 join LU_ITEM a12 on (a11.ITEM_ID = a12.ITEM_ID) join LU_SUBCATEG a13 on (a12.SUBCAT_ID = a13.SUBCAT_ID) join LU_EMPLOYEE a14 on (a11.EMP_ID = a14.EMP_ID) join LU_ORDER a15 on (a11.ORDER_ID = a15.ORDER_ID) join LU_CUSTOMER a16 on (a15.CUSTOMER_ID = a16.CUSTOMER_ID) join LU_CUST_CITY a17 on (a16.CUST_CITY_ID = a17.CUST_CITY_ID) join LU_CUST_STATE a18 on (a17.CUST_STATE_ID = a18.CUST_STATE_ID) join LU_DAY a19 on (a11.ORDER_DATE = a19.DAY_DATE) join LU_CATEGORY a110 on (a13.CATEGORY_ID = a110.CATEGORY_ID) join LU_COUNTRY a111 on (a14.COUNTRY_ID = a111.COUNTRY_ID) join LU_CUST_REGION a112 on (a18.CUST_REGION_ID = a112.CUST_REGION_ID) join LU_QUARTER a113 on (a19.QUARTER_ID = a113.QUARTER_ID) group by a19.QUARTER_ID, a113.QUARTER_DESC, a14.COUNTRY_ID, a111.COUNTRY_NAME, a18.CUST_REGION_ID, a112.CUST_REGION_NAME, a13.CATEGORY_ID, a110.CATEGORY_DESC
gafuu6h796zbkSELECT OBJECT_ID, COMMENT_ID, COMMENT_VAL, LOCALE FROM DSSMDOBJCMNT WHERE OBJECT_ID=:V1 AND PROJECT_ID=:V2 ORDER BY OBJECT_ID ASC, COMMENT_ID ASC, LOCALE ASC, COMMENT_SEQ ASC
gdhz78y24tvnzdelete from ncomp_dll$ where obj#=:1 returning dllname into :2
gqnkks4yykvn7select pa0.REGION_ID WJXBFS0, sum(pa2.TOT_DOLLAR_SALES) Column1 from LU_REGION pa0 left outer join STATE_REGION_MNTH_SLS pa1 on (pa0.REGION_ID = pa1.REGION_ID) right outer join STATE_SUBCATEG_REGION_SLS pa2 on ((pa1.REGION_ID = pa2.REGION_ID and pa0.REGION_ID = pa2.REGION_ID)) group by pa0.REGION_ID

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 58,807 16.43 3.86
CPU used when call started 57,938 16.19 3.81
CR blocks created 27,323 7.63 1.80
Cached Commit SCN referenced 396 0.11 0.03
Commit SCN cached 1 0.00 0.00
DB time 4,566,580 1,275.73 300.12
DBWR checkpoint buffers written 478,594 133.70 31.45
DBWR checkpoints 3,261 0.91 0.21
DBWR object drop buffers written 6,639 1.85 0.44
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR thread checkpoint buffers written 262,870 73.44 17.28
DBWR transaction table writes 299 0.08 0.02
DBWR undo block writes 30,957 8.65 2.03
DFO trees parallelized 0 0.00 0.00
IMU CR rollbacks 0 0.00 0.00
IMU Flushes 7,856 2.19 0.52
IMU Redo allocation size 44,409,492 12,406.30 2,918.60
IMU commits 1,107 0.31 0.07
IMU contention 13 0.00 0.00
IMU ktichg flush 683 0.19 0.04
IMU pool not allocated 674 0.19 0.04
IMU recursive-transaction flush 58 0.02 0.00
IMU undo allocation size 62,461,832 17,449.43 4,105.01
IMU- failed to get a private strand 674 0.19 0.04
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
Parallel operations not downgraded 0 0.00 0.00
RowCR - row contention 3 0.00 0.00
RowCR attempts 2,628 0.73 0.17
RowCR hits 2,624 0.73 0.17
SMON posted for dropping temp segment 2 0.00 0.00
SMON posted for undo segment shrink 40 0.01 0.00
SQL*Net roundtrips to/from client 537,285 150.10 35.31
active txn count during cleanout 576,307 161.00 37.88
application wait time 242,443 67.73 15.93
background checkpoints completed 10 0.00 0.00
background checkpoints started 11 0.00 0.00
background timeouts 9,487 2.65 0.62
branch node splits 62 0.02 0.00
buffer is not pinned count 12,274,017 3,428.89 806.65
buffer is pinned count 15,929,158 4,449.99 1,046.87
bytes received via SQL*Net from client 3,317,025,849 926,649.14 217,995.92
bytes sent via SQL*Net to client 325,271,750 90,868.39 21,376.96
calls to get snapshot scn: kcmgss 1,386,332 387.29 91.11
calls to kcmgas 203,368 56.81 13.37
calls to kcmgcs 667,978 186.61 43.90
change write time 22,249 6.22 1.46
cleanout - number of ktugct calls 792,152 221.30 52.06
cleanouts and rollbacks - consistent read gets 4,690 1.31 0.31
cleanouts only - consistent read gets 214,514 59.93 14.10
cluster key scan block gets 127,174 35.53 8.36
cluster key scans 62,111 17.35 4.08
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 51 0.01 0.00
commit batch/immediate requested 51 0.01 0.00
commit cleanout failures: block lost 14,937 4.17 0.98
commit cleanout failures: buffer being written 312 0.09 0.02
commit cleanout failures: callback failure 950 0.27 0.06
commit cleanout failures: cannot pin 164 0.05 0.01
commit cleanouts 730,267 204.01 47.99
commit cleanouts successfully completed 713,904 199.44 46.92
commit immediate performed 51 0.01 0.00
commit immediate requested 51 0.01 0.00
commit txn count during cleanout 224,895 62.83 14.78
concurrency wait time 1,465,784 409.48 96.33
consistent changes 82,199 22.96 5.40
consistent gets 21,021,293 5,872.54 1,381.53
consistent gets - examination 3,101,883 866.55 203.86
consistent gets direct 2 0.00 0.00
consistent gets from cache 21,021,291 5,872.54 1,381.53
current blocks converted for CR 0 0.00 0.00
cursor authentications 9,727 2.72 0.64
data blocks consistent reads - undo records applied 31,682 8.85 2.08
db block changes 6,372,947 1,780.36 418.83
db block gets 7,401,317 2,067.64 486.42
db block gets direct 168,075 46.95 11.05
db block gets from cache 7,233,242 2,020.69 475.37
deferred (CURRENT) block cleanout applications 107,603 30.06 7.07
dirty buffers inspected 318,845 89.07 20.95
enqueue conversions 17,035 4.76 1.12
enqueue releases 448,904 125.41 29.50
enqueue requests 448,913 125.41 29.50
enqueue timeouts 9 0.00 0.00
enqueue waits 4,573 1.28 0.30
exchange deadlocks 30 0.01 0.00
execute count 857,326 239.50 56.34
failed probes on index block reclamation 2 0.00 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 1,574,826 439.95 103.50
free buffer requested 1,318,878 368.44 86.68
heap block compress 8,241 2.30 0.54
hot buffers moved to head of LRU 307,566 85.92 20.21
immediate (CR) block cleanout applications 219,204 61.24 14.41
immediate (CURRENT) block cleanout applications 86,465 24.15 5.68
index crx upgrade (found) 15 0.00 0.00
index crx upgrade (positioned) 94,476 26.39 6.21
index fast full scans (full) 611 0.17 0.04
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 1,000,413 279.48 65.75
index scans kdiixs1 667,291 186.42 43.85
leaf node 90-10 splits 187 0.05 0.01
leaf node splits 4,794 1.34 0.32
lob reads 534 0.15 0.04
lob writes 874 0.24 0.06
lob writes unaligned 874 0.24 0.06
logons cumulative 1,549 0.43 0.10
messages received 64,801 18.10 4.26
messages sent 64,801 18.10 4.26
no buffer to keep pinned count 958 0.27 0.06
no work - consistent read gets 16,792,951 4,691.30 1,103.64
opened cursors cumulative 511,551 142.91 33.62
parse count (failures) 12 0.00 0.00
parse count (hard) 67,235 18.78 4.42
parse count (total) 509,057 142.21 33.46
parse time cpu 16,165 4.52 1.06
parse time elapsed 95,723 26.74 6.29
physical read IO requests 132,622 37.05 8.72
physical read bytes 1,545,314,304 431,701.24 101,558.51
physical read total IO requests 153,773 42.96 10.11
physical read total bytes 1,886,024,192 526,882.45 123,950.07
physical read total multi block requests 5,537 1.55 0.36
physical reads 188,637 52.70 12.40
physical reads cache 188,046 52.53 12.36
physical reads cache prefetch 55,808 15.59 3.67
physical reads direct 591 0.17 0.04
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 589 0.16 0.04
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 526,535 147.09 34.60
physical write bytes 7,290,355,712 2,036,644.32 479,124.32
physical write total IO requests 543,305 151.78 35.71
physical write total bytes 18,731,837,952 5,232,953.35 1,231,061.91
physical write total multi block requests 104,914 29.31 6.89
physical writes 889,936 248.61 58.49
physical writes direct 168,663 47.12 11.08
physical writes direct (lob) 2 0.00 0.00
physical writes direct temporary tablespace 589 0.16 0.04
physical writes from cache 721,273 201.50 47.40
physical writes non checkpoint 853,119 238.33 56.07
pinned buffers inspected 95 0.03 0.01
pinned cursors current 8 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 3,040 0.85 0.20
process last non-idle time 3,579 1.00 0.24
queries parallelized 0 0.00 0.00
recursive calls 4,291,963 1,199.01 282.07
recursive cpu usage 29,214 8.16 1.92
redo blocks written 11,090,669 3,098.31 728.88
redo buffer allocation retries 903 0.25 0.06
redo entries 4,583,509 1,280.46 301.23
redo log space requests 7,184 2.01 0.47
redo log space wait time 584,484 163.28 38.41
redo ordering marks 90,774 25.36 5.97
redo size 5,495,115,132 1,535,123.31 361,140.58
redo subscn max counts 757,193 211.53 49.76
redo synch time 303,302 84.73 19.93
redo synch writes 18,166 5.07 1.19
redo wastage 6,313,404 1,763.72 414.92
redo write time 159,700 44.61 10.50
redo writer latching time 9 0.00 0.00
redo writes 21,559 6.02 1.42
rollback changes - undo records applied 1,253 0.35 0.08
rollbacks only - consistent read gets 22,364 6.25 1.47
root node splits 1 0.00 0.00
rows fetched via callback 242,010 67.61 15.90
session connect time 0 0.00 0.00
session cursor cache hits 223,571 62.46 14.69
session logical reads 28,422,582 7,940.17 1,867.94
shared hash latch upgrades - no wait 107,784 30.11 7.08
shared hash latch upgrades - wait 18 0.01 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 191,063 53.38 12.56
sorts (rows) 45,809,685 12,797.46 3,010.63
sql area evicted 62,718 17.52 4.12
sql area purged 2,921 0.82 0.19
summed dirty queue length 5,153,280 1,439.63 338.68
switch current to new buffer 5,627 1.57 0.37
table fetch by rowid 12,454,023 3,479.17 818.48
table fetch continued row 1,278 0.36 0.08
table scan blocks gotten 3,162,151 883.38 207.82
table scan rows gotten 127,549,244 35,632.34 8,382.57
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 40 0.01 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 60,388 16.87 3.97
total number of times SMON posted 45 0.01 0.00
transaction rollbacks 51 0.01 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 278,926,268 77,921.25 18,331.12
user I/O wait time 195,036 54.49 12.82
user calls 542,095 151.44 35.63
user commits 13,057 3.65 0.86
user rollbacks 2,159 0.60 0.14
workarea executions - onepass 4 0.00 0.00
workarea executions - optimal 85,599 23.91 5.63
write clones created in background 5 0.00 0.00
write clones created in foreground 528 0.15 0.03

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 21,050,786,440 21,197,873,512
session cursor cache count 658,519 667,866
session uga memory 2.6E+13 2.6E+13
opened cursors current 1,538 1,070
workarea memory allocated 341 6,885
logons current 121 120
session uga memory max 75,610,842,448 76,725,662,728
session pga memory 10,817,585,128 10,912,422,952

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 11 11.06

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)
USER_DATA 111,398 31 11.87 1.26 509,529 142 177 59.49
SYSTEM 18,543 5 21.75 2.40 5,068 1 12,622 961.78
UNDOTBS1 15 0 0.00 1.00 10,983 3 2,874 843.03
SYSAUX 2,443 1 54.27 1.02 954 0 2 0.00
TEMPORARY_DATA 19 0 1.05 31.00 19 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 /dbdata/oradata/orcl/sysaux01.dbf 2,443 1 54.27 1.02 954 0 2 0.00
SYSTEM /dbdata/oradata/orcl/system01.dbf 18,543 5 21.75 2.40 5,068 1 12,622 961.78
TEMPORARY_DATA /dbdata/oradata/orcl/temp01.dbf 19 0 1.05 31.00 19 0 0  
UNDOTBS1 /dbdata/oradata/orcl/undotbs01.dbf 15 0 0.00 1.00 10,983 3 2,874 843.03
USER_DATA /dbdata/oradata/orcl/useres02.dbf 866 0 9.98 1.42 12,862 4 0 0.00
USER_DATA /dbdata/oradata/orcl/useres03.dbf 836 0 12.20 1.35 9,246 3 5 16.00
USER_DATA /dbdata/oradata/orcl/useres04.dbf 596 0 21.33 2.25 3,887 1 0 0.00
USER_DATA /dbdata/oradata/orcl/useres05.dbf 352 0 12.59 2.59 3,238 1 0 0.00
USER_DATA /dbdata/oradata/orcl/useres06.dbf 332 0 18.83 1.71 24,477 7 0 0.00
USER_DATA /dbdata/oradata/orcl/useres07.dbf 370 0 21.00 2.30 6,541 2 3 23.33
USER_DATA /dbdata/oradata/orcl/useres08.dbf 574 0 9.60 1.65 6,560 2 3 10.00
USER_DATA /dbdata/oradata/orcl/useres09.dbf 1,040 0 4.03 1.31 11,630 3 2 45.00
USER_DATA /dbdata/oradata/orcl/useres10.dbf 8,761 2 3.77 1.24 20,322 6 0 0.00
USER_DATA /dbdata/oradata/orcl/useres11.dbf 8,348 2 4.04 1.30 23,787 7 15 1.33
USER_DATA /dbdata/oradata/orcl/useres12.dbf 4,447 1 3.69 1.52 16,560 5 0 0.00
USER_DATA /dbdata/oradata/orcl/useres13.dbf 1,741 0 7.59 1.68 6,311 2 0 0.00
USER_DATA /dbdata/oradata/orcl/useres14.dbf 1,883 1 4.21 1.55 3,671 1 0 0.00
USER_DATA /dbdata/oradata/orcl/useres15.dbf 1,593 0 6.11 1.38 20,256 6 0 0.00
USER_DATA /dbdata/oradata/orcl/useres16.dbf 3,461 1 17.90 1.06 24,819 7 0 0.00
USER_DATA /dbdata/oradata/orcl/useres17.dbf 5,380 2 20.33 1.13 18,621 5 6 6.67
USER_DATA /dbdata/oradata/orcl/useres18.dbf 4,490 1 21.48 1.10 15,481 4 4 10.00
USER_DATA /dbdata/oradata/orcl/useres19.dbf 2,451 1 27.85 1.13 14,259 4 10 48.00
USER_DATA /dbdata/oradata/orcl/useres20.dbf 3,302 1 17.12 1.13 14,339 4 9 214.44
USER_DATA /dbdata/oradata/orcl/useres21.dbf 2,418 1 22.10 1.65 11,842 3 3 20.00
USER_DATA /dbdata/oradata/orcl/useres22.dbf 2,523 1 21.60 1.56 23,421 7 8 12.50
USER_DATA /dbdata/oradata/orcl/useres23.dbf 5,336 1 9.59 1.11 13,934 4 4 25.00
USER_DATA /dbdata/oradata/orcl/useres24.dbf 4,803 1 14.26 1.33 14,103 4 15 23.33
USER_DATA /dbdata/oradata/orcl/useres26.dbf 2,920 1 20.94 1.53 10,408 3 38 123.68
USER_DATA /dbdata/oradata/orcl/useres27.dbf 14,835 4 9.14 1.22 32,455 9 40 51.75
USER_DATA /dbdata/oradata/orcl/useres28.dbf 10,162 3 9.15 1.11 21,338 6 3 0.00
USER_DATA /dbdata/oradata/orcl/useres29.dbf 4,041 1 17.08 1.30 15,631 4 0 0.00
USER_DATA /dbdata/oradata/orcl/useres30.dbf 5,465 2 6.73 1.11 20,356 6 2 110.00
USER_DATA /dbdata/oradata/orcl/useres31.dbf 2,973 1 10.17 1.21 16,600 5 7 21.43
USER_DATA /dbdata/oradata/orcl/useres32.dbf 1,201 0 25.35 1.15 12,832 4 0 0.00
USER_DATA /dbdata/oradata/orcl/useres33.dbf 1,001 0 23.95 1.14 15,958 4 0 0.00
USER_DATA /dbdata/oradata/orcl/useres34.dbf 1,564 0 21.09 1.00 19,401 5 0 0.00
USER_DATA /dbdata/oradata/orcl/users01.dbf 1,333 0 11.65 1.28 24,383 7 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 412,567 99 28,238,713 188,080 721,383 358399 85 15,678


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 119 9118 113640 1843200 1843200 3663466  
E 0 712 89549 1655695 1843200 1843200 4081892  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 320 0.10 39,580 2.11 24,556,659
D 640 0.19 79,160 1.77 20,622,042
D 960 0.29 118,740 1.51 17,627,260
D 1,280 0.38 158,320 1.33 15,562,552
D 1,600 0.48 197,900 1.21 14,145,241
D 1,920 0.57 237,480 1.13 13,216,537
D 2,240 0.67 277,060 1.08 12,608,426
D 2,560 0.77 316,640 1.05 12,199,885
D 2,880 0.86 356,220 1.02 11,921,420
D 3,200 0.96 395,800 1.01 11,726,939
D 3,344 1.00 413,611 1.00 11,659,934
D 3,520 1.05 435,380 0.99 11,577,983
D 3,840 1.15 474,960 0.98 11,451,905
D 4,160 1.24 514,540 0.97 11,335,514
D 4,480 1.34 554,120 0.96 11,217,860
D 4,800 1.44 593,700 0.95 11,093,435
D 5,120 1.53 633,280 0.94 10,960,269
D 5,440 1.63 672,860 0.93 10,828,128
D 5,760 1.72 712,440 0.92 10,698,653
D 6,080 1.82 752,020 0.91 10,568,142
D 6,400 1.91 791,600 0.89 10,433,877

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
99.69 14,941 47

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 788 637 185.89 0.52 0.28 100.00 0.00 102,400
E 788 641 192.84 0.34 0.18 100.00 0.00 102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 65,477 65,477 0 0
64K 128K 2,993 2,993 0 0
128K 256K 1,749 1,749 0 0
256K 512K 1,977 1,977 0 0
512K 1024K 12,018 12,018 0 0
1M 2M 879 879 0 0
2M 4M 292 292 0 0
4M 8M 140 138 2 0
8M 16M 58 58 0 0
16M 32M 26 24 2 0
32M 64M 13 13 0 0
64M 128M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
99 0.13 1,038,084.24 24,903.28 98.00 73
197 0.25 1,038,084.24 13,051.79 99.00 0
394 0.50 1,038,084.24 1,462.88 100.00 0
591 0.75 1,038,084.24 1,363.17 100.00 0
788 1.00 1,038,084.24 1,251.26 100.00 0
946 1.20 1,038,084.24 1,189.97 100.00 0
1,103 1.40 1,038,084.24 1,189.97 100.00 0
1,261 1.60 1,038,084.24 1,189.97 100.00 0
1,418 1.80 1,038,084.24 1,189.97 100.00 0
1,576 2.00 1,038,084.24 1,189.97 100.00 0
2,364 3.00 1,038,084.24 1,189.97 100.00 0
3,152 4.00 1,038,084.24 1,189.97 100.00 0
4,728 6.00 1,038,084.24 1,189.97 100.00 0
6,304 8.00 1,038,084.24 1,189.97 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)
960 0.37 290 32,328 3,807,100 0.99 95,460 2.55 109,640
1,232 0.48 560 54,393 3,821,802 0.99 80,758 2.16 110,364
1,504 0.58 831 74,122 3,835,348 0.99 67,212 1.80 111,053
1,776 0.69 1,102 93,717 3,846,698 1.00 55,862 1.49 111,669
2,048 0.79 1,372 111,142 3,855,159 1.00 47,401 1.27 112,178
2,320 0.90 1,643 136,313 3,861,074 1.00 41,486 1.11 112,579
2,592 1.00 1,914 169,313 3,865,188 1.00 37,372 1.00 112,890
2,864 1.10 2,185 190,360 3,868,072 1.00 34,488 0.92 113,131
3,136 1.21 2,456 207,374 3,870,124 1.00 32,436 0.87 113,322
3,408 1.31 2,727 225,356 3,871,617 1.00 30,943 0.83 113,476
3,680 1.42 2,998 243,818 3,872,728 1.00 29,832 0.80 113,603
3,952 1.52 3,269 264,231 3,873,579 1.00 28,981 0.78 113,708
4,224 1.63 3,540 283,603 3,874,252 1.00 28,308 0.76 113,798
4,496 1.73 3,811 304,826 3,874,800 1.00 27,760 0.74 113,878
4,768 1.84 4,082 324,956 3,875,259 1.00 27,301 0.73 113,948
5,040 1.94 4,353 340,366 3,875,651 1.00 26,909 0.72 114,012
5,312 2.05 4,624 361,233 3,875,991 1.00 26,569 0.71 114,069

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,500 0.25 472,506 24,014,112
3,000 0.50 378,715 15,218,964
4,500 0.75 331,582 12,924,578
6,000 1.00 317,182 11,658,468
7,500 1.25 311,124 11,403,148
9,000 1.50 306,622 10,589,386
10,500 1.75 302,213 10,203,491
12,000 2.00 300,468 10,203,491

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
16 1.00 0 0 0 0
32 2.00 0 0 0 0
48 3.00 0 0 0 0
64 4.00 0 0 0 0
80 5.00 0 0 0 0
96 6.00 0 0 0 0
112 7.00 0 0 0 0
128 8.00 0 0 0 0
144 9.00 0 0 0 0
160 10.00 0 0 0 0
176 11.00 0 0 0 0
192 12.00 0 0 0 0
208 13.00 0 0 0 0
224 14.00 0 0 0 0
240 15.00 0 0 0 0
256 16.00 0 0 0 0
272 17.00 0 0 0 0
288 18.00 0 0 0 0
304 19.00 0 0 0 0
320 20.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 12,800 12,151 949
file header block 2,317 2,259 975
undo header 227 164 722
undo block 333 0 1
segment header 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
CI-Cross-Instance Call Invocation 6,912 6,912 0 1,332 5,489 4,120.71
RO-Multiple Object Reuse (fast object reuse) 29,241 29,241 0 3,135 2,483 792.15
HW-Segment High Water Mark 14,049 14,049 0 8 456 57,017.50
CF-Controlfile Transaction 6,134 6,134 0 12 14 1,196.67
TX-Transaction (index contention) 20 20 0 20 1 59.00
TX-Transaction (allocate ITL entry) 22 22 0 21 0 5.71
PF-Password File 21 21 0 4 0 22.50
TX-Transaction 59,379 59,377 0 1 0 20.00
TX-Transaction (row lock contention) 39 39 0 39 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 52.98 70,076 537 18 15/19 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
05-Feb 23:04 22,682 14,584 0 8 15 0/0 0/0/0/0/0/0
05-Feb 22:54 7,100 13,390 31 8 15 0/0 0/0/0/0/0/0
05-Feb 22:44 3,122 4,259 281 14 15 0/0 0/0/0/0/0/0
05-Feb 22:34 5,591 10,948 170 12 17 0/0 0/0/0/0/0/0
05-Feb 22:24 5,151 7,384 537 15 19 0/0 0/0/0/0/0/0
05-Feb 22:14 5,599 8,133 238 18 15 0/0 0/0/0/0/0/0
05-Feb 22:04 3,738 11,378 0 6 15 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 14,956 0.00   0 0  
AWR Alerted Metric Element list 19,747 0.00   0 0  
Consistent RBA 21,574 0.00   0 0  
FIB s.o chain latch 58 0.00   0 0  
FOB s.o list latch 4,047 0.02 0.00 0 0  
In memory undo latch 74,191 0.02 0.94 0 10,944 0.01
JS mem alloc latch 16 0.00   0 0  
JS queue access latch 16 0.00   0 0  
JS queue state obj latch 25,738 0.00   0 0  
KMG MMAN ready and startup request latch 1,187 0.00   0 0  
KMG resize request state object freelist 8 0.00   0 0  
KTF sga latch 9 0.00   0 1,069 0.00
KWQMN job cache list latch 58 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 64 0.00
Memory Management Latch 80 0.00   0 1,187 0.00
OS process 4,659 0.00   0 0  
OS process allocation 4,294 0.05 0.00 0 0  
OS process: request allocation 2,998 0.10 0.00 0 0  
PL/SQL warning settings 50,806 0.00   0 0  
SGA IO buffer pool latch 3,353 0.00   0 4,283 0.00
SQL memory manager latch 1 0.00   0 1,074 0.00
SQL memory manager workarea list latch 133,350 0.00   0 0  
Shared B-Tree 13 0.00   0 0  
active checkpoint queue latch 63,753 0.02 0.07 0 0  
active service list 12,219 0.02 0.00 0 5,703 0.00
archive control 34 0.00   0 0  
begin backup scn array 29,604 0.00 0.00 0 0  
buffer pool 840 0.00   0 0  
cache buffer handles 901,392 0.02 0.01 0 0  
cache buffers chains 68,694,491 0.00 0.05 0 1,810,354 0.01
cache buffers lru chain 1,903,564 0.40 0.02 0 1,159,702 0.50
cache table scan latch 0     0 5,502 0.00
channel handle pool latch 3,055 0.03 0.00 0 0  
channel operations parent latch 88,839 0.01 0.14 0 0  
checkpoint queue latch 1,040,677 0.00 0.00 0 798,308 0.03
client/application info 5,571 0.00   0 0  
commit callback allocation 11,514 0.01 1.00 0 0  
compile environment latch 1,552 0.00   0 0  
dictionary lookup 4,990 0.00   0 0  
dml lock allocation 376,339 0.04 0.05 0 0  
dummy allocation 3,106 0.16 0.00 0 0  
enqueue hash chains 926,468 0.03 0.02 0 6,384 0.00
enqueues 474,119 0.04 0.04 0 0  
event group latch 1,499 0.00   0 0  
file cache latch 12,948 0.01 0.00 0 0  
global KZLD latch for mem in SGA 1,491 0.00   0 0  
hash table column usage latch 7,442 0.03 0.00 0 1,501,669 0.00
hash table modification latch 692 0.00   0 0  
interrupt manipulation 75 0.00   0 0  
job workq parent latch 0     0 114 0.00
job_queue_processes parameter latch 116 0.00   0 0  
kks stats 340,523 0.03 0.14 0 0  
kokc descriptor allocation latch 158,678 0.00   0 0  
ksuosstats global area 201 0.00   0 0  
ktm global data 158 0.00   0 0  
kwqbsn:qsga 12 0.00   0 0  
lgwr LWN SCN 21,845 0.00   0 0  
library cache 4,810,923 0.57 0.29 73 251,627 276.03
library cache load lock 22,863 0.03 0.00 0 229 0.00
library cache lock 6,060,600 0.05 0.01 0 0  
library cache lock allocation 35,372 0.01 0.25 0 0  
library cache pin 1,325,919 0.01 0.01 0 0  
library cache pin allocation 3,959 0.03 0.00 0 0  
list of block allocation 54,354 0.02 0.73 0 0  
loader state object freelist 4,648 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 4 0.00   0 4 0.00
message pool operations parent latch 9,747 0.01 0.00 0 0  
messages 209,524 0.10 0.04 0 0  
mostly latch-free SCN 21,877 0.02 0.00 0 0  
multiblock read objects 107,136 0.00   0 0  
ncodef allocation latch 306 0.00   0 0  
object queue header heap 89,199 0.00 0.00 0 13,334 0.00
object queue header operation 4,138,018 0.06 0.03 0 0  
object stats modification 4,083 0.02 0.00 0 0  
parallel query alloc buffer 460 0.00   0 0  
parameter list 988 0.00   0 0  
parameter table management 3,263 0.00   0 0  
post/wait queue 793,561 0.14 0.00 0 48,655 0.02
process allocation 2,998 3.74 1.08 1 1,495 0.27
process group creation 2,998 0.03 0.00 0 0  
redo allocation 95,317 0.12 0.06 0 4,582,879 0.09
redo copy 0     0 4,583,525 0.03
redo writing 115,433 0.15 0.01 0 0  
resmgr group change latch 997 0.00   0 0  
resmgr:active threads 3,090 0.00   0 0  
resmgr:actses change group 682 0.00   0 0  
resmgr:free threads list 3,089 0.29 0.11 0 0  
resmgr:resource group CPU method 682 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 7,585,520 0.08 0.02 1 14,957 0.32
rules engine aggregate statistics 29 0.00   0 0  
rules engine rule set statistics 158 0.00   0 0  
sequence cache 4,941 0.45 0.00 0 0  
session allocation 189,541 0.10 0.09 0 0  
session idle bit 1,156,663 0.01 0.05 0 0  
session state list latch 3,152 0.25 0.13 0 0  
session switching 7,801 0.03 0.00 0 0  
session timer 1,313 0.00   0 0  
shared pool 4,681,330 1.08 0.20 105 0  
shared pool simulator 525,019 0.01 0.04 0 0  
simulator hash latch 2,742,192 0.00 0.05 0 0  
simulator lru latch 721,550 0.03 0.02 0 1,918,300 0.09
slave class 8 0.00   0 0  
slave class create 32 3.13 1.00 0 0  
sort extent pool 4,655 0.06 0.00 0 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  
temporary table state object allocation 41 0.00   0 0  
threshold alerts latch 168 0.00   0 0  
transaction allocation 6,254 0.02 0.00 0 0  
transaction branch allocation 1,313 0.00   0 0  
undo global data 1,035,720 0.01 0.00 0 0  
user lock 22,339 0.28 0.43 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
shared pool 4,681,330 50,540 10,093 41,326 0 0 0
library cache 4,810,923 27,187 7,881 21,416 0 0 0
cache buffers lru chain 1,903,564 7,591 171 7,425 0 0 0
row cache objects 7,585,520 5,907 115 5,799 0 0 0
library cache lock 6,060,600 2,749 36 2,713 0 0 0
object queue header operation 4,138,018 2,404 68 2,338 0 0 0
cache buffers chains 68,694,491 2,376 130 2,252 0 0 0
post/wait queue 793,561 1,113 5 1,108 0 0 0
enqueue hash chains 926,468 301 6 295 0 0 0
messages 209,524 210 8 202 0 0 0
simulator lru latch 721,550 209 4 205 0 0 0
enqueues 474,119 201 8 193 0 0 0
cache buffer handles 901,392 195 1 194 0 0 0
session allocation 189,541 194 18 177 0 0 0
redo writing 115,433 176 1 175 0 0 0
dml lock allocation 376,339 163 8 156 0 0 0
library cache pin 1,325,919 150 1 149 0 0 0
kks stats 340,523 119 17 102 0 0 0
redo allocation 95,317 119 7 112 0 0 0
process allocation 2,998 112 121 6 0 0 0
user lock 22,339 63 27 36 0 0 0
session idle bit 1,156,663 58 3 56 0 0 0
simulator hash latch 2,742,192 38 2 36 0 0 0
shared pool simulator 525,019 27 1 26 0 0 0
In memory undo latch 74,191 18 17 1 0 0 0
active checkpoint queue latch 63,753 15 1 14 0 0 0
list of block allocation 54,354 11 8 3 0 0 0
resmgr:free threads list 3,089 9 1 8 0 0 0
session state list latch 3,152 8 1 7 0 0 0
channel operations parent latch 88,839 7 1 6 0 0 0
library cache lock allocation 35,372 4 1 3 0 0 0
commit callback allocation 11,514 1 1 0 0 0 0
slave class create 32 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch ktiFlush: child 0 9 9
In memory undo latch kticmt: child 0 9 8
active checkpoint queue latch kcbo_add_ckpt: Add last obj ckpt 0 1 0
cache buffer handles kcbzgs 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 117 77
cache buffers chains kcbgtcr: fast path 0 38 4
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 34 50
cache buffers chains kcbzwb 0 17 15
cache buffers chains kcbgcur: kslbegin 0 16 9
cache buffers chains kcbzgb: exit_loop 0 16 13
cache buffers chains kcbrls: kslbegin 0 15 60
cache buffers chains kcbzgb: scan from tail. nowait 0 14 0
cache buffers chains kcbget: pin buffer 0 12 10
cache buffers chains kcbget: exchange rls 0 2 1
cache buffers chains kcbnew: new latch again 0 2 0
cache buffers chains kcbnlc 0 2 7
cache buffers chains kcbchg: kslbegin: call CR func 0 1 34
cache buffers chains kcbget: exchange 0 1 4
cache buffers chains kcbget: in cur_read 0 1 0
cache buffers chains kcbgtcr: kslbegin shared 0 1 1
cache buffers lru chain kcbzgws 0 118 23
cache buffers lru chain kcbzgb: posted for free bufs 0 23 32
cache buffers lru chain kcbbxsv: move to being written 0 11 68
cache buffers lru chain kcbo_link_q 0 7 1
cache buffers lru chain kcbbic2 0 5 41
cache buffers lru chain kcbbwlru 0 5 3
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 1 0
cache buffers lru chain kcbzgm 0 1 0
channel operations parent latch ksrchdelete() 0 1 1
channel operations parent latch ksrmfree() 0 1 0
commit callback allocation ktccaco 0 1 0
cost function kzulgt: find user res 0 17 19
cost function kzulrl 0 10 8
dml lock allocation ktaiam 0 7 8
dml lock allocation ktaidm 0 1 0
enqueue hash chains ksqcnl 0 3 0
enqueue hash chains ksqgtl3 0 2 1
enqueue hash chains ksqrcl 0 1 4
enqueues ksqgel: create enqueue 0 4 2
enqueues ksqdel 0 3 4
enqueues ksqies 0 1 2
event range base latch No latch 0 14 13
hash table column usage latch KSXMMON_GETCELEM 0 1 0
kks stats kks stats alloc/free 0 17 17
library cache kglobpn: child: 0 379 372
library cache kglpndl: child: after processing 0 362 42
library cache kglhdiv: child 0 171 4
library cache kglLockCursor 0 167 93
library cache kglivl: child 0 149 3
library cache kgldte: child 0 0 126 490
library cache kglhdgn: child: 0 116 655
library cache kgldti: 2child 0 109 49
library cache kglpin 0 86 64
library cache kglukp: child 0 70 138
library cache kglpndl: child: before processing 0 39 208
library cache kglrtl 0 39 16
library cache kglic 0 31 0
library cache kglhdgc: child: 0 30 29
library cache kglati 0 21 0
library cache kglnti 0 20 1
library cache kglpnp: child 0 16 37
library cache kglobld 0 13 82
library cache kgldrp: child 0 12 1
library cache kglScanDependency 0 9 0
library cache kglprg: child 0 9 28
library cache kglhdiv0: child 0 6 2
library cache kgldtld: 2child 0 3 2
library cache kglgfc: child 0 3 5
library cache kglpin: child: KGLMX 0 3 3
library cache kglhdbrnl: child 0 1 2
library cache kglivr: child 0 1 0
library cache kglpim 0 1 0
library cache kglupd: child 0 1 0
library cache lock kgllkdl: child: no lock handle 0 312 339
library cache lock kgllkdl: child: cleanup 0 15 11
library cache lock kgllkal: child: multiinstance 0 7 11
library cache lock allocation kgllkget 0 1 1
library cache pin kglpndl 0 1 1
list of block allocation ktlabl 0 8 7
messages ksarcv 0 4 3
messages ksaamb: after wakeup 0 3 1
messages ksarcr: inside loop 0 1 0
object queue header operation kcbw_unlink_q 0 90 9
object queue header operation kcbo_switch_cq 0 46 108
object queue header operation kcbw_link_q 0 26 6
object queue header operation kcbo_switch_q_bg 0 10 23
object queue header operation kcbo_switch_mq_bg 0 4 27
object queue header operation kcbo_swap_buf 0 2 1
object queue header operation kcbo_swap_buf_bg 0 2 3
object queue header operation kcbo_write_q 0 1 0
post/wait queue ksliwat:add:wait 0 3 3
post/wait queue ksliwat:remove 0 2 2
process allocation ksucrp 0 73 0
process allocation ksudlp 0 33 19
process allocation ksuapc 0 15 102
redo allocation kcrfw_redo_gen: redo allocation 1 0 6 0
redo allocation kcrfw_redo_write: before write 0 1 3
redo writing kcrfw_cal_target_rba 0 1 0
resmgr:free threads list kgskthrcreate 0 1 1
row cache objects kqreqd: reget 0 57 3
row cache objects kqrpre: find obj 0 25 64
row cache objects kqrso 0 8 1
row cache objects kqrcmt: while loop 0 4 10
row cache objects kqreqd 0 4 4
row cache objects kqrpup 0 1 3
session allocation ksuxds: KSUSFCLC not set 0 8 4
session allocation ksuxds: not user session 0 5 6
session allocation ksucri 0 2 5
session allocation ksucrp 0 2 1
session allocation kspallmod 0 1 0
session idle bit ksupuc: set busy 0 2 3
session idle bit ksupuc: clear busy 0 1 0
session idle bit ksuxds 0 1 1
session state list latch kpseqd 0 1 0
shared pool kghfrunp: clatch: wait 0 4,059 5,217
shared pool kghalo 0 3,924 2,818
shared pool kghfrunp: alloc: wait 0 3,883 3,539
shared pool kghfrunp: clatch: nowait 0 1,508 0
shared pool kghupr1 0 638 2,554
shared pool kghalp 0 441 626
shared pool kghfrh 0 339 37
shared pool kghfre 0 269 452
shared pool kgh: quiesce extents 0 227 1
shared pool kgh: add extent to quiesced list 0 203 0
shared pool kghasp 0 128 62
shared pool kgh_next_free 0 38 1
shared pool kghquiesce: clatch: nowait 0 25 0
shared pool kghfree_extents: scan 0 2 3
shared pool kghfen: not perm alloc class 0 1 0
shared pool simulator kglsim_upd_newhp 0 1 1
simulator hash latch kcbs_get_or_extract_simbufseq 0 1 0
simulator hash latch kcbs_lookup_setid: lookup dba 0 1 0
simulator lru latch kcbs_simulate: simulate set 0 4 0
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
DBPOOL48 USER_DATA DSSMDOBJINFO   TABLE 7,612,416 26.78
DBPOOL33 USER_DATA DSSMDOBJINFO   TABLE 1,850,320 6.51
SYS SYSAUX SYS_IOT_TOP_8802   INDEX 1,721,152 6.06
DBPOOL37 USER_DATA DSSMDOBJDEFN   TABLE 824,432 2.90
DBPOOL46 USER_DATA DSSMDOBJDEFN   TABLE 755,664 2.66

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SYS SYSTEM SEG$   TABLE 27,065 14.35
DBPOOL37 USER_DATA DSSMDOBJDEFN   TABLE 20,361 10.79
DBPOOL10 USER_DATA DSSMDOBJDEFN   TABLE 12,863 6.82
SYS SYSTEM OPQTYPE$   TABLE 6,536 3.46
EATUTORIAL USER_DATA ORDER_DETAIL   TABLE 5,417 2.87

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SYS SYSTEM I_FILE#_BLOCK#   INDEX 22 37.93
SYS SYSTEM I_COBJ#   INDEX 11 18.97
SYS SYSTEM I_COL2   INDEX 4 6.90
SYS SYSTEM I_OBJ#   INDEX 4 6.90
SYS SYSTEM I_CCOL2   INDEX 2 3.45

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
SYS SYSTEM SEG$   TABLE 7 31.82
SYS SYSTEM TAB$   TABLE 6 27.27
SYS SYSTEM CCOL$   TABLE 5 22.73
SYS SYSTEM CDEF$   TABLE 2 9.09
SYS SYSTEM HISTGRM$   TABLE 2 9.09

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYSTEM SYSTEM STATS$USER_LOG   TABLE 12,095 95.99
SYS SYSTEM OBJ$   TABLE 74 0.59
SYS SYSTEM TAB$   TABLE 52 0.41
SYS SYSTEM OPQTYPE$   TABLE 44 0.35
SYS SYSTEM SEG$   TABLE 43 0.34

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 60 0.00 0   2 1
dc_constraints 10,449 66.47 0   10,449 1,535
dc_database_links 2,944 0.00 0   0 1
dc_files 252 0.00 0   0 36
dc_global_oids 79,880 0.12 0   0 74
dc_histogram_data 208,747 0.94 0   681 9,733
dc_histogram_defs 236,366 7.26 0   818 8,488
dc_object_grants 36,943 0.61 0   0 348
dc_object_ids 575,759 1.02 0   4,154 5,201
dc_objects 301,352 3.21 0   11,112 5,761
dc_profiles 1,571 0.00 0   0 2
dc_rollback_segments 2,271 0.00 0   0 98
dc_segments 263,188 1.94 0   20,056 5,828
dc_sequences 11 36.36 0   11 2
dc_table_scns 3,101 100.00 0   0 0
dc_tablespace_quotas 7,904 0.19 0   234 60
dc_tablespaces 364,613 0.00 0   0 6
dc_usernames 37,191 0.03 0   0 149
dc_users 507,736 0.00 0   21 277
global database name 1 100.00 0   0 0
outstanding_alerts 71 19.72 0   29 8


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 8,596 0.48 33,950 0.42 100 0
CLUSTER 388 0.52 867 0.81 5 0
INDEX 1,946 92.14 2,623 74.34 8 0
SQL AREA 404,948 23.30 1,514,691 10.79 20,048 39,983
TABLE/PROCEDURE 34,472 14.08 619,744 2.89 4,208 0
TRIGGER 62,479 0.04 70,622 0.14 43 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 94.49   0.77 1.00 11 11 123 123
  Freeable 81.81 0.00 1.64 4.50 30   50 50
  SQL 7.13 0.85 0.06 0.11 0 10 116 113
  PL/SQL 3.28 2.77 0.03 0.01 0 0 121 121
E Other 98.23   0.81 1.00 11 11 122 122
  Freeable 85.88 0.00 1.48 4.19 30   58 58
  SQL 12.54 7.28 0.11 0.64 7 23 115 110
  PL/SQL 3.26 2.74 0.03 0.01 0 0 120 120

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 3,170,893,824 3,506,438,144
Fixed Size 2,105,624  
Redo Buffers 14,667,776  
Variable Size 3,103,788,776 2,768,244,456

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 CCursor 338.94 240.89 -28.93
shared Cursor Stats 51.74 51.74 0.00
shared KGH: NO ACCESS 40.13 56.10 39.79
shared PCursor 307.55 155.18 -49.54
shared free memory 1,098.38 1,317.81 19.98
shared kglsim heap 67.30 67.30 0.00
shared kglsim object batch 108.69 108.69 0.00
shared library cache 194.67 152.69 -21.56
shared obj stat memo 77.97 79.15 1.52
shared sql area 430.64 198.30 -53.95
shared sql area:PLSQL 41.88 32.73 -21.84
streams KGH: NO ACCESS 15.99 15.99 0.00
streams free memory 16.00 16.00 0.00
  buffer_cache 3,024.00 3,344.00 10.58
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.99 13.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

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 29 0 0 2 108

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)
aq_tm_processes 0   
audit_file_dest /orcl/oracle/admin/orcl/adump   
background_dump_dest /orcl/oracle/admin/orcl/bdump   
compatible 10.2.0.1.0   
control_files /dbdata/oradata/orcl/control01.ctl, /dbdata/oradata/orcl/control02.ctl, /dbdata/oradata/orcl/control03.ctl   
core_dump_dest /orcl/oracle/admin/orcl/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name orcl   
db_recovery_file_dest /orcl/oracle/flash_recovery_area   
db_recovery_file_dest_size 2147483648   
dispatchers (PROTOCOL=TCP) (SERVICE=orclXDB)   
job_queue_processes 10   
nls_length_semantics BYTE   
open_cursors 300   
pga_aggregate_target 826277888   
processes 500   
recyclebin OFF   
remote_login_passwordfile EXCLUSIVE   
resource_manager_plan      
sga_max_size 6291456000   
sga_target 6291456000   
undo_management AUTO   
undo_retention 900   
undo_tablespace UNDOTBS1   
user_dump_dest /orcl/oracle/admin/orcl/udump   


Back to Top

End of Report