SQL Developer 4 EA2 includes a performance node in the DBA tree.
You can use this to view ADDM, AWR and ASH reports directly from SQL Developer. I know I can get these from Cloud Control, but previously I tended to pull these out from the command line on the server. This is a much better approach IMHO.
I found out about this stuff at OOW2013, whilst talking to Jeff Smith and Barry McGillin in the demo grounds. I tweeted some pictures at the time, but figured it was worth a post for those that don’t do Twitter. 🙂
Cheers
Tim…
PS. Yes, it is only going to be of use to people connecting to Enterprise Edition databases with the Diagnostics & Tuning Pack.
Performance Reports in SQL Developer 4 EA2 | The ORACLE-BASE Blog http://t.co/mq6CivUW4b
RT @oraclebase: Performance Reports in SQL Developer 4 EA2 | The ORACLE-BASE Blog http://t.co/mq6CivUW4b
Tim Hall: Performance Reports in SQL Developer 4 EA2: SQL Developer 4 EA2 includes a performance node in the D… http://t.co/X5Y1bCQo7l
RT @oraclebase: Performance Reports in SQL Developer 4 EA2 | The ORACLE-BASE Blog http://t.co/mq6CivUW4b
Hi Tim, nice, however only useful with EE, what really would help much more DBAs in the world would be some useful performancetools for SE and SEONE editons
RT @oraclebase: Performance Reports in SQL Developer 4 EA2 | The ORACLE-BASE Blog http://t.co/mq6CivUW4b
@Gerrit : That argument has been made so many times. Quite frankly, it’s not going to happen.
If you go to 12c there *may* be some exception for some of the diagnostics available from DBExpress, but that’s not a promise. For most tools though, this is the way it is and this is the way it is going to stay. To quote the late Mark Townsend,
“Oracle’s stance is Enterprise Edition and the Diagnostics & Tuning Pack are the entry level product”
You might not like that, but that is the way it is. 🙁
Cheers
Tim…
RT @orafaq: Tim Hall: Performance Reports in SQL Developer 4 EA2: SQL Developer 4 EA2 includes a performance node in the D… http://t.co/X…
Thanks for sharing !