title: Oracle performance when dropping all tables
body: <p>I have the following Oracle SQL:</p>
  
  <pre><code>Begin
  
  -- tables
  for c in (select table_name from user_tables) loop
  execute immediate ('drop table '||c.table_name||' cascade constraints');
  end loop;
  
  -- sequences
  for c in (select sequence_name from user_sequences) loop
  execute immediate ('drop sequence '||c.sequence_name);
  end loop;
  
  End;
  </code></pre>
  
  <p>It was given to me by another dev, and I have no idea how it works, but it drops all tables in our database.</p>
  
  <p>It works, but it takes forever!</p>
  
  <p><img src="https://i.stack.imgur.com/jDGsA.png" alt="Script Output"></p>
  
  <p>I don't think dropping all of my tables should take that long.  What's the deal?  And, can this script be improved?</p>
  
  <p><em>Note:</em> There are somewhere around 100 tables.</p>