Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk
From: Greg Rahn <greg_at_structureddata.org>
Date: Mon, 14 Nov 2011 15:29:29 -0800
Message-ID: <CAGXkmisf2hJhH_xnK2nX=yYMZLkMWhDsURekKojjrqv3=R4GLg_at_mail.gmail.com>
You dont need a tool - you can use the plan hash value.
Date: Mon, 14 Nov 2011 15:29:29 -0800
Message-ID: <CAGXkmisf2hJhH_xnK2nX=yYMZLkMWhDsURekKojjrqv3=R4GLg_at_mail.gmail.com>
You dont need a tool - you can use the plan hash value.
Second, how much memory do you have on this system? Only a 9GB PGA (or is it 256MB)? Seems quite small by today's standards, especially if you have tens of GB of RAM on this system and aren't running numerous instances.
On Mon, Nov 14, 2011 at 1:19 PM, Denis <denis.sun_at_yahoo.com> wrote:
> Comparing execution plan from sqlplus and from sqldevloper is impossible by visual checking as it has 1000+ line. (anyone know a tool to compare execution plan based on sql_id? )
>
> BTW Oracle 11.2.0.1.0 PGA%6MB in stage db , but problem is same with production db PGA=9G
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 14 2011 - 17:29:29 CST