RE: Oracle license requirements for unused options

  • From: "DOBSON L." <lisa.dobson@xxxxxxxxxxxx>
  • To: <Jay.Miller@xxxxxxxxxxxxxxxx>, <tkiernan@xxxxxxxxxxx>, <Joel.Patterson@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 18 Oct 2011 17:29:02 +0100

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Jay.Miller@xxxxxxxxxxxxxxxx
Sent: 18 October 2011 16:58
To: tkiernan@xxxxxxxxxxx; Joel.Patterson@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx] 
Sent: Tuesday, October 18, 2011 11:40 AM
To: Miller, Jay; Joel.Patterson@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Jay.Miller@xxxxxxxxxxxxxxxx
Sent: Tuesday, October 18, 2011 10:29 AM
To: Joel.Patterson@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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

--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2011