Tag: #db20c

Posted on

Oracle TidBits – July 2020 #OraTidBit

“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.
Posted on

Oracle Tidbits – March 2020 #OraTidbit

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

#OraTidbit #Db20c Initialization parameters AUDIT_FILE_DEST, AUDIT_SYS_OPERATIONS, AUDIT_SYSLOG_LEVEL, AUDIT_TRAIL (Traditional auditing parameters) are deprecated in Oracle Database 20c.
#OraTidbit #db20c Traditional auditing is deprecated in Database 20c. DBA Views deprecated include DBA_AUDIT_TRAIL, DBA_COMMON_AUDIT_TRAIL, DBA_FGA_AUDIT_TRAIL and so on.
#OraTidbit #db20c Starting with Oracle Database 20c, an Oracle Database installation configures all Oracle Database homes in read-only mode by default (ORACLE_BASE_HOME and ORACLE_BASE_CONFIG are located separately from ORACLE_HOME).
#OraTidbit #db20c The option to use Oracle Data Guard with a logical standby Database is deprecated in Database 20c. The logical standby feature and the DBA_LOGSTDBY and DBMS_LOGSTDBY SQL statements and V$LOGSTDBY views can be desupported in a future release.
#OraTidbit #db20c Starting in Oracle Database 20c, the IGNORECASE parameter for the orapwd file is desupported. All newly created password files are case-sensitive.
#OraTidbit #ADW #ATP Depending on the region where you provision or clone your database, Autonomous Database supports 18c or 19c or both Oracle Database versions.
#OraTidbit #ADW #ATP By default the Autonomous database uses extended data types and the value of MAX_STRING_SIZE is set to EXTENDED. To support migration from older Oracle Databases or applications you can set MAX_STRING_SIZE to the value STANDARD by using DBMS_MAX_STRING_SIZE.MODIFY_MAX_STRING_SIZE.
#OraTidbit #ATP #ADW Oracle Database Vault is disabled by default on Autonomous Database. To configure and enable Oracle Database Vault on Autonomous Database, use DBMS_CLOUD_MACADM.CONFIGURE_DATABASE_VAULT and DBMS_CLOUD_MACADM.ENABLE_DATABASE_VAULT.
#OraTidbit #ATP #ADW You can create #OracleCloud Autonomous Database Dedicated Deployment on Exadata Infrastructure quarter-rack or half-rack Exadata Database Machine X7-2 or X8-2 systems.
#OraTidbit #ATP #ADW Autonomous Database with Oracle Database 19c includes automatic index management tasks, such as creating, rebuilding, and dropping indexes based on changes in the application workload.
#OraTidbit #db20cThe result cache in an Active Data Guard standby database is utilized to cache results of queries that were run on the physical standby database. In the case of a role transition to primary, the standby database result cache will be preserved ensuring performance for offloaded reporting and other queries continue without compromising the performance benefits of the standby result cache.
#OraTidbit #db20c Starting with 20c, the USER_APPLICATION_ROLES data dictionary view provides a subset of roles that are available in DBA_APPLICATION_ROLES that only apply to the current user.
#OraTidbit #db20c The SQL set operators support all keywords as defined in #ANSISQL. The new operator EXCEPT [ALL] is functionally equivalent to MINUS [ALL]. The operators MINUS and INTERSECT now support the keyword ALL.
#OraTidbit #db20c Starting with Oracle Database 20c Oracle Data Pump can include and exclude objects in the same export or import operation.
#OraTidbit #db20c Starting with Oracle Database 20c Oracle Data Pump can resume transportable tablespace export and import jobs that are stopped.
#OraTidbit #db20c DbNest provides operating system resource isolation and management, file system isolation, and secure computing for PDBs. The infrastructure is implemented as a Linux-specific package that provides hierarchical containers, called nests.
#OraTidbit #db20c The UNIFIED_AUDIT_SGA_QUEUE_SIZE initialization parameter is desupported in Oracle Database release 20c, version 20.2.
#OraTidbit #OracleCloud If your Autonomous Database instance is on Oracle Database 18c, Oracle will automatically upgrade your instance to Oracle Database 19c. If you want to upgrade at a time of your choosing, then you can manually upgrade your database to Oracle Database 19c.
#OraTidbit #OracleCloud The automatic upgrade of Autonomous Database 18 to 19c is a minimal downtime operation and requires up to ten (10) minutes of downtime during the maintenance window.
#OraTidbit #DB20c The Data Guard Broker in 20c enables users to create and add a Far Sync instance to a Data Guard Broker configuration using a single command. Zero Data loss over a long distance can be achieved by using the Data Guard Far Sync standby instances.
#OraTidbit #db20c Automatic zone maps are created and maintained for any user table without any customer intervention. Zone maps allow the pruning of blocks and partitions based on the predicates in the queries. Automatic zone maps improve the performance of any query transparently and automatically.
#OraTidbit #db20c Oracle ASM Flex Disk Group supports Cloning a PDB in one CDB to a new PDB in a different CDB. This feature enables you to use Oracle ASM cloning for test and development cloning.