Browsing Tag
oracle
13 posts
Series Week 4/52 — Predictable SLAs in Oracle Database Management
{ Abhilash Kumar Bhattaram : Follow on LinkedIn } > Ground Zero: Where Challenges Start Underneath Ground Zero:…
Understanding Distributed Transaction Locks and Session-Specific Data in Oracle
Understanding Distributed Transaction Locks and Session-Specific Data in Oracle When working with Oracle databases, developers and DBAs often…
Creating Gold Image from existing installed software(GI HOME and Oracle HOME)
Consider a situation where you need to repeatedly install an already-installed software, which also has several applied patches,…
OIC integration with OCI
{ Abhilash Kumar Bhattaram : Follow on LinkedIn } Seamless Integration: Oracle Integration Cloud (OIC) with Oracle Cloud…
Creating Materialized View with FAST REFRESH
Part 1 – Implementation: Creating Materialized View with FAST REFRESH To enable FAST REFRESH in a materialized view,…
Best Oracle Database Design Tools in 2025
When you’re looking for a database design tool, it’s not just for fun – you actually need one!…
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…
How to Write a Token Price Oracle Smart Contract
Introduction In the rapidly evolving DeFi ecosystem, accurate and reliable token price data is fundamental for various applications…
Stored Procedure in PL/SQL
Stored Procedure A stored procedure in PL/SQL (Procedural Language/Structured Query Language) is a set of SQL statements that…
Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL
Introduction This article is based on real problems I had in a production environment in Oracle 11g. Oracle…
