Re: Temp usage on Linux vs solaris

From: Greg Rahn <greg_at_structureddata.org>
Date: Mon, 20 Jun 2011 23:10:18 -0700
Message-ID: <BANLkTi=JP8XENLcp5BNb5BrDwbCE1qepOQ_at_mail.gmail.com>

Recommendations on triaging:
1) What are the parameter differences (anything that could impact execution plans)
2) For a given query with the issue, look at the before and after plans and try and figure out what is causing this (get a 10053 trace and diff it)

Once you get #2 and look into the cause for the diff, then it can be analyzed on what could be causing it.

Understand that the increased temp usage is the effect (symptom) of plans changing and you want to get to the root cause of why that is the case. If you have AWR data for both systems you can look at {sql_id, plan_hash_values} comparisons assuming all the objects are identical.

On Mon, Jun 20, 2011 at 10:35 PM, Kumar Madduri <ksmadduri_at_gmail.com> wrote:

> To minimize issues with version differences we maintained the version of
> rdbms s (11.1.0.7) between solaris and linux and another change to init.ora
> was not to use memory_target and memory_max-target (that should not matter I
> hope in this particular case thoug h. We are using sga_target and
> sga_max_size )
>

-- 
Regards,
Greg Rahn
http://structureddata.org

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

Received on Tue Jun 21 2011 - 01:10:18 CDT