“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 |