RE: Growing table

Terry,

        Do you know how the app is inserting rows into the tables? It their using the append method then new blocks always get used.=20

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----

From: Terry Sutton [mailto:terrysutton_at_usa.net]=20 Sent: Friday, November 12, 2004 12:03 PM To: oracle-l_at_freelists.org
Subject: Re: Growing table

Dick,

Unfortunately there's no foreign key (something I'm not happy with), but I
don't think that's the problem. The ratio of rows in DATA to row in INFO
stays around 5, so the app seems to be deleting appropriately. The growth
isn't in the number of rows, it's just in the number of blocks they consume.
As it stands right now, there is roughly 1 DATA row per 3-4 blocks! I could
see this if the number of DATA rows had grown to 4 million at some point,
but it hasn't. Frustrating.

Thanks,

--Terry

• Original Message -----=20 From: "Goulet, Dick" <DGoulet_at_vicr.com> To: <oracle-l_at_freelists.org> Sent: Friday, November 12, 2004 8:45 AM Subject: RE: Growing table

Terry,

Are these two tables parent-child constrained together? It's quite possible that you web application is deleting the INFO table records without taking care of the DATA records. A simple foreign key constraint with "on delete cascade" may well fix it.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

--

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

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 12 2004 - 11:21:36 CST