Gather Database Stats EXEC dbms_stats.gather_database_stats; /* Gather Database Stats with default preference */ EXEC dbms_stats.gather_database_stats(cascade=>true,method_

There are many ways to find locking /blocking sessions in Oracle, this is what I normally use. SELECT a.sid Blocker_SID, sb.username || '

This instruction is created for Oracle on Windows, it also applies to Unix/Linux installations. The difference will be mainly the folder path locations. Master