Previously Released Oracle Support Case Studies

Intense and Random Buffer Busy Wait Performance
Performance / Beginner / December, 2005

Configuring the Kerberos Adapter in a Windows Environment
Networking / Beginner / July, 2006

The Case of the Stubborn Cost Based Optimizer
Performance / Intermediate / December, 2005

Diagnosing Another Buffer Busy Waits Issue
Performance / Intermediate / March, 2006

Using Real-Time Diagnostic Tools to Diagnose Intermittent Database Hangs
Performance / Intermediate / July, 2006

Resolving High CPU Usage on Oracle Servers
Performance / Intermediate / May, 2006

Analyzing 10053 Trace Files
Performance / Expert / December, 2005

The Mysterious Performance Drop
Performance / Expert / May, 2006

Judicious Use of Histograms for Oracle Applications Tuning
Tuning and Performance / Expert / March, 2006

Slow Client Connection in a RAC/Sun Cluster
Real Application Clusters / Expert / December, 2005

Diagnosing Unsuccessful CRS root.sh Issues
Real Application Clusters / Expert / March, 2006

Setting up External Stream Generation in Lease Management
Lease Management / Expert / March, 2006

OCFS Drives Disappearing and/or Becoming Inaccessible
Clustered File System / Expert / December, 2005

Refences Used : Metalink Case Study Index

Announcement of a new product; ubSQL from ubTools

ubSQL is a utility which unloads Oracle data to text format; runs DML/DDL statements. So why ubSQL ?

• It is a fast, C-based utility.
• Multi-threaded utility; N threads fetch data, N threads process fetched data, N threads write processed data to disks.
• Uses Oracle Call Interface(OCI), which is the lowest documented layer to access Oracle.
• Uses Operating System Kernel Calls directly in many unload operations without needing a library overhead.
• Multiple sessions can unload different parts of a table at the same time.
• Oracle data can be unloaded to multiple output files.
• Array Fetching is used in unload operations.
• Creating SQL*Loader control file is possible.
• Regular and Named Pipes are supported as Output File Types.
• Reading Oracle data directly from disks without using Oracle SGA is currently under development.
• Supported Oracle Versions Oracle 9i and onwards are supported.

ubSQL Presentation

ps: itrprof SQL Analyzer