Tag: Pythian

Do AWR Reports Show the Whole Picture?

AWR report is a great source of aggregated information on top activities happening in our databases. I use data collected in AWR quite often, and obviously the easiest way of getting the data out from the AWR is by running the…

Read More >

How to recover a subset of an Oracle database

Today’s blog post will discuss how to recover a subset of an Oracle database. Many of you would have come across different recovery scenarios, but I’ll be talking about a very different one that happened to me. The following are…

Read More >

Online Storage Migration without ASM

I recently blogged about Playing with ASM Online Migration and still soul searching from not having jumped on the ASM band wagon. How can online storage migration be performed before ASM came about? One option is using Logical Volume Manager…

Read More >

How to move Oracle DB to New Oracle Home on Same Windows Server

I have been thinking about writing a Pythian blog for long time, and today I finally took the opportunity. In the DBA life, it’s common to get a request to move the database across servers due to a RDBMS upgrade…

Read More >

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

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 >
Page 2 of 4012345...10...Last Page »