Tag: Pythian

Preventing runaway queries using Resource Governor

Section A (Theory) One of the typical reasons for performance issues is runaway queries executed by end users on a busy production database. This problem is fairly common in OLAP or shared systems (OLTP/OLAP) where business users begin executing complex…

Read More >

Do You Know Your Customers? The Truth Behind Millennial Shopping Habits

millennials

Black Friday is fast approaching and all eyes have turned toward retail and the holiday shopping season. After initial reports that 2013 would be the worst shopping season since 2009, new forecasts have upped the total sales estimate. The 2013…

Read More >

Oracle RAC on the Cloud, Part 2

In part 1 of this series, we talked about some of the challenges of setting up Oracle RAC on a public cloud provider, and went on to order some VMs from provider Gandi, and finally configuring a NFS server for shared storage. In this post, we move on to configuring the rac servers themselves, rac01 and rac02.

Read More >

Oracle RAC on the Cloud, Part 1

I’ve been working on moving a lot of the testing and R&D work I do away from local virtual machines and onto cloud environments, for a few reasons: I can avoid carrying around a laptop all the time, and rather…

Read More >

How to Download Oracle Software Using WGET or CURL

This is yet another blog post with tips and tricks to help you (and me) download Oracle software without the help of a Web browser. If you Google “how to download Oracle with wget” you’ll find heaps of posts with…

Read More >

getMOSPatch.sh – Downloading Patches From My Oracle Support

How to download patches from My Oracle Support (MOS) directly to the server? This has bothered me since the ftp access was closed a few years ago. Of course, I’ve been given some options by Oracle, like, I could access…

Read More >

The responsibility of “root”

Systems Administrators often hold the “keys to the kingdom”.  In a data driven world, every IT asset has the potential to have multiple privileged accounts, which can introduce risk to your business and your data.  From the SuperUser to the…

Read More >

Discoverer 11.1.1.7 Installation and Integration to R12.1.3 Instance

This blog gives instructions on how to install Discoverer 11.1.1.7 and get it integrated to your R12.1.3 instance. For easy installation, I have provided all of the important screen shots in a slidehare Word document. These will guide you through…

Read More >

Oracle Free Block Corruption – Test Case

My very first blog post at Pythian – Trick or Treat? So there I was, faced with more that 4000 block corruptions as shown from v$database_block_corruption. The script  corrupt_seg.sql identified the corruption as Free Block Corruption (block not associated with any segments)….

Read More >

SQL Server Instance in Script Upgrade mode

Introduction: Almost all of us in our DBA life would have patch/upgrades SQL Server instance and would have faced many issues while upgrading the SQL Server build. Today I will discuss in little detail about the background of the Script…

Read More >
Page 2 of 4212345...10...Last Page »