RE: Oracle license requirements for unused options
Date: Tue, 18 Oct 2011 15:57:49 +0000
Message-ID: <0D8F4CAC0F9D3C4AACC63F50FD9957F72592BFBD_at_PRDCTWPEMLMB03.prod-am.ameritrade.com>
Hmm, in 10.2.0.4 that gives me:
SQL> select distinct name
from DBA_FEATURE_USAGE_STATISTICS
where name like 'Diag%'
or name like 'SQL%'
order by name
SQL Access Advisor
SQL Tuning Advisor
SQL Tuning Set
Jay Miller
Sr. Oracle Database Administrator
201.369.8355
-----Original Message-----
From: TJ Kiernan [mailto:tkiernan_at_pti-nps.com]
Sent: Tuesday, October 18, 2011 11:40 AM
To: Miller, Jay; Joel.Patterson_at_crowley.com; oracle-l_at_freelists.org
Cc: TJ Kiernan
Subject: RE: Oracle license requirements for unused options
Diagnostics pack is there, but not broken out. The Tuning pack is broken out (10.2.0.5):
select distinct name
from DBA_FEATURE_USAGE_STATISTICS
where name like 'Diag%'
or name like 'SQL%'
order by name
/
NAME
Diagnostic Pack
SQL Access Advisor
SQL Tuning Advisor
SQL Tuning Set
4 rows selected.
Thanks,
T. J.
-----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: Tuesday, October 18, 2011 10:29 AM
To: Joel.Patterson_at_crowley.com; oracle-l_at_freelists.org
Subject: RE: Oracle license requirements for unused options
Unfortunately I'm pretty sure that DBA_FEATURE_USAGE_STATISTICS does not include the diagnostic pack or tuning pack until 11g and we're still on 10g for most of our databases.
Jay Miller
Sr. Oracle Database Administrator
201.369.8355
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 18 2011 - 10:57:49 CDT