Tag: oratidbit

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

#OraTidbit You can create Autonomous Database dedicated deployments. The order of deployment is Autonomous Exadata Infrastructure (#Exadata), Autonomous Container Database (CDB), Autonomous Transaction Processing Database (PDB).

#OraTidbit For dedicated deployment of Autonomous Database, you can choose to use Release Update (RU) or Release Update Revision (RUR) for your Autonomous Container Database maintenance. You have the option to skip maintenance runs for up to 2 consecutive quarters.

#oratidbit #db19c The COLOCATION_TAG parameter is an alphanumeric string that you can use with the CONNECT_DATA parameter of the TNS connect string. Clients with the same COLOCATION_TAG are routed to the same database instance in a RAC environment.

#oratidbit #ThinkAutonomous #OracleCloud In an Autonomous Database (ATP) dedicated deployment, you can create up to four Autonomous Container Databases (CDB) with up to 200 Autonomous Databases (PDBs) in each CDB.

#oratidbit #ThinkAutonomous #OracleCloud In an Autonomous Database (ATP) dedicated deployment, the Fleet Administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.

#oratidbit Use the -dbconfig command when Oracle ORAchk is not able to discover ORACLE_HOME or the name of the Oracle Database and you have multiple ORACLE_HOMEs in a system and each home is running multiple Oracle Databases.

#oratidbit #OracleCloud Infrastructure Bare metal DB systems consist of a single server running Oracle Linux 6.8, with locally attached NVMe storage. Each DB system can have multiple database homes, which can be different versions. Each database home can have only one database.

#oratidbit #AutonomousDatabase #ThinkAutonomous Oracle Autonomous Database (ATP & ADW) includes the Performance Hub to view real-time and historical performance data.

#oratidbit #db19c To enable automatic indexing, set the AUTO_IMPLEMENT_INDEXES initialization parameter to the Oracle database release number, say 19.3. You can disable automatic indexing by setting the AUTO_IMPLEMENT_INDEXES initialization parameter to NONE.

#oratidbit #db19c #OrclEM Beginning with Oracle Enterprise Manager 13.3 Plugin Update (PG) Release, Database version 19c is supported as both a Repository Database and a Managed Target Database.

#OraTidbit #ThinkAutonomous #AutonomousDatabase allows data file resize, autoextend on/off using ALTER DATABASE or ALTER PLUGGABLE DATABASE commands. ALTER TABLESPACE and CREATE TABLESPACE commands are not allowed.

#OraTidbit #ThinkAutonomous #AutonomousDatabase You can limit the storage allocated to a user by specifying a tablespace quota using the DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA procedure.

#OraTidbit The continuous_mine option for the DBMS_LOGMNR.START_LOGMNR package is desupported in Oracle Database 19c, and is no longer available. The CONTINUOUS_MINE functionality of the LogMiner package is obsolete.

#OraTidbit In the license included model of #AWS RDS Oracle service, you contact AWS Premium Support for both Amazon RDS and Oracle Database specific service requests.

#OraTidbit Autonomous Database (ATP/ADW) supports native authentication with #OracleCloud Infrastructure Object Store. Using native authentication you can use key-based authentication to access the Object Store (instead of using a username and password).

#oratidbit #OracleRAC Starting with 19c, the Grid Infrastructure Management Repository (GIMR) is optional for new installations of Oracle Standalone Cluster. No GIMR reduces functionality in CHAG, CHACTL, TFA.

#ortidbit Oracle Active Data Guard DML Redirect feature enables DML on the standby to be redirected to the primary to allow infrequent writes to run on the ADG standby database. This feature is not available on the authorized cloud environments (#AWS/#Azure).

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

#oratidbit #db18c Automatically maintain standby databases when performing PDB plugins by using initialization parameter STANDBY_PDB_SOURCE_FILE_DIRECTORY (directory location where files of a PDB being used for repeated plugins are stored).

#oratidbit #db18c Automatically maintain Active Data Guard standby databases when performing PDB remote clones by using initialization parameter STANDBY_PDB_SOURCE_FILE_DBLINK (name of the db link used to clone the PDB at the primary).

#oratidbit #db19c The SET FAST_START FAILOVER TARGET command enables to dynamically change the fast-start failover target to the named standby database without disabling fast-start failover or modifying the fast start failover list.

#oratidbit #db19c The High-Frequency Automatic Optimizer Statistics Collection feature collects statistics frequently (default 15 minutes) for tables where data changes frequently. The lightweight task gathers only stale statistics.

#oratidbit #db19c Oracle Trace File Analyzer integrates with Oracle Cluster Health Advisor. When Oracle Cluster Health Advisor detects a problem event, Oracle Trace File Analyzer automatically triggers the relevant diagnostic collection and sends an email notification.

#oratidbit #db19c Heard at #CTX19: #OracleEBS will support Oracle Database 19c container database architecture, with one PDB.

#oratidbit Heard at #CTX19: #OracleEBS uses (deprecated) UTL_FILE_DIR parameter to read and write files. Starting Database 19c, UTL_FILE_DIR is desupported. When you upgrade EBS database to 19c, an equivalent directory object will be created for each UTL_FILE_DIR entry.

#oratidbit #db19c You can use ADDM to analyze AWR data stored inside the PDB through an AWR snapshot taken inside the PDB. Automatic ADDM of a PDB is disabled by default. You can enable it for a PDB by enabling automatic AWR snapshots.

#oratidbit #db19c In Oracle Grid Infrastructure, use Fleet Patching and Provisioning to automate relocation of a PDB from one CDB to another. Automated relocation enables individual PDBs to be patched more quickly without exposing other PDBs to the changes in the patch.

#oratidbit #OracleCloud The Oracle Cloud Infrastructure Audit service automatically records calls to all supported OCI public API endpoints as log events. Each log event includes a header ID, target resources, time stamp of the recorded event, request parameters, and response parameters.

#oratidbit #ADW #OracleCloud DATA_PUMP_DIR is the only directory you can specify as the directory argument for data pump jobs, and it is predefined. Move the dump files from the directory DATA_PUMP_DIR to Cloud Object Store by calling DBMS_CLOUD.PUT_OBJECT.

#oratidbit #ADW #OracleCloud To ensure the security and the performance of Autonomous Data Warehouse, LONG and LONG RAW data types are not supported (also media types and spatial types).

#oratidbit #db19c In a multitenant database, you can use Oracle Database Vault to block common users (infrastructure DBAs, for example) from accessing local data in pluggable databases (PDBs).

#oratidbit #exadata Secure Eraser (V2 or higher) solution securely erases all data on both database servers and storage servers, and resets InfiniBand switches, Ethernet switches, and power distribution units back to factory default. Use when you are removing an Oracle Exadata Database Machine from your environment to securely erase all the information on the servers.

#oratidbit #apex For testing and production instances, Oracle Application Express supports the ability to install a runtime version. This minimizes the installed footprint and privileges.

#oratidbit #orcldb #db19c Real-Time SQL Monitoring for Developers: Database users without SELECT_CATALOG_ROLE can generate and view SQL Monitor reports for their own SQL statements, including the execution plans and performance metrics.

#oratidbit #orcldb Trace File Analyzer (TFA) feature: Use “tfactl blackout” command to suppress automatic diagnostic collections. If you set blackout for a target, then TFA stops automatic diagnostic collections if it finds events in the alert logs while scanning.

#oratidbit #orcldb Trace File Analyzer (TFA) feature: “tfactl blackout” command has several options to supress diagnostic collection at a granular level. Use -targettype, -target, -events, -local.