Author: Maris Elsins

Achieving rock-solid maintenance with template-based action plans

Pythian has always been serious about reducing human mistakes. Our consultants have always been required to log all terminal outputs for the work we execute so that the information is available to our clients, and to make sure the same…

Read More >

Using Docker to provide self-service database patching

I’ve been looking into how Vagrant and/or Docker can be used to improve the life of DBAs and maybe others, too. I did this mostly to practice using these tools – especially Docker – that are becoming more and more important…

Read More >

Redo Volume Optimization in 12c R2

I was using SLOB to compare the throughput between 12.1 and 12.2 databases, and was surprised to see that the average redo size per transaction was ~18.5KB on 12cR2, and ~339KB on 12cR1. Understanding this difference was important for the…

Read More >

Automating Password Rotation for Oracle Databases

Password rotation is not the most exciting task in the world, and that’s exactly why it’s a perfect candidate for automation. Automating routine tasks like this are good for everyone – DBAs can work on something that’s more exciting, companies…

Read More >

Investigating IO performance on Amazon EC2

I published a blog post called “Investigating IO Performance on Amazon RDS for Oracle” recently, and soon after posting it I received several questions asking if IO worked the same way on EC2 instances. My immediate though was it did,…

Read More >

Investigating IO Performance on Amazon RDS for Oracle

Maris Elsins, Lead Database Consultant at Pythian, provides an in-depth examination of IO Performance on Amazon RDS for Oracle.

Read More >

The getMOSPatch V2 Is Here!

Maris Elsins, Lead Database Consultant at Pythian, Oracle ACE & OC announces a new version of the tool getMOSPatch V2.

Read More >

Internals of Querying the Concurrent Requests’ Queue – Revisited for R12.2

Maris Elsins, Lead Database Consultant at Pythian, Oracle ACE & OCM, revisits the internals of querying the concurrent requests’ queue for R12.2.

Read More >

Is Oracle Smart Flash Cache a “SPOF”?

Maris Elsins, Lead Database Consultant at Pythian, Oracle ACE & OCM, explores whether the failure of a solid-state device used by Oracle Smart Flash Cache affects the availability of the database.

Read More >

Handling the Leap Second – Linux

Last week I published a blog post titled “Are You Ready For the Leap Second?“, and by looking at the blog statistics I could tell that many of you read it, and that’s good, because you became aware of the…

Read More >
Page 1 of 3123