Insights and Experiences from Doyensys’ Database Administrators.
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 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 ...
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...
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 D...
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 se...
Read More