RE: dynamically generated temp objects?

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Thu, 08 May 2003 06:42:33 -0800
Message-ID: <F001.00593B68.20030508064233@fatcity.com>

Guys,

I am doing a query on one table then a join with 2 other tables - one sql statement. The strange thing is that I see in the explain plan: temp table generation. Then a lookup on these temporary tables called ora_temp_201e. I have not specified the generation of temporary tables. I am using tempfile for sorting but have a large sort_area_size (few megs). I noticed that these "temporary" dynamically generated tables were created after I specified certain fields and values in the predicate on one of the tables.

Can someone explain these objects - when Oracle generates them, what versions of Oracle, under what circumstances and any papers/books where information about them can be obtained?

--

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

Author:
  INET: Paula_Stankus_at_doh.state.fl.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Thu May 08 2003 - 09:42:33 CDT