Almost exactly a year ago I published a post covering my first impressions of the ASM Filter Driver (ASMFD) released in Oracle 188.8.131.52, followed swiftly by a second post showing that it didn’t work with 4k native devices.
When I wrote that first post I was about to start my summer holidays, so I’m afraid to admit that I was a little sloppy and made some false assumptions toward the end – assumptions (more...)
For the last couple of years I’ve been writing a series of blog posts introducing the concepts of flash-memory and solid state storage to those who aren’t part of the storage industry. I’ve covered storage fundamentals, some of what I consider to be the enduring myths of storage, a section of unashamed disk-bashing and then a lengthy set of articles about NAND flash itself.
Now it’s time to talk about all flash arrays. (more...)
In a proud moment for me, it appears that Mark Hurd, CEO of Oracle, has mentioned my flashdba blog during the Oracle Q4 2015 results call. At least, that’s what I’m reading into this section from the transcript published by Seeking Alpha:
We grew in storage in the quarter and this is — really we are going through a shift in storage now. We released our SAN product FS1 in the quarter which (more...)
Oded Raz, my colleague and friend is on right now, talking about security in the cloud in the Scotland OUG conference.
Since the room is full, I had to leave to make some more space to the participants…
In the mean time, I was taking a walk around this nice complex and found the visitor demo room for hardware and engineered systems. I took some pictures:
My first session will start in a couple of (more...)
Just a quick note – I was quite busy in the last few days – first there was the Israeli ilOUG convention (it’s still on) but I had to leave early since today I’m speaking at Scotland!
So today I’m speaking at 15:25 – my session is about “Adding Real Time Reporting to Your Database: Oracle In Memory Option”. This is a great session I gave last year in ilOUG SIG group and I added (more...)
So this is it – the last article in my mini-series on understanding flash. This is the bit where I draw it all together in a neat conclusion that makes you think, “Yes! That was worth reading”. No pressure eh?
So let me start with the conclusion first: as a storage medium, NAND flash is a royal pain in the ass.
Why? Well, let’s look back at what we’ve learned in the previous 9 (more...)
This is a very simple post to show the results of some recent testing that Tom and I ran using Oracle SLOB on Violin to determine the impact of using virtualization. But before we get to that, I am duty bound to write a paragraph of text featuring lots of long sentences peppered with industry buzz words. Forgive me, it’s just the way I’m wired.
It is increasingly common these days to find database environments running (more...)
I’ve run into a few customers recently who have had problems with their ASM rebalance operations running too slowly. Surprisingly, there were some simple concepts being overlooked – and once these were understood, the rebalance times were dramatically improved. For that reason, I’m documenting the solutions here… I hope that somebody, somewhere benefits…
1. Don’t Overbalance
Every time you run an ALTER DISKGROUP <NAME> REBALANCE operation you initiate a large amount of I/O workload as (more...)
I’m delighted to say that this is another guest post from my good friend Nate Fuzi, who performs the same role as me for Violin but is based in the US instead of EMEA. Because he is American, Nate thinks that scones are called “biscuits”, that chips are called “fries” and that there is nothing – *nothing* – that cannot be improved with the simple addition of bacon. Clearly, something is fundamentally wrong with him (more...)
A quick post to say that this week, on Thursday 26th, I will be giving a talk (in English!) on the subject of Flash for DBAs (and architects, designers, developers, managers etc) at the Paris Oracle Meetup:
Flash for DBAs: A new technology is sweeping the world of storage. Flash, a type of non-volatile memory, is gradually replacing hard disk drives. It began in consumer electronic devices such as phones, cameras and tablets (more...)
A few weeks ago, in what seems to be a truly modern phenomenon, I became aware that it was my third anniversary of joining Violin after I noticed a number of people congratulating me on LinkedIn. In many ways it feels like I’ve already been here for a lifetime, but it was only twelve months ago I was trying to think of a suitable flash-based pun for the title of an article just like this one. (more...)
My good friend and colleague Liron Amitzi started his new Oracle Blog.
Here is a shout out to @amitzil and his new blog: good luck and have fun!
The thing I like the most about his new blog is the “Did you know” section.
In those posts he’s describing very short facts that people might not have known before, and could save some them a lot of time (or just be very educational).
I’m actually (more...)
Once, a very long time ago, I told an old joke about SQL and it was a huge success (not really).
This week I heard a joke that is slightly related to that joke and it made me giggle for a couple of minutes.
Those who know me, knows that I really like to hear jokes but I’m really terrible at telling them – but let’s go for it anyway.
2 DBAs NoSQL walk into (more...)
Semiconductor Fabrication Plant (picture courtesy of SemiWiki.com)
Before I draw this series on Understanding Flash to a close, I wanted to briefly touch on the subject of manufacturing. Don’t worry, I’ve taken heed of the kind feedback I had after my floating gate transistor blog post (“Please stop talking about electrons!“) and will instead focus on the commercial aspects, because ultimately they affect the price you will be paying for your flash-based (more...)
First off, if you are not familiar with the term SIG, it stands for Special Interest Group. OAUG facilitates a number of SIGs to bring users together that share common or industries concerning certain Oracle products.
Unfortunately, the BI Publisher SIG has been offline for a number of years and has not been given the attention it needs to be a useful resource for members of OAUG. Well… I’m getting the band back together and (more...)
Recently, I received my annual report from WordPress/Jetpack. I have always enjoyed these reports, so I thought I would make it public.
For the complete report, view it here: PSST0101 – 2014 Year in Blogging
Here’s a couple of excerpts:
Madison Square Garden can seat 20,000 people for a concert. This blog was viewed about 67,000 times in 2014. If it were a concert at Madison Square Garden, it would take about 3 (more...)
Strangest thing happened the other day during a customer upgrade. Our automated scripts were in the process of creating a view and I received the error:
ORA-01720: Grant Option Does Not Exist.
OK….. I get it… BUT…. I didn’t even execute a GRANT statement!? I was just executing a CREATE OR REPLACE VIEW…. what gives?
Doing some searching online, I didn’t find too much that fit my issue. Everyone was getting (more...)
With the release of EBS 12.2, Oracle is making the claim that they have improved the attachment printing process. After reviewing the integration, I completely disagree; they have not given users a better solution. No matter how you slice it, Oracle EBS customers are no further ahead with (more...)