Oracle Notepad vi

How Can I?
Book Reviews
User Groups

Legal Notice & Terms of Use
Privacy Statement

Blog Archives
Friday, November 19, 2010
The conference here in Pravets has been a lot of fun. Much like my experience in Germany ... the skills and professional skill of the practitioners here in Europe greatly exceeds that of those I routinely see in the US. I've got the pictures ready to post so here's the link for DOAG (Germany), BGOUG (Bulgaria), and if there are pics from UKOUG I will post them here as well. [Click Here]
Wednesday, November 17, 2010
I am currently in Germany attending DOAG. Heading for Sofia Bulgaria tomorrow and then to the UK. I will post pictures and a bit more soon.
Tuesday, October 26, 2010
I have the pages reasonably complete from the OTN LAD tour so click on the link, below, and enjoy.

Now for a little rant. And if you recognize yourself in this consider yourself taken out to the woodshed and severely beaten.

I am fighting a team of DBA's that, I hope, would be horrified if they ever went to a surgeon, dentist, attorney, or accountant who had the same level of skill his or her profession as these DBAs have in theirs. I am not SYS and can not either train them or fire them but ... good grief ... take some pride in what you do and take some classes, read some books (not books about 8i and 9i) and understand your responsibilities to your employer and your customers. If your employer won't invest money in you invest it in yourself.

How can I, as an outside vendor, help you to understand that the reason your database is slow is that you do not have sufficient skill to manage it? How can I convince your manager of the critical importance of finding the training dollars necessary to either get you the education you need or to bring in someone senior enough to mentor you.

I have bitten my tongue bloody not saying out loud what I am thinking.
Monday, October 11, 2010
I've done a lot of things since August ... gone to OpenWorld. Gone to ClosedWorld and I may find the time to write about them ... who can say. But right now I am in Lima Peru and I am beginning to record my journey on the OTN (Oracle Technology Network) Latin America Tour. I will write about it a bit more but for starters here is a link to the pages I am starting to build. These initial pages cover preparations for the trip, the trip into Lima Peru, and the tour of Cusco and Machu Piccu. [Click Here] and enjoy. I will be adding more pictures, text, and pages as the trip goes on and time permits.
On arriving in Cusco Stanley immediately went native with coca tea Then complained about altitude sickness and has some more
Fully prepared for altitude Stanley visits Machu Picchu Stanley enjoys a Cusquena at Chi Cha in Cusco
Saturday, August 28, 2010
Getting ready for OpenWorld and cleaning up the hard disk a bit ... here are a few pics I thought worth sharing.
Mogens in Tallinn Bigger than yours my friend
A lot bigger than yours. ;-)   (this is from slide 1 of 5) Morgan and Chris Date in Tallinn
Friday, August 27, 2010
Back in Seattle from a great conference with the NWOUG in Portland Oregon. Reconnected with a lot of friends from around the region including Jeremiah Wilton, Holly Willey, Dale Rae, Lee Murray, Neil Isenberg, Terry Golden, and the leadership Board of NWOUG. Presented on "11gR2 New Features that Oracle Doesn't Talk About" and Edition Based Redefinition" and took a few pictures you can view if you [Click Here].
Friday, August 20, 2010
Went down to the Bay Area to enjoy the warmth, the sunshine, and California hospitality with friends at NoCOUG. I pulled out the Nikon a few times and here are some pictures that made it past the censors [Click Here].
Friday, June 4, 2010
We now have more than 15,000 years of human history during which events like this, and far worse, have happened again and again and again.

And from each of these events we have learned precisely nothing. Each new tragedy leaves the apathetic public scratching heads and wondering why all of the assurances by those solely focused on profits did not protect them. In a few short weeks, or months, Paris Hilton will re-emerge and we will again amuse ourselves to death.

"The human race, to which so many of my readers belong, has been playing at children's games from the beginning and will probably do it 'till the end, which is a nuisance for the few people who grow up."

~ G. K. Chesterton
   The Napoleon of Notting Hill (1904)
Friday, May 21, 2010
It is 6:00am in Tallinn and the sun has now been up for three hours.

Today one of the father's of relational algebra and the relational database, Christopher J. Date, will be presenting three seminars: (1) The Closed World Assumption, (2) An Introduction to Logic, and (3) Why Three-Valued Logic Doesn't Work.

By some miracle I present on EBR after he is done. Who would want to come to an empty room. I wouldn't even come to my own seminar if Chris was presenting.

Chris is currently writing four books, I encouraged him to write the history, from his perspective, of the relational database revolution, we talked about the good old days when 360s and 370s were the face of computing when IBM couldn't get out of its own way and handed the database industry to Ingres and Oracle.

I have a firm invitation to be in Latin America in October. And an equally firm invitation at the same time to fly to Venice and accompany Joze Senegacnik to Slovenia and Croatia for the HROUG conference in Rovinj. Decisions decisions.

