Step-by-step guide to January 2016 PSU patch apply on 12c drid and RDBMS homes in Linux

Creating a test lab using VirtualBox / NAT networking

My job is almost completely reliant upon my ability to perform work in lab of virtual machines. Almost every action ...

Tracking ASM Metrics

Collecting ASM IO Metrics If you are an Oracle DBA, then it is quite likely that Oracle ASM is used as the storage ...

Some Fun with MySQL's History List

Why this article? First of all, because I had fun digging in the code. Then, I was reading a lot about the improvements ...

Configure high availability - load balancing for Hiveserver2

We are noticing a steady adoption of Hive adoption among our customers. Due to the increased workload we want to make ...

Online resizing of ASM disks

The SAN administrator recently informed us that several disks were extended from 300GB to 600GB. These multipath disks ...

The Internal Workflow of an E-Business Suite Concurrent Manager Process

Concurrent processing is one of the key elements of any E-Business Suite system. It provides scheduling and queuing ...

Nagios authentication with active directory

Nagios authentication with Active Directory (AD) aligns with user management consolidation policies in most ...

Oracle Database Appliance -- Storage expansion with NFS (dNFS, HCC)

The biggest objection to Oracle Database Appliance (ODA) we hear from customers is about 4TB usable space limit ...

Availability Group - Delay with Listener Connectivity After Failover

The beauty of working for multiple clients from different industries is that you get exposed to a myriad of environment ...

How to Update JDK on Oracle Enterprise Linux from Version 1.6 to 1.7

Intro JDK is the environment to develop Java programs, and updating Java on Linux boxes is a requirement which often ...

High "cursor: pin S wait on X" waits?

If your system meets any of the following criteria:

Exadata Join Offloading in Action

One of the biggest selling features of Oracle's flagship engineered system - Exadata - is the storage offloading ...

Magic of "\d" in Vertica

A quick neat way to list down important and oft-needed information like names of databases, schemas, users, tables, ...

getMOSPatch.sh - Downloading Patches From My Oracle Support

The transition away from FTP access in My Oracle Support (MOS) several years ago introduced a significant hurdle for ...

A Simple Way to Monitor Java in Linux

A quick and easy way to know what is it inside Java process that is using your CPU. Using just Linux command line tools ...

Adaptive Log File Sync: Oracle, Please Don't Do That Again

Disclaimer: Much of what follows is pure speculation on my part. It could be completely wrong, and I'm putting it out ...

Managing Oracle on Windows: Where’s my Oratab?

Introduction If you manage Oracle on Windows, you probably have wondered why it is so difficult to work out which ...

Troubleshooting a Multipath Issue

Multipathing allows for the configuration of multiple paths from servers to storage arrays, providing I/O failover and ...

Weblogic patch rollback issues in Oracle EBS R12.2

When you try to rollback a weblogic patch in Oracle EBS R12.2, you might run into issues similar to below:

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 ...

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 ...

Debugging high CPU usage using Perf Tool and Vmcore Analysis

There are several tools and technologies available to debug deeper into high CPU utilization in a system; perf, sysrq, ...

fsfreeze in Linux

Suspending and Resuming Access A filesystem can be frozen using following command: # /sbin/fsfreeze -f /data Now if you ...

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 ...

How to Troubleshoot OEM 12c Cloud Control Auto-Discovery

I was recently involved in an upgrade project to go from 11.2.0.2 to 11.2.0.3 on an Exadata V2. We hit some snags ...

Select Statement Generating Redo and Other Mysteries of Exadata

Like many good stories, this one also started with an innocent question from a customer: “I often check “SELECT ...