Please execute the below and change the username accordingly. After the trace drop the trigger. CREATE OR REPLACE TRIGGER “1234_TMP_LOGGINGTRIG” AFTER LOGON ON DATABASE begin if ora_login_user = ‘1234’…
Read MoreTelegraf is a small tool that collects system and application data and sends it to monitoring tools like Prometheus, Grafana.Telegraf helps you see what is happening inside your server and…
Read More1.Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass # --- CONFIGURATION --- $oracleHome = "D:\automation\WINDOWS.X64_193000_db_home" $patchDir = "D:\automation\p37532350_190000_MSWIN-x86-64 (2)\37532350" $opatchDir = "$oracleHome\OPatch" $opatchZip = "D:\automation\p6880880_190000_MSWIN-x86-64.zip" $logFile = "C:\Users\Administrator\Documents\oracle_patch_log.txt" # Define Oracle services $dbService…
Read MoreStep-by-Step guide to installing MySQL Server Step 1: Download MySQL Installer Open your web browser and go to the official MySQL downloads page. Choose the MySQL Installer for Windows appropriate for your system. …
Read MoreCommon causes of SQL Server Timeout During a recent production run, a stored procedure timed out at peak order processing. This caused delays in processing orders and highlighted the importance of query…
Read MoreOracle LogMiner: Unlocking the Power of Database Transaction Analysis In the world of database management, understanding the changes happening inside your Oracle Database is crucial. Whether it’s for auditing, troubleshooting, or replicating data,…
Read MoreHow Oracle 19c Protects SQL Performance Using SQL Plan Management (SPM) What is SQL Plan Management (SPM)? SQL Plan Management ensures that only known and verified execution plans are used for a…
Read MorePurpose and Scope This document describes the procedure to copy table data from a source server to a destination server using the SQL Server Import and Export Wizard. This method is commonly used for…
Read MoreThe purpose of this article is to give newbies some basic advice about SQL performance tuning that helps to improve their query tuning skills in SQL Server. Introduction We…
Read MoreIntroduction : Always On Availability Groups is a high-availability and disaster-recovery feature in SQL Server that ensures database continuity with minimal downtime. In this blog, I explain the step-by-step process to…
Read More