Re: DFS Lock issue, RAC, ASM, and oracle bug reports

From: 조동욱 <ukja.dion_at_gmail.com>
Date: Thu, 17 Jul 2008 09:12:50 +0900
Message-ID: <43c2e3d60807161712y3ebfcbe0r74be1bbc3240c674@mail.gmail.com>


Can you report the lock type and mode?
Using query like this?

select
  chr(to_char(bitand(&p1,-16777216))/16777215)||

      chr(to_char(bitand(&p1, 16711680))/65535) "lock",     to_char(bitand(&p1, 65535) ) "mode" from dual
;

Dion Cho

2008/7/17 Dba DBA <oracledbaquestions_at_gmail.com>:

> I am having problems with a DFS Lock wait. I am copying data from table to
> another and no data is being copied (I can tell this by looking to see if
> the segment size is increasing).
> I so found this.
>
> http://forums.oracle.com/forums/thread.jspa?messageID=2231833
>
> I then went to metalink and look up the bug. There is not much there. I did
> not even see the recommendation to bounce one node in the cluster in the bug
> report. I have seen this poster on several forums for a number of years. He
> seems to know what he is doing.
>
> where do you get the bug report info? To get details do I need to open a
> TAR? I searched the bug database and though the bug exists, there is not
> much there.
>
> We just migrated to 10.2.0.4, using 7 RAC nodes, with ASM.
>
> I plan to bounce the whole cluster including ASM, but this is not something
> I can do during the day. Has anyone else seen this ?
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 16 2008 - 19:12:50 CDT

Original text of this message