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

Giganews Newsgroups
Subject: 10g Rel 2 Problems, Possible DOS threat????
Posted by:  Geek.Empiā€¦@gmail.com
Date: 27 Sep 2006

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.

Replies