Skip to main content

Oracle Database Release

 From here 1979 to 1983 Oracle version 3 

 In the year 1984 Oracle released version 4 

 In the year 1985 Oracle released version 5 

 In the year 1988 released version 6 introduced   row locking in this version

 In the year 1992 Oracle released the version 7 introduced pl/sql storage programs in this version 

 In the year 1997 Oracle released the version 8 introduced objects and partitioning in this version 

 In the year 1999 Oracle released the version 8i internet compounding was introduced in this version 

 In the year 2001 Oracle released version 9iOracle rac was introduced in this version

 In the year 2004 Oracle released version 10g introduced grid computing this version 

 In the year 2007 Oracle released version 11g introduced diagnosatability and availability 

  In the year 2013 Oracle released version 12c introduced the multitenancy and Cloud Computing in this version 

 In the year 2018 Oracle released version 18c introduced polymorphic table function and AD integration

 In the year 2019 Oracle released version 19c introduced automatic indexing in this version

 In the year 2021 Oracle released version 21C  introduced enhanced multitanancy in this version 

 In the year 2023 Oracle released version 23ai introduced Generative AI in this version



Comments

Post a Comment

Popular posts from this blog

Oracle database single instance architecture

Oracle database single instance architecture  Maine database runs on a single machine we referred to this architecture as the Oracle database single instance architecture this setup involves having one Oracle database instance running on the mission serving its clients   The term Oracle database instance simply refers to the combination of memory structure and database process that collectively represent the database service.  However this Architectire has a significant availability risk.  If anything goes wrong with the mission that database becomes UN available.
Post a Comment
Read more

Table spaces

 Tablespace consists of one or more data files.  A data file belongs to only one tablespace. Segments, Extents, and Blocks • Segments exist within a tablespace • Segments are made up of a collection of extents • An extents is a collection of logically contiguous data blocks - Cannot span multiple data files • Data blocks are mapped to disk blocks SYSTEM and SYSAUX Tablespaces • The SYSTEM and SYSAUX tablespaces are mandatory tablespaces. • They are created at the time of database creation. • They must be online. • The SYSTEM tablespace is used for core functionality (for example, data dictionary tables). • The auxiliary SYSAUX tablespace is used for additional database components.
Post a Comment
Read more