In this post I will present a script called WaitCheck which you can use to monitor wait events in an Oracle database. You can find and download it from my GitHub Page here: https://github.com/bbalazs83/WaitCheck The script was written in python and uses the cx_Oracle Python module which you can download here: https://pypi.python.org/pypi/cx_Oracle/5.2.1 The following two historical views are…
Read More →Category: Oracle
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 →