Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Delete/Insert and high number of concurrent users

Re: Delete/Insert and high number of concurrent users

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 19 Sep 2004 16:47:20 GMT
Message-ID: <Xns956963949F538SunnySD@68.6.19.6>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US