How to generate the IOPS report in Oracle database 19c Note: The report is created as per the requirement of the client from the databaase., Usually we should do it on regular basis for the analysis of the data. Check the database SYS> select name, open_mode, version from V$instance, v$database; NAME OPEN_MODE VERSION ——— ——————–… Read More

Real time Auditing in Oracle Database 11gR2 There are major 4 types of auditing: 1 – Statement level auditing 2 – Object level auditing 3 – Privilege level auditing 4 – Fine granined auditing  In… Read more..

Auditing at Schema Level in Oracle Database 11gR2  DDL Auditing at Schema Level  Try to perform the below tested & verified auditing at schema level in Oracle Database 11gr2  A DDL event occurs when a DDL statement is run in specific schema level such as… Read more..

Performance tuning test for Wait Event enq: TX – row lock contention. Simulate step by step procedure for Wait Event enq: TX – row lock contention, by updated (locking) row in 1st session & while trying to update the 2nd… Read more..