Could you please email me the following:

1. A copy of your initialization file
2. A copy of your tnsnames and listener files
3. A copy of your alert log
4. Include in the text of your email #CPU's and memory you
have.
5. At a time when you have an average load (watch out for
lunch breaks) run the following:

SVRMGRL> your_oracle_home\rdbms\admin\utlbstat

This will run some scripts to create some temporary tables and collect some statistics.

Let this run for about 2 hours and then run

SVRMGRL> your_oracle_home\rdbms\admin\utlestat

Make sure before you do this that the parameter TIMED_STATISTICS = TRUE. Also, when you run utlestat, make sure you are in a directory that you have write permissions to.

There will be a report generated called report.txt - attach this file as well to your email and send it my way.

Thanks,

Joe