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.