Oracle Announces Exadata X4-2

Today, Oracle announced the Exadata X4-2 model.  The X4 has some considerable improvements, namely:

  • 12-core Intel Xeon e5-2697 CPUs, up from the 8-core models found in the X3-2 (hello, database licenses!)
  • 256GB RAM per database server, upgradeable to 512GB
  • 96GB RAM per storage server
  • 800GB Sun Flash F80 cards (more...)

Exadata MAA Presentation – Oracle Day 2013 Istanbul

Exadata Maximum Availability Architecture from Yunus Emre Baransel

Kdump to NFS Broken in UEK

There were problems that affected UEK and NFS when 11.2.3.2.1 was initially released (as covered by Andy Colvin). As mentioned in the comments of Andy’s post: Oracle released an updated ISO with fixes for this problem (patch 16432033).

There were also problems with kdump not (more...)

Info about Exadata’s imageinfo and rpm’s

Recently we noticed that imageinfo was displaying the following information at a customers site. Imageinfo was not displaying data i suspected, so a quick little blogpost about what was going on there.

[root@dm01db01 ~]# dcli -g /opt/oracle.SupportTools/onecommand/dbs_group -l root "imageinfo | grep 'Image version'"
dm01db01: Image version: 11.2. (more...)

Redo on SSD: effect of redo size (Exadata)

Of all the claims I make about SSD for Oracle databases, the one that generates the most debate is that placing redo logs on SSD is not likely to be effective.  I’ve published data to that effect in particular see  Using SSD for redo on Exadata - pt 2 (more...)

Exadata Write-back cache and free buffer waits

Prior to storage server software version 11.2.3.2.0 (associated with Exadata X3), Exadata Smart Flash Cache was a “write-through” cache, meaning that write operations are applied both to the cache and to the underlying disk devices, but are not signalled as complete until the IO to the (more...)

RDBMS and their bundle-mates

Relational DBMS used to be fairly straightforward product suites, which boiled down to:

  • A big SQL interpreter.
  • A bunch of administrative and operational tools.
  • Some very optional add-ons, often including an application development tool.

Now, however, most RDBMS are sold as part of something bigger.

Exadata – a new learning cuvrve

Perhaps I might be touch late on adopting/exploring/reacting/coping up with the exadata, but, it was always my dream and passion to work with the technologies since the announcement. As we knew Exadata is not something we can download and configure that easily on PC like those of traditional database or (more...)

About cellcli calibrate

With cellcli you can run the calibrate command, this will measure the performance of your harddisks and flashcards. It will eventually report to you the throughput and amount of IOPS that was measured during the calibrate, it will also report to you which luns are not performing up to par.

(more...)

Why my EM12c is giving Metric evaluation error for Exadata cell targets?

As part of my Cloud Control journey I encountered a strange problem where I got the following error for few Exadata Storage Server (cell) targets:

Metric evaluation error start - oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: em_error=Failed to execute_exadata_response.pl ssh -q -o ConnectTimeout=60 -o BatchMode=yes -o StrictHostKeyChecking=no -o  (more...)

My #OOW13 Session: Are Indexes Unnecessary in Exadata

Thanks to all those who came to my session "Are Indexes Unnecessary in Exadata" at Oracle Open World 2013. Considering it was late afternoon of the last day of the conference, especially after the appreciation concert, it was a pleasure to see a packed room. Judging by the interaction I (more...)

Stuck Timezone Upgrades and Smart Scans

I heard a strange report from a client late last week - they weren't getting any smart scans on their Exadata - a data warehouse, no less (and we checked to see if cell_offload_processing was set to true).  Queries would run normally, but for some reason, the "cell physical IO (more...)

Love your Exadata! Use Exadata Database DBRM

You have bought Exadata after spending a fortune and more importantly after convincing everybody in the organization and in your family that this is the ultimate resource machine which hosts the world’s best database, Oracle 12c. You are not off the mark with those statements, though one might term them bit exaggerated. The point is […]

The post Love your Exadata! Use Exadata Database DBRM appeared first on VitalSoftTech.

Virtualization on Exadata?

A while back, I noticed this session in the Open World 2013 content catalog.  I didn't think much of it at the time, other than that it had a catchy title.  The other day, I downloaded the latest Exadata deployment utility via the OneCommand tool.  I noticed something a little (more...)

Analyzing page allocation failures on Exadata

I have seen several clients who are struggling to decode page allocation failures on Exadata, in this post i will try to explain how to read the backtrace. The following is an anonymized client case where page allocation failures are leading up to a node reboot.

Jan 1 11:58:02 dm01db01  (more...)

Reminder – “Getting Ready for Exadata” Seminar in London

Just a quick reminder - I'll be presenting my "Getting Ready for Exadata" seminar in London on July 1. We'll cover various topics on what you need to know before you purchase an Exadata and how to manage one of these systems on a daily basis. We'll have lots of (more...)

Patching an Exadata Compute Node

An Oracle Exadata Full Rack consists of 8 DB compute nodes. Oracle has shifted the strategy to patching the exadata in 11.2.3.2.0 onwards to using Yum as the method of patching. the Quarterly Full Stack  does not include the DB Compute nodes patches anymore. So that (more...)

dbnodeupdate.sh on Exadata Compute Nodes

Rene Kundersma at Oracle just published a nifty new utility named dbnodeupdate.sh that will assist with the sometimes-cumbersome process of updating the compute nodes in an Exadata environment.  Starting last year with 11.2.3.1.0, Oracle introduced yum updates for the Exadata compute nodes.  Previously, each Exadata (more...)

Speaking at E4 2013! … and some Exadata Patents good stuff

I’ll be co-speaking with Tyler Muth at E4  and we will be talking about Performance Visualization… some of you may already know that I’m really a big fan of Tableau and just to give you an example on what the tool can do I’ve consolidated all the different viz that (more...)

gv$cell_thread_history ; A Nice View

There are certain dictionary views available to monitor the Exadata cells from the database.One of the view is gv$cell_thread_history. This view is very interesting as it delves down to the session level with its serial number, SQL, specific cell, instance and also which Exadata object was waited and every (more...)