Re: Multiple datasets in one dataset

Hi Brian,

if such sample data appear within a certain time span, we encounter a significant raise of time. In other words I quit the thread after about 4500 seconds.

After excessive testing it turned out, that those values were blamable where all values are 0.

We have also tested on Postgres ( before we turned it to an inner select - Postgres does not understand (+) ). Even the inner select did not return, either on Oracle nor on Postgres.

Postgres moaned that memory exceeded. Oracle did not state anything. So this kind of data seems to be an impossible variation of data for this request.

But as Postgres unveiled we may have to less dedicated memory for our Oracle database.

Regards
Roman Received on Thu Oct 18 2007 - 01:52:40 CDT