With this post I aim to present a lightweight CPU Monitoring solution for individual processes that can be automated on Windows Hosts. This can be useful if we see a constant CPU peak on some of our MSSQL Hosts but no heavy load on the instance itself. In such cases we need to monitor all…
Read More →Author: Balazs Berki
Recently I was in charge of implementing the single-sign-on feature of Oracle using Kerberos at my workplace. With this post I would like to pinpoint some pitfalls and how to avoid them when setting up and troubleshooting Oracle Kerberos. I do not aim to provide a complete guide on the topic as there are already many…
Read More →Installing an Oracle Client on a Linux host is a rather easy and straightforward task but when you have to do this on a lot of hosts with different Linux distributions you probably will think about how to automate the process and not use the GUI at all. A simple script for installing an Oracle 12c…
Read More →Lately I was responsible for implementing Kerberos authentication at the company where I work. During the planning I have discovered some differences and features which are not well documented regarding external authentication in Oracle. This blog post will discuss the issue with password expiration for externally authenticated users in Oracle 11g and 12c. When we change a…
Read More →In case you have been wondering how to measure the effect of an “ALTER TABLE MOVE” command on a full table scan then this little test will show it to you. Using ALTER TABLE MOVE is a good idea if you want to reorganize your tables but do not wish to enable row movement and export-import is…
Read More →