#oracle Development Tutorials & Tips | Roast Dev

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

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

Day-3 Exploring Oracle, JavaScript

Today I have gone through the integrity constraints in deeper. then i performed some operations like creating the table with check and i learned the relationship among the table using one-to-one They ...

03.04.2025 0 Read More

Day 4 I have revised some of oracle concepts

Hi Everyone Today I have revised some of the topics in oracle like cross join ,set operators like union, union all, intersect, minus I would like to define them in simple words unio means that combi...

04.04.2025 0 Read More

Oracle 23ai — Automatic SQL Transpiler Feature

As you may know, using a function in an SQL statement causes a context switch between the SQL engine and the PL/SQL engine. Frequent context switches can negatively impact database performance.To impr...

07.04.2025 0 Read More

gprofng on Oracle ARM Linux

{ Abhilash Kumar Bhattaram : Follow on LinkedIn } What is gprofng ? gprofng is a next-generation profiling tool designed to help identify performance bottlenecks in software applicat...

08.04.2025 0 Read More

Oracle Linux - AppStream

{ Abhilash Kumar Bhattaram : Follow on LinkedIn } What is Oracle Linux AppStream ? Application Stream (AppStream) is a concept introduced in RHEL 8 (and adopted by Oracle Linux 8 and...