Summer Student Project Report - Steffen Pade

During my summer project here at CERN I was able to work with a - to me - completely new database technology: Oracle’s 12c. My task was to investigate on a new feature called ”Far Sync”. I was asked to run performance tests using Oracle’s ”Real Application Testing” framework. The main goal was to find out whether Far Sync is working as promised by Oracle with real workloads from production database systems. After having finished this, I was given the task to extend an existing python tool by a new module. The python tool called ”DBCheck” is supposed to check the setup of database systems for their proper configuration. My module will not only check one system but a group of systems, further called ”Data Guard system”. Including at least two database systems interacting. The tools checks for proper system setup and configuration so the whole group of databases can interact properly as supposed to.