D D D D D D D D D D D D 3,200 3,344 3,520 3,840 4,160 4,480 4,800 5,120 5,440 5,760 6,080 6,400 0.96 1.00 1.05 1.15 1.24 1.34 1.44 1.53 1.63 1.72 1.82 1.91 383,800 401,071 422,180 460,560 498,940 537,320 575,700 614,080 652,460 690,840 729,220 767,600 1.00 1.00 0.99 0.99 0.99 0.99 0.99 0.98 0.98 0.98 0.98 0.98 7,784,014 7,748,403 7,702,243 7,680,429 7,663,046 7,653,232 7,645,544 7,630,008 7,616,886 7,614,591 7,613,191 7,599,930 Back to Advisory Statistics Back to Top
PGA Aggr Summary
?
PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written 87.91 Back to Advisory Statistics Back to Top
1,100 151 PGA Aggr Target Stats
? ? ? ? ? ?
B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto) %PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt %Man W/A Mem - percentage of workarea memory under manual control
%Man W/A Mem 0.00 0.00 B E PGA Aggr Target(M) 1,024 1,024 Auto PGA Target(M) 862 860 PGA Mem Alloc(M) 150.36 154.14 W/A PGA Used(M) 0.00 0.00 %PGA %Auto W/A Mem W/A Mem 0.00 0.00 0.00 0.00 Global Mem Bound(K) 104,850 104,850 Back to Advisory Statistics Back to Top
PGA Aggr Target Histogram
?
Optimal Executions are purely in-memory operations
Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs 2K 64K 128K 4K 128K 256K 1,385 28 5 1,385 28 5 0 0 0 0 0 0 256K 512K 1M 8M 128M 256M 512K 1024K 2M 16M 256M 512M 79 108 7 1 3 1 79 108 7 1 2 1 0 0 0 0 1 0 0 0 0 0 0 0 Back to Advisory Statistics Back to Top
PGA Memory Advisory
?
When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0
Size Factr 0.13 0.25 0.50 0.75 1.00 1.20 1.40 1.60 1.80 2.00 3.00 4.00 6.00 8.00 W/A MB Processed 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 Estd Extra W/A MB Read/ Written to Disk 2,895.99 2,857.13 2,857.13 2,857.13 717.82 717.82 717.82 717.82 717.82 717.82 717.82 717.82 717.82 717.82 Estd PGA Cache Hit % 62.00 62.00 62.00 62.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 Estd PGA Overalloc Count 0 0 0 0 0 0 0 0 0 0 0 0 0 0 PGA Target Est (MB) 128 256 512 768 1,024 1,229 1,434 1,638 1,843 2,048 3,072 4,096 6,144 8,192 Back to Advisory Statistics Back to Top
Shared Pool Advisory
? ?
SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.
Est LC Size (M) 78 78 78 78 78 78 78 78 Est LC Mem Obj 7,626 7,626 7,626 7,626 7,626 7,626 7,626 7,626 Est LC Time Saved (s) 64,842 64,842 64,842 64,842 64,842 64,842 64,842 64,842 Est LC Time Saved Factr 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Est LC Load Time (s) 31 31 31 31 31 31 31 31 Est LC Est LC Mem Load Time Obj Hits Factr 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 Shared Pool Size(M) 304 384 464 544 624 704 784 864 SP Size Factr 0.43 0.55 0.66 0.77 0.89 1.00 1.11 1.23 944 1,024 1,104 1,184 1,264 1,344 1,424 1.34 1.45 1.57 1.68 1.80 1.91 2.02 78 78 78 78 78 78 78 7,626 7,626 7,626 7,626 7,626 7,626 7,626 64,842 64,842 64,842 64,842 64,842 64,842 64,842 1.00 1.00 1.00 1.00 1.00 1.00 1.00 31 31 31 31 31 31 31 1.00 1.00 1.00 1.00 1.00 1.00 1.00 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 Back to Advisory Statistics Back to Top
SGA Target Advisory
SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads 1,024 2,048 3,072 4,096 5,120 6,144 7,168 8,192 Back to Advisory Statistics Back to Top
0.25 0.50 0.75 1.00 1.25 1.50 1.75 2.00 9,060 7,612 7,563 7,451 7,423 7,397 7,385 7,385 9,742,760 7,948,245 7,886,258 7,748,338 7,713,470 7,680,927 7,666,980 7,666,980 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
? ? Buffer Wait Statistics Enqueue Activity Back to Top
Buffer Wait Statistics
?
ordered by wait time desc, waits desc
Waits Total Wait Time (s) Avg Time (ms) Class data block undo header file header block undo block 3 616 8 7 0 0 0 0 23 0 0 0 Back to Wait Statistics Back to Top
Enqueue Activity
? ? ?
only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data ordered by Wait Time desc, Waits desc
Succ Gets 14,075 964 24 4,223 10,548 1 121,761 103 9,933 12 18 16 3 3 11 14 2 2 6 Failed Gets 0 0 0 0 0 0 6 0 0 0 0 0 0 0 3 0 0 0 0 Wt Time (s) 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Av Wt Time(ms) 0.43 0.32 9.00 1.22 0.67 35.00 0.43 0.65 0.54 1.42 0.38 0.50 0.67 0.33 0.33 1.00 1.00 1.00 0.00 Enqueue Type (Request Reason) FB-Format Block US-Undo Segment WF-AWR Flush HW-Segment High Water Mark CF-Controlfile Transaction TX-Transaction (index contention) TM-DML PS-PX Process Reservation TT-Tablespace TD-KTF map table enqueue (KTF dump entries) TA-Instance Undo PI-Remote PX Process Spawn Status MW-MWIN Schedule DR-Distributed Recovery TS-Temporary Segment AF-Advisor Framework (task serialization) JS-Job Scheduler (job run lock - synchronize) UL-User-defined MD-Materialized View Log DDL Back to Wait Statistics Back to Top
Requests 14,075 964 24 4,223 10,548 1 121,768 103 9,933 12 18 16 3 3 14 14 2 2 6 Waits 7,033 556 14 37 58 1 70 46 39 12 13 8 3 3 3 1 1 1 2 Undo Statistics
? ? Undo Segment Summary Undo Segment Stats Back to Top
Undo Segment Summary
? ?
Min/Max TR (mins) - Min and Max Tuned Retention (minutes) STO - Snapshot Too Old count, OOS - Out of Space count
? ? ?
Undo TS# 1 Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed eS - expired Stolen, eR - expired Released, eU - expired reUsed
Max Qry Len (s) 0 Num Undo Blocks (K) 219.12 Number of Transactions 113,405 Max Tx Concurcy Min/Max TR (mins) 6 130.95/239.25 STO/ OOS 0/0 uS/uR/uU/ eS/eR/eU 0/0/0/13/24256/0 Back to Undo Statistics Back to Top
Undo Segment Stats
?
End Time 25-Dec 15:18 25-Dec 15:08 25-Dec 14:58 25-Dec 14:48 25-Dec 14:38 25-Dec 14:28 25-Dec 14:18 25-Dec 14:08 Most recent 35 Undostat rows, ordered by Time desc Num Undo Blocks 182,021 57 68 194 570 36,047 70 91 Number of Transactions 74,309 170 31 4,256 12,299 21,328 907 105 Max Qry Len (s) 0 0 0 0 0 0 0 0 Max Tx Concy 5 3 2 4 5 6 3 3 Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU 0/0/0/13/24256/0 0/0/0/0/0/0 0/0/0/0/0/0 0/0/0/0/0/0 0/0/0/0/0/0 0/0/0/0/0/0 0/0/0/0/0/0 0/0/0/0/0/0 131 0/0 239 0/0 229 0/0 219 0/0 209 0/0 200 0/0 162 0/0 154 0/0 Back to Undo Statistics Back to Top
Latch Statistics
? ? ? ? ? Latch Activity Latch Sleep Breakdown Latch Miss Sources Parent Latch Statistics Child Latch Statistics Back to Top
Latch Activity
? ? ?
\requests
\ \ Latch Name Get Pct Get Avg Slps Wait NoWait Pct NoWait