StatsPack Report for oradb


Common Instance Information
Hostname:sv2001
Instance:ORADB
Version:9.0.1.0.0
Cluster:NO
FileSize (Data+Log) 92,701.00 MB
Startup / Uptime15.12.2003 17:03 / 48.81 d
Report generated:02.02.2004 12:27


SnapShot Info
 Snap ID Snap TimeSessionsCurs/SessComment
Start48915.12.2003 18:0047 4.49 
End117310.01.2004 12:0042 5.21 
Elapsed: 37,079.47 min


Cache Sizes (End)
CacheSize
Buffer Cache 304 M
Std Block Size 16 K
Shared Pool Size 112 M
Log Buffer 12,288 K


Load Profile
 Per SecondPer 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%)
EventEfficiency (%)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.06A 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.99See Soft Parse above.
Non-Parse CPU 91.68 


Shared Pool Statistics
NameBeginEnd
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
EventWaitsWait 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.
If your primary tuning goal is reducing resource usage, start tuning these statements/objects (CPU) plus SQL by Reads (File IO).

Buffer GetsExecutions Gets per Exec% TotalCPU Time (s)Elapsed Time (s)Hash Value
10,284,393 1 10,284,393.0 0.4 397.99 745.193734559764
  select * from wumm.intern
7,861,780 346 22,721.9 0.3 0.04 0.102033635752
  BEGIN xon.hum_load; END;
3,726,207 346 10,769.4 0.1 0.06 0.072712042468
  DELETE from xo_import where subtype='HUM'
2,941,519 346 8,501.5 0.1 51.41 76.591566221371
  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.08300667169
  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 ReadsExecutionsReads per Exec% Total CPU Time (s)Elapsed Time (s)Hash Value
382,085 1 382,085.0 0.1 598.94 1,017.183217870462
  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.193734559764
  select * from wumm.intern
155,454 4,859 32.0 0.6 0.02 0.011125808767
  INSERT INTO DM.DM_KDFLOP (DATEI,DATA) VALUES (:DATEI,:DA TA)
147,003 2 73,501.5 0.1 67.77 117.753115724095
  select * from bc_btram_l1 where --wkl='907250' kno=401071 026587
 
OperationObject OptimizerCostCPUCostIOCostSize
SELECT STATEMENT
.CHOOSE 10,408  
 
. VIEW
.  10,408  
242 k
. . UNION-ALL
.     
 
. . . INDEX FAST FULL SCAN
XON.LID0100_IXBIDANALYZED 5,199  5,199
69 k
. . . INDEX FAST FULL SCAN
XON.LID0100_IXASKANALYZED 5,209  5,209
69 k
81,810 1 81,810.0 0.2 97.78 113.58782365933
  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.
