Re: "Delete From <table>" taking all day

        This could be a rollback segment sizing problem - check the size and number of extents allocated to the default rollback segment. Also consider using the TRUNCATE TABLE command which doesn't require rollback resource usage.

meskillw_at_ncr.disa.mil (Bill Meskill) wrote:

>Hi,
>I have a 4000 row table that's taking quite a long
>time to delete. What's going on?
 

>Bill Meskill
 

>FYI. I have my data and indexes separated on lots of
>different disks and have allocated 80M for the
>SGA (a full database export is 10M). There are only
>2 people on the server.
Received on Tue Aug 20 1996 - 00:00:00 CEST