Oracle SQL Monitoring
All of us has some point in time used Oracle SQL monitoring reports which are pretty useful to identify critical statistics for an currently running query which can be find through various database queries as well. With SQL monitoring reports it makes pretty easy for DBA's to identify real time statistics about qery execution state. There are multiple ways where sql monitoring reports can be extracts Real Time - Fetch the reports when query is running. Historical Reports - Fetch the reports when queries are already completed in some point time in history. Real Time Reports can be extracted through OEM (Oracle Enterprise Manager) SQLPLUS commands - We are going to discuss them within this blog. Very often everyone of us might of noticed sql monitoring reports are not generated for all queries, which is due to some important factor: _sqlmon_threshold with default value of 5 means any query which has combined CPU and I/O execution more than 5 seconds is entit