Re: How to crash Your instance with simple CTAS
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Thu, 1 Dec 2011 13:34:37 -0600 (CST)
Message-ID: <1be9d98e571efea983b6871670dfb2a6.squirrel_at_society.servebeer.com>
> create table t as (select * from dba_users minus select * from dba_users
> where mod(user_id,2) = 0 ) order by dbms_random.value
>
> can crash You session in 9,10,11 and in 10.2.0.3 instance as well :).
> Dont ask me how do I know :)
Date: Thu, 1 Dec 2011 13:34:37 -0600 (CST)
Message-ID: <1be9d98e571efea983b6871670dfb2a6.squirrel_at_society.servebeer.com>
> create table t as (select * from dba_users minus select * from dba_users
> where mod(user_id,2) = 0 ) order by dbms_random.value
>
> can crash You session in 9,10,11 and in 10.2.0.3 instance as well :).
> Dont ask me how do I know :)
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!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 01 2011 - 13:34:37 CST