Nicolas Jardot has more than 10 years of experience in Oracle database infrastructure management and optimization, with a strong recent focus on cloud and automation technologies, including four-plus years building and maintaining AWS applications with CI/CD pipelines via Terraform. He holds Oracle Certified Professional 12c, Oracle Certified Expert Performance Management and Tuning 12c, and AWS Solutions Architect Professional certifications, has spoken at Oracle OpenWorld and UKOUG, and served as an AWS Authorized Instructor for two years. He holds an Engineering degree in Computer Science from the University of Technology of Belfort-Montbéliard. His industry experience covers pharma, public sector, health, real estate, and automotive.
This week, I consider myself lucky I’m working with AWS at customer and at dbi since few years now and I consider myself lucky to attend the conference in person. At re:Invent, there are different types of content so you can adapt your schedule. I personally tried this year to get some diversity, I started the week with a workshop…
On Friday, it’s the last day for AWS re:Invent convention in Las Vegas. I didn’t know in advance what to expect because I have to admit that even if I started to use AWS, there is still a lot to learn. And that’s why I personally think working with technology is interesting, it’s always moving and there is always something new to…
Thursday morning it’s time for the keynote from Dr Werner Vogels. A big part of the keynote was about databases again. Maybe AWS people knows that there are still lots of DBAs out there! It’s also again a focus on Amazon Aurora (relational), Dynamo DB (NoSQL) and AWS Redshift that are replacing Oracle databases Amazon was using. There was also a…
On Wednesday morning, this is the big day for AWS re:Invent conference. The day started with a 3 hours keynote from Andy Jassy, CEO of AWS.The keynote covered a lot of different topics: databases, blockchain, machine learning… As most keynotes, it started with some numbers and AWS is still a strong leader on the public Cloud if you look at…
Second day in Las Vegas for the AWS re:Invent conference. It was time to travel a little bit around the campus to attend some sessions at the Aria. The planning was still around databases and a bit AWS knowledge. The shuttle service worked perfectly in both directions with a reasonable time travel between the 2 hotels. But with such time…
Yesterday was my first day at AWS re:Invent conference. The venue is quite impressive, the conference is split between 6 hotels where you can attend different types of sessions including chalk talk, keynotes, hands-on labs or workshop. For my first day, I stayed in the same area in The Venetian to make it easy. The walking distance is quite big between…
The Cloud is now part of our job so we have to get a deeper look on the available services to understand and take best advantage of them. The annual AWS conference re:invent has started tonight in The Venetian at Las Vegas and will last until Friday. Today was a bit special because there were no sessions yet but instead I…
Since Oracle 11g, Oracle maintains two copies of the database’s alertlog in ADR: a flat text file in the sub-directory trace and an XML like in the folder alert. I had a case recently at a customer where the log.xml was moved to another place and compressed for archiving reason. As the regular text file was not containing old data, the…
In our more and more connected world, security is a big concern. Storing password is a very important topic because if a machine is compromised, we can assume that any password stored in clear text are also compromised. I had the question from a customer how can we encrypt the password in our application and monitoring scripts? In this blog…
Recently, at a customer site, I faced a performance issue. However, as often the statement is embedded in the application so it’s not possible to rewrite the query. In this blog post, we’ll change the execution plan to solve the problem without changing the code – thanks to SQL Patch. The faulty statement was part of a daily job that…
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:
In this posting, I will present the query result cache feature.
