Re: many inserts into a table

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Fri, 01 Aug 2003 23:41:03 GMT
Message-ID: <3F2AF8F7.BA4A14AD@telusplanet.net>

Daud wrote:

> oracle 8.1.7.4 (OPS environment)
>
> Ok...pls help me out on this one.
> I have one table where there can be many inserts per second. I need to
> know the order of the inserts. I cannot use date because the
> resolution is up to seconds only and I have tested
> dbms_utility.get_time and it wont work too. This will be in an OPS
> environment so, I guess sequence is out (I heard sequence is bad in
> OPS). So, what else can I do? If anyone has some sample codes to
> share, that will be great.
>

Any chance of upgrading to 9i+? You would be able to leverage the new TIMESTAMP datatype and that goes down to many fractions of a second.

How are you doing the inserts? (language, bulk binding, etc.?) Can you leverage at data source? Received on Fri Aug 01 2003 - 18:41:03 CDT