Posts Tagged ‘nologging’

delete statement performance impact

+14 Delete Statement Response Time  in Oracle: Below is a quick observation on my test machine. ———————————–Playing with Delete statement with enabled trigger,Logging/Nologging Below Analysis Result on below System Configuration: Two Node RAC 11gR2  created on Virtual Box CPU: 1(2.00 GHz) each node RAM: 2gb each node