Profiler Issues

[VladimirSanchez]

I'd like to know if there is a bug in the Profiler, version 5.0.1.

I created a profile for which there are no stats on the Total Time, Maximum and Minimum Times. These values are set to "0.00" whereas the system help suggests the should be initalized accordingly.

Besides this, I can't specify which columns to print. It always print a pre-defined set of columns (Unit, Line, Occurrences, Minimum time, Maximum time) which doesn't include the notorious Total time.

Would you please tell me if I am doing anything wrong? Is there anything I need to configure in the database in order to supply this information? Otherwise, why is this information lacking from the Profile?

I am in great need for this information. I am experiencing performance problems that could potentially be resolved with the assistance of these stats.

Thanks.

-Vladimir

 

[Marco Kalter]

There have been some platform specific Oracle Server bugs concerning the profiler times. Can you let me know your Oracle Server platform and version?

------------------
Marco Kalter
Allround Automations

 

[VladimirSanchez]

Originally posted by mkalter:
There have been some platform specific Oracle Server bugs concerning the profiler times. Can you let me know your Oracle Server platform and version?

I am running Oracle Enterprise ver 8.1.7. I told my boss about this issue, and he said that "Time Statistics" could be the cause of the problem. Time Statistics are currently disabled in our system to preserve resources. I'll recreate another Profile after the Time Statistics are enabled, then I'll give you feedback.

Thanks.

 

[VladimirSanchez]

Originally posted by mkalter:
There have been some platform specific Oracle Server bugs concerning the profiler times. Can you let me know your Oracle Server platform and version?

As previously suggested, we turned on the "Time Statistics". Then made a run and we still have NO Total Time.

I am totally clueless. I there anyone else going through this? Please advise what would be the next steps.

Thanks,

- Vlad

 

[Marco Kalter]

Can you let me know your server OS platform?

------------------
Marco Kalter
Allround Automations

 

[VladimirSanchez]

It is SCO Unixware 7.1.1

 

[Marco Kalter]

You are probably running into Oracle bug 1899627 ("Package dbms_profiler does not return execution time for SCO UnixWare 7.1"). Unfortunately it is not documented how to fix this. Perhaps you can contact your Oracle support representative about this?

------------------
Marco Kalter
Allround Automations