Wordpress - uhesse.wordpress.com - The Oracle Instructor
General Information:
Latest News:
Oracle University Instructors at DOAG 2013: The Program 19 Aug 2013 | 05:07 pm
My dear colleague Joel Goodman and me will present at the DOAG (German Oracle User Group) Annual Conference 2013; I’m already excited about it Apart from seeing presentations by top-notch Oracle Expe...
Why your Parallel DML is slower than you thaught 12 Jul 2013 | 05:59 pm
In the Data Warehouse Administration course that I delivered this week, one topic was Parallel Operations. Queries, DDL and DML can be done in parallel, but DML is special: You need to enable it for y...
The Data Guard Broker: Why it is recommended 8 Jul 2013 | 11:52 pm
When it comes to Data Guard on a recent version, I will always use the Data Guard Broker. Not the Enterprise Manager; don’t get me wrong: Strictly Command Line with DGMGRL. It is for Standby Databases...
Fine Grained Access Control with DBMS_RLS using UPDATE_CHECK=>true 19 Jun 2013 | 12:09 am
Fine Grained Access Control aka Virtual Private Database (VPD) has been there since Oracle 8 and got enhanced in each subsequent version. One minor New Feature of 11.2 was the addition of the paramete...
Modify segment attributes on Logical Standby during Migration 29 May 2013 | 07:54 pm
Whenever you want to change certain storage attributes of your production tables, a Logical Standby can help. A common case is to do that during a migration. Not only will Data Guard help you to reduc...
Evidence for successful #Oracle Performance Tuning 16 Apr 2013 | 02:50 pm
This article shows an easy way to determine, whether your Oracle Database Performance Tuning task has been successful – or not. In the end, it boils down to “The objective for tuning an Oracle system ...
The 3e-Approach 19 Mar 2013 | 02:47 pm
After years of teaching and studying (holding a Bachelor’s Degree in Educational Science), I think I’m now able to put my experience & conclusions into the this formular: Explain: Even a complex techn...
Appliance? How #Exadata will impact your IT Organization 20 Feb 2013 | 06:21 pm
The impact, Exadata will have on your IT’ s organizational structure can range from ‘None at all’ to ‘Significantly’. I’ll try to explain which kind of impact will likely be seen under which circumsta...
Brief Introduction into Partitioning in #Oracle 25 Jan 2013 | 04:49 pm
Partitioning is a great way to deal with large tables. This post will give you a quick start with examples that you can reproduce easily for yourself. Focus will be on Range-Partitioning, which is sti...
Top 10 postings in 2012 30 Dec 2012 | 08:02 pm
The following postings got most of your views here in 2012: 1. adrci: A survival guide for the DBA Many DBAs used this article to get a quick start with the new Automatic Diagnostic Repository feature...
