BC remote Oracle DBA - Call (800) 766-1884  
Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

   
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

 

 
 

Improper Initialization File Parameter Settings

Oracle Tips by Mike Ault

For Oracle7, version 7.3, there are 154 initialization parameters, for Oracle8, version 8.0.5, there are 184. In Oracle8i there are 194. In Oracle9i version 9.0.1 there are 251 and in 9iR2, 257. In 10g the number of parameters actually dropped to 254 but the number of undocumented parameters increased. In 9iR2 the number of undocumented parameters was 583 up to 918 in 10gR1.

Fortunately there are very few that you need to adjust to tune Oracle. Table 2 lists the major tuning parameters, but is not supposed to be a complete list by any means.

Parameter

Definition

create_bitmap_area_size

This sets the memory area for bitmap creation

bitmap_merge_area_size

This is the memory area used for bitmap merge

create_stored_outlines

This allows Oracle to create stored outlines

cursor_sharing

This sets for automated literal replacement

db_file_multiblock_read_count

This sets the read size for full table and index scans

filesystemio_options

This is used to set direct or AIO options for filesystem reads

optimizer_index_caching

Used to tune index access

optimizer_index_cost_adj

Used to tune index access

query_rewrite_enabled

Sets for queries to be rewritten to use materialized views or FBIs

query_rewrite_integrity

Sets the criteria for when MVs are used.

session_cached_cursors

Sets the number of cached cursors at the session level

sga_max_size

Sets the maximum SGA memory size

sga_target

Sets the baseline SGA memory size

star_transformation_enabled

Allows Oracle to use star transformation

transactions_per_rollback_segment

Sets the number of transactions that will use a single rollback (undo) segment

pga_aggregate_target

Sets the total PGA memory usage limit

workarea_size_policy

Determines how workareas (sort and hash) are determined

buffer_pool_keep

Sets the size of the keep buffer pool for tables and indexes

buffer_pool_recycle

Sets the size of the recycle buffer pool for tables and indexes

cursor_space_for_time

Sacrifices memory for cursor storage space

db_16k_cache_size

Sets the size of the 16K cache size

db_2k_cache_size

Sets the size of the 2K cache size

db_32k_cache_size

Sets the size of the 32K cache size

db_4k_cache_size

Sets the size of the 4K cache size

db_8k_cache_size

Sets the size of the 8K cache size

db_block_size

Sets the default block size for the database

db_cache_size

Sets the default cache size

Table 2: Tuning Parameters

How to determine proper setpoints for all of these is beyond the scope of this paper. However the Oracle tuning guides provide many good tips as does the Burleson Consulting web site: www.remote-Remote DBA.net.

SEE CODE DEPOT FOR FULL SCRIPTS


For more information on this topic, I recommend Don Burleson's latest book "Oracle Tuning: The Definitive Reference". 

You can buy it direct from the publisher for 50%-off and get instant access to the code depot of Oracle tuning scripts:

http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm

 


Expert Remote DBA

BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call
BC Remote DBA today.

 

 

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.



Hit Counter