Re: massive inserts with multiple process instances

Fred wrote:

> Hello,
>
> I have to implement massive inserts (arrays with Pro*C) and many instances of
> the program can be started simultaneously
> Then I must do something like that for the key column:
> select max from table_cpt into :max;
> update table_cpt set max = :max + 1000;
> Here I insert 1000 rows (array) (for value=max to max + 1000) because of
> multiple instances of the process.
> Is it a good method ?
> Must I use locks on table_cpt ?
>
> Thanks in advance.
>
> --
> Use our news server 'news.foorum.com' from anywhere.
> More details at: http://nnrpinfo.go.foorum.com/

No. What you MUST do is learn something about Oracle before you absolutely destroy its scalability and performance.

Look up sequences at http://tahiti.oracle.com.

Everything you describe above is unnecessary.

Daniel Morgan Received on Mon Jul 01 2002 - 15:15:27 CDT