OCI
-
Oracle SQL: DELETE … RETURNING: Efficient Data Removal with Immediate Feedback
The article discusses the Oracle Database feature “DELETE … RETURNING,” which allows for the deletion of rows while simultaneously retrieving data from those rows. This simplifies operations, reduces network round-trips, and enhances performance. It highlights Oracle’s advanced capabilities, making it invaluable for efficient data manipulation and maintaining records in enterprise systems.
-
Creating a free Linux OS lab environment on Oracle’s OCI
Introduction Creating a free Linux virtual machine on Oracle Cloud Infrastructure (OCI) is one of the best ways to experiment with cloud computing without spending [a lot of] money. Oracle offers an Always Free tier that includes ARM and AMD-based virtual machines, storage, and networking resources at no cost.This step-by-step guide walks you through the entire process. Why Use OCI…
-
DB creation in EXACS services using DBAASCLI utility
-
watch Command in Unix
The content outlines the use of the “watch” command to monitor an Oracle ZDM migration process on Azure. It demonstrates how to query job status at regular intervals, providing details about the job ID, user, type, execution times, and system metrics. The command’s functionality enhances visibility into the migration process.
-
How to Detect Unused PL/SQL Objects in Oracle
To identify unused PL/SQL code in an Oracle database, several methods are recommended. Strategies include auditing PL/SQL execution, using DBA_DEPENDENCIES views to track dependencies, and analyzing execution data through DBMS_PROFILER. A process for safely removing unused code should be established, including renaming suspected units and ensuring backups before deletion.
-
Understanding RAC One Node: Benefits and Drawbacks
RAC OneNode is an Oracle RAC feature that allows a single database instance on one node with easy relocation options. It enhances high availability and simplifies management but is less effective for heavy workloads and multi-node performance. Its complexities in licensing and potential downtime during relocations are notable drawbacks.
-
Top Factors for Oracle Database Migration Success
To migrate Oracle database instances to Oracle Database on Azure, key criteria include database size, workload characteristics, version compatibility, application dependencies, performance requirements, high availability, security compliance, current infrastructure, customization complexity, migration strategy feasibility, backup procedures, and cost implications. Assessing these ensures effective migration planning.
-
Ensuring PL/SQL Code Integrity with Checksums
The content explains how to implement a checksum for PL/SQL procedures to detect unauthorized modifications. It details steps for generating a checksum using Oracle’s DBMS_CRYPTO, storing it for future verification, and comparing it against current values. This approach helps ensure the integrity of PL/SQL procedures over time.
-
Setting up Oracle Base Database Service on OCI
Oracle Base Database service is a for pay offering on OCI but it is quite reasonably priced and suitable for setting up test environments. Still the setup is relatively complex and the scope of this article is the out line the main steps used. Setup the Network Decide the compartment to be used. In my…
-
SQLcl: Customizing on a Mac
In this post I will summarize the steps I’ve taken to customize SQLcl on my Mac working environment. We assume that the reader is familiar with the procedures outline din my previous post on SQLcl on setting up SQLcl on Mac environment. Terminal customization First I start with changing the terminal a bit in order…
-
SQLcl: Setup on a Mac
Simple and straightforward steps about how to setup Oracle’s new SQL command line tool on a macOS X environment. Download Application and Environment Setup Attempt to start the application: Setup Java Download Java from the Oracle site. As I am on a mac wit M processor (ARM) , I cannot install jre-8u371-macosx-x64.dmg, so I cannot…
-
Linux Playground on #OCI
