RE: AWR Viewer

From: Job Miller <>
Date: Fri, 3 Oct 2008 19:46:11 -0700 (PDT)
Message-ID: <>

have you ever clicked the "(+)" sign at the bottom of home page in grid control?

It turns on link annotation, that shows you exactly what each link *may* require in terms of packs to use.  I say may because it shows many different packs for each link usually, because depending on the tab/link, there may be more than one pack that provides that functionality for that target. 

If you disable the packs in the setup, those links that require licensing go away.  As someone mentioned earlier, disable DIAG/TUNING and the Performance Tab goes away.

You can click on the link annotation, and it will launch built in help that explains that "DC" means "Database Configuration", and it describes in a paragraph for each pack what functionality that pack provides.

For example, if you see a metric for a host that is a hyperlink, that hyperlink is only enabled because you licensed one of the following things (DD, AD, SM...)  Database Diagnostics (if it is a DB Server), AS Diagnostics (if it is an App Server), or System Monitoring for Hosts (if it is just a host you are monitoring).

Any of those packs on that target will enable the historical collection of a particular metric related to that host.  Without that pack, you will just have the current metric.

Grid control is still very useful without packs for centralized db admin via a "GUI".  It prevents the need for 30 different standalone java containers on a single server because you have 30 databases running on it all with DB Console turned on..  Lots of folks are still holding on to the 9i thick java client for centralized admin because they can't/won't/don't want to install GC somewhere.


  • On Fri, 10/3/08, Jackie Brock <> wrote:

From: Jackie Brock <> Subject: RE: AWR Viewer
To:, "Matthew Zito" <>, Date: Friday, October 3, 2008, 2:01 PM

Oracle really does need to provide a licensing FAQ and tutorial... perhaps even a training course! It's amazing how hard it is to get specific information about what's covered and what's not.

I think the difficulty here may lie with the fact that yes, you can install and run grid control without the diagnostics packs (et al), but you can't do much with it. I believe that there is something in the install documentation for OEM that discusses whether grid control is included or not - my recollection is that grid control is included with the database, but not useful without the packs.  


Jackie D. Brock
Database Specialist - Systems Evaluation CableLabs(r)
858 Coal Creek Circle
Louisville, CO 80027


Received on Fri Oct 03 2008 - 21:46:11 CDT

Original text of this message