Timeline for How to find the latest SQL statements within the database?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 11, 2015 at 14:53 | history | edited | Sathyajith Bhat | CC BY-SA 3.0 |
added 26 characters in body
|
| Jan 5, 2011 at 15:06 | comment | added | ScottCher | Oracle Enterprise Manager (OEM) is very nice. We can monitor our database health in near real-time with auto-refreshed graphs. We've got a big monitor hanging on a wall showing OEM for our primary databases 24x7 and its hugely beneficial in identifying problems as they occur. | |
| Jan 4, 2011 at 5:46 | comment | added | Sathyajith Bhat | Sorry I should have mentioned it - from what I know, AWR requires a separate licensing - the Oracle Tuning & Diagnostic Pack. I prefer to use AWR from the Enterprise Manager console - I've been blessed with the privilege(!) to utilize the Enterprise Manager console. I also found that you can use SQL Developer to monitor SQLs, but that requires the above licensing | |
| Jan 4, 2011 at 5:17 | comment | added | Sebastian Roth | Out of curiosity - AWR is a tool available to all Oracle licenses & could I use it via command line only? | |
| Jan 4, 2011 at 4:43 | history | answered | Sathyajith Bhat | CC BY-SA 2.5 |