Size of Global temporary table.
From: Paresh Patel <paresh.patel_at_mantis-tgi.com>
Date: Thu, 2 Jul 2009 12:07:18 -0700
Message-ID: <1F59FE5D79A73248B7BEBE37907CC53B021B91B0_at_mantis.mantis-tgi.com>
Listers,
Date: Thu, 2 Jul 2009 12:07:18 -0700
Message-ID: <1F59FE5D79A73248B7BEBE37907CC53B021B91B0_at_mantis.mantis-tgi.com>
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,
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 02 2009 - 14:07:18 CDT