RE: raw versus Mounted File Systems
Vivek - There used to be a good paper on Oracle's website. The paper asked the question: If benchmarks show raw to be faster that file systems, why don't you see a difference in production? The answer the paper provided is that on a well-tuned OLTP system, disk isn't the bottleneck. There are many users performing many different tasks simultaneously, and not everyone is sitting around waiting for disk. I looked around on Oracle's Web site, but I can't find the paper there now. Maybe someone else will recall this paper. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, November 16, 2002 12:08 PM To: Multiple recipients of list ORACLE-L There is an (older) paper on www.jlcomp.demon.co.uk, and some very good info on www.ixora.com.au hth connor --- VIVEK_SHARMA [EMAIL PROTECTED] wrote: Any Good Docs , Links , sources ? Need to present a paper to the Managers Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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.com -- Author: DENNIS WILLIAMS 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: raw versus Mounted File Systems
Dennis, I think the paper you ae thinking of is Makingthe decision to use raw devices, and it's MetaLink Doc ID 29676.1. It was written by this guy named Cary Millsap, who seems to think he knows a thing or two about Oracle performance tuning;-) -Mark On Mon, 2002-11-18 at 08:28, DENNIS WILLIAMS wrote: Vivek - There used to be a good paper on Oracle's website. The paper asked the question: If benchmarks show raw to be faster that file systems, why don't you see a difference in production? The answer the paper provided is that on a well-tuned OLTP system, disk isn't the bottleneck. There are many users performing many different tasks simultaneously, and not everyone is sitting around waiting for disk. I looked around on Oracle's Web site, but I can't find the paper there now. Maybe someone else will recall this paper. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, November 16, 2002 12:08 PM To: Multiple recipients of list ORACLE-L There is an (older) paper on www.jlcomp.demon.co.uk, and some very good info on www.ixora.com.au hth connor --- VIVEK_SHARMA [EMAIL PROTECTED] wrote: Any Good Docs , Links , sources ? Need to present a paper to the Managers Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak 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: raw versus Mounted File Systems ...
Qs.Using Veritas for Striping across Raw Devices ,creates a RAW partition or Mounted Filesystem? Qs Like Filesysem Block Size (e.g. 8K) , is there a Concept of Block-size on raw devices / partitions ? -Original Message- Sent: Monday, November 18, 2002 1:03 PM To: Multiple recipients of list ORACLE-L EMC has hardware (raw) striping now. Also could be done by Veritas. Waleed -Original Message- Sent: Sunday, November 17, 2002 9:53 PM To: Multiple recipients of list ORACLE-L Is it possible to STRIPE a File Across a Set of RAW Devices/Disks (like RAID 0) to give IO/Load Balancing ? If so how ? Thanks P.S. Links , Docs on raw versus Mounted FS also needed. To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Any Good Docs , Links , sources ? Need to present a paper to the Managers Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: Khedr, Waleed 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.com -- 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: raw versus Mounted File Systems
Mark - Thanks very much. You are right, that Cary guy really nails those performance issues. The original paper date is 1992. I guess that if you say something about Oracle over 10 years ago and it is still relevant, that would have to qualify as a classic. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 18, 2002 8:04 AM To: Multiple recipients of list ORACLE-L Dennis, I think the paper you ae thinking of is Makingthe decision to use raw devices, and it's MetaLink Doc ID 29676.1. It was written by this guy named Cary Millsap, who seems to think he knows a thing or two about Oracle performance tuning;-) -Mark On Mon, 2002-11-18 at 08:28, DENNIS WILLIAMS wrote: Vivek - There used to be a good paper on Oracle's website. The paper asked the question: If benchmarks show raw to be faster that file systems, why don't you see a difference in production? The answer the paper provided is that on a well-tuned OLTP system, disk isn't the bottleneck. There are many users performing many different tasks simultaneously, and not everyone is sitting around waiting for disk. I looked around on Oracle's Web site, but I can't find the paper there now. Maybe someone else will recall this paper. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, November 16, 2002 12:08 PM To: Multiple recipients of list ORACLE-L There is an (older) paper on www.jlcomp.demon.co.uk, and some very good info on www.ixora.com.au hth connor --- VIVEK_SHARMA [EMAIL PROTECTED] wrote: Any Good Docs , Links , sources ? Need to present a paper to the Managers Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak 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.com -- Author: DENNIS WILLIAMS 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: raw versus Mounted File Systems ...
1)It's your choice. Both could be done. 2)No -Original Message- Sent: Monday, November 18, 2002 10:19 AM To: Multiple recipients of list ORACLE-L Qs.Using Veritas for Striping across Raw Devices ,creates a RAW partition or Mounted Filesystem? Qs Like Filesysem Block Size (e.g. 8K) , is there a Concept of Block-size on raw devices / partitions ? -Original Message- Sent: Monday, November 18, 2002 1:03 PM To: Multiple recipients of list ORACLE-L EMC has hardware (raw) striping now. Also could be done by Veritas. Waleed -Original Message- Sent: Sunday, November 17, 2002 9:53 PM To: Multiple recipients of list ORACLE-L Is it possible to STRIPE a File Across a Set of RAW Devices/Disks (like RAID 0) to give IO/Load Balancing ? If so how ? Thanks P.S. Links , Docs on raw versus Mounted FS also needed. To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Any Good Docs , Links , sources ? Need to present a paper to the Managers Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: Khedr, Waleed 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.com -- 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.com -- Author: Khedr, Waleed 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: raw versus Mounted File Systems
-Original Message- Sent: Monday, November 18, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Mark - Thanks very much. You are right, that Cary guy really nails those performance issues. The original paper date is 1992. I guess that if you say something about Oracle over 10 years ago and it is still relevant, that would have to qualify as a classic. I submit it is the relevance of UNIX that makes the paper a classic. If Oracle existing solely on another OS (Windows?) then this paper would be no more relevant that a whitepaper on Banyan Vines. ~brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Dunbar 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: raw versus Mounted File Systems
I have framed a Basic Doc on RAW Versus CFS , Mounted FS I will send it directly to any who seek it for review , perusal . Thanks to all who helped in making the same -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: raw versus Mounted File Systems ...
Is it possible to STRIPE a File Across a Set of RAW Devices/Disks (like RAID 0) to give IO/Load Balancing ? If so how ? Thanks P.S. Links , Docs on raw versus Mounted FS also needed. To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Any Good Docs , Links , sources ? Need to present a paper to the Managers Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: raw versus Mounted File Systems ...
EMC has hardware (raw) striping now. Also could be done by Veritas. Waleed -Original Message- Sent: Sunday, November 17, 2002 9:53 PM To: Multiple recipients of list ORACLE-L Is it possible to STRIPE a File Across a Set of RAW Devices/Disks (like RAID 0) to give IO/Load Balancing ? If so how ? Thanks P.S. Links , Docs on raw versus Mounted FS also needed. To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Any Good Docs , Links , sources ? Need to present a paper to the Managers Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: Khedr, Waleed 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: raw versus Mounted File Systems
There is an (older) paper on www.jlcomp.demon.co.uk, and some very good info on www.ixora.com.au hth connor --- VIVEK_SHARMA [EMAIL PROTECTED] wrote: Any Good Docs , Links , sources ? Need to present a paper to the Managers Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
raw versus Mounted File Systems
Any Good Docs , Links , sources ? Need to present a paper to the Managers Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).
Raw versus Mounted File-systems
Any Notes , Docs , Links ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: Raw versus Mounted File-systems
Vivek, Check http://www.ixora.com.au/ Start by clicking the 'Tips' link, and read through the 'Database creation' section. Also, you could try a search on 'raw file'. It will return several more links. -Mark On Tue, 2002-10-08 at 02:03, VIVEK_SHARMA wrote: Any Notes , Docs , Links ? Thanks -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak 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).