Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Streams testing and AWR report

Streams testing and AWR report

From: ramick <ramick_at_dotster.com>
Date: Sun, 9 Apr 2006 17:21:26 -0700
Message-Id: <20060410002132.471CA2D7569@turing.freelists.org>


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
Received on Sun Apr 09 2006 - 19:21:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US