Re: PeopleSoft query

From: Nuno Souto <>
Date: Tue, 14 Jul 2009 22:27:07 +1000
Message-ID: <>

David Kurtz wrote,on my timestamp of 14/07/2009 8:51 PM:

> You can get contention caused by consistent read because the Cobol
> processes, unlike most Application Engine programs, share working storage
> tables. One option is to convert these tables into Global Temporary Tables
> (though I have had to use leading hints on a couple of statements in the
> identification phase).
> In GP systems where they want to run 'streamed' processing you also end up
> physical partitioning the tables to match the logical stream definitions.
> You can get also changes in execution plans because the range of EMPLIDs
> being processed is very wide, but the number of rows involved are small.
> Oracle miscalculates the cardinality because the group list is a skewed
> sample of the whole population.

Thanks heaps, David.

Nuno Souto
in sunny Sydney, Australia
Received on Tue Jul 14 2009 - 07:27:07 CDT

Original text of this message