Month: June 2014

AWR report from SQL Developer 4.0

I found a cool feature in SQL Developer 4.0 today. I was just toying with the new installation on my machine and noticed a Reports tab on the left side of IDE.

There is a new report category called ” Data Dictionary Reports” and another sub-category ASH and AWR. We can find options to generate ASH and AWR report under this sub-menu.

You can find the report tab details below and when i clicked on Last AWR report it pulled the latest AWR report from the repository.



Here is a screenshot of the AWR report , and it was very quick and easy.




Hope this helps..