Author Archives: bdrouvot

New member of the OakTable Network

A quick one to say that I am very happy to be a new member of the OakTable Network. Thanks Kevin Closson for my nomination, I feel deeply honored!

Posted in Other | 13 Comments

SystemTap and Oracle RDBMS: Time in Various States, VFS I/O and Block I/O

Introduction Now that I am able to aggregate SytemTap probes by Oracle database, it’s time to create several scripts in a toolkit. The toolkit is available in this github repository. Let’s describe 3 new members of the toolkit: schedtimes_per_db.stp: To … Continue reading

Posted in SystemTap | Leave a comment

SystemTap and Oracle RDBMS: Aggregate by database

Introduction The purpose of this post is to share a way to aggregate by Oracle database within SystemTap probes. Let’s describe a simple use case to make things clear. Use Case Let’s say that I want to get the number … Continue reading

Posted in SystemTap | Leave a comment

Running 12.1.0.2 Oracle Database on Docker

Introduction As you may have noticed, Oracle has released a few weeks ago Docker build files for the Oracle Database on Github and an associated blog post. Should you read the blog post, you would notice that you need to download manually the … Continue reading

Posted in Other | Leave a comment

Push oracle audit data into Elasticsearch and analyze/visualize it with Kibana

Introduction Auditing the oracle database may lead to a wide variety of information. What about having all this information centralized? What about having the possibility to gather, format, search, analyze and visualize this information in near real time? To achieve this, … Continue reading

Posted in Other | 5 Comments

Graphing Exadata cells metrics with Telegraf, InfluxDB and Grafana

Introduction As a picture is worth a thousand words, we may want to visualise the Exadata cells metrics. What if you could do it the way you want? build your own graph? Let’s try to achieve this with 3 layers: telegraf: to … Continue reading

Posted in Exadata | Leave a comment

Oracle Unified Directory and user security: quick demo

Introduction Oracle Unified Directory (OUD) can be used to centrally manage database users across the enterprise. It allows us to manage roles and privileges across various databases registered with the directory. Users connect to the database by providing credentials that … Continue reading

Posted in Other | Leave a comment