No. I mean the goals of the benchmark. What are you measuring and why.
On 2003.09.16 06:10, VIVEK_SHARMA wrote:
> Hi
>
>
>
> Plan of the Benchmark = ? If you mean an action plan of important steps
> ?
>
> We have just started. I Shall send it to you shortly.
>
>
>
> Monitoring of Actual Bandwidth thruput (MBPS) used versus that set on
> WAN will be done .
>
> (other than actual application transaction thruput rate (TPS) , OS
> resources Utilizations )
>
>
>
> Thanks indeed
>
>
>
>
>
> -----Original Message-----
> Sent: Tuesday, September 16, 2003 2:59 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Did you plan that benchmark? What did you decide to monitor in the
> planning phase?
>
>
>
>
>
> --
> Mladen Gogala
> Oracle DBA
>
> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On
> Behalf Of VIVEK_SHARMA
> Sent: Monday, September 15, 2003 1:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Dataguard Benchmark
>
> We are doing a Data guard Benchmark.
>
>
>
> INFO.:-
>
> -----
>
> WAN Simulator :-
>
> We have a WAN Simulator with 2 routers at either ends of it.
>
> Thruputs from 0 to 2 MBPS can be manually set as is required by
> the run.
>
>
>
> Application = Banking :-
>
> Transactions mainly OLTP in nature (Both DML & SELECTS) .
>
> We can do CPU intensive batch Transactions too if advised by you
> folks
>
>
>
> Machines = 2 machines of 4 CPUs each
>
> Memory = 8 GB on each machine
>
> O.S. = Solaris 9
>
> Oracle = 9.2
>
> Sniffer network tool ( to get volume of bytes transferred over
> the WAN )
>
> Dataguard Setup will transfer Data thru the listener services :-
>
> i.e. init.ora - LOG_ARCHIVE_DEST_2 =
> 'SERVICE=<SERVICE_NAME_FROM_TNSNAMES.ORA>,. . .'
>
>
>
> Execution methodology:-
>
>
>
> Run Same Transaction's Volume in BOTH Logical & Physical
> (Maximum Protection , Maximum Availability , Maximum performance )
> standby modes
>
>
>
>
>
> Qs What readings to be particularly monitored & measured?
>
> Qs What thruput bandwidths should be benchmarked?
>
> Qs Does total Size of Existent Database-in-use matter to the
> Benchmark?
>
> Current Database Size = 3 GB
>
> Qs Does RMAN setup add any value to the Dataguard benchmark in
> some way?
>
> Else we will do Without RMAN, manually altering the various
> modes
>
> Qs Any Sample Docs, Links on existing Dataguard Benchmarks?
>
> Qs Any else that will enable us to bring out a paper of
> reasonable standard?
>
>
>
>
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mgogala_at_adelphia.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Sep 16 2003 - 06:54:38 CDT
