Blog - comments

Hi Martin, No unfortunately I've no bug opened. SR were closed as resolved by customer. Increasing n...
Did you succeed in getting support to open a bug for this? Which agent versions are affected?Best re...
Martin Decker
Hi Christopher, It's there. I't not an option that you check at install. Just use it by setting inme...
Hello, Thanks for the nice blog. I tried the latest 12c download available in Oracle's website and I...
Christopher Bernard
-- Here is a quick script to display which objects are locked in Share. Parameters: owner tablename....
Blog Nicolas Jardot Oracle Open World 2013: 3rd day - Hands on lab, Optimizer tips and Microsoft Cloud

dbi services Blog

Welcome to the dbi services Blog! This blog focuses on IT infrastructure - featuring news, troubleshooting, and tips & tricks. It covers database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Posted by on in Technology Survey

Oracle Open World 2013: 3rd day - Hands on lab, Optimizer tips and Microsoft Cloud

Today, I'll talk about the 3rd day at Oracle OpenWorld 2013 and I'll be shorter than yesterday, too much text. Actually, it's difficult to have good pictures during the conferences. So what's the program in this blog: a "hands on lab" session about Linux management, a keynote from Microsoft and few tips about the optimizer.

Too much text and not enough photos, I already told that the event is impressive:

IMG_0373

And it's just one place!

Microsoft: Oracle's partner in the Cloud

I'll start with the most surprising keynote, it was from Brad Anderson, Corporate Vice President of Program Management at Microsoft. It's the first time Microsoft holds a conference at OpenWorld and it was to talk about the partnership between Oracle and Microsoft in the Cloud.

So what's the main important point?

Oracle services, Database, Weblogic and Java will be available on Windows Azure platform and guess what not only on Windows Server, virtual machines provided by Microsoft will be available on Windows and on Linux if we want.

Another big new is regarding the license, if you choose Oracle on Windows, it is fully included whereas on Linux it's BYOL, Bring Your Own License. It's available now for testing.

I'll just finish that part with another interesting thing about Azure, you can enable an auto scale option for your virtual machines based on metric like CPU. If the load is increasing, automatically the power of the virtual machine will be increased and I guess that the price too but it gives a flexible architecture.

Hands on lab: Linux package management

IMG_0426

I followed the hands on lab hosted by Avi Miller and Timothy Hill. It was a good revision of all useful Yum commands and an occasion to test BTRFS snapshot feature to restore a system at a previous state.

BTRFS is a filesystem designed to be resilient and can be a good idea for root filesystem. It's fully supported in Oracle Linux 6.

All exercises are available at Oracle wiki

Optimizer tips

Maria Colgan and Jonathan Lewis. Maria is the Product Manager of the optimizer at Oracle and Jonathan Lewis is an independent consultant with a a great experience on Oracle internal behavior.

I'd really liked the way the optimizer tips have been presented. Maria and Jonathan didn't always agree about the solutions but in that conference Jonathan actually did follow some tips with similar advices.

The most important here is that you always should try to provide the best information about your data to the optimizer and you'll get the best plans.

I've learned that Maria Colgan will be Product Manager for the new In-Memory option available in next patch. I'm pretty sure you'll be surprised by the new Product Manager of the optimizer: Tom Kyte, responsible since many years of AskTom website.

OpenWorld is not over, stay tuned for next days...

Rate this blog entry:
2

Nicolas Jardot has more than two years of experience in Oracle database management and Microsoft application development. He is specialized in Oracle tuning as well as in the Oracle Optimizer. Nicolas Jardot perfectly masters the behavior of the Oracle Optimizer, holding speeches on the topic at the Oracle OpenWorld 2013 and the UKOUG 2013. He is also specialized in C++ development and masters the programming of requests in SQL language. Nicolas Jardot has a solid experience in the virtualization and centralization of applications. He has developed several PL/SQL packages aimed to simplify the administration of database applications and maintains the DMK_SQL package of dbi services' Database Management Kit. Nicolas Jardot is Oracle Certified Professional 11g (OCP 11g) and ITIL Foundation V3 certified. He holds an Engineer's Degree in Computer Science from the University of Technology of Belfort-Montbéliard (F). His branch-related experience covers Pharma, Public Sector, Health, Real Estate, Automotive, etc.

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Monday, 28 July 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter