Oracle8i:New Features for Administrators
Installation and Configuration
· Using Oracle Universal Installer and Packager
· Installing a pre-tuned database
· Creating a database using database configuration assistant
Tablespace Management
· Making tablespace read-only ONLINE
· Transporting tablespaces
· Creating locally managed tablespaces
Oracle Enterprise Manager
· Using Java-based console and applications
· Sharing repository amongst administrators
· Printing
· Using Data Browser
Constraints
· Using Non-Unique Indexes for primary key and unique constraints
· Controlling constraint validation
ROWIDs
· Differentiating between extended and restricted ROWIDs
· Describing logical ROWIDs
Other Manageability Enhancements
· Dropping Columns
· Creating temporary tables
· Using SQL*Loader new features
Parallel Query Enhancements
· Specifying automatic PQ optimization
· Monitoring PQ operations using new dynamic performance views
Database Resource Manager
· Configuring database resource
· Controlling resource usage by user groups
Recovery Manager
· Introduction to Recovery Manager
· Using Catalog Commands and Reports
· Using RUN Commands and Scripts
· Duplexing Backup Sets
Standby Databases
· Automating standby databases
· Opening database for read-only access
Other Availability and Recoverability Enhancements
· Specifying multiple archivers and destinations
· Using LogMiner
· Specifying bounded recovery time
· Detecting data corruption using DBMS_REPAIR package
Password Management
· Concepts
· Managing passwords using profiles
· Password Complexity Checking
Other Security Enhancements
· Specifying invoker's rights execution
· Using application context
· Implementing N-tier authentication
· Defining fine-grained access control
· Implementing global roles
Memory Management
· Using large pool
· Using segmented cache
(multiple buffer pools)
Optimizer and Query Improvements
· Controlling plan stability (Stored Outlines)
· Collecting and moving statistics DBMS_STATS package
· Optimizing “Top-N” queries
· Monitoring long running operations
Materialized Views
· Creating summaries and join indexes
· Controlling refresh of materialized views
· Controlling query rewrite
· Managing materialized views using advisory functions
· Managing dependencies and materialized view invalidation
· Controlling rewrites requiring hierarchies
Index Enhancements
· Combining index creation and statistics generation
· Implementing function-based indexes
· Implementing descending indexes
· Bitmap index improvements
· Using reverse key indexes
· (Re)building indexes ONLINE
Index-organized Tables (IOTs)
· Concepts
· Implementing IOTs
· Creating secondary indexes
Advanced Queuing (AQ)
· Messages and Queue Tables
· Implementing AQ (Packages)
· Subscribing to queues
Managing Large Objects (LOBs)
· Differentiating between different types of LOBs
· Creating directories
· Migrating LONGs to LOBs
SQL, PL/SQL and NLS Enhancements
· Oracle8 data types
· NLS Enhancements (including Union currency)
· Using PL/SQL Enhancements
· Using database events (Triggers)
Object Relational Databases
· Defining object types
· Creating object tables
· Analyzing dangling references
· Using REF column referential integrity
· Defining object methods
· Implementing collections (VARRAYs, Nested Tables)
· Migrating relational schema using object views
· Using INSTEAD OF triggers
Partitioning: Basic Concepts
· Partitioning tables
· Partitioning indexes
Partitioning Techniques
· Range partitioning tables and indexes
· Hash partitioning tables and indexes
· Using composite partitioning
· Partitioning operations
Parallel DML and Queries
· Configuring for partition-wise joins
· Using parallel query on object tables
Partitioned IOTs, LOBs and Objects
· Partitioning index-organized tables
· Partitioning tables with LOBs
· Partitioning objects
Net8
· Using Connection Manager
· Multiplexing
· Connection pooling
· Load balancing
· Automatic Instance Registration
· Using Net8 Assistant (from OEM)
· Using RADIUS adapter
Enhancements to Distributed Databases
· Queue propagation
· Using Primary Key snapshots
· Deferred Constraints and Updateable Snapshots
· LOB Support
· Monitoring replication events using new V$-views
· Implementing snapshot security
· Instantiating snapshot sites OFFLINE
· Using snapshot deployment templates
Migrating Server and Applications
· Migrating from 7.3 to 8i
· Upgrading from 8.0 to 8i
Enhancements to Oracle Parallel Server
· Using OPS wizard
· Using global fixed views
· using cluster group services
· Setting up integrated DLM
· Dynamic load balancing
· Consistent read server
· Controlling job execution
· RMAN Disk Affinity
· Using application failover
Java in the Database
· Different methods of using Java to access the database
· Java VM architecture
· Loading and publishing Java classes