There is no way to speed up inserts that doesn't introduce factors that need to be carefully considered. i.e. recoverability, availability. You can: use append hint =20 do the operation with nologging drop the indexes on the target table or set the indexes to unusable and set skip_unusable_indexes at the session level=20 make use of partition exchange make user of oracle's table renaming ability make use of pl/sql's bulk operations (if the insert logic cannot be done in sql) There are probably other possibilities as well. On 6/2/05, J. Dex <cemail_219@xxxxxxxxxxx> wrote: > Is there any way to "tune" insert or update statements so that they are > faster? >=20 > Are there any issues that arise with having more than one DBWR? We are > using 9.2.0.6 >=20 > _________________________________________________________________ > Don't just search. Find. Check out the new MSN Search! > http://search.msn.click-url.com/go/onm00200636ave/direct/01/ >=20 > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l