--------------------------------------------------------------------------------
--
-- File name:   lotslios.sql
-- Purpose:     Generate Lots of Logical IOs for testing purposes
--
-- Author:      Tanel Poder
-- Copyright:   (c) http://www.tanelpoder.com
--              
-- Usage:       @lotslios <number>
--              @lotslios 100
--              @lotslios 1000000
--	        
-- Other:       As the script self-joins SYS.OBJ$ to itself the maximum number
--              of rows processed (and LIOs generated) depends on the number
--              of rows in SYS.OBJ$
--
--------------------------------------------------------------------------------

select 
    /*+ ordered use_nl(b) full(a) full(b) */ 
    count(*) 
from 
    sys.obj$ a, 
    sys.obj$ b 
where 
    a.name = b.name
and rownum <= &1
/