This is DBA basics 101 in the oracle world but well also something that we grumpy DBA types forget from time to time. We have an existing table in a schema that is populated with data. Something like this say:
Kanna Technologies Proudly announces next Oracle DBA Online Below are the course details: Faculty: Pavan Dba Demo: 14/04/0214 Start Date: 21/04/2014 Timings:08:30PM – 10:00PM IST Duration: 30 days Demo Link:https://global.gotomeeting.com/meeting/join/156856405 Registration Link: http://dbatalent.com/index.php/store/product/46-oracle-dba-11g-12c Coupon Code: DB@T@L3NT Note: Early Bird Registrations will get 10% Discount.
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.