Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: resolving buffer busy waits
> I think this means you are using a non-unique index, is there any way
> you can add a unique one? A whole bunch of people trying to do the
> same thing might show your cyclical symptoms, since they each have to
> wait for many blocks to be available which they might not even care
> about. The cycle might be shortened noticeably if you can change it
> to index unique scan.
>
> jg
wish it were that simple honestly, but this is a third-party product. means going back to the vendor. but i am testing possiblilities just to see what they say ...
more weird activity: recent query on dba_data_files hung on a file open wait (i assume accessing a controlfile) and only completed when all the queueing sessions completed. start a new session now, same query, result back immediately as one would expect.
i have a horrible feeling the answer is right in front of me, but w/the unix team denying IO issues (and my checking seemingly prove they are correct) and oracle not playing nice ... am sort of feeling a bit beat at the mo'.
think you also asked about the controllers: 2 mirrored a5200's. Received on Thu Sep 18 2003 - 09:24:05 CDT