Krishna

• Mar 14th, 2006

 

10 G supports grid computing, ASM (Automatic storage management) and Memory management

raju

• Jan 23rd, 2007

 

in oracle 9i after drop we cannot rollback 

but in oracle 10g have 

sureshch83

 Profile Answers by sureshch83 

• Jan 28th, 2008

 

Oracle 10g is grid computing. What is that grid computing concept?. Why it is popular?
But next is oracle 11i. Why again they changed to i(internet).

dk_dl

 Profile Answers by dk_dl 

• Feb 21st, 2008

 

10 G supports grid computing, ASM (Automatic storage management) and Memory management.

Oralce 10g is higher version of 9i , Oracle 10g  has added a follwoing 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.

In Oracle 9i after drop we can't rollback but we can do it in 10g.
Moreover, 10g has additional 149 features than 9i. 

Ghilli

 Profile Answers by Ghilli 

• Mar 13th, 2008

 

wht is GRID computing?

aadisri

 Profile Answers by aadisri 

• Mar 30th, 2008

 

In 9i after dropping the  table we cant rollback. But in 10g v can roll back...
10g supoports grid computing but 9i cant support that...

coolcat

 Profile Answers by coolcat 

• Mar 6th, 2010

 

10g ueses CBO whereas 9i uses RBO

bpatel2003

 Profile Answers by bpatel2003 

• May 13th, 2010

 

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).

naren

• Aug 4th, 2011

 

Drop is autocommit command
We can't rollback it

naren

• Aug 4th, 2011

 

Drop is autocommit command we cant rollback it
in respones to the difference between the oracle 9i and 10g

Ashwin Hegde

• Aug 20th, 2011

 

i is for Internet
g is for Grid Computing

Azam

• Oct 24th, 2011

 

10 G supports grid computing, ASM (Automatic storage management) and Memory management.

Oralce 10g is higher version of 9i , Oracle 10g has added a follwoing 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.

In Oracle 9i after drop we can't rollback but we can do it in 10g.
Moreover, 10g has additional 149 features than 9i.