Hello

I think that is 2 much information.i suggest you plaese read the oracle docs on tuning.and preferably this book oracle sql high performance tuning by guy harrisson.

regards
Hrishy