<div>
where does the data for the insert come from?<br />
another table? another db? file? VALUES coded?<br />
that part might be optimizable ...<br />
<br />
anything else is about the target table:<br />
does it have indexes ? yes =&gt; are they on a dedicated tablespace?<br />
does it have INSERT triggers? yes =&gt; could they be deactivated for this big insert?<br />
is the table partitioned?<br />
and a couple of others.<br />
<br />

</div>


where does the data for the insert come from?
another table? another db? file? VALUES coded?
that part might be optimizable ...

anything else is about the target table:
does it have indexes ? yes => are they on a dedicated tablespace?
does it have INSERT triggers? yes => could they be deactivated for this big insert?
is the table partitioned?
and a couple of others.



<div>
hi<br />
<br />
you can use NOLOGGING<br />
you can use APPEND<br />
you can use DIRECT PATH with SQLLDR<br />
<br />

</div>


hi

you can use NOLOGGING
you can use APPEND
you can use DIRECT PATH with SQLLDR



<div>
<div class="content wysiwyg-content">
in order to improve performance on an insert statement that places millions of rows<br />
into that table what steps can be done..<br />

</div>
</div>


in order to improve performance on an insert statement that places millions of rows
into that table what steps can be done..


performance

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.