Quick Tip: Snapshot Findings and ADDM Reports in SQL Developer 4

thatjeffsmith SQL Developer 12 Comments

Tell Others About This Story:

One of our bigger new features for version 4 is our new support for the Database Diagnostic Pack. We have a new interface for your ASH, AWR, ADDM reports, and snapshots, baselines, etc.

I want to show you a quick navigation trick today: how to quickly go from snapshots with findings to the actual ADDM findings report.

First things first: open your snapshots list.

First things first: open your snapshots list.

On the DBA tree, click on the Snapshots node. Don’t expand the node, click on the top level node itself. This will give you a list of all of your snapshots.

You can now sort by ‘ADDM Findings,’ and find all of your ‘YES’ items.

Then click on the hyperlinked blue ID text – this will open that particular snapshot.

Then you can click on the ADDM report hyperlinked blue ID text, and then toggle to the ‘ADDM Report’ tab.

Bonus tip: I’ve created 2 additional document tab groups so you can see all three editors at once in the screenshot above.

If in doubt, check your licenses.

If you don’t know if you have licensed the Enterprise Edition Diagnostic Pack features, please check your contracts and the fine print before using this feature in SQL Developer.

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Comments 12

  1. Hello JeffSmith

    I have a problem, We have licensed the Enterprise Edition Diagnostic Pack , And I tray to see ADDM on my SQL Developer, (Tab DBA), but, when I try to see it, the application show me this error: ORA-00942: Table or View Does not exists, provider code: 942.

    Please tell me what should I do?

    1. thatjeffsmith Post
      Author
      1. Ok,

        I saw your coment, and I found on my DB all DBMS_ADVISOR% rows but not found DBMS_ADDM%

        What happened here?

        1. thatjeffsmith Post
          Author
          1. You say: “you have access to views like dba_addm_findings, dba_advisor_tasks….”, so I try to execute this:

            select * from dba_objects where object_name like ‘DBA_ADDM%’; Not Return Nothing

            and

            select * from dba_objects where object_name like ‘DBA_ADVISOR%’; Return 56 rows

            What I need to see, for execute ADDM on SQL Developer…. ? I have SYS user for this procedure….

          2. thatjeffsmith Post
            Author
        1. thatjeffsmith Post
          Author

          track down the offending query with a trace, or use the ‘Statements’ feature in version 4.1 – then triage your database or let me know what we’re doing wrong. Or open a SR with MOS.

      1. thatjeffsmith Post
        Author

Leave a Reply

Your email address will not be published. Required fields are marked *