Question

Locked

ORACLE 10G

By aarulnithi ·
WHAT IS THE DIFFERENCE BETWEEN ORACLE 10G FRONT END AND 9I FRONT-END

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Features introduced in the various server releases

Most DBA's and developers work with multiple versions of Oracle at any particular time. This document describes the high level features introduced with each new version of the Oracle database. It is intended to be used as a quick reference as to whether a feature can be implemented, or if a upgrade is required.

Oracle 10g Release 2 (10.2.0) - September 2005

* Transparent Data Encryption
* Async commits
* CONNECT ROLE can not only connect
* Passwords for DB Links are encrypted
* New asmcmd utility for managing ASM storage

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
* Data Pump - faster data movement with expdp and impdp.

Oracle 9i Release 2 (9.2.0)

* Locally Managed SYSTEM tablespaces
* Oracle Streams - new data sharing/replication feature (can potentially replace Oracle Advance Replication and Standby Databases)
* XML DB (Oracle is now a standards compliant XML database)
* Data segment compression (compress keys in tables - only when loading data)
* Cluster file system for Windows and Linux (raw devices are no longer required).
* Create logical standby databases with Data Guard
* Java JDK 1.3 used inside the database (JVM)
* Oracle Data Guard Enhancements (SQL Apply mode - logical copy of primary database, automatic failover
* Security Improvements - Default Install Accounts locked, VPD on synonyms, AES, Migrate Users to Directory

Please post back if you have any more problems or questions.
If this info is useful, please give a thumbs up. Thanks

Back to IT Employment Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums