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.