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

From: 조동욱 <>
Date: Thu, 17 Jul 2008 09:12:50 +0900
Message-ID: <>

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


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

Dion Cho

2008/7/17 Dba DBA <>:

> 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.
> 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, 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 ?

Received on Wed Jul 16 2008 - 19:12:50 CDT

Original text of this message