Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table keeps growing inspite of purging
Sasha Ostojic wrote:
>
> I have an application that writes several hundred records to a table every
> few minutes. There is a cron job that runs every hour that deletes records
> older than two days from this table. This has been running now for about
> three months. The problem is that I noticed that the table is growing over
> time (the number of extents is growing). I would have expected it to reach
> a certain size (after two days), and then the space freed by deleted records
> would be reused. The table has one index, and it is still growing as well.
>
> The table is created with PCTFREE 5 and PCTUSED 60. The index is PCTFREE 5.
>
> Why is my table still growing?
>
> Thanks in advance.
>
> .sasha
Hi,
The High Water Mark won't change if you use delete command.
AMAR
-- ****************************************************************************** AMARENDRA B NETTEM 5039 N E River Road, Apt. 1A Oracle Certified DBA (OCP) NORRIDGE, IL 60656 Whittman-Hart Inc., 311 South Wacker Drive, Suite 3500 Chicago, IL 60606. Ph.No. (708) 583 9870 (H) (312) 913 6758 (W) E-mail:nettama_at_charlie.cns.iit.edu, anettem_at_whittman-hart.com Homepage: http://www.iit.edu/~nettama **************************************************************************** Opinions are mine and do not necessarily reflect those of Whittman-hart Inc.Received on Thu Nov 20 1997 - 00:00:00 CST