Re: Simulate Database Writes

There's an outline and sample C program that I wrote about 5 years ago on my web site under

    http://www.jlcomp.demon.co.uk/block.html

Bear in mind that the write has to be at the equivalent of an oracle block boundary, and you need to open the file and write to the file using the same calls that dbwr does - you might want to "truss" a database startup before writing the C to find out what those calls are.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____England______January 21/23
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: 10 January 2003 12:24

>
>Instead of making Actual Database Writes is it possible to Simulate
Such Writes
>by using a suitable program in order to Check the thruput of a newly
configured
>RAID Storage Box ?
>
>Nature of Application - Hybrid
>
>If so What should be the Size of the Writes ?
>Our DB_BLOCK_SIZE is 8K
>Is there a Dependency on the Size & Volume of our Batch Job related
Database Commits ?
>Any Other Boundary conditions need to be taken into consideration ?
>
>Thanks
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: VIVEK_SHARMA
> INET: VIVEK_SHARMA_at_infosys.com
>
>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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

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).