Category: TidBits

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in April 2021. I hope you find these helpful to learn something new or to remind you of its existence and use. It’s a shorter list this month, as I did not tweet every day.

#OraTidbit #AutonomousDB Database Actions Data Load option helps you select data to load from your local computer, from tables in other databases, or from cloud storage. Then you can add the data you select to new or existing tables or views in Autonomous Database.

#OraTidbit #AutonomousDB Database Actions Catalog option helps you to see information about the entities in your Autonomous Database and to see the effect that changing an object has on other objects. The catalog provides a tool for you to examine data lineage and understand the impact of changes.

#OraTidbit #AutonomousDB Database Actions Data Insights option crawls a table or business model and discovers hidden patterns, anomalies, and outliers in your data. Insights are automatically generated by built-in analytic functions. The results of the insight analysis appear as bar charts in the Data Insights dashboard.

#OraTidbit #AutonomousDB Database Actions Business Models option describes the business entities that are derived from data in your Autonomous Database schema or from other sources. This allows you to create a semantic model on top of your data identifying hierarchies, measures, and dimensions.

#OraTidbit #AutonomousDB You can view Autonomous Database maintenance history to see details about past maintenance, such as the start time and stop time for past maintenance events.

#OraTidbit #Linux Oracle Linux Virtualization Manager is a server virtualization management platform that can be easily deployed to configure, monitor, and manage an Oracle Linux Kernel-based Virtual Machine (KVM) environment with enterprise-grade performance and support from Oracle.

#OraTidbit #AutonomousDB Autonomous Database uses predefined maintenance windows to automatically patch your database. Your database remains available during the maintenance window. Your existing database connections may get disconnected briefly; however, you can immediately reconnect and continue using your database.

#OraTidbit #AutonomousDB You can view Autonomous Database maintenance history to see details about past maintenance, such as the start time and stop time for past maintenance events. Your database remains available during the maintenance window.

#OraTidbit #OracleCloud The Network Visualizer provides a diagram of the implemented topology of all VCNs in a selected region and tenancy. Regional Network Topology shows a high-level layout and routing topology of the entire virtual network configuration within a region. Virtual Cloud Network Topology shows the organization of a single VCN including its subnets and routing configuration.

#OraTidbit #Exadata The Smart Flash Log Write-Back feature automatically and transparently stores the entire contents of redo log files using Exadata Smart Flash Cache in Write-Back mode, thereby eliminating the HDDs as a potential performance bottleneck. Depending on the system workload, overall log write throughput can improve up to 250%.

#OraTidbit #OracleCloud Oracle Integration is a fully managed service that allows you to integrate your applications, automate processes, gain insight into your business processes, and create visual applications.

#OraTidbit #OracleCloud OCI Database Migration is a fully-managed service that provides a high performing, self-service experience for migrating databases to OCI. It provides logical online and offline migration for enterprise-level database migration with minimal downtime.

#OraTidbit #OracleCloud The Oracle Cloud Infrastructure Streaming service provides a fully managed, scalable, and durable solution for ingesting and consuming high-volume data streams in real-time.

#OraTidbit #OracleCloud The Oracle Cloud Infrastructure OS Management service allows you to manage updates and patches for the operating system environment on your Oracle Cloud Infrastructure instances.

#OraTidbit #OracleCloud For each Exadata Cloud Service instance you provision, you are billed for the infrastructure for a minimum of 48 hours, and then by the second after that. Each OCPU you add to the system is billed by the second, with a minimum usage period of 1 minute.

#OraTidbit #SQLDev The SQL Developer unit testing feature provides a framework for testing PL/SQL objects, such as functions and procedures, and monitoring the results of such objects over time. The implementation of unit testing is modeled on the well known xUnit collection of unit test frameworks.

#OraTidbit #SQLDev For certain operations, you can invoke SQL Developer from the command line as an alternative to the graphical user interface using sdcli. If you enter just sdcli, the list of available features shows each sdcli command and its associated feature.

#OraTidbit #SQLDev SQL Developer includes an integrated version of SQL Developer Data Modeler. You can create, open, import, and save a database design, and you can create, modify, and delete Data Modeler objects.

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in March 2021. I hope you find these helpful to learn something new or to remind you of its existence and use. It’s a shorter list this month, as I did not tweet every day.

#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. OML4Py is available through the Python interpreter in Oracle Machine Learning Notebooks.

#OraTidbit #AutonomousDB Oracle will generate one-off patches for critical service requests filed with My Oracle Support for Oracle Autonomous Database on Dedicated Exadata Infrastructure when you and Oracle agree that the problem is critical and requires a one-off patch for immediate resolution.

#OraTidbit PASSWORD_ROLLOVER_TIME password profile parameter in #db21c allows the older database password to remain valid for the time specified. During the rollover period of time, the application instance can use either the old password or the new password to connect to the database server. When the rollover time expires only the new password is allowed.

#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 #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 #db21c 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 #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 #FusionMW Oracle Enterprise Manager Cloud Management Pack for Oracle Fusion Middleware helps to set up a Middleware Cloud and operate the Middleware (or Platform) as a Service model.

#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. You can execute SQL statements, create Data Modeler diagrams, develop RESTful web services, manage JSON collections, and use the Data Load, Catalog, Data Insights, Business Models, and Data Transforms tools, view data in tables and views, view objects in the data dictionary, and organize, analyze, and transform your data.

#OraTidbit #OrclDB Zero Downtime Migration leverages Oracle Active Data Guard to create a standby instance of your database in an Oracle Cloud Infrastructure system. You switch over only when you are ready, and your source database remains available as a standby.

#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. You can then use Oracle Analytics Cloud to customize existing dashboards and create dashboards.

#OraTidbit #OracleCloud EPM Automate enables users to remotely perform tasks within Oracle Enterprise Performance Management Cloud environments. EPM Cloud Service Administrators can automate many repeatable tasks.