Posted by Mir Sayeed Hassan on 23rd December 2017
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..
Posted in Performance Tuning(PT) | Comments Off on Real time Auditing in Oracle Database 11gR2
Posted by Mir Sayeed Hassan on 23rd December 2017
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..
Posted in Performance Tuning(PT) | Comments Off on Auditing at Schema Level in Oracle Database 11gR2
Posted by Mir Sayeed Hassan on 3rd December 2017
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..
Posted in Performance Tuning(PT) | Comments Off on Performance tuning test for Wait Event enq: TX – row lock contention.