Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Saving AWR report from SQL developer

BV2925Jun 22 2016 — edited Jun 22 2016

Hi Folks,

I am new to sql developer and have a situation where I would want to save the awr snapshots to my local machine. I can view the snapshots taken every one hour and can access them in sql developer.

Any ways that I can save them to my local OC?

Thanks.

BV

Comments

thatJeffSmith-Oracle

yeah, hit the web/browser button in the toolbar, that will write it to a tmp HTML file that opens in your browser

diagnostics5.png

diagnostics6.png

Or just use the 'Save' button I guess...

BPeaslandDBA

Have you considered setting up an AWR warehouse? That way, you don't have to deal with the individual reports and you can save off your historical AWR information...all of it.

Cheers,
Brian

BV2925

Thanks for the response but I do not see that option and guess should probably activate it or access it from somewhere within SQLDEV.

Below is a screen shot of the snapshot files that i see.

Capture.PNG

When I click on one of the snapshot, the panel on the right looks like this.

Capture.PNG

thatJeffSmith-Oracle

snapshots aren't reports

you can have findings attached to snapshots...you need to navigate via the ADDM findings or just open the ADDM tree item and view the reports there

I talk about this here

BV2925

Thank you. Got it now.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 20 2016
Added on Jun 22 2016
5 comments
1,408 views