Re: Gather IO stats

joel garry wrote:
> Charles Hooper wrote:
> > Sybrand Bakker wrote:
> > > I see, you are actually re-inventing the wheel...
> > > The functionality you are building is available in 10g, and in several
> > > other products.
> > > Obviously using the commercial alternative is cheaper than you
> > > reinventing the wheel.
> > > Probably someone should tell you to stop reinventing the wheel, and
> > > make sure you spend your employer's time no longer on exercises in
> > > futility.
> > >
> > > Sybrand Bakker, Senior Oracle DBA
> >
> > Available in 10g? Some of the information can be viewed in 10g, with
> > the additional cost Database Diagnostics Pack that can only be added to
> > the Enterprise Edition of Oracle. The Active Session History
> > capabilities in 10g would be nice to have also - yes the ASH
> > information is recorded in the database even when the Database
> > Diagnostics Pack is not enabled.
>
> But does it violate the license to access that information without
> buying EE and Diag?
> http://download-west.oracle.com/docs/cd/B14117_01/license.101/b13552/options.htm#sthref48
> (in particular the section labelled "Some Diagnostics Pack features are
> accessed by way of database server APIs and command-line interfaces").
>
> jg

Considering that access to certain performance views, including those for the Database Diagnostics Pack, is recorded in DBA_FEATURE_USAGE_STATISTICS, I would expect that it would be a violation of the license to directly access those views.

http://www.oracle.com/technology/books/pdfs/wait_tuning_ch8.pdf Pg 3: "Many of these features support Oracle's assertion that 10g is easier to manage than previous versions. Obviously, the new features have required many man-hours to develop and test, so it is reasonable that they recuperate some of the investment through additional fees. However, keep in mind that many components that are now integrated into the Relational Database Management Systems (RDBMS) started out as separate, additional-cost features.

There are views named dba_feature_usage_statistics and dba_advisor_usage which record usage of the new features. These reports indicate that the user needs to purchase the license for the additional products. In other words, usage of features like AWR, ASH and ADDM is recorded in the database."

One of the unfortunate features of 10g R2 is that all of the additional cost performance tuning features are enabled by default (even for the Standard Edition), until the SYSMAN user logs into Enterprise Manager for the first time, and is asked which features need to be disabled. How many companies are unknowingly violating their license agreement by mistakenly accessing this feature?

Hence the need to periodically capture information from the standard performance views in order to analyze changes in performance. My project actually started when I was still working with Oracle 8i.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Mon Jul 31 2006 - 18:09:07 CDT