Re: PeopleSoft query

From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Tue, 14 Jul 2009 22:27:07 +1000
Message-ID: <4A5C799B.6010009_at_iinet.net.au>



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.

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_iinet.net.au
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 14 2009 - 07:27:07 CDT

Original text of this message