Hi,
I'm working on an Oracle Database 11g Release 11.1.0.6.0 - 64bit Production With the Real Application Clusters option.
On friday I run an:
ALTER TABLE DW.T_EVENT_DATA_HIST SET UNUSED ADDRESS;
ALTER TABLE DW.T_EVENT_DATA_HIST DROP UNUSED COLUMNS;
Then, for a particular reason I had to stop the drop and I restart it using
ALTER TABLE dw.t_event_data_hist drop columns continue;
At this momen, after almost 3 days, the ALTER is still running.
The table was about 500GB and the address columns was almost the 70% of the table size.
My question is how I can know how long I still have to wait the query to end.
I cannot find it into the v$session_longops.
Using the Enterprise Manager I found this value:
physical read total bytes 222343790592 (222gb)
Could be that an indicator of how much is missing to be read (almost half of table)?
Is there any other way to achieve my goal?
Thanks in advance,
Samuel