Re: Bulk Collect without LIMIT

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 12 Jan 2006 08:45:34 -0800
Message-ID: <1137084334.352445.231660@g44g2000cwa.googlegroups.com>

I do believe that the maximum size of a pl/sql table (array) is officially OS dependent so the odds are that you will get a memory related error prior to hitting the row limit. Back in version 7 days we tested and hit the limit at about 10M. I have no idea how large we can make a pl/sql table today except that I know I have gone past 10M.

If anyone has tested or has current large pl/sql tables that they can estimate memory usage for based on row counts I would be interested in seeing the numbers.

HTH -- Mark D Powell -- Received on Thu Jan 12 2006 - 10:45:34 CST