SQL & PL/SQL

Hello All,

For Oracle 12.1, how can ı use pl/sql profiler properly?

I use the following code in order to use profiler. However, there are two cases. First, why the total times don't match between plsql_profiler_runs and plsql_profiler_data? Second, why the text column is empty in plsql_profiler_data table?

begin


    DBMS_PROFILER.START_PROFILER('profiler run ' || to_char (sysdate, 'yyyymmddhh24mi'));
    
    proc_test();
    
    DBMS_PROFILER.STOP_PROFILER;


end;

SELECT run_total_time FROM plsql_profiler_runs a where runid= 9013;
>>48670000000

SELECT sum(total_time) FROM plsql_profiler_data where runid = 9013;
>>34403398794

SELECT count(*) FROM plsql_profiler_data where text is not null and runid = 9013;
>>0

Thanks in advance