Samir Roy, Author At DBA POSTMORTEM

How to find bind variable values for a given sql_id in Oracle: Easy Guide

Today in this article, we will see how to find bind variable values for a given sql_id in Oracle. Let’s […]

SQL Tuning Advisor (STA) can provide some recommendations for a sql_id to improve its performance. Today in this article, we

Today we will learn how to resolve ORA-12170 Error while using DB Link. Let’s go through this in detail :

In this article, we will learn how to find DDL of DB_LINK in Oracle. Let’s go through this. Query :

Sometimes while starting up the databases, we may get the error ORA-46365. Today we will discuss how to resolve this

Welcome to our guide on how to reduce a datafile in oracle database. Whether you’re a beginner or an expert,

In this comprehensive guide, we’ll show you how to reclaim space from datafile oracle. Let’s open Virtualbox. Follow along for

This post will cover everything you need to know about tablespace utilization in Oracle. Let’s open virtualBox and get started!

Welcome to our guide on finding the top 10 largest tables in Oracle. You’ll find valuable insights here whether you’re