Re: ORA-0600 SQL Statements

[Robert Freeman <robertgfreeman@xxxxxxxxx>]

Interesting Tim and potentially very evil... ;-), but
what I need is a SQL statement that generates an
ORA-0600... Need to test certain things that I can't
talk about...

RF

--- Tim Gorman <tim@xxxxxxxxx> wrote:


---------------------------------
    Robert,

Well, one sure-fire way I know is to type in "oracle"
at the UNIXcommand-prompt and just hit "return" -- you
get a nice little,serious-looking ORA-00600 [12235]
message in your "alert.log" file.�This has been true
since Oracle v6, at least.� In some situations,
youalso get a nice ".trc" file to go with it...

However, I also know it's a sure-fire way to excite
any DBAs who haveautomated monitoring of their
"alert.log" files and trace files, so becareful about
doing this from an inter-personal perspective...
;-)�...especially if they get paged on such errors
and you're doing thisexperimentation at 3am... :-)
...please don't ask how I would know that?

Tim Gormanconsultant - Evergreen Database
Technologies, Inc.P.O. Box 1802, Evergreen CO 
80437-1802website = http://www.evdbt.comemail   =
tim@xxxxxxxxxxxxxxx  = +1-303-885-4526fax     =
+1-303-484-3608


Robert Freeman wrote:        Hi folks....
  �
  Might sound like a silly question, but I'mlooking
for some SQL statements (the more basic the better) in
10gR2that will cause an ORA-0600 error. If you have
one and an associatedtest case that you could sent
that would be great. You can send to medirect mail
rather than through the newsgroup,
robertgfreeman@xxxxxxxxxx
  �
  RF
  �
  
Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for
Pre-sales onAmazon.com!
Sig V1.1 
      �
  


Robert G. Freeman
Author:
Now Available for Pre-Sales on Amazon.com!!!!
**************************************************
Oracle Database 11g New Features (Oracle Press)
**************************************************
Portable DBA: Oracle  (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Features (Oracle Press)
--
http://www.freelists.org/webpage/oracle-l

• Follow-Ups:
  • RE: ORA-0600 SQL Statements
    • From: Hallas, John (EXP N-ARM)

• References:
  • Re: ORA-0600 SQL Statements
    • From: Tim Gorman

Other related posts:

ORA-0600 SQL Statements

Re: ORA-0600 SQL Statements

Re: ORA-0600 SQL Statements

RE: ORA-0600 SQL Statements

RE: ORA-0600 SQL Statements