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

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

A strange space issue problem

From: Richard Ji <richard_at_letsplay.com>
Date: Fri, 16 Feb 2001 10:23:05 -0800
Message-ID: <F001.002B6AC4.20010216100117@fatcity.com>

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). Received on Fri Feb 16 2001 - 12:23:05 CST

Original text of this message

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