Oracle 9i Database Administration in 10 Minutes
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Chapter 10: Oracle Performance Tuning
Oracle Performance Tuning, the topic is not that
scary as it sounds. Actually it’s very simple if you understand the
performance tuning concept –the bigger picture or in other words bird’s
eye view.
Performance tuning is nothing but the collection of statistics regarding
the current status of the system and then change system values based on
the statistics to enhance the performance. In other words performance
tuning is
• Collection of system statistics
• Changing system based on the statistics
Now we have to look into what are different sources that can provide us
the information regarding the current health of the system. Although
there are a lot of sources. The simple sources, which can provide us the
Oracle system information, are alert log file, trace files, dynamic
performance view, data dictionary views etc. Let’s start learning about
each of these sources one by one.
Chapter 10: Oracle Performance Tuning
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning