“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in July 2020. I hope you find these helpful to learn something new or to remind you of its existence and use.
| #OrclDB #db20c Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All passwords in 20c password files are case-sensitive. |
| #OraTidbit #OrclDB Oracle Blockchain tables are append-only tables in which only insert operations are allowed. Deleting rows is either prohibited or restricted based on time. |
| #OraTidbit #OrclDB #db20c allows an expression when setting the value of an initialization parameter. This allows us to optimize the values set in initialization parameters when they depend on environmental characteristics, such as system configurations, run-time decisions, or the values of other parameters by using expressions. |
| #OraTidbit #AutonomousDB With Autonomous Data Guard, the standby database is created in the same region as the primary database. If the region has multiple Availability Domains, the standby database is provisioned in a different availability domain than the primary database. |
| #OraTidbit #AutonomousDB July 2020 Feature: You can create database links from an Autonomous Database to an Oracle Database Gateway to access Non-Oracle databases. |
| #OraTidbit #GoldenGate Oracle GoldenGate Monitor is a real-time, Web-based monitoring console that delivers an at-a-glance, graphical view of all of the Oracle GoldenGate instances and their associated databases within your enterprise. |
| #OraTidbit #OraleCloud #DataSafe is a unified control center for managing database security in the Oracle Cloud. Data Safe provides an integrated set of features enabling users to understand the sensitivity, |
| evaluate risks, mask, implement security controls, assess user security, monitor user activity, and address data security compliance requirements. |
| #OraTidbit #SE#db19c Oracle Database Standard Edition High Availability (available from 19.7) provides cluster-based failover for single-instance Standard Edition Oracle Databases using Oracle Clusterware. |
| #OraTidbit (from the Oracle database licensing doc) Oracle Automatic Storage Management (Oracle ASM) is free to use with all Oracle databases and Oracle ACFS file systems (including Oracle Standard Edition). |
| #OraTidbit Oracle Enterprise Data Quality (EDQ) provides a comprehensive data quality management environment that is used to understand, improve, protect, and govern data quality. EDQ facilitates best practice master data management, data integration, business intelligence, and data migration initiatives. |
| #OraTidbit #OracleCloud #DBaaS provisioning has two options. Fast provisioning includes the Preview Version (currently 20c) and uses Logical Volume Manager (not ASM) for storage. Standard provisioning uses Automatic Storage Management and includes versions 11.2 to 19c. |
| #OraTidbit #MachineLearning The OML4SQL API consists of Machine Learning extensions to Oracle SQL. The #MLPL/SQL packages are DBMS_DATA_MINING, DBMS_DATA_MINING_TRANSFORM, DBMS_PREDICTIVE_ANALYTICS. |
| #OraTidbit #AutonomousDB #OrclAPEX Autonomous Database 19c includes Oracle Application Express Release 20.1. If your Autonomous Database instance is Database 18c, to use APEX 20.1 you must upgrade to Oracle Database 19c. APEX is automatically upgraded to APEX 20.1. |
| #OraTidbit #db20c Oracle Data Pump supports adding, changing, and eliminating table compression. Oracle Database 20c introduces a new TRANSFORM parameter clause, INDEX_COMPRESSION_CLAUSE. This clause enables you to control whether index compression is performed during import. |
| #OraTidbit #db20c #AutonomousDB Starting with Oracle Database 20c, Oracle Data Pump can perform exports from Oracle Autonomous Database into dump files in a cloud object-store. |
| #OraTidbit #MachineLearning #ML Oracle Machine Learning Notebooks is an Apache Zeppelin-based collaborative web-based interface that provides a development environment to create data mining notebooks where you can perform data exploration and visualizations, data preparation and machine learning. |
| #OraTidbit #MachineLearning #ML Oracle Machine Learning in the #AutonomousDB includes #OpenSource components Apache Zeppelin, Mockito, and JavaScript Extension Toolkit. |
| #OraTidbit #AutonomousDB You can configure Autonomous Database to authenticate and authorize Microsoft Active Directory users. The integration of Autonomous Database with Centrally Managed Users (CMU) provides integration with Microsoft Active Directory. CMU with Active Directory works by mapping Oracle database users and roles to Microsoft Active Directory users and groups. |