Re: Temp tablespace full
From: joel garry <joel-garry_at_home.com>
Date: Mon, 11 Nov 2013 09:09:16 -0800 (PST)
Message-ID: <8c029c7e-fd18-4a4e-9711-e98b39383e14_at_googlegroups.com>
Date: Mon, 11 Nov 2013 09:09:16 -0800 (PST)
Message-ID: <8c029c7e-fd18-4a4e-9711-e98b39383e14_at_googlegroups.com>
On Sunday, November 10, 2013 3:04:45 PM UTC-8, Trevor A wrote:
> am getting the error Temp table-space full
Another thing to look at is PGA memory usage details for multipass executions. How exactly you would do that depends on things like your version, edition, and licensing. The general idea is allow more sort area in memory, so you don't have to use so much temp. But there could be other things going on that you are not telling us about.
jg
-- _at_home.com is bogus. http://readwrite.com/2013/11/08/in-the-age-of-twitter-do-we-need-oracleReceived on Mon Nov 11 2013 - 18:09:16 CET