Re: Temp usage on Linux vs solaris
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: "ksmadduri@xxxxxxxxx" <ksmadduri@xxxxxxxxx>, oracle Freelists <Oracle-L@xxxxxxxxxxxxx>
- Date: Mon, 20 Jun 2011 16:17:14 -0700 (PDT)
Are your SGA/memory settings the same on Linux as they were on Solaris? To
what values are sort_area_size and hash_area_size set? Have you monitored
who's using the TEMP space, how much they're using and what statements are the
largest offenders? Is the TEMP tablespace sized the same on Linux as it was on
Solaris? Have you traced sessions with strace?
David Fitzjarrell
From: Kumar Madduri <ksmadduri@xxxxxxxxx>
To: oracle Freelists <Oracle-L@xxxxxxxxxxxxx>
Sent: Monday, June 20, 2011 2:26 PM
Subject: Temp usage on Linux vs solaris
Hi
We recently migrated our ebiz solaris db to linux. We have some bad queries in
solaris which take up temp segment (I mean mor than what it should take if the
query was properly written in the first place).
Since we migrated to LInux, the queries are as bad as ever but we see more
ORA-1652 errors now than we were on Solaris.
We are trying to identify the sql_id and report that to developers. But have
any of you noticed increased temp space usage after migration to linux from
solaris.
Thank you
Kumar
Other related posts: