Re: AWR - Finding Sql uses Bulk
From: Karth Panchan <keyantech_at_gmail.com>
Date: Wed, 1 Apr 2015 11:45:01 -0400
Message-Id: <083CE86C-0F15-4DBB-BBDB-384EE94012FA_at_gmail.com>
Carlos
>> 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
>
Date: Wed, 1 Apr 2015 11:45:01 -0400
Message-Id: <083CE86C-0F15-4DBB-BBDB-384EE94012FA_at_gmail.com>
Carlos
Thanks so much. That works for me.
Karth
Sent from my IPhone
> On Apr 1, 2015, at 11:25 AM, Carlos Sierra <carlos.sierra.usa_at_gmail.com> wrote: > > 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-lReceived on Wed Apr 01 2015 - 17:45:01 CEST