Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Long Operation
"Gordon T. Wu" <wutao19_at_yahoo.com> schrieb im Newsbeitrag
news:2zsqb.294$Er.31320_at_mencken.net.nih.gov...
> Hi Group:
>
> I have an operation that is running all night, and still running. The
> operation involves deleting 4 tables:
>
> delete table a;
> delete table b;
> delete table c;
> delete table d;
>
> /*Rest of the code*/
>
> I have run query against v$session_longops and it is saying that the
> operation has already completed (sofar/totalwork = 1).
> But obviously it is still running since I'm not getting the sql prompt
back.
> Also, I have run a query against table a and it is showing that nothing
> actually got deleted.
>
> I have also run query against v$sgastat to monitor the free memory in SGA,
> it is showing the following:
> shared pool free memory 163.4 MB
> large pool free memory 16 MB
>
> Any help would be greatly appreciated.
>
>
>
> Gordon
>
Gordon,
Why do You not use
TRUNCATE TABLE a;
instead of
DELETE TABLE a;
?
In Your case You have no WHERE conditions for delete.
So a truncate would be *much* faster at does just what You want !
hth, Jan Received on Thu Nov 06 2003 - 08:11:58 CST