Category: TidBits

Posted on

Oracle Tidbits: November 2021 #OraTidbit

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

#OraTidbit #OracleCloud #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 #OracleCloud #AutonomousDB You can make your Java application connect to Oracle Autonomous Database using TLS instead of mTLS for secure, encrypted communications without a wallet.
#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 #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 #OracleCloud Starting November 3, 2021, Oracle defined backup policies will no longer include full volume backups. All volume backups generated from Oracle-defined policies will be incremental backups. This change applies to existing volume backup policy assignments and new volume backup policy assignments.
#OraTidbit #OracleCloud #AutonomousDB can import JSON data from Cloud Object Store into a table. This import method supports all the Cloud Object Stores supported by Autonomous Database.
#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 #AutonomousDB now supports Blockchain tables. Blockchain tables are insert-only tables that organize rows into a number of chains.
#OraTidbit #OracleCloud Shielded instances harden the firmware security on bare metal hosts and virtual machines (VMs) to defend against malicious boot-level software. Shielded instances use the combination of Secure Boot, Measured Boot, and the Trusted Platform Module (TPM) to harden the firmware security on your instances.
#OraTidbit #OracleCloud #AutonomousDB supports immutable tables. Immutable tables are read-only tables that prevent unauthorized data modifications by insiders and accidental data modifications resulting from human errors.
#OraTidbit #OracleCloud A cluster network is a pool of high-performance computing (HPC), GPU, or Optimized instances that are connected with a high-bandwidth, ultra-low-latency network. Each node in the cluster is a bare metal machine located in close physical proximity to the other nodes.
#OraTidbit #OracleCloud schedule-based autoscaling of the instance pool is ideal where demand behaves predictably based on a schedule, such as a month, date, or time of day. A schedule-based autoscaling configuration can have multiple autoscaling policies, each with a different schedule and target pool size or lifecycle action.
#OraTidbit #AutonomousDB When you initiate certain operations that take some time to complete, including scaling the system (Scale Up/Down) or performing a manual backup, these operations do not prevent you from performing other operations.
#OraTidbit #OracleCloud Verrazzano is an end-to-end enterprise container platform for deploying cloud-native and traditional applications in multicloud and hybrid environments.
#OraTidbit #OracleCloud Data Labeling is the process of identifying properties of documents, text, and images and annotating them with those properties.
#OraTidbit #OracleCloud #OCI Certificates provides organizations with certificate issuance, storage, and management capabilities, including revocation and automatic renewal. If you have a third-party certificate authority (CA) that you already use, you can import certificates issued by that CA for use in an Oracle Cloud Infrastructure tenancy.
#OraTidbit #OracleCloud #AutonomousDB DBMS_LDAP and UTL_TCP packages are now available with restrictions. UTL_TCP restrictions include only 443 (HTTP) 25 and 587 (SMTP) are the allowed ports. For DBMS_LDAP the only allowed port is 636.
#OraTidbit #OracleCloud These PL/SQL packages are not available on
#AutonomousDB DBMS_DEBUG, DBMS_DEBUG_JDWP, DBMS_DEBUG_JDWP_CUSTOM, DBMS_PIPE, UTL_INADDR.
#OraTidbit #OracleCloud #AutonomousDB You can set up Database Actions for database users of Autonomous Database. Database users are not service administrators who do not have access to the Autonomous Database service console. Database Actions provides development tools, data tools, administration, and monitoring features for Autonomous databases.
#OraTidbit #OracleAPEX The Oracle APEX Application Development service provides a preconfigured, fully managed, and secured environment in Oracle Cloud to build and deploy world-class applications. After signing up for your Free Tier account, you can easily create an APEX Service that is free for an unlimited time.
Posted on

Oracle Tidbits: September 2021 #OraTidbit

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

#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 #OCI E4 Flex shapes lets you choose the number of OCPU and the amount of memory for IaaS deployments. PaaS deployments of Virtual Machine DB Systems are restricted to Standar2 shapes (1 OCPU to 24 OCPU – fixed memory based on OCPU).
#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 APEX applications and corresponding Oracle REST Data Services endpoints. APEX Service also comes with development tools such as Database Actions.
#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 #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 #OracleXE restricts the database resources to 12 GB of user data,
2 GB of database RAM, and 2 CPU threads.
#OraTidbit #OracleXE Oracle Database XE restricts itself to only one installation per logical environment. The logical environment can either be a virtual host such as a VM or container, or a physical host.
#OraTidbit #AutonomousDB #OCI Oracle Cloud Infrastructure Console provides information on Autonomous Database maintenance windows and patch level and provides a customer contacts area where you can view or manage the list of contacts to receive information on operational issues and service announcements.
#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 The Data Science service enables data science teams to build, train, and manage machine learning and artificial intelligence models on Oracle Cloud. Notebook Sessions provide a JupyterLab interface where data scientists can write and execute Python code to build, train, evaluate, and explain models using a wide variety of pre-installed open-source and Oracle machine learning libraries.
#OraTidbit #AutonomousDB You can use Autonomous Database as a Recovery Manager (RMAN) recovery catalog. Recovery Manager (RMAN) recovery catalog is preinstalled in Autonomous Database in schema RMAN$CATALOG. The preinstalled catalog version is based on the latest version of Oracle Database and is compatible with all supported Oracle database versions.
#OraTidbit #OracleCloud Oracle Integration is a secure, unified platform that lets you connect cloud and on-premises applications, automate business processes, gain insight into your business through business metrics analysis, and develop web and mobile applications.
#OraTidbit #OracleCloud Oracle Integration includes a portfolio of recipes for integrating different applications. Think of a recipe as a template or pre-assembled solution that gives you a head start in building your integrations. You can start with a recipe, and then customize it to fit your needs and requirements.
#OraTidbit Application Continuity Protection Check (ACCHK) (#db21c feature backported to 19.11) provides guidance on the level of protection for each application that uses Application Continuity and assists you to increase protection if required.
#OraTidbit Oracle database has two core mechanisms to work with data in OCI object stores – DBMS_CLOUD package or manually defining external tables. The DBMS_CLOUD package is available in Oracle Database 19c, starting with version 19.10.
#OraTidbit #AutonomousDB Automatic partitioning analyzes and automates partition creation for tables and indexes of a specified schema to improve performance and manageability in Autonomous Database. Automatic partitioning, when applied, is transparent and does not require any user interaction or maintenance.