Search

OakieTags

more tags

Who's online

There are currently 0 users and 25 guests online.

Recent comments

Affiliations

Home » Monthly archive

May 2010

Seeing Exadata in action

Submitted by karlarao on Sun, 2010-05-30 12:34


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

“Flash” Storage Will Be Cheap – The End of the World is Nigh

Submitted by James Morle on Sat, 2010-05-29 21:21

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 [...]

Oracle OTN Developer Day VirtualBox Appliance

Submitted by marco on Sat, 2010-05-29 17:37

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:

  • Oracle Enterprise Linux 5
  • Oracle Database 11g Release 2 Enterprise Edition
  • Oracle TimesTen In-Memory Database Cache
  • Oracle XML DB
  • Oracle SQL Developer
  • Oracle SQL Developer Data Modeler
  • Oracle Application Express
  • Oracle JDeveloper
  • Hands-On-Labs (accessed via the Toolbar Menu in Firefox)

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.

Click here for the Pre-Workshop Setup Instructions - Hands-On Labs

 

Oracle OTN Developer Day VirtualBox Appliance

Oracle memory troubleshooting article

Submitted by tanelpoder on Fri, 2010-05-28 17:37

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!

http://oracle-randolf.blogspot.com/2010/05/advanced-oracle-troubleshooting-session.html

Share/Bookmark

SQL Server 3

Submitted by Jonathan Lewis on Fri, 2010-05-28 06:29

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

Extended statistics and function-based indexes

Submitted by Timur Akhmadeev on Thu, 2010-05-27 21:37

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 [...]

ACT Oracle User Group Seminar Session: 2 June 2010

Submitted by Richard Foote on Thu, 2010-05-27 13:08

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. [...]

Visual SQL Tuning Webinar with Jonathan Lewis June 10, 2010

Submitted by khailey on Thu, 2010-05-27 06:45
Register for the live webinar on June 10th here:

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

Visual Tuning

Submitted by Jonathan Lewis on Wed, 2010-05-26 20:47

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 [...]

Coming Soon

Submitted by Jonathan Lewis on Wed, 2010-05-26 09:32

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.

UK

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”.

Mainland Europe

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: