Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete/Insert and high number of concurrent users
gautrak_at_yahoo.com (Gautrak) wrote in
news:76ceef56.0409190825.240ff9a8_at_posting.google.com:
> Hi,
> Oracle version : 9.2
>
> A transaction, in addition to other statements, involves first
> deleting all records belonging to that userid and then insert fresh
> set from another table.
> The database must be able to support large number of users, each with
> own userid, performing this transaction.
>
> I believe this is not a good design but have no control on this part.
>
> To ensure that these delete statements do not result in any
> bottlenecks, what should be the focus areas.
>
> Thanks and regards,
> Gautrak
>
Do NOT use DELETE use TRUNCATE instead. Received on Sun Sep 19 2004 - 11:47:20 CDT