Tag: oratidbit

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

#OraTidbit #DB19c For Enterprise and Standard editions of Oracle database, if you are not licensed for Oracle Multitenant, then you may have up to 3 PDBs in a given container database at any time.

#OraTidbit #OracleLinux Oracle Linux 8 ships with version 8.0 of the #MySQL database.

#OraTidbit #OracleLinux In Oracle Linux 8, the default iptables network packet filtering framework been replaced with the nftables framework. iptables-translate, ip6tables-translate commands to convert existing iptables and ip6tables rules to their nftables equivalents.

#OraTidbit #OracleCloud #AutonomousDB #AlwaysFree Autonomous Database will stop the database if there is no activity for 7 consecutive days. Always Free Autonomous Database will be terminated if the database is stopped for 3 consecutive months.

#OraTidbit #OracleCloud #Exadata Cloud Service configuration is equipped with a fixed amount of memory, storage, and network resources. You can choose how many compute node CPU cores are enabled, to meet workload demands and only pay for the compute node resources that you need.

#OraTidbit #OracleCloud When an #AutonomousDB preview version is available you can provision an Autonomous Database to try new features and to test your applications before the general availability of these features. The current preview version is Oracle Database 19c.

#OraTidbit #DB19c In Oracle Database 19c, you can create a duplicate of an Oracle Database by using the createDuplicateDB command of Database Configuration Assistant (DBCA) in silent mode.

#OraTidbit #DB19c GROUP_PARTITION_TABLE_DATA, a new value for the Import DATA_OPTIONS command line parameter, changes Oracle Data Pump default behavior by importing table data in all partitions of a table as one operation.

#OraTidbit Oracle Trace File Analyzer in #DB19c includes REpresentational State Transfer (REST) support. The REST interface enables you to configure remote management, and automate data center operations.

#OraTidbit #OrclAPEX Social Sign-In authentication scheme supports authentication with Google, Facebook, and other social networks that support OpenIDConnect / OAuth2 standards.

#OraTidbit #OracleCloud #AutonomousDB ATP/ADW allows you to modify initialization parameters OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES, STATISTICS_LEVEL, and TIME_ZONE (only) at the session-level.

#OraTidbit #OracleCloud #AutonomousDB Caution: A restore operation on ATP/ADW restores the user-defined directories to the timestamp you specified for the restore; files that were created after that timestamp would be lost.

#OraTidbit #OracleCloud #AutonomousDB Oracle Flashback Features Supported with Autonomous Database are Flashback Drop, Query, Table, Transaction Query, and Version Query. Flashback Data Archive and Flashback Transaction are not supported.

#OraTidbit #OracleCloud #AutonomousDB Though CREATE DATABASE LINK statement is not available, you can use DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK to create database links in Autonomous Database (ATP/ADW).

#OraTidbit #OracleCloud #AutonomousDB You can create and validate external partitioned tables with the DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE and DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE statements. Query multiple data files in the Object Store as a single external table and the files can be represented as multiple logical partitions.

#OraTidbit #OracleCloud #AutonomousDB Enabling autoscaling allows an Autonomous Database to use up to three times more CPU and IO resources than the currently specified CPU Core Count (up to a maximum of 128 CPU cores). If your workload requires additional CPU and IO resources the database automatically uses the resources without any manual intervention required.

#OraTidbit #DB19c In Oracle Database 19c, you can use an external Simple Mail Transfer Protocol (SMTP) server to receive Oracle Trace File Analyzer notifications. In earlier releases, the monitored hosts have to be configured with local Sendmail or SMTP support.

#OraTidbit #OrclDB Oracle Advanced Queuing stores user messages in abstract storage units called queues. When Web-based business applications communicate with each other, producer applications enqueue messages and consumer applications dequeue messages.

#OraTidbit #oVirt is an open-source distributed virtualization solution, designed to manage enterprise infrastructure. oVirt uses the KVM hypervisor. Oracle Linux Virtualization Manager (#OLVM) is based on the oVirt opensource project.

#OraTidbit #Linux In Oracle Linux 8, both the GNOME session and GNOME Display Manager (GDM) use Wayland as the default display server. Wayland is a simpler replacement to the X.org server.

#OraTidbit Starting with Oracle Database Release 19c, invalidated PL/SQL objects run on Active Data Guard standby database can be automatically recompiled by setting the ADG_REDIRECT_DML initialization parameter to TRUE. The DDL corresponding to these PL/SQL objects is redirected to and executed on the primary database. The standby session waits until the operation is completed.

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

#Oratidbit Fast-Start Failover (FSFO) is a feature of the Oracle Data Guard Broker that enables an automatic failover to the standby database upon failure of the primary. FSFO can be configured in either an active or an Observer only mode.

#OrclEBS #OracleCloud Oracle E-Business Suite Cloud Manager provides a graphical user interface for creating, managing, configuring, migrating Oracle E-Business Suite environments on Oracle Cloud Infrastructure (OCI).

