Results 1 to 3 of 3
  1. #1
    Join Date
    May 2008
    Posts
    2

    Question Unanswered: Problem while dropping materialzed views in Oracle 10g

    Hi,

    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.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    I would assume there is another session actually using (i.e. retrieving data) that MV

  3. #3
    Join Date
    May 2008
    Posts
    2
    I am sure there is no other session which is retrieving data from MV.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •