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.

With a recreatable test case in 10.2 the first thing to do is to submit a service request and get it into oracle and acknowledged as a bug. Received on Wed Sep 27 2006 - 13:19:35 CDT