Re: Streams testing and AWR report

In 10G, there is the new time model to store statistics, wherein every operation is stored in a bucket of time. "DB Time" is one such operation. It represents the total time spent in database calls and is derived by adding the times from all non-idle user sessions.

May be there were ~30 active sessions making db calls ...

HTH,
-Arul

On 4/9/06, ramick <ramick_at_dotster.com> wrote:
>
> I'm trying to get an idea of what hardware will be sufficient to support
> streaming an application from our production database. In this effort, I
> searched Google and found:
> http://www.dba-oracle.com/t_streams_benchmarking_testing.htm
>
> While I understand the findings, I don't understand the report.
> Specifically, why is the Elapsed at 2.62 minutes and DB Time at 74.32
> minutes. I would have thought this due to the number of CPUs on the
> system,
> but looking further down under "Operating System Statistics" at the
> statistic "NUM_CPUS" it is 2. Am I missing something?
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l