Author: biju.thomas

Posted on

Oracle Tidbits: July 2021 #OraTidbit

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

#OraTidbit #db21c The attention log is a structured, externally modifiable file that contains information about critical and highly visible database events. Use the attention log to quickly access information about critical events that need action. One attention log for each DB.
#OraTidbit V$DIAG_ALERT_EXT view shows the contents of the XML-based alert log in the Automatic Diagnostic Repository (ADR) for the current container (PDB). A message_level of 1 corresponds to critical errors that need immediate action.
#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.
#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 and replicate the data from just that PDB to ADB or ATP.
#OraTidbit #OracleCloud Oracle Machine Learning for Python (#OML4Py) on Autonomous Database provides a Python API to explore and prepare data, and build and deploy machine learning models using the database as a high-performance compute engine.
#OraTidbit #AutonomousDB Oracle will generate one-off patches for critical service requests filed with MOS for Oracle Autonomous DB on Dedicated Exadata Infrastructure when you and Oracle agree that the problem is critical and requires a one-off patch for immediate resolution.
#OraTidbit #orcldb Oracle Enterprise Manager Cloud Management Pack for Oracle Database helps to set up a Database Cloud and operate the Database as a Service model.
#OraTidbit #db21c Starting with Oracle Database 21c Oracle Data Pump expdp and impdp support use of object store URIs for the DUMPFILE parameter. To use this feature for exports or imports from an object store the CREDENTIAL parameter must be set.
#OraTidbit #OracleCloud The Fusion Analytics Warehouse service includes Oracle Analytics Cloud powered by Oracle Autonomous Data Warehouse. The service extracts and loads data from your Oracle Applications Cloud into an instance of Oracle Autonomous Data Warehouse.
#OraTidbit #AutonomousDB New in July 2021. You can view Autonomous Database patch information, including a list of resolved issues and components. The view DBA_CLOUD_PATCH_INFO is available to the ADMIN user.
#OraTidbit #OracleCloud Oracle Machine Learning for Python (#OML4Py) on Autonomous Database provides a Python API to explore and prepare data, and build and deploy machine learning models using the database as a high-performance compute engine.
#OraTidbit #AutonomousDB Oracle will generate one-off patches for critical service requests filed with MOS for Oracle Autonomous DB on Dedicated Exadata Infrastructure when you and Oracle agree that the problem is critical and requires a one-off patch for immediate resolution.
#OraTidbit #OracleCloud The Fusion Analytics Warehouse service includes Oracle Analytics Cloud powered by Oracle Autonomous Data Warehouse. The service extracts and loads data from your Oracle Applications Cloud into an instance of Oracle Autonomous Data Warehouse.
#OraTidbit #OracleCloud EPM Automate Cloud Service enables users to remotely perform tasks within Oracle Enterprise Performance Management Cloud environments. EPM Cloud Service Administrators can automate many repeatable tasks.
#OraTidbit #db21c Starting with Oracle Database 21c Oracle Data Pump can perform exports from Oracle Autonomous Database into dump files in a cloud object-store.
#OraTidbit July Edition
Posted on

Oracle Tidbits: June 2021 #OraTidbit

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

#OraTidbit #OracleCloud Exadata Cloud Service has a non-rolling infrastructure patching option. This option allows you to reduce the total time your system is undergoing quarterly maintenance but does involve system downtime.
#OraTidbit #OracleCloud AWR Viewer in Database Management integrates performance and data visualization tools, displaying the historical performance data from AWR snapshots in easy-to-interpret charts. You can use the #OCI Database Management service to monitor and manage your on-premises Oracle Databases.
#OraTidbit #OracleCloud Data Flow is a fully managed service for running Apache Spark applications. It allows developers to focus on their applications and provides an easy runtime environment to execute them. There is no need to spend any time on the underlying infrastructure, cluster provisioning, or software install.
#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.
#OraTidbit #AutonomousDB Automatic partitioning uses a single-column partition key combined with single-level partitioning. Partition methods: AUTOMATIC INTERVAL, LIST AUTOMATIC, HASH. Automatic partitioning analyzes application workload and finds the optimal partitioning strategy.
#OraTidbit #AutonomousDB Graph Studio provides graph data support in Oracle Autonomous Database to model, create, query, and analyze graph data. Graph Studio includes notebooks, developer APIs for executing graph queries using PGQL, nearly 60 built-in graph algorithms, and offers dozens of visualizations including native graph visualization.
#OraTidbit #AutonomousDB Database Actions is a web-based interface that uses Oracle REST Data Services to provide development, data tools, administration, and monitoring features for Oracle Autonomous Database. The main features include executing your SQL statements and scripts, creating Data Modeler diagrams, developing RESTful web services, managing JSON collections, and using the Data Load, Catalog, Data Insights, Business Models, and Data Transforms tools to load data from local and remote sources, view data in your tables and views, view objects in your data dictionary, and organize, analyze, and transform your data.
#OraTidbit #db21c Database Nest is an infrastructure that provides operating system resource isolation and management, file system isolation, and secure computing for CDBs and PDBs. This infrastructure enables a database instance to run in a protected, virtualized environment.