Re: AWR - Finding Sql uses Bulk
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Wed, 01 Apr 2015 13:05:18 -0500
Message-ID: <551C335E.1080104_at_yahoo.com>
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!
>
>
>
Date: Wed, 01 Apr 2015 13:05:18 -0500
Message-ID: <551C335E.1080104_at_yahoo.com>
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".
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 01 2015 - 20:05:18 CEST