Re: Insert/updates

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_at_hotmail.com> 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
> --
> http://www.freelists.org/webpage/oracle-l
>

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