title: Tracking drop column progress in Oracle
body: <p>I have issued following statement in Oracle on a huge table (1.8 TB size):</p>
  
  <pre><code>alter table drop unused columns checkpoint
  </code></pre>
  
  <p>It has been running for almost 10 days now, crashing a couple of times due to lack of memory.</p>
  
  <p>I resumed it with :</p>
  
  <pre><code>alter table drop columns continue
  </code></pre>
  
  <p>How can I track the progress and possibly get an estimate of the finish time?</p>
  
  <p>I tried querying v$session_longops but there are no records for this session.</p>