Changes in This Release for Oracle Database Reference (2024)

This preface lists changes in Oracle Database Reference:

Changes in Oracle Database 19c, Release Update 19.22
Changes in Oracle Database 19c, Release Update 19.16
Changes in Oracle Database 19c, Release Update 19.13
Changes in Oracle Database 19c, Release Update 19.11
Changes in Oracle Database 19c, Release Update 19.10
Changes in Oracle Database 19c, Release Update 19.6
Changes in Oracle Database 19c, Release Update 19.4
Changes in Oracle Database 19c

Changes in Oracle Database 19c, Release Update 19.23

The following initialization parameter is new in Oracle Database 19c, Release Update 19.23:

SESSION_EXIT_ON_PACKAGE_STATE_ERROR

Changes in Oracle Database 19c, Release Update 19.22

The following initialization parameter is new in Oracle Database 19c, Release Update 19.22:

OGG_ONLINE_DDL

The following initialization parameter is changed in Oracle Database 19c, Release Update 19.22:

The value of the PRE_PAGE_SGA initialization parameter is always set to true on Exadata systems. Any attempt to set this parameter to false on an Exadata system will not take effect.

Changes in Oracle Database 19c, Release Update 19.21

The following initialization parameter is new in Oracle Database 19c, Release Update 19.21:

MAIN_WORKLOAD_TYPE

Changes in Oracle Database 19c, Release Update 19.16

The following initialization parameters are new in Oracle Database 19c, Release Update 19.16:

IDENTITY_PROVIDER_CONFIG
IDENTITY_PROVIDER_TYPE
TABLESPACE_ENCRYPTION

Changes in Oracle Database 19c, Release Update 19.13

New AE Analytic Views

Oracle Database 19c, Release Update 19.13, introduces AE ("all edition") analytic views. Each new AE analytic view corresponds to an existing non-AE analytic view. AE views have the same columns as their non-AE counterparts, plus a column that displays the name of the application edition where the editioned object is defined.

The following table lists the new AE analytic views, divided into three categories: analytic view views, attribute dimension views, and hierarchy views. For brevity, only the ALL_ views are listed. The corresponding DBA_ and USER_ views are also available and are documented in this guide.

Analytic View Views	Attribute Dimension Views	Hierarchy Views
ALL_ANALYTIC_VIEW_ATTR_CLS_AE ALL_ANALYTIC_VIEW_BAS_MEAS_AE ALL_ANALYTIC_VIEW_CLASS_AE ALL_ANALYTIC_VIEW_CLC_MEAS_AE ALL_ANALYTIC_VIEW_COLUMNS_AE ALL_ANALYTIC_VIEW_DIM_CLS_AE ALL_ANALYTIC_VIEW_DIMS_AE ALL_ANALYTIC_VIEW_HIER_CLS_AE ALL_ANALYTIC_VIEW_HIERS_AE ALL_ANALYTIC_VIEW_KEYS_AE ALL_ANALYTIC_VIEW_LEVELS_AE ALL_ANALYTIC_VIEW_LVL_CLS_AE ALL_ANALYTIC_VIEW_LVLGRPS_AE ALL_ANALYTIC_VIEW_MEAS_CLS_AE ALL_ANALYTIC_VIEWS_AE	ALL_ATTRIBUTE_DIM_ATTR_CLS_AE ALL_ATTRIBUTE_DIM_ATTRS_AE ALL_ATTRIBUTE_DIM_CLASS_AE ALL_ATTRIBUTE_DIM_JN_PTHS_AE ALL_ATTRIBUTE_DIM_KEYS_AE ALL_ATTRIBUTE_DIM_LEVELS_AE ALL_ATTRIBUTE_DIM_LVL_ATRS_AE ALL_ATTRIBUTE_DIM_LVL_CLS_AE ALL_ATTRIBUTE_DIM_ORD_ATRS_AE ALL_ATTRIBUTE_DIM_TABLES_AE ALL_ATTRIBUTE_DIMENSIONS_AE	ALL_HIER_CLASS_AE ALL_HIER_COLUMNS_AE ALL_HIER_HIER_ATTR_CLASS_AE ALL_HIER_HIER_ATTRIBUTES_AE ALL_HIER_JOIN_PATHS_AE ALL_HIER_LEVEL_ID_ATTRS_AE ALL_HIER_LEVELS_AE ALL_HIERARCHIES_AE

Changes in Oracle Database 19c, Release Update 19.11

The following initialization parameter is new in Oracle Database 19c, Release Update 19.11:

DRCP_DEDICATED_OPT

The following static data dictionary views are new in Oracle Database 19c, Release Update 19.11:

