Category: TidBits

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

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

#OraTidbit #Exadata The Oracle Database 21c incorporates workload monitoring to establish what materialized views are needed. Based on the decisions, materialized views and materialized view logs are created and maintained automatically without manual interaction.

#OraTidbit #db21c The Data Guard Broker in Oracle Database 21c enables users to create and add a Far Sync instance to a Data Guard Broker configuration using a single command.

#OraTidbit #AutonomousDB #OracleCloud You can access Oracle Application Express, Oracle SQL Developer Web, Oracle REST Data Services, and Oracle Machine Learning Notebooks with Private Endpoints.

#OraTidbit #AutonomousDB #OracleCloud Using Oracle #GoldenGate you can capture changes from an Oracle Autonomous Database and replicate them to any target database or platform that Oracle GoldenGate supports, including another Oracle Autonomous Database.

#OraTidbit #AutonomousDB #OracleCloud Oracle Database 21c is available with Always Free Autonomous Database on Oracle Cloud.

#OraTidbit #AutonomousDB #OracleCloud Oracle Machine Learning Notebooks is an Apache Zeppelin-based collaborative web-based interface that provides a development environment to create machine learning notebooks where you can perform data exploration and visualizations, data preparation and machine learning.

#OraTidbit #OracleCloud Oracle Cloud VMware Solution is a fully customer-controlled and customer-operated #VMware environment provisioned on Oracle Cloud Infrastructure. It enables you to migrate VMware-virtualized workloads at a global scale, using existing practices for IT operations, and in a secure manner.

#OraTidbit #AutonomousDB Oracle Autonomous Database uses always-on encryption that protects data at rest and in transit. All data stored in and network communication with Oracle Cloud is encrypted by default. Encryption cannot be turned off.

#OraTidbit #OrclDB Oracle Data Safe helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements in both cloud and on-premise databases.

#OraTidbit #AutonomousDB Oracle Autonomous Database with Oracle Autonomous Data Guard – Recovery Time Objective (RTO) is seconds up to two minutes; Recovery Point Objective (RPO) is near-zero.

#OraTidbit Oracle #db21c incorporates workload monitoring to establish what materialized views are needed. Based on the decisions materialized views and materialized view logs are created and maintained automatically without any manual interaction.

#OraTidbit #db21c Automatic In-Memory feature enables, populates, evicts, and recompresses segments without user intervention. When INMEMORY_AUTOMATIC_LEVEL is set to HIGH the database automatically enables and populates segments based on their usage patterns.

#OraTidbit #db21c #db19c Database In-Memory is an option to Enterprise Edition. Database In-Memory has a new Base Level feature. This allows the use of Database In-Memory with up to a 16GB column store without triggering any license tracking.

#OraTidbit #AutonomousDB New in January – You can choose the bucket name to store manual backups and the steps to configure manual backups are simplified.

#OraTidbit #AutonomousDB New in January – Autonomous Database generates events that you can subscribe to with Oracle Cloud Infrastructure Events. There are two new Information events: ScheduledMaintenanceWarning and WalletExpirationWarning.