Most of the readers of this blog will be developers, or DBAs, who got the rules of Normalisation drummed into them during some phase of the education or training. But often we get to work with people who don't have that grounding. This post is for them. Feel free to point them at it.
This example shows how to deal with the enq: SQ – contention wait event. It was tested on Oracle 11.2.
Thank you all for coming to my session Cache Buffer Chains Demystified at Collaborate 14, especially for sticking around for a geeky topic like this to the very end. Much appreciated.
I was not aware that I would not be allowed to use my laptop; so I couldn't show all the demos I so carefully prepared. Please download the scripts and execute them yourself.
As promised, here are the materials I used in the session
Jephe Wu - http://linuxtechres.blogspot.comProblem: random assigned ethX name with MAC address and renamed ethX to something else, different /etc/issue output after each rebootEnvironment: Oracle VM server 3.1.1, PCI card with multiple NIC portsSteps:1. use DRAC and lspci to check pci bus infoOpen DRAC, network device, check each MAC address for NIC2. draw network diagram for each NIC MAC address
1. Register Static service
To enable DGMGRL to restart instances during the course of broker operations, a static service must be registered In the listener.ora, the following entries should be presented:
LISTENER = (DESCRIPTION =
Our new (free!) Portfolio tools and themes put your creativity front and center.
12c Adaptive Plan feature has already been exposed by Nicolas Jardot in OOW 2013 : Solving customer issues with the 12c Optimizer.
Among the most critical but often most neglected database administration tasks is testing restore from backup. But sometimes, you don’t have a test system handy, and need to test the restore on the same host as the source database. In such situations, the biggest fear is overwriting the original database. Here is a simple procedure you can follow, which will not overwrite the source.
Today’s blog post is the first of three in a series dedicated to data infrastructure outsourcing, with excerpts from our latest white paper.
Despite the strong push to outsource corporate functions that began more than two decades ago, many IT shops have been hesitant to outsource their data management requirements.