Oracle9i: New Features For Administrators Exam Tips - Some tips on what to expect when upgrading your OCP to Oracle9i.

ANSI ISO SQL Support In Oracle9i - Check out the new SQL enhancements to bring Oracle in line with the ANSI/ISO SQL: 1999 standards.

Automatic Segment Free Space Management - Reduce segment header contention and wasted space within blocks by switching from using FreeLists to Automatic Segment Free Space Management.

Automatic Undo Management - Replace you existing rollback segments with self-tuning undo segments.

Bitmap Join Indexes - Increase the performance and reduce the size of your data warehouse.

Data Guard - Oracle9i Data Guard is the new name for Oracle8i Standby Database incorporating a large number of new features. This article discusses those relevant to the Oracle9i Database: New Features For Administrators OCP exam.

Export And Import Enhancements In Oracle9i - See what new functionality has been incorporated into the Export and Import utilities in Oracle9i.

Flashback Query - Get a consistent view of the your data at a previous point in time.

High Availability Enhancements in Oracle9i - Reduce downtime for users by using the new high availability features of Oracle9i.

Index Organized Table (IOT) Enhancements in Oracle9i - Better support for secondary indexes and improved online maintenance make IOTs nearly as flexible as heap tables.

Index Skip Scanning - See how Oracle9i uses composite indexes even when the leading edge is not referenced.

LOB Enhancements In Oracle9i - Kickstart the conversion from LONG and RAW columns to CLOB and BLOB columns.

Logminer Enhancements In Oracle9i - A summary of the new features introduced in Oracle9i.

Memory Management In Oracle9i - See how easy memory management has become in Oracle9i.

Metadata API - Extract DDL or XML definitions of all database objects using this simple API.

Multiple Block Sizes - Improve efficiency by having multiple block sizes that relate more closely to the operations that are being performed.

Oracle Managed Files - Let Oracle manage operating system level file placement, naming and cleanup.

Partitioning Enhancements In Oracle9i - Check out the additions and enhancements to partitioning in Oracle9i.

Performance Enhancements In Oracle9i - Read about some of the new performance features in Oracle9i.

Persistent Initialization Parameters - Make database parameter changes persist between shutdowns.

Real Application Clusters - A brief introduction to the Oracle9i replacement for Oracle Parallel Server.

Recovery Enhancements In Oracle9i - Reduce unplanned downtime by using the new crash, instance and media recovery features of Oracle9i.

Recovery Manager (RMAN) Enhancements In Oracle9i - Use the latest RMAN features which make backup and recovery quicker and more reliable.

Resource Manager Enhancements In Oracle9i - Manage system resources more precisely using the Resource Manager enhancements in Oracle9i.

Resumable Space Allocation - Make long running operations suspend rather than abort if they encounter space errors.

Scalable Session Management - Learn about the new session management features in Oracle9i.

Security Enhancements In Oracle9i - A run through the new security features available in Oracle9i, focusing on those relevant for the Oracle9i Database: New Features For Administrators OCP exam.

SQL New Features In Oracle9i - Check out the new SQL features with emphasis on those relevant for the Oracle9i Database: New Features For Administrators OCP exam.

Workspace Management In Oracle9i - Allow multiple transactionally consistent environments to exist within one database.

BACK TO ARTICLES MAIN PAGE