Simulate Database Writes
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Simulate Database Writes
Great article! I'll be nabbing the code to test/compare our new storage systems (whenever it gets approved). :) I few items though: This is the first that I've seen a recommendation for raw on the redo volumes. Are there any issues with having the redos on raw if the archives are cooked? Any issues of raw redos that would be different from having raw datafiles? Thanks again! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 8:04 AM To: Multiple recipients of list ORACLE-L Subject: 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).