Re: How to generate a lot of load on an Oracle database?
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: cichomitiko@xxxxxxxxx
- Date: Fri, 18 Nov 2005 13:44:06 -0500
On 11/18/05, Radoulov, Dimitre <cichomitiko@xxxxxxxxx> wrote:
>
>
> >>> We need to test the maximum I/O throughput of our SAN storage system and
> therefore need an Oracle database to generate so much load that >>> there is
> an I/O bottleneck. Does anybody out there have open source tools or Oracle
> scripts for that?
>
> Just an idea (quick and dirty): there are a couple of sql scripts to
> generate "load" that Oracle provides with the VMware/Linux/Oracle RAC image
> demo kit for the EM Advisors presentation that may be usefull.
>
>
> Regards,
> Dimitre Radoulov
quick and dirty?
for win32 ... on the server console
in sqlplus ...
spool
set pga_workarea_policy manual
hike sort_area_size
hike dbfmbrc
take a statspack snapshot
fire up filemon.exe (from sysinternals), filter for the mount points of interest
exec dbms_stats.gather_database_stats(cascade=>true ...);
stop capture of filemon.exe, save the file
take a statspack snapshot
dump a statspack report
upload the filemon.exe log into excel
works for me.
Paul
--
#/etc/init.d/init.cssd stop
-- play a Sony CD, install a rootkit today
--
//www.freelists.org/webpage/oracle-l
Other related posts:
