<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>


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

</div>


<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..


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 =&gt; are they on a dedicated tablespace?
does it have INSERT triggers? yes =&gt; could they be deactivated for this big insert?
is the table partitioned?
and a couple of others.



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


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.