Tag: performance

Analyze Index Validate Structure – The Dark Side

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

Read More >

Oracle’s CREATE INDEX command can take a hint

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

Read More >

Use Case for SQL Server Table Partitioning

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.

Read More >

Recursion in Hive – Part 1

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.

Read More >

ORA-10173: Dynamic Sampling Time-Out Error

  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…

Read More >

High “cursor: pin S wait on X” waits?

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…

Read More >

Slimming Down Oracle RAC 12c’s Resource Footprint

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.

Read More >

High System Time on Windows Running in a VM

Recently I’ve seen an issue with CPU usage on a server running Windows 2003 Server in a VMware. This is a small Virtual Machine with just 2 cores allocated (which are possibly mapped to “threads” on a host level but…

Read More >

In-Memory Column Store: 10046 May Be Lying to You!

The Oracle In-Memory Column Store (IMC) is a new database option available to Oracle Database Enterprise Edition (EE) customers. It introduces a new memory area housed in your SGA, which makes use of the new compression functionality brought by the…

Read More >

Comparing CPU Throughput of Azure and AWS EC2

After observing CPU core sharing with Amazon Web Services EC2, I thought it would be interesting to see if Microsoft Azure platform exhibits the same behavior. Signing up for Azure’s 30-day trial gives $200 in credit to use over the…

Read More >
Page 1 of 3123