Re: Dbms_profiler

I assume you are running on Tru64, what is your exact Oracle version number?

There's a bug (1638505) registered in Oracle related to no timing information when measured time intervals are short. Also it seems, that this bug is mostly occurring on Tru64.

Try to make a pl/sql loop with 10000 iterations and profile that, see whether the timing columns get populated.

Tanel.

"ngilles" <member25303_at_dbforums.com> wrote in message news:2557545.1045821412_at_dbforums.com...
>
> it's already set to true
>
>
> Originally posted by Tanel Poder
> > Hi,
> >
> > have you tried to set timed_statistics = true ?
> >
> > Tanel.
> >
> > "ngilles" wrote in message
> > news:2553656.1045759907_at_dbforums.com"]news:2553656.1045759907_at_d-
> > bforums.com[/url]...
> > > I need help for the use of the package DBSM_PROFILER. When I
> > use
> > > DBMS_PROFILER, I get the information about the units, but no
> > information
> > > about the time. The time is always "0". Why ?? ...
> > > Oracle server 8.1.7 running on Unix Alpha server.
> > > --
> > Posted via
> http://dbforums.com/http://dbforums.com
>
>
> --
> Posted via http://dbforums.com
>
Received on Fri Feb 21 2003 - 13:56:09 CST