RE: ORA-600

Hey, Jared, how are you doing?  

  We had a 8.1.6. DB with blobs. I wrote a query to summarize average length per day and saw size had become dramatically larger. Found some users had switched from pictures to video. We auto-extended files, but they were getting so large we started creating and dropping a dummy table daily to allocate space before the app needed it. We also had a problem with CF updates and addressed that with EVENT 10359 LEVEL1, courtesy of Tanel Poder.  

    They did upgrade to 9.2.0.4  

    Larry

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Susan White Sent: Tuesday, October 03, 2006 7:46 AM
To: Jared Still
Cc: ORACLE-L
Subject: RE: ORA-600

Good morning Jared,  

I believe he used the "getlength' function to find those of 0 (I assume) length and then used EMPTY_BLOB() to "initialize" it.  

Thanks  

Susan    

From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Monday, October 02, 2006 4:49 PM
To: Susan White
Cc: ORACLE-L
Subject: Re: ORA-600  

On 10/2/06, Susan White <swhite_at_lifetouch.com> wrote:

        We have an 8.1.6 database running on Linux. One of the tables contains two blob columns. About 3 weeks ago, one of the admins decided to do maintenance on the blob columns by reinitializing those he determined had no data. At this point, the database started throwing ORA-600 errors and writing frequently to an smon trace file. We don't normally support this database, so I just heard about it today.

I'm curious about a couple things:

1. Howd did the admin detemine that the blob 'had no data'?
2. What exactly is 'reinitialize'?

-- 

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist




______________________________________________________________________

This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 


______________________________________________________________________


***************************************************************************
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.
****************************************************************************

--
http://www.freelists.org/webpage/oracle-l