Introduction High availability and predictable disaster recovery are critical in any Oracle production environment. While managing Data Guard manually via SQL*Plus is possible, the number of manual steps during incidents…
Read MorePrerequisites: a. Oracle Linux 7.9 b. Oracle 19c database (should be 19.3 or higher version), Check using… SELECT target_version AS RU_VERSION FROM dba_registry_sqlpatch WHERE action = 'APPLY' ORDER BY action_time…
Read MorePrerequisite: 1. MS SQL Server with a SQL Authenticated User. CREATE LOGIN Sivakumar WITH PASSWORD = 'Doyen@123', CHECK_POLICY = OFF; SELECT name, type_desc,…
Read MoreParameter Sniffing Issue in SQL Server and Its Resolution Parameter Sniffing Issue in SQL Server and Its Resolution
Read MorePerformance Tuning of Slow Running Queries in SQL
Read MoreIntroduction: Transaction log growth is a common operational challenge in SQL Server environments. Uncontrolled log file growth can lead to disk space issues, performance degradation, and operational risks. This blog…
Read MoreIntroduction Performance issues in SQL Server rarely appear overnight. They build gradually—hidden behind rising CPU usage, growing waits, slow queries, or storage bottlenecks. Effective performance monitoring helps DBAs move from reactive firefighting…
Read MoreIntroduction Data Guard setups often appear straightforward on paper, but real-world environments have a way of exposing gaps in even the most familiar procedures. While creating a Physical Standby Database using…
Read MoreINTRODUCTION: As an Oracle DBA, setting up Data Guard is only half the job. The real responsibility starts after the setup — making sure redo is shipping, applying correctly, and that there…
Read MoreDescripton: Configuring Oracle E-Business Suite REST Services on Oracle Cloud Infrastructure. Steps: 1.EBS version: Must be Oracle E-Business Suite Release 12.2 or higher. Patches required: AD and TXK latest delta…
Read More