Re: Size of Global temporary table.

From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Thu, 2 Jul 2009 15:26:23 -0400
Message-ID: <49d668000907021226k262b9bcdr5271e45a8061750d_at_mail.gmail.com>

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_at_mantis-tgi.com> 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
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 02 2009 - 14:26:23 CDT