“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in June 2019. Hope you find these helpful to learn something new or to remind you of its existence and use.
| #oratidbit Oracle Data Pump in #db19c has a new transform parameter OMIT_ENCRYPTION_CLAUSE that causes Data Pump to suppress any encryption clauses associated with objects using encrypted columns. |
| #oratidbit Deferred Insert is a special type of insert in #db19c for which the database allocates buffers from the large pool. Deferred inserts are automatically committed and cannot be rolled back. |
| #oratidbit Enable deferred insert (#db19c feature) for a table by using the MEMOPTIMIZE FOR WRITE clause in ALTER TABLE or CREATE TABLE. Initiate deferred insert using the /*+ MEMOPTIMIZE_WRITE */ hint in the INSERT statement. |
| #oratidbit #db19c Starting in Oracle Database 19c, the SQL*Plus table PRODUCT_USER_PROFILE (PUP table) is desupported. The SQL*Plus product-level security feature is unavailable in Oracle Database 19c. |
| #oratidbit #db19c Starting with Oracle Database 19c and Oracle Grid Infrastructure 19c, Rapid Home Provisioning is renamed to Fleet Patching and Provisioning (FPP). |
| #oratidbit Using Fleet Patching and Provisioning to patch and upgrade Oracle Restart automates and standardizes the processes that are implemented in Oracle RAC database installations. This also reduces operational demands and risks, especially for large numbers of Oracle Restart deployments. |
| #oratidbit Oracle Big Data SQL supports queries against non-relational data stored in multiple big data sources, including Apache Hive, HDFS, Oracle NoSQL Database, Apache HBase, and Apache Kafka. It enables unified query for distributed data. |
| #oratidbit #oraclecloud Autonomous Database (ADW/ATP) automatically backs up the database for you. The retention period for backups is 60 days. You can restore and recover your database to any point-in-time in this retention period. |
| #oratidbit #oraclecloud Autonomous Database supports restricted access using a network Access Control List (ACL) to accept connections from addresses specified on the ACL and rejects all other client connections. |
| #oratidbit #oraclecloud Autonomous Database supports Application Continuity. Enable using the DBMS_CLOUD_ADMIN.ENABLE_APP_CONT procedure for a service. |
| #oratidbit #OracleRAC Starting with Oracle Grid Infrastructure 19c, the Grid Infrastructure Management Repository (GIMR) is optional for new installations of Oracle Standalone Cluster. Reduces functionality in CHAG, CHACTL, TFA. |
| #oratidbit #OracleRAC In Oracle Grid Infrastructure 12.2, Oracle announced that it would no longer support the placement of the Oracle Cluster Registry (OCR) and voting files directly on a shared file system. This desupport is now rescinded starting with 19c (19.3). |
| #oratidbit V$PASSWORDFILE_INFO provides information about the database password file. IS_ASM column indicates where the password file is stored. |
| #oratidbit Oracle #db19c still supports the DBMS_JOB package. You must grant the CREATE JOB privilege to the database schemas that submit DBMS_JOB jobs. |
| #oratidbit Flash-based Enterprise Manager Express is deprecated in Oracle Database 19c. Starting with #db19c, Enterprise Manager Express uses Java JET technology for the user interface. |
| #oratidbit #db19c Oracle Streams desupported in Oracle Database 19c 19.1. The streams views such as DBA_STREAMS*, ALL_STREAMS*, V$STREAMS* are desupported. |
| #oratidbit #thinkautonomous #APEX Each Autonomous Database (ATP/ADW) instance includes a dedicated instance of Oracle Application Express; you can use this instance to create multiple workspaces. |
| #oratidbit #thinkautonomous Autonomous Database (ATP/ADW) supports Microsoft Azure cloud storage with Oracle Data Pump. |
| #oratidbit #db19c AutoUpgrade enables you to upgrade one or many Oracle Database instances at the command-line, using a single command, and a single configuration file. AutoUpgrade runs preupgrade tasks, fix-ups where needed, database upgrade, and post-upgrade tasks. |
| #oratidbit #db19c Oracle Real Application Testing supported multitenant databases at the root container database (CDB) level. Starting with Oracle Database Release 19c, you can capture and replay the workload from within an individual pluggable database (PDB). |