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@xxxxxxxxx>: > 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 ? >