Shrinking 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 MoreReplication snapshot agent permission issue and Troubleshooting 1. What is the replication for the SQL server? SQL Server replication is one of the HADR technologies that copy and distribute the data…
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 MoreSQL servers’ registration in SSMS What is server registration in SSMS? It is one of the features in SQL Server Management Studio (SSMS) which is very useful to have a list of registered servers…
Read MoreIntroduction/ Issue: Organizations operating across multiple countries and currencies require accurate financial reporting in more than one currency. In Oracle Fusion Financials, finance teams often face confusion between Reporting Currency…
Read MoreIntroduction/ Issue: Modern finance teams using Oracle Fusion Financials deal with large transaction volumes, tight close timelines, compliance pressure, and growing expectations for real-time insights. Traditional rule-based processes and…
Read MoreAJAX-Dynamic Tooltips & Cascading LOVs in Oracle APEX Introduction: In Oracle APEX applications, cascading List of Values (LOVs) are commonly used to filter data based on user selections. However, users…
Read More