problems with profiler output

[mpl1604]

We found often on the profiler output lines with total time seconds that seams to be an overflow value: in some lines we have 9.223.372.036,86 seconds of total time !!!!

could someone explain this?

 

[Marco Kalter]

This may be a dbms_profiler bug. Do these huge values really appear in the plsql_profiler_data table?

 

[mpl1604]

Yes, in the column plsql_profiler_data.total_time
are values equal 9,22337203685478E18 !!

 

[Claus Pedersen]

I have the same problem. I am on a 10.2.0.3.0 base. I have not noticed this behaviour on the 9i base.

Could someone please tell how to invoke a profiler session from SQL*Plus, so we can report this to Oracle?

 

[Marco Kalter]

You can find a complete example here .