Oracle Database / Applications Topics:

Oracle database performance problems and tuning

Browse through our tips and advice on Oracle performance tuning to keep your databases, applications and SQL queries running quickly and efficiently.

Spotlight on Oracle performance tuning Article - Performance tuning -- keeping your database and SQL queries running quickly and smoothly -- is one of the most important and demanding tasks for an Oracle DBA. This special report compiles analysis, tips and expert advice to help you meet your tuning...
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 - @9844 Performance tuning expert Gaja Krishna Vaidyanatha wants to help DBAs who suffer from what he calls "Compulsive Tuning Disorder" (CTD). Vaidyanatha, owner of consulting firm DBPerfMan.com and an author of several Oracle books, including "Oracle...
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.

1 - 3 of 22

Oracle releases new database, says 11g upgrade will cut costs 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 17 Jul 2009
Article - With little fanfare, Oracle earlier this month increased pricing on a handful of optional database management offerings.
Oracle New Year's resolutions, part 1: Advice for navigating 2009 30 Dec 2008
Article - Oracle analysts weigh in with advice for improving Oracle database security and upgrading to new Oracle applications in 2009.

1 - 3 of 291

Oracle 11g data compression
Tip - Here is an overview of new 11g compression features, which make storage up to three times cheaper, solid-state flash drives far less expensive allowing Oracle shops to forever eliminate the high costs of platter-disk I/O and enjoy data access speeds up...
Varchar or number for better performance?
Ask the Expert - Which one is better for performance as a unique index, varchar or number?
Do statistics on SYS-owned objects hurt performance in 10g?
Ask the Expert - You mentioned that in Oracle 9i statistics on SYS-owned objects can actually hurt the performance. Is it the same in 10g?

1 - 3 of 4

Oracle database performance tuning guide
Learning Guide - Learn the tricks of industry experts for identifying and eliminating perfomance problems in this guide. Topics include tuning fundamentals and fallacies, explanations of performance tuning tools, disk I/O and SQL tuning specifics, and common problem...
Inside Oracle10g dynamic sampling
Chapter Download - Oracle9i introduced the new dynamic sampling method for gathering run-time schema statistics, and it is now enabled by default in Oracle10g. But you may want to turn it off to remove unnecessary overhead in some circumstances. This excerpt, taken from...
Oracle 10g datafile I/O statistics
Chapter Download - The Oracle10g database significantly improves the I/O subsystem, but it is still important to constantly monitor the I/O workload on the database. This excerpt, taken from the book "Oracle Tuning Power Scripts: With 100+ High Performance SQL Scripts" by...

1 - 1 of 1

What managers should consider when starting a database scaling project
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.

See also -Topics Related to Oracle performance problems and tuning:

Oracle Development Solutions - SQL, J2EE, XML, SOA