[ SnapShot Info ] [ Cache Sizes ] [ Load Profile ]
[ Efficiency ] [ Shared Pool ] [ Top 5 Wait ]
[ SQL by Gets ] [ SQL by Reads ] [ SQL by Exec ] [ SQL by Parse ]
[ TableSpace IO ] [ File IO ] [ Buffer Pool ] [ Instance Recovery ] [ Buffer Waits ]
[ Memory Stats ] [ Enqueue Activity ] [ RBS ] [ Undo Segs ]
[ Caches ] [ SGA ] [ Init Params ] |
Common Instance Information | |
---|---|
Hostname: | sv2001 |
Instance: | ORADB |
Version: | 9.0.1.0.0 |
Cluster: | NO |
FileSize (Data+Log) | 92,701.00 MB |
Startup / Uptime | 15.12.2003 17:03 / 48.81 d |
Report generated: | 02.02.2004 12:27 |
SnapShot Info | |||||
---|---|---|---|---|---|
Snap ID | Snap Time | Sessions | Curs/Sess | Comment | |
Start | 489 | 15.12.2003 18:00 | 47 | 4.49 | |
End | 1173 | 10.01.2004 12:00 | 42 | 5.21 | |
Elapsed: 37,079.47 min |
Cache Sizes (End) | |
---|---|
Cache | Size |
Buffer Cache | 304 M |
Std Block Size | 16 K |
Shared Pool Size | 112 M |
Log Buffer | 12,288 K |
Load Profile | ||
---|---|---|
Per Second | Per Transaction | |
Redo Size | 23,243.19 | 31,837.52 |
Logical Reads | 1,296.31 | 1,775.63 |
Block Changes | 67.35 | 92.25 |
Physical Reads | 130.68 | 179.00 |
Physical Writes | 10.75 | 14.72 |
User Calls | 54.88 | 75.17 |
Parses | 5.20 | 7.12 |
Hard Parses | 2.47 | 3.38 |
Sorts | 1.01 | 1.39 |
Logons | 0.02 | 0.03 |
Executes | 6.26 | 8.58 |
Transactions | 0.73 |
Instance Efficiency Percentages (Target: 100%) | ||
---|---|---|
Event | Efficiency (%) | Comment |
Buffer Nowait | 99.61 | If this ratio is low, check the Buffer Wait Stats section for more detail on which type of block is being contended for. |
Redo Nowait | 99.61 | A value close to 100% indicates minimal time spent waiting for redo logs
to become available, either because the logs are not filling up very often or because the database is able to switch to a new log quickly whenever the current log fills up. |
Buffer Hit | 90.46 | A low buffer hit ratio does not necessarily mean the cache is too small: it may very well be that potentially valid full-table-scans are artificially
reducing what is otherwise a good ratio. A too-small buffer cache can sometimes be identified by the appearance of write complete waits event indicating hot blocks
(i.e. blocks still being modified) are aging out of the cache while they are still needed; check the Wait Events list for evidence of this event. |
In-Memory Sort | 99.99 | A too low ratio indicates too many disk sorts appearing. One possible
solution could be increasing the sort area/SGA size. |
Library Hit | 85.66 | A low library hit ratio could imply that SQL is prematurely aging out of a too-small shared pool, or that non-shareable SQL is being used.
If the soft parse ratio is also low, check whether there is a parsing issue. |
Soft Parse | 52.48 | When the soft parse
ratio falls much below 80%, investigate whether you can share SQL by using bind variables or force cursor sharing. But before drawing any conclusions, compare the soft parse
ratio against the actual hard and soft parse rates shown in the Loads Profile. Furthermore, investigate the number of Parse CPU to Parse Elapsed below. |
Execute to Parse | 17.06 | A low value here indicates that there is no much re-usable SQL. See Soft Parse for possible actions. |
Latch Hit | 99.98 | A low value for this ratio indicates a latching problem, whereas a high value is generally good. However, a high latch hit ratio can artificially mask a low get rate on a specific latch. Cross-check this value with the Top 5 Wait Events to see if latch free is in the list, and refer to the Latch sections of this report. |
Parse CPU to Parse Elapsed | 87.99 | See Soft Parse above. |
Non-Parse CPU | 91.68 |
Shared Pool Statistics | ||
---|---|---|
Name | Begin | End |
Memory Usage % | 17.92 | 88.18 |
% SQL with executions > 1 | 54.13 | 21.24 |
% Memory for SQL with executions > 1 | 39.74 | 25.63 |
Top 5 Wait Events | |||
---|---|---|---|
Ordered by Wait Time (desc), Waits (desc)
Start with these topmost events and find out about details in the corresponding block, e.g. for "db file * read" check the TableSpace IO
(and File IO) blocks to identify the possibly affected schemas, and then the SQL Statements by Reads (and
Wait Objects) to find out what statements (and/or objects) may need some tuning , for "enqueue" waits look up the Enqueue Activity
section of this document. If the CPU is indicated as a bottleneck, check the SQL Statements by Gets. Then continue the same
with the next block, All Wait Events | |||
Event | Waits | Wait Time (s) | % Total Wt Time (ms) |
db file sequential read | 152,757,111 | 231,968.72 | 46.30 |
db file scattered read | 8,684,843 | 111,994.86 | 22.36 |
log file parallel write | 1,719,659 | 38,352.08 | 7.66 |
log file sync | 1,447,208 | 33,139.91 | 6.62 |
db file parallel read | 1,033,258 | 21,305.92 | 4.25 |
Top 5 SQL ordered by Gets | ||||||
---|---|---|---|---|---|---|
End Buffer Gets Treshold: 10000
Note that resources reported for PL/SQL includes the resources used by all SQL statements called within the PL/SQL code. As individual SQL statements are also reported,
it is possible and valid for the summed total % to exceed 100. | ||||||
Buffer Gets | Executions | Gets per Exec | % Total | CPU Time (s) | Elapsed Time (s) | Hash Value |
10,284,393 | 1 | 10,284,393.0 | 0.4 | 397.99 | 745.19 | 3734559764 |
select * from wumm.intern | ||||||
7,861,780 | 346 | 22,721.9 | 0.3 | 0.04 | 0.10 | 2033635752 |
BEGIN xon.hum_load; END; | ||||||
3,726,207 | 346 | 10,769.4 | 0.1 | 0.06 | 0.07 | 2712042468 |
DELETE from xo_import where subtype='HUM' | ||||||
2,941,519 | 346 | 8,501.5 | 0.1 | 51.41 | 76.59 | 1566221371 |
SELECT kv,dat,minrn,maxrn,aktrn,zeile from bc_lid0200_load order by kv,dat,aktrn | ||||||
2,078,204 | 9,096 | 228.5 | 0.1 | 0.09 | 0.08 | 300667169 |
INSERT INTO XON.XO_IMPORT (SUBTYPE,DATA) VALUES (:SUBTYPE,: DATA) |
Top 5 SQL ordered by Reads | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
End Disk Reads Treshold: 1000 If your primary tuning goal is to reduce resource usage, start by tuning these statements/objects (File IO) plus SQL by Gets (CPU). | ||||||||||||||||||||||||||||||||||||||||||||||||
Pysical Reads | Executions | Reads per Exec | % Total | CPU Time (s) | Elapsed Time (s) | Hash Value | ||||||||||||||||||||||||||||||||||||||||||
382,085 | 1 | 382,085.0 | 0.1 | 598.94 | 1,017.18 | 3217870462 | ||||||||||||||||||||||||||||||||||||||||||
SELECT /*+ */ "A1"."06S"||';'||"A1"."03S"||';'||"A1"."04S"||';'| |"A1"."10N"||';'||"A1"."11N"||';'||"A1"."20K"||';'||"A1"."21K"|| ';'||"A1"."25K"||';'||"A1"."26K"||';'||"A1"."28K"||';'||"A1"."29 K"||';'||"A1"."31K"||';'||"A1"."32K"||';'||"A1"."33K"||';'||"A1" ."34K"||';'||"A1"."40U" FROM "DM"."INTERNET_SHAREQUOTE" "A1" | ||||||||||||||||||||||||||||||||||||||||||||||||
307,751 | 1 | 307,751.0 | 3.5 | 397.99 | 745.19 | 3734559764 | ||||||||||||||||||||||||||||||||||||||||||
select * from wumm.intern | ||||||||||||||||||||||||||||||||||||||||||||||||
155,454 | 4,859 | 32.0 | 0.6 | 0.02 | 0.01 | 1125808767 | ||||||||||||||||||||||||||||||||||||||||||
INSERT INTO DM.DM_KDFLOP (DATEI,DATA) VALUES (:DATEI,:DA TA) | ||||||||||||||||||||||||||||||||||||||||||||||||
147,003 | 2 | 73,501.5 | 0.1 | 67.77 | 117.75 | 3115724095 | ||||||||||||||||||||||||||||||||||||||||||
select * from bc_btram_l1 where --wkl='907250' kno=401071 026587 | ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
81,810 | 1 | 81,810.0 | 0.2 | 97.78 | 113.58 | 782365933 | ||||||||||||||||||||||||||||||||||||||||||
SELECT "AZU","VERK","KLS" FROM "WUMM"."VKONTEN" "VKONTE N" WHERE INSTR(UPPER("VERK"),'SMITH')<>0 |
Top 5 SQL ordered by Executions | ||||||
---|---|---|---|---|---|---|
End Executions Treshold: 100 Start with tuning these statements if your primary goal is to increase the response time. | ||||||
Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | Hash Value | |
434,305 | 618 | 0.0 | 11.65 | 405.80 | 2963598673 | |
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= n ext_date) and (next_date < :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5) ) and (this_date is null) order by next_date, job | ||||||
433,699 | 433,699 | 1.0 | 3.67 | 34.23 | 2964743345 | |
select count(*) from sys.job$ where (next_date > sysdate) and (n ext_date < (sysdate+5/86400)) | ||||||
130,201 | 339,444 | 2.6 | 8,930.12 | 9,014.43 | 1353809701 | |
/* OracleOEM */ SELECT decode(target_desc,NULL,decode(target,NU LL,opname, concat(opname, concat (' - ',target))),decode(target, NULL,concat(opname, concat (' : ',target_desc)),concat(opname, c oncat (' : ',concat(target_desc,concat (' - ',target)))))),sofar ,totalwork,units, start_time,TO_CHAR(elapsed_seconds,'99999990.0 0'), decode(sofar, 0, 0, round(elapsed_seconds*(totalwork-sofar) /sofar)) FROM v$session_longops WHERE sid = 35 AND serial# = 57 96 and sofar< totalWork | ||||||
22,688 | 0 | 0.0 | 76.25 | 73.82 | 1826919589 | |
COMMIT | ||||||
14,093 | 13,975 | 1.0 | 128.43 | -1,417.79 | 4083054575 | |
SELECT "WKL","AZU","KRZ" FROM "WUMM"."MAN_P" "A" WHERE "AZU"=:1 |
Top 5 SQL ordered by Parse Calls | ||||||
---|---|---|---|---|---|---|
End Parse Calls Treshold: 1000 Consider tuning these statements/objects, if the percentage of CPU used for parsing is high. Currently, parsing takes avg. 8.32% of all CPU usage by all sessions. | ||||||
Parse Calls | Executions | % Total Parses | Hash Value | |||
130,202 | 130,201 | 0.01 | 1353809701 | |||
/* OracleOEM */ SELECT decode(target_desc,NULL,decode(target,NU LL,opname, concat(opname, concat (' - ',target))),decode(target, NULL,concat(opname, concat (' : ',target_desc)),concat(opname, c oncat (' : ',concat(target_desc,concat (' - ',target)))))),sofar ,totalwork,units, start_time,TO_CHAR(elapsed_seconds,'99999990.0 0'), decode(sofar, 0, 0, round(elapsed_seconds*(totalwork-sofar) /sofar)) FROM v$session_longops WHERE sid = 35 AND serial# = 57 96 and sofar< totalWork | ||||||
22,687 | 22,688 | 0.00 | 1826919589 | |||
COMMIT | ||||||
17,531 | 0 | 0.00 | 3127169738 | |||
SELECT * FROM "WUMM"."MAN_P" | ||||||
8,006 | 8,005 | 0.00 | 2501101467 | |||
select name from v$database | ||||||
7,823 | 14,093 | 0.00 | 4083054575 | |||
SELECT "WKL","AZU","KRZ" FROM "WUMM"."MAN_P" "A" WHERE "AZU"=:1 |
TableSpace IO Summary Statistics ![]() | ||||||||
---|---|---|---|---|---|---|---|---|
Ordered by IOs (Reads + Writes) desc | ||||||||
TableSpace | Reads | AvgReads/s | AvgRd (ms) | Avg Blks/Rd | Writes | Avg Wrt/s | Buffer Waits | Avg Buf Wt (ms) |
XON_IDX | 100,942,464 | 45.37 | 0.7 | 1.2 | 355,089 | 0.16 | 11,082,240 | 0.9 |
DM_IDX | 40,512,985 | 18.21 | 2.5 | 1.0 | 2,905,693 | 1.31 | 0 | 0.0 |
WM_TAB | 12,369,725 | 5.56 | 10.5 | 6.2 | 399,800 | 0.18 | 55,677 | 16.4 |
XON_MV | 11,189,620 | 5.03 | 3.9 | 3.5 | 227,657 | 0.10 | 1,129 | 5.0 |
TEMP | 5,401,454 | 2.43 | 0.1 | 2.8 | 1,635,400 | 0.74 | 1,590 | 246.5 |
WM_IND | 1,647,055 | 0.74 | 6.3 | 1.0 | 962,436 | 0.43 | 1,339 | 6.6 |
UNDOTBS | 25,977 | 0.01 | 58.9 | 1.0 | 1,691,185 | 0.76 | 1,808 | 24.5 |
XON | 162,811 | 0.07 | 7.2 | 1.4 | 212,608 | 0.10 | 0 | 0.0 |
XON_TAB | 223,111 | 0.10 | 8.0 | 4.9 | 24,284 | 0.01 | 0 | 0.0 |
TOOLS | 57,246 | 0.03 | 12.7 | 1.1 | 52,871 | 0.02 | 0 | 0.0 |
SYSTEM | 87,768 | 0.04 | 77.2 | 1.7 | 8,277 | 0.00 | 1,590 | 246.5 |
DM_TAB | 28,348 | 0.01 | 1.1 | 1.0 | 62,198 | 0.03 | 0 | 0.0 |
DM | 911 | 0.00 | 3.7 | 1.0 | 515 | 0.00 | 0 | 0.0 |
XON_FIX | 794 | 0.00 | 2.0 | 1.0 | 513 | 0.00 | 0 | 0.0 |
File IO Summary Statistics ![]() | |||||||||
---|---|---|---|---|---|---|---|---|---|
Ordered by TableSpace, File | |||||||||
TableSpace | Filename | Reads | AvgReads/s | AvgRd (ms) | Avg Blks/Rd | Writes | Avg Wrt/s | Buffer Waits | Avg Buf Wt (ms) |
DM | /vol2/oraData/dm.dbf | 911 | 0.00 | 3.7 | 1.0 | 515 | 0.00 | 0 | 0.0 |
DM_IDX | /vol2/oraData/dm_idx.dbf | 40,512,985 | 18.21 | 2.5 | 1.0 | 2,905,693 | 1.31 | 0 | 0.0 |
DM_TAB | /vol2/oraData/dm_tab.dbf | 28,348 | 0.01 | 1.1 | 1.0 | 62,198 | 0.03 | 0 | 0.0 |
SYSTEM | /vol1/oraData/system.dbf | 87,768 | 0.04 | 77.2 | 1.7 | 8,277 | 0.00 | 1,590 | 246.5 |
TEMP | /vol1/oraData/temp.dbf | 5,401,454 | 2.43 | 0.1 | 2.8 | 1,635,400 | 0.74 | 1,590 | 246.5 |
TOOLS | /vol2/oraData/tools.dbf | 57,246 | 0.03 | 12.7 | 1.1 | 52,871 | 0.02 | 0 | 0.0 |
UNDOTBS | /vol1/oraData/undotbs.dbf | 25,977 | 0.01 | 58.9 | 1.0 | 1,691,185 | 0.76 | 1,808 | 24.5 |
WM_IND | /vol2/oraData/wm_ind.dbf | 1,647,055 | 0.74 | 6.3 | 1.0 | 962,436 | 0.43 | 1,339 | 6.6 |
WM_TAB | /vol1/oraData/wm_tab.dbf | 12,369,725 | 5.56 | 10.5 | 6.2 | 399,800 | 0.18 | 55,677 | 16.4 |
XON | /vol3/oraData/xon.dbf | 162,811 | 0.07 | 7.2 | 1.4 | 212,608 | 0.10 | 0 | 0.0 |
XON_FIX | /vol3/oraData/xon_fix.dbf | 794 | 0.00 | 2.0 | 1.0 | 513 | 0.00 | 0 | 0.0 |
XON_IDX | /vol2/oraData/xon_idx.dbf | 100,942,464 | 45.37 | 0.7 | 1.2 | 355,089 | 0.16 | 11,082,240 | 0.9 |
XON_MV | /vol2/oraData/xon_mv.dbf | 11,189,620 | 5.03 | 3.9 | 3.5 | 227,657 | 0.10 | 1,129 | 5.0 |
XON_TAB | /vol2/oraData/xon_tab.dbf | 223,111 | 0.10 | 8.0 | 4.9 | 24,284 | 0.01 | 0 | 0.0 |
Buffer Pool Statistics | |||||||||
---|---|---|---|---|---|---|---|---|---|
Standard Block Size Pools
D:Default, K:Keep, R:Recycle Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k | |||||||||
Pool | # of Buffers | Cache Hit % | Buffer Gets | PhyReads | PhyWrites | FreeBuf Waits | Wrt complete Waits | Buffer Busy Waits | HitRatio (%) |
D | 19247 | 87.7 | 2,239,252,566 | 275,246,460 | 6,889,614 | 129 | 0 | 11,143,787 | 87.71 |
Instance Recovery Statistics | ||||||||
---|---|---|---|---|---|---|---|---|
B: Begin SnapShot, E: End SnapShot | ||||||||
Target MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual Redo Blks | Target Redo Blks | LogFile Size Redo Blks | Log Ckpt Timeout Redo Blks | Log Ckpt Interval Redo Blks | |
B | 43 | 9 | 19,247 | 2,765 | 2,765 | 184,320 | 2,765 | 4,294,967,295 |
E | 43 | 9 | 19,247 | 596 | 120 | 184,320 | 120 | 4,294,967,295 |
Buffer Wait Statistics ![]() | ||||
---|---|---|---|---|
Ordered by Wait Time desc, Waits desc | ||||
Class | Waits | Tot Wait Time (s) | Avg Wait Time (s) | Waits/s |
data block | 11,141,553 | 10,913.08 | 0.98 | 1,020.94 |
segment header | 421 | 131.77 | 312.99 | 3.19 |
undo header | 1,806 | 44.33 | 24.55 | 40.74 |
undo block | 3 | 0.00 | 0.00 |
PGA Aggreg Target Memory Statistics | ||||||||
---|---|---|---|---|---|---|---|---|
B: Begin SnapShot, E: End SnapShot | ||||||||
PGA Aggreg Target (M) | PGA in Use (M) | W/A PGA in Use (M) | 1-Pass Mem Req (M) | % Optim W/A Execs | % Non-W/A PGA Memory | % Auto W/A PGA Mem | % Manual W/A PGA Mem | |
B | 200.00 | 37.97 | 17.10 | 40.57 | 98.86 | 54.96 | 45.04 | 0.00 |
E | 200.00 | 34.16 | 0.03 | 153.43 | 99.99 | 99.91 | 0.09 | 0.00 |
PGA Memory Statistics | |||
---|---|---|---|
WorkArea (W/A) memory is used for: sort, bitmap merge, and hash join ops | |||
Statistic | Begin (M) | End (M) | % Diff |
global memory bound | 0.01 | 0.01 | 0.00 |
maximum PGA allocated | 45.38 | 137.32 | 202.59 |
maximum PGA memory for one-pass | 40.57 | 153.43 | 278.19 |
maximum PGA memory for optimal | 59.09 | 2,063.45 | 3,392.28 |
maximum PGA used for auto workareas | 21.57 | 30.69 | 42.31 |
maximum PGA used for manual workareas | 0.00 | 0.50 |   |
total PGA allocated | 45.38 | 57.04 | 25.70 |
Enqueue Activity ![]() | |||||||
---|---|---|---|---|---|---|---|
Enqueue Stats gathered prior to 9i should not be compared with 9i data Ordered by Waits desc, Requests desc | |||||||
Eq | Requests | Succ Gets | Failed Gets | PctFail | Waits | Avg Wt Time (ms) | Wait Time (s) |
SQ | 2,286 | 2,286 | 0 | 0.00 | 154 | 145.20 | 22 |
TC | 820 | 820 | 0 | 0.00 | 128 | 156.85 | 20 |
CF | 879,661 | 879,661 | 0 | 0.00 | 74 | 2,215.01 | 164 |
TX | 2,193,987 | 2,193,978 | 9 | 0.00 | 9 | 7.78 | 0 |
JD | 434,936 | 434,936 | 0 | 0.00 | 6 | 3,000.33 | 18 |
DX | 10,936,047 | 10,936,045 | 0 | 0.00 | 2 | 13.00 | 0 |
TM | 4,536,723 | 4,536,679 | 44 | 0.00 | 2 | 33,894.50 | 68 |
HW | 139,486 | 139,486 | 0 | 0.00 | 1 | 165.00 | 0 |
Rollback Segments Stats ![]() | ||||||
---|---|---|---|---|---|---|
A high value for "Pct Waits" suggests more rollback segments may be required.
A large number of transaction table waits also results in high values of "buffer busy waits" for undo segment header blocks; cross-reference with the Buffer Wait Statistics
to confirm this correlation. RBS stats may not be accurate between begin and end snaps when using Auto Undo Management, as RBS may be dynamically
created and dropped as needed | ||||||
RBS# | Trans Table Gets | Pct Waits | Undo Bytes Written | Wraps | Shrinks | Extends |
0 | 30,462.0 | 0.00 | 0 | 0 | 0 | 0 |
1 | 822,943.0 | 0.02 | 1,901,798,320 | 2,488 | 338 | 1,957 |
2 | 1,035,343.0 | 0.02 | 2,029,634,530 | 2,506 | 331 | 2,018 |
3 | 1,537,366.0 | 0.01 | 2,096,819,062 | 2,575 | 348 | 2,057 |
4 | 1,593,885.0 | 0.01 | 2,550,240,154 | 2,948 | 372 | 2,400 |
5 | 942,717.0 | 0.01 | 1,799,736,186 | 2,238 | 276 | 1,891 |
6 | 1,944,767.0 | 0.01 | 2,187,045,590 | 2,665 | 354 | 2,136 |
7 | 1,608,343.0 | 0.01 | 2,107,676,952 | 2,521 | 336 | 2,037 |
8 | 883,821.0 | 0.01 | 1,953,264,856 | 2,512 | 337 | 1,999 |
9 | 1,391,136.0 | 0.01 | 2,349,765,310 | 2,500 | 303 | 2,153 |
10 | 1,181,910.0 | 0.01 | 2,145,774,268 | 2,453 | 311 | 2,067 |
Undo Segment Summary ![]() | |||||||
---|---|---|---|---|---|---|---|
Undo Segment block stats uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed eS - expired Stolen, eR - expired Released, eU - expired reUsed | |||||||
Undo TS# | Undo Blocks | # TXN | Max Qry Len (s) | Max Tx Concurcy | Snapshot Too Old | Out of Space | uS/ur/uU / eS/eR/eU |
1 | 1,667,475 | 2,340,199 | 588,928 | 8 | 1 | 0 | 0/0/949 / 0/0/0 |
Dictionary Cache | |||||||
---|---|---|---|---|---|---|---|
"Pct Misses" should be very low (< 2% in most cases) "Cache Usage" is the number of cache entries being used "Pct SGA" is the ratio of usage to allocated size for that cache | |||||||
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage | Pct SGA |
dc_constraints | 12 | 41.67 | 0 | 12 | 1 | 33.33 | |
dc_database_links | 7,798,910 | 0.00 | 0 | 0 | 19 | 95.00 | |
dc_files | 91,046 | 0.00 | 0 | 0 | 13 | 65.00 | |
dc_free_extents | 6,751 | 0.07 | 4 | 0.00 | 12 | 2 | 66.67 |
dc_global_oids | 172 | 0.58 | 0 | 0 | 3 | 13.04 | |
dc_histogram_defs | 521,896,029 | 0.01 | 0 | 32 | 1,990 | 99.70 | |
dc_object_ids | 119,521,617 | 0.00 | 0 | 282 | 361 | 98.63 | |
dc_objects | 8,137,755 | 0.09 | 0 | 1,082 | 533 | 99.26 | |
dc_profiles | 36,594 | 0.00 | 0 | 0 | 1 | 33.33 | |
dc_rollback_segments | 253,438 | 0.00 | 0 | 0 | 16 | 88.89 | |
dc_segments | 27,998,054 | 0.00 | 0 | 290 | 363 | 96.03 | |
dc_sequences | 2,129 | 0.09 | 0 | 2,129 | 3 | 75.00 | |
dc_tablespace_quotas | 21,271 | 0.13 | 0 | 7,588 | 14 | 93.33 | |
dc_tablespaces | 3,578,206 | 0.00 | 0 | 0 | 17 | 56.67 | |
dc_used_extents | 4 | 100.00 | 0 | 4 | 1 | 50.00 | |
dc_user_grants | 665,912 | 0.00 | 0 | 0 | 30 | 68.18 | |
dc_usernames | 7,188,569 | 0.00 | 0 | 0 | 20 | 95.24 | |
dc_users | 45,244,956 | 0.00 | 0 | 1 | 30 | 81.08 | |
table scns | 852 | 1.17 | 0 | 0 | 1 | 33.33 |
SGA Memory Summary | |
---|---|
Values at the time of the End SnapShot | |
SGA Region | Size in Bytes |
Database Buffers | 318,767,104 |
Fixed Size | 279,900 |
Redo Buffers | 12,591,104 |
Variable Size | 167,772,160 |
Sum | 499,410,268 |
SGA BreakDown Difference | ||||
---|---|---|---|---|
Pool | Name | Begin Value | End Value | % Diff |
java | free memory | 16,777,216 | 16,777,216 | 0.00 |
large | PX msg pool | 7,077,888 | 7,077,888 | 0.00 |
large | free memory | 4,287,889,408 | 4,287,889,408 | 0.00 |
shared | 1M buffer | 1,049,088 | 1,049,088 | 0.00 |
shared | Checkpoint queue | 282,304 | 282,304 | 0.00 |
shared | FileIdentificatonBlock | 319,452 | 319,452 | 0.00 |
shared | FileOpenBlock | 695,504 | 695,504 | 0.00 |
shared | KGK heap | 3,756 | 3,756 | 0.00 |
shared | KGLS heap | 1,388,884 | 1,301,048 | -6.32 |
shared | KGSK scheduler | 59,316 | 75,956 | 28.05 |
shared | KGSKI schedule | 17,608 | 17,608 | 0.00 |
shared | KSXR pending messages que | 225,836 | 225,836 | 0.00 |
shared | KSXR receive buffers | 1,058,000 | 1,058,000 | 0.00 |
shared | PL/SQL DIANA | 562,728 | 1,636,828 | 190.87 |
shared | PL/SQL MPCODE | 195,228 | 542,000 | 177.62 |
shared | PLS non-lib hp | 2,068 | 2,068 | 0.00 |
shared | PX subheap | 226,504 | 226,504 | 0.00 |
shared | character set object | 281,296 | 281,296 | 0.00 |
shared | dictionary cache | 582,100 | 1,369,928 | 135.34 |
shared | enqueue | 184,124 | 184,124 | 0.00 |
shared | event statistics per sess | 1,366,120 | 1,366,120 | 0.00 |
shared | fixed allocation callback | 140 | 140 | 0.00 |
shared | free memory | 110,172,172 | 15,860,248 | -85.60 |
shared | joxs heap init | 4,220 | 4,220 | 0.00 |
shared | library cache | 2,951,216 | 26,716,032 | 805.26 |
shared | log_buffer | 196,608 | 196,608 | 0.00 |
shared | message pool freequeue | 767,192 | 767,192 | 0.00 |
shared | miscellaneous | 4,082,428 | 5,704,636 | 39.74 |
shared | parameters | 8,352 | 14,820 | 77.44 |
shared | sessions | 395,080 | 395,080 | 0.00 |
shared | simulator trace entries | 196,608 | 196,608 | 0.00 |
shared | sql area | 6,292,012 | 73,488,252 | 1,067.96 |
shared | table definiti | 728 | 7,144 | 881.32 |
shared | transaction | 181,624 | 181,624 | 0.00 |
shared | trigger defini | 636 | 46,132 | 7,153.46 |
shared | trigger inform | 876 | 616 | -29.68 |
shared | trigger source | 460 | 56 | -87.83 |
db_block_buffers | 318,767,104 | 318,767,104 | 0.00 | |
fixed_sga | 279,900 | 279,900 | 0.00 | |
log_buffer | 12,582,912 | 12,582,912 | 0.00 |
Initialization Parameters (init.ora) | ||
---|---|---|
Parameter Name | Begin Value | End Value (if different) |
O7_DICTIONARY_ACCESSIBILITY | TRUE | |
background_dump_dest | $ORACLE_DATA/$ORACLE_SID/v01/Dmp | |
compatible | 9.0.0 | |
control_files | $ORACLE_DATA/$ORACLE_SID/v01/$ORACLE_SID.ctl, $ORACLE_DATA/$ORACLE_SID/v02/$ORACLE_SID.ctl, $ORACLE_DATA/$ORACLE_SID/v03/$ORACLE_SID.ctl | |
core_dump_dest | $ORACLE_DATA/$ORACLE_SID/v01/Dmp | |
db_block_size | 16384 | |
db_cache_size | 318767104 | |
db_domain | OMUC.BAAG | |
db_file_multiblock_read_count | 24 | |
db_name | ORADB | |
fast_start_mttr_target | 300 | |
global_names | FALSE | |
ifile | $ORACLE_BASE/adm/init/init.ora | |
instance_name | ORADB | |
java_pool_size | 16777216 | |
job_queue_processes | 1 | |
large_pool_size | 10M | |
log_archive_dest_1 | location=$ORACLE_DATA/$ORACLE_SID/v03/Arch | |
log_archive_format | log_%t_%S.arc | |
log_archive_start | TRUE | |
log_buffer | 12582912 | |
open_cursors | 300 | |
os_authent_prefix | ||
parallel_automatic_tuning | TRUE | |
parallel_threads_per_cpu | 4 | |
pga_aggregate_target | 209715200 | |
processes | 150 | |
query_rewrite_enabled | TRUE | |
query_rewrite_integrity | trusted | |
remote_login_passwordfile | EXCLUSIVE | |
resource_manager_plan | SYSTEM_PLAN | |
service_names | ORADB.HOME.NET | |
shared_pool_size | 117440512 | |
star_transformation_enabled | true | |
timed_statistics | TRUE | |
undo_management | AUTO | |
undo_tablespace | UNDOTBS | |
user_dump_dest | $ORACLE_DATA/$ORACLE_SID/v01/Dmp |
Created by OSPRep v0.2.0 © 2003-2004 by Itzchak Rehberg & IzzySoft |