Search

Top 60 Oracle Blogs

Recent comments

October 2011

A look into the Exadata infrastructure

An Oracle Exadata database machine consists of several parts: Intel based servers, infiniband switches, a cisco ethernet switch, a KVM switch and the hardware surrounding it like cables, 19″ rack, power distribution units. The Intel based servers are what “Exadata administrators” are administering the most. The intention of this article is to let the reader gain a little more insight into Exadata specific administration on those.

Two server layers: computing and storage
The two layers have quite different properties: the Exadata computing layer is Linux with Oracle grid infrastructure and the Oracle database software installed, very much as you would do yourself (if you install it in a strict OFA way), and the storage layer is Linux too, but with specific Exadata storage software.

UKOUG Oaktable Sunday 2011

UKOUG Oaktable Sunday 2011
Event date: 
Sun, 2011-12-04

 Why not join us for OakTable day on Sunday 4th December?
 
In a smaller setting, you can attend a dedicated set of sessions directly from a selection of OakTable members away from any potential session contention of the main conference. The sessions will be presented in just two streams, and will also be repeated on the Wednesday of the main conference, allowing you two chances not to miss some of the top sessions of the conference. Participants of OakTable Sunday will also receive the exclusive chance to win a selection of signed books by various OakTable members, and the opportunity to join the OakTable for an informal panel session and a beer. Attendees will receive a commemorative shirt to mark the event.
Sponsored by Scale Abilities Ltd and Miracle A/S.

To view the presentations on offer visit the agenda grids.
 
To register click here.

Simple SQL with and without Inline Views 2

October 26, 2011 (Back to the Previous Post in the Series) In the previous article of this series we examined a couple of moderately simple data retrieval requirements, and used inline views and/or analytic functions to solve those data retrieval requirements.  I recently saw another opportunity to help a person on the ERP mailing list with [...]

How to pass from a TABLE to a Matrix of Anydata. to pass a Matrix of Anydata to TABLE

How to pass from a TABLE to a Matrix of Anydata. to pass a Matrix of Anydata to TABLE.

Read the answer...

OTN APAC Tour: Beijing, China (update)

Following on from my previous post, once the OTN APAC event was over I managed to see some of the sights of Beijing and the surrounding area, including the Forbidden City, Tiananmen Square, the Great Wall and Ming Tombs. I’ve uploaded some photos here, but it seems my photography skills are getting worse, not better. I’m ashamed to say these are the better photos. Let’s not discuss the ones I’ve not bothered to upload. :)

I have a few suggestions for any travellers to China:

  • Do not consider driving yourself. The traffic is crazy! I’ve never seen anything like it before. I experienced several “we’re all going to die” moments in every trip I took. Probably the worst was when two lorries moved together with our minibus between them. If our driver had not sped up in time, I’m quite convinced the ACE program would have lost several members. As you may have already read, some of the ACEs were in a crash, but came out of it unharmed. I was only able to wear a seat belt on one journey because all but one of the vehicles either had no belts, or belts but nowhere to plug them in. This takes a lot of getting used to.
  • If you have any sort of respiratory issues, it’s probably best to avoid Beijing completely. The pollution is very bad. It quickly makes you feel like you’ve smoked 40 cigarettes for breakfast. Even at the Great Wall (50+km from the city) it is still really bad.
  • Make sure you have printed copies of the Chinese names for any locations you want to visit. Having an English address is pretty much useless. Even with the Chinese addresses, it was often very difficult, especially if the print was small.
  • Don’t rely on any cloud services for your journey. You need local copies of everything and any apps you want to work with should have full offline functionality. Why? The Great Firewall of China is very effective at blocking a variety of services. Most Google services were trashed. Gmail was intermittently offline and I was never able to access attachments. Google Docs essentially doesn’t exist. Google Reader would work for about 5 minutes at a time, then fail bigtime. Most annoyingly, I was unable to use Google to search for anything. :( I was able to search with Bing, but I could only see results in Chinese. Even when I switched to English, I still got results in Chinese. Like I said, be very well prepared because searching for information is not easy. I’m sure there are ways to cope if you are clued up, but I was a little naive and went with very little preparation as far as logistics were concerned.
  • Take money with you. I was able to get cash advances from my credit cards, but the ATM failed to get cash from any of my bank accounts.

I’m now stationed at my friends house about 40 minutes from Auckland. There are cows in the garden, including 6 new calves which are pretty funny, and two pre-school children who are pretty funny too. Although I’m very much a towny at heart, I must admit the change in pace and air quality is very welcome. Last week I was talking about Oracle and this week I’ve chopping down some trees, cleared some scrub and pretended (very badly) to be a farmer. I’ve nearly mastered saying, “Get off my land!”, or as the Kiwi’s say it, “Gt ff my lnd aye!” I’m trying to introduce vowels to the natives, but with the exception of the word “aye” that is added to the end of every sentence, vowels seem to be lost forever. :)

In a few days I will transplant to Auckland and start the NZOUG conference.

Cheers

Tim…




Forms is not dead!

The recent interest in Oracle Forms is quite interesting. Besides ODTUG (Oracle Development Tools User Group); two other groups have recently conducted surveys to see how people are using forms one in Germany (http://talk2gerd.blogspot.com/2011/08/result-of-2011-oracle-forms-poll-part-1.html) and one in the US (http://blog.whitehorses.nl/2011/10/01/results-oracle-forms-survey/). Now, Oracle has release Oracle Forms 11g R2!

NoCOUG’s 100th Conference Nov 9th!

Download the 100th issue of the NoCOUG Journal at http://bit.ly/rC2gRA.

What the heck is the SQL Execution ID – SQL_EXEC_ID?

Ok, I think it’s time to write another blog entry. I’ve been traveling and dealing with jetlag from 10-hour time difference, then traveling some more, spoken at conferences, drank beer, had fun, then traveled some more, trained customers, hacked some Exadatas and now I’m back home.
Anyway, do you know what is the SQL_EXEC_ID in V$SESSION and ASH views?
Oh yeah, it’s the “SQL Execution ID” just like the documentation says … all clear.

What the heck is the SQL Execution ID – SQL_EXEC_ID?

Ok, I think it’s time to write another blog entry. I’ve been traveling and dealing with jetlag from 10-hour time difference, then traveling some more, spoken at conferences, drank beer, had fun, then traveled some more, trained customers, hacked some Exadatas and now I’m back home.
Anyway, do you know what is the SQL_EXEC_ID in V$SESSION and ASH views?
Oh yeah, it’s the “SQL Execution ID” just like the documentation says … all clear.

What the heck is the SQL Execution ID – SQL_EXEC_ID?

Ok, I think it’s time to write another blog entry. I’ve been traveling and dealing with jetlag from 10-hour time difference, then traveling some more, spoken at conferences, drank beer, had fun, then traveled some more, trained customers, hacked some Exadatas and now I’m back home.

Anyway, do you know what is the SQL_EXEC_ID in V$SESSION and ASH views?

Oh yeah, it’s the “SQL Execution ID” just like the documentation says … all clear. Um … is it? I’d like to know more about it – what does it actually stand for?! Is it session level, instance level or a RAC-global counter? And why does it start from 16 million, not 1?