DBA_ACCHK_EVENTS
DBA_ACCHK_EVENTS_SUMMARY
DBA_ACCHK_STATISTICS
DBA_ACCHK_STATISTICS_SUMMARY
ALL_IMMUTABLE_TABLES, DBA_IMMUTABLE_TABLES, and USER_IMMUTABLE_TABLES

Changes in Oracle Database 19c, Release Update 19.10

The following initialization parameters are new in Oracle Database 19c, Release Update 19.10:

BLOCKCHAIN_TABLE_MAX_NO_DROP
CONTAINER_DATA
MAX_AUTH_SERVERS
MIN_AUTH_SERVERS
OPTIMIZER_REAL_TIME_STATISTICS

The following static data dictionary views are new in Oracle Database 19c, Release Update 19.10:

ALL_BLOCKCHAIN_TABLES, DBA_BLOCKCHAIN_TABLES, and USER_BLOCKCHAIN_TABLES
ALL_CERTIFICATES, DBA_CERTIFICATES, and USER_CERTIFICATES
DBA_LOGMNR_DICTIONARY_BUILDLOG

Changes in Oracle Database 19c, Release Update 19.6

The following initialization parameter is new in Oracle Database 19c, Release Update 19.6:

OPTIMIZER_SESSION_TYPE
See Also
How to Find Your Oracle Database Version Number

Changes in Oracle Database 19c, Release Update 19.4

The following initialization parameter is new in Oracle Database 19c, Release Update 19.4:

IGNORE_SESSION_SET_PARAM_ERRORS

Changes in Oracle Database 19c

This section lists changes in Oracle Database Reference for Oracle Database 19c.

See Oracle Database New Features Guide for a complete list of new features for this release.

New Features

This section lists new features in this manual for Oracle Database 19c.

The following initialization parameters are new in Oracle Database 19c:

ADG_REDIRECT_DML
ALLOW_ROWID_COLUMN_TYPE
CLIENT_STATISTICS_LEVEL
CPU_MIN_COUNT
DATA_GUARD_MAX_IO_TIME
DATA_GUARD_MAX_LONGIO_TIME
ENABLE_IMC_WITH_MIRA
LOB_SIGNATURE_ENABLE
MAX_DATAPUMP_PARALLEL_PER_JOB
MAX_IDLE_BLOCKER_TIME
UNIFIED_AUDIT_COMMON_SYSTEMLOG

Note:

See Initialization Parameters for more information about these initialization parameters.

The following static data dictionary views are new in Oracle Database 19c:

ALL_TRIGGERS_AE, DBA_TRIGGERS_AE, and USER_TRIGGERS_AE
DBA_AUTO_INDEX_CONFIG
DBA_AUTO_STAT_EXECUTIONS
DBA_PDB_SNAPSHOTFILE
DBA_RAT_CAPTURE_SCHEMA_INFO
DBA_REGISTRY_BACKPORTS
DBA_SQL_QUARANTINE

Note:

Static Data Dictionary Views for more information about these static data dictionary views

The following dynamic performance views are new in Oracle Database 19c:

GV$AQ_PARTITION_STATS and V$AQ_PARTITION_STATS
GV$ASM_ACFSAUTORESIZE and V$ASM_ACFSAUTORESIZE
GV$MEMOPTIMIZE_WRITE_AREA and V$MEMOPTIMIZE_WRITE_AREA
GV$SHARED_SERVER_STAT and V$SHARED_SERVER_STAT
GV$SQL_TESTCASES and V$SQL_TESTCASES

Note:

GV$ Views and Dynamic Performance Views for more information about these dynamic performance views

Deprecated Features

The following features are deprecated in Oracle Database 19c, and may be desupported in a future release:

The CLUSTER_DATABASE_INSTANCES initialization parameter
The SERVICE_NAMES initialization parameter

Desupported Features

The following features are desupported in Oracle Database 19c:

The MAX_CONNECTIONS attribute of the LOG_ARCHIVE_DEST_n initialization parameter, for Oracle Data Guard redo transport
The EXAFUSION_ENABLED initialization parameter
The O7_DICTIONARY_ACCESSIBILITY initialization parameter
Oracle Streams is desupported. As a result, the following views are desupported:
- ALL_STREAMS_COLUMNS
- ALL_STREAMS_MESSAGE_RULES
- ALL_STREAMS_RULES
- ALL_STREAMS_UNSUPPORTED
- DBA_STREAMS_ADMINISTRATOR
- DBA_STREAMS_COLUMNS
- DBA_STREAMS_MESSAGE_RULES
- DBA_STREAMS_RULES
- DBA_STREAMS_SPLIT_MERGE
- DBA_STREAMS_SPLIT_MERGE_HIST
- DBA_STREAMS_STMTS
- DBA_STREAMS_STMT_HANDLERS
- DBA_STREAMS_TRANSFORMATIONS
- DBA_STREAMS_UNSUPPORTED
- V$STREAMS_CAPTURE
- V$STREAMS_MESSAGE_TRACKING
- V$STREAMS_TRANSACTION
Extended Datatype Support (EDS) is desupported. As a result, the following views are desupported:
- DBA_LOGSTDBY_EDS_SUPPORTED
- DBA_LOGSTDBY_EDS_TABLES

