Re: DFS Lock issue, RAC, ASM, and oracle bug reports
Date: Thu, 17 Jul 2008 09:12:50 +0900
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"
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.
> 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 ?