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
>

If you really want to "simulate a real world DB environment", then one of the best places to look is at a real world application. Start a 10046 trace, level 4 to capture the bind variables. Then exercise your application. The resulting trace file will contain the SQL code the app issued against the DB. You now have a source for which to simulate those same actions against the DB.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown