How to set the timing on
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: How to set the timing on

  1. #1
    Join Date
    Jun 2001
    Posts
    150
    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

  2. #2
    Join Date
    Jun 2001
    Posts
    150
    will this work in pl/sql
    timing abc
    timing show
    timing stop

    please reply asap
    Cheers
    UKDBA

  3. #3
    Join Date
    Sep 2001
    Location
    SWEDEN
    Posts
    70
    Set TIMED_STATISTICS = TRUE and then use the
    DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure.

  4. #4
    Join Date
    Sep 2001
    Posts
    112
    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.

  5. #5
    Join Date
    Jun 2001
    Posts
    150
    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

  6. #6
    Join Date
    Oct 2000
    Posts
    211
    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

  7. #7
    Join Date
    Jun 2001
    Posts
    150
    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
  •  



Click Here to Expand Forum to Full Width