Oracle Tidbits – May 2020 #OraTidbit

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

#OraTidbit #AutonomousDB Oracle Database Vault implements powerful security controls for your Autonomous Data Warehouse database. These security controls restrict access to application data by privileged database users, reducing the risk of inside and outside threats, and addressing common compliance requirements.
#OraTidbit #db20c Starting with Oracle Database 20c, Oracle Data Pump can perform exports from Oracle Autonomous Database into dump files in a cloud object-store. Oracle Data Pump supports dump file export from cloud services to the object-store.
#OraTidbit A bigfile tablespace contains only one datafile or tempfile, which can contain up to approximately 4 billion blocks. The maximum size of the single datafile or tempfile is 128 terabytes (TB) for a tablespace with 32 K blocks and 32 TB for a tablespace with 8 K blocks.
#OraTidbit The LONG datatype is deprecated since Oracle Database 8.0, but is still supported in Oracle Database 20c! LONG columns may be desupported in a future release.
#OraTidbit The container root (CDB$Root) of the standby database may be opened read-only without requiring an Oracle Active Data Guard license. An Oracle Active Data Guard license is only required if any of the pluggable databases in the standby is opened for read.
#OraTidbit #OracleAnalyticsCloud has three editions available: Professional, Enterprise, and Essbase. Essbase Edition isn’t available in APAC or LAD regions or with Oracle Cloud accounts created after 12th December 2019.
#OraTidbit #OracleIntegration #OracleCloud Oracle Integration is a unified platform where you can integrate your applications, automate processes, and create applications.
#OraTidbit #OracleCloud OCI cluster network is a pool of high-performance computing (HPC) instances that are connected with a high-bandwidth, ultra-low-latency network. Each node in the cluster is a bare-metal machine connected using remote direct memory access (RDMA) network that provides single-digit microseconds latency.
#OraTidbit #AutonomousDB Performance Hub now includes a new Workload tab that displays four sets of graphically displayed data to help users monitor and analyze database performance. The four regions are CPU, Wait time, Workload, and sessions.
#OraTidbit #Exadata Cloud Service instance is based on an Exadata system configuration that contains compute nodes and Storage Servers tied together by a high-speed, low-latency InfiniBand network. Quarter, half & full rack configurations possible. The full rack has eight compute nodes and 12 Exadata Storage Servers.
#OraTidbit #ML Machine learning is a powerful tool that can help you find patterns and relationships within your data. ML discovers hidden information in data, but it cannot tell you the value of the information to your organization.
#OraTidbit #ML Oracle Machine Learning for SQL (OML4SQL) provides a powerful, state-of-the-art machine learning capability within Oracle Database. In Database releases prior to Release 20c, Oracle Machine Learning was named Oracle Data Mining.
#OraTidbit #ML Oracle Machine Learning for R (OML4R) is a comprehensive, database-centric environment for end-to-end analytical processes in R. OML4R is a set of R packages and Oracle Database features that enable an R user to operate on database-resident data without using SQL and to execute R scripts.
#OraTidbit #ML Oracle Database has several data dictionary views that contain information about Oracle Machine Learning for R (OML4R) datastores and scripts in the repository. Views begin with ALL_RQ_, RQUSER_, USER_RQ_.
#OraTidbit #ML The PL/SQL interface to Oracle Machine Learning for SQL (OML4SQL) is implemented in three packages – DBMS_DATA_MINING, DBMS_DATA_MINING_TRANSFORM, DBMS_PREDICTIVE_ANALYTICS.
#OraTidbit #AutonomousDB Autonomous Database instance CPU and storage usage on shared Exadata infrastructure is billed by the second, with a minimum usage period of 1 minute. Use what you need, pay what you use.
#OraTidbit #OracleCloud Oracle Exadata Cloud Service has three configuration options. Quarter rack with 2 compute nodes and 3 Exadata storage servers, half rack and full rack with 8 compute nodes and 12 Exadata storage servers.
#OraTIdbit #documentation Looking for help with designing and implementing IT topologies for specific business scenarios? You can find reference architectures, solution playbooks, and more right here. https://docs.oracle.com/en/solutions/index.html?type=reference-architectures&page=0&is=true&sort=0

Oracle Tidbits – April 2020 #OraTidbit

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

