Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk
From: Denis <denis.sun_at_yahoo.com>
Date: Mon, 14 Nov 2011 13:47:42 -0800 (PST)
Message-ID: <1321307262.38423.YahooMailNeo_at_web161806.mail.bf1.yahoo.com>
While the sqldeveloper session is running, I also try to generate sql monitor reprot in hoping to see at exactly which step of the execution plan it is , but although it is running for hours it (sql + sql_id) did not appear in v$sql_monitor at all
With the timing going, the temp space used by the session can easily > 20GB while doing hash join
The pga is:
Date: Mon, 14 Nov 2011 13:47:42 -0800 (PST)
Message-ID: <1321307262.38423.YahooMailNeo_at_web161806.mail.bf1.yahoo.com>
While the sqldeveloper session is running, I also try to generate sql monitor reprot in hoping to see at exactly which step of the execution plan it is , but although it is running for hours it (sql + sql_id) did not appear in v$sql_monitor at all
With the timing going, the temp space used by the session can easily > 20GB while doing hash join
The pga is:
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_target big integer 256M ________________________________
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 14 2011 - 15:47:42 CST