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.

thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

12 Comments

  1. Mauricio Rodriguez Reply

    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?

    • thatjeffsmith

      Make sure you have access to views like dba_addm_findings, dba_advisor_tasks, dba_advisor_parameters, dba_scheduler_jobs, etc.

      That panel assumes your account has DBA privs.

    • Mauricio Rodriguez

      Ok,

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

      What happened here?

    • Mauricio Rodriguez

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

    • thatjeffsmith

      are you 12c multitenant? make sure you’re connected to the container database and not the pluggable

    • Mauricio Rodriguez

      The data base is 10G, I see AWR and ASH on SQL Developer, but not ADDM, I need to install anithing?

    • thatjeffsmith

      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.

    • thatjeffsmith

      It’s possible we’re trying to hit something that doesn’t exist in 10g. Are you on 10gR1 or 10gR2?

    • Mauricio Rodriguez

      Hi Jeff

      Version: 10.2.0.4.0, I don know why not see this tables, %ADDM%, what can I do?

Write A Comment