Re: many inserts into a table

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1 Aug 2003 05:45:18 -0700
Message-ID: <1a75df45.0308010445.648bc121@posting.google.com>

daud11_at_hotmail.com (Daud) wrote in message

> 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.

Oracle is not a real-time database environment. For that you need an in-memory database running on a true real-time o/s.

The market for this is however is small and very specialised.. which makes me question your requirements for wanting to be able to determine the physically sequence of updates. It is not the norm and very unusual...

> 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.

Have you considered in writing a high resolution timer as a Java stored proc and using that?

--
Billy

Received on Fri Aug 01 2003 - 07:45:18 CDT