SQL Profiles are a powerful tool to improve performance of SQL queries in your Oracle Database. Most of the time, you implement them by the output of a SQL Tuning Task, but did you know, that you can write your own SQL Profile manually?
Read More »Manual creation of SQL Profiles in Oracle Database
Oracle want’s to participate in the open source movement lately, making itself known as “an Open Source company”. Part of this is the Oracle Database Operator for Kubernetes. It’s an early version (0.1.0) that I’ve tested out, so it offers only a limited set of features as of now. Let’s move it to it’s paces, shall we?
Read More »Bastard Operator from Hell? – Giving the Kubernetes Oracle Database Operator a try
The most basic Feature of Pythia is, to install an Oracle Database RDBMS on a Linux machine of your choice. The RDBMS Installation will most likely be combined with other Tasks (TAGs) you want to have done by Pythia. Beside the RDBMS, we will build us an Oracle Database in this article. All done by one line of command.
Read More »Pythia – An Oracle DB Automation Story – Chapter 2 – Install RDBMS and Database Maintaining an Oracle Database can be a pain sometimes. I admit that. It’s a massive Software, with so many facets in features, functionality and restrictions. Having to manage several hundreds (if not thousands) of Oracle Databases in my former job, I was searching for some automation to make my life easier. And also here, there are many tools that answer some of my needs but nothing seemed really usable for my individual needs. Second, I was eager to get knowledge in Ansible as an Automation Tool by myself. So I decided to write it on my own. This is the story behind Pythia, my Oracle Database Automation Toolset.
Read More »Pythia – An Oracle DB Automation Story – Chapter 1