LogMiner Enhancements In Oracle9i

The basic usage of Logminer is the same between Oracle8i and Oracle9i, so for basic usage notes see the LogMiner article in the Oracle8i section.

Memory Management In Oracle9i

Oracle9i introduces a number of new features aimed to make memory management simpler and more flexible:

• Dynamic SGA Parameters
• Automatic SQL Execution Memory Management
• Buffer Cache Advisory

Recovery Manager (RMAN 8i)

Recovery manager is a platform non-specific utility for coordinating you backup and restoration procedures across multiple servers. In my opinion it's value is limited if you only have on or two instances, but it comes into it's own where large numbers of instances on multiple platforms are used. The reporting features alone mean that you should never find yourself in a position where your data is in danger due to failed backups.