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.
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.
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.
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:
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…
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!
Download the 100th issue of the NoCOUG Journal at http://bit.ly/rC2gRA.
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.
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.
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?
Recent comments
1 year 45 weeks ago
2 years 5 weeks ago
2 years 10 weeks ago
2 years 10 weeks ago
2 years 15 weeks ago
2 years 36 weeks ago
3 years 4 weeks ago
3 years 34 weeks ago
4 years 18 weeks ago
4 years 19 weeks ago