Solved

Oracle Initialization Parameters

Posted on 2009-04-03
2
285 Views
Last Modified: 2013-12-18
Is there a script or optimal way of figuring out what the following 2 Oracle parameters should be set to in an Oracle 10gR2 Database that is considered a hybrid (Both Database Warehouse and OLTP) Database: optimizer_index_cost_adj and optimizer_index_caching.

My Database is quite small, only 27 GB in size but is run on a very powerful machine that has 32GB of RAM and 8 CPUs.
0
Comment
Question by:BISCO3
2 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 250 total points
ID: 24060602
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question