title: How to create a slow SQL query?
body: <p>I have a million row table in <code>Oracle 11g Express</code> and want to run a slow SQL select query so I can test stopping agents in various ways and observe the results on the database server. </p>
  
  <p>However no matter what I do, like self joins against a non-indexed column, selecting random rows using dbms_random, where/order by statements using non-indexed columns, the results all finish within a few seconds.</p>
  
  <p>Is there a query I can write that will make it take a few minutes?</p>