RE: How to crash Your instance with simple CTAS
From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Fri, 2 Dec 2011 15:16:29 +0000
Message-ID: <BD475CE0B3EE894DA0CAB36CE2F7DEB4454D461C_at_LITIGMBCRP02.Corp.Acxiom.net>
This would be a great item to use when testing failover, but unfortunately under 10.2.0.2 it only crashes my session, not the instance. Man, even bugs don't work properly in this release!
1501 Opus Pl, Downers Grove, IL 60515, USA WWW.ACXIOM.COM The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you.
Date: Fri, 2 Dec 2011 15:16:29 +0000
Message-ID: <BD475CE0B3EE894DA0CAB36CE2F7DEB4454D461C_at_LITIGMBCRP02.Corp.Acxiom.net>
This would be a great item to use when testing failover, but unfortunately under 10.2.0.2 it only crashes my session, not the instance. Man, even bugs don't work properly in this release!
DAVID HERRING
DBA
Acxiom Corporation
EML dave.herring_at_acxiom.com TEL 630.944.4762 MBL 630.430.5988
1501 Opus Pl, Downers Grove, IL 60515, USA WWW.ACXIOM.COM The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Grzegorz Goryszewski
Sent: Thursday, December 01, 2011 12:52 PM
To: oracle-l_at_freelists.org
Subject: How to crash Your instance with simple CTAS
Hi,
something like that
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 :)
Regards
GregG
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 02 2011 - 09:16:29 CST