SQL & PL/SQL

Hi,

I am doing complete refresh on a materialized view using below command.

EXECUTE DBMS_SNAPSHOT.REFRESH( '"RAAV_SIT"."RAAV_SIT_MV"','C');

but it is hanging, not completing the task.

I checked the MV query when i run outside it is having only 350 records, so it should take couple of min/secs to complete. but why it is hanging.

So i thought of dropping an recreating the Mv, so when i run drop command in another session

drop materialized view raav_orders_mv;

but it is also not getting executed, getting hanging.

where do i check, whether it is waiting for something or went into locked status etc.

THANKS.