Skip to Main Content

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!

How to monitor database performance during job runs.

1003624Apr 17 2013 — edited Apr 19 2013
Hi All,

We are running a Batch Job , which fetches data from thousands of table for the 15 days volume and creates the report.

I would like to know what all are the possible way of monitoring the Database performance during the report runs. I need to know some basic performance views and SQL queries from DB which will give the DB performance overview. It should be apart from AWR report .

Please suggest me , your reply will be highly appreciable.

Kind Reagrds
Shankar N
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2013
Added on Apr 17 2013
8 comments
825 views