Oracle database performance problems and tuning

MUST READ Spotlight on Oracle performance tuning ARTICLE - Performance tuning is a key task for any Oracle DBA. This spotlight includes tips and advice to help you meet your tuning challenges and keep users happy. Oracle tuning fallacies TIP - Some common fallacies about Oracle tuning, including the importance of reducing logical I/O, the meaninglessness of hourly tuning averages, and more. Oracle disk I/O tuning: Disk performance statistics TIP - This is the third tip in a series on the different aspects of disk I/O performance and optimization for Oracle databases. Recovering from "Compulsive Tuning Disorder" INTERVIEW - Performance tuning expert Gaja Krishna Vaidyanatha has a prescription for DBAs suffering from "Compulsive Tuning Disorder." Oracle tuning: Blocksize and index tree structures TIP - There has been a great debate about the structures of Oracle index trees and whether they are important to Oracle tuning. Guru Don Burleson gives his opinion on the matter.

NEWS: 1 - 3 of 20

	Author Mike Ault sizes up the new Oracle Database 11g SearchOracle.com | 04 May 2007 ARTICLE - Oracle book author Mike Ault talks about the upcoming Oracle Database 11g's new SQL replay and memory management capabilities.

	Lessons Learned: Oracle performance tuning 101 SearchOracle.com | 06 Apr 2007 ARTICLE - Part of the SearchOracle.com Lessons Learned series, this week's lesson covers Oracle performance tuning basics.

	Podcast: Oracle Database 11g preview -- New automated features promise to make DBA life easier SearchOracle.com | 20 Mar 2007 ARTICLE - Oracle Database 11g will offer new automated management features that should allow DBAs to concentrate on more strategic issues. We talked to an Oracle honcho to find out more.

	VIEW ALL NEWS ON ORACLE DATABASE PERFORMANCE PROBLEMS AND TUNING

EXPERT TECHNICAL ADVICE: 1 - 3 of 335

ORACLE DATABASE PERFORMANCE PROBLEMS AND TUNING EXPERTS
			Paul Baumgartel Senior Database Administrator and Consultant ASK A QUESTION

	Oracle 11g data compression 18 Oct 2007 TIP - Here is an overview of 11g compression features, which make storage up to 3x cheaper, eliminate the high costs of platter-disk I/O, and enjoy data access speeds up to 300x faster.

	Varchar or number for better performance? 27 Aug 2007 EXPERT ANSWER - Which one is better for performance as a unique index, varchar or number?

	Do statistics on SYS-owned objects hurt performance in 10g? 09 Aug 2007 EXPERT ANSWER - You mentioned that in Oracle 9i statistics on SYS-owned objects can actually hurt the performance. Is it the same in 10g?

	VIEW ALL EXPERT TECHNICAL ADVICE ON ORACLE DATABASE PERFORMANCE PROBLEMS AND TUNING

REFERENCE & LEARNING: 1 - 3 of 3

	Database storage management 12 Feb 2007 ALL-IN-ONE GUIDES - This guide will help you master backup and recovery, from the basics of forming a storage management plan to step-by-step instructions for using RMAN and other backup methods.

	Learning Guide: Performance tuning SearchOracle.com | 03 Nov 2004 LEARNING GUIDE - Learn the tricks of industry experts for identifying and eliminating perfomance problems in this guide.

	SQL Tuning with SQL Access Advisor Rampant TechPress | 13 Jun 2005 CHAPTER DOWNLOAD - This excerpt, taken from "Easy Oracle Automation: Oracle10g Automatic Storage, Memory and Diagnostic Features" by Dr. Arun Kumar R, describes the process of using SQL Access Advisor for tuning SQL.

	VIEW ALL REFERENCE & LEARNING ON ORACLE DATABASE PERFORMANCE PROBLEMS AND TUNING

WEBCASTS: 1 - 3 of 3

	Tuning where it counts: Optimizing Oracle E-Business Suite performance - Vendor Webcast VIEW WEBCAST PREMIERED:   02 SEP 2004, 14:00 EDT (18:00, GMT) SUMMARY:   Save time and money by properly tuning your Oracle E-Business environment. Gain expert advice on how to detect, diagnose and resolve top areas of contention throughout the application.

Oracle SQL tuning secrets - Expert Webcast VIEW WEBCAST PREMIERED:   17 JUN 2004, 09:00 EDT (13:00, GMT) SUMMARY:   In this webcast, Don Burleson will teach attendees how to focus on real-world techniques for improving the speed of SQL queries in Oracle9i, including how to use advanced techniques such as materialized views and how to show actual performance difference. Attendees will also get a peek at Oracle10g SQL enhancements.

	Oracle9iAS tuning techniques - Expert Webcast VIEW WEBCAST PREMIERED:   16 MAR 2004, 09:00 EST (14:00, GMT) SUMMARY:   This webcast with coauthor of the "Oracle9iAS Administration Handbook" focuses on the techniques Oracle professionals use to detect and correct performance bottlenecks in Oracle9iAS.

	VIEW ALL WEBCASTS ON ORACLE DATABASE PERFORMANCE PROBLEMS AND TUNING

BEST WEB LINKS: 1 - 3 of 10

	Fast Guide: Solving common Oracle errors SearchOracle.com | 24 Oct 2006 BEST WEB LINK - Solve your Oracle errors quickly and easily with help from this fast guide. It covers every expert response pertaining to Oracle errors on SearchOracle.com.

	300 free Oracle scripts SearchOracle.com | 11 Jul 2003 BEST WEB LINK - No matter what your Oracle admin dilemma, here you're sure to find a script to help solve it. Dig through SearchOracle.com's collection of nearly 300 Oracle scripts and tips. (July 11, 2003)

	Oracle expert tuning secrets SearchOracle.com | 29 Jun 2003 BEST WEB LINK - A true Oracle guru, Don Burleson, shares tuning secrets from 20+ years of experience in a discussion of the most common causes of poor Oracle performance and the "silver bullets" for Oracle tuning.

	VIEW ALL BEST WEB LINKS ON ORACLE DATABASE PERFORMANCE PROBLEMS AND TUNING

SEE ALSO - Topics Related to Oracle database performance problems and tuning:  Oracle on Linux, Oracle database availability, Oracle database backup and recovery, Oracle database design, Oracle database installation, upgrades and patches, Oracle database export, import and migration, Oracle Real Application Clusters (RAC), Oracle database security, Oracle data warehousing, Oracle error messages, Oracle ETL (extract, transform and load), Oracle grid computing