Re: Growing table

From: Terry Sutton <terrysutton_at_usa.net>
Date: Fri, 12 Nov 2004 09:03:28 -0800
Message-ID: <009101c4c8d9$e5653490$6601a8c0@TerrySutton>

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 ----- 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 Received on Fri Nov 12 2004 - 11:05:16 CST