RE: Oracle license requirements for unused options

From: DOBSON L. <lisa.dobson_at_durham.ac.uk>
Date: Tue, 18 Oct 2011 17:29:02 +0100
Message-ID: <DA43BFC7EF4DB2499791854EB0431E4802F77BF1_at_DURMAIL2.mds.ad.dur.ac.uk>

I see Automatic Workload Repository listed in 10.1.0.5

SQL> select distinct name

        from dba_feature_usage_statistics
where name like 'Auto%';

NAME

---

Automatic Database Diagnostic Monitor
Automatic SQL Execution Memory
Automatic Segment Space Management (system) Automatic Segment Space Management (user) Automatic Storage Manager
Automatic Undo Management
Automatic Workload Repository

7 rows selected.

Lisa.

-----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: 18 October 2011 16:58
To: tkiernan_at_pti-nps.com; Joel.Patterson_at_crowley.com; oracle-l_at_freelists.org Subject: RE: Oracle license requirements for unused options

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 18 2011 - 11:29:02 CDT