Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_PROFILER - Total_Time - format?
DBMS_PROFILER - Total_Time - format? [message #184937] Fri, 28 July 2006 15:40
Messages: 116
Registered: May 2006
Senior Member
Hi gurus,

I have a question and need help to understand.

After DBMS_FROFILER run and data flushed to the following table :

SQL> desc plsql_profiler_data
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- -------------------------------
 RUNID                                                 NOT NULL NUMBER
 UNIT_NUMBER                                           NOT NULL NUMBER
 LINE#                                                 NOT NULL NUMBER
 TOTAL_OCCUR                                                    NUMBER
 TOTAL_TIME                                                     NUMBER
 MIN_TIME                                                       NUMBER
 MAX_TIME                                                       NUMBER
 SPARE1                                                         NUMBER
 SPARE2                                                         NUMBER
 SPARE3                                                         NUMBER
 SPARE4                                                         NUMBER

----I want time results which in total_time column, so I enquired like...

SQL> select total_time from plsql_profiler_data where rownum <3
  2   and runid = 20


---Now how do i know this TOTAL_TIME column value is in what format ?

--I mean ,  Is it in Miliseconds or Seconds or Minitues ?

Suppose , If I want to get Miliseconds then i will write the following statement, is it correct ?

SQL> select total_time/1000000 "Msec" from plsql_profiler_data where rownum <3
  2  and runid = 20;


---And Suppose , What if i want to get Seconds and minitues ? 
---how do i write my statement so that i will get Seconds and Minitues results?

Your help will be highly obliged.

Thanking you,

Previous Topic: NLS_DATE_FORMAT from 10g client to 8i database
Next Topic: Dynamicl DDL
Goto Forum:

Current Time: Tue Jul 25 12:00:30 CDT 2017

Total time taken to generate the page: 0.16400 seconds