Blog dbi bloggers Nicolas Jardot
Nicolas's 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, 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!
Nicolas Jardot
Nicolas Jardot is Consultant at dbi services. He is specialized in C++ development on Windows environment. He has developed several PL/SQL packages aimed to simplify the administration of database applications.
Yesterday was a very busy day at UKOUG 2012: many technical sessions about performances and also a time travel back in the evening. I really like sessions about performances (Oracle Optimizer) and Oracle behinds, but I will not focus on the technical side because it will take too much time (maybe in future blogs!). I will just summarize a little the main interesting topics.
Today was the official launch of UKOUG 2012. We started with keynotes including one from Tom Kytes giving information about Oracle 12c features.
Then I had some very interesting sessions on database performance.
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.
Data can be corrupted in different ways, for example an I/O issue when reading data from the storage or a memory issue when updating data. The db_block_checking parameter allows to change the behavior of an Oracle database concerning block checking.
This posting will present this parameter and some tests to measure its impact on the database.
Oracle has introduced three new caching features in its Oracle 11g release:
- Query result cache
- Client OCI result cache
- PL/SQL function result cache
In this posting, I will present the query result cache feature.
- Florian Haas' blog
- Dirk Nachbar's blog on Oracle Fusion Middleware & Application Server
- Oracle Scratchpad - Jonathan Lewis' blog
- Martin Bach's blog
- Striving for optimal performance - Chris Antognini's blog
- The Tom Kyte Blog (Ask Tom)
- Blog of Adar-Consult
- Alex Gorbachev's blog
- Marcus Mönnig's Oracle & Mumbai Blog
I wish someone would demonstrate how they generated the graphs - seems to be a well-kept secret
Hi Arnaud,
Can I hav english version of these document.
Rgds
Raffi