Features Oracle Database11g: How NOT to RAC Your Brain By Matthew Zito Zito takes a good look at Oracle Database 11g and how automation can help the DBA. The New Generation of MetaLink By April Sims MetaLink, the customer support portal, is evolving to provide an improved customerexperience for all Oracle Premier Support customers. In…

Features Implementing Oracle Grid: A Successful Customer Case Study By Kai Yu, Dan Brint and Aaron Burns The authors cover a successful case study of implementing an Oracle Grid in three layers:applications, databases and storages. The authors also examine the related performance metrics obtained in benchmarks for a Proof of Concept environment. Creating Enterprise Rich…

This insightful article looks at the various aspects of determining and resolving performanceissues in a Web-based application.

Burleson describes the approach taken to broad brush SQL tuning in Oracle Database 11g,and describes how we got here by providing a brief history of performance-related additionsin each new Oracle version.

This article explores instrumenting applications to run on Oracle databases and makes afirst pass at defining an instrumentation framework. It also passes along some guidelinesthe author has learned while instrumenting Oracle-based applications.

In his article, Kerber explores the current status of Solid State Disk technologies with respectto Oracle databases and looks at ways of incorporating SSD into Oracle-based environments.

Using examples, Morton examines whether the SQL Tuning Advisor is helpful or not. She citesexamples and walks the reader through the various functions of the tool.

SELECT’s Associate Editor, Dr. Paul Dorsey askedDr. Stephen Peterson, lecturer in Public Policy atHarvard University’s Kennedy School of Governmentand founder of the Executive Program in Public FinancialManagement (under the Harvard Institute for InternationalDevelopment) about the challenges of assisting developingcountries with their IT infrastructures.

Zeng presents a robust method of using a transportable tablespace feature to perform database upgrade. This method is valid for all versions of Oracle database from 8i to 10.2.

Fernandez discusses the shortfalls in the Query optimization, the theory behind it, and possible solutions and takeaways.