Re: How to crash Your instance with simple CTAS
From: Grzegorz Goryszewski <grzegorzof_at_interia.pl>
Date: Thu, 01 Dec 2011 20:44:14 +0100
Message-ID: <4ED7D90E.2000003_at_interia.pl>
On 2011-12-01 20:34, Rich Jesse wrote:
> Even simpler, forget the CTA part and run just the SELECT. It may be
> related to the fact that DBMS_RANDOM.VALUE returns a non-whole number 0<=1,
> which doesn't probably do what you were hoping it to do. But I was only
> able to get it to fail when some MINUS clause was used (the WHERE clause
> didn't seem to matter).
>
> In any case, it shouldn't disconnect the session...
>
> Nice one!
Thats true , minus is necessary and order by dbms_random.value . Not sure about create table thou.
Regards
GregG
Date: Thu, 01 Dec 2011 20:44:14 +0100
Message-ID: <4ED7D90E.2000003_at_interia.pl>
On 2011-12-01 20:34, Rich Jesse wrote:
> Even simpler, forget the CTA part and run just the SELECT. It may be
> related to the fact that DBMS_RANDOM.VALUE returns a non-whole number 0<=1,
> which doesn't probably do what you were hoping it to do. But I was only
> able to get it to fail when some MINUS clause was used (the WHERE clause
> didn't seem to matter).
>
> In any case, it shouldn't disconnect the session...
>
> Nice one!
Thats true , minus is necessary and order by dbms_random.value . Not sure about create table thou.
Regards
GregG
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 01 2011 - 13:44:14 CST