Wednesday, September 14, 2011

Oracle Priority Service Infogram for 14-SEP-2011

Performance: Mutex

Sounds like a badly named audio product, or perhaps some kind of cleaning agent, but in fact it's an important term for performance troubleshooting. Here are a few links I found researching it for a customer (some are a bit old, but from very solid sources and still useful):

From Tanel Poder

cursor: pin S waits, sporadic CPU spikes and systematic troubleshooting

Latch and Contention Troubleshooting in Oracle

Library cache latches gone in Oracle 11g

A posting with some good comments below at Jonathan Lewis' Scratchpad blog: Concurrency

 From Andrey Nikolaev: Mutex waits. Part 1. “Cursor: Pin S” in Oracle 10.2-11.1. Invisible and aggressive.

And finally from the 11.1 docs, on V$MUTEX_SLEEP_HISTORY.

Database Express

The Upgrade your Database - NOW! blog lets us know that: Oracle Database Express Edition 11g Release 2 is now available!

Sybase Migration

A client of mine is looking at a major Sybase conversion and was looking for resources. Things seem to boil down to two key portions - SQL Developer Migration Workbench for the database objects and GoldenGate for replicating the data in the fastest possible way. Here are a couple of postings/pages I found to be good starting points:

From Jason's Blog on Integration, Consolidation and Migration: Sybase Migrations with Oracle SQL Developer

Oracle Open World

A couple more items on what's coming up at OpenWorld. As always, a major conference makes you want to clone yourself to be at several events at once (like when several Oak Table members all present on performance at the same time). Not to mention that if you were cloned six times that means collecting SIX shopping bags of conference swag.

Let's start with MySQL: MySQL@Oracle OpenWorld

and continue with data integration:

Discover What's Coming Up at OpenWorld on Data Integration

UNIX: Back to Basics

Unix is powerful, and thus has a reputation for being dangerous. To be frank, a misplaced comma in a script can undo an entire enterprise, so it can be dangerous. But if you feel confident and use Unix tools right it will save you enormous amounts of time and money. Here are a couple of items for those starting out or those reviewing:

Learning Unix


The Vim Cheat Sheat for Programmers by Michael Pohoreski

and a quick example from over at dbaStreet on how useful Unix scripting can be in the day to day work of a DBA: Shell script to generate awr diff reports.

Data Warehouse

From The Data Warehouse Insider: So why do I need "so much extra space" for my partition SPLIT operation?

Oracle VM

Oracle VM 3 is out there. It might be time for you to take another look: Oracle's Big Virtualization Bet.

Star Trek at 45

Nothing to do with Oracle, of course, but I'm a Trekkie, so, it would appear, is Tom Kyte, and anything he writes about has been 'touched by Oracle'. So here is his posting on the 45th anniversary of Star Trek: 45 years ago...

And in science news, another step toward Star Trek technology:

Interesting how technologies evolve in similar ways. When the city reached its limits builders broke through to the next level by adding layers. The introduction of cheap, strong steel and re-bar reinforced concrete allowed the birth of large, inexpensive buildings and skyscrapers. And the city moved to the next stage. From this article it looks like the next re-bar has been found for computer chips, allowing them to sprout up into skyscrapers full of churning data.

Breakthrough: The Secret to Making Processors 1,000 Times Faster [VIDEO]

No comments:

Official, Youbetcha Legalese

This blog is provided for information purposes only and the contents hereof are subject to change without notice. This blog contains links to articles, sites, blogs, that are created by entities other than Oracle. These links may contain advice, information, and opinion that is incorrect or untested. This blog, links, and other materials contained or referenced in this blog are not warranted to be error-free, nor are they subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this blog, links and other materials contained or referenced in this blog, and no contractual obligations are formed either directly or indirectly by this blog, link or other materials. This blog may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. The opinions and recommendations contained in this blog(including links) do not represent the position of Oracle Corporation.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.