#oracle Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Oracle 23ai - Staging Table Feature

As you may know, using staging tables is a common practice in Data Warehouse environments, primarily during the data loading process into the Warehouse Database. Typically, raw data received from sour...

13.03.2025 0 Read More

ps --forest | for navigating Oracle PID's

{ Abhilash Kumar Bhattaram : Follow on LinkedIn } A primer about what is ps A ps (Process Status) Session involves analyzing active processes running on a Linux system using the ps c...

15.03.2025 0 Read More

Oracle 23ai — Track Table and Partition Scan Access

In Oracle 23ai, a new view named [dba|all|user]_table_access_stats has been introduced, enabling users to view the access history of tables and partitions. This view shows how many times each table or...

15.03.2025 0 Read More

Read-Only Oracle Home: Disabled by Default in Oracle 23ai

The Read-Only Oracle Home feature was introduced in Oracle 18c. This feature moves log files and configuration files located in the ORACLE_HOME directory-such as listener.ora, sqlnet.ora, spfile.ora, ...

17.03.2025 0 Read More

Oracle to PostgreSQL Migration: A Comprehensive Guide

Migrating from Oracle to PostgreSQL is becoming a priority for businesses looking to reduce costs, improve flexibility, and embrace open-source technologies. While Oracle provides enterprise-grade sol...

19.03.2025 0 Read More

Oracle 23ai — Speed up IMPDP Using NOVALIDATE Constraints

When executing the IMPDP command, some operations do not support parallel execution. Creating constraints is one such operation. Oracle must validate the current data in the table before creating a co...

21.03.2025 0 Read More

Column Level Audit in Oracle 23ai

Unified Auditing is enabled by default in Oracle 23ai, and this version introduces new features, including column-level auditing. This feature allows auditing specific column(s) of a table or view. Fo...

22.03.2025 0 Read More

Getting Started with Generative AI Services on OCI

Introduction This article aims to provide a comprehensive guide for beginners to get started with Oracle Cloud Infrastructure (OCI) Generative AI service. This article covers everything from ...

23.03.2025 0 Read More

OCI 2024 Security Professional: Key Skills & Best Practices for Cloud Security

Cloud migration continues to rise within businesses which has made security management a vital issue. OCI serves as a robust base to protect cloud systems. Experts having specialized skills and knowle...

23.03.2025 0 Read More

Compatibilidad entre Apex y Base de datos Oracle

Compatibilidad entre Oracle APEX y la Base de Datos Oracle Este cuadro muestra las versiones de Oracle APEX y su compatibilidad con las versiones de Oracle Database. Versión de Oracle APEX...

24.03.2025 0 Read More