Category: Oracle
-
SQL Assertions in Oracle: From Theory to Practice with Oracle AI Database
SQL assertions are defined in the standard but are rarely implemented in real databases due to performance and complexity challenges. Vendors like Oracle opt for simpler constraints, such as triggers and stored procedures, to maintain global integrity rules. Consequently, this reflects a gap between theoretical relational models and practical implementations. The evolution shows a preference…
Written by
·
-
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.
Written by
·
-
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…
Written by
·
-
UPDATE: Release Schedule of Current Database Releases (Doc ID 742060.1)
The release schedule for current database updates has been updated. Upgrade support for versions 11.2, 12.1, and 12.2 has been extended through 2026, ensuring continued assistance and maintenance for users of these database versions. For further details, refer to Doc ID 742060.1.
Written by
·
-
Oracle 19c Lab Setup: Essential Steps on VMWare Fusion
This document outlines the steps for installing Oracle Enterprise Linux 8 and Oracle Database 19c on VMware Fusion. Key procedures include configuring network settings, enabling SSH, and installing open-vm-tools. Post-installation tasks involve setting up authentication for the oracle user, configuring firewall ports, and preparing the environment for database operations.
Written by
·
-
Mastering User Control in Oracle Enterprise Linux Systems
This post details user management in Oracle Enterprise Linux (OEL), covering user creation, modification, deletion, and group management. Key commands include useradd, usermod, and userdel. Additionally, it emphasizes the importance of proper user management for system security and efficiency, along with options for managing user passwords and home directories.
Written by
·
-
How to Check Table Replication Status with DBA_GOLDENGATE_SUPPORT_MODE
DBA_GOLDENGATE_SUPPORT_MODE is a key view in Oracle 23ai that provides critical metadata about table replication compatibility with Oracle GoldenGate. It helps Database Administrators identify a table’s support level for replication. Enhanced features allow for more efficient data synchronization across environments, improving the management of replication processes.
Written by
·
-
DB creation in EXACS services using DBAASCLI utility
DBAASCLI is a command-line utility for managing Oracle Database Cloud Services (DBaaS) instances especially for Oracle Exadata cloud services. It … DB creation in EXACS services using DBAASCLI utility
Written by
·
-
Control DDL Commands in Oracle Databases
This article discusses implementing a database-level trigger to manage and restrict DDL operations by limiting access to specific users. Unauthorized users attempting DDL actions will encounter a custom error message. The trigger code is provided, along with examples of error stacks generated from prohibited actions such as adding a column or truncating a table. This…
Written by
·
-
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.
Written by
·
-
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.
Written by
·
-
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.
Written by
·