Re: AWR - Finding Sql uses Bulk

From: Carlos Sierra <carlos.sierra.usa_at_gmail.com>
Date: Wed, 1 Apr 2015 11:25:59 -0400
Message-Id: <FD79D7E7-6D62-4B96-8849-2A61ED5BA682_at_gmail.com>



Karth,

Compare Rows Processed to Executions. If 1 to 1 then you have Row by Row, else Bulk Insert

Carlos Sierra
Life is Good!

> On Apr 1, 2015, at 10:59, Karth Panchan <keyantech_at_gmail.com> wrote:
>
> List
>
> I would like to find DB sessions came from our Java applications issued SQL with Bulk Insert.
>
> All I see in AWR SQL as below
>
> Insert into table1
> Values(:b1,:b2,:b3,:b4,:b5);
>
> Java team claims they do Bulk Insert
>
> Looking above SQL it appears Row By Row insert.
>
> Want to confirm is there any other way to find Session used Bulk operations
>
> Thanks in advance
>
> Karth
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 01 2015 - 17:25:59 CEST

Original text of this message