Here are a few scripts that can be used to compile invalid objects in an Oracle database: Note: Please make sure that you have the…
Leave a CommentAuthor: Brijesh Gogia
I’m an experienced Cloud and AI Architect with over 19 years in Oracle Applications, Databases, and Cloud ecosystems. My work spans large-scale, global projects where I’ve designed and optimized solutions across both Oracle and non-Oracle stacks—on-prem and in the cloud. Lately, my focus has shifted toward integrating AI into enterprise architectures, leveraging GenAI, automation, and data intelligence to drive performance, resilience, and modernization. I’m passionate about exploring emerging AI tools, agentic workflows, and practical use cases—and I'm fortunate that my role gives me space to experiment and share my learnings.
[sc name="linkedin"][/sc]
The “library cache pin” wait event in an Oracle database occurs when a session is waiting to acquire a shared lock on an object in…
Leave a CommentQ: What is Oracle ASM and what are its benefits compared to traditional file systems? Ans: Oracle ASM is a volume manager and file system…
Leave a CommentConverting a database SID from uppercase to lowercase in the Oracle database can be needed sometimes. Below are general steps for converting a database SID…
Leave a CommentInactive Connection Timeout is a feature in WebLogic that allows you to configure the amount of time a connection can be inactive before it is…
Leave a CommentThe SCM0 background process in Oracle RAC (Real Application Clusters) is a component of the Oracle Clusterware and is responsible for managing the shared resources…
Leave a CommentOracle Database Service for Azure (OracleDB for Azure ODSA) allows you to easily integrate Oracle Cloud Infrastructure database products into your Azure cloud environment. The…
Leave a CommentIn our previous post, we covered the fundamental aspects of Oracle Database Service for Azure (ODSA). In this post, we will delve into the process…
Leave a CommentMajor cloud providers have begun to offer a plethora of services tailored to meet the demands of various industries. Oracle Database Service for Azure is…
Leave a CommentSQL Profile and SQL Baseline are both used to optimize the performance of SQL statements in Oracle databases. However, they work in slightly different ways:…
Leave a Comment