RE: Size of Global temporary table.
From: Yong Huang <yong321_at_yahoo.com>
Date: Sun, 5 Jul 2009 08:15:41 -0700 (PDT)
Message-ID: <388648.73660.qm_at_web80604.mail.mud.yahoo.com>
Date: Sun, 5 Jul 2009 08:15:41 -0700 (PDT)
Message-ID: <388648.73660.qm_at_web80604.mail.mud.yahoo.com>
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jul 05 2009 - 10:15:41 CDT