Posts Categorized: Oracle

Locks, Latches, Mutexes and CPU usage

So how is the actual “waiting on lock” implemented? How does session B waiting for a transaction to commit started by session A, knows that the resource is free for use? To find out how it is implemented, I have traced Oracle foreground processes. I tried this on Oracle RDBMS 11.2.0.3 running on Linux. This is a excerpt of system calls being executed during a session waiting for a lock:

The Exadata Installed Base, Quantified

Update 13-June-2012: it has come to my attention that the numbers from the original source may have been incorrect or improperly released. To avoid confusion and potentially misleading information, the original content of this blog post has been removed.

Should your ADR be on Shared Storage?

I was on an Exadata environment with four RAC instances, when a fellow DBA created an incident package. No big deal, except part of the adrci packaging procedure was to take a backup of the controlfile and include it in the incident package. Though the package was created successfully, the controlfile never made it.

NoCOUG Contest Take #1: The Es-cu-el spell

As heralded by Iggy Fernandez and Gwen Shapira, NoCOUG has launched its Third International SQL vs. NoSQL Challenge. Pythian is sponsoring the challenge so I decided not to take part in the contest. However, I’m still having a crack at the problem just for fun. So, here is my first take on it.

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

Technical blogging has become more than just a way to tell the world what the technologist did. It has become a vibrant medium through which the tech bloggers are sharing their experiences and teaching the interested audience. It has become an enabling technology. This Log Buffer Edition encompasses such vibrant blogs in Log Buffer #274.

Error Installing Oracle VM: File “/usr/lib/anaconda/network.py”, line …

I just installed 3.1.1 Oracle VM server for training purposes on my sandbox and faced the same issue I faced installing 3.0.3 and 3.0.1 versions before. I quickly found a workaround that worked for me. But as follow up I decided to search though Google and MOS in order to see if there has been any good development in resolving the issue from others (Oracle may be ;). Anyway this is that I found.

Page 16 of 102« First...10...1415161718...304050...Last »