Oracle Tidbits: July 2021 #OraTidbit

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

#OraTidbit #db21c The attention log is a structured, externally modifiable file that contains information about critical and highly visible database events. Use the attention log to quickly access information about critical events that need action. One attention log for each DB.
#OraTidbit V$DIAG_ALERT_EXT view shows the contents of the XML-based alert log in the Automatic Diagnostic Repository (ADR) for the current container (PDB). A message_level of 1 corresponds to critical errors that need immediate action.
#OraTidbit #db21c With dynamic cache resizing the sequence cache size is auto-tuned based on the rate of consumption of sequence values. This means the cache can automatically grow and shrink over time depending on usage while never falling below the DDL specified cache size.
#OraTidbit #db21c Read-only Oracle homes where all configuration data and log files reside outside of the read-only Oracle home are the default option for Oracle Database installations and upgrades.
#OraTidbit To securely capture and replicate individual PDB changes to Oracle Autonomous Database, in #db21c, you can use Oracle GoldenGate per-PDB capture. Provide local user credentials to connect to an individual PDB and replicate the data from just that PDB to ADB or ATP.
#OraTidbit #OracleCloud Oracle Machine Learning for Python (#OML4Py) on Autonomous Database provides a Python API to explore and prepare data, and build and deploy machine learning models using the database as a high-performance compute engine.
#OraTidbit #AutonomousDB Oracle will generate one-off patches for critical service requests filed with MOS for Oracle Autonomous DB on Dedicated Exadata Infrastructure when you and Oracle agree that the problem is critical and requires a one-off patch for immediate resolution.
#OraTidbit #orcldb Oracle Enterprise Manager Cloud Management Pack for Oracle Database helps to set up a Database Cloud and operate the Database as a Service model.
#OraTidbit #db21c Starting with Oracle Database 21c Oracle Data Pump expdp and impdp support use of object store URIs for the DUMPFILE parameter. To use this feature for exports or imports from an object store the CREDENTIAL parameter must be set.
#OraTidbit #OracleCloud The Fusion Analytics Warehouse service includes Oracle Analytics Cloud powered by Oracle Autonomous Data Warehouse. The service extracts and loads data from your Oracle Applications Cloud into an instance of Oracle Autonomous Data Warehouse.
#OraTidbit #AutonomousDB New in July 2021. You can view Autonomous Database patch information, including a list of resolved issues and components. The view DBA_CLOUD_PATCH_INFO is available to the ADMIN user.
#OraTidbit #OracleCloud Oracle Machine Learning for Python (#OML4Py) on Autonomous Database provides a Python API to explore and prepare data, and build and deploy machine learning models using the database as a high-performance compute engine.
#OraTidbit #AutonomousDB Oracle will generate one-off patches for critical service requests filed with MOS for Oracle Autonomous DB on Dedicated Exadata Infrastructure when you and Oracle agree that the problem is critical and requires a one-off patch for immediate resolution.
#OraTidbit #OracleCloud The Fusion Analytics Warehouse service includes Oracle Analytics Cloud powered by Oracle Autonomous Data Warehouse. The service extracts and loads data from your Oracle Applications Cloud into an instance of Oracle Autonomous Data Warehouse.
#OraTidbit #OracleCloud EPM Automate Cloud Service enables users to remotely perform tasks within Oracle Enterprise Performance Management Cloud environments. EPM Cloud Service Administrators can automate many repeatable tasks.
#OraTidbit #db21c Starting with Oracle Database 21c Oracle Data Pump can perform exports from Oracle Autonomous Database into dump files in a cloud object-store.
#OraTidbit July Edition