Oracle VM Consulting
view counter

Oracle Priority Service Infogram for 14-SEP-2011

Thanks to Oracle Infogram for this story


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

Oracle Virtualization and Cloud Consulting
view counter

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 andwas looking for resources. Things seem to boil down to two key portions - SQLDeveloper Migration Workbench for the database objects and GoldenGate forreplicating the data in the fastest possible way. Here are a couple ofpostings/pages I found to be good starting points:

From Jason's Blog on Integration, Consolidation andMigration: 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

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 similarways. When the city reached its limits builders broke through to the next levelby adding layers. The introduction of cheap, strong steel and re-bar reinforcedconcrete allowed the birth of large, inexpensive buildings and skyscrapers.And the city moved to the next stage. From this article it looks like the nextre-bar has been found for computer chips, allowing them to sprout up into skyscrapersfull of churning data.

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




Read the entire article at its source

view counter