Search

OakieTags

Who's online

There are currently 0 users and 41 guests online.

Recent comments

Affiliations

October 2012

Exadata upgrade to version 11.2.3.2.0 and ASR

Recently we upgraded an Exadata to the currently latest version, 11.2.3.2.0. The Exadata software itself consists of an image for the storage servers (the storage servers are essentially re-imaged), and a set of updates for the database/computing nodes, including: firmware for ILOM (lights out adapter), BIOS, LSI RAID adapter, Infiniband adapter, linux kernel, drivers, mandatory packages, to name some.

Select statement generating redo – and lost write detection

Gwen Shapira has written a nice summary of a problem case where the classic wait interface based troubleshooting method is not always enough for troubleshooting low-level issues.

The top SQL + top wait approach should usually be used as the starting point of troubleshooting a session, workload etc, but often the troubleshooting does not stop there. So, when the wait interface and related tools don’t explain the problem well enough, then you either start guessing from there or dig deeper into performance data. And Gwen used the V$SESSTAT metrics (using my Snapper tool) to understand why was a select statement generating redo this time (there are multiple reasons for that – and V$SESSTAT tells you why).

Movember 2012: The ‘stache returns!

In 2011, I joined many others in the Movember event for the first time. This is a fund-raising effort where participants grow a mustache for the month of November and collect donations to support men’s health, specifically prostate and testicular cancers. Individuals can participate on their own or as a team, but no matter what you donate, it all goes to the same place. In my first year, I managed to collect $754 from 15 donors! Hopefully, I’ll exceed my previous year’s fundraising this year…just not sure what mustache style will bring in the most money yet?!

To see photo updates of how my ‘stache is coming along and to make donations, go to my page on Movember. Thanks for any donation you can make!

Source Control

If you’ve been following my blog fairly closely, you’ve probably seen that I have some involvement with Redgate run. I’ve just had an email reminding me about their “Source Control for Oracle” which started as an Agile development at the ODTUG annual conference (Kaleidoscope 2012) this year, taking contributions from any conference delegates that wanted to participate. who wanted to supply ideas, do some testing, give feedback, or be involved in the scrums.

Girl 99…

When I was at University I lived in shared houses with the author of Girl 99, Andy, for several years. We were on the same degree course and both stayed on to do PhDs. When he left to go to London I shared a house with his (then) girlfriend for a year before she left Uni. Suffice to say, over those years I got to know the guy pretty well.

Help Yourself

When people ask for help on (for example) OTN, they are often asked to supply further information – sometimes in the form of requests for results from SQL queries. If you are ever in this position, you may find that you don’t understand what the query does, or why the information is useful – nevertheless you can still do something to make it as easy as possible for your potential saviour to help you.

Here’s an example to show you how NOT to do it:
Request for information: “Please format the contents of v$sga_dynamic_components.”
Response:

Oracle Expert Seminars

As already announced in the past the following Oracle Expert Seminars have been scheduled by Oracle University:

3rd December: "Advanced Oracle Performance Troubleshooting", Wien, Austria
17th December: "Mastering Oracle Parallel Execution", London UK
30th January 2013: "Mastering Oracle Parallel Execution", LVC, EMEA

I've also added the entries to the list on the right hand side under "Upcoming Public Appearances".

AUSOUG conference 2012

Starts tomorrow everyone…

Its about the biggest list of international names Perth has ever seen at the conference:

Tom Kyte (of asktom fame)

Graham Wood (ever used Statspack, ASH ?, …. well, this is the guy you should be sending a “Thank you” card to)

Melanie Caffrey (regular inside Oracle magazine)

the list goes one.

Check it out here

Oracle Database File System (DBFS) in Oracle 12c : WebDav Support?

On a yoga course a teacher said to the group, “Don’t try to remember everything I say. Some things will come back to haunt you later.”

So I was reviewing a couple of chapters of Marcelle Kratochvil‘s multimedia book and she mentioned DBFS. That jogged a memory of the DBFS demo stand at OOW12, where the guy told me that 12c will (probably) have WebDAV support for DBFS.

DBFS is a neat feature, but it’s a little frustrating if you are using any OS other than Linux because you are forced to use a client utility with limited functionality, rather than accessing it like a regular file system as you can on Linux using the FUSE project. If this WebDAV functionality does get released in 12c it will make it accessible from pretty much any OS or browser.

VirtualBox 4.2.4 Released…

VirtualBox 4.2.4 has been released. Downloads and changelog in the usual places.

I’ve literally not had chance to upgrade all by VMs with the guest additions since the update released last week. :)

Happy upgrading. :)

Cheers

Tim…