Search

OakieTags

more tags

Who's online

There are currently 0 users and 37 guests online.

Recent comments

Affiliations

Home » Monthly archive

June 2010

Upcoming Index Seminar Dates (The Tourist)

Submitted by Richard Foote on Tue, 2010-06-08 13:25

I’ve just finalised some European dates for my Oracle Index Internals and Best Practices Seminar for later in the year. Location and dates are as follows: Turkey (Istanbul): 18-19 October 2010 Germany (Munich): 21-22 October 2010 Czech Republic (Prague) : 25-26 October 2010 As usual, always a good idea to book early to avoid disappointment. [...]

Advert: See you in Utrecht next week

Submitted by doug on Tue, 2010-06-08 03:51

I'm excited to be teaching at Amis for one day next week and the more informal event the previous evening. Registration form is here. Showing my beloved pictures with beer in hand? Sounds perfect although perhaps I should make sure the demos are working correctly before opening the bottle ;-)

Lots more technical posts to come in the near future too, I'm just getting over jet-lag on top of a week in Las Vegas!

Oracle Exadata Storage Server: No More SQL Tuning Required? Hooray!

Submitted by kevinclosson on Mon, 2010-06-07 17:34

I sometimes wonder if folks think I prefer poorly-tuned SQL. After all, I like hardware and everyone knows how effective it is to throw hardware at a poor query plan. I think everyone in the world has already blogged it but I can’t resist the me-too excitement. On June 10 my fellow Oak Table Network [...]

Evolution of a SQL Plan Baseline Based on a DELETE Statement

Submitted by Chris Antognini on Mon, 2010-06-07 15:21

During an evolution the database engine compares the performance of two execution plans. The aim is to find out which one provides the better performance. For that purpose it has to run the SQL statement on which the SQL plan baseline is based and compare some execution statistics. The following output of the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function [...]

an unexpected visitor ...

Submitted by robyn on Sun, 2010-06-06 15:12

I got up early so I could plant a few things in the garden before I settled down to some writing this afternoon. I was on my way out the door, returned to my room to get my socks and noticed something long and black on the floor near my bed. Then I realize the thing was alive and flicking it's tongue at me:Interesting start to a Sunday morning: a 3 foot long black snake on my bedroom floor.

Oracle Internals and X$ tables

Submitted by mbobak on Sat, 2010-06-05 15:34

I try to be active on the OTN Forums, particularly the Database – General forum. Very often, I’ll see people asking about Oracle internals and X$ tables and where they can learn more. The answer is generally, that you can’t. It’s not possible to read up on stuff that’s largely undocumented. Further, you shouldn’t really care that much. While internals can be interesting, they rarely add a great deal of real, practical value.

This recently came up again in an OTN forum posting. I replied to the thread. That answer is reproduced here:

Do-It-Yourself Exadata-Level Performance? Really?

Submitted by kevinclosson on Fri, 2010-06-04 22:15

Oracle Mix is hosting “Suggest-a-Session” for OOW 2010. I thought that sounded like fun so I did the following…see what you think: Do-It-Yourself Exadata-level Performance? Since my blog has been essentially dormant for 2 months I expect about 43 click-throughs and no more than 42 votes And, yes, I will kick up my blogging again [...]

Quiz Night

Submitted by Jonathan Lewis on Fri, 2010-06-04 20:48

A recent question on OTN gave the following information: I’m having problem with my database (Oracle 8.1.7.2.0 on Solaris 9), which contains more than 1 row with a same value on a field that has uniqueness constraint. Could you please help tell me how to fix this? Here is the log from sqlplus. When I [...]

Oracle Mix – OOW and Oracle Develop Suggest-A-Session 2010 Now Open

Submitted by Richard Foote on Fri, 2010-06-04 14:34

Just a short note to let everyone know the Oracle Mix – OOW and Oracle Develop Suggest-A-Session facility is now open for the submission and voting of proposals to this year’s Oracle OpenWorld and Oracle Develop conferences. This is a great opportunity to let the “public” not only submit proposals for presentations and panel sessions but also to vote for those sessions [...]

Beginner/Expert

Submitted by Jonathan Lewis on Thu, 2010-06-03 20:34

I mentioned some time ago the presentation I did at Open World 2009 and Miracle Open World called “The Beginner’s Guide to becoming an Expert”. Over the last few months I’ve had a few people email me asking me if I’m going to post the presentation on my blog. The answer is no – because [...]