Mike Ault's thoughts on various topics, Oracle related and not. Note: I reserve the right to delete comments that are not contributing to the overall theme of the BLOG or are insulting or demeaning to anyone. The posts on this blog are provided “as is” with no warranties and confer no rights. The opinions expressed on this site are mine and mine alone, and do not necessarily represent those of my employer.
Thursday, February 25, 2010
So, after 1:45 Susan and I jump back in the car for the 4 hour drive back to Alpharetta. We'll be swinging by Susan's folks and picking up the signed books for Dr. Kuntz (he purchased 10 of my father-in-law's books) and dropping them off on the way home. If anyone is interested in the book, it is called a"A Kick in Your Caduceus" and can be found here. 50% of all proceeds for the book go to Alzheimer's research.
The next stop for conferences and shows is the TMS Roadshow in San Jose. Hope to see you there!
Friday, February 19, 2010
Why am I so enthusiastic about this new architecture? In tests, by only switching on this architecture in an existing structure we were able to achieve a 9-10 times performance improvement. Time to execute a test run of 2,000,000 SQL statements dropped from 12 minutes to 1.3 minutes. Latency dropped from 13 ms to less than 1 ms. Here is a link to the entire paper describing this architecture:
While the paper describes an Oracle based architecture, the concepts it describes could be used for any read-intensive application with the use of a disk management system that allows preferred-read mirrors to be utilized.
of course the beauty of this architecture is that it makes use of and accelerates your existing IO subsystem without any changes to the tables and indexes or your application.
Thursday, February 18, 2010
Of course in this more generic version of the paper I have reworked the OPERA acronym into "Oracle Performance Enhancing Reliable Architecture" an removed specific references to the RamSan-620 (other than in the pictures) to be able to give this great presentation and not come across as an advertisement which of course is a no-no at almost all Oracle conferences unless you are doing an allowed and sanctioned product presentation. Fear not, whether the paper uses RamSan or SSD the architecture it espouses is just as valid and performance enhancing!
In speaking with some of my contacts here I found out something interesting for you MySQL folks out there. MySQL as it sits right now can only properly utilize about 4 CPUs before not so good things start happening. Well, there should be a new release soon that will properly handle up to 32 CPUs. Looks like Oracle is keeping their word not to interfer with the further advancement of MySQL in the OpenSource environemnt.
Well, I have to pack and then do the normal morning duties so I can meet Lee Miles for breakfast at 6:50 (the showroom floor opens at 07:30) so that is all for now.
Wednesday, February 17, 2010
My first presentation "Going Solid: Determining What in Oracle to Put on Tier Zero" came off without a hitch with lots of interest and great questions. We've seen lots of activity at the booth with many people very curious about the benefits of SSD technology in their environment.
Well, it is off to lunch, I will try to post more later in the day after I see a few presentations.
Monday, February 15, 2010
So...I published Doc's book, a collection or anecdotes from his 47 years as a country doctor. It started as a roughly printed manuscript that lingered for 10 years in the back of a closet. I scanned it in to my computer and used OCR (optical character recognition) software to recover as much of the text as I could then spent several nights correcting, editing and typing in hand written changes and additions that didn't make it in to a final printing the first time. Doc also painted, scenes for his life, scenes for day to day living. I then added pictures of Doc's paintings where I could find some that were at least tangential to the story being told.
2 years ago Doc was diagnosed with Alzheimer's. Luckily it isn't a severe form...yet. He still recognizes us but his memory stops short of his second great-grandchild, Hannah Marie, my grand daughter. Anyway, to try and do my bit for helping to eliminate this brain stealing disease, half the royalties will be donated to Alzheimer's research and the other half to help cover Doc's future medical and care costs in the future.
Doc wasn't aware (neither was Mary) that I was doing this, Susan, Marie (my oldest daughter) and I did a real good job of keeping it secret. We gave a proof copy to Doc on Valentines day. At first he didn't know what it was, until he recognized his drawing on the cover and saw his name as author! His eyes lit up and he spent then next several minutes paging through, reading here and there and remembering. Mary (his wife of over 50 years) got wide eyed and I think she was about to cry, if you could know Mary you know how much that is saying. Anyway, they both gave their support to making it publicly available.
Here is the books website, have a look!
Friday, February 05, 2010
Now using RAC and going with multiple instances I was able to increase that number as a factor of the number of nodes. However that seems to be a very complex method.
So, anyone out there have some good tips for loading data quickly into Oracle? Currently I am going from a memory cache (filesystem) using external tables directly into an internal table, use of APPEND made no difference since the table is new.
Eventually I would use the table to do a partition swap as soon as the table reaches a specific size and start a new table loading. For right now I just have to maximize the load speed going from an external table to an internal one.
Anyway, I will post more information as I find more.