Re: DFS Lock issue, RAC, ASM, and oracle bug reports
- From: "조동욱" <ukja.dion@xxxxxxxxx>
- To: oracledbaquestions@xxxxxxxxx
- Date: Thu, 17 Jul 2008 09:12:50 +0900
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 ?
>
Other related posts:
