• Great article, but BTW, flushing the shared pool in oracle does not clear the buffer cache with the data blocks in them.

    It only clears the SQL statement from the shared pool.  The SQL statement will be reparsed the next time you run, but typically only takes a fraction of a second.

    Oracle 10g will allow you to clear the actual buffer pools.