Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: A strange space issue problem

Re: A strange space issue problem

From: S Acharya <sujit_at_oil.asm.nic.in>
Date: Fri, 16 Feb 2001 18:29:52 -0800
Message-ID: <F001.002B73E9.20010216181528@fatcity.com>

Pl. check available contiguous space for extend in the tablespace and next extend size for the segment.
sujit
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, February 16, 2001 11:31 PM

> Hi all,
>
> I am experiencing a problem and am in need of your opnions.
>
> I have a table which has two columns, one is a NUMBER, one is a LONG RAW.
> The LONG RAW column is used to store
> a Java Serialized Object of a size about 5k to 12k. We get about 15000
rows
> per day. Each night the old rows are purged
> to make room for the new ones. This worked fine for over 6 months, except
> once the table failed to extend because
> the purge job was broken and we didn't have enough space.
>
> But about a week ago, I am starting to see ORA-1653: unable to extent
table
> message appear in alert log randomly. The
> purge job is running fine and did free up space. Only around 20 out of
> 15000 caused the error message. At first I suspect those
> failed ones must be trying to put in something BIG. But after the
developer
> debugged it, he told me the size of the binary
> is only between 6-8k of the failed ones which is no larger than the
others.
> So now I am really puzzled. I have one
> transaction that's trying to stick an 8k LONG ROW into the table and it
> failed with ORA-1653 and the next whole bunch
> of transactions going into the table successfully with the same size or
even
> bigger. And there is no delete happened between
> those transactions. Nothing is deleted from the database except the
nightly
> purge job which only deletes from that table.
>
> I suspect there is something that the developer didn't find out, but I
want
> to rule out the possibility that it's the database
> that's causing the problem.
>
> Thanks in advance for any suggestions, comments, even if it's a shot in
the
> dark.
>
>
> Richard Ji
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Richard Ji
> INET: richard_at_letsplay.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: S Acharya
  INET: sujit_at_oil.asm.nic.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Feb 16 2001 - 20:29:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US