RE: Growing table
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Nov 2004 12:25:11 -0500
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@xxxxxxx]=20
Sent: Friday, November 12, 2004 12:03 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
