OracleNotes

Blog

  • Oracle Tidbits – March 2018 #oratidbit

    Oracle Tidbits – March 2018 #oratidbit

    “Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in March 2018. You will also see these tidbits on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use.

    #oratidbit #db18c SQL*Plus Feature: The SET LINESIZE command has a WINDOW option to automatically change the linesize and pagesize for the formatted output according to the width and height of the screen.
    #oratidbit #db18c SQL*Plus Feature: SQL_ID option for the SET FEEDBACK command displays the sql_id for the currently executed SQL or PL/SQL statements. The sql_id will be assigned to the predefined variable _SQL_ID.
    #oratidbit #db18c Instead of terminating a session, you can cancel a high-load SQL statement in a session. When you cancel a DML statement, the statement is rolled back. Usie the ALTER SYSTEM CANCEL SQL statement.
    #oratidbit #db18c An Oracle home can be read-only, thus preventing creation or modification of files inside the Oracle home directory ORACLE_HOME. A read-only Oracle home can be used as a software image that can be shared across multiple database servers.
    #oratidbit #db18c The default location for Oracle Database password file (ORAPWD) is ORACLE_BASE directory instead of ORACLE_HOME directory. This change supports read-only Oracle homes.
    #oratidbit #db18c When OPTIMIZER_IGNORE_HINTS parameter is set to TRUE, the optimizer ignores embedded hints.
    #oratidbit #db18c When OPTIMIZER_IGNORE_PARALLEL_HINTS parameter is set to TRUE, the optimizer ignores embedded parallel hints.
    #oratidbit #db18c To change the starting point of a sequence, use the RESTART clause to restart the sequence from the specified value. The new value specified must be between the MINVALUE and MAXVALUE parameter values.
    #oratidbit #db18c New init parameter FORWARD_LISTENER specifies the name of a listener to which a connection must be forwarded by an existing set of remote listeners.
    #oratidbit #db18c Private temporary tables are temporary database objects that are automatically dropped at the end of a transaction or a session. A private temporary table is stored in memory and is visible only to the session that created it.
    #oratidbit #db18c Init parameters STANDBY_ARCHIVE_DEST and UTL_FILE_DIR are desupported in #orcldb 18.1.
    #oratidbit Oracle Database Cloud Backup Module is an SBT interface integrated with RMAN. Database backups are created using RMAN and the Cloud Backup Module sends these backups, to Oracle Database Backup Service for offsite storage.
    #oratidbit #db18c You can create both global temporary tables and private temporary tables on an Active Data Guard instance. DML and DDL operations are allowed on temporary tables on Oracle Active Data Guard instances.
    #oratidbit #db18c A new view V$DATAGUARD_PROCESS provides information to verify that redo is being transmitted from the primary database and applied to the standby database.
    #oratidbit The DROP TABLESPACE INCLUDING CONTENTS AND DATAFILES SQL statement on the primary database will delete the data files on (both the primary and) standby databases, if the STANDBY_FILE_MANAGEMENT init parameter is set to AUTO.
    #oratidbit In order to use the EM Express Performance Hub ($ORACLE_HOME/rdbms/admin/perfhubrpt.sql), need the Diagnostics Pack license. To view SQL Monitor data in Performance Hub, need the Tuning Pack license.
    #oratidbit #db18c Oracle Database software is available as an image file for download and installation. Extract the image software into the directory where the Oracle home to be located, and then run the runInstaller script to start the Oracle Database installation.
    #oratidbit #db18c Starting with Oracle Database 18c, you can use the Oracle Preinstallation RPM and the rpm -ivh command to perform an RPM-based Oracle Database installation. RPM-based installation is supported for single-instance Oracle Database on Oracle Linux systems only.
    #oratidbit #orcldb Deprecated features are no longer being enhanced, but are still supported. Desupported features are no longer supported by fixing bugs related to that feature. Oracle can choose to remove the code required to use the feature.
    #oratidbit #db18c Oracle Database 18c is the terminal release for support of the Oracle Streams. Oracle Streams will be desupported from Oracle Database 19 onwards and was deprecated in Oracle Database 12c (12.1).
    #ortidbit #db18c Support for the initialization parameter STANDBY_ARCHIVE_DEST is removed in Oracle Database 18c. For LOCAL and REMOTE archiving, use LOG_ARCHIVE_DEST_n.

  • Oracle Tidbits – February 2018 #oratidbit

    “Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in February 2018. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use.

     

    #oratidbit #oraclecloud Oracle Database Backup Cloud Service includes two Oracle Database optimizations – RMAN backup encryption and All RMAN backup compression algorithms.
    #oratidbit #oraclecloud Oracle Database Backup Cloud Service is used to store Oracle Database backups only. To store other types of data, use Oracle Storage Cloud Service.
    #oratidbit #oraclecloud Oracle DBaaS Monitor provides monitoring and management of the Oracle database and listener on Oracle Database Cloud Service. To use the Open DBaaS Monitor Console menu item, you must unblock port 443.
    #oratidbit #oraclecloud Deployments that host single-instance databases include the cleandblogs cronjob script to archive and purge a variety of log and diagnostic files. Config file cleandblogs.cfg determines how long to retain each kind of log or diagnostic file.
    #oratidbit #oraclecloud Oracle Database Cloud Service Data Guard configuration can be administered using the dbaascli utility. “dbaascli dataguard” command options include “status”, “failover”, “switchover”, “reinstate”.
    #oratidbit #oraclecloud Use the “dbpatchmsm” utility to apply Linux OS security patches to compute nodes associated with database deployments hosting a single-instance database.
    #oratidbit #oraclecloud Use the “dbpatchm” subcommand of the “dbaascli” utility to apply a patch to a database deployment hosting a single-instance database.
    #oratidbit The DBMS_SQLTUNE package is the interface for tuning SQL on demand. The DBMS_AUTO_SQLTUNE package provides the interface for SQL Tuning Advisor run as an automated task.
    #oratidbit The automated system task SYS_AUTO_SQL_TUNING_TASK automatically chooses a set of high-load SQL from AWR and runs SQL Tuning Advisor. The automated task performs the same comprehensive analysis as any other SQL Tuning task.
    #oratidbit Oracle Database SQL Monitor will only monitor a SQL statement if the execution plan has less than 300 lines. Set the underscore parameter _sqlmon_max_planlines to increase this limit.
    #oratidbit OPTIMIZER_DYNAMIC_SAMPLING value when set to 11, the optimizer will automatically determine which statements
    would benefit from dynamic statistics, even if all of the objects have statistics.
    #oratidbit The SQL Plan Management (SPM) Evolve Advisor is an AutoTask (SYS_AUTO_SPM_EVOLVE_TASK), which operates during the nightly maintenance window and automatically runs the evolve process for unaccepted plans in SPM.
    #oratidbit #db18c Zero-Downtime Database Upgrade automates all of the steps required for a Database upgrade. It can minimize or even eliminate application downtime during the upgrade process.
    #oratidbit #db18c Passwords in database links are encrypted in 18c. Oracle Data Pump handles the export and import of these passwords. This prevents an intruder from decrypting an encrypted database link password.
    #oratidbit #db18c A refreshable clone PDB is an incrementally updated copy of a master PDB. The new switchover feature enables a change of roles between master and clone PDBs for planned or unplanned switchover.
    #oratidbit #db18c When you perform the export or import operation of a database, the unified audit trail is automatically included in the Data Pump dump files.
    #oratidbit #db18c ASM database cloning provides cloning of Multitenant databases (PDBs) by leveraging ASM redundancy. Flex Disk Groups can provide up to five redundant copies, one or more of the copies can be split off to provide a near instantaneous replica.
    #oratidbit $db18c Drop a file group and its associated files (drop including content) using the CASCADE keyword with ALTER DISKGROUP … DROP FILEGROUP SQL statement.
    #oratidbit #ORAchk new version 12.2.0.1.4 works on Windows! It is rewritten in Python, no longer has the need for Cygwin on Windows. ORAchk just needs Python 2.7 software and libraries.