The following are changes in Oracle Installation for Oracle Database release 19c. Root Scripts Automation Support for Oracle Database Installation Rapid Home Provisioning (RHP) Name Change Starting with Oracle Database 19c and Oracle Grid Infrastructure 19c, Rapid Home Provisioning is renamed to Fleet Patching and Provisioning (FPP). The following are changes in Oracle Database Data Warehousing for […]
The following are changes in Oracle Database Performance Tuning for Oracle Database Release 19c. Memoptimized Rowstore – Fast Ingest Automatic Database Diagnostic Monitor (ADDM) support for pluggable databases (PDBs) The following are changes in Oracle Database In-Memory for Oracle Database release 19. Database In-Memory wait on populate Big Data and performance enhancements for In-Memory external tables Hybrid partitioned […]
These are the new features for Oracle Automatic Storage Management 19c. SRVCTL command enhancements Flushing the password file metadata Automatic block corruption recovery with the CONTENT.CHECK disk group attribute New and updated ASMCMD commands The password option with the ASMCMD pwcreate command is now optional. The new ASMCMD setsparseparent command sets the parent for a sparse child file. The new ASMCMD mvfile command moves a […]
These are the changes in Oracle Data Guard Concepts and Administration for Oracle Database Release 19c. The process of flashing back a physical standby to a point in time that was captured on the primary is simplified by automatically replicating restore points from primary to the standby. When flashback or point-in-time recovery is performed on the primary […]
The following initialization parameters are new in Oracle Database Release 19c, Version 19.1: ADG_REDIRECT_DML DATA_GUARD_MAX_IO_TIME DATA_GUARD_MAX_LONGIO_TIME ENABLE_IMC_WITH_MIRA LOB_SIGNATURE_ENABLE MAX_DATAPUMP_PARALLEL_PER_JOB The following static data dictionary views are new in Oracle Database Release 19c, Version 19.1: ALL_TRIGGERS_AE, DBA_TRIGGERS_AE, and USER_TRIGGERS_AE DBA_PDB_SNAPSHOTFILE DBA_RAT_CAPTURE_SCHEMA_INFO DBA_REGISTRY_BACKPORTS The following dynamic performance views are new in Oracle Database Release 19c, Version 19.1: GV$AQ_PARTITION_STATS and V$AQ_PARTITION_STATS […]
The following are changes in the Oracle Security for Oracle Database Release 19c. Signature-Based Security for LOB LocatorsStarting with this release, you can configure signature-based security for large object (LOB) locators. Default User Accounts Now Schema OnlyUsing the schema only account feature from Oracle Database release 18c, most of the Oracle Database supplied schemas (users) now have […]
The following are changes in the Oracle Database Backup and Recovery for Oracle Database Release 19c. Recovery catalog support for PDBs You can connect to a recovery catalog when the target database is a pluggable database (PDB). Automatic deletion of flashback logs Flashback logs that are beyond the retention period are automatically deleted. Automatically deleting flashback logs […]
Oracle Database supplied user accounts are now schema only accounts Most of the Oracle Database supplied user accounts, except SYS and sample schemas are now schema only accounts, that is, these accounts are created without passwords. This prevents malicious users from logging into these accounts. You can assign passwords to these accounts whenever you want them to be authenticated. […]
Enhancements to database-managed PDB snapshots When the initialization parameter CLONEDB is TRUE, database-managed snapshots create sparse copies of the data files of the source PDB. Starting in Oracle Database 19c, you can create database-managed snapshot clone PDBs from a source PDB that is open read/write. In previous releases, the source PDB needed to remain read-only and unchanging for […]