you could read a book called Oracle 24 X 7 tips and techniques by venkat devraj which i think adreses a lot of questions in this area.

hth