Tag: Linux

The importance of Oracle database related kernel parameters (aio-max-nr) (with bonus track)

We tend to configure a server following Oracle best practices for the kernel parameters, but what once was a server of a couple instances, soon becomes a huge and heavy environment with four, six or ten instances running on it…

Read More >

Chart Your Course With sar

The sar (system activity reporter) is a Linux utility that actually started life long ago in System V Unix. In spite of its ancient origins, sar is still quite useful, and has even been enhanced in recent versions of Linux….

Read More >

Intel Skylake and Kaby Lake CPU Detector – Sherlock Holmes need not apply

Perhaps you’ve heard of the HyperThread bugs that are found in Intel Kaby Lake and some Skylake processors. (This article is intended for Linux based servers). No?  Then you may wish to read this article from the Debian support list:…

Read More >

Datascape Podcast Episode 2 – Running SQL Server on Linux – Say whaaat??!

SQL Server is a conventional RDBMS created in partnership between Microsoft and Sybase in ~1989. Since then, SQL Server has only ever run on the Windows operating system. Infoworld ranked SQL Server as the second most popular database (along with…

Read More >

GNU Screen Utility for DBAs

Gleb Otochkin, Principal Consultant and Certified Oracle Expert at Pythian, explains how to use the GNU Screen utility for DBAs.

Read More >

The rlwrap utility for DBA.

I spend most of my time as a DBA in linux terminal and sqlplus. Everybody who works with oracle sqlplus knows about its power, but also about its limitations. For many years I have used the rlwrap utility developed by…

Read More >

vm.swappiness and OOM in RHEL6

The behavior of vm.swappiness was always a bit confusing for novice linux users, as setting vm.swappiness to 0 would not completely disable swapping in the system during a memory crunch. vm.swappiness would only affect the agressiveness of swapping. Following upstream…

Read More >

Encrypting sensitive data in puppet using hiera-eyaml

Minto Joseph, Site Reliability Consultant at Pythian, explains how to encrypting sensitive data in puppet using hiera-eyaml.

Read More >

How to recover space from already deleted files

Austin Arowsmith, Site Reliability Consultant – Assistant Team Manager at Pythian, explains how to recover space from already deleted files.

Read More >

No Arguments Here – Use xargs for File Management Performance

Jared Still, Pythian Principle Consultant and Oracle ACE, explains how using xargs with find can greatly speed up maintenance scripts and reduce system resource usage.

Read More >
Page 1 of 512345