Re: Need some ideas, WIN vs. LINUX... Same process on Win takes much less temp space than on Linux

I ran into something like that when I enabled parallel. It looked like each parallel slave was allocating the full amount the entire process might need. You might try disabling parallel in linux and see what happens. Thats pretty much a shot in the dark though.

On 9/26/07, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:
>
> So, I need some thoughts to bounce around here. Running 10.2 Standard
> edition on Win and 10.2 Enterprise edition on Linux RH 5. I have the same
> database, the same data. Building a Materialzed View on the Win box never
> requires the temporary tablespace be more than about 500mb. While on the
> LINUX box we are gobbling up about 175GB of space. Any idea why we might
> see
> such a vast difference?
>
> RF
>
> Robert G. Freeman
> Oracle Consultant/DBA/Author
> Principal Engineer/Team Manager
> The Church of Jesus Christ of Latter-Day Saints
> Father of Five, Husband of One,
> Author of various geeky computer titles
> from Osborne/McGraw Hill (Oracle Press)
> Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com
> !
> BLOG: http://robertgfreeman.blogspot.com/
> Sig V1.2
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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