AW: Temp usage on Linux vs solaris
Date: Tue, 21 Jun 2011 06:28:11 +0000
Message-ID: <09011014EB621E4CBC2536B62A1B64071E7A6558_at_SMXC001.trivadis.com>
Plan_hash_value depends also on endianness. If the old and new system has different endian , you would need to compare all steps of execution plans to be sure, if the execution plan really changed.
Best Regards,
Petr
Von: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org]" im Auftrag von "Greg Rahn [greg_at_structureddata.org] Gesendet: Dienstag, 21. Juni 2011 08:10
Bis: Kumar Madduri
Cc: oracle Freelists
Betreff: Re: Temp usage on Linux vs solaris
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<mailto: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:28:11 CDT