How to set the timing on

Hi
In order to set the timing on the sqlplus is set timing on. but is there anyway to set the timing on in plsql or proC.
I want to monitor the timings of the applications and work we do.

Cheers
UKDBA

will this work in pl/sql
timing abc
timing show
timing stop

please reply asap
Cheers
UKDBA

Set TIMED_STATISTICS = TRUE and then use the
DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure.

A simple method would be to put the whole PL/SQL into a script and add the SET commands at the top of the procedure.

If you are wanting to store the procedure in the database this isn't a viable method.

I need to get the time in bind variable so that i can use it somewhere else.is there any way that i will get the cpu timings and elapsed timing in bind variable.
Cheers
UKDBA

To get the timings through variable, declare it first(say vtmp_start)and then use in your pl/sql procedure
vtmp_start:=dbms_utility.get_time;

You can have a temporary table into which you can populate vtmp_start, vtmp_intermediate, vtmp_complete etc and then thru' sqlplus you can findout the lapsed time between any of them.
I dont know how to get the cpu timings isong variables
HTH
manjunath

Hi manju
can you explain it to me in detail i still don't understand how to use it.

UKDBA