Pythian Marketing

Table recovery with rman in Database 12c

One of the new features of rman in Oracle Database 12c is the topic of this short document. For many years since we ...

Troubleshooting Oracle's Auto Service Request

I've spent the better part of the day troubleshooting an issue with Oracle's Auto Service Request (ASR) and wanted to ...

What is the difference between logical and physical corruption in Oracle?

Slimming Down Oracle RAC 12c's resource footprint

I've been working on setting up a demo for my upcoming presentation on application continuity at RMOUG training days ...

Monitoring Cassandra with Grafana and Influx DB

Hello, In this post I will explain how to set up Cassandra monitoring with influxDB and Grafana. This can also be used ...

Troubleshooting Transactional Replication Latency Using Agent Statistics

In this blog post, we will look at how you can leverage the Agent statistics to troubleshoot the replication latency ...

Oracle Database 12c: Network Recovery in RMAN

Over the past 8 months, I have had the pleasure of working on a soon-to-be-released update for our popular Beginner's ...

Database 12c: What's New with Data Pump? Lots.

This article will discuss some of the new stuff on board with Oracle Database 12c and one of our favorite tools: data ...

Guide to Cassandra Thread Pools

This guide provides a description of the different thread pools and how to monitor them. Includes what to alert on, ...

How To Improve SQL Statements Performance: Using SQL Plan Baselines

The performance of any Oracle database heavily relies on query execution(s). The reasons for any SQL statement’s ...

Disable Lock Escalation in SQL Server

Introduction If a lot of rows or pages are locked, the SQL Server escalates to a table-level lock, to save resources. ...

Merge Replication Identity Range Management - An Identity Disorder? Part 2

In Part 1 of this series, we explored Merge Replication Identity Range Management of tables with identity columns. We ...

Magic Knobs in Replication Agents

Have you ever wondered if there's a "secret sauce" for tuning your replication configuration to squeeze out better ...

Building a MariaDB Galera Cluster with Docker

There’s been a lot of talk about Docker for running processes in isolated userspace (or the cloud for that matter) ...

Fixing Windows RAC listener to listen on IP address of Hostname

Background Recently, there was an issue after a node was added to an existing Windows RAC cluster. After everything was ...

Small files on MapR-FS

One of the well-known best practices for HDFS is to store data in few large files, rather than a large number of small ...

How SQL Server browser service Works

Some of you may wonder the role SQL browser service plays in the SQL Server instance. In this blog post, I’ll provide ...

SQL Server replication quick tips

There is a time in every SQL Server DBA career where a mail came in with a “replication is not working, please check” ...

Virtual CPUs with Amazon Web Services

Some months ago, Amazon Web Services changed the way they measure CPU capacity on their EC2 compute platform. In ...

Connection Resets When Importing from Oracle with Sqoop

I’ve been using Sqoop to load data into HDFS from Oracle. I’m using version 1.4.3 of Sqoop, running on a Linux machine ...

SQL server error: 18056, Severity: 20, State: 29

Introduction Howdy everyone, One of the most frequent error messages I come across when dealing with SQL Server, ...

Disabling Triggers in Oracle 11.2.0.4

In March 2012, I put together a blog post entitled Disabling Oracle triggers on a per-session basis, outlining a way to ...

Getting ready to install EBS 12.2 Vision: Quickstart notes

Getting ready for the next big thing In the wake of last week’s announcement of the general availability of Oracle ...

Benchmark: TokuDB vs. MariaDB / MySQL InnoDB compression

Introduction As the amount of data companies are interested in collecting grows, life becomes all the more difficult ...

A (BIG) Trick Listing Windows updates using PowerShell

If you (like me) are using Microsoft.Update.Session for listing the installed windows updates, you might be surprised ...

An introduction to extended data types in Oracle 12c

Introduction One of the lesser known new features that comes as a boon to many developers and DBAs is the provision of ...

Linux HugePages for Oracle on Amazon EC2

Situation One of the optimizations available to us when running Oracle on Linux is huge page support. This feature of ...

Data profile: better knowing your data

Problem Statement Have you ever needed to start a new data analysis project or create a report for the business users ...