OracleNotes

“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).

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in May 2019. Hope you find these helpful to learn something new or to remind you of its existence and use.

#oratidbit #orcldb Starting with Oracle Grid Infrastructure 19c, the installation wizard (gridSetup.sh) enables you to perform a dry-run mode upgrade to check your system’s upgrade readiness. It helps anticipate potential problems with the system setup and avoids upgrade failures.

#oratidbit #orcldb Datapump parameters MAX_DATAPUMP_JOBS_PER_PDB and MAX_DATAPUMP_PARALLEL_PER_JOB give DBAs more control over the number of jobs that can be started in a container DB, and the number of parallel workers that can be used for an individual job, respectively.

#oratidbit #orcldb #db19c When INMEMORY_SIZE init parameter is greater than 0, Oracle Database Resource Manager is automatically enabled. The Resource Manager is required to take advantage of In-Memory Dynamic Scans.

#oratidbit #oraclecloud The #GlusterFS shared file system creates a high availability storage environment on Oracle Cloud Infrastructure Compute Classic instances using a distributed GlusterFS volume.

#oratidbit #OracleOEM You can upgrade your Enterprise Manager Cloud Control installation to Version 13c Release 3 (13.3.0.0) directly from 13c Rel 2 (13.2.0.0), 13c Rel 1 (13.1.0.0) or 12c Rel 5 (12.1.0.5).

#oratidbit #OracleOEM Oracle Enterprise Manager Cloud Control Version 13c Release 3 (13.3.0.0) Management Service (OMS) can communicate with Oracle Management Agent versions 13c Rel 3 (13.3.0.0), 13c Rel 2 (13.2.0.0), 13c Rel 1 (13.1.0.0) or 12c Rel 5 (12.1.0.5).

#oratidbit #OracleVM (3.4.5+) provides support for Hybrid Columnar Compression (HCC) on Oracle Database Release 18c or higher with Oracle ZFS Storage Appliance and Oracle FS1 Series Flash Storage Systems.

#oratidbit #OracleOEM includes a restricted-use license of the Oracle Database Enterprise Edition for use only with the Oracle Management Repository and these complementary repositories: AWR Warehouse, Ops Center, Real User Experience Insight, Load Testing, and Test Manager.

#oratidbit #OracleCloud Oracle Cloud Infrastructure Compute offers four shapes designed to meet a range of computing and application requirements: Standard (general purpose), DenseIO (large database and big data), GPU & High-Performance Computing (HPC).

#oratidbit #thinkautonomous #OracleATP and #OracleADW support setting a network Access Control List (ACL) to restrict access to a specific ATP database (only accepts connections from addresses specified on the ACL and rejects all other client connections).

#oratidbit #thinkautonomous #OracleATP and #OracleADW support cloning where you can choose to clone either the full database or only the database metadata.

#oratidbit #OracleASM You can upgrade Oracle ASM 11g 11.2 and later without shutting down an Oracle RAC database by performing a rolling upgrade either of individual nodes or of a set of nodes in the cluster.

#oratidbit #db19c Oracle Multimedia is desupported in Oracle Database 19c, and the implementation is removed. The ORDIM component remains in the registry and still has a VALID status. The objects and packages no longer function and raise exceptions when used.

#oratidbit #Linux Spacewalk provides a set of tools for managing the Oracle Linux software life cycle. Spacewalk helps to automate a kickstart installation, system configuration, maintenance tasks; simplifies applying patches and software updates, and auditing system security.

#oratidbit Oracle Management Cloud Log Analytics is a unified, integrated cloud solution to monitor, aggregate, index, analyze, search, explore, and correlate all log data from applications and system infrastructure.

#oratidbit ALL_TRIGGERS_AE, USER_TRIGGERS_AE and DBA_TRIGGERS_AE are new views in #db19c that describe triggers on tables across all editions.

#oratidbit DBA_AUTO_INDEX_CONFIG displays the current configuration parameter settings for automatic indexing in #db19c. Set automatic indexing configuration parameters by using the DBMS_AUTO_INDEX.CONFIGURE procedure.

#oratidbit DBA_AUTO_STAT_EXECUTIONS in #db19c displays information about automatic optimizer statistics collection tasks, which are executed by the automated maintenance tasks infrastructure (known as AutoTask).

#oratidbit The CLUSTER_DATABASE_INSTANCES parameter is deprecated in #db19c. Starting with Oracle Database release 19c, version 19.1, the number of configurable Oracle RAC instances is derived from Oracle Clusterware.