It is the same execution plans in batch processing the CPU gets use up to 100% Same optimizer mode and the batch fires the same transaction OLTP does. On 8/8/05, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote: > Sounds like different explain plans between the two executions. Do you have > different system stats for different periods (OLTP/batch) of the day? Are > you changing optimizer_mode or any other parameters in your batch process? > Do you have a smaller arraysize in your batch process? > > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Alfonso León > Sent: Monday, August 08, 2005 11:46 AM > To: oracle-l > Subject: Buffer gets increase in massive execution > > > 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 > -- > //www.freelists.org/webpage/oracle-l > > Privileged/Confidential Information may be contained in this message or > attachments hereto. Please advise immediately if you or your employer do not > consent to Internet email for messages of this kind. Opinions, conclusions > and other information in this message that do not relate to the official > business of this company shall be understood as neither given nor endorsed by > it. > > -- > //www.freelists.org/webpage/oracle-l > -- Alfonso Leon -- //www.freelists.org/webpage/oracle-l