Thread: Difference between Oracle 9i and 10g
View Single Post
  #16 (permalink)  
Old 08-25-2007, 02:47 AM
Gopisoft Gopisoft is offline
D-Web Sr.Programmer
  
Join Date: Feb 2007
Posts: 117
Gopisoft is on a distinguished road
Default Re: Difference between Oracle 9i and 10g
Oracle 10g Release 1 (10.1.0)

  • 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

Oracle 10g Release 2 (10.2.0)
  • Transparent Data Encryption
  • Async commits
  • CONNECT ROLE can not only connect
  • Passwords for DB Links are encrypted
  • New asmcmd utility for managing ASM storage
  • Data Pump - faster data movement with expdp and impdp.
Reply With Quote