Posts Categorized: Oracle
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 184.108.40.206 running on Linux. This is a excerpt of system calls being executed during a session waiting for a lock:
This is just a very short blog entry to inform folks that there is an open discussion group over at LinkedIn for SLOB topics of interest. The group can be accessed through the following link
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.
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.
This posts finalizes a few weeks work on comparing SLOB and ORION IO testing tools.
In this blog post I share physical IO testing results I got running SLOB and ORION on the same system on the same disks. I will use those results as a reference in few next blog posts. As of now I would like to make few points based in the results here.
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.
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.
The purpose of this blog post is to share my favorite speakers list from Collaborate 12 and give you hints on who you may want to listen at future conferences. Let me start with 4 speakers that I didn’t hear before Collaborate 12.
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.