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
> --
> http://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.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
--
Alfonso Leon
--
http://www.freelists.org/webpage/oracle-l
