Re: Size of Global temporary table.
- From: Alex Fatkulin <afatkulin@xxxxxxxxx>
- To: paresh.patel@xxxxxxxxxxxxxx
- Date: Thu, 2 Jul 2009 15:11:05 -0400
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@xxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
