RE: Size of Global temporary table.
- From: "Paresh Patel" <paresh.patel@xxxxxxxxxxxxxx>
- To: "Alex Fatkulin" <afatkulin@xxxxxxxxx>
- Date: Thu, 2 Jul 2009 12:23:12 -0700
I checked that view, but it doesn't contain information about GTT
segment. All I can see in that view is temporary space occupied by sort
and group by operations.
Thanks,
Paresh Patel,
-----Original Message-----
From: Alex Fatkulin [mailto:afatkulin@xxxxxxxxx]
Sent: Thursday, July 02, 2009 12:11 PM
To: Paresh Patel
Cc: oracle-l
Subject: Re: Size of Global temporary table.
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:
