How to set the timing on

[UKDBA]

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

[UKDBA]

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

please reply asap
Cheers
UKDBA

[mageri]

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

[UNIX DBA]

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.

[UKDBA]

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

[manjunathk]

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

[UKDBA]

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

UKDBA