Oracle db very slow | where to look

Hi All,

I couldnt find pertinent info about this through google....

We had a database running on Oracle9i Release 9.2.0.8.0 - 64bit. Recently something went wrong and we had an external dba come in and look at it. He said that it is unrecoverable, & he restored it from a backup and left.

But now our application runs very very slow when connected to this db. I am still a newbie at this - so can you please point me where to start looking to find the root cause of the performance problem. (logs / parameters etc..). We do not have much data - we have about 50 tables and each table has about 2000 rows.

I am thinking that the dba turned on some tracing or something to debug our db problems and forgot to turn them off before giving it back to us.

Thanks,
Anoop Received on Fri Jan 12 2007 - 13:01:05 CST