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
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Rich [richa03@xxxxxxxxx]
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