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