Sorry I meant 11.2 beta which should come out post OOW Fairlie Rego Senior Oracle Consultant http://el-caro.blogspot.com/ M: +61 402 792 405 --- On Mon, 6/7/09, Yong Huang <yong321@xxxxxxxxx> wrote: From: Yong Huang <yong321@xxxxxxxxx> Subject: RE: Size of Global temporary table. To: fairlie_r@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Received: Monday, 6 July, 2009, 1:15 AM > I believe this is a currently limitation in the code... > > Bug 7210183 > SQL_ID VALUE IS NOT SAME IN V$TEMPSEG_USAGE AND OTHER VIEWS. > > addresses this issue. Haven't checked this in 11.2 yet 11.2? I just checked OTN. The latest 11g is still 11.1.0.7. Indeed the definition of GV$SORT_USAGE in v$fixed_view_definition says the SQL columns are PREV_sql_%. I should've looked there first. I checked it in a 11.1.0.7 database. The definition is still the same. Yong Huang ____________________________________________________________________________________ Access Yahoo!7 Mail on your mobile. Anytime. Anywhere. Show me how: http://au.mobile.yahoo.com/mail