Search For Any I.T Related Information
Thursday, April 28, 2011
Difference Between Oracle 9i and Oracle 10g
Posted on 11:37 PM by Unknown
Oracle 9i vs Oracle 10g
In 1977 Software Development Laboratories (SDL) developed the Oracle Database software which is simply known as Oracle. It is an Object-Relational Database Management System (ORDMBS) which is identified by an alpha numeric system identifier (SID).
The Oracle Database software includes a set of operating system processes such as PMON or process monitor and SMON or system monitor together and memory with data storage. In 2001, Oracle 9i was released, the “i” standing for the word “Internet” meaning that it is Internet ready.
Oracle 9i has the following new features:
- Direct XML database support.
- Java JDK 1.3.
- Oracle Data Guard and enhancements.
- New data sharing and replication features.
- Compresses keys in tables when loading data.
- Security Improvements.
- Manage system table spaces locally.
- Automated DBA.
Oracle 10g, on the other hand, was released in 2003 to support regular expressions with the letter “g” standing for “grid” to emphasize Oracle 10g as grid computing ready.
Here are some of Oracle 10g features:-
- New drop database and alter database begin backup syntax.These two versions have many differences including the following:
- Oracle 10g Data Guard Broker and RAC to support Redo Log Transport.
- SQL apply feature and regular expression support.
- Supports HTML database.
- Recycle bin for storing objects and new purge command.
- SYSAUX table space and rename table space command.
- Automated Storage Management (ASM).
- Automatic Workload Repository (AWR).
- Automatic Database Diagnostic Monitor (ADDM).
- Manageability. Oracle 10g is proven to be more manageable than oracle 9i.
- New ADDM and SQL Tuning Advisor of Oracle 10g is a very remarkable improvement against that of Oracle 9i.
- Oracle 10g lessens DBA workload and hastens performance of management tasks.
- Oracle 10g executable is bigger.
- Oracle 9i does not allow rollback after a drop while it is allowed in Oracle 10g.
- Oracle 10g has more features and offers more efficient replication support than Oracle 9i.
- Oracle 10g has higher system requirements than Oracle 9i.
- Both versions have excellent features. The main difference between the two is that Oracle 10g is a higher version than Oracle 9i and has many added features that enhance the features of Oracle 9i while some old features may have been abandoned.
Summary:-
1.Oracle 9i is an Object-Relational Database Management System (ORDMBS) which was released in 2001 while Oracle 10g is also an Object-Relational Database Management System (ORDMBS) which was released in 2003.
2.The “i” in the Oracle 9i stands for “Internet ready” while the “g” in the Oracle 10g stands for “grid computing ready.”
3.Oracle 10g is actually an upgraded or a higher version of Oracle 9i.
4.Oracle 10g is more manageable while Oracle 9i is not.
5.Oracle 10g offers more features while Oracle 9i offers less.
6.Oracle 10g has higher system requirements while Oracle 9i has lower system requirements.
7.Oracle 10g also offers flashback, backup, recovery, and several other enhancements while Oracle 9i does not.
Feel Free to share this blog post with your friends using the share buttons below this post and the share button at the top right corner of this page.
If you have anything to contribute or ask, kindly make use of the comment Form below.
Please, do not forget to SUBSCRIBE to this blog, so that you can be Receiving future Information Technology News, money making tricks, browsing Cheat, latest I.T Jobs, latest I.T career article, Hardware Tips, Software/Programming Tips, Mobile/Telecommunication news, Updates on IT Certifications DIRECTLY into your email inbox, even when you are not online.
You can Subscribe by making use of the Subscription box at the top right corner of this website or the one at the below of this blog post.
We also offer:-
•Repairing of both Laptop and Desktop Computer
•Setting up of Cybercafé
•Networking of office System
•Sales and Installation of Software’s
•Sales of Hardware Component for both Laptop and Desktop Computer
•Sales of both Laptop and Desktop Computer @ a very cheap price(New and Tokunbo)
•Designing of Website for client
•Application Developing
•Internet Connection for just N1500 per month
Sales of ebook:-
•How to Start a Recharge Card Printing Business with a little Capital and Make Huge Profit
•How to be a Bulk Sms Consultant and make over 90,000 Monthly
•Football Trading (How to make money from Football matches played aroung the Globe)
•Forex Trading Manual
•How to Make over N50,000 selling TYRE PROTECTOR
•How to Make over N76,500 selling FIRE BALL EXTINGUISHER an Alternative to Fire Extinguisher.
NOTE: If the LINKS are NOT clickable, it simple means you are not reading this at www.olamoshsystem.com. So, visit HTTP://WWW.OLAMOSHSYSTEM.COM now to read the original article.
Phone number: 08026652529, 07034628261E-mail Address:olamosh.system009@gmail.comJoin me on facebook:www.facebook.com/olamoshsystemWebsite address:- www.olamoshsystem.com or www.latestdreamjob.blogspot.com
If you have anything to contribute or ask, kindly make use of the comment Form below.
Please, do not forget to SUBSCRIBE to this blog, so that you can be Receiving future Information Technology News, money making tricks, browsing Cheat, latest I.T Jobs, latest I.T career article, Hardware Tips, Software/Programming Tips, Mobile/Telecommunication news, Updates on IT Certifications DIRECTLY into your email inbox, even when you are not online.
You can Subscribe by making use of the Subscription box at the top right corner of this website or the one at the below of this blog post.
We also offer:-
•Repairing of both Laptop and Desktop Computer
•Setting up of Cybercafé
•Networking of office System
•Sales and Installation of Software’s
•Sales of Hardware Component for both Laptop and Desktop Computer
•Sales of both Laptop and Desktop Computer @ a very cheap price(New and Tokunbo)
•Designing of Website for client
•Application Developing
•Internet Connection for just N1500 per month
Sales of ebook:-
•How to Start a Recharge Card Printing Business with a little Capital and Make Huge Profit
•How to be a Bulk Sms Consultant and make over 90,000 Monthly
•Football Trading (How to make money from Football matches played aroung the Globe)
•Forex Trading Manual
•How to Make over N50,000 selling TYRE PROTECTOR
•How to Make over N76,500 selling FIRE BALL EXTINGUISHER an Alternative to Fire Extinguisher.
NOTE: If the LINKS are NOT clickable, it simple means you are not reading this at www.olamoshsystem.com. So, visit HTTP://WWW.OLAMOSHSYSTEM.COM now to read the original article.
Phone number: 08026652529, 07034628261E-mail Address:olamosh.system009@gmail.comJoin me on facebook:www.facebook.com/olamoshsystemWebsite address:- www.olamoshsystem.com or www.latestdreamjob.blogspot.com
Subscribe to:
Post Comments (Atom)
No Response to "Difference Between Oracle 9i and Oracle 10g"
Leave A Reply