Oracle Tidbits: January/February 2022 #OraTidbit

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

#OraTidbit #AutonomousDB When you enable an Auto Start/Stop Schedule for an Autonomous Database instance, the instance automatically starts and stops according to the schedule you specify. This allows you to reduce costs by scheduling shutdown periods for times when a system is not in use.
#OraTidbit #AutonomousDB The Associated Services area on the Oracle Cloud Infrastructure Console includes the Database Management service to monitor the health of a single Autonomous Database or a fleet of Autonomous Databases.
#OraTidbit #AutonomousDB you can export data from Autonomous Database as text in the following formats: CSV, JSON, or XML.
#OraTidbit #AutonomousDB The CS_SESSION package provides an interface to switch the database service and consumer group of the existing session. When a connection is established with an Autonomous Database, that session is assigned a consumer group. The CS_SESSION package provides an API for switching, for example from LOW to HIGH.
#OraTidbit #OracleCloud Verrazzano is an end-to-end enterprise container platform for deploying cloud-native and traditional applications in multicloud and hybrid environments. It is made up of a curated set of open source components.
#OraTidbit #OracleCloud Operations Insights provides 360-degree insight into the resource utilization and capacity of databases and hosts. You can easily analyze CPU and storage resources, forecast capacity issues, and proactively identify SQL performance issues across your database fleet.
#OraTidbit #db21c feature in #db19c Blockchain tables are append-only tables in which only insert operations are allowed. Deleting rows is either prohibited or restricted based on time. Rows in a blockchain table are made tamper-resistant by special sequencing and chaining algorithms.
#OraTidbit #OracleCloud Oracle Cloud Guard detects misconfigured resources and insecure activity across tenants and provides security administrators with the visibility to triage and resolve cloud security issues. Security inconsistencies can be automatically remediated with out-of-the-box security recipes to effectively scale the security operations center.
#OraTidbit #OracleCloud Oracle Cloud Infrastructure Vulnerability Scanning Service gives development teams the confidence to develop their code on hosts with the latest security patches and helps ensure a smooth transition to build production code. Used with Oracle Cloud Guard, operations teams gain a unified view of all hosts to quickly remediate any open ports or patch unsafe packages discovered by Vulnerability Scanning Service.
#OraTidbit #OracleCloud Oracle Visual Builder Studio (VB Studio) brings you all the functionality previously available with Oracle Developer Cloud Service and Oracle Visual Builder, along with the ability to extend certain Oracle Cloud Applications to customize the UI for your business needs.
#OraTidbit #OracleCloud Verrazzano is an end-to-end enterprise container platform for deploying cloud-native and traditional applications in multicloud and hybrid environments. It is made up of a curated set of open source components
#OraTidbit #AutonomousDB The DB_NOTIFICATIONS view stores information about maintenance status notifications and timezone version upgrade notifications for your Autonomous Database instance.
#OraTidbit #AutonomousDB Autonomous Database provides routines to manage and store files in Cloud Code (Git) Repositories. The supported Cloud Code Repositories are: GitHub Repository, AWS CodeCommit, and Azure Repos.
#OraTidbit #AutonomousDB The Associated Services area on the Oracle Cloud Infrastructure Console includes a Database Management link. You can use Database Management service to monitor the health of a single Autonomous Database or a fleet of Autonomous Databases.
#OraTidbit #OracleCloud Oracle Cloud Infrastructure Console Dashboards
service allows you to create custom dashboards in the OCI Console to monitor resources, diagnostics, and key metrics for your tenancy. A dashboard is a collection of widgets. Each widget presents one set of data.
#OraTidbit #OracleCloud Observability and Management Services: The OCI Logging Analytics service is a highly scalable, reliable, and real-time log analysis solution. Logging Analytics automates the collection of historic and real-time logs from any on-premises or cloud resource.
#OraTidbit #OracleCloud Observability and Management Services: Database Management includes two options for Oracle Cloud Databases – Basic (free), and full-management (additional cost).
#OraTidbit #OracleCloud Observability and Management Services: On the Fleet Summary page, you can monitor multiple Oracle Databases, which include single instance and RAC databases. This enables you to proactively detect and identify the root cause of performance issues across a fleet of databases and respond to performance and configuration-related alerts.
#OraTidbit #OracleCloud Observability and Management Services: Oracle Cloud Logging Analytics is a cloud solution that lets you index, enrich, aggregate, explore, search, analyze, correlate, visualize and monitor all log data from your applications and system infrastructure.
#OraTidbit #OracleCloud OCI Vision is a serverless, cloud-native service that provides deep learning-based, prebuilt, and custom computer vision models over REST APIs. OCI Vision helps you identify and locate objects, extract text, and identify tables, document types, and key-value pairs from business documents like receipts.

