Re: Insert/updates

  • From: Chris Stephens <cstephens16@xxxxxxxxx>
  • To: cemail_219@xxxxxxxxxxx
  • Date: Thu, 2 Jun 2005 14:16:15 -0400

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

Other related posts: