Re: AWR - Finding Sql uses Bulk

  • From: Carlos Sierra <carlos.sierra.usa@xxxxxxxxx>
  • To: keyantech@xxxxxxxxx
  • Date: Wed, 1 Apr 2015 11:25:59 -0400

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@xxxxxxxxx> 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


--
//www.freelists.org/webpage/oracle-l



--
//www.freelists.org/webpage/oracle-l


Other related posts: