How Does An Execution Plan Suddenly Change When The Statistics (And Everything Else) Remains The Same ? (In Limbo)

Richard Foote's Oracle Blog

I’ve slipped this post in as there have been a number of discussions recently on how execution plans have changed while nothing else appears to have changed in the database. How can an execution plan suddenly change when no one has made any changes to the database ?
 
By no changes, it means that there have been no alterations to any segments, no new indexes have been added, no changes associated  bind peeking (indeed, there may not even be any bind variables), no parameters changes, no new patches or upgrades, no new outlines or profiles, no new system stats and perhaps most prevalent of all, no changes to any CBO statistics.
 
The DBA hasn’t touched a thing and yet suddenly, for no apparent reason, execution plans suddenly change and (say) an inappropriate index is suddenly used and causes performance degradation.
 
How can this be possible ?
 
There are…

View original post 1,271 more words

The first full day

Japan à Trois

Stephen: It’s 5am, after our first full day in Japan. We’re left feeling a bit like Scarlett Johansson in Lost in Translation at this point, with our body clocks thrown completely out of whack. Sleeping until 2.30pm was probably not our wisest ideas – but the 18 hour journey was pretty gruelling – even for me, who is fairly well accustomed to long haul by now.

We are staying in the famous Shibuya area, and stepping out of the train station to the mass of excited chatter, neon lights, and noise after being on a plane for so long was both a welcome, and overwhelming experience. Despite some serious exhaustion, we wandered out braving the rain and humidity to marvel and take pictures of everything we saw. Now the penchant that Asian tourists seem to have for taking photos of every single minute detail when they travel abroad doesn’t seem…

View original post 751 more words

There’s Been a Murder!

In a bid to do something creative I made this a T-Shirt, if you fancy it you can pick it up from here for £12 + Shipping. T-shirt will be available for 21 Days and will only be shipped if I meet 10 orders.

 

 

Cheers Paz.

Featured Image -- 686

Recording an album

Closet Organ

This past week, we headed up into the beautiful Scottish hills to spend three days (four nights) recording our first (and probably last) ever album. We had planned to put down 9 tracks, but ended up doing 12 – a task which has rightfully been described as ‘fucking mental’.

We did it though; fighting through the actual literal blood, sweat, and booze induced tears to record the various guitars, drums, bass, vocals, and random noises that will make up the release – even managing to throw in our first gig as a full band, supporting Living Body at Glasgow’s Broadcast.

closetorgan_1469723919_hd.jpg

This picture was not staged.

Everything started out well enough, with excitement at the prospect of having a dedicated, proper studio space to spend time recording in for a few solid days.

IMG_3765.jpgclosetorgan_1469544378_hd.jpg

We celebrated with our traditional Goldschlager.

goldsch.jpg

And even the scenery was beautiful.

closetorgan_1469378836_hd.jpg

Though the less said about the…

View original post 204 more words

Scotland, get ready to fight

Clicky Steve

Earlier today, we woke up to the terrible realisation that the UK had narrowly voted to leave the European Union. This was an outcome that I ultimately expected, but facing the stark reality of the situation has still left me feeling numb, and in shock. Opening my eyes to see ‘Nigel Farage declares independence day’ and ‘British Pound drops to a 31 year low’ on my phone’s lock screen is something I’m not sure I’ll ever be able to forget; reminiscent of a dystopian nightmare rather than reality.

To make things worse, the dogged, often proud ignorance of those smugly celebrating victory in the immediate aftermath has been staggering. As I write this, I am overlooking the City of Barcelona, and being here only renders the sadness even more palpable, and even harder to believe.

However, this is not a drill. This is the real deal. Like it or not…

View original post 1,217 more words

making stuff

unexpectedbowtie

I’ve not posted much recently, but I’ve been busy making stuff in the background.

My pal Lee left a bunch of his pedals with me to try out, and in amongst them was a kit to build an octave-up fuzz. I decided to put it together (and discovered how handy a multi-meter is at the same time).

IMG_0233.jpg

When I realised how straight forward it is, I decided to have a bash at building my own signal splitter pedal as well, to take one input and give three separate outputs at the same volume.

I didn’t want to just leave the enclosures bare aluminium, so started to look into ways of painting them. After reading endless advice online, I decided to just get some spray paint suitable for metal, and use a varnish over the top. I didn’t bother sanding the cases down, as many people suggest – so we will…

View original post 306 more words

House Of Cards Season 4: The Annual Binge Watch

Yearly House of Cards binge with my darling!

The Big Picture

anything-for-america-1260x840.jpg

It can’t be a coincidence that the season 4 debut comes out right in the middle of the primaries. This elegant timing by the producers only adds to the hype surrounding the return of this epic political drama.

Carrying on from last years tradition, my boyfriend and I held our House of Cards day, complete with deep-South inspired snacks, where we vowed to dedicate our entire day to binge watching the full season.

image

I’ll be the first to admit that I was a little disappointed with Season 3. After the unforgivable murders of both Zoe’s Barnes and Peter Russo in Season’s 1 & 2, the stakes were high for Underwood to deliver another killer move (pardon the pun). Sadly, that moment never came, and the episodes plodded on slowly. However, it becomes apparent upon watching Season 4 that the writers were simply biding their time and building up to…

View original post 1,792 more words