RE: Streams testing and AWR report

We run RAC in production - the use of streams will be for reporting and testing.  

The real draw of the article for me was the statspack report and the load.  

Please look at the AWR/statspack report and my question.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alex Gorbachev
Sent: Monday, April 10, 2006 9:01 AM
To: ramick_at_dotster.com
Cc: oracle-l_at_freelists.org
Subject: Re: Streams testing and AWR report  

Sorry.. stopped reading this article after the first line: "Oracle Streams is a popular free alternative to Oracle RAC for failover and disaster recovery..."

2006/4/10, ramick <ramick_at_dotster.com>:

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

--

Best regards,
Alex Gorbachev

--

http://www.freelists.org/webpage/oracle-l Received on Mon Apr 10 2006 - 13:22:41 CDT