Proof of Concept Maximum Availability Architecture
Preparation Steps
To prepare ourselves we have read the paper of Jeffrey Hunter: Build Your Own RAC 10g Release 2 Cluster on Linux and Firewire http://www.oracle.com/technology/pub/articles/hunter_rac10gr2.html
This paper has been in the top 5 most read DBA Articles on OTN for the last 3 months. And it is one of the first [...]

Popularity: 296 points

Check if your database can benefit from IOTs. You could be surprised.
Index Organized tables are possibly the most under used feature after the clustered table (now there is another underused item …). IOT’s also have some additional benefits that the manual seems to forget.
In brief: If you have tables with parent-child relations, or dependent [...]

Popularity: 146 points

If you would like to explain to less technical people what RAID is in a figurative way you can use this link.
Popularity: 280 points

Popularity: 280 points

In the server room of LogicaCMG Arnhem we setup the Proof of Concept Servers using demo equipment from HP and with the help of an HP engineer.

Popularity: 284 points

Popularity: 284 points

Introduction
LogicaCMG initiated a proof of concept (PoC) in January 2006. LogicaCMG tries to develop best practices on the implementation, configuration and deployment of RAC and Data Guard a.k.a. the Maximum Availability Architecture. The main point of our PoC is to simplify installation and DBA maintenance tasks by using as much as possible a “shared everything�? [...]

Popularity: 142 points

On March 22, Duncan Mills gave an excellent presentation on meta framework. He discussed the challenges we face when developing (web) applications and how meta frameworks can help us developers to tackle those problems. Some really interesting subjects were discussed, certainly food for thought.
A recap of his presentation can be found here
The presentation of Duncan [...]

Popularity: 136 points

At the moment a college has asked me to think with him about a big contract. It’s mainly about the bigger things in development life and forced me to think about developing bigger applications than we have done until now. This fortunately fell together with the talk Duncan Mills had at Guru4Pro (see other article) [...]

Popularity: 175 points

As Okke stated earlier, Duncan Mills has made a visit to the Netherlands to speak on an event called Guru4Pro. Guru4Pro is a series of presentations given by knowledgable guru’s. The first of these presentations was given by Duncan Mills of Oracle. Duncan has been working in the field for 18 years in total, of [...]

Popularity: 339 points

Last week we encoutered the problem that reading a 10,000 record csv-file took 45 minutes from a location in Belgium. From The Netherlands it took about 20 minutes. The Application Server and Database Server is located in the UK. The difference is due to available band width.
The performance from both locations were not acceptable. How [...]

Popularity: 334 points

Let’s consider the contents of the famous dual table:

SQL>select * from dual;
D
-
X
SQL>select rownum from dual;
ROWNUM
———-
1

Now let’s try to get multiple rows returned form dual:
Popularity: 163 points

Popularity: 163 points