Re: High IOPS direct small writes?

COMMIT WRITE WAIT; If its in plsql?

Tom

On Thu, Nov 19, 2015 at 7:58 PM, Rich <richa03_at_gmail.com> wrote:

> Perfect - thanks!
>
> On Thu, Nov 19, 2015 at 11:32 AM, Jonathan Lewis <
> jonathan_at_jlcomp.demon.co.uk> wrote:
>
>>
>> Unless I've misunderstood your question you could just use insert/append
>> differently:
>>
>> begin
>> for i in 1..10000 loop
>> insert /*+ append */ into t1 select 1 from dual;
>> commit;
>> end loop;
>> end;
>> /
>>
>> That's 10,000 single block direct path writes - requiring 10,000 blocks
>> allocated.
>>
>>
>>
>> Regards
>> Jonathan Lewis
>> http://jonathanlewis.wordpress.com
>> _at_jloracle
>> ------------------------------
>> *From:* oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on
>> behalf of Rich [richa03_at_gmail.com]
>> *Sent:* 19 November 2015 19:27
>> *To:* Oracle-L Freelists
>> *Subject:* High IOPS direct small writes?
>>
>> Hi All,
>> This is 11.2.0.3 on AIX.
>>
>> I know how to create direct IO load with insert+append, however, I'd like
>> to know how I can create high IOPS, direct small writes through the Oracle
>> code - preferably using SQL*Plus. I'd also prefer the target be a "normal
>> object" (like a table or index; not redo logs, LOB nor temp).
>>
>> Any ideas?
>>
>> TIA,
>> Rich
>>
>
>

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