Re: Size of Global temporary table.
- From: Alex Fatkulin <afatkulin@xxxxxxxxx>
- To: paresh.patel@xxxxxxxxxxxxxx
- Date: Thu, 2 Jul 2009 15:26:23 -0400
you should see segment type data
SQL> create global temporary table gtt (n number);
Table created
SQL> insert into gtt values (1);
1 row inserted
SQL> select blocks, segtype
2 from v$tempseg_usage
3 where session_addr=(select saddr from v$session where
sid=sys_context('userenv', 'sid'));
BLOCKS SEGTYPE
---------- ---------
128 DATA
On Thu, Jul 2, 2009 at 3:23 PM, Paresh Patel<paresh.patel@xxxxxxxxxxxxxx> wrote:
> 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,
>
>
--
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
//www.freelists.org/webpage/oracle-l
Other related posts:
