Infrastructure at your Service

Exadata Archives - Page 2 of 2 - Blog dbi services

Franck Pachot

Oracle Exadata – poor optimization for FIRST_ROWS

By | Database Administration & Monitoring, Oracle | 3 Comments

In a previous blog, I discussed the difference between rownum and row_number(), in particular their behaviour in implicitely adding a first_rows(n) to the optimizer. That reminded me that I forgot to blog about an issue I encountered and which concerns both approaches. It was on an Exadata: a nice full table scan with smartscan was taking a long time. And forcing to an index access – with a very bad index – was better. The…

 
Read More
Pierre Sicot

UKOUG Day 2: Exadata Management Deep Dive with OEM Cloud 12c

By | Technology Survey | No Comments

I started the second day ay UKOUG with an Exadata Management Deep dive with Oracle Enterprise Manager Cloud 12c. Through a certain numer of plugins, Oracle Enterprise Manager Cloud 12c offers an integrated view of hardware and software. In Enterprise Management Cloud 12c you have access to the following menus: Software Cell Management: Cell home page and performance page Workload distribution by database Interprets immediately what’s happening Performance workload distribution may help analyze analyses performance…

 
Read More
Pierre Sicot

UKOUG Day 1: Oracle Optimizer 12c, Cost Based Optimizer, Exadata

By | Technology Survey | No Comments

Today was the first day of the United Kingdom Oracle User Group (UKOUG) – usually called the Super Sunday! I already participated in today’s first session three weeks ago in Geneva, but my colleague Nicolas Jardot was talking about Solving Critical Issues with the 12c Optimizer, covering histogram collection, temporary table statistics and adaptive query optimization. There were around thirty people at his session, and a lot of UKOUG speakers were very interested and asked…

 
Read More
Michael Schwalm

Oracle Database Appliance (ODA) – an overview

By | Operation systems | No Comments

Last february, I had the chance to attend an Oracle presentation about ODA: Oracle Database Appliance. I found it interessant to share what I have learned about this technology. Which, I confess, convinced me. Summary Before developing the software and hardware components, here is a small overview of ODA. ODA is an all in one solution providing Hardware, Operating System, and database components. It comes in a 4U rack server form, composed of two distinct…

 
Read More
Nicolas Jardot

OakTable at UKOUG 2012: Hybrid Columnar Compression (Exadata), SQL tuning, etc.

By | Technology Survey | No Comments

Yesterday, I went to a set of sessions organized by OakTable members just before the kick-off of the UKOUG conference 2012, one of the biggest events on Oracle Technology and E-Business in Europe. This post focuses on some of the covered topics, such as database development, Hybrid Columnar Compression (Exadata), optimizer statistics, and SQL tuning. There were 2 streams with very interesting topics. I attended to sessions covering the following topics: Application development: Keep it…

 
Read More
Jérôme Witt

Oracle OpenWorld 2012 – the world is not enough: Larry’s keynote on Oracle 12c, etc.

By | Technology Survey | No Comments

I am pretty sure you are wondering what Larry Ellison announced in his Oracle OpenWorld keynote, especially concerning Oracle 12c! In fact there were three major announcements, which I will cover in this posting. But first, let’s start with Fujitsu’s (Oracle Open World sponsor) announcement on a new SPARC technology. At the beginning of the session, Noriyuki Toyoki, Senior Vice President of Fujitsu Limited (which is this year the main sponsor of the OOW) introduced…

 
Read More
David Hueber

Flying with “Air Oracle”

By | Technology Survey | One Comment

Finally after a 18 hours, doors-to-doors, journey I’m arrived in San Francisco for Oracle OpenWorld 2011. My trip started in Basel, making a stop in Paris and then an 11 hours flight to San Francisco. Even with the on-board movies this kind of flight are still quite boring, but the funny things is that I really though that I was flying with “Air Oracle“…

 
Read More