OracleNotes

Category: TidBits

  • Oracle Tidbits: May 2019 #oratidbit

    Oracle Tidbits: May 2019 #oratidbit

    “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.
  • Oracle Tidbits: April 2019 #oratidbit

    Oracle Tidbits: April 2019 #oratidbit

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

    #oratidbit #db18c Automatically maintain standby databases when performing PDB plugins by using initialization parameter STANDBY_PDB_SOURCE_FILE_DIRECTORY (directory location where files of a PDB being used for repeated plugins are stored).
    #oratidbit #db18c Automatically maintain Active Data Guard standby databases when performing PDB remote clones by using initialization parameter STANDBY_PDB_SOURCE_FILE_DBLINK (name of the db link used to clone the PDB at the primary).
    #oratidbit #db19c The SET FAST_START FAILOVER TARGET command enables to dynamically change the fast-start failover target to the named standby database without disabling fast-start failover or modifying the fast start failover list.
    #oratidbit #db19c The High-Frequency Automatic Optimizer Statistics Collection feature collects statistics frequently (default 15 minutes) for tables where data changes frequently. The lightweight task gathers only stale statistics.
    #oratidbit #db19c Oracle Trace File Analyzer integrates with Oracle Cluster Health Advisor. When Oracle Cluster Health Advisor detects a problem event, Oracle Trace File Analyzer automatically triggers the relevant diagnostic collection and sends an email notification.
    #oratidbit #db19c Heard at #CTX19: #OracleEBS will support Oracle Database 19c container database architecture, with one PDB.
    #oratidbit Heard at #CTX19: #OracleEBS uses (deprecated) UTL_FILE_DIR parameter to read and write files. Starting Database 19c, UTL_FILE_DIR is desupported. When you upgrade EBS database to 19c, an equivalent directory object will be created for each UTL_FILE_DIR entry.
    #oratidbit #db19c You can use ADDM to analyze AWR data stored inside the PDB through an AWR snapshot taken inside the PDB. Automatic ADDM of a PDB is disabled by default. You can enable it for a PDB by enabling automatic AWR snapshots.
    #oratidbit #db19c In Oracle Grid Infrastructure, use Fleet Patching and Provisioning to automate relocation of a PDB from one CDB to another. Automated relocation enables individual PDBs to be patched more quickly without exposing other PDBs to the changes in the patch.
    #oratidbit #OracleCloud The Oracle Cloud Infrastructure Audit service automatically records calls to all supported OCI public API endpoints as log events. Each log event includes a header ID, target resources, time stamp of the recorded event, request parameters, and response parameters.
    #oratidbit #ADW #OracleCloud DATA_PUMP_DIR is the only directory you can specify as the directory argument for data pump jobs, and it is predefined. Move the dump files from the directory DATA_PUMP_DIR to Cloud Object Store by calling DBMS_CLOUD.PUT_OBJECT.
    #oratidbit #ADW #OracleCloud To ensure the security and the performance of Autonomous Data Warehouse, LONG and LONG RAW data types are not supported (also media types and spatial types).
    #oratidbit #db19c In a multitenant database, you can use Oracle Database Vault to block common users (infrastructure DBAs, for example) from accessing local data in pluggable databases (PDBs).
    #oratidbit #exadata Secure Eraser (V2 or higher) solution securely erases all data on both database servers and storage servers, and resets InfiniBand switches, Ethernet switches, and power distribution units back to factory default. Use when you are removing an Oracle Exadata Database Machine from your environment to securely erase all the information on the servers.
    #oratidbit #apex For testing and production instances, Oracle Application Express supports the ability to install a runtime version. This minimizes the installed footprint and privileges.
    #oratidbit #orcldb #db19c Real-Time SQL Monitoring for Developers: Database users without SELECT_CATALOG_ROLE can generate and view SQL Monitor reports for their own SQL statements, including the execution plans and performance metrics.
    #oratidbit #orcldb Trace File Analyzer (TFA) feature: Use “tfactl blackout” command to suppress automatic diagnostic collections. If you set blackout for a target, then TFA stops automatic diagnostic collections if it finds events in the alert logs while scanning.
    #oratidbit #orcldb Trace File Analyzer (TFA) feature: “tfactl blackout” command has several options to supress diagnostic collection at a granular level. Use -targettype, -target, -events, -local.