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..