Scaling Oracle Application Express for large systems projects Oracle Tips by Burleson Consulting

Click here for a list of all Oracle User Group Session Topics and here for past Oracle Speaker Sessions.  Just phone below to schedule this session for your Oracle users group.

Oracle DBA predictive modeling

Those who cannot remember the past are condemned to repeat it, and this is especially true for those who use Oracle Discoverer and Oracle data mining for analyzing historical data and identifying significant correlations.  Oracle professionals are now applying the techniques of predictive modeling to Oracle performance data and using the gold mine of information in STATSPACK and AWR to develop Oracle tuning models.

This paper will examine the types of data stored inside STATSPACK and AWR and examine techniques for trend identification and predictive modeling.  Using these techniques Oracle professionals remove the guesswork from change to the Oracle instance and provide a framework for gathering evidence to justify database changes.

This is an indispensable presentation for any Oracle developer and DBA who assumes responsibility for making system-wide Oracle database changes.

Key points:

- See how AWR data can be used to develop database signatures

- Develop justifications for database maintenance activities

- See hidden trends within your database

- Aggregate average metrics by hour of the data and day of the week

Oracle Speaker Bio:

Don Burleson is considered one of the world’s top experts in Oracle.  He is very active in the Oracle community and has written 32 books, published more than 100 articles in National Magazines, a popular lecturer and teacher who is a frequent speaker at OracleWorld and other international database conferences.   As a corporate database consultant, Don has worked with numerous Fortune 500 corporations creating robust database architectures for mission-critical systems.  Don is also a noted expert on eCommerce systems, and has instrumental in the development of numerous Web-based systems that support thousands of concurrent users.

If you like Oracle tuning, you may enjoy my new book "Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.