RE: AWR Licensing
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Jul 2004 11:04:59 -0400
Works for me:
oracle@dvlpq1 [/home/admin/oracle]sqlplus "/ as sysdba"
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Jul 28 11:03:41 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
