Tips, Notes and Information from InSync 2011

How do you access data efficiently if there’s no perfect index? Jonathan provides insight on how to creatively combine indexes in ways that the optimizer cannot yet manage and, by doing so, minimize the number of table blocks there are to access.

Ahmed delves into how upgrading from Oracle SOA Suite 10g to 11g can be costly due to the dramatic change in the underlying architecture. This article takes you through a tried-and tested upgrade strategy to help you avoid the pitfalls early adopters have faced.

Marc tells the story of a real-world Exadata Database Machine deployment integrating OBIEE analytics and third-party ETL tools in a geographically distributed, high-availability architecture.

Jim explains how new capabilities in 11gR2 are likely to significantly improve the performance and throughput of database applications that can be leveraged for improved database application performance even without implementing an Exadata solution.

Abhinav discusses how unsuccessful or delayed BI implementations are most often attributed to an improperly modeled repository not adhering to basic dimensional modeling principles.

New DBMS_SQLTUNE Active Reports and an Undocumented Parameter

In his article, Havewala exposes a number of advanced tips regarding setting up and working with Enterprise Manager Grid Control, based on his own practical experience. His tips range from the recommended architecture for Grid Control, to setting up RMAN backupsand creating and managing Oracle Data Guard standbys using Grid Control.

Yu’s article examines the infrastructure of the Oracle Enterprise Manager Provisioning Pack,and how to automate some time-consuming and error-prone tasks such as provisioning and Oracle 11g RAC database, and extending a RAC database to additional nodes.

Learn how to use Oracle SQL Developer PL/SQL Unit Test capabilities to define and create PL/SQL unit tests. Harper will also show readers how to add reusable test components to a unit test library and how to define and handle test exceptions.