RE: Temporary table vs pl\sql table
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <AmihayG@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 30 Nov 2005 09:45:21 -0500
Temporary table will reside in memory as long as it fits sort_area_size.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Amihay Gonen
Sent: Wednesday, November 30, 2005 3:43 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Temporary table vs pl\sql table
Hi , I've a process which need to do a lot of processing (summaries) on
a large set of data.
The main flow is as follow:
copy the new rows since last run (up to defined row count) to a
temporary table.
Run various selects with group by on the temporary table and merge
them into summary table.
I wander (I will conduct some tests ofcourse ) what type of temporary
table will be better:
1) create ... temporary table or ...
2) create type test is table of
The first option has more i/o and go throw the buffer cache , but
doesn't consume a lot of memory
the second option doesn't has I/O but consume more memory for the PGA.
Any ideas ?
Other related posts:
