Tag: oratidbit

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

#oratidbit #db19c You can tune the Oracle Data Guard automatic outage resolution using DATA_GUARD_MAX_IO_TIME and DATA_GUARD_MAX_LONGIO_TIME parameters.

#oratidbit #db18c ASM database cloning provides cloning of Multitenant databases (PDBs). This feature works by leveraging ASM redundancy.

#oratidbit Passwords in database links are encrypted in #db18c. Oracle Data Pump handles the export and import of these passwords. Import operations from older versions and export operations to older versions can still be used.

#oratidbit #oraclecloud #thinkautonomous When using the OCI Console, starting on 3/7/2019, all ADW and ATP databases will appear in a single list view as Autonomous Databases with a new workload type column showing the type of Autonomous Database, namely “Data Warehouse” or “Transaction Processing”.

#oratidbit #db19c Pluggable databases (PDBs) are supported as a target database in RMAN Recovery Catalog and a virtual private catalog (VPC) user can be used to more granularly control permissions to perform backup and restore operations at a PDB level.

#oratidbit #orcldb Starting with 19c, the Oracle Database Client software is available as an image file for download and installation. Extract the image software into the Oracle Home directory and run the runInstaller script.

#oratidbit #db19c Starting with Oracle Grid Infrastructure 19c, the Oracle Grid Infrastructure installation wizard (gridSetup.sh) enables you to perform a dry-run mode upgrade to check your system’s upgrade readiness.

#oratidbit #db19c Data Pump Import supports wildcard dump file names for URL-based dump files maintained in cloud object stores. Note that the wildcard character can only be specified in the file-name component of the URL.

#oratidbit #db19c Starting with #db12c, ADDM is enabled by default in the root container of a multitenant container database (CDB). Starting with #db19c, you can also use ADDM in a pluggable database (PDB). AWR data on a PDB cannot be accessed from the CDB root.

#oratidbit #db19c ADDM does not work in a PDB by default, because automatic AWR snapshots are disabled by default in a PDB. To use ADDM in a PDB, enable automatic AWR snapshots in the PDB.

#oratidbit The #db18c resource manager directive PQ_TIMEOUT_ACTION enables the database administrator to specify the action to take on a parallel SQL statement that is timed out of the parallel SQL statement queue.

#oratidbit #nothingnew The UNION and UNION ALL statements can run several branches concurrently instead of working on them one-by-one – speeds up processing time and leads to better resource utilization.

#oratidbit #db19c 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. Good for developers.

#oratidbit #db19c SQL statements that are terminated by Oracle Database Resource Manager due to their excessive consumption of CPU and I/O resources can be automatically quarantined. The execution plans associated with the terminated SQL statements are quarantined to prevent them from being executed again.

#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 #db12cR2 Parameter AUTOTASK_MAX_ACTIVE_PDBS specifies the maximum number of PDBs that can schedule automated maintenance tasks at the same time. By default, two PDBs and the CDB root can run tasks at the same time during a maintenance window.

#oratidbit #db12cR2 Parameter AWR_PDB_AUTOFLUSH_ENABLED specifies whether to enable or disable automatic Automatic Workload Repository (AWR) snapshots for all the PDBs in a CDB or for individual PDBs in a CDB. By default, automatic AWR snapshots are disabled for all the PDBs.

#oratidbit #nothingnew Unusable indexes and index partitions do not consume space in the database because they become segmentless. When you make an existing index unusable, its index segment is dropped.

#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 #nothingnew Database Smart Flash Cache feature (on #Solaris and #OracleLinux) is a transparent extension of the database buffer cache using solid state device (SSD) technology. The SSD acts as a Level 2 cache to the (Level 1) SGA.

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

#oratidbit In Oracle Database 18c, RMAN can recover a standby database using “FROM SERVICE” to perform an Active Data Guard synchronization and refresh the standby DB with a single RMAN command: RECOVER STANDBY DATABASE FROM SERVICE primary_db.

