EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Oracle Tutorial Oracle DBA Versions
Secondary Sidebar
Oracle Tutorial
  • Advanced
    • Timestamp to Date in Oracle
    • Oracle Golden Gate
    • Oracle Virtual Machine
    • Oracle Describe Table
    • Oracle Clauses
    • Oracle Having Clause
    • Oracle?Primavera
    • Oracle FOREIGN Key
    • PIVOT in Oracle
    • Oracle Alter Table
    • Oracle Queries
    • Oracle Views
    • Oracle Window Functions
    • Oracle String Functions
    • Oracle Date Functions
    • Oracle Analytic Functions
    • Oracle Aggregate Functions
    • Select in Oracle
    • INSERT in Oracle
    • DISTINCT in Oracle
    • Function in Oracle
    • Oracle GROUP_CONCAT
    • Oracle INSTR()
    • Oracle CONVERT
    • Oracle LENGTH()
    • Oracle EXISTS
    • Oracle REPLACE()
    • Oracle MERGE
    • Oracle LEAD()
    • Oracle EXTRACT()
    • Oracle LISTAGG()
    • Oracle SYS_CONTEXT()
    • Oracle COALESCE
    • Oracle NVL()
    • Oracle SYSDATE()
    • Oracle?Date Format
    • Oracle SYS_GUID()
    • Oracle WILDCARDS
    • Oracle Synonyms
    • Oracle Subquery
    • BETWEEN in Oracle
    • FETCH in Oracle
    • Oracle Index
    • Oracle Function-based Index
    • Oracle UNIQUE Index
    • Oracle Bitmap Index
    • Oracle Column
    • Oracle Triggers
    • Oracle Procedures
    • Sample Database for Oracle
    • Oracle LIKE Operator
    • ORDER BY in Oracle
    • Oracle ORDER BY DESC
    • GROUP BY in Oracle
    • Oracle GROUP BY HAVING
    • Oracle Aliases
    • Table in Oracle
    • Oracle Temporary Table
    • Oracle? Table Partition
    • Oracle rename table
    • Oracle CTE
    • Cursor in Oracle
    • Oracle LOCK TABLE
    • Oracle Tablespace
    • Oracle CARDINALITY
    • Oracle REGEXP
    • Oracle REGEXP_REPLACE
    • Oracle to_date
    • JSON in Oracle
    • Oracle COMMIT
    • Oracle GRANT
    • Oracle MD5
    • Oracle ROLLBACK
    • Oracle Users
    • Oracle TIMESTAMP
    • IF THEN ELSE in Oracle
    • Oracle While Loop
    • Oracle Clone Database
    • Oracle Backup Database
    • Oracle? XML
    • Oracle XMLAGG
    • Oracle XMLTABLE
    • Oracle Performance Tuning
    • Oracle B Tree Index
    • Oracle fusion
    • Oracle ebs
    • Oracle GRC
    • Oracle ERP
    • Oracle ASM
    • Oracle Cloud
    • Oracle HCM Cloud
    • Oracle Integration Cloud
    • Oracle Jinitiator
    • Oracle pathfinder
    • Oracle VirtualBox
    • Oracle Weblogic Server
    • Oracle decode
    • Oracle Exadata
    • Oracle ZFS
    • Oracle? utilities
    • JDBC Driver for Oracle
    • Oracle? DBA Versions
    • Oracle DBA Salary
  • Basic
    • Oracle Marketing Cloud
    • What is Oracle?
    • Career in Oracle
    • How to Install Oracle
    • Oracle Versions
    • What Is Oracle Database
    • Oracle Data Warehousing
    • Oracle Warehouse Builder
    • Career In Oracle Database Administrator
    • Career In Oracle DBA
    • What is Oracle RAC
    • Oracle DBA
    • Oracle? Vanderbilt
    • What is RMAN Oracle
    • Oracle Database Administration
    • Oracle Operators
    • Oracle Constraints
    • Oracle number
    • Oracle Data Types
    • Oracle UNIQUE Constraint
    • Oracle Check Constraint
  • Joins
    • Joins in Oracle
    • Inner Join in Oracle
    • Oracle Cross Join
    • Left Join in Oracle
    • OUTER Join in Oracle
    • Oracle Full Outer Join
    • Natural Join in Oracle
    • Oracle Self Join
    • Oracle hash join
    • Oracle? Update with Join
  • Oracle SET Operators
    • UNION in Oracle
    • Oracle UNION ALL
    • INTERSECT in Oracle
    • MINUS in Oracle
  • Interview Questions
    • Oracle Interview Questions
    • Oracle Apps Interview Questions
    • Oracle Apps Technical Interview Questions
    • Oracle Database Interview Questions
    • Oracle Forms Interview Questions
    • Oracle PL/SQL Interview Questions
    • Oracle RAC Interview Questions
    • Oracle SOA Interview Questions

Related Courses

Oracle Course Training

Oracle DBA Certification Course

MongoDB Certification Training

Oracle DBA Versions

Oracle DBA Versions

Definition of Oracle DBA versions

  • Oracle DBA is defined as Oracle Database Administrator who is responsible to govern the Oracle database server holding different accountabilities and operations.
  • Since types of database users and their associated roles and jobs may vary at a site and therefore this DBA user having a high privilege level occupies more priority tasks to handle and control the overall database management and administration for the application creators and other users.
  • In every database server, there is a requirement of at least a single DBA for administrating the large site as well as a small one. Since Oracle database server is big and includes many types of users who share a section of responsibilities with each other to handle and secure the database.
  • Hence, an Oracle DBA version comprises Oracle database enhancements to bring up new capabilities to sustain the market-leading performance, reliability, scalability, and security also on-premises and in the cloud.

Oracle DBA versions

