How to monitor database performance during job runs.
1003624Apr 17 2013 — edited Apr 19 2013Hi 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