Hi,


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.

Vijay.