If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

as of next week I need to start tuning the db that comes with our application at site of several customers.
I've theoretical knowledge on tuning (hit rates,...), but where do I really start? Does anyone have tips (and maybe some scripts) where my quest for cpu should start?

First find out what needs to be tuned.
For this you will have to collect statistics. We call it as Benchmark.
Once you have the benchmark then set a goal for it.

Ex:
If one query takes 10hrs to complete it's job, then set a goal like I want to bring it down to 5hrs.

As far as performance is concerned, you should set a goal to yourslef and then findout the
bottleneck. You should not go by 'Increase the performance'.

The problem might be in the statement level.
It might be due to heavy I/O or contention.
It might be due to insufficient memory allocated for Oracle.
It might be due to network.
You might not have enough space in the server itself.

The bottomline is, performance issues can come at any level. Create a benchmark and then
start digging into it.

as of next week I need to start tuning the db that comes with our application at site of several customers.
I've theoretical knowledge on tuning (hit rates,...), but where do I really start? Does anyone have tips (and maybe some scripts) where my quest for cpu should start?

Thx,

Rik

You may try to get some basic info with this script, save it as dba.sql first:

here are the steps for tuning. they are listed in the order. If possiable do #1 then #2 etc. It will do you no good to increase db_block_buffers if some user is doing a full table scan on a table with millions of rows and Gigs of data. (unless of course you use 64bit oracle and have 64GB of RAM ... )