RE: Oracle license requirements for unused options
- From: "TJ Kiernan" <tkiernan@xxxxxxxxxxx>
- To: <Jay.Miller@xxxxxxxxxxxxxxxx>, <Joel.Patterson@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 Oct 2011 10:40:11 -0500
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
Other related posts:
- » Oracle license requirements for unused options- Jay.Miller
- » Re: Oracle license requirements for unused options- Toon Koppelaars
- » RE: Oracle license requirements for unused options- Khan, Arif
- » Re: Oracle license requirements for unused options- Rich Jesse
- » Re: Oracle license requirements for unused options- Paul Drake
- » Re: Oracle license requirements for unused options- Toon Koppelaars
- » Re: Oracle license requirements for unused options- Howard Latham
- » RE: Oracle license requirements for unused options- Dunbar, Norman (Capgemini)
- » RE: Oracle license requirements for unused options- Dunbar, Norman (Capgemini)
- » Re: Oracle license requirements for unused options- Iquatealerts
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- Allen, Brandon
- » RE: Oracle license requirements for unused options- Goulet, Richard
- » RE: Oracle license requirements for unused options- norman . dunbar . capgemini
- » RE: Oracle license requirements for unused options- Goulet, Richard
- » RE: Oracle license requirements for unused options- Dunbar, Norman (Capgemini)
- » RE: Oracle license requirements for unused options- norman . dunbar . capgemini
- » RE: Oracle license requirements for unused options- Dunbar, Norman (Capgemini)
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- Allen, Brandon
- » RE: Oracle license requirements for unused options- Yong Huang
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- Joel.Patterson
- » RE: Oracle license requirements for unused options- D'Hooge Freek
- » RE: Oracle license requirements for unused options- Joel.Patterson
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- Joel.Patterson
- » RE: Oracle license requirements for unused options - TJ Kiernan
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- DOBSON L.
- » RE: Oracle license requirements for unused options- Chitale, Hemant Krishnarao
- » RE: Oracle license requirements for unused options- Joel.Patterson
- » RE: Oracle license requirements for unused options- Joel.Patterson
- » Re: Oracle license requirements for unused options- De DBA
- » RE: Oracle license requirements for unused options- D'Hooge Freek
- » Re: Oracle license requirements for unused options- Howard Latham
- » RE: Oracle license requirements for unused options- Joel.Patterson
- » Re: Oracle license requirements for unused options- De DBA