Tag: performance

Valerie Parham-Thompson explains why duplicate (redundant) indexes are sometimes helpful.

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

Introduction Every DBA should know that the baseline is one of the most important pieces to make a proactive troubleshoot to discover potential problems in your SQL Server environment. The baseline is a key point to measure the instance performance…

Know the performance implications of a command before deciding to use it.

Christo Kutrovsky, ATCG Principal Consultant and Oracle ACE at Pythian, shares something useful he discovered by accident when playing with Auto DOP.

Michelle Gutzait, one of Pythian’s SQL Server Experts, offers some helpful use cases for those who have trouble deciding which tables they should partitioning or not.

In Part 1 of this series, Valentin Nikotin, will teach you about migrating from RDBMS to Hive, while maintaining the simplicity and flexibility of a SQL approach.

  Recently on a heavily used and freshly upgraded 12.1.0.2 ware-house type database, we started seeing lots of ORA-10173 dumped into the alert log. The information out there on this error is somewhat sparse, and it is often linked to…

If your system meets any of the following criteria: – Oracle 12.1.0.2.0 or higher – Partitioned tables – Parallel query heavily used – Bind variables in use, as they should be and, you’re seeing unusually high “cursor: pin S wait…

Oracle Grid Infrastructure 12c uses a considerable amount of RAM and CPU resources; here are a few tips to shoehorn it into a 2GB virtual machine.