RE: Oracle license requirements for unused options
Date: Tue, 18 Oct 2011 16:33:24 +0200
Message-ID: <4814386347E41145AAE79139EAA39898193727D0A5_at_ws03-exch07.iconos.be>
Jay,
You can check the MGMT_ADMIN_LICENSES view to verify if someone has clicked "yes" in the dbconsole when asked if a license was available for the management pack.
Don't know if there is a flag set when running the awrrpt.sql script or when selecting directly from the hist* tables.
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jay.Miller_at_tdameritrade.com
Sent: dinsdag 18 oktober 2011 16:16
To: oracle-l_at_freelists.org
Subject: RE: Oracle license requirements for unused options
Revisiting this thread from back in May... Does anyone know of a method in 10g to check whether a Diagnostic Pack option was ever used? I'm concerned that someone might at some point have run an awrrpt on a dev database without realizing that required a license and want to check whether it has ever happened.
For 11g Oracle provides scripts to check this (option_usages.sql) but they don't seem to work in 10g.
Appreciate any help in advance.
BTW - people might find this of interest: http://searchoracle.techtarget.com/news/2240035131/Common-traps-in-Oracle-licensing-audits I have verified that when we uninstall certain options and then patch the database the options come back.
Thanks,
Jay Miller
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 18 2011 - 09:33:24 CDT