Have you used performance tuning? What major steps will you use for these?

First of all tunning can be done
In three ways: disk i/o ,sql tunning , memory tunings,
Before tunning u have to get the status of your database using
Oracle utility called stat pack , tkprof, then you should go for tunings.