Finding trends and signatures for proactive tuning

One shortcoming with reactive tuning approaches like Oracle's automatic memory management (AMM) is that it is reactive, and it waits until a problem is signaled before taking remedial actions.  To be truly proactive, we must develop techniques that will analyze repeating trends and identify processing signatures.

These trends, in turn, will predict changes in workload characteristics.  If you know in-advance when a workload is going to change, you can adjust the SGA just-in-time to accommodate the new workload, fixing the issue before it bothers your end-user community.

This is the idea behind creating a self-tuning Oracle database, a proactive technique that I've been working on for over a decade.

To get started, you must use AWR or STATSPACK queries to identify changing workloads, analyzed in a linear regression, as well as by hour-of-the-day and day-of-the-week.  Once you do this, "signatures" will become apparent, and you will see when your workload changes, the first step in proactive self-tuning for an Oracle database.

I'm excited to announce that after years of work, I've finally completed a comprehensive tool for identifying hidden trends and signatures, Ion for Oracle.  Ion uses applied artificial intelligence to remove the tedium from proactive analysis, leaving you free to do the intuitive work:

http://www.ion-dba.com/index.html

To see how you can visualize your database you can download Ion Lite here (limited fucntionality), and this coupon allows you to try it for only $29.95:

coupon_code=newsletter

For more on techniques, see the link below and see how predictive analytics forms the foundation for a self-tuning database:

http://www.dba-oracle.com/t_trending_forecasting_signature_analysis.htm

*****************************************
Can you see your Oracle bottlenecks?

After several years of hard work, Ion for Oracle is finally available for general release.  Ion is unlike any other Oracle tool on the market, a tool that encapsulates expert techniques to allow a DBA to quickly visualize important trends and signatures.

Predictive analytics if the key to repairing Oracle problems before they cripple your database, and I created Ion for Oracle to allow any DBA to quickly identify changing workloads and unobtrusive patterns of data access.  To try Ion for free, see here:

http://www.ion-dba.com

*****************************************

Need a health Check?

Oracle is the world's most complex and robust database and there are hundreds of sub-optimal setting that can cripple your database performance.

Burleson Consulting has a great Oracle health check where we identify all database bottlenecks to ensure that your mission-critical system is running at optimal speeds

Just call 800-766-1884 to schedule your health check.

*****************************************

Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call 800-766-1884 for details, and check-out our on-site Oracle training catalog at the following link:

http://www.dba-oracle.com/bc-catalog.pdf