OraFAQ Forum: SQL & PL/SQL » DATABASE TIMER

Home » SQL & PL/SQL » SQL & PL/SQL » DATABASE TIMER

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DATABASE TIMER [message #40689]

Thu, 31 October 2002 01:57

rmn
Messages: 2
Registered: July 2002

Junior Member

HI TO ALL
any body explain me how to create databse timer (not from developer but from databse)

Report message to a moderator

Re: DATABASE TIMER [message #40692 is a reply to message #40689]

Thu, 31 October 2002 06:13

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

what kind of timer are u looking into?
you can design one, as u want.

Report message to a moderator

Re: DATABASE TIMER [message #40699 is a reply to message #40689]

Thu, 31 October 2002 09:29

andrew again
Messages: 2577
Registered: March 2000

Senior Member

does this help:

DECLARE
   v_hsec   PLS_INTEGER := DBMS_UTILITY.get_time;
BEGIN
   my_proc;
   DBMS_OUTPUT.put_line ('sec for my_proc to run = '|| (DBMS_UTILITY.get_time - v_hsec) / 100);
END;
/

Report message to a moderator

Previous Topic:	Please check this ....Urgent
Next Topic:	How to insert a record in another schema table through Trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 00:37:07 CDT 2024