Author: biju.thomas

“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.

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

#OraTidbit Starting #db21c #orcldb Oracle Grid Infrastructure, you must configure the Grid Infrastructure Management Repository (GIMR) in a separate Oracle home instead of in the Grid home. It is mandatory to configure GIMR in a separate Oracle home when you upgrade Oracle Grid infrastructure with an existing GIMR deployed in it.

#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 in a multitenant architecture Oracle Database and replicate the data from just that PDB to an Oracle Autonomous Database.

#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. Read-only Oracle homes also enable patching and updating of Oracle Database without extended downtime as patching simply means replacing a given set of binaries in a defined location.

#OraTidbit #db21c #db19c Oracle Database AutoUpgrade enables you to upgrade one or many databases without human intervention all with one command and with a single configuration file. AutoUpgrade runs the preupgrade tasks performs automated fix-ups where needed runs the database upgrade and finishes by completing post-upgrade tasks.

#OraTidbit Starting with #db21c, Oracle Data Pump can perform exports from Oracle Autonomous Database into dump files in a cloud object-store. You can now migrate data from services you manage in Oracle Autonomous Database.

#OraTidbit #AutonomousDB Big Data Service provides enterprise-grade Hadoop as a service, with end-to-end security, high performance, and ease of management and upgradeability. After deploying the Oracle Cloud SQL Query Server to Big Data Service, you can easily query data available on Hadoop clusters at scale from Autonomous Database using SQL.

#OraTidbit REST-Enabled SQL is an HTTPS web service that provides REST endpoints to access the Oracle Database SQL engine. You can POST SQL statements to the service. The service then runs the SQL statements against Oracle Database and returns the result to the client in a JSON format.

#OraTidbit Oracle REST Data Services provides REST endpoints that perform a wide range of Oracle Database management and monitoring operations.

#OraTidbit SODA (Simple Oracle Document Access) for REST provides endpoints that perform create, read, update, and delete operations on documents of any kind, and you can use them to query JSON documents.

#OraTidbit #AutonomousDB Oracle Machine Learning Notebooks is a collaborative user interface for data scientists and business/data analysts who perform machine learning in Oracle Autonomous Database.

#OraTidbit #AutonomousDB SQL Developer Web is now called Database Actions. Database Actions is a web-based interface that provides development tools, data tools, administration, and monitoring features for Autonomous Database. Using Database Actions you can load data and run SQL statements, queries, and scripts in a worksheet.

#OraTidbit #OracleCloud Oracle APEX Application Service is a low cost, Oracle Cloud service offering convenient access to the Oracle Application Express platform. APEX Service includes Oracle Application Express Workspace, SQL Developer Web (Database Actions), ORDS, and OCI Console UI for APEX Instances.

#OraTidbit #OracleCloud OCI Data Catalog service makes it easier to find valuable trusted data. It is a metadata management solution that supports data lakes, data warehouses, analytics, and data science solutions by enabling self-service data discovery and improving data governance.