Long Operation

From: Gordon T. Wu <wutao19_at_yahoo.com>
Date: Thu, 6 Nov 2003 09:05:50 -0500
Message-ID: <2zsqb.294$Er.31320@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 Received on Thu Nov 06 2003 - 08:05:50 CST