Re: Difference between Oracle 9i and 10g Here are some additional features available in 10g Network Management
• Back Up Directory Naming Entries to Local Naming File.
• Dynamic Connection Manager Configuration.
• Easy Connect Naming Method.
• Improved Network Outage Detection.
• Automatic LDAP Discovery for Clients.
• Improved Connection Manager Access Rules.
• Automatic Shared Server Configuration.
• Simplified Shared Server Configuration Parameters. Manageability Infrastructure
• Database Features Usage Tracking.
• Enhanced Database Time Model.
• End-to-End Application Tracing.
• JDBC: End-to-End Tracing.
• SYSAUX Tablespace.
• Automatic Routine Administration Tasks.
• Server-Generated Alerts.
• Automatic Workload Respository.
• Enhanced Wait Model.
• Threshold-Based Alerts. Storage Management
• Multiple Default Temporary Tablespace Support for SQL Operations.
• Automatic Storage Management.
• Rename Tablespace. Backup and Recovery Manageability
• Enhanced RMAN Reporting.
• Backup Compression.
• Bounded Backup Window.
• RMAN Scripts Manageability.
• Recovery Area Full Alert. Performance and Scalability
• Index-Organized Table (IOT) Partitioning Enhancements.
• Eliminate Duplicated Columns in Index on an Index-Organized Table.
• Configurable TCP/IP Send and Receive Buffer Size.
• Single-Set Aggregates in DML Returning Clause.
• High-Speed Infiniband Network Support.
• Sorted Hash Clusters.
• Windows Fiber Support.
• Optimized 64-bit Database.
• SQL Tuning Advisor.
• SQLAccess Advisor.
• Materialized View Tuning API.
• Automatic Optimizer Statistics Collection. Backup and Recovery
• Flash Backup and Recovery.
• Drop Database.
• RMAN Database Deregistration.
• Backup and Restore of Standby Control File.
• Automatic TSPITR.
• Simplified Recovery Manager Cataloging of Backup Files.
• Automatic Channel Failover for Backup and Restore.
• Automatic File Creation During Recovery.
• Simplified Backups to Disk.
• Proxy Copy Backup of Archivelogs.
• Incrementally Updated Backups.
• Simplified Recovery Through Resetlogs.
• Restore Tolerates Corrupt or Missing Backups.
• Full Database Begin Backup Command.
• Change-Aware Incremental Backups. Improved Administration
• DML Support in FGA.
• Communication over SASL.
• Unified User Model.
• Easy Database Registration.
• Extended and Uniform Audit Trail.
• Oracle Label Security Directory Integration. Data Mining Support for Analytic Applications
• Frequent Itemsets.
• DBMS_DATA_MINING PL/SQL Interface for Oracle Data Mining.
• Features Extraction using Non-Negative Matrix Factorization Algorithm.
• Enhanced Data Preprocessing.
• Enhanced Adaptive Bayes Network.
• Multi-User Access Control.
• Oracle Data Mining Client (DM4J).
• Support Vector Machines (SVM). And still many more...... |