Re: Temp usage on Linux vs solaris
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Mon, 20 Jun 2011 16:17:14 -0700 (PDT)
Message-ID: <402588.65907.qm_at_web65406.mail.ac4.yahoo.com>
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_at_gmail.com> To: oracle Freelists <Oracle-L_at_freelists.org> 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
Date: Mon, 20 Jun 2011 16:17:14 -0700 (PDT)
Message-ID: <402588.65907.qm_at_web65406.mail.ac4.yahoo.com>
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_at_gmail.com> To: oracle Freelists <Oracle-L_at_freelists.org> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 20 2011 - 18:17:14 CDT