FAQs

How to undo changes in Oracle Database? ›

Oracle provides a fully automated mechanism, referred to as automatic undo management, for managing undo information and space. With automatic undo management, the database manages undo segments in an undo tablespace. Automatic undo management is the default mode for a newly installed database.

Read On ›

How to check Oracle Database release? ›

To check the Oracle database version, you can run the following SQL query: “SELECT * FROM v$version;” in SQL*Plus or any SQL client.

Discover More Details ›

How to save changes in Oracle Database? ›

When you finish editing or adding a record in a form or list, do one of the following:

Step off the record to commit the changes to the database. ...
Click the Cogwheel icon, and then click Save Record.
From the application-level menu, choose Edit, then Save Record.

What is the latest long term release of the Oracle Database? ›

Oracle Database Release Roadmap

Release	Patching End Date
23ai Long Term Release	April 30, 2032
21c Innovation Release	April 30, 2025
19c Long Term Release	April 30, 2026 with Premier Support April 30, 2027 with ES/ULA
18c Innovation Release	Jun 30, 2021

4 more rows

Aug 14, 2024

See Details ›

How to rollback an update in Oracle? ›

Select the Device Route Set Updates tab. Select the failed update task you want to rollback in the Update Tasks table and click Rollback.

Find Out More ›

What is the difference between undo and redo in Oracle database? ›

UNDO is used to rollback transactions. REDO records changes to the original data, and is important for transactions that are not committed at the time of a crash or failure. REDO is used to roll forward transactions.

Tell Me More ›

Which key is used to save the changes in the database? ›

Open and save databases

To do this	Press
Move forward through options.	Tab key
Move backward through options.	Shift+Tab
Open the Look in list.	F4 or Alt+I
Save a database object.	Ctrl+S or Shift+F12

7 more rows

Show Me More ›

Which command is used to save changes to the database? ›

The 'Commit' command is used to permanently save a transaction into the database, ensuring data consistency, integrity, and durability. It is a crucial step in the transaction process and plays a vital role in maintaining a reliable and accurate database.

Explore More ›

How to capture data changes in Oracle? ›

Users can set up Asynchronous Oracle CDC (Change Data Capture) by implementing the following steps:

Step 1: Configuring Database.
Step 2: Enabling Supplemental Logging.
Step 3: Enabling Logging for Columns.
Step 4: Preparing Source Tables.
Step 5: Creating Change Set.
Step 6: Creating Change Table.
Step 7: Enabling Change Set.

Feb 1, 2022

How often does Oracle release updates? ›

Typically, production environments are patched on the third Friday of the month. Oracle notifies Service Administrators of the updates included in each patch. For minor patch releases, Oracle typically provides one week advance notification before patching the test environment.

Show Me More ›

Is Oracle still the best database? ›

Yes, Oracle is still considered one of the best databases, as it continues to dominate the enterprise market and has received high scores in database management evaluations.

Read The Full Story ›

What will replace Oracle? ›

Top Oracle Alternatives

Microsoft.
IBM.
Amazon Web Services (AWS)
MongoDB.
Google.
SAP.
MariaDB.
Cloudera.

See Details ›

How do I undo changes in SQL database? ›

You can undo changes that aren't committed to source control yet. In the Object Explorer, right-click the object, folder, or database with changes you want to undo, select Other SQL Source Control tasks > Undo changes. Alternatively, right-click an object on the Commit tab, and click Undo changes.

Get More Info Here ›

How does undo work in Oracle? ›

When a transaction modifies the database, Oracle copies the original data before modifying it. The original copy of the modified data is called undo data.

How do I ROLLBACK the transaction? ›

After you create a table, the following statements start a named transaction, insert two rows, and then roll back the transaction named in the variable @TransactionName . Another statement outside of the named transaction inserts two rows. The query returns the results of the previous statements.

How to recover current redo log file in Oracle? ›

Recovering After the Loss of All Members of an Online Redo Log Group

Locate the filename of the lost redo log in V$LOGFILE and then look for the group number corresponding to it. ...
Determine which groups are active. ...
If the affected group is inactive, follow the procedure in Losing an Inactive Online Redo Log Group.

View Details ›