RE: ORA-600
- From: "Wolfson Larry - lwolfs" <lawrence.wolfson@xxxxxxxxxx>
- To: <swhite@xxxxxxxxxxxxx>, "Jared Still" <jkstill@xxxxxxxxx>
- Date: Tue, 3 Oct 2006 09:17:11 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxx]
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@xxxxxxxxxxxxx> 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.
****************************************************************************
Other related posts:
