OracleNotes

Blog

  • Oracle Tidbits: July 2019 #oratidbit

    Oracle Tidbits: July 2019 #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 Tidbits: June 2019 #OraTidbit

    Oracle Tidbits: June 2019 #OraTidbit

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

    #oratidbit Oracle Data Pump in #db19c has a new transform parameter OMIT_ENCRYPTION_CLAUSE that causes Data Pump to suppress any encryption clauses associated with objects using encrypted columns.
    #oratidbit Deferred Insert is a special type of insert in #db19c for which the database allocates buffers from the large pool. Deferred inserts are automatically committed and cannot be rolled back.
    #oratidbit Enable deferred insert (#db19c feature) for a table by using the MEMOPTIMIZE FOR WRITE clause in ALTER TABLE or CREATE TABLE. Initiate deferred insert using the /*+ MEMOPTIMIZE_WRITE */ hint in the INSERT statement.
    #oratidbit #db19c Starting in Oracle Database 19c, the SQL*Plus table PRODUCT_USER_PROFILE (PUP table) is desupported. The SQL*Plus product-level security feature is unavailable in Oracle Database 19c.
    #oratidbit #db19c Starting with Oracle Database 19c and Oracle Grid Infrastructure 19c, Rapid Home Provisioning is renamed to Fleet Patching and Provisioning (FPP).
    #oratidbit Using Fleet Patching and Provisioning to patch and upgrade Oracle Restart automates and standardizes the processes that are implemented in Oracle RAC database installations. This also reduces operational demands and risks, especially for large numbers of Oracle Restart deployments.
    #oratidbit Oracle Big Data SQL supports queries against non-relational data stored in multiple big data sources, including Apache Hive, HDFS, Oracle NoSQL Database, Apache HBase, and Apache Kafka. It enables unified query for distributed data.
    #oratidbit #oraclecloud Autonomous Database (ADW/ATP) automatically backs up the database for you. The retention period for backups is 60 days. You can restore and recover your database to any point-in-time in this retention period.
    #oratidbit #oraclecloud Autonomous Database supports restricted access using a network Access Control List (ACL) to accept connections from addresses specified on the ACL and rejects all other client connections.
    #oratidbit #oraclecloud Autonomous Database supports Application Continuity. Enable using the DBMS_CLOUD_ADMIN.ENABLE_APP_CONT procedure for a service.
    #oratidbit #OracleRAC Starting with Oracle Grid Infrastructure 19c, the Grid Infrastructure Management Repository (GIMR) is optional for new installations of Oracle Standalone Cluster. Reduces functionality in CHAG, CHACTL, TFA.
    #oratidbit #OracleRAC In Oracle Grid Infrastructure 12.2, Oracle announced that it would no longer support the placement of the Oracle Cluster Registry (OCR) and voting files directly on a shared file system. This desupport is now rescinded starting with 19c (19.3).
    #oratidbit V$PASSWORDFILE_INFO provides information about the database password file. IS_ASM column indicates where the password file is stored.
    #oratidbit Oracle #db19c still supports the DBMS_JOB package. You must grant the CREATE JOB privilege to the database schemas that submit DBMS_JOB jobs.
    #oratidbit Flash-based Enterprise Manager Express is deprecated in Oracle Database 19c. Starting with #db19c, Enterprise Manager Express uses Java JET technology for the user interface.
    #oratidbit #db19c Oracle Streams desupported in Oracle Database 19c 19.1. The streams views such as DBA_STREAMS*, ALL_STREAMS*, V$STREAMS* are desupported.
    #oratidbit #thinkautonomous #APEX Each Autonomous Database (ATP/ADW) instance includes a dedicated instance of Oracle Application Express; you can use this instance to create multiple workspaces.
    #oratidbit #thinkautonomous Autonomous Database (ATP/ADW) supports Microsoft Azure cloud storage with Oracle Data Pump.
    #oratidbit #db19c AutoUpgrade enables you to upgrade one or many Oracle Database instances at the command-line, using a single command, and a single configuration file. AutoUpgrade runs preupgrade tasks, fix-ups where needed, database upgrade, and post-upgrade tasks.
    #oratidbit #db19c Oracle Real Application Testing supported multitenant databases at the root container database (CDB) level. Starting with Oracle Database Release 19c, you can capture and replay the workload from within an individual pluggable database (PDB).