Check the following to tune db

v$sqlarea
v$filestat
v$system_event

Also genarate a statspack for 1hr to get a fair idea.
______
Sekhar