Having SQLTXPLAIN and SQLHC available, WHY do I need yet another way to display execution plans?
New script planx.sql reports execution plans for one SQL_ID from RAC and AWR. It is lightweight and installs nothing. It produces list of performance metrics for given SQL out of gv$sqlstats, gv$sqlstats_plan_hash, gv$sql and dba_hist_sqlstat. It also (more...)
The aim of this post isn’t to explain what the “exadata mode” is. Hence, if you don’t know what it is, before continuing reading have a look to this post published on Kerry Osborne’s blog. The only think I would like to add is that the “exadata mode” is available (more...)
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...)
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...)
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...)
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...)
Mehr als 11 Millionen Verbraucher
besitzen die "Deutschlandcard",
mit der bei Einkäufen Bonuspunkte gesammelt werden können. Die teilnehmenden Unternehmen festigen so die Beziehung zu ihren Kunden und lernen, deren Kaufverhalten einzuschätzen.
Klar, dass bei der Deutschlandcard AG enorme, ständig wachsende Datenmengen
Um dauerhaft hohe Performanz und Verfügbarkeit garantieren zu (more...)
I’ll start with three observations:
- Computer systems can’t be entirely tightly coupled — nothing would ever get developed or tested.
- Computer systems can’t be entirely loosely coupled — nothing would ever get optimized, in performance and functionality alike.
- In an ongoing trend, there is and will be dramatic refactoring as (more...)
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...)
An Oracle Exadata Full Rack consists of 8 DB compute nodes. Oracle has shifted the strategy to patching the exadata in 220.127.116.11.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...)
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 18.104.22.168.0, Oracle introduced yum updates for the Exadata compute nodes. Previously, each Exadata (more...)
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...)
The basic idea behind the Exadata Hybrid Columnar Compression (hereby referred as EHCC) is to reprise the benefits of column based storage while sustaining to the fundamental row based storage principle of Oracle database. Oftentimes the databases following column based storage claim that comparatively they needs less IO to retrieve (more...)
Exadata Article as NYOUG's Article of the Year 2012
The Editors of New York Oracle User Group (NYOUG)
publication - TechJournal - chose my article Exadata Demystified
as the Article of the Year
. Here is the snippet from the Editorial:
And the Award Goes To …
The Editor’s Choice Award (more...)
Ein Praxistest überzeugt leichter, als lange Erklärungen. Daher stellt der Oracle
VAD Azlan Deutschland nun eine Oracle Exadata Demomaschine für Reseller bereit.
Händler und unabhängige Software Hersteller (ISVs) können
sie sowohl für Teststellungen direkt vor Ort bei Endkunden als auch zum Testen
eigener Applikationen nutzen. Für Partner bietet das den (more...)
Exklusiv für Oracle
Partner: Produkt- und Geschäftsstrategien, Fallstudien, Kundenerfolge, Erfolgreiche
- The trend to clustered computing is sustainable.
- The trend to appliances is also sustainable.
- The “single” enterprise cluster is almost as much of a pipe dream as the single enterprise database.
I shall explain.
Arguments for hosting applications on some kind of cluster include: