Re: AWR - Finding Sql uses Bulk
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Wed, 01 Apr 2015 13:08:30 -0500
Message-ID: <551C341E.30103_at_yahoo.com>
On 4/1/2015 1:05 PM, Mladen Gogala (Redacted sender mgogala_at_yahoo.com for DMARC) wrote:
> On 4/1/2015 10:25 AM, Carlos Sierra 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!
>>
>>
>>
>
> Carlos, that is not necessarily true. Oracle 11g obeys the
> APPEND_VALUES hint and will insert every row in the new block. In my
> opinion, that should be illegal, but it does qualify as "direct insert".
>
Date: Wed, 01 Apr 2015 13:08:30 -0500
Message-ID: <551C341E.30103_at_yahoo.com>
On 4/1/2015 1:05 PM, Mladen Gogala (Redacted sender mgogala_at_yahoo.com for DMARC) wrote:
> On 4/1/2015 10:25 AM, Carlos Sierra 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!
>>
>>
>>
>
> Carlos, that is not necessarily true. Oracle 11g obeys the
> APPEND_VALUES hint and will insert every row in the new block. In my
> opinion, that should be illegal, but it does qualify as "direct insert".
>
Sorry, I apologize. I have confused "direct insert" with "bulk insert". You are absolutely correct.
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 01 2015 - 20:08:30 CEST