RE: Diagnostics Pack
Date: Thu, 7 Aug 2014 13:24:22 +0000
Message-ID: <1AFD62082EEAF0448EF1815139687F1324BF8811_at_NC2PWEX504.us.ad.lfg.com>
With regard to the underlying tables...
From http://docs.oracle.com/cd/E11882_01/license.112/e47877/options.htm#DBLIC167
- All data dictionary views beginning with the prefix DBA_HIST_ are part of this pack, along with their underlying tables, except for these views that you can use without the Diagnostic Pack license: DBA_HIST_SNAPSHOT, DBA_HIST_DATABASE_INSTANCE, DBA_HIST_SNAP_ERROR, DBA_HIST_SEG_STAT, DBA_HIST_SEG_STAT_OBJ, and DBA_HIST_UNDOSTAT.
- All data dictionary views with the prefix DBA_ADVISOR_ are part of this pack if queries to these views return rows with the value ADDM in the ADVISOR_NAME column or a value of ADDM* in the TASK_NAME column or the corresponding TASK_ID.
- Monitoring Views
o MGMT$BLACKOUT_HISTORY
o MGMT$BLACKOUTS
o MGMT$ALERT_ANNOTATIONS
o MGMT$ALERT_NOTIF_LOG
o MGMT$TARGET_METRIC_COLLECTIONS
o MGMT$METRIC_COLLECTIONS
o MGMT$TARGET_METRIC_SETTINGS
o MGMT$AVAILABILITY_CURRENT
o MGMT$AVAILABILITY_HISTORY
o MGMT$ALERT_CURRENT
o MGMT$ALERT_HISTORY
o MGMT$METRIC_DETAILS
o MGMT$METRIC_CURRENT
o MGMT$METRIC_HOURLY
o MGMT$METRIC_DAILY
- Template Views
o MGMT$TEMPLATES
o MGMT$TEMPLATE_POLICY_SETTINGS
o MGMT$TEMPLATE_METRIC_COLLECTION
o MGMT$TEMPLATE_METRIC_SETTINGS
Many years ago, I thought I could design my own "alerting" mechanism by using the underlying diagnostic pack tables when I installed the SYSMAN objects in a database (for database control).
Then, I found the above info in the documentation and had to build everything from scratch...no such loophole!
Chris..
Chris Ruel * Oracle Database Administrator cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chitale, Hemant K
Sent: Thursday, August 07, 2014 5:27 AM
To: ORACLE-L
Subject: Diagnostics Pack
From the 11gR2 Licensing doc at http://docs.oracle.com/cd/E11882_01/license.112/e47877/options.htm#DBLIC165
- Performance monitoring (database and host)
- Event notifications: notification methods, rules, and schedules
- Event history and metric history (database and host)
- Blackouts
In order to use the features listed above, you must purchase licenses for Oracle Diagnostics Pack
Any and all methods of accessing Oracle Diagnostics Pack functionality, whether through Enterprise Manager Console, Desktop Widgets, command-line APIs, or direct access to the underlying data, requires an Oracle Diagnostics Pack license.
So *any* usage of the Performance tab in Oracle Enterprise Manager (hopefully not from command-line scripts which don't use the APIs but query V$SYSSTAT, V$SYSTEM_EVENT !) requires the Diagnostics Pack ?
Hemant K Chitale
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html. Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 07 2014 - 15:24:22 CEST