Re: script to generate TEMP tablespace READS?
- From: Alex Fatkulin <afatkulin@xxxxxxxxx>
- To: Christopher.Taylor2@xxxxxxxxxxxx
- Date: Tue, 6 Nov 2012 11:36:36 -0500
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@xxxxxxxxxxxx> 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@xxxxxxxxxxxx<mailto:christopher.taylor2@xxxxxxxxxxxx>
> www.parallon.net
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
Alex Fatkulin,
http://afatkulin.blogspot.com
Enkitec,
http://www.enkitec.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
