Re: Temp usage on Linux vs solaris

From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Mon, 20 Jun 2011 17:31:49 -0700
Message-ID: <BANLkTinse_6TYRkbchmo=Oqa0j8DnCmYaw_at_mail.gmail.com>

Forgot to mention
(A) SGAs are sized similarly. In fact, it is 15% more on the linux boxes because these boxes had more memory than the solaris set.

(b) we have pga_aggregate_target
(c) We are monitoring the temp space but the point is in linux the same query (and it could be bad already in solaris) is taking more temp space than corresponding solaris env.

On Mon, Jun 20, 2011 at 4:17 PM, David Fitzjarrell <oratune_at_yahoo.com>wrote:

> Are your SGA/memoryiz 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-l

Received on Mon Jun 20 2011 - 19:31:49 CDT