Hi: I have a batch process that executes individual transactions, normally a transaccion e.g. a simple select would take 8-10 buffer gets but in the batch processing it takes 45 buffer gets. Any ideas in the explanation? TIA -- Alfonso Leon -- http://www.freelists.org/webpage/oracle-l