-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|