SQL statements including queries and DML sometimes execute with the different index because of the following reasons: Missing index The target index might be dropped… Read More »How to Improve SQL Performance
The following statement is wrong if you are trying to change the owner of a table via rename clause:SQL> alter table hr.employees rename to sh.employees;alter… Read More »How to Change the Owner of Tables
After the blocking sessions are identified, DBA should notify the session owners and leave them a chance to exit sessions gracefully by themselves. If things… Read More »How Oracle Kill Blocking Sessions
Implicit Commit In the default behavior, if session A wants to see session B's results, he must be waiting for session B to commit his… Read More »How to Set Autocommit ON and OFF