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

  • From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • To: denis.sun@xxxxxxxxx
  • Date: Mon, 14 Nov 2011 15:29:29 -0800

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@xxxxxxxxx> 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

Other related posts: