Re: Script monitoring in lieu of EMGC
- From: Ravi Madabhushanam <ravi.madabhushanam@xxxxxxxxx>
- To: big.dave.roberts@xxxxxxxxxxxxxx, Jed_Walker@xxxxxxxxx
- Date: Wed, 26 May 2010 22:52:34 +0530
You may also want to keep an eye on the table DBA_FEATURE_USAGE_STATISTICS.
Below link describes the contents of this view.
http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/statviews_3166.htm#I1023396
This view has information about various option usage stats, what, when, how
many times. Never know when the Oracle guys query this table and catch the
usage of features.
I guess Oracle will start thinking about uploading this information to MOS
via Configuration Support Manager. ;-)
May be its not a bad idea to enable VPD and disable access and/or updates to
this view for ALL users ;-)
Regards,
Ravi.M
On Wed, May 26, 2010 at 10:31 PM, David Roberts <
big.dave.roberts@xxxxxxxxxxxxxx> wrote:
> Also, make sure you read the comments by Tanel on his own post where he
> details limited information on the new parameter:
> control_management_pack_access!
>
> I also note a blog post from Doug burn referencing the new parameter
> with associated further links:
>
>
> http://oracledoug.com/serendipity/index.php?/archives/1310-Thats-More-Like-It!.html
>
>
> <http://oracledoug.com/serendipity/index.php?/archives/1310-Thats-More-Like-It!.html>
> Dave
>
> On Wed, May 26, 2010 at 5:13 PM, Rodd Holman <rodd.holman@xxxxxxxxx>wrote:
>
>> Thanks, Rich and also Eric that's the info I was seeking.
>>
>> We're going through the license review process now and I wanted to make
>> sure I didn't do anything to get us busted.
>>
>> On 05/26/2010 10:23 AM, Rich Jesse wrote:
>>
>>> Hey Rodd,
>>>
>>>
>>> Tanel Poder's blog:
>>>
>>> http://blog.tanelpoder.com/2009/05/06/free-dba_hist-awr-views-in-11g/
>>>
>>> ...which points out differences in the docs between 11g and 10g as far as
>>> the Diagnostic Pack license and which views can be queried w/o the pack.
>>>
>>> Fun stuff! :)
>>>
>>> Rich
>>>
>>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
Other related posts:
