Infrastructure at your Service
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…
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…
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…
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…
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…
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…
This has been a long day, started with gathering some news about the Enterprise Manager 12c and finished with a huge concert on Treasure Island. However the highlight of the day was clearly Larry Ellison’s Keynote. Since this afternoon (pacific time), Oracle is officially proposing a Public Cloud, which integrates an Oracle Social Network…
So the first Oracle OpenWorld 2011 is over. This introduction day was dedicated to Oracle Users and Oracle Partners Forums and the Welcome Keynote. It already showed some interesting stuff and finished with a new announcement
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“…