Oracle Tidbits: December 2021 #OraTidbit

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

#OraTidbit #NewFeature #db19c #db21c Gradual Database Password Rollover feature allows an application to change its database passwords without scheduling downtime. Use the PASSWORD_ROLLOVER_TIME password profile parameter. This #db21c feature is available from 19.12.
#OraTidbit #AutonomousDB #New When you provision or clone an Autonomous Database instance you can select a patch level to apply upcoming patches. Regular and Early. The Early patch level allows you to use and test upcoming patches before they are applied to all systems.
#OraTidbit #NewFeature #db19c #db21c Application Continuity Protection Check (ACCHK) provides guidance on the level of protection for each application that uses Application Continuity and assists you to increase protection if required. This #db21c feature is available from 19.11.
#OraTidbit #NewFeature #db19c #db21c Immutable tables are insert-only tables in which existing data cannot be modified. Deleting rows is either prohibited or restricted based on the insertion time of the rows. This #db21c feature is available from 19.11.
#OraTidbit #OrclAPEX Oracle APEX Application Development (APEX Service) is a feature-scoped service of Autonomous Database that enables developers to rapidly build and deploy low-code APEX applications. APEX Service supports Oracle REST Data Services endpoints.
#OraTidbit #OracleXE Oracle Advanced Compression, Advanced Security, Database In-Memory, Database Vault, Label Security, Multitenant and Partitioning options are included with the Oracle XE release.
#OraTidbit Restricted use licenses for Oracle Advanced Compression and Oracle Advanced Security are granted when performing a migration to OCI using Oracle Zero Downtime Migration or Oracle Cloud Infrastructure Database Migration (DMS).
#OraTidbit #OCI #AutonomousDB You can configure a custom domain name or vanity URL for your APEX apps, Oracle REST Data Services (ORDS), and developer tools by placing an Oracle Cloud Infrastructure Load Balancer directly in front of your Autonomous Database.
#OraTidbit #AutonomousDB #OCI Oracle Cloud Infrastructure Console provides information on Autonomous Database maintenance windows and patch level and provides a customer contacts area to manage the contacts to receive information on operational issues and service announcements.
#OraTidbit #OracleXE Multitenancy is included in XE and you are licensed to create up to 252 PDBs, however, the actual number of PDBs you can create might be less due to XE resource limits.
#OraTidbit #db21c A temporary tablespace can grow to a very large size due to spikes in temporary space usage by queries. Automatic temporary tablespace shrink is a feature that shrinks the temporary tablespace in the background when temporary space usage has subsided.
#OraTidbit The #db21c database incorporates workload monitoring to establish what materialized views are needed. Based on the decisions it makes, materialized views and materialized view logs are created and maintained automatically without any manual interaction.
#OraTidbit #OracleCloud #OCI Oracle Cloud Infrastructure Operations Insights is an OCI native service that provides 360-degree insight into the database and host resource utilization and capacity.
#OraTidbit #OracleCloud In metric-based autoscaling, when system usage meets a specific defined metric threshold, autoscaling dynamically resizes the instance pool in near-real-time. As load increases, the pool scales out. As load decreases, the pool scales in.
#OraTidbit #OracleCloud Shielded instances harden the firmware security on bare metal hosts and virtual machines (VMs) to defend against malicious boot-level software. They use the combination of Secure Boot, Measured Boot, and the Trusted Platform Module (TPM) to harden.
#OraTidbit #OracleCloud A cluster network is a pool of high-performance computing (HPC), GPU, or Optimized instances connected with a high-bandwidth, ultra-low-latency network. Each cluster node is a bare metal machine located in close physical proximity to the other nodes.