“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in April 2020. I hope you find these helpful to learn something new or to remind you of its existence and use.
| #OraTidbit #db20c Oracle Data Guard Broker provides early detection of fast-start failover (FSFO) configuration issues and reports those misconfigurations allowing administrators to take action prior to a failover event. |
| #OraTidbit #db20c Oracle Data Guard broker utilizes a standardized directory structure to store client-side files. Use the DG_ADMIN environment variable to specify the default location. |
| #OraTidbit #db20c Two new #GoldenGate views, DBA_OGG_AUTO_CAPTURED_TABLES, and USER_OGG_AUTO_CAPTURED_TABLES, provide you with tools to query which tables are enabled for Oracle GoldenGate automatic capture. |
| #OraTidbit #db20c #db19c Init parameter MAX_IDLE_BLOCKER_TIME specifies the maximum number of minutes that a blocking session can be idle. After that point, the session is automatically terminated. This parameter differs from the MAX_IDLE_TIME parameter in that MAX_IDLE_TIME applies to all sessions (blocking and non-blocking), whereas MAX_IDLE_BLOCKING_TIME applies only to blocking sessions. |
| #OraTidbit #db20c In 20c, you must configure the Grid Infrastructure Management Repository (GIMR) in a separate Oracle home, instead of in the Grid home. A separate Oracle home for the GIMR ensures faster rolling upgrades, less errors, and fewer rollback situations. |
| #OraTidbit #db20c The remote Grid Infrastructure Management Repository (GIMR) feature for Oracle Standalone Cluster enables you to use a centralized GIMR. This feature does not require local cluster resources to host the GIMR. |
| #OraTidbit #db20c Init parameter DIAGNOSTICS_CONTROL helps to control and monitor the users who perform potentially unsafe database diagnostic operations. To modify this parameter with the ALTER SYSTEM command, you must be authenticated AS SYSDBA. |
| #OraTidbit #db20c Init parameter TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM specifies the default algorithm the database uses when encrypting a tablespace if an encryption algorithm is not specified when creating an encrypted tablespace or when encrypting an existing tablespace. |
| #OraTidbit #AutoUpgrade Oracle Database AutoUpgrade enables you to upgrade one or many databases without human intervention, all with one command, and with a single configuration file. |
| #OraTidbit #DBUpgrade Use the Oracle Database Parallel Upgrade Utility with the -T option to take schema-based tablespaces offline during upgrade. Oracle Database can read file headers created in earlier releases. The file headers of READ ONLY tablespaces are updated when they are changed to READ WRITE. |
| #OraTidbit #DBUpgrade If you plug in an earlier release PDB to a new release CDB, then the CDB detects on opening the PDB that the PDB is an earlier release than the CDB, and automatically starts a Replay Upgrade process. Upgrade on PDB Open automatically upgrades the PDB using the Replay Upgrade synchronization feature. |
| #OraTidbit #DBUpgrade By default, the Oracle Multitenant Replay Upgrade method is enabled for upgrades on PDBs and CDBs. To disable the Parallel Upgrade Utility (catctl.pl) default of performing a Replay Upgrade, run ALTER DATABASE UPGRADE SYNC OFF on either CDB$ROOT or a particular PDB. |
| #OraTidbit #db20c Traditional auditing is deprecated in 20c. Thus, AUDIT_FILE_DEST, AUDIT_SYS_OPERATIONS, AUDIT_SYSLOG_LEVEL, AUDIT_TRAIL init parameters are deprecated. |
| #OraTidbit #db20c The UNIFIED_AUDIT_SGA_QUEUE_SIZE initialization parameter is desupported in 20c database. |
| #OraTidbit #db20c #AutonomousDB Autonomous Database instance OCPU compute usage is now billed per-second with a one minute minimum. Previously Autonomous Database billed in one-hour minimum increments and partial usage of an hour was rounded up to a full hour. |
| #OraTidbit #AutonomousDB You can create Oracle Autonomous Database Dedicated Deployment on quarter-rack or half-rack Exadata Database Machine X7-2 or X8-2 systems. |
| #OraTidbit #VirtualBox Oracle VM VirtualBox 6.1 supports the importing of cloud instances from an Oracle Cloud Infrastructure service. When you import a cloud instance, Oracle VM VirtualBox creates and registers a new VM automatically on the localhost. |
| #OraTidbit #VirtualBox You can export a VirtualBox VM to Oracle Cloud Infrastructure account and save it as a custom image to create multiple cloud instances from the custom image, without having to reupload the image every time. |
| #OraTidbit #Linux The virt-v2v utility converts virtual machines from Oracle VM hypervisor, including their disk images and metadata, for use with Oracle Linux Virtualization Manager and Oracle Linux KVM. |
| #OraTidbit #AutonomousDB Autonomous Database supports loading and using Simple Oracle Document Architecture (#SODA) documents and collections. SODA allows us to store, search, and retrieve document collections, typically JSON documents, without using SQL. |