RE: A strange space issue problem

From: andrey <bronfin_at_visualtop.com>
Date: Mon, 19 Feb 2001 05:14:31 -0800
Message-ID: <F001.002B7D08.20010219043522@fatcity.com>

Probably there is no room in the rollback TBS rather than in the data one . Might it be possible ?

-----Original Message-----

Sent: Sat, February 17, 2001 12:11 AM
To: Multiple recipients of list ORACLE-L

The tablespace is not that fragmented. Any other suggestions?

-----Original Message-----

Winnie_Liu_at_infonet.com
Sent: Friday, February 16, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L

It's time to look into the tablespace and see if it is real fragmented!

Winnie

"Richard Ji" <richard_at_letsplay.com>@fatcity.com on 02/16/2001 10:01:17 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

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:
INET: Winnie_Liu_at_infonet.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

--

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: andrey
INET: bronfin_at_visualtop.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