Category: TidBits

Posted on

Oracle Tidbits: August 2021 #OraTidbit

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

#OraTidbit #NewFeature #db19c #db21c You can use the -switchGridHome option with gridSetup. sh to switch from one Oracle Grid Infrastructure home to another. This #db21c feature is available from 19.9.
#OraTidbit #NewFeature #db19c #db21c To securely capture and replicate individual pluggable database (PDB) changes to Oracle Autonomous Database, you can now use Oracle GoldenGate to provide per-PDB capture. This #db21c feature is available from 19.10.
#OraTidbit #NewFeature #db19c #db21c You can create SQL Macros (SQM) to factor out common SQL expressions and statements into reusable, parameterized constructs that can be used in other SQL statements. This #db21c feature is available from 19.7.
#OraTidbit #NewFeature #db19c #db21c Blockchain tables are append-only tables in which only insert operations are allowed. Rows in a blockchain table are made tamper-resistant by special sequencing and chaining algorithms. Deleting rows is either prohibited or restricted based on time. This #db21c feature is available from 19.10.
#OraTidbit #NewFeature #db19c #db21c New database initialization parameters MIN_AUTH_SERVERS, MAX_AUTH_SERVERS, and DRCP_DEDICATED_OPT have been added to configure Database Resident Connection Pooling (DRCP). This #db21c feature is available from 19.10.
#OraTidbit #AutonomousDB #NewFeature When you provision or clone an Autonomous Database instance you can select a patch level to apply upcoming patches. There are two patch-level options: Regular and Early.
#OraTidbit #NewFeature #db19c #db21c Application Continuity Protection Check (ACCHK) provides guidance on the level of protection for each application that uses Application Continuity and assists you to increase protection if required. This #db21c feature is available from 19.11.
#OraTidbit #NewFeature #db19c #db21c Database In-Memory “Base Level” feature allows the use of Database In-Memory with up to a 16GB column store without having to license the option. This #db21c feature is available from 19.8.
#OraTidbit #NewFeature #db19c #db21c Gradual Database Password Rollover for Applications feature allows an application can change its database passwords without an administrator having to schedule downtime. Use the PASSWORD_ROLLOVER_TIME password profile parameter. This #db21c feature is available from 19.12.
#OraTidbit #NewFeature #db19c #db21c Immutable tables are insert-only tables in which existing data cannot be modified. Deleting rows is either prohibited or restricted based on the insertion time of the rows. This #db21c feature is available from 19.11.
#OraTidbit #AutonomousDB #New When you provision or clone an Autonomous Database instance you can select a patch level to apply upcoming patches. There are two patch-level options: Regular and Early. The Early patch level allows you to use and to test upcoming patches before they are applied to all systems.
#OraTidbit #AutonomousDB #New When you enable Autonomous Data Guard, the system creates a standby database that is continuously updated with the changes from the primary database. You can enable Autonomous Data Guard with standby in the current region, a local standby, or with standby in a different region, a cross-region standby. You can also enable Autonomous Data Guard with both a local standby and a cross-region standby.
Posted on

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