What are the ways you can do the tuning? What are the major steps will you use for these?
Tuning can be done in three ways disk i/o, SQL tunning and memory tunning. Before tuning, you have to get the status of your database using oracle utility called stat pack and tkprof.