“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in November 2020. I hope you find these helpful to learn something new or to remind you of its existence and use.
| #OraTidbit #SQLcl Oracle SQLcl (SQL Developer Command-Line) is a Java-based command-line interface for Oracle Database. Using SQLcl, you can interactively or batch execute SQL and PL/SQL statements. SQLcl provides inline editing, statement completion, command recall, and supports existing SQL*Plus scripts. |
| #OraTidbit #Liquibase is an open-source database-independent library for tracking, managing, and applying database schema changes. With the Liquibase feature in SQLcl, you can generate and execute single object changelogs. |
| #OraTidbit #SQLDev There are two options for working with databases other than Oracle in SQL Developer: Creating database connections so that you can view schema objects and data. Migrating these databases to Oracle to take advantage of the full range of Oracle Database features and capabilities. |
| #OraTidbit #SQLDev The SQL Developer unit testing feature provides a framework for testing PL/SQL objects, such as functions and procedures, and monitoring such objects’ results over time. You create tests, and for each, you provide information about what is to be tested and what result is expected. |
| #OraTidbit Users of #AutonomousDB can subscribe to events and get notified. An event could be a resource lifecycle state change or a system event impacting a resource. Example events are DatabaseDownBegin, DatabaseDownEnd, MaintenanceBegin, MaintenanceEnd, DatabaseConnection. |
| #OraTidbit #OracleCloud Zero Downtime Migration lets you quickly and smoothly move your Oracle databases from on-premises environments and Oracle Cloud Infrastructure Classic to the Oracle Cloud without incurring significant downtime. |
| #OraTidbit #AutonomousLinux #Linux Every system running Autonomous Linux is patched automatically. This helps keep systems secure and compliant, eliminating the risk of unpatched systems. Ksplice technology allows patching for kernel and key userspace libraries without restarting or scheduled downtime. |
| #OraTidbit #AutonomousLinux #Linux Oracle Autonomous Linux automatically tunes memory management, network algorithms, and disk I/O based on workload, so applications run at higher performance and better reliability. |
| #OraTidbit #AutonomousDB #Azure You can use Shared Access Signatures (SAS) URL in any DBMS_CLOUD procedure that takes a URL to access files in Azure Blob Storage, without the need to create a credential. (New Feature) |
| #OraTidbit #AutonomousDB #AWS You can use a presigned URL in any DBMS_CLOUD procedure that takes a URL to access files in Amazon Simple Storage Service, without the need to create a credential. (New Feature) |
| #OraTidbit #VirtualBox Oracle VM VirtualBox supports importing of cloud instances from an Oracle Cloud Infrastructure service. When you import a cloud instance, Oracle VM VirtualBox creates and registers a new VM automatically on the localhost. |
| #OraTidbit #DB20c Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All passwords in new password files are case-sensitive. |
| #OraTidbit #DB20c MAX_IDLE_BLOCKER_TIME sets the number of minutes that a session holding needed resources can be idle before it is a candidate for termination. Unlike MAX_IDLE_TIME, MAX_IDLE_BLOCKER_TIME terminates resources only when they are needed. |
| #OraTidbit #DB20c Oracle ASM Flex Disk Group supports Cloning a PDB in one CDB to a new PDB in a different CDB. Previously point-in-time database clones could only clone a pluggable database (PDB) in a multitenant container database (CDB) to a new PDB in the same CDB. |
| #OraTidbit Oracle Database AutoUpgrade enables you to upgrade one or many Oracle Database instances at the command-line using a single command and a single configuration file. AutoUpgrade runs the pre-upgrade tasks, performs automated fix-ups where needed, runs the database upgrade, and finishes by completing post-upgrade tasks. |