#oratidbit The LISTAGG aggregate function in #db19c supports duplicate elimination by using the DISTINCT keyword. With the new DISTINCT keyword, duplicate values can be removed from the specified expression before concatenation into a single string.

#oratidbit #db19c contains a keenly awaited fix to the optimizer costing for for ANSI fetch first/offset queries. Now they can take advantage of an index scan + stopkey as per the older style order by/rownum syntax.

#oratidbit #db18c New routine validate_character_encoding in UTL_I18N allow for validation of characters within a particular characterset.

#oratidbit #db18c The TREAT … as JSON operator provides a way to inform the database that the content of a VARCHAR2, BLOB, CLOB should be treated as containing JSON. This enables the ability to use “Simplified Syntax” on db objects that do not have an “IS JSON” constraint.

#oratidbit #db18c A scalable sequence adds a 6 digit prefix to the sequence. The prefix is made up of a 3 digit instance offset concatenated to a 3 digit session offset.

#oratidbit #thinkautonomous Oracle GoldenGate On Premises releases 12.3.0.1.2 and later are certified with Oracle Autonomous Cloud for remote delivery using the non-integrated Replicats. You can’t set up Autonomous Cloud database as a source for GoldenGate On Premises.

#oratidbit Oracle Enterprise Manager Cloud Control releases 13.1 and 13.2 support integration with Oracle ORAchk and Oracle EXAchk through the OEM ORAchk Healthchecks Plug-in.

#oratidbit Each database PSU/RU contains the latest Oracle ORAchk version available at time of creation. When a database PSU is applied, the ORAchk zip version contained is staged in $ORACLE_HOME/suptools.

#oratidbit Oracle ORAchk and Oracle EXAchk include full REST support allowing invocation and query over HTTPS. To enable REST, setup ORDS and then provide a user password when prompted “orachk -ordssetup”.

#oratidbit #db19c Most of the Oracle Database supplied user accounts, except SYS and sample schemas are schema only accounts in 19c, these accounts are created without passwords. This prevents malicious users from logging into these accounts.

#oratidbit #db19c The automatic indexing feature automates index management tasks, such as creating, rebuilding, and dropping indexes in an Oracle database based on changes in the application workload.

#oratidbit In #db19c you can configure quarantine for execution plans for SQL statements that are terminated by the Resource Manager due to their excessive consumption of system resources, such as CPU and I/O. The quarantined execution plans are not allowed to run again.

#oratidbit #db19c. A hybrid partitioned table is a partitioned table in which some partitions reside in the database and some partitions reside outside the database in external files, such as operating system files or Hadoop Distributed File System (HDFS) files.

#oratidbit #db19c The new SQL Repair Advisor function DBMS_SQLDIAG.SQL_DIAGNOSE_AND_REPAIR creates a diagnostic task, executes it, and accepts SQL patch recommendation for a SQL statement that is generating a critical error.

#oratidbit #db19c The script catpcat.sql runs the scripts catalog.sql and catproc.sql with parallel processes, thus improving the performance of building the data dictionary manually.

#oratidbit The #db19c view DBA_REGISTRY_BACKPORTS shows the bugs that have been fixed by the patches applied to the database. Only the bug fixes that have modified the data dictionary are displayed in this view.

#oratidbit #db19c The LISTAGG aggregate function supports duplicate elimination by using the new DISTINCT keyword.

#oratidbit #db19c The standby database is flashed back automatically when Flashback Database is performed on the primary database. If you do not want the standby to automatically follow the primary, either keep the standby database in OPEN mode or stop the MRP process on the standby.

#oratidbit #db19c The ALTER SYSTEM clause FLUSH PASSWORDFILE_METADATA_CACHE refreshes the metadata cache with the latest details of the database password file. The latest details of the database password file can be retrieved by querying the V$PASSWORDFILE_INFO view.