#OraTidbit #db20c Oracle Data Guard Broker provides early detection of fast-start failover (FSFO) configuration issues and reports those misconfigurations allowing administrators to take action prior to a failover event.
#OraTidbit #db20c Oracle Data Guard broker utilizes a standardized directory structure to store client-side files. Use the DG_ADMIN environment variable to specify the default location.
#OraTidbit #db20c Two new #GoldenGate views, DBA_OGG_AUTO_CAPTURED_TABLES, and USER_OGG_AUTO_CAPTURED_TABLES, provide you with tools to query which tables are enabled for Oracle GoldenGate automatic capture.
#OraTidbit #db20c #db19c Init parameter MAX_IDLE_BLOCKER_TIME specifies the maximum number of minutes that a blocking session can be idle. After that point, the session is automatically terminated. This parameter differs from the MAX_IDLE_TIME parameter in that MAX_IDLE_TIME applies to all sessions (blocking and non-blocking), whereas MAX_IDLE_BLOCKING_TIME applies only to blocking sessions.
#OraTidbit #db20c In 20c, you must configure the Grid Infrastructure Management Repository (GIMR) in a separate Oracle home, instead of in the Grid home. A separate Oracle home for the GIMR ensures faster rolling upgrades, less errors, and fewer rollback situations.
#OraTidbit #db20c The remote Grid Infrastructure Management Repository (GIMR) feature for Oracle Standalone Cluster enables you to use a centralized GIMR. This feature does not require local cluster resources to host the GIMR.
#OraTidbit #db20c Init parameter DIAGNOSTICS_CONTROL helps to control and monitor the users who perform potentially unsafe database diagnostic operations. To modify this parameter with the ALTER SYSTEM command, you must be authenticated AS SYSDBA.
#OraTidbit #db20c Init parameter TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM specifies the default algorithm the database uses when encrypting a tablespace if an encryption algorithm is not specified when creating an encrypted tablespace or when encrypting an existing tablespace.
#OraTidbit #AutoUpgrade Oracle Database AutoUpgrade enables you to upgrade one or many databases without human intervention, all with one command, and with a single configuration file.
#OraTidbit #DBUpgrade Use the Oracle Database Parallel Upgrade Utility with the -T option to take schema-based tablespaces offline during upgrade. Oracle Database can read file headers created in earlier releases. The file headers of READ ONLY tablespaces are updated when they are changed to READ WRITE.
#OraTidbit #DBUpgrade If you plug in an earlier release PDB to a new release CDB, then the CDB detects on opening the PDB that the PDB is an earlier release than the CDB, and automatically starts a Replay Upgrade process. Upgrade on PDB Open automatically upgrades the PDB using the Replay Upgrade synchronization feature.
#OraTidbit #DBUpgrade By default, the Oracle Multitenant Replay Upgrade method is enabled for upgrades on PDBs and CDBs. To disable the Parallel Upgrade Utility (catctl.pl) default of performing a Replay Upgrade, run ALTER DATABASE UPGRADE SYNC OFF on either CDB$ROOT or a particular PDB.
#OraTidbit #db20c Traditional auditing is deprecated in 20c. Thus, AUDIT_FILE_DEST, AUDIT_SYS_OPERATIONS, AUDIT_SYSLOG_LEVEL, AUDIT_TRAIL init parameters are deprecated.
#OraTidbit #db20c The UNIFIED_AUDIT_SGA_QUEUE_SIZE initialization parameter is desupported in 20c database.
#OraTidbit #db20c #AutonomousDB Autonomous Database instance OCPU compute usage is now billed per-second with a one minute minimum. Previously Autonomous Database billed in one-hour minimum increments and partial usage of an hour was rounded up to a full hour.
#OraTidbit #AutonomousDB You can create Oracle Autonomous Database Dedicated Deployment on quarter-rack or half-rack Exadata Database Machine X7-2 or X8-2 systems.
#OraTidbit #VirtualBox Oracle VM VirtualBox 6.1 supports the importing of cloud instances from an Oracle Cloud Infrastructure service. When you import a cloud instance, Oracle VM VirtualBox creates and registers a new VM automatically on the localhost.
#OraTidbit #VirtualBox You can export a VirtualBox VM to Oracle Cloud Infrastructure account and save it as a custom image to create multiple cloud instances from the custom image, without having to reupload the image every time.
#OraTidbit #Linux The virt-v2v utility converts virtual machines from Oracle VM hypervisor, including their disk images and metadata, for use with Oracle Linux Virtualization Manager and Oracle Linux KVM.
#OraTidbit #AutonomousDB Autonomous Database supports loading and using Simple Oracle Document Architecture (#SODA) documents and collections. SODA allows us to store, search, and retrieve document collections, typically JSON documents, without using SQL.