#OraTidbit You can use Oracle Enterprise Manager to discover and manage dedicated Autonomous Transaction Processing databases, if you are using Enterprise Manager version 13.3 with EM DB Plugin Bundle Patch 13.3.2.0.190731 or higher.

#OraTidbit #SQLDev Oracle SQL Developer Web provides a development environment and a data modeler interface for Oracle Autonomous Databases (ATP/ADW).

#OraTidbit #OracleCloud #OCI The minimum retention requirement for Archive Storage is 90 days. If you delete objects from Archive Storage before the minimum retention requirements are met, you are charged a deletion penalty.

#OraTidbit #OracleCloud #OCI Oracle Cloud Infrastructure offers 1-node DB systems on either bare metal or virtual machines, and 2-node RAC DB systems on virtual machines.

#OraTidbit #OracleCloud #OCI When you enable Data Guard for a virtual machine DB system database, a new DB system with the standby database is created. For bare metal DB system, DB system to be used as the standby must already exist before you enable Data Guard.

#OraTidbit #OracleCloud Oracle Functions is a fully managed, highly scalable, on-demand, Functions-as-a-Service platform, built on #OCI and powered by the Fn Project open-source engine. Access Oracle Functions using the Console, a CLI, and a REST API.

#OraTidbit #OracleCloud The #OCI Health Checks service provides high-frequency external monitoring to determine the availability and performance of any publicly facing service, including hosted websites, API endpoints, or externally facing load balancers.

#OraTidbit #OracleCloud The #OCI Monitoring service actively and passively monitor your cloud resources using the Metrics (to monitor resources) and Alarms (to notify you when these metrics meet alarm-specified triggers) features.

#OraTidbit #OracleCloud #ThinkAutonomous The data_pump_dir directory is available in an Autonomous database. You can now use CREATE DIRECTORY and DROP DIRECTORY commands to create and drop additional directories.

#OraTidbit The I/O calibration feature of #OrclDB is using the DBMS_RESOURCE_MANAGER.CALIBRATE_IO procedure- issues one megabyte of random I/O intensive read-only I/Os to the database files to determine the maximum IOPS and MBPS that can be sustained by the storage subsystem.

#OraTidbit #DB19c Real-Time Statistics feature is when a DML operation is currently modifying a table, Oracle Database dynamically computes values for the most essential statistics. The NO_GATHER_OPTIMIZER_STATISTICS hint prevents the collection of real-time statistics.

#OraTidbit #DB19c If real-time statistics are available, then you can access them using DBA_TAB_COL_STATISTICS and DBA_TAB_STATISTICS views. Real-time statistics are indicated by STATS_ON_CONVENTIONAL_DML in the NOTES column and SHARED in the SCOPE column.

#OraTidbit The Oracle Data Masking and Subsetting (DMS) pack of the Oracle Enterprise Manager (OEM) provides an automated, flexible, and easy-to-use solution that masks and subsets sensitive production data, allowing data to be shared safely across a non-production environment

#OraTidbit #OracleVM The Oracle VM Paravirtual Drivers for Microsoft Windows improve performance for network and block (disk) devices on Microsoft Windows guests running in a virtual environment on Oracle VM.

#OraTidbit #OracleVM Oracle VM provides support for Hybrid Columnar Compression (HCC) on Oracle Database Release 18c (or higher) with Oracle ZFS Storage Appliance and Oracle FS1 Series Flash Storage Systems.

#OraTidbit #OracleVM Enabling viridian support ensures improved performance for all Microsoft Windows guest operating systems on Oracle VM. Viridian support enables the exposure of Windows virtualization compatible entitlements to Microsoft Windows guest operating systems.

#OraTidbit #OracleVM Oracle Enterprise Manager Release 13.2 or later is required to manage Oracle VM Release 3.4.x. Oracle VM Manager integrates with OEM so that you can manage the entire Oracle VM environment from within OEM.

#OraTidbit #Vagrant is an open-source software product for building and maintaining portable virtual software development environments, for #VirtualBox, KVM, Hyper-V, #Docker containers, #VMware, and #AWS.

#OraTidbit #ThinkAutonomous Oracle Autonomous Database (ADW/ATP) allows CREATE DIRECTORY statement to create directories. If the file system directory exists then CREATE DIRECTORY only creates the database directory object.

#OraTidbit #ThinkAutonomous You can create directories in Oracle Autonomous Database (ADW/ATP). CREATE DIRECTORY command creates the necessary directories and subdirectories on the OS side for you.

#OraTidbit #ThinkAutonomous Autonomous Database (ADW/ATP) allows user directories. Since there is no OS access to ATP/ADW machines, use DBMS_CLOUD.LIST_FILES function to list files in a directory. Use DBMS_CLOUD.DELETE_FILE function to remove a file.