Search

OakieTags

Who's online

There are currently 0 users and 36 guests online.

Recent comments

Affiliations

March 2012

UK Oracle User Group Council Elections

If you are a member of the UK Oracle User Group, you are entitled to vote in the elections to the council. The polls close this week on Thursday 8th March.

You can vote on-line at http://www.ukoug.org/other/councilvote/.

Regular readers of this blog will have an interest in the PeopleSoft community. Steve Smith has been a deputy chair of the PeopleSoft Technical SIG for several years, and is standing as the representitive of the PeopleSoft community in the UK, and I urge you  to support him,

UK Oracle User Group Council Elections

If you are a member of the UK Oracle User Group, you are entitled to vote in the elections to the council. The polls close this week on Thursday 8th March.

You can vote on-line at http://www.ukoug.org/other/councilvote/.

Regular readers of this blog will have an interest in the PeopleSoft community. Steve Smith has been a deputy chair of the PeopleSoft Technical SIG for several years, and is standing as the representitive of the PeopleSoft community in the UK, and I urge you  to support him,

Create a database link with the new host:port/service syntax

I just noticed that (finally) in 11.2 this syntax is supported:

SQL> CREATE DATABASE LINK demo_x2 
  2  CONNECT TO tanel IDENTIFIED BY password 
  3  USING 'exadb03:1521/DEMO';
Database link created.

This just makes life a bit easier as there’s no need to use the long TNS format entry (or a tnsnames.ora/LDAP alias). It might work in 11.1 too (haven’t tested) but it didn’t work on 10.2.0.4 …

Update: This feature works for dblinks in 10.2 onwards – when I tested it on my 10.2, I got an error initially, but it was because the hostname I used didn’t resolve to an IP. Thanks to Randolf Geist for pointing this out.

In case you didn’t know, the sqlplus supports such an easy connect method since 10g:

Dates on articles…

Over the weekend, someone wrote to me asking about the lack of dates on my website articles. I tried to reply to them directly, but their mailbox bounced everything back, so I though I would write it here on the off chance they read my blog.

As the original poster correctly pointed out, there are no dates on my website articles. When I started the website many years ago it just never crossed my mind to put dates on the articles and I’ve seen no reason to include them since. Why not?

Count(*)

A recent posting on the comp.databases.oracle.server newsgroup pointed me to a rather elderly Ask Tom question (originally posed in July 2004, last updated June 2011) where Tom produced an extraordinary observation. The response times for the following two queries are completely different (on Oracle 9.2 on his data set):

Hotsos 2012

Here I am again – in the BA lounge at Heathrow waiting for a plane. Take-off is in 45 minutes, and I land in Dallas at 14:40 local time after nine or ten hours of flying time. The movie selection looks good this month, so I don’t think I’ll need to worry about the entertainment.

If you see me aroundt the Omni over the next few days, feel free to come up and say hello – despite any rumours to the contrary I am an ordinary human being and you won’t get struck by lightning if you get too close. (I also tend to head for bed early in the US, so don’t assume that I’ll be around the bars or restaurants later in the evening – but I might be in the gym around 5:00 am)

Looking forward to seeing you.

 

 

Book Review: Oracle Database 11gR2 Performance Tuning Cookbook (Part 1)

March 3, 2012 Oracle Database Performance Tuning Test Cases without Many “Why”, “When”, and “How Much” Filler Details http://www.amazon.com/Oracle-Database-Performance-Tuning-Cookbook/dp/184... I ordered the “Oracle Database 11gR2 Performance Cookbook” book shortly after it became available for purchase.  I was very curious to see how the book compared with the similarly titled “Oracle Database 11g Performance Tuning Recipes” book, [...]

Oracle Database Appliance (ODA) Patch Bundle 2.1.0.3.0 Fixes CPU Performance Issue

If you are using Oracle Database Appliance (ODA) then this patch is very important to apply. The patch bundle 2.1.0.3.0 has been published just this week and the most important fix from my perspective is the new BIOS version 12010304. Intel CPUs have a feature called Software Controlled Clock Modulation that allows programmatically control of [...]

Availability Infrastructure & Management SIG March 14th 2012

I am proud to be able to speak at the first instalment of the Availability, infrastructure and management SIG on March 14th in  the London City office.

The event is announced on the UKOUG website here:

http://www.ukoug.org/events/ukoug-availability-infrastructure-and-management-sig-meeting/

Unfortunately I will be between you and lunch! I hope that works out, and I don’t overrun.

Editing Hints in Stored Outlines

Introduction 
This note describes changing a hint in a SQL Outline by updating the OUTLN.OL$ and OUTLN.OL$HINTS tables directly. It shows that in the limited test case that it does affect the resulting execution plan.  

CAVEAT: This is a hack, so this is more of an oddity that something that I would recommend for use in production. I am only interested in it for the limited purpose of adding a NO_EXPAND hint to an outline, that would not otherwise be included if the outline was generated in the conventional manner.

Why Outlines?