TEMP_SPACE in V$SQL_PLAN

From: Bill Buchan <wbuchan_at_uk.intasys.com>
Date: Fri, 28 Jun 2002 10:53:30 -0800
Message-ID: <F001.0048BB54.20020628105330@fatcity.com>

Does anyone have any info on the TEMP_SPACE column for V$SQL_PLAN? This column does event appear in the documentation for the view in 9.0.1.

I've heard that the CBO can now guess the amount of sort space that a query plan will use. Is this correct or it is just wishful thinking? And if so, is the TEMP_SPACE column the place to look? It is empty for all but one query on my test database which seems a bit odd. Also, is it possible to get at this information via EXPLAIN PLAN?

Thanks for any help,
- Bill.

--

Intasys Billing Technologies Ltd. www.intasysbilling.com 74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX tel (0)131 625 8200 fax (0)131 625 8201 email wbuchan_at_uk.intasys.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bill Buchan
  INET: wbuchan_at_uk.intasys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 28 2002 - 13:53:30 CDT