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 21

	Oracle New Year's resolutions, part 1: Advice for navigating 2009 SearchOracle.com | 30 Dec 2008 ARTICLE - Oracle analysts weigh in with advice for improving Oracle database security and upgrading to new Oracle applications in 2009.

	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.

	VIEW ALL NEWS ON ORACLE DATABASE PERFORMANCE PROBLEMS AND TUNING

EXPERT TECHNICAL ADVICE: 1 - 3 of 347

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 6

	Solving common Oracle errors guide SearchOracle.com | 15 Apr 2008 LEARNING GUIDE - 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.

	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.

	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

SEE ALSO - Topics Related to Oracle database performance problems and tuning:  Oracle DBA tools, Oracle database availability, Oracle database backup and recovery, Oracle database design and architecture, Oracle database installation, upgrades and patches, Oracle database export, import and migration, Oracle RAC and database clustering, Oracle error messages, Oracle grid computing, Oracle database security