This is just a quick a note to show how we can monitor some important kernel parameters limits. This can be very handy in case of highly consolidated database environment where the default limits are usually not enough.
Orachrome Lighty is a great tool for monitoring our oracle databases even in case we do not have the diagnostic packs license or in case we are using the standard edition. It really on statspack and L-ASH for collecting the needed information.
This blog post is not about the different feature offered by the tool or how to use, there are already many articles covering that. I will focus on the overhead I noticed when trying this great tool and the different solution that can be implemented to alleviate them.
It can sometimes be handy to automate the generation of presentations slides ,such as listing KPIs/Health for production servers needed for capacity planning or other purpose.
The source data may be stored in different locations/different databases.So let’s see how we can do that in python !
CPU usage is one of the KPIs usually used for capacity planning, it’s supposed to allow us to determine the remaining available capacity. But with hyper-threading enabled things can become much more complicated as the Linux operating system assumes that all threads are equal and thus overstates the CPU capacity. So the CPU usage may be wrongly interpreted if we don’t take into account that !
In this part, we will see one way of sending unified auditing data to a centralized logging solution outside the Oracle Database. We will not be looking at remote SYSLOG as there is many missing information when redirecting audit data to syslog (Missing Audit Infomation In The Unified Audit Trail Records Sent To SYSLOG (Doc ID 2520613.1))
Still for remote syslog auditing we can set the parameter “unified_audit_systemlog= ‘LOCAL5.INFO’”
In addition, add the following entry in “rsyslog.conf” to enabled Reliable Message forwarding (https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/7/html/system_administrators_guide/s1-working_with_queues_in_rsyslog) :
On the remote audit server just uncomment the lines “$ModLoad imtcp $InputTCPServerRun 514”.
Ok but this is not the purpose of this blog post, here we are going to look at how we can integrate oracle unified audit data with SPLUNK using Splunk DB Connect and the oracle add-on.
Here is a little script to check HugePage usage by instance and the overall usage by all the instances in the server.You may not have enough hugepage configured in the server ,some instance configured to not use huge pages or other applications using them.
As we know from ORACLE 19c Oracle RAC is no longer supported within Standard edition 2. In this blog post, we will take a quick look at one of the alternative to configure high availability: configuring active-passive cluster using Oracle clusterware.
Target platform :
As we say in French “jamais deux sans trois” so this year was my third TALK at POUG !
As usual, this was a great conference! I meet old friends, made new ones and learned new things what else can we ask for 🙂
Also this was a special one because this time I’ve done a Co-Talk with Stefan Koehler and that was just awesome!!!
Tanel Poder have just shared an awesome tool Linux Process Snapper 🙂 Which is as he described “a Linux
/proc profiler that works by sampling Linux task states and other metrics from
/proc/PID/task/TID pseudofiles” . What i like about the tool is the easy of use and also that it allow Off-Cpu analysis (For more info about Off-Cpu analysis please take a look at Brendan Gregg Blog )
Here is the event mapping files for the new oracle 19c
As usual this include new added/removed events :
19c on the left/18c on the right
As i showed in my previous blog post this event mapping files can be used in different use cases.Such as flame graph annotation :