script to generate TEMP tablespace READS?

From: <Christopher.Taylor2_at_parallon.net>
Date: Tue, 6 Nov 2012 09:11:30 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E88564D7666F_at_NADCWPMSGCMS10.hca.corpad.net>

I need a test script to generate TEMP tablespace READS - I'm able to generate writes but I'm not getting any reads (or very few). Anyone have a simple script to do that?

The reason for this is to test the filesystem/san throughput down the path where the temp tablespace tempfiles reside.

Chris Taylor
Oracle DBA
Parallon IT&S
christopher.taylor2_at_parallon.net<mailto:christopher.taylor2_at_parallon.net> www.parallon.net

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 06 2012 - 16:11:30 CET