Oracle database release

Long Term Support Release

- 5 years of Premier support followed by 3 years of Extended Support - Recommended for production databases

- Currently is 19c ( PS ends April 30, 2024)

- The next one is scheduled to be 23c

Innovation Release

- 2 year of Premier Support, no Extended Support - Recommended for studying the new features in development environments

- Examples: 12c, 18c, and 21c

Comments

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.

ORACLE DBA NOTES

ORACLE DBA NOTES 3 ORACLE DBA NOTES 2 ORACLE DBA NOTES 1

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.

DAILYDBADIARIES

Search This Blog