Oralce 10g is higher version of oracle 9i, oracle 10g has added a following features
•Transparent Data Encryption
•Async commits
•CONNECT ROLE can not only connect
•Passwords for DB Links are encrypted
•New asmcmd utility for managing ASM storage
•Grid computing - an extension of the clustering feature (Real Application Clusters)
•Manageability improvements (self-tuning features)
•Performance and scalability improvements
•Automated Storage Management (ASM)
•Automatic Workload Repository (AWR)
•Automatic Database Diagnostic Monitor (ADDM)
•Flashback operations available on row, transaction, table or database level
•Ability to UNDROP a table from a recycle bin
•Ability to rename tablespaces
•Ability to transport tablespaces across machine types (E.g Windows to Unix)
•New 'drop database' statement
•New database scheduler - DBMS_SCHEDULER
•DBMS_FILE_TRANSFER Package
•Support for bigfile tablespaces that is up to 8 Exabytes in size
•Data Pump - faster data movement with expdp and impdp.
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).