ExecutionsRows ProcessedRows per ExecCPU per Exec (s) Elap per Exec (s)Hash Value
434,305 618 0.0 11.65 405.802963598673
  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.232964743345
  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.431353809701
  /* 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.821826919589
  COMMIT
14,093 13,975 1.0 128.43 -1,417.794083054575
  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 CallsExecutions% Total ParsesHash Value
130,202 130,201 0.011353809701
  /* 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.001826919589
  COMMIT
17,531 0 0.003127169738
  SELECT * FROM "WUMM"."MAN_P"
8,006 8,005 0.002501101467
  select name from v$database
7,823 14,093 0.004083054575
  SELECT "WKL","AZU","KRZ" FROM "WUMM"."MAN_P" "A" WHERE "AZU"=:1


TableSpace IO Summary Statistics 
Ordered by IOs (Reads + Writes) desc
TableSpaceReadsAvgReads/sAvgRd (ms)Avg Blks/Rd WritesAvg Wrt/sBuffer WaitsAvg 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
TableSpaceFilenameReadsAvgReads/sAvgRd (ms) Avg Blks/RdWritesAvg Wrt/sBuffer WaitsAvg 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 BuffersCache Hit %Buffer GetsPhyReads PhyWritesFreeBuf WaitsWrt complete WaitsBuffer Busy WaitsHitRatio (%)
D19247 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 IOsActual Redo Blks Target Redo BlksLogFile Size Redo BlksLog Ckpt Timeout Redo BlksLog 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
ClassWaitsTot 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
StatisticBegin (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
EqRequestsSucc GetsFailed GetsPctFail WaitsAvg 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 GetsPct WaitsUndo Bytes WrittenWraps ShrinksExtends
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

Rollback Segments Storage 
Optimal Size should be larger than Avg Active
RBS#Segment SizeAvg ActiveOptimal SizeMaximum Size
0 507,904 0  507,904
1 1,163,264 844,097  134,332,416
2 1,163,264 1,405,125  125,943,808
3 2,211,840 1,562,728  117,555,200
4 2,211,840 1,186,645  234,995,712
5 1,163,264 1,289,993  125,943,808
6 1,163,264 831,717  151,109,632
7 2,211,840 3,214,062  134,332,416
8 2,211,840 1,423,485  134,332,416
9 2,211,840 1,025,864  159,498,240
10 2,211,840 1,522,207  193,052,672


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# TXNMax Qry Len (s)Max Tx Concurcy Snapshot Too OldOut of SpaceuS/ur/uU / eS/eR/eU
1 1,667,475 2,340,199 588,928 8 1 00/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
CacheGet RequestsPct MissScan ReqsPct Miss Mod ReqsFinal UsagePct 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

Library Cache 
"Pct Misses" should be very low (< 10%), "Reloads" should not be significantly high.
NameSpaceGet RequestsPct MissPin ReqsPct Miss ReloadsInvalidations
BODY 21,805 0.95 21,804 1.89 205 0
CLUSTER 19,983 1.63 22,347 2.92 0 0
INDEX 220 36.82 227 41.41 0 0
SQL AREA 11,332,752 48.19 35,816,720 30.58 34,333 26,567
TABLE/PROCEDURE 9,806,156 0.24 37,545,695 0.29 39,312 0
TRIGGER 3,734,445 0.06 3,734,489 0.07 393 0


SGA Memory Summary
Values at the time of the End SnapShot
SGA RegionSize 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
PoolNameBegin 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 NameBegin ValueEnd Value (if different)
O7_DICTIONARY_ACCESSIBILITYTRUE 
background_dump_dest$ORACLE_DATA/$ORACLE_SID/v01/Dmp 
compatible9.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_size16384 
db_cache_size318767104 
db_domainOMUC.BAAG 
db_file_multiblock_read_count24 
db_nameORADB 
fast_start_mttr_target300 
global_namesFALSE 
ifile$ORACLE_BASE/adm/init/init.ora 
instance_nameORADB 
java_pool_size16777216 
job_queue_processes1 
large_pool_size10M 
log_archive_dest_1location=$ORACLE_DATA/$ORACLE_SID/v03/Arch 
log_archive_formatlog_%t_%S.arc 
log_archive_startTRUE 
log_buffer12582912 
open_cursors300 
os_authent_prefix  
parallel_automatic_tuningTRUE 
parallel_threads_per_cpu4 
pga_aggregate_target209715200 
processes150 
query_rewrite_enabledTRUE 
query_rewrite_integritytrusted 
remote_login_passwordfileEXCLUSIVE 
resource_manager_planSYSTEM_PLAN 
service_namesORADB.HOME.NET 
shared_pool_size117440512 
star_transformation_enabledtrue 
timed_statisticsTRUE 
undo_managementAUTO 
undo_tablespaceUNDOTBS 
user_dump_dest$ORACLE_DATA/$ORACLE_SID/v01/Dmp 


Created by OSPRep v0.2.0 © 2003-2004 by Itzchak Rehberg & IzzySoft