“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in October 2019. I hope you find these helpful to learn something new or to remind you of its existence and use.
| #OraTidbit #DB19c For Enterprise and Standard editions of Oracle database, if you are not licensed for Oracle Multitenant, then you may have up to 3 PDBs in a given container database at any time. |
| #OraTidbit #OracleLinux Oracle Linux 8 ships with version 8.0 of the #MySQL database. |
| #OraTidbit #OracleLinux In Oracle Linux 8, the default iptables network packet filtering framework been replaced with the nftables framework. iptables-translate, ip6tables-translate commands to convert existing iptables and ip6tables rules to their nftables equivalents. |
| #OraTidbit #OracleCloud #AutonomousDB #AlwaysFree Autonomous Database will stop the database if there is no activity for 7 consecutive days. Always Free Autonomous Database will be terminated if the database is stopped for 3 consecutive months. |
| #OraTidbit #OracleCloud #Exadata Cloud Service configuration is equipped with a fixed amount of memory, storage, and network resources. You can choose how many compute node CPU cores are enabled, to meet workload demands and only pay for the compute node resources that you need. |
| #OraTidbit #OracleCloud When an #AutonomousDB preview version is available you can provision an Autonomous Database to try new features and to test your applications before the general availability of these features. The current preview version is Oracle Database 19c. |
| #OraTidbit #DB19c In Oracle Database 19c, you can create a duplicate of an Oracle Database by using the createDuplicateDB command of Database Configuration Assistant (DBCA) in silent mode. |
| #OraTidbit #DB19c GROUP_PARTITION_TABLE_DATA, a new value for the Import DATA_OPTIONS command line parameter, changes Oracle Data Pump default behavior by importing table data in all partitions of a table as one operation. |
| #OraTidbit Oracle Trace File Analyzer in #DB19c includes REpresentational State Transfer (REST) support. The REST interface enables you to configure remote management, and automate data center operations. |
| #OraTidbit #OrclAPEX Social Sign-In authentication scheme supports authentication with Google, Facebook, and other social networks that support OpenIDConnect / OAuth2 standards. |
| #OraTidbit #OracleCloud #AutonomousDB ATP/ADW allows you to modify initialization parameters OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES, STATISTICS_LEVEL, and TIME_ZONE (only) at the session-level. |
| #OraTidbit #OracleCloud #AutonomousDB Caution: A restore operation on ATP/ADW restores the user-defined directories to the timestamp you specified for the restore; files that were created after that timestamp would be lost. |
| #OraTidbit #OracleCloud #AutonomousDB Oracle Flashback Features Supported with Autonomous Database are Flashback Drop, Query, Table, Transaction Query, and Version Query. Flashback Data Archive and Flashback Transaction are not supported. |
| #OraTidbit #OracleCloud #AutonomousDB Though CREATE DATABASE LINK statement is not available, you can use DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK to create database links in Autonomous Database (ATP/ADW). |
| #OraTidbit #OracleCloud #AutonomousDB You can create and validate external partitioned tables with the DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE and DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE statements. Query multiple data files in the Object Store as a single external table and the files can be represented as multiple logical partitions. |
| #OraTidbit #OracleCloud #AutonomousDB Enabling autoscaling allows an Autonomous Database to use up to three times more CPU and IO resources than the currently specified CPU Core Count (up to a maximum of 128 CPU cores). If your workload requires additional CPU and IO resources the database automatically uses the resources without any manual intervention required. |
| #OraTidbit #DB19c In Oracle Database 19c, you can use an external Simple Mail Transfer Protocol (SMTP) server to receive Oracle Trace File Analyzer notifications. In earlier releases, the monitored hosts have to be configured with local Sendmail or SMTP support. |
| #OraTidbit #OrclDB Oracle Advanced Queuing stores user messages in abstract storage units called queues. When Web-based business applications communicate with each other, producer applications enqueue messages and consumer applications dequeue messages. |
| #OraTidbit #oVirt is an open-source distributed virtualization solution, designed to manage enterprise infrastructure. oVirt uses the KVM hypervisor. Oracle Linux Virtualization Manager (#OLVM) is based on the oVirt opensource project. |
| #OraTidbit #Linux In Oracle Linux 8, both the GNOME session and GNOME Display Manager (GDM) use Wayland as the default display server. Wayland is a simpler replacement to the X.org server. |
| #OraTidbit Starting with Oracle Database Release 19c, invalidated PL/SQL objects run on Active Data Guard standby database can be automatically recompiled by setting the ADG_REDIRECT_DML initialization parameter to TRUE. The DDL corresponding to these PL/SQL objects is redirected to and executed on the primary database. The standby session waits until the operation is completed. |