var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problem while dropping materialzed views in Oracle 10g
I want to drop a materialized view (in oracle 10g) . But most of the times whenever "Drop materialized view" command is issued, this session hangs and inturn all the other sessions also hangs.
V$session has the following information
Command : 76 (DROP MATERIALIZED VIEW)
Event : library cache lock
These Sessions doesn’t have any SQL’s associated with this.
Could someone explain why these drop materialized view command hangs?
To avoid this situation, I had to manually kill such sessions almost everyday.
I would assume there is another session actually using (i.e. retrieving data) that MV
I am sure there is no other session which is retrieving data from MV.