Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Investigate database activity at a specific time

486215Jun 18 2009 — edited Jun 23 2009

I am working on Oracle 10.2.0.4 database on OEL 5.

We had a heavy load on the database yesterday evening and the database was performing very slowly.

Is it possible to check what activity would have occurred at that time.

OEM can be of help but I thought if there are any other database views other than the AWR which stores these information ?

Any suggestions would be of great help?

If it is only through AWR which tables and columns should i query for relevant data?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 21 2009

Added on Jun 18 2009

#general-database-discussions

9 comments

1,138 views