Martin, How did you test your 1GB/sec read speeds? With Oracle or with another tool? What filesystem are you running? I assume it's linux, what version is it? Also assuming it's 10g. Note that only if you have parallel_automatic_tuning=true then the buffers are allocated from LARGE_POOL, otherwise (the default) they come from the shared pool, which may be an issue when you try to allocate 64kb chunks. -- Christo Kutrovsky DBA Team Lead The Pythian Group - www.pythian.com I blog at http://www.pythian.com/blogs/ On Fri, Sep 19, 2008 at 8:48 AM, Martin Klier <usn@xxxxxxxxx> wrote: > Hi William, > > William Robertson schrieb: >> Do you need to enable parallel DML? > > yes I did. If I don't, the producers don't parallelize as well. > > Thanks > Martin > > > > -- > Usn's IT Blog for Linux, Oracle, Asterisk > http://www.usn-it.de > > -- > //www.freelists.org/webpage/oracle-l > > > -- Christo Kutrovsky DBA Team Lead The Pythian Group - www.pythian.com I blog at http://www.pythian.com/blogs/ -- //www.freelists.org/webpage/oracle-l