The Anti-Kyte

Oracle – for when it was like that when you got there

Main menu

Skip to primary content
Skip to secondary content
  • Home
  • About

Tag Archives: Oracle Feature Usage

DBMS_FEATURE_USAGE_REPORT and The Phantom AFTER SELECT Trigger

Posted on January 23, 2013 by mikesmithers
2

Splat !
Darth Debbie has just launched a surprise attack using her current favourite weapon. Never get into a snowball fight with that woman.
Milton Keynes, like much of the UK at the moment, looks less like it’s leafy, quiet self and more like the Arctic Tundra at present.
Being in a part of the country where normally, you can tell the changing of the seasons by the changing temperature of the rain, a little bit of snow always causes chaos.
On the plus side, the national weather forecasters – The Met Office – issue colour-coded weather warnings which, at times like this include the always hilarious Yellow Snow Warning.

Anyway, the reason for the Star Wars references in this post is that I was planning to cover the whole question of license monitoring with particular reference to the Diagnostic and Tuning packs. However, it was getting to be more of a novel than a blog post so I’ve decided to split it down into more manageable chunks…or Episodes.
So, in the style of the Epic Space Opera, please imagine the following paragraph scrolling through space with John Williams and his Orchestra blaring out of your speakers…

Episode 1 – The Phantom AFTER SELECT Trigger

It is a time of license audits.
The sinister Oracle Corporation have besieged the peaceful Database with some arcane licensing restrictions.
The Geeki, keepers of peace and tranquility in the Data Centre are on the case.
Using their mystical powers, they begin to investigate DBMS_FEATURE_USAGE_REPORT to discover

  • Where Oracle stores information on Database Features being used
  • How this information is collected
  • What unnatural force powers are at work to enable the recording of SELECT statements against some tables and views

Queen Debbie ( she’s changed sides in this paragraph) is wondering just how geeky this is all going to get ….

Continue reading →

Posted in Oracle, SQL | Tagged AWR, dba_dependencies, DBA_FEATURE_USAGE_STATISTICS, dba_views, DBMS_FEATURE_USAGE_INTERNAL, DBMS_FEATURE_USAGE_REPORT, Oracle Feature Usage, Oracle licensing, wri$_dbu_feature_metadata, wri$_dbu_feature_usage, wri$_dbu_usage_sample | 2 Replies

I’ve re-decorated

At the suggestion of my style guru (Deb), I'm trying out a different Wordpress theme for the blog. Hopefully you will find this makes things a little bit easier to read. Navigation etc should be unaffected. Please let me know if you come across any glitches. Thanks, Mike

Search

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 57 other followers

Popular Ramblings

  • Solved – The Mystery of SQLDeveloper and the Missing ocijdbc11
  • Installing Oracle 11gXE on Mint and Ubuntu
  • Getting output from Ref Cursors in PL/SQL
  • Installing Ubuntu in VirtualBox on a Windows 7 Host
  • A Quick guide to Cygwin commands for the deprived of the DOS world

Ramblings by Category

Past Ramblings

Pages

  • About

Blogroll

  • Boneist's Oracle Blog
  • Connor McDonald
  • Grassroots Oracle
  • Jeff Kemp
  • Jeff Smith
  • Red Database Security Blog
  • SimCard
Theme: Twenty Eleven | Blog at WordPress.com.
Follow

Get every new post delivered to your Inbox.

Join 57 other followers

Powered by WordPress.com