RE: AWR Licensing

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 28 Jul 2004 11:04:59 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF09660C5B@bosmail00.bos.il.pqe>

Works for me:
oracle_at_dvlpq1 [/home/admin/oracle]sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Jul 28 11:03:41 2004

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> set long 10000
SQL> select text from dba_views where view_name =3D 'DBA_FEATURE_USAGE_STATISTICS'; TEXT

select samp.dbid, fu.name, samp.version, detected_usages, total_samples, decode(to_char(last_usage_date, 'MM/DD/YYYY, HH:MI:SS'),

         NULL, 'FALSE',
         to_char(last_sample_date, 'MM/DD/YYYY, HH:MI:SS'), 'TRUE',
         'FALSE')

currently_used, first_usage_date, last_usage_date, aux_count, feature_info, last_sample_date, last_sample_period, sample_interval, mt.description
from wri$_dbu_usage_sample samp, wri$_dbu_feature_usage fu,

wri$_dbu_feature_metadata mt
where

TEXT

  samp.dbid    =3D fu.dbid and
  samp.version =3D fu.version and
  fu.name      =3D mt.name and
  fu.name not like '_DBFUS_TEST%' and   /* filter out test features */
  bitand(mt.usg_det_method, 4) !=3D 4     /* filter out disabled =

features
*/

-Mark

--

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"On two occasions, I have been asked [by members of Parliament], "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
-- Charles Babbage (1791-1871)

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Wednesday, July 28, 2004 10:57 AM
To: Oracle-L Freelists
Subject: RE: AWR Licensing

On Wed, 2004-07-28 at 01:58, Tony Jambu wrote:

> The underlying objects, programs and views are created by default in 10g. If you access any of the following views:=20

>        The V$ACTIVE_SESSION_HISTORY dynamic performance view=20
>        All data dictionary views beginning with the prefix DBA_HIST_*

along with their underlying tables.
> and others mentioned in the link above, you are required to purchase the optional EM packs. =20
>=20
> Basically big brother is auditing _all_ the features you are accessing!
>=20
>=20

Initial tests seem to indicate that merely querying the views does not increment the counters in DBA_FEATURE_USAGE_STATISTICS.

Interestingly enough as well, a query of dba_views doesn't reveal the underlying tables of DBA_FEATURE_USAGE_STATISTICS.

Jared

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed Jul 28 2004 - 10:01:53 CDT