Initially, Oracle was founded by Larry Ellison, Bob Miner along Ed Oates on June 16, 1977, under the name SDL (Software Development Laboratories). Later the company was not successful with the name till 1979 and then in the same year the company name was modified to Relational Software Inc worked in Relational Software Inc, by three courageous friends which were till 1982. Also, further, the company was recognized with its products and again altered to Oracle Systems Corporation. Later in 1995, the name was modified to Oracle Corporation which is still continued to this current date.

This was just a brief on oracle DBA Versions history. Now, let us discuss and explain some details on DBA versions also listed as follows:

Version Year New Structures 
Oracle v2 1979 Initial commercialized SQL-based RDBMS.
Oracle v3 1983 Data Distribution, Concurrency Controller, and Scalability
Oracle v4 1984 Read Consistency having Multiversion
Oracle v5 1985 Distributed database systems & server/client computing support
Oracle v6

 

1988 PL/SQL, Online backup and recovery, Row-level locking, Oracle Parallel Server, and scalability
Oracle 7 1992 Triggers, PL/SQL stored events procedures, Cost-based Optimizer, shared Cursors, Transparent Application Failover
Oracle 8 1997 Virtual Private Database, Partitioning, Java, Recovery manager, Native Internet protocols, Dataguard
Oracle 9 2001 Logical Standby, Oracle XML DB, Oracle Real application clusters i.e. RAC, Streams, Data Mining
Oracle 10gR1 2003 Automatic Database Diagnostic Monitor, Oracle ASM, Grid Infrastructure, Flashback Database
Oracle 10gR2 2005 Online Indexing, Transparent Data Encryption, Database Vault, Real application testing, Advanced Compression
Oracle 11gR1 2007 Exadata, Secure Files, Active Data Guard
Oracle 11gR2 2009 Database Appliance, Cluster File system, Hybrid Columnar Compression, golden Gate Replication, Data Redaction
Oracle 12cR1 2013 Database cloud service, In-memory Column store, SQL pattern matching, Native JSON, Multitenant architecture
Oracle 12cR2 2016 Cloud at customer, Exadata cloud service, Zero data loss recovery appliance, Native sharding
Oracle 18c 2018 Active Directory Integration, Autonomous database, Polymorphic table functions, Data guard multi-instance redo apply
Oracle 19c 2019 Partitioned Hybrid Tables, Automatic Indexing, Real-time stats + stats only queries, Data-guard DML
  • Oracle 8: With this version of DBA in Oracle, Recovery Manager(RMAN) was introduced that denotes the recovery and backup tool of Oracle database along with Partitioning feature making a prodigious involvement to the Database Management system in positions of performance. Also, with Oracle 8 the Disaster recovery feature is out known as Dataguard.
  • Oracle 9: In this version, the most beneficial feature is the (RAC) Real Application Cluster undoubtedly. Further, Oracle Instance available with this feature that is installed on many servers at an identical time delivers high availability of databases. In other RDBMS still, there is no other feature such as RAC(active-active) that has come to be a sine qua non for corporations, called as call business-critical systems particularly for the customers having prompt money flows like banking and insurance.
  • Oracle 10g Release Date: The Oracle 10g was introduced in 2003 which holds the capability to handle Oracle’s storage management from operating systems that is currently called Automatic storage management. With Oracle 9 version, the feature called Real application cluster has been enhanced and the other feature Grid Infrastructure has been released with Oracle 10g. One of the most significant features i.e. Flashback for database administrators and reduces the recovery on user faults was presented with the Oracle 10g. Similarly, some other innovative features such as Transparent Data Encryption and Advanced Compression are also introduced.
  • Oracle 11g Release Date: In 2007, Oracle 11g was introduced. Also, the Exadata was designed as a database machine developed by Oracle on the hardware side. Hence, Oracle 11g becomes the first version of the database to be used in Exadata. In this version, Active dataguard feature was developed for the disaster recovery feature of Dataguard databases. Cluster File system, Hybrid Columnar Compression, and Data Redaction are listed as another feature of this version.
  • Oracle 12c Released that: With the 12c version, Oracle has broadcast several different features at 2012 which has echoed in the market already, and further, the most significant reason behind this is that it has proclaimed Cloud feature. Hence, now the idea of g i.e. grid in 10g and 11g is substituted by c i.e. cloud.
  • Oracle 18c Release Date: The Oracle 18c is out in 2018 including the most significant features such as Data Guard Multi-Instance Redo Apply and Autonomous Database.
  • Oracle 19c Release Date: In 2019, the Oracle 19c is introduced with features such as Automatic Indexing, Partitioned Hybrid Tables, Data-guard DML Redirect, and Real-time Stats + Stats Only Queries features.

Thus, an Oracle DBA functions to prioritize few tasks such as weighing the Database server hardware, deploying the Oracle Software, forecasting the Database, generating & opening the Database, Backup the database and enrolling system users, executing the database design, backing up the entirely functional database and at last tweaking database performance.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,527 ratings)

Conclusion

  • In this Oracle DBA version, we have learned about all several versions that offer diverse new features along with inventive abilities in all the areas consisting of development, security, performance, and management.
  • All delivering the database administrator and developer having essential tools to support creating the innovative application on top of secure and efficient database infrastructure.

Recommended Articles

This is a guide to Oracle DBA Versions. Here we discuss the definition, Explain some details on DBA versions. You may also have a look at the following articles to learn more –

  1. Oracle Update with Join
  2. Oracle EXISTS
  3. Oracle XMLType
  4. Oracle XML
Popular Course in this category
Oracle Training (14 Courses, 8+ Projects)
  14 Online Courses |  8 Hands-on Projects |  120+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

Oracle DBA Database Management System Training (2 Courses)4.9
All in One Financial Analyst Bundle- 250+ Courses, 40+ Projects4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more