Oracle database 9i interview questions persistent storage. In 2001 oracle9i appeared with 400 new features, including the ability to read and write xml documents. In oracle 10g, one more table space sysaux is added to reduce load on oracle default tablespace system. Oracle database 10g and oracle9i database manageability. You created a new oracle internet directory instance by creating a new configsetn entry and then. In this article, we have thrown light on the difference between oracle 11g and 12c, the difference between oracle 10g vs.
As per oracle, the letter g in the name of oracle 10g signifies the organizations. It is an easytouse tool for creating business applications, from templates or from scratch. The differences between 9i and 10g can be found here. Here are some key features of oracle database 9i, 10g and 11g. What differences are there in options between 9i and 10g.
In the article i will try to explain the newly added features in oracle 12c as well as oracle 11g vs 12c. Itll probably be hinted at or announced at the next appsworld. You will find complete documentation for oracle 10g on oracles web site, but the two. What are the differences between forms 11g and 12c. Difference between 10g, 11g and 12c oracle database 10g new features. Oracle database 10g and 9i manageability comparison. Tell me the 10 major difference between oracle 8 and oracle. Oracle 11g vs 12c difference between oracle 11g and. We are more interested in features that are depricated in oracle 10g 10. Oracle application server oas is connects to oracle databases and is used for creating realtime reports and metric information from data. With oracle database 9i and 10g now both out of support, you should be thinking about an oracle database upgrade to oracle 11g or 12c. Upgrade your dba ocp certification to oracle database 12c. Oracle offers inline views, role based security, advanced replication, etc.
It makes these decisions based on the structure of the query, the statistical. The main difference between the two is that oracle 10g is a higher version than oracle 9i and has many. The differences between oracle database 9i, 10g,11g and 12c. You will find complete documentation for oracle 10g on oracle s web site, but the two documents that will be of most interest to you are. String matching by testing levels of similaritydifference use. Microsoft access vs oracle what are the differences. As an oracle dba, database upgrades is one of the critical tasks that you must be confident about. Sep, 2011 what is difference between oracle 9i and oracle 10g what is difference between oracle 9i and oracle 10g what is the full form of i in oracle 9i what is the full form of g in oracle 10g ans. I keep a list of the differences and make sure to see these important differences when migrating from 9i to oracle 10g. What to expect from the optimizer 1 introduction the purpose of the optimizer is to determine the most efficient execution plan for your queries. There are some newly added features in oracle 12c over oracle 11g.
For example, iirc between oracle 8 and 9, the mod function became illegal to use as an infix operator. Oracle database administrator certified professionals ocp upgrade to the new oracle database 12c administrator certified professional certification by taking a single exam, upgrade to oracle database 12c 1z0060, regardless of the version of oracle database on which you are certified oracle7, oracle8, oracle8i, oracle9i, oracle database 10g, or oracle database 11g. Differences between oracle 9i and 10g burleson consulting. Well, the main difference between oracle and mysql is their capabilities as oracle is a much more powerful software than mysql. Tell me the 10 major difference between oracle 8 and. This will help you in increasing the knowledge about oracle database 9i as some of the questions may be new to you. In my previous article, i have given the idea about the oracle 11g new features.
I am not looking for vendor differences but objective differences here. If you want to run a oracle database, this is what you are looking for. Nov 09, 20 each oracle release has many differences. Difference between oracle reports 6i and 10g 20101216. Oracle client 10g is a follower of the 9i platform hosted by oracle. 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. Hi guys, could some of you tell me the difference between oracle 9i 9. As this is the management tool that comes bundled with the. Jun 11, 2016 from its creation in the early 1980s, oracle had undergone continuous improvement and redefinition until the oracle 8i, first released in 1997 to its most recent release, the oracle 12c released in june 20. And oracle 9i has a host of new features designed to make the database more stable, easier to manage and increase functionality.
Basically it is a significantly different version of oracle that has a number of new features. I am not considering the versions and their supported os, in the interview point of view. The latest release of the oracle database, oracle database 10g, introduced a number of new manageability enhancements designed to make the oracle database highly selfmanaging. The differences between 9i and 10g are too numerous to list here.
Oracle 10g oracle 10g was the upgraded version from oracle 9i. What is difference between oracle 9i and 10g answers. Oct 27, 2017 difference between 10g, 11g and 12c oracle database 10g new features. This is most useful article for such database administrator. Nid utility has been introduced to change the database name a. What is the difference between oracle 9i and oracle 10g. Oracle 10g was the upgraded version from oracle 9i. To this end, oracle enterprise manager oem gave a powerful grid control mechanism. Moreover, oracle 12c allows running multiple databases on the same hardware while maintaining the security and isolation among the databases. Ive been working with oracle software since about 1989 on oracle5. Oracle 11g vs 12c difference between oracle 11g and oracle. The major difference between oracle 9i and 10g is that oracle 10g is a database which uses lattice computing in the most commercial method to categorize the data. Below is a basic overview of the five generations of oracle databases from 8i to 12c. Jun 19, 2006 i expect a new major release of the applications to go along with 10g prety soon.
What is the main difference between oracle 8i, 9i, 10g. Find answers to difference between oracle reports of 6i, 9i, 10g and developer 2000, 11i from the expert community at experts exchange. Alongside, we have shed light upon oracle 11 g new features, oracle 10g new features, and the new features oracle 12 c for your benefit. Developers and dbas get help from oracle experts on. Difference between oracle 10g and 11g simplified and improved.
Ask tom what is the major differences between oracle 10 g. Oracle introduces a major new version about every 34 years. Dec 16, 2010 difference between oracle reports 6i and 10g. String matching by testing levels of similarity difference use. String matching by testing levels of similaritydifference. Difference between oracle reports 6i and 10g club oracle. The major difference between oracle 9i and 10g is that oracle 10g is a. Im considering a migration to 10g and i need to get a list of all differences. Time and again, oracle releases new versions of oracle database and your client would ask you to upgrade their databases from previous version to latest version. The best place to look for documentation on 10g s new features is oracle technology network. Difference between oracle 10g and 11g and 12c database.
However, oracle is considered to be much more powerful a software than mysql. The main difference between oracle and mysql is the fact that mysql is open source, while oracle is not. You get things like inline views, role based security, advanced replication, and many more. Jun 11, 2007 in 2001 oracle9i appeared with 400 new features, including the ability to read and write xml documents. Difference between oracle and mysql oracle vs mysql. Hi, i want to know the difference between oracle 9i and 10g. In oracle 9i,table spaces are dictionary managed table. Oracle 10g release 2 further enhances support for xml.
Moreover, oracle 12c allows running multiple databases on the same hardware. It is fundamentally used on behalf of the basis that it assists in the. Difference between oracle 9i and oracle 10g difference. Also 11i refers to the oracle applications a suite of financial, human resources, manufacturing, and and accounting applications, not a database. With each release there is is always improvements and new features. It contains a variety of functions that are helpful for testing the level of similaritydifference between strings. Page 2 executive summary easeofuse or manageability is a key focus area for oracle. Difference between oracle server and oracle database.
Most database administrator doesnt know the difference between the versions of the oracle database. They are both made by the oracle corporation so a lot of people are asking what the differences between the two are. With oracle database 9i and 10g now both out of support, you should be thinking about an oracle database upgrade to oracle 11g or 12c with each release there is is always improvements and new features. Difference between oracle 10g and 11g simplified and. Oracle 9i does many things differently internally so they are not exactly the same database engine. Each release of oracle has many differences, and oracle 10g is a major rewrite of the oracle kernel from oracle 9i. Difference between oracle 9i and oracle 10g difference between. Oct 12, 2005 the differences between 9i and 10g are too numerous to list here. Can anyone help me understand the detailed difference between the various version of oracle db.
There are many similarities to 11g as 12c continues to use weblogic. I expect a new major release of the applications to go along with 10g prety soon. The main difference between oracle 11g and 12c is that the oracle 11g is an older version of oracle rdbms and has no pluggable databases while oracle 12c is a newer version designed for the cloud and has pluggable databases. Dynamic sampling ds was introduced in oracle database 9i release 2 to. Get unlimited access to documents by upgrading to premium membership.
Oracle has a number of versions like 9i, 10g, 11g etc. In 2003, oracle corporation released oracle database 10g. This post has questions related to oracle 9i dba only. Based on high influx of mail from users requesting difference between oracle applications release 12 and 11i, i decided to dedicate this post to outline few major technical difference. You can connect to oracle interfaces in the following ways. Perform multiple operations such as table drops, table inserts directly on your. While there are several hundred new features and other differences between 9i and 10g, here are the. Difference between oracle 10g and 11g and 12c database stechies.
Oracle 9i is an objectrelational database management system ordmbs. What is the difference between oracle 11g and 12c pediaa. Oracle 10g database administrators require 50% less time than oracle9i to. The best place to look for documentation on 10gs new features is oracle technology network. Moreover, transparent data encryption and passwords for db links provide more powerful encryption for data. Note the difference between avg and median select avgsal average,mediansal median. Oracle server is the actual oracle database and its client software. First, compare the differences between forms 11g and 12c before you begin your upgrade project, or if you are considering upgrading to either 11g or 12c from an older version such as 6i. Dec 03, 2018 the main difference between oracle 11g and 12c is that the oracle 11g is an older version of oracle rdbms and has no pluggable databases while oracle 12c is a newer version designed for the cloud and has pluggable databases. Primarily it provided grid computing by provision of cpus and data. Oracle white paperupgrading from oracle database 10g to 11g. It was a very stable version from the out set with many of the bugs in 9i fixed and with host of new features.
117 43 879 1402 1512 454 288 1275 440 486 708 966 695 1082 1238 514 272 997 1538 396 1024 37 1062 222 919 399 93 1176 1118 912 620 1264 851