Md Asif Hussain / Database Blog / 28 Jan 2026

How to Perform Password-Based Encrypted RMAN Tablespace Backup & Restore

  Overview  This blog explains how to secure an Oracle 19c tablespace using RMAN password-based encryption and demonstrates a complete backup, restore, and recovery cycle. ...

Read More

Md Asif Hussain / Database Blog / 28 Jan 2026

Oracle 19c Table Shrink Space

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 ...

Read More

Venkatesh GK / Database Blog / Object / Roles / SYSTEM / 27 Jan 2026

Query to get the output for object privileges, roles, system privileges with details

Please 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...

Read More

Venkatesh GK / Database Blog / 10046 / sql trace / trace / 27 Jan 2026

Script to create trace at database schema level by enabling trigger model.

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 D...

Read More

Kaviarasy Gopinath / Database Blog / 27 Jan 2026

Telegraf configuration to scrape database information in windows server

Telegraf 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 se...

Read More