Difference between Oracle 10g and 11g

By Jaxson

Main Difference

Oracle databases are the well famous objective-oriented database administration frameworks created and conveyed by Oracle Corporation. The most recent variant of Oracle databases is Oracle 11g, initially discharged in September 2008; it succeeded Oracle 10g. These variants are a part of the proceeded with the advancement of the Oracle databases since the 1980s. Each new form has more up to date patch sets discharge routinely, the most noteworthy of which are known as a release. A noteworthy goal of each updated rendition is to build execution and versatility over the more seasoned variant. Along these lines, there are numerous new elements in 11g based on top of those officially accessible in 10g. These give better capacities to the database overseers (DBAs) to deal with their multi-layered database situations that are getting more mind boggling and bigger throughout the years. Oracle 10g was the redesigned rendition from Oracle 9i. It was an exceptionally stable form from the outset with a hefty portion of the bugs in 9i altered and with a host of new elements. Fundamentally it gave matrix figuring by procurement of CPUs and information. To this end, Oracle Enterprise Manager (OEM) gave a capable lattice control instrument. This adaptation likewise gave upgrades to cutting edge expansions, for example, Oracle RAC (Real Application Clusters), Oracle Data Guard and Oracle Streams. 10g achieved mechanization of most organization errands by presenting numerous self-overseeing highlights like computerized database demonstrative screen, robotized shared memory tuning, mechanized capacity administration, and mechanized circle based reinforcement and recuperation. Oracle 11g pushed the wrap further, upgrading a hefty portion of the components found in 10g. It gave new parts, for example, Oracle Configuration Manager (OCM), Oracle Application Express, Oracle SQL Developer, Oracle Database Vault, Oracle Real Application Testing, Oracle Warehouse Builder, and Oracle Shadow Copy Service. In this manner 11g gives better execution and its discharge 2 has been intended for fresher working frameworks, for example, Windows 7, Server 2008 and most recent adaptations of Linux, UNIX, Solaris, and so on. Contrasted and 10g, 11g gives more rearranged, enhanced and mechanized memory administration and better capacity to analyze issues through the inbuilt framework to counteract, distinguish, analyze, and resolve basic database blunders, and additionally, low database execution issues. It gives undetectable records, virtual sections, table parceling and the capacity to rethink tables which have emerged view logs whilst on the web. A noteworthy distinction in the two are the new security highlights found in 11g, for example, better secret key based confirmation with blended case passwords, encryption, and upgrades for information pump encryption and pressure. 11g proceeded with the utilization of various versions utilized as a part of 10g which are Enterprise Edition (EE), Standard Edition (SE), Standard Edition One (SE1), Express Edition (EX) and Oracle Database Lite for cell phones.

Oracle 10g

Oracle Database 10g was the main database intended for lattice registering, the most adaptable and savvy approach to overseeing endeavor data. It cut expenses of administration while giving the most noteworthy conceivable nature of administration. 10g is Oracle’s network registering item gather including (in addition to other things) a database administration framework (DBMS) and an application server. Notwithstanding supporting framework figuring elements, for example, asset sharing and programmed load adjusting, 10g items robotize numerous database administration errands. The Real Application Cluster (RAC) part makes it conceivable to introduce a database over various servers. 10g takes after Oracle’s 9i stage. Oracle says that the g (rather than the normal i) in the name symbolizes the organization’s dedication to the network model. Notwithstanding, as per some reports, numerous early adopters are sending 10g exclusively for its computerization includes and have no prompt arrangements of executing a lattice domain.

Oracle 11g

Oracle Database 11g Express Edition (Oracle Database XE) is a section-level, little impression database taking into account the Oracle Database 11g Release 2 code base. It’s allowed to create, send, and disseminate; quick to download; and easy to oversee. Oracle Database XE is an incredible starter database for the Designers taking a shot at Node.js, Python, PHP, Java,NET, XML, and Open Source applications. DBAs who require a free, starter database for preparing and arrangement. Autonomous Software Vendors (ISVs) and equipment sellers who need a starter database to appropriate for nothing out of pocket. Instructive establishments and understudies who require a free database for their educational programs. With Oracle Database XE, you can now create and convey applications with an effective, demonstrated, industry-driving framework, and after that overhaul when essential without exorbitant and complex movements. Oracle Database XE can be introduced on any size host machine with any number of CPUs (one database for every machine), except XE will put away to 11GB of client information, use up to 1GB of memory, and utilize one CPU on the host machine. The backing is given through a free Oracle Discussion Forum observed by Oracle representatives and additionally group specialists.

Key Differences

  • Oracle 11g is an upgrade of 10g.
  • 11g is a better choice for DBAs.

Leave a Comment