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
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
and
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:
Post a Comment