OracleNotes

Blog

  • Oracle Tidbits – March 2020 #OraTidbit

    Oracle Tidbits – March 2020 #OraTidbit

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

    #OraTidbit #Db20c Initialization parameters AUDIT_FILE_DEST, AUDIT_SYS_OPERATIONS, AUDIT_SYSLOG_LEVEL, AUDIT_TRAIL (Traditional auditing parameters) are deprecated in Oracle Database 20c.
    #OraTidbit #db20c Traditional auditing is deprecated in Database 20c. DBA Views deprecated include DBA_AUDIT_TRAIL, DBA_COMMON_AUDIT_TRAIL, DBA_FGA_AUDIT_TRAIL and so on.
    #OraTidbit #db20c Starting with Oracle Database 20c, an Oracle Database installation configures all Oracle Database homes in read-only mode by default (ORACLE_BASE_HOME and ORACLE_BASE_CONFIG are located separately from ORACLE_HOME).
    #OraTidbit #db20c The option to use Oracle Data Guard with a logical standby Database is deprecated in Database 20c. The logical standby feature and the DBA_LOGSTDBY and DBMS_LOGSTDBY SQL statements and V$LOGSTDBY views can be desupported in a future release.
    #OraTidbit #db20c Starting in Oracle Database 20c, the IGNORECASE parameter for the orapwd file is desupported. All newly created password files are case-sensitive.
    #OraTidbit #ADW #ATP Depending on the region where you provision or clone your database, Autonomous Database supports 18c or 19c or both Oracle Database versions.
    #OraTidbit #ADW #ATP By default the Autonomous database uses extended data types and the value of MAX_STRING_SIZE is set to EXTENDED. To support migration from older Oracle Databases or applications you can set MAX_STRING_SIZE to the value STANDARD by using DBMS_MAX_STRING_SIZE.MODIFY_MAX_STRING_SIZE.
    #OraTidbit #ATP #ADW Oracle Database Vault is disabled by default on Autonomous Database. To configure and enable Oracle Database Vault on Autonomous Database, use DBMS_CLOUD_MACADM.CONFIGURE_DATABASE_VAULT and DBMS_CLOUD_MACADM.ENABLE_DATABASE_VAULT.
    #OraTidbit #ATP #ADW You can create #OracleCloud Autonomous Database Dedicated Deployment on Exadata Infrastructure quarter-rack or half-rack Exadata Database Machine X7-2 or X8-2 systems.
    #OraTidbit #ATP #ADW Autonomous Database with Oracle Database 19c includes automatic index management tasks, such as creating, rebuilding, and dropping indexes based on changes in the application workload.
    #OraTidbit #db20cThe result cache in an Active Data Guard standby database is utilized to cache results of queries that were run on the physical standby database. In the case of a role transition to primary, the standby database result cache will be preserved ensuring performance for offloaded reporting and other queries continue without compromising the performance benefits of the standby result cache.
    #OraTidbit #db20c Starting with 20c, the USER_APPLICATION_ROLES data dictionary view provides a subset of roles that are available in DBA_APPLICATION_ROLES that only apply to the current user.
    #OraTidbit #db20c The SQL set operators support all keywords as defined in #ANSISQL. The new operator EXCEPT [ALL] is functionally equivalent to MINUS [ALL]. The operators MINUS and INTERSECT now support the keyword ALL.
    #OraTidbit #db20c Starting with Oracle Database 20c Oracle Data Pump can include and exclude objects in the same export or import operation.
    #OraTidbit #db20c Starting with Oracle Database 20c Oracle Data Pump can resume transportable tablespace export and import jobs that are stopped.
    #OraTidbit #db20c DbNest provides operating system resource isolation and management, file system isolation, and secure computing for PDBs. The infrastructure is implemented as a Linux-specific package that provides hierarchical containers, called nests.
    #OraTidbit #db20c The UNIFIED_AUDIT_SGA_QUEUE_SIZE initialization parameter is desupported in Oracle Database release 20c, version 20.2.
    #OraTidbit #OracleCloud If your Autonomous Database instance is on Oracle Database 18c, Oracle will automatically upgrade your instance to Oracle Database 19c. If you want to upgrade at a time of your choosing, then you can manually upgrade your database to Oracle Database 19c.
    #OraTidbit #OracleCloud The automatic upgrade of Autonomous Database 18 to 19c is a minimal downtime operation and requires up to ten (10) minutes of downtime during the maintenance window.
    #OraTidbit #DB20c The Data Guard Broker in 20c enables users to create and add a Far Sync instance to a Data Guard Broker configuration using a single command. Zero Data loss over a long distance can be achieved by using the Data Guard Far Sync standby instances.
    #OraTidbit #db20c Automatic zone maps are created and maintained for any user table without any customer intervention. Zone maps allow the pruning of blocks and partitions based on the predicates in the queries. Automatic zone maps improve the performance of any query transparently and automatically.
    #OraTidbit #db20c Oracle ASM Flex Disk Group supports Cloning a PDB in one CDB to a new PDB in a different CDB. This feature enables you to use Oracle ASM cloning for test and development cloning.

  • Oracle Tidbits – December 2019 #OraTidbit

    Oracle Tidbits – December 2019 #OraTidbit

    “Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in December 2019. December Tidbits are a repeat of the popular tidbits from 2019. I hope you find these helpful to learn something new or to remind you of its existence and use.

    #OraTidbit DBA_AUTO_STAT_EXECUTIONS view 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.
    #OraTidbit #ThinkAutonomous Though there is no Operating System access, you can create directories in Oracle Autonomous Database (ADW/ATP). CREATE DIRECTORY command creates the necessary directories and sub-directories on the OS side for you.
    #OraTidbit #ThinkAutonomous Autonomous Database (ADW/ATP) allows user directories. Since there is no OS access to ATP/ADW machines, use DBMS_CLOUD.LIST_FILES function to list files in a directory. Use DBMS_CLOUD.DELETE_FILE function to remove a file.
    #OraTidbit ORAchk/EXAchk -autostart will perform compliance checks for the most severe problems at 2 am daily, and all known problems once a week at 3 am on a Sunday.
    #OraTidbit Init parameter ADG_ACCOUNT_INFO_TRACKING controls login attempts of users on Oracle Active Data Guard standby databases. Value GLOBAL maintains a single global copy of users’ account information across all databases (primary and standby).
    #OraTidbit ORAchk, EXAchk and Trace File Analyzer (TFA) are now combined into a single installer called Autonomous Health Framework (AHF 19.3). There is no change to the command-line tools. Use Oracle Support Doc ID 2550798.1 to download AHF.
    #OraTidbit Oracle Database Personal Edition includes all of the Enterprise Edition components except Oracle RAC. Oracle PE is available on Linux and Windows platforms only and Oracle management packs cannot be used.
    #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 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 #DB19c For Enterprise and Standard editions of Oracle database, if you are not licensed for Oracle Multitenant, then you may have up to 3 PDBs in a given container database at any time.
    #oratidbit Using Fleet Patching and Provisioning to patch Oracle Restart automates and standardizes the processes that are implemented in Oracle RAC database installations. It also reduces operational demands and risks, especially for large numbers of Oracle Restart deployments.
    #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 #DB19c In Oracle Database 19c, you can create a duplicate of an Oracle Database by using the createDuplicateDB command of Database Configuration Assistant (DBCA) in silent mode.
    #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 #OrclDB Global Data Services is a highly effective solution for automatic workload management across a set of replicated databases. Data Guard, GoldenGate, or any replication technology, can be used to sync the databases. Requires the Oracle Active Data Guard license.
    #OraTidbit The I/O calibration feature of #OrclDB is using the DBMS_RESOURCE_MANAGER.CALIBRATE_IO procedure- issues random I/O intensive read-only I/Os to the database files to determine the maximum IOPS and MBPS that can be sustained by the storage subsystem.
    #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 Starting with Oracle Database Release 19c, invalidated PL/SQL objects run on Active Data Guard standby database can be automatically recompiled by setting the ADG_REDIRECT_DML initialization parameter to TRUE.
    #OraTidbit #DB19c Real-Time Statistics feature is when a DML operation is currently modifying a table, Oracle Database dynamically computes values for the most essential statistics. The NO_GATHER_OPTIMIZER_STATISTICS hint prevents the collection of real-time statistics.