Last week I was able to attend a 3 day exadata workshop conducted by performance engineers from Singapore. It was supposed to be a 5 day workshop with hands on labs but everything was squeezed (unfortunately no hands on) and just the critical sections were tackled.. The workshop highlight was the demos and these are as follows:
- loading large amount of data from an external table
- cell offloading on a typical datawarehouse query
- creation of a 400gb tablespace
- linear scalability of storage cells
A couple of weeks ago I tweeted a projection that the $/GB for flash drives will meet the $/GB for hard drives within 3-4 years. It was more of a feeling based upon current pricing with Moore’s Law applied than a well researched statement, but it felt about right. I’ve since been thinking some more [...]
I have forgotten and searched for this cool VirtualBox Appliance, now so often that I found it time to make a small notepad/placeholder for this.
For those who haven't found it yet, there is a OTN Developer VirtualBox appliance out there that is a great start-up environment to use as a test, presentation, try-out or development environment. Probably officially used for Oracle demo's and or Hands on Exercises (HOL) but also very usable on a laptop.
Its a VirtualBox environment with Hands on Lab (HOL) exercises and the following software environment/software:
Be aware that, as it is described as well on the download instruction page, that this appliance is for testing purposes only, as such it is unsupported and should not to be used in production environment. I really hope they make more of those cool VirtualBox example appliances.
Randolf Geist has written a good article about systematic troubleshooting of a PL/SQL memory allocation & CPU utilization problem – and he has used some of my tools too!
I haven’t had much spare time for writing this week – although I’ve got about 45 drafts of notes to publish – but Simpletalk have just published the “learning SQL Server” paper I sent them a couple of weeks ago, and it’s worth a link. Filed under: SQL Server
About a year ago I’ve discovered nice feature of Oracle 10gR2 CBO: to overcome an issue with calculated selectivity for predicates on multiple columns, it can use DISTINCT_KEYS of the available index. Couple of weeks ago the bug fix mentioned in the OTN thread actually helped to solve a performance issue of a query. And [...]
Just a short note for anyone near the Canberra region that the next ACT Oracle User Group Seminar Session will be held next Wednesday, 2 June 2010 at the Oracle Offices in Turner. I’ll be presenting “Indexing New Features and Improvements Introduced in Oracle 11g Release 1 & 2″. Follow the above link for the full agenda. [...]
|Tune in for the Ultimate SQL Tune-off|
According to Jonathan Lewis, there is a basic strategy to writing efficient SQL, but it requires knowledge of the data, the metadata, and the intent of the query.
Jonathan will start with the basic principles of efficient data access and then show different ways of analyzing the data. He'll then describe a graphical approach to finding the most efficient access path for a query and then apply the method to a problem he recently saw with one of his clients.
But wait... is there more than one way to skin a cat? Kyle Hailey thinks so, and he's not afraid to let Jonathan know it!
Kyle's fancy footwork will include his own approach to Visual SQL Tuning (VST) with some ring side support from DB Optimizer XE. Hitting below the belt? You be the judge.
Live! June 10, 2010 at 11AM Pacific
I’ll be doing a joint event with Kyke Hailey of Embarcadero in a few days time. It’s going to be a little unusual – a simultaneous webcast from opposite sides of the Atlantic – mixing my presentation about using a graphic method of tuning SQL with Kyle taking on the role of an active audience [...]
I’ve just popped this posting to the top of the stack as the best place to mention a change in my “public appearances” listing. There’s still a link in the “Special Links” list near the top of the right hand column, but this now points to a page on the blog rather than to a page on my old web site. This should make it a little easier to keep it up to date in a more timely fashion.
I will be speaking at a couple of events for the UKOUG, over the next few months. The next is in Scotland on 8th June (details not yet published) – for a joint effort with Tony Hasler to repeat the debate I had with him at the UKOUG annual conference: “Does Oracle Ignore Hints”.
Moving out from the local user group – I will be heading to Zurich, Switzerland for May 24th/25th, to take part in the Trivadis Performance Days 2011 where I’ll be doing my presentation on “How to Write Efficient SQL”, and ending the event with my interactive “Beginner’s Guide to becoming an Expert” and one other presentation. And in other events in mainland Europe, I’ve got a date with DOAG (the German Oracle user group) for an event on 14th/15th September to present the two-day “Optimising Oracle – Foundations” course.
In the Oracle University “Celebrity Seminar” series I’ll be in in Prague (Czech Republic) in May and Munich (Germany) in June. For more details see the “Public Appearances” link near the top of the right-hand panel.
If you need to persuade anyone that they should give you the time and money to attend one of my full-day events you might want to show them these blog reports of three of my one-day tutorials: