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

Locked Post

New comments cannot be posted to this locked post.

Locked on May 17 2013

Added on Apr 17 2013

#11g, #database, #general-database-discussions, #performance, #report

8 comments

831 views