Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
On Sun, 10 Jun 2001, George Schlossnagle wrote: Hmmm so it's a pci only interface, so I can't use it with my Enterprise Sun systems, and drivers for Tru64 don't yet exist, so unless you're running Windoze, AIX or Linux, you're out of luck. That's a real bummer. But there WOULD be the possibility of using them with Sun E250s and E450s. -- Larry Herzog Jr.Do nothing out of selfish ambition or vain ZRXOA #1029 conceit, but in humility consider others [EMAIL PROTECTED] better than yourselves. - Philippians 2:3 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
Jared wrote: I just *had* to point this out. Had too many damagers want to solve everything by buying HW when they have no idea what the problem is. how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM made the application fly. Until we hit THE ultimate peak stress day and they died. I had spent the year prior screaming about how the application needed some serious rewrite or we would die on that day. Database had been designed (if you can call it that) by people who did not know Oracle and so recreated their flat file system. They told me that the reason we died was because I had not done my job properly. What's wrong with that picture? _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
oops Sun E6500 From: Rachel Carmichael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O Date: Mon, 11 Jun 2001 04:50:19 -0800 Jared wrote: I just *had* to point this out. Had too many damagers want to solve everything by buying HW when they have no idea what the problem is. how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM made the application fly. Until we hit THE ultimate peak stress day and they died. I had spent the year prior screaming about how the application needed some serious rewrite or we would die on that day. Database had been designed (if you can call it that) by people who did not know Oracle and so recreated their flat file system. They told me that the reason we died was because I had not done my job properly. What's wrong with that picture? _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
What's wrong with that picture? You are telling them what they do not wish/want to listen ;) And I am making the same 'mistake' - Kirti -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 7:50 AM To: Multiple recipients of list ORACLE-L Subject: Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O Jared wrote: I just *had* to point this out. Had too many damagers want to solve everything by buying HW when they have no idea what the problem is. how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM made the application fly. Until we hit THE ultimate peak stress day and they died. I had spent the year prior screaming about how the application needed some serious rewrite or we would die on that day. Database had been designed (if you can call it that) by people who did not know Oracle and so recreated their flat file system. They told me that the reason we died was because I had not done my job properly. What's wrong with that picture? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
yep -- and as soon as I realized what I'd written I corrected it. I've been running sleep-deprived for several weeks (months?) now. I'm surprised that's all I wrote incorrectly! From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O Date: Mon, 11 Jun 2001 06:55:30 -0800 On Mon, 11 Jun 2001, Rachel Carmichael wrote: how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM I assume you mean a Sun E6500 (since E650's don't exist). :) -- Larry Herzog Jr.Do nothing out of selfish ambition or vain ZRXOA #1029 conceit, but in humility consider others [EMAIL PROTECTED] better than yourselves. - Philippians 2:3 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
On Mon, 11 Jun 2001, Rachel Carmichael wrote: how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM I assume you mean a Sun E6500 (since E650's don't exist). :) -- Larry Herzog Jr.Do nothing out of selfish ambition or vain ZRXOA #1029 conceit, but in humility consider others [EMAIL PROTECTED] better than yourselves. - Philippians 2:3 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
But there WOULD be the possibility of using them with Sun E250s and E450s. Sure. Except that the drivers aren't available. Besides, these are really tiny, unscaleable boxes. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
management was heavily invested in making the system go live as is... since they were heavily involved with the design. They designed it without a DBA. OLTP system, main order table had 23 indexes on it. Because they wanted to be able to search by customer first name, customer last name, recipient first name, recipient last name and had foreign keys all over the place. Ah, but I am so much the better for NOT being there anymore! From: Deshpande, Kirti [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O Date: Mon, 11 Jun 2001 06:55:29 -0800 What's wrong with that picture? You are telling them what they do not wish/want to listen ;) And I am making the same 'mistake' - Kirti -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 7:50 AM To: Multiple recipients of list ORACLE-L Subject:Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O Jared wrote: I just *had* to point this out. Had too many damagers want to solve everything by buying HW when they have no idea what the problem is. how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM made the application fly. Until we hit THE ultimate peak stress day and they died. I had spent the year prior screaming about how the application needed some serious rewrite or we would die on that day. Database had been designed (if you can call it that) by people who did not know Oracle and so recreated their flat file system. They told me that the reason we died was because I had not done my job properly. What's wrong with that picture? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
Larry Herzog Jr. wrote: But there WOULD be the possibility of using them with Sun E250s and E450s. On Mon, 11 Jun 2001, George Schlossnagle wrote: Sure. Except that the drivers aren't available. Besides, these are really tiny, unscaleable boxes. I didn't say it was a GOOD solution. I simply said that it was possible. :) -- Larry Herzog Jr.Do nothing out of selfish ambition or vain ZRXOA #1029 conceit, but in humility consider others [EMAIL PROTECTED] better than yourselves. - Philippians 2:3 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
I disagree wholeheartedly with this statement Alex. How can you make this statement without knowing the situation? (You seem to be becoming the resident troller in this group! Sorry, but it does appear that way.) In spite of all evidence and repeated warnings, management often does not allow the most reasonable solution - preferring instead to play ostrich and simply throw hardware at the problem. Then one day even this isn't enough or it becomes prohibitively expensive and they want to hold someone else responsible for their own bad decisions - and the all too common scapegoat hunting expedition begins! That is when I usually forward to the hunters the same email that I sent them three years ago (and two years ago and a year ago , and six months ago, ...) analyzing the problem and proposing a reasonable solution - with attached proof (e.g. tkprof output showing how rewriting a few problematic queries can reduce CPU utilization by a factor of 72 and LIO by a factor of 6200! A real life example - that stayed like this for over three and a hlf years!). -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 11, 2001 1:40 PM Of cource you did not do your job properly. Or are you telling us that damagement did not do their job properly? I have never heard anything more ridiculous. :-). Alex Hillman -Original Message- Sent: Monday, June 11, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Jared wrote: I just *had* to point this out. Had too many damagers want to solve everything by buying HW when they have no idea what the problem is. how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM made the application fly. Until we hit THE ultimate peak stress day and they died. I had spent the year prior screaming about how the application needed some serious rewrite or we would die on that day. Database had been designed (if you can call it that) by people who did not know Oracle and so recreated their flat file system. They told me that the reason we died was because I had not done my job properly. What's wrong with that picture? _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
On Monday 11 June 2001 09:06, Rachel Carmichael wrote: OLTP system, main order table had 23 indexes on it. Because they wanted to ?!?!?! That's just nuts. be able to search by customer first name, customer last name, recipient first name, recipient last name and had foreign keys all over the place. Sounds like Data Mart was a term they were unfamiliar with. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
I hoped that everybody understand that this was a joke. I use damagement and :-) in the end. I hoped that it was grotesc. Apparently I was wrong. My apologies for all offended. For people who do not understand humor I repeate again that it was a joke. Alex Hillman -Original Message- Sent: Monday, June 11, 2001 4:01 PM To: Multiple recipients of list ORACLE-L I disagree wholeheartedly with this statement Alex. How can you make this statement without knowing the situation? (You seem to be becoming the resident troller in this group! Sorry, but it does appear that way.) In spite of all evidence and repeated warnings, management often does not allow the most reasonable solution - preferring instead to play ostrich and simply throw hardware at the problem. Then one day even this isn't enough or it becomes prohibitively expensive and they want to hold someone else responsible for their own bad decisions - and the all too common scapegoat hunting expedition begins! That is when I usually forward to the hunters the same email that I sent them three years ago (and two years ago and a year ago , and six months ago, ...) analyzing the problem and proposing a reasonable solution - with attached proof (e.g. tkprof output showing how rewriting a few problematic queries can reduce CPU utilization by a factor of 72 and LIO by a factor of 6200! A real life example - that stayed like this for over three and a hlf years!). -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 11, 2001 1:40 PM Of cource you did not do your job properly. Or are you telling us that damagement did not do their job properly? I have never heard anything more ridiculous. :-). Alex Hillman -Original Message- Sent: Monday, June 11, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Jared wrote: I just *had* to point this out. Had too many damagers want to solve everything by buying HW when they have no idea what the problem is. how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM made the application fly. Until we hit THE ultimate peak stress day and they died. I had spent the year prior screaming about how the application needed some serious rewrite or we would die on that day. Database had been designed (if you can call it that) by people who did not know Oracle and so recreated their flat file system. They told me that the reason we died was because I had not done my job properly. What's wrong with that picture? _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
Alex, I think you are trying to not be incredibly rude? How rude of you! grin, duck, and run like hell || -Original Message- || From: Hillman, Alex [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 11, 2001 3:39 PM || To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' || Cc: '[EMAIL PROTECTED]' || Subject: RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O || || || I hoped that everybody understand that this was a joke. I || use damagement || and :-) in the end. I hoped that it was grotesc. Apparently || I was wrong. My || apologies for all offended. For people who do not understand || humor I repeate || again that it was a joke. || || Alex Hillman || || -Original Message- || From: Don Granaman [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 11, 2001 4:01 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O || || || I disagree wholeheartedly with this statement Alex. How can || you make this || statement without knowing the situation? (You seem to be || becoming the || resident troller in this group! Sorry, but it does appear that way.) || || In spite of all evidence and repeated warnings, management || often does not || allow the most reasonable solution - preferring instead to || play ostrich || and simply throw hardware at the problem. Then one day even || this isn't || enough or it becomes prohibitively expensive and they want || to hold someone || else responsible for their own bad decisions - and the all too common || scapegoat hunting expedition begins! That is when I usually || forward to the || hunters the same email that I sent them three years ago || (and two years ago || and a year ago , and six months ago, ...) analyzing the problem and || proposing a reasonable solution - with attached proof (e.g. || tkprof output || showing how rewriting a few problematic queries can reduce || CPU utilization || by a factor of 72 and LIO by a factor of 6200! A real life || example - that || stayed like this for over three and a hlf years!). || || -Don Granaman || [certifiable OraSaurus] || || - Original Message - || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Sent: Monday, June 11, 2001 1:40 PM || || || Of cource you did not do your job properly. Or are you || telling us that || damagement did not do their job properly? I have never || heard anything more || ridiculous. :-). || || Alex Hillman || || -Original Message- || Sent: Monday, June 11, 2001 8:50 AM || To: Multiple recipients of list ORACLE-L || || || Jared wrote: || || I just *had* to point this out. Had too many damagers || want to solve || everything by buying HW when they have no idea what the || problem is. || || || how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM || || made the application fly. Until we hit THE ultimate peak || stress day and || they died. I had spent the year prior screaming about how || the application || needed some serious rewrite or we would die on that day. || Database had been || designed (if you can call it that) by people who did not || know Oracle and || so recreated their flat file system. || || They told me that the reason we died was because I had not || done my job || properly. || || What's wrong with that picture? || || || _ || Get your FREE download of MSN Explorer at http://explorer.msn.com || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Rachel Carmichael ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || || 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: Hillman, Alex ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || || 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
Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
It seems sarcasm may be beyond you. Check the smileys for emphasis in Alex's mail. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 11, 2001 4:00 PM I disagree wholeheartedly with this statement Alex. How can you make this statement without knowing the situation? (You seem to be becoming the resident troller in this group! Sorry, but it does appear that way.) In spite of all evidence and repeated warnings, management often does not allow the most reasonable solution - preferring instead to play ostrich and simply throw hardware at the problem. Then one day even this isn't enough or it becomes prohibitively expensive and they want to hold someone else responsible for their own bad decisions - and the all too common scapegoat hunting expedition begins! That is when I usually forward to the hunters the same email that I sent them three years ago (and two years ago and a year ago , and six months ago, ...) analyzing the problem and proposing a reasonable solution - with attached proof (e.g. tkprof output showing how rewriting a few problematic queries can reduce CPU utilization by a factor of 72 and LIO by a factor of 6200! A real life example - that stayed like this for over three and a hlf years!). -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 11, 2001 1:40 PM Of cource you did not do your job properly. Or are you telling us that damagement did not do their job properly? I have never heard anything more ridiculous. :-). Alex Hillman -Original Message- Sent: Monday, June 11, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Jared wrote: I just *had* to point this out. Had too many damagers want to solve everything by buying HW when they have no idea what the problem is. how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM made the application fly. Until we hit THE ultimate peak stress day and they died. I had spent the year prior screaming about how the application needed some serious rewrite or we would die on that day. Database had been designed (if you can call it that) by people who did not know Oracle and so recreated their flat file system. They told me that the reason we died was because I had not done my job properly. What's wrong with that picture? _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing
RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
LOL! You got one, Alex. || -Original Message- || From: Don Granaman [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 11, 2001 4:01 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O || || || I disagree wholeheartedly with this statement Alex. How can || you make this || statement without knowing the situation? (You seem to be || becoming the || resident troller in this group! Sorry, but it does appear that way.) || || In spite of all evidence and repeated warnings, management || often does not || allow the most reasonable solution - preferring instead to || play ostrich || and simply throw hardware at the problem. Then one day even || this isn't || enough or it becomes prohibitively expensive and they want || to hold someone || else responsible for their own bad decisions - and the all too common || scapegoat hunting expedition begins! That is when I usually || forward to the || hunters the same email that I sent them three years ago || (and two years ago || and a year ago , and six months ago, ...) analyzing the problem and || proposing a reasonable solution - with attached proof (e.g. || tkprof output || showing how rewriting a few problematic queries can reduce || CPU utilization || by a factor of 72 and LIO by a factor of 6200! A real life || example - that || stayed like this for over three and a hlf years!). || || -Don Granaman || [certifiable OraSaurus] || || - Original Message - || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Sent: Monday, June 11, 2001 1:40 PM || || || Of cource you did not do your job properly. Or are you || telling us that || damagement did not do their job properly? I have never || heard anything more || ridiculous. :-). || || Alex Hillman || || -Original Message- || Sent: Monday, June 11, 2001 8:50 AM || To: Multiple recipients of list ORACLE-L || || || Jared wrote: || || I just *had* to point this out. Had too many damagers || want to solve || everything by buying HW when they have no idea what the || problem is. || || || how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM || || made the application fly. Until we hit THE ultimate peak || stress day and || they died. I had spent the year prior screaming about how || the application || needed some serious rewrite or we would die on that day. || Database had been || designed (if you can call it that) by people who did not || know Oracle and || so recreated their flat file system. || || They told me that the reason we died was because I had not || done my job || properly. || || What's wrong with that picture? || || || _ || Get your FREE download of MSN Explorer at http://explorer.msn.com || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Rachel Carmichael ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || || 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: Hillman, Alex ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || || 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: Don Granaman || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
Let's see. What was that rule of thumb I heard from Kevin Loney? I think it was that each index slows down DML by a factor of 3 (at least for batch jobs where you have to worry about recursive SQL). So 23 indexes would run about 70 times slower than no indexes. Do I sense a hardware throwing contest?? Henry -Original Message- Sent: Monday, June 11, 2001 4:01 PM To: Multiple recipients of list ORACLE-L On Monday 11 June 2001 09:06, Rachel Carmichael wrote: OLTP system, main order table had 23 indexes on it. Because they wanted to ?!?!?! That's just nuts. be able to search by customer first name, customer last name, recipient first name, recipient last name and had foreign keys all over the place. Sounds like Data Mart was a term they were unfamiliar with. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
I suspect, as with most 'rules of thumb', that Kevin's does not scale well. || -Original Message- || From: Henry Poras [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 11, 2001 4:42 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O || || || Let's see. What was that rule of thumb I heard from Kevin || Loney? I think it || was that each index slows down DML by a factor of 3 (at || least for batch jobs || where you have to worry about recursive SQL). So 23 indexes || would run about || 70 times slower than no indexes. Do I sense a hardware || throwing contest?? || || Henry || || -Original Message- || Sent: Monday, June 11, 2001 4:01 PM || To: Multiple recipients of list ORACLE-L || || || On Monday 11 June 2001 09:06, Rachel Carmichael wrote: || OLTP system, main order table had 23 indexes on it. || Because they wanted to || || ?!?!?! || || That's just nuts. || || be able to search by customer first name, customer last || name, recipient || first name, recipient last name and had foreign keys || all over the || place. || || Sounds like Data Mart was a term they were unfamiliar with. || || Jared || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Jared Still || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || 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: Henry Poras || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || 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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
as I said, 26 CPUs, 9GB RAM, lots of disks.. oh, and they wanted a bitmapped index on that table too somedays it don't pay to get out of bed From: Henry Poras [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O Date: Mon, 11 Jun 2001 12:41:32 -0800 Let's see. What was that rule of thumb I heard from Kevin Loney? I think it was that each index slows down DML by a factor of 3 (at least for batch jobs where you have to worry about recursive SQL). So 23 indexes would run about 70 times slower than no indexes. Do I sense a hardware throwing contest?? Henry -Original Message- Sent: Monday, June 11, 2001 4:01 PM To: Multiple recipients of list ORACLE-L On Monday 11 June 2001 09:06, Rachel Carmichael wrote: OLTP system, main order table had 23 indexes on it. Because they wanted to ?!?!?! That's just nuts. be able to search by customer first name, customer last name, recipient first name, recipient last name and had foreign keys all over the place. Sounds like Data Mart was a term they were unfamiliar with. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
Kevin's point is probably, that if each index has a depth (blevel) of three, then each index will add three LIO's to any DELETE or INSERT statement. For UPDATE statements, only the indexes on the updated columns count. LIO's mean cpu usage and latch pressure, which is why we want to mininize them in many situations. Mohan, Ross wrote: I suspect, as with most 'rules of thumb', that Kevin's does not scale well. || -Original Message- || From: Henry Poras [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 11, 2001 4:42 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O || || || Let's see. What was that rule of thumb I heard from Kevin || Loney? I think it || was that each index slows down DML by a factor of 3 (at || least for batch jobs || where you have to worry about recursive SQL). So 23 indexes || would run about || 70 times slower than no indexes. Do I sense a hardware || throwing contest?? || || Henry || || -Original Message- || Sent: Monday, June 11, 2001 4:01 PM || To: Multiple recipients of list ORACLE-L || || || On Monday 11 June 2001 09:06, Rachel Carmichael wrote: || OLTP system, main order table had 23 indexes on it. || Because they wanted to || || ?!?!?! || || That's just nuts. || || be able to search by customer first name, customer last || name, recipient || first name, recipient last name and had foreign keys || all over the || place. || || Sounds like Data Mart was a term they were unfamiliar with. || || Jared || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Jared Still || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || 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: Henry Poras || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || 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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Venlig hilsen Mogens Nørgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
Alex, I think most everyone knew it was a joke. Not everyone will get your jokes. Not everyone gets my jokes. I wouldn't have it any other way. ;) Jared On Monday 11 June 2001 13:36, Hillman, Alex wrote: I hoped that everybody understand that this was a joke. I use damagement and :-) in the end. I hoped that it was grotesc. Apparently I was wrong. My apologies for all offended. For people who do not understand humor I repeate again that it was a joke. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
Title: RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O I could not get this URL to work, are you sure it is "platypus.com". I tried www.platypus.comand it came up with some other non-related site. I would be greatly interested in reading about this device. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Friday, June 08, 2001 6:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O It works just fine, but I think you will actually get more performance out of a solid state device. Take a look at platypus.com, they have a SSD device that plugs into the PCI board in your computer... They claim over 60 MB per second of data transfer. And the drives can go up to 500 GB... I think they can even daisy chain them if you need more. You will only need enough space for the redo logs, control files, and a locally managed tablespace that holds the data. It only took us about 20 minutes to install one on a Sparc Ultra 5 for some testing. And it works great. Nick -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: Veritas Quick I/0 and Oracle/ Asycnchronous I/O Will Oracle use the Quick I/O capability of Veritas on database writes; that is, will it bypass any file system buffer cache and write directly to disk? Is the implementation of asynchronous I/O imnproved in Solaris 8; does one have to use raw disks or does it now work properly with UFS or Veritas? I need to configure a machine to provide for the maximum number of transactions per second. Our Accelerator Controls folks are at it again, testing how much data they can push into Oracle. They have backed off the plan of having 6000 Beam Position Monitors sampling at 120 Hz write into the database; although., 720,000 transactions per seconds might be fun to try. But they do want to see what they can do. Obviously, the programs which collect the data from BPM's and other sensors needs to do some buffering. But when they dump to the database I need the writes to happen as quickly as possible. The current method of handloing this via ring buffers and doubly-linked lists. They want to look at replacing the lists with an Oracle database. Our initial tests will be done using a 4 processor ES-450. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
http://www.platypustechnology.com/default2.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
AWESOME looking website Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Sunday, June 10, 2001 4:34 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] http://www.platypustechnology.com/default2.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
Christopher Spence wrote: AWESOME looking website Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- From: Paul Drake [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 10, 2001 4:34 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O http://www.platypustechnology.com/default2.asp Christopher, I like the section that dicusses how it makes Citrix suck less. I was thinking about a pair of these for (oracle mirrored) online redo logs. 2 units of 1 GB each would have plentry of room - half for redo and half for swap. If it works really well, get a 3rd unit for swap alone - but it would have to be on another bus channel. this is where having multiple PCI bus channels (e.g. 4) really makes a big difference. 1 for internel storage (ultra 160/m SCSI) 1 for external storage (fibre channel or ultra 160/m SCSI) 1 for gigabit network cards (and backup fast ethernet card) 1 for PCI NVRAM for swap and online redo 64 bit slots allow for (max) 350 MB/sec transfers. wow. cdw has these (special order) - http://www.cdw.com/shop/products/default.asp?EDC=209969 the one listed looked like it supported a 32 bit interface. $2500 each. ouch. sounds like a good way of justifying an adequate number of hard drives for online redo. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
1 for PCI NVRAM for swap and online redo I totally buy into using this sort of technology for online redo, but using it for swap just seems silly. You shouldn't be swapping anyway, and if you are it's much cheaper to buy ram than to buy a solid-state disk. 64 bit slots allow for (max) 350 MB/sec transfers. wow. cdw has these (special order) - http://www.cdw.com/shop/products/default.asp?EDC=209969 the one listed looked like it supported a 32 bit interface. $2500 each. ouch. sounds like a good way of justifying an adequate number of hard drives for online redo. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
George Schlossnagle wrote: 1 for PCI NVRAM for swap and online redo I totally buy into using this sort of technology for online redo, but using it for swap just seems silly. You shouldn't be swapping anyway, and if you are it's much cheaper to buy ram than to buy a solid-state disk. 64 bit slots allow for (max) 350 MB/sec transfers. wow. cdw has these (special order) - http://www.cdw.com/shop/products/default.asp?EDC=209969 the one listed looked like it supported a 32 bit interface. $2500 each. ouch. sounds like a good way of justifying an adequate number of hard drives for online redo. Paul George, Agreed about it being silly for swap on a *nix box, but if you're running on a brain-dead OS that is going to page stuff out uncontrollably (NT/W2K) even with lots of available memory - its still a good idea to give the OS some pagefile space on NVRAM. I should have called it pagefile - not swap. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
Hmmm so it's a pci only interface, so I can't use it with my Enterprise Sun systems, and drivers for Tru64 don't yet exist, so unless you're running Windoze, AIX or Linux, you're out of luck. That's a real bummer. Anyone use Imperial's solid state disks? I played with them at a clients a few months ago. I had a few problems with DMP but they were otherwise very impressive. Fiber interface, so you can put them on a fabric switch and share them between your hosts. http://www.imperialtechnology.com/ On Sunday, June 10, 2001, at 06:05 PM, Paul Drake wrote: Christopher Spence wrote: AWESOME looking website Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- From: Paul Drake [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 10, 2001 4:34 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O http://www.platypustechnology.com/default2.asp Christopher, I like the section that dicusses how it makes Citrix suck less. I was thinking about a pair of these for (oracle mirrored) online redo logs. 2 units of 1 GB each would have plentry of room - half for redo and half for swap. If it works really well, get a 3rd unit for swap alone - but it would have to be on another bus channel. this is where having multiple PCI bus channels (e.g. 4) really makes a big difference. 1 for internel storage (ultra 160/m SCSI) 1 for external storage (fibre channel or ultra 160/m SCSI) 1 for gigabit network cards (and backup fast ethernet card) 1 for PCI NVRAM for swap and online redo 64 bit slots allow for (max) 350 MB/sec transfers. wow. cdw has these (special order) - http://www.cdw.com/shop/products/default.asp?EDC=209969 the one listed looked like it supported a 32 bit interface. $2500 each. ouch. sounds like a good way of justifying an adequate number of hard drives for online redo. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
George, Agreed about it being silly for swap on a *nix box, but if you're running on a brain-dead OS that is going to page stuff out uncontrollably (NT/W2K) even with lots of available memory - its still a good idea to give the OS some pagefile space on NVRAM. Ahh My lack of knowledge of running 'real' apps outside of a *nix environments constantly vacillates between shamefully poor and thankfully poor. :) George I should have called it pagefile - not swap. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
On Sunday 10 June 2001 14:35, Paul Drake wrote: http://www.platypustechnology.com/default2.asp Interesting product. This would be great for redo logs. I can't help picking at one of their 'success' stories however. This is from their website: This customer is running an SQL database on a DELL 6350 quad-processor system, with a fiber channel storage system. Under this configuration the time taken to access information from the database was taking more than seven minutes. This performance was unacceptable to the organization. Performance By introducing the Platypus Technology solid-state storage system to the SQL database, the time taken to access information was reduced from seven minutes to a maximum of two minutes, representing a threefold increase in performance. The result is that the Platypus Technology solution is allowing far greater productivity from the substantial ERP investment the company has made. --- This appears to be one of those cases of management throwing money (hardware) at a problem, but they're still stuck with the problem. Taking response time down to 2 minutes still sounds unacceptable to me. There are bigger problems here; the customers system is in serious need of tuning. I just *had* to point this out. Had too many damagers want to solve everything by buying HW when they have no idea what the problem is. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
Title: RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O It works just fine, but I think you will actually get more performance out of a solid state device. Take a look at platypus.com, they have a SSD device that plugs into the PCI board in your computer... They claim over 60 MB per second of data transfer. And the drives can go up to 500 GB... I think they can even daisy chain them if you need more. You will only need enough space for the redo logs, control files, and a locally managed tablespace that holds the data. It only took us about 20 minutes to install one on a Sparc Ultra 5 for some testing. And it works great. Nick -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: Veritas Quick I/0 and Oracle/ Asycnchronous I/O Will Oracle use the Quick I/O capability of Veritas on database writes; that is, will it bypass any file system buffer cache and write directly to disk? Is the implementation of asynchronous I/O imnproved in Solaris 8; does one have to use raw disks or does it now work properly with UFS or Veritas? I need to configure a machine to provide for the maximum number of transactions per second. Our Accelerator Controls folks are at it again, testing how much data they can push into Oracle. They have backed off the plan of having 6000 Beam Position Monitors sampling at 120 Hz write into the database; although., 720,000 transactions per seconds might be fun to try. But they do want to see what they can do. Obviously, the programs which collect the data from BPM's and other sensors needs to do some buffering. But when they dump to the database I need the writes to happen as quickly as possible. The current method of handloing this via ring buffers and doubly-linked lists. They want to look at replacing the lists with an Oracle database. Our initial tests will be done using a 4 processor ES-450. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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).