Posts tagged "oracle"

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

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

Schema Privileges in Oracle Database 23ai

In version 23ai, the new schema privilege feature allows administrators to grant access to all existing and future objects within a schema with a single command. This simplifies privilege management a...

25.03.2025 0 Read More

Key Features No Longer Supported in Oracle 23ai

Oracle regularly introduces numerous features in each version while deprecating or desupporting certain older ones. “Deprecate” means a feature will no longer receive improvements and will eventua...

25.03.2025 0 Read More

Installing Oracle Grid Infrastructure 19.25 on Oracle Linux 9.5 Using ASMLIB 3

From Oracle Linux 8.7 onward, installing Oracle ASM using ASMLIB was challenging due to the need for a kernel downgrade. Recently, Oracle introduced a new version of ASMLIB with enhanced features, ena...

29.03.2025 0 Read More

How I Reduced My Oracle SQL Execution Time from 110s to 2s

🧩 The Problem Recently, I encountered a performance bottleneck while writing a SQL query: the execution time was over 110 seconds. Here’s a simplified version of the query: ⛶SELECT '...

30.03.2025 0 Read More

Oracle 23ai - Hybrid Read-Only Mode for Pluggable Databases

In Oracle 23ai, a new open mode called Hybrid Read-Only has been introduced for pluggable databases (PDBs). When a PDB is set to this mode, local users can only connect with read-only access. However,...

02.04.2025 0 Read More