Oracle 10g tuning

[DrDDT]

Hi!

For Oracle 9.2 we are using the following optimisations as recommended by OpenText:

Optimizer_mode=choose;
Optimizer_index_caching=80;
Optimizer_index_cost_adj=5;
Query_rewrite_enabled=true;
Query_rewrite_integrity=enforced;
Cursor_sharing=exact;

Generate full statistics using COMPUTE rather than ANALYZE on a percentage.
Maintain stats regularly (overnight every night, for example).


Do these still apply for 10g?

 

[DrDDT]

Oracle 10g Parameters:
db_file_multiblock_read_count=16
optimizer_mode=ALL_ROWS
optimizer_index_caching=90
optimizer_index_cost_adj=10
pga_aggregate_target=( <Total Physical Memory> * 80%) * 20%
statistics_level=TYPICAL | ALL
workarea_size_policy=AUTO
Statistics:
Oracle 10g automatically generates statistics based on percentage of table modification. Table, index and column statistics will be generated by default as long as statistics_level=TYPICAL or statistics_level=ALL.

 

[ggriffit]

DrDDT,
where did you get your Oracle 10g params from ?


Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005

http://www.greggriffiths.org/livelink/

 

[DrDDT]

Greg,

I got them from Opentext UK Support.