Ora-600 [Qctvco:Csform]

At one recent engagement we ran into a problem with queries against some views running slow. The CBO didn't use complex view merging because this was turned off due to a 10G bug. This bug is documented in Metalink note 437376.1: “A query involving inline subqueries from mulitple tables whose columns are encrypted using Transparent Data Encryption [TDE] results in ORA-600 [qctVCO:csform]”. The Oracle recommended workaround, turn off complex view merging, had been implemented (_complex_view_merging=false) at this site.
We resolved this by turning back on complex view merging, and targeting the views suffering from this bug one by one. We added the /*+ no_merge */ hint to the view definition. Now most queries ran fast again, and the queries on the views suffering from the bug didn't fail with ora-00600.

And this week Ric is in....

Quite a change from Atlanta. They tell me the week before I got here it was rather nice, but the snow and cold arrived just in time for me. Humm there seems to be a pattern going on here... This a shot from the classroom facility. Very flat here, you can see for a very long distance. As a hint they have a very large mall here, at one time the largest in the world I'm told.

Where is Ric?

I'm haveing a great time in _____. Weather is nice and the view from my hotel is great compared to what it was on the west coast a little while ago. Here is a picture of the nice view from the window. Can you guess where I am? (Karen, Stacy and Monty, you can't guess!!)

Fire in the West

I've been out here in Irvine CA teaching this week with the wild fires raging around the area. I haven't been closer then 3-4 miles from the fires so not a big threat to me from the fire it self. However the smoke and ash from these fires is everywhere. This is a shot as I left my hotel yesterday and that is not morning clouds, that is smoke you see between the buildings. Fortunately I'm inside for the vast majority of the day and the air conditioning systems seem to filter out most of the smoke. I can still smell smoke inside, but not like out side. My eyes still sting sometimes when I'm out side.

100,000

Back when I was a kid, a car turning over 100,000 miles was a big deal. The odometer on most cars back then didn't even show 100,000. Today it's pretty common for a car to "roll over" as we used to say. I was able to catch it happening on my car the other day. Still a cool thing to see.

Summer Safety Tip: Vinyl Siding and Gas Grills

I suppose this happens to folks now and then, we forget to turn off the gas grill after cooking up some burgers for the family. Just be sure your grill isn't close to the vinyl like we see here. Fortunately for this person (who will remain nameless) the job to fix the siding cost about $30 at the local home depot and about 3 hours of time.

In Normandy

While here in Amsterdam I took a side trip this last week end to Normandy where the liberation of Europe started on June 6th 1944. I visited Pointe-Du-Hoc where the US Rangers climbed 100 foot cliffs to neutralizer an observation point which could have brought down devastating artillery fire on the landing beaches of Omaha and Utah. I also visited the Omaha beach where the US 1st and 28th divisions landed and suffered the worst casualties of the day. And I saw the US cemetery behind Omaha beach. I've read about the landings and battles across Europe for years, so this was a great event for me.

Too early!

This morning at 6:33 my alarm starts blaring... Now, this is my second night in this hotel, yesterday morning nothing happened, and I did not touch the alarm clock.
This is not the first time this happened to me. So I'm suspecting a conspiracy. Or is the cleaning staff punishing me for not leaving a tip yesterday?

Going to Amsterdam

I'm going to Amsterdam next month to teach a couple of classes, so I thought I'd ask Google how to get there. Over all thing looked ok until I got to step 29:

Google TiSP: Going with the Flow

Google provided a nice April Fool's prank this year. I even thought the press release was real for about 5 seconds...then I looked at the installation page. The guys at Google must have the 2nd best job on the planet (2nd only to mine, of course!) if part of their job is to come up with stuff like this!

Which one are you?

PC, Mac or Linux? I had to chuckle at this.

Hotsos Newsletter Correction

Hotsos Newsletter Volume III - Issue 10 had an inadvertant truncation of the Tips & Techniques article written by Ric Van Dyke on "Delayed Block Cleanout and Read Only Tablespaces" when it was distributed. You can view the entire article in the newsletter copy stored on our web site.

Don't miss the punchline! Visit the link to get the full text of the article.

Have someone look at your work!

Did anybody notice the main Google search page today? The problem actually had to be pointed out to me as my eye didn't catch it initially, but obviously I'm not the only one who didn't see the problem.

So...have you Googed anything today?

Six Students, Five Continents

This week I taught a Performance Diagnosis (PD) class in Dallas with six great students. And we realized that we had five continents of the planet represented in the class! That is pretty darn good for such a small group. Africa, Asia, Australia, North and South America. No penguins…

Also we all got to sing Happy Birthday to Cary when he stopped in for a quick visit. Big bonus for every one!

The roof, the roof, the roof is on fire?

It has been cold in Austin the last couple of days. The result of two days of freezing rain: a thick layer of ice on my roof! OK, not a strange sight in some parts of the country, but here in Texas...

I sure don't need no water :-)

Hotsos Support Discussion Forum

We've recently consolidated our class forums into our main support facility. You can now find the new Hotsos Discussion Forum here.

At the Discussion Forum, you can discuss Hotsos products, services, events, and techniques. Feel free to ask new questions or post your own responses to questions or post responses from other posters.

Drop by and join in!