Re: Query to generate database activity

mwilliam06 wrote:
> I am currently studying to get my OCA I and am reading about AWR and
> ADDM optimization. I would like to find a query out there that would
> generate a substantial amount of I/O for a long period of time to
> better simulate a real world DB environment. Does anyone know where I
> might find such a script?
> Thanks in advance!
>
> Matt

I have one that I use when teaching ADDM as part of a Grid Control class that should run long enough to make you happy.

www.psoug.org
Click on Morgan's Library
Click on Grid Control
Scroll down to ADDM Workout

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group