Description: – Active Data Guard allows a physical standby database to be opened in READ ONLY mode while redo apply continues in the background. This enables the standby database to be used for reporting and…
Read MoreOverview This blog explains how to secure an Oracle 19c tablespace using RMAN password-based encryption and demonstrates a complete backup, restore, and recovery cycle. It covers verifying tablespaces and datafiles, taking an encrypted RMAN backup…
Read MoreShrinking a table in an Oracle database is used to reclaim unused space and optimize storage. As data is inserted, updated, and deleted over time, tables can become fragmented and retain empty blocks, leading to wasted…
Read MorePlease use the below query to get the output. set echo on; SELECT COUNT(*) AS object_priv_count FROM dba_tab_privs WHERE grantee = ‘A’; set echo on; SELECT COUNT(*) AS role_grant_count…
Read MorePlease 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 More