RE: Size of Global temporary table.

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Sun, 5 Jul 2009 16:07:31 -0700 (PDT)
Message-ID: <630939.11759.qm_at_web45011.mail.sp1.yahoo.com>

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_at_yahoo.com> wrote:

From: Yong Huang <yong321_at_yahoo.com>
Subject: RE: Size of Global temporary table. To: fairlie_r_at_yahoo.com
Cc: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jul 05 2009 - 18:07:31 CDT