Oracle Database 11g on Linux now available

For those keeping track, Oracle Database 11g Release 1 (11.1.0.6.0) - Standard Edition, Standard Edition One, and Enterprise Edition - became avialable for download from OTN. You can download it from this link - a 1.7GB single zip file. Also see Keith's previous post - 11g OLAP – Hot Pluggable Performance Booster… and Oracle Extends Its Lead in the DW Platform Tools M...

New Book : The Oracle 10gR2 Performance Tuning Tips and Techniques

At the moment I am working on a project to design a utility to help monitor performance during the execution of OLAP data loading and aggregation routines. Interestingly I received an email from Richard Niemiec at TUSC yesterday on a similar subject. As everyone knows Richard is one of the few Oracle Certified Masters and he has just published a new book on 10g performance tuning.

Amazon has just made the book available and reviews have already been posted on their site. You can checkout the book and reviews at:

http://www.amazon.com/Oracle-Database-Performance-Tuning-Techniques/dp/0072263059

The book explains how to monitor, analyze, and optimize Oracle Database 10g using the tested methods and insider advice contained in this definitive volume. The book is packed with detailed case studies, best practices, and code samples illustrating Oracle's new tuning features. Find out how to select optimal indexing options, effectively manage drives and disk arrays, troubleshoot queries, and reliably predict future performance. You'll also get detailed coverage of PL/SQL performance enhancements, initialization file tweaks, and the latest database surveying and reporting utilities.

I am going online tonight to order a copy as I know this will help with my OLAP tuning project. More on that in another post, hopefully coming soon.

Oracle Database 11g on Linux now available oracle

For those keeping track, Oracle Database 11g Release 1 (11.1.0.6.0) - Standard Edition, Standard Edition One, and Enterprise Edition - became avialable for download from OTN. You can download it from this link - a 1.7GB single zip file. Also see Keith's previous post - 11g OLAP – Hot Pluggable Performance Booster… and Oracle Extends Its Lead in the DW Platform Tools M...

OOW 2007 News oracle

Oracle OpenWorld 2007 (San Francisco, Nov 11-15) is just a couple of months away.

The Session Tracks | Oracle OpenWorld 2007 page lists four tracks:

• Applications
• Technology
• Industries
• Services

and you can view a listing of all the tracks and content at this page: Oracle OpenWorld - Content Catalog

Some sessions pertinent to BI:

• How-to: Oracle Business Intelligence Enterprise Edition and Self-Learning Predictive Analytics--Automate Real-Time Intelligent Decisions - Ed Suen, Oracle
• Overview: Next-Generation Enterprise Semantic Layer - Ed Suen, Oracle
• Oracle Business Intelligence Road Map and Strategy - Rich Clayton, Oracle; Paul Rodwick, Oracle
• Introduction to Oracle Business Intelligence Enterprise Edtion Plus - Mark Bauer, Oracle; Matt Elumba, Oracle
• Architecture: Oracle Business Intelligence Applications Advantages and Deep Dive - Rao Adivikolanu, Oracle; Esmond Chia, Oracle
• What's Coming in Oracle Business Intelligence Suite Enterprise Edition Plus Foundation - David Granholm, Oracle
  
• Cisco Systems: Implementing a Customer Intelligence Center with Oracle Business Intelligence Enterprise Edition - Maria Forney, Oracle; Ryan Uda, Cisco Systems; Dongyan Wang, Cisco Systems

For those interested in the Discoverer to BI EE migration, this is a session you must attend:
How-to: Migrating an Oracle Discoverer System to Oracle Business Intelligence Enterprise Edition - Mike Durran, Oracle

and two by yours truly:

• Enhanced Interactive Visualizations and Dynamic Data Exploration within Oracle BI Suite Enterprise Edition Dashboards
• Introduction to Oracle Business Intelligence Enterprise Edition Office Integration: The Information Consumer Approach

In case you are interested in the new OLAP capabilities in Oracle Database 11g, especially as they relate to materialized views (MVs), this is the session for you:
Enhanced Business Intelligence and Data Warehousing with Oracle OLAP 11g - William Endress, Oracle
Early bird registrations close on September 14 (Register now)

Michael informs us at his blog that he shall be presenting a paper - Paper accepted at Open World 2007 - Build an EUL in One Hour is the official name of the session.
Mark Rittman also has a paper on BI and SOA (Open World, BIWA, UKOUG and Oracle Mag) - Integrating Oracle Business Intelligence Enterprise Edition and SOA: Step by Step is the official name of the track.

I shall, hopefully, have more posts on the conference over the next couple of months.

EUL Horror Story - From Michael's Blog

An EUL horror story - from Michael's blog. Don't read that while drinking coffee or anything hot :-)

Hilarious.

Friday, August 24, 2007

New Book : The Oracle 10gR2 Performance Tuning Tips and Techniques

At the moment I am working on a project to design a utility to help monitor performance during the execution of OLAP data loading and aggregation routines. Interestingly I received an email from Richard Niemiec at TUSC yesterday on a similar subject. As everyone knows Richard is one of the few Oracle Certified Masters and he has just published a new book on 10g performance tuning.

Amazon has just made the book available and reviews have already been posted on their site. You can checkout the book and reviews at:

http://www.amazon.com/Oracle-Database-Performance-Tuning-Techniques/dp/0072263059

The book explains how to monitor, analyze, and optimize Oracle Database 10g using the tested methods and insider advice contained in this definitive volume. The book is packed with detailed case studies, best practices, and code samples illustrating Oracle's new tuning features. Find out how to select optimal indexing options, effectively manage drives and disk arrays, troubleshoot queries, and reliably predict future performance. You'll also get detailed coverage of PL/SQL performance enhancements, initialization file tweaks, and the latest database surveying and reporting utilities.