Oracle-L: RE: TEMP_SPACE in V$SQL

From: Richard Huntley <rhuntley_at_mindleaders.com>
Date: Fri, 28 Jun 2002 13:00:25 -0800
Message-ID: <F001.0048BDD3.20020628130025@fatcity.com>

Bill...You can find it in the docs for 9iR2... http://docs.oracle.com/cd_a97630/server.920/a96536/ch3194.htm#1101574

-----Original Message-----
Sent: Friday, June 28, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L

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).

--

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

Author: Richard Huntley
INET: rhuntley_at_mindleaders.com

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

RE: TEMP_SPACE in V$SQL_PLAN