similar as dbms_lock.sleep

[Shine]

can you tell me what is a function similar as dbms_lock.sleep exict from Oracle 9i.
because i want take more exactly time in fraction of second.
and dbms_lock.sleep(second in NUMBER), but i know that similar function exists from Oracle 9i but there time in INTERVAL.
please help me, what is the name of that function?

[TimHall]

Hi.

The DBMS_LOCK.sleep() function accepts fractions of a second also, like:

SQL> SET TIMING ON
SQL> EXEC DBMS_LOCK.sleep(0.01);

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.03
SQL>

Remember, there is some time overhead associated with calling the procedure etc.

Cheers

Tim...

[Shine]

it's good, but not enoughf.

i want more exactly, smallest units of seconds.

somebody sayed me that from Oracle 9i similar function exists, but i don't know it's name.

and in dbms_lock.sleep(seconds in NUMBER);

and in those (unnamed function) seconds should be in INTERVAL.

what is the name such function?

[TimHall]

Hi.

I've never heard of such a fuunction, that's not to say it doesn't exist.

The other thing to remember is that it is rare to any sleep operation to be totally accurate because of the delays associated with calling a procedure, setting a timer of some description, noticing the time is right to wake up and then actually waking up the process.

As such I doubt you will every get an accurate short duration pause in a language such as PL/SQL.

It's only my opinion, but I'm happy to be proved wrong.

Cheers

Tim...

[TimHall]

Hi.

I've just had a scan through the documentation and metalink and I can't see any functions or procedures that do what you are saying.

The TIMESTAMP datatype is present in 9i which allows you to deal with times to 9 decimal places of a second, but this has nothing to do with any form of sleep, pause or wait function.

If you ever find such a thing please post it. I don't need it, but it's nice to know ;-)

Cheers

Tim...

[DaPi]

Originally posted by Shine
i want more exactly, smallest units of seconds.

I too would be surprised if you would get results repeatable to better than a few hundreth's or even tenth's of a second.

My reaction is that if you need timing to "high" precision, you're using the wrong technology - DBMS aren't really designed for that.

[tamilselvan]

Try sys.dbms_system.ksdddt function.

This function will return 1000th of a second along with date.

Tamil