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 23

	Oracle tutorial library: SearchOracle.com's learning guides SearchOracle.com | 12 Nov 2009 ARTICLE - We've gathered all our learning guides here in one invaluable list that you can return to again and again whenever you need a helping hand.

	Oracle releases new database, says 11g upgrade will cut costs SearchOracle.com | 01 Sep 2009 ARTICLE - Oracle released its new 11g R2 database today. But will users embark on an Oracle 11g upgrade? And why should they?

	Oracle raises prices on database management packs SearchOracle.com | 17 Jul 2009 ARTICLE - With little fanfare, Oracle earlier this month increased pricing on a handful of optional database management offerings.

	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.

	Oracle database performance tuning guide 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

DOWNLOADS: 1 - 1 of 1

	What managers should consider when starting a database scaling project Published by: SerachOracle.com | 11 Nov 2009 PODCAST - Learn about database scaling from Oracle consultant Don Burleson, who discusses the goals, costs and challenges of scaling an Oracle database in this podcast.

	VIEW ALL DOWNLOADS ON ORACLE DATABASE PERFORMANCE PROBLEMS AND TUNING

SEE ALSO - Topics Related to Oracle database performance problems and tuning:  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, Oracle DBA tools