Oracle

Oracle RAC on the Cloud, Part 3

This is part 3 of a multipart series of getting oracle RAC running on a cloud environment. In part 1, we set up a NFS server for shared storage. In part 2, we set up OS components for each RAC server. Now we finish up the OS configuration and move to Oracle grid infrastructure.

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.

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 log onto the cloud wherever I happen to be It’s easy to scale down and…

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 useful tips. I decided to write this post to compile the methods I’m aware of…

Log Buffer #345, A Carnival of the Vanities for DBAs

There are a number of technologies, apps, and social media creations out there seeking to displace blogs as the mode of sharing between surfers, but blogging has proved hardy. It has proven its mettle and it’s here to stay. This Log Buffer Edition appreciates this strength of the blogs.

Meaning of “Disk Reads” Values in DBA_HIST_SQLSTAT

This post relates to my previous writing on mining the AWR. I noticed that it’s very easy to misinterpret the DISK_READS_TOTAL and DISK_READS_DELTA columns in DBA_HIST_SQLSTAT. Let’s see what the documentation says: DISK_READS_TOTAL – Cumulative number of disk reads for this child cursor DISK_READS_DELTA – Delta number of disk reads for this child cursor You…

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). So how can free block corruption be removed? One method is to format the corrupted…

Mining the AWR to Identify Performance Trends

Sometimes it’s useful to check how performance of a SQL statement changes over time. The diagnostic pack features provide some really useful information to answer these questions. The data is there, but it not always easy to retrieve it, especially if you want to see how the performance changes over time. I’ve been using three really…

Page 10 of 140« First Page...89101112...20...Last Page »