You can follow this link to my pictures from Tallinn.
Thursday, May 20, 2010
Heli made a big deal out of the importance of the ACE program to the Baltic countries and Russia and we had a full-house for the presentation. I was joined by Mogens Norgaard, Francisco Munoz Alvarez, Tuomas Pystynen, and Piet de Visser. Among those attending is the current Chair person of RUOUG and Dmitry Volkov of Oracle Russia. Tanel presented a paper titled "Understanding LGWR, log file sync Waits and Commit Performance" that should be mandatory for every IT professional touching a keyboard connected to an Oracle database, and we had dinner at the House of the Brotherhood of Black Heads, the name of which would require more space to explain than I have here. <g>

But there is no question that the highlight of the day was Mogen's telling the story of the "Whiskey on the Rocks" to the audience. If you are not familiar with what most people think happened [Click Here]. We, on the other hand, learned what really happened and it is payment enough for the pain I will feel Saturday waking up at 5:00am to fly Tallinn to Copenhagen to Amsterdam to Minneapolis to Seattle. A story worthy of many retellings. But you'll have to ask me in person for the verbal version. It is, after all, Mogen's story not mine.
Wednesday, May 19, 2010
Presented my second paper here at Orcan, Edition Based Redefinition, made the outrageous claim which I truly believe, that if you don't know EBR you will be essentially unskilled in Oracle within 5 years, joined Husnu and his wife for the taxi to the airport, and flown to Tallinn, Estonia. I will put together a paper of pictures after I get done editing them.

Heading for Tallinn so here's the link for the Stockholm-Orcan pics.
Tuesday, May 18, 2010
Arrived at Yasuragi in Hasseludden for Orcan. It is a combination of the simplicity that is Scandinavian elegance with the simplicity that is Japanese elegance: A planet or two away from Stockholm: A galaxy away from home. Presented my seminar on 11gR2 new features Oracle doesn't talk about ... although I did spend some time, also, on Hybrid Columnar Compression. Heading up to the third floor for sushi and saki not necessarily in that order.
Monday, May 17, 2010
In Stockholm Sweden ... third day ... this feels like it could be, should be, home. Last night, in the executive lounge we met another American couple, they were from Bothell, Washington ...moved there from Sweden 30 or so years ago and go home every year to see family and friends. Otherwise this has been a blessedly non-American trip. Not once have we been subjected to the gross ignorance and star spangled myopia that fuels US politics. Not once have we been forced to bite our tongues confronting belief systems based on nothing more substantive than 1960s flashbacks.

But lets not forget the trip that got me here.

In Shiphol Airport, Amsterdam, at the entrance to C Gates, there are two shops that tell you, without equivocation, you aren't in Kansas any more. The first, and one I visit every chance I get, is Bubbles. The best place in the airport to catch great salmon, sushi, and champagne. This is where civilized life resides and where everyone is interesting and every conversation equally so. Today I met someone traveling from Northern Ohio (via Detroit) to Stockholm and a PhD biologist from Trondheim Norway for a fascinating conversation.

Just a few feet away, pictures below, is the Chocolate Bar. And while I have so far resisted temptation it is just another sign that airport food need not be Burger King and other tributes to mediocrity.


Friday, May 14, 2010
If you do not recognize yourself ...

perhaps you are in the wrong business ...

or reading the wrong blog.
Tuesday, April 20, 2010
Arrived yesterday at Keflavik Airport in Reykjanesbaer Iceland. I am dressed for Norway, not Iceland, and most of those here at the hotel are refugees. Compared with refugees from various wars and genocides this has been a walk in the park. But the perspective it has given is not lost upon this observer. Volcano tours appear to be canceled as you will see from the pictures from the University of Oslo, the airport, and the trip to Keflavik [Click Here].

Flying, non-stop, back to Seattle on Wednesday. Nothing to do except walk the neo-Siberian tundra and commune with the wind-chill and wait.

I just tried that "walk on the wild side." 22 minutes and I surrendered to the beginning of frostbite ... and it is snowing. The Icelandic Air presentation on the plane coming in here boasted that Iceland had a mild climate because it is warmed by the Gulf Stream. Mild compared with what? Vladivostok? Three weeks ago I was walking with penguins on the beaches of South Island New Zealand ... in a tee shirt.
Saturday, April 17, 2010
I've assembled a few selected pictures from the conference trip for your viewing pleasure: [Click Here]. And, on behalf of my many friends in the UK ... "We said send "Cash" not "ash."

Looking at the political news from the US right now I am reminded of a quote from the 1960s and the Cold War which I will paraphrase: "If the Democrats announced that they were going to go to to hell ... Republicans would announce a plan to get there first."

Anyone wondering when, or if I am coming home, before the Orcan conference in Stockholm in just three weeks here are my plans. And I use the word "plans" with quotes ... (1) Tuesday Oslo -> Frankfurt -> Seattle, (2) Oslo -> Helsinki (by train) -> Tallinn (by ferry) -> Moscow (by airplane) -> Los Angeles -> Seattle, and finally (3) Oslo -> Bergen (by train) -> Newcastle (by ferry) -> London (by train) -> Oxfordshire (by train or bus). Anybody need a DBA? ;-)
Friday, April 16, 2010
The Eyjafjallajokull volcano has erupted in Iceland. For such a little country they sure can create big messes for everybody else. <g> Heading for the Radisson Blu and trying to figure out whether to stay or go ... and if to go ... where and how?

I've worked out a deal to teach at the University of Oslo on Monday in the last two hours. Now it is up to the Moirae as to what I do on Tuesday.
Tuesday, April 13, 2010
Arrived in Oslo after an easy an uneventful trip through Frankfurt Germany. Going out tonight for dinner at Tjuvholmen Sjømagas with Trules, Debra, Sten, Harald, Joel, and a few other friends. More soon: But probably not until the Color Magic returns to port on Friday.
Just signed on to Twitter and found Justin tweeting about some Oracle Cloud Computing event. Seeing it reminded me that it was mandatory learning for everyone to watch to this YouTube video.

I put Cloud Computing right up there with all the other marketing jargon. Our industry seems to leap from one nonsense phrase to another as companies try to claim their brand of toilet paper is better than the other guy's. Wash your clothes or brush your teeth with "Brand X" and see where that gets you. Where are all the object databases? Where are all the XML databases? Now it is "the Cloud."

In three years will anyone other than Amazon and Google have any use for NoSQL databases?

A database that can not deliver a correct answer has limited utility. A phrase, like "Cloud" is just the latest nonsense phrase.

What makes Oracle different is that after you peel away all of the checkboxes on the marketing brochure, and all the market-speak about value and cost of ownership, there are very real redo logs, undo segments, atomic transactions, and system change numbers. The stuff that actually works.
Wednesday, March 3, 2010
I'm a bit slow here but I've finally started putting up pics from New Zealand. You can find them [Here].
Monday, March 1, 2010
If you have yet to meet XKCD

Here's your invitation

[ Click Here ]

Thursday, February 18, 2010
Here I am at Denver Irrational Airport (a pathetic follow-on to the beloved Stapleton of days past) following a Rocky Mountain User Group training and conference event that is clearly best-of-breed for North America.

Among my personal highlights was being part of the Wednesday keynote panel with Chen Shapiro, Alex Gorbachev, and Debra Lilley, and managing, in the final half-hour of my hour-and-a-half presentation to do Edition Based Redefinition live in SQL*Plus.

Some people jump out of airplanes and trust their parachute. Some people jump up in front of audiences and trust their software. The later group likely suffers more catastrophic failures but I was once again spared that fate.

Among those here and presenting, not mentioned previously, and making this the event is was ... Mogens Norgaard, Cary Millsap, Jeremiah Wilton, Graham Wood, Jose Senegacnik, Sridhar Avantsa, and Robert Freeman (post-LDS job, now with Oracle).

Non-presenters included Angela, SQL*Developer product manager, who I hope to lure into presenting at the next WWOUG meeting and Dan Norris who insists that he doesn't sell Exadata but helps those that do, and Paul Veilleux, formerly with Larry's Pillar Data Systems returned to Oracle to also work with Exadata.
Keynote at RMOUG
Friday, January 29, 2010
Today is the last day of the IOUC Leadership Conference and, following the pics, I have posted a few comments from the event.
Mark Townsend w/ Stanley  
  Willie Hardie w/ Stanley
  • Extended support for Database 9i (9.0 and 9.2) ends July 31, 2010
  • Extended support for Database 10g (10gR1 and 10gR2) begins August 1, 2010
  • Larry Ellison is dismissive of the entire buzz around the buzzword d'jour "Cloud" and "Cloud Computing." Hmmmm.
Margaret Lee w/ Stanldy  
Friday, January 01, 2010
From a private communication:
I have just confirmed that attempting to do GbE line rate TCP writes on e1000s is sub-optimal.

Customers that are using Intel e1000 NICS (or e1000e in the new Nelly) and are running the NFS client on ANY version of RHEL on either AMD or Intel,
will only see a sequential TCP write range of 75-85MB/sec. This is a GbE part. I don't know about 10GbE NFS client performance yet (I do now have 2
Intel 10GbE parts).

Broadcom 5700 parts are fine. nVidia MCP55 (a builtin found in AMD servers) are fine.

It is a corner case, but affects database performance for TCP writes and e1000s are ubiquitous parts.

TCP read is line rate
TCP write is about 70% of line rate
UDP read is line rate
UDP write is line rate

Line rate is PAYLOAD, so this is about 105-108. At the filer, this renders to about 113MB/sec

-- private communication from an Oracle Platform Engineering at Red Hat Software