“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in February 2021. I hope you find these helpful to learn something new or to remind you of its existence and use.
| #OraTidbit Starting #db21c #orcldb Oracle Grid Infrastructure, you must configure the Grid Infrastructure Management Repository (GIMR) in a separate Oracle home instead of in the Grid home. It is mandatory to configure GIMR in a separate Oracle home when you upgrade Oracle Grid infrastructure with an existing GIMR deployed in it. |
| #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 in a multitenant architecture Oracle Database and replicate the data from just that PDB to an Oracle Autonomous Database. |
| #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. Read-only Oracle homes also enable patching and updating of Oracle Database without extended downtime as patching simply means replacing a given set of binaries in a defined location. |
| #OraTidbit #db21c #db19c Oracle Database AutoUpgrade enables you to upgrade one or many databases without human intervention all with one command and with a single configuration file. AutoUpgrade runs the preupgrade tasks performs automated fix-ups where needed runs the database upgrade and finishes by completing post-upgrade tasks. |
| #OraTidbit Starting with #db21c, Oracle Data Pump can perform exports from Oracle Autonomous Database into dump files in a cloud object-store. You can now migrate data from services you manage in Oracle Autonomous Database. |
| #OraTidbit #AutonomousDB Big Data Service provides enterprise-grade Hadoop as a service, with end-to-end security, high performance, and ease of management and upgradeability. After deploying the Oracle Cloud SQL Query Server to Big Data Service, you can easily query data available on Hadoop clusters at scale from Autonomous Database using SQL. |
| #OraTidbit REST-Enabled SQL is an HTTPS web service that provides REST endpoints to access the Oracle Database SQL engine. You can POST SQL statements to the service. The service then runs the SQL statements against Oracle Database and returns the result to the client in a JSON format. |
| #OraTidbit Oracle REST Data Services provides REST endpoints that perform a wide range of Oracle Database management and monitoring operations. |
| #OraTidbit SODA (Simple Oracle Document Access) for REST provides endpoints that perform create, read, update, and delete operations on documents of any kind, and you can use them to query JSON documents. |
| #OraTidbit #AutonomousDB Oracle Machine Learning Notebooks is a collaborative user interface for data scientists and business/data analysts who perform machine learning in Oracle Autonomous Database. |
| #OraTidbit #AutonomousDB SQL Developer Web is now called Database Actions. Database Actions is a web-based interface that provides development tools, data tools, administration, and monitoring features for Autonomous Database. Using Database Actions you can load data and run SQL statements, queries, and scripts in a worksheet. |
| #OraTidbit #OracleCloud Oracle APEX Application Service is a low cost, Oracle Cloud service offering convenient access to the Oracle Application Express platform. APEX Service includes Oracle Application Express Workspace, SQL Developer Web (Database Actions), ORDS, and OCI Console UI for APEX Instances. |
| #OraTidbit #OracleCloud OCI Data Catalog service makes it easier to find valuable trusted data. It is a metadata management solution that supports data lakes, data warehouses, analytics, and data science solutions by enabling self-service data discovery and improving data governance. |