Re: Size of Global temporary table.

From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Thu, 2 Jul 2009 15:11:05 -0400
Message-ID: <49d668000907021211r905d005la160c49ace00dbc9_at_mail.gmail.com>

you can reference v$tempseg_usage to find GTT's temporary segment size, if this is what you're looking for

On Thu, Jul 2, 2009 at 3:07 PM, Paresh Patel<paresh.patel_at_mantis-tgi.com> wrote:
> Listers,
>
>
>
> I have a Global temporary table which gets populated by a PL/SQL procedure.
> Once it is populated, it’s used by some other SQLs in the same session. Does
> anyone have any idea how can I find out the size of GTT when it is fully
> populated?
>
>
>
> Thanks in advance!
>
>
>
> Thanks,
>
> Paresh Patel,
>
>

-- 
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 02 2009 - 14:11:05 CDT