New Oracle9i RDBMS features
Extending Oracle’s leadership
•Automatic Memory Tuning
•ETL Infrastructure
–Change data capture
–External tables
–Table functions
–Upserts
–Multi-table INSERTs
–Resumable statements
–Transportable tablespace enhancements
•List Partitioning
•Internal enhancements for:
–parallel query
–aggregation
–cost-based optimization
•Bitmap Join Indexes
•Analytic SQL fns
–Grouping sets
–FIRST/LAST aggregates
–Inverse distribution
–Hypothetical rank
•Proactive query governing
•Enhancements to MVs
–Broader refresh and rewrite capabilities
–More sophisticated summary advisor
•Full Outer Joins
•WITH-clause