THE WORLD DISCUSSES #PYTHIAN ON TWITTER. HAVE A QUESTION? USE OUR HASHTAG AND ASK AWAY.

Oracle Database Machine on a Budget: Standard Edition (SE)?

One of the customers (actually a prospect) here in Australia asked me about minimal Oracle licensing on a quarter rack database machine. This prompted a thought of using Oracle Standard Edition instead of full blown Enterprise Edition with bunch of options.

Before even going into possibility of using Oracle SE for the database machine, let’s see if we even want to.

Why Oracle Standard Edition?

If the environment is data warehouse then it’s extremely unlikely that Standard Edition will cut it. Lack of many feature make it non-feasible to use for data warehousing — no partitioning licensing, no parallel query, and dozens more.

Oracle Standard Edition might fit OLTP environments depending on the application design and data volumes. Since Database Machine is made to store large amounts of data, we assume that it makes financial sense to run databases that are quite large. Oracle SE lacks some critical features in order to successfully manage VLDB (Very Large Databases). It’s not impossible and depends a lot on the presence of outage windows, how active is the development life-cycle, availability requirements and etc.

Where Standard Edition seems to fit nicely is Read the rest of this entry . . .

Larry Ellison to Announce OLTP Database Machine on… Sun Hardware

In line with my prediction from few days ago, Larry Ellison is announcing the new Database Machine — the new version is targeting OLTP workloads and is based on Sun hardware.

Larry Ellison announces Sun Oracle OLTP Database Machine

Looks like I just got the date wrong. Oh well, now is the announcement, hype and demo is at the Oracle Open World and shipments are to start upon Oracle-Sun acquisition completion.

So what’s new in Exadata that I didn’t mention in the previous blog post? Ah, right — Sun FlashFire technology. It’s no surprise that the new OLTP version of Database Machine is boosting the IOPS (IO’s per second) capacity by introducing the flash drives. Nothing prevented Oracle to place flash disks into the original Exadata, not from technology perspective.
Read the rest of this entry . . .

Oracle Exadata v2 — Truly Oracle (Sun) Hardware

Update 16-Sep-09: Apparently, all this was true and you can find more details after the announcement that posted here.

OK. It’s not often that I make predictions these days but this was on my mind for a while so here we go. Mind you, I don’t have any confirmed insider information so it’s based on some assumptions, my perspective on Oracle-Sun acquisition and some vibes I can feel in the air.

The rumors are that Oracle Exadata v2 and Oracle Database Machine v2 are going to be announced within few weeks and my take is that it’s going to happen at the Oracle Open World. I don’t think it comes as a surprise to anyone that it will be configured with Oracle Database 11g Release 2.

Moving on to predictions and speculations…
Read the rest of this entry . . .

Oracle Open World 2008 Diaries: HP Oracle Database Machine

For those of you who didn’t see the Larry Ellison’s keynote here it is courtesy to Sheeri.

We cut out the HP part but I don’t think anyone will complain. It’s not the best angle but we didn’t get there early in advance to secure the right location for the camera.

Read the rest of this entry . . .

Analysis of the Oracle Exadata Storage Server and Database Machine

*Updated* see comments.
Exadata — the smart storage server. I am definitely excited about this product, but my point of view is a bit different.

It’s fast, and much faster than anything out there right now. But how many shops will actually need this? How many shops can spend 2.2 million dollars on hardware and equipment?

What are the products, in a nutshell? The Oracle Exadata Storage Server (Data Sheet, PDF):

  • 2U Storage “unit” with either 1 TB SAS or 3.3 TB SATA redundant capacity. There is a query processor in the box that can “offload” tasks from the main database server. Primary filtering, decompression, joins, backups.
  • Storage units linked to database servers via dual Infiniband offering 20 Gbit/s (2.5 GBytes/sec) bandwidth

The Database Machine (Data Sheet, PDF):

  • A standard 42U rack with 8 database servers and 12 Exadata storage servers.
  • Pre-installed Linux and Oracle. Pre-configured.
  • In 8 servers — a total of 256GB RAM, 64 Intel cores @ 2.66 Ghz, InfiniBand-ed and gigabit-switched.

The cost for one Database Machine: $2.33M ($650,000 + $1,680,000 in software) as grabbed from Larry’s keynote (thank chet) I called the “call us now” phone mentioned on the Oracle Exadata website to ask them for pricing. They had no idea what I was asking about, and I’m still waiting on a salesperson to call me back. (Hint for Oracle — educate your sales staff about new products, just in case I decide to buy one the day after you announce it.)

You have to realize how “cheap” this is. It comes down to $25,000 per core for Oracle EE, RAC, and Partitioning! And extra “free” CPUs for decompressing, filtering and joining, and backups. That’s a good deal. Oh, did I mention you can interconnect several 42U racks?

Back to the main question, what problems does this product solve?

Read the rest of this entry . . .

Start NowWith Pythian - database design, management and emergency handling capabilities...

Live Updates

pythian: RT @sheeri: #confoo talk "Bending Queries to your Will with EXPLAIN" slides http://bit.ly/explainslides & handout
more



Testimonials

  • Serge Racine

    DBA, Brookfield Energy

    We are very satisfied by the service given to us by Andre and Shakir in support of our recent data quality and reorganization initiative.... more