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

Possibly compare pga_aggregate_target, but that would not explain the
vast difference.  If the difference were in megabytes (rather than
gigabytes) this would be the first place I would look.

Another possibility is that statistics are stale one or both machines,
so execution plans are not the same ?

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Robert Freeman
Sent: Wednesday, September 26, 2007 11:39 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Need some ideas, WIN vs. LINUX... Same process on Win takes
much less temp space than on Linux

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


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


Other related posts: