Re: script to generate TEMP tablespace READS?

1. Create global temporary table
2. Insert required amounts of data
3. Set "_serial_direct_read"=always in your session

Now any query against the temp table will result in "'direct path read temp". You can mode different access patterns by changing access paths.

On Tue, Nov 6, 2012 at 10:11 AM, <Christopher.Taylor2_at_parallon.net> wrote:
> 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
>
>

-- 
Alex Fatkulin,
http://afatkulin.blogspot.com

Enkitec,
http://www.enkitec.com
--
http://www.freelists.org/webpage/oracle-l