Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk

From: Greg Rahn <>
Date: Mon, 14 Nov 2011 15:29:29 -0800
Message-ID: <>

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 <> 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  PGA%6MB in stage db , but problem is same with production db PGA=9G

Greg Rahn
Received on Mon Nov 14 2011 - 17:29:29 CST

Original text of this message