Re: 10g Rel 2 Problems, Possible DOS threat????

Geek.Empire_at_gmail.com wrote:
> While upgrading a 9i database to 10g Rel 2 we came across some bad
> code. When executed this code would cause that sql session to fully
> consume one whole CPU and never return even if the user canceled the
> session. I'm sure you can see where this would lead. We have been
> able to recreate this with the following code:
>
> DECLARE
> TYPE DOSTestTab IS TABLE OF dual.dummy%TYPE;
> vDTab DOSTestTab;
> CURSOR c_DOScursor IS
> SELECT dummy BULK COLLECT INTO vDTab FROM dual;
> BEGIN
> OPEN c_DOScursor ;
> FETCH c_DOScursor BULK COLLECT INTO vDTab;
> CLOSE c_DOScursor ;
> END;
>
> This, although very bad looking code, did work in 9.2.0.x.

Definitely repeatable. Please open an SR with this at metalink.

I'll save it off for 11g.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group