Follow Us on Twitter

Better performance on database links

by Michel van Zoest on September 2, 2010 · 1 comment

In my current project we are looking at different solutions to improve performance for our applications. One of the issues is that we have an APEX application running on database X. Data for this application is partially pulled from a SIEBEL database Y using a database link. When looking through the explain plans, we noticed [...]

Read the full article →

How to Reinstalll DBconsole

by Jos van den Oord on August 13, 2010 · 0 comments

Step-By-Step – DBconsole RAC Uninstall WARNING: The uninstall process will Quiesce the database. Do not run on a live system 1. Ensure you have the following information before continuing. Database unique name Listener port number Password for SYS user Password for SYSMAN user 2. Log onto any node in the cluster. 3. Set-up your environment [...]

Read the full article →

Getting ready for Oracle OpenWorld 2010

July 28, 2010

Oracle OpenWorld, the largest and most important Oracle conference of the year, will flood San Francisco from 19 until the 23 September. Whitehorses will be represented there by our two Oracle ACE professionals.

Read the full article →

[Oracle APEX 4.0] Create Multiple Users

June 29, 2010

My first post on my own APEX 4.0 installation and it’s about user maintenance. New in APEX 4.0 is an option called “Create Multiple Users”. It’s located in the task lists in the Administration section of the Application Builder. When the option is selection you’re presented with a screen where you provide the details of [...]

Read the full article →

“Right Availability”, a pragmatic approach to Maximum Availability Architecture

June 25, 2010

Oracle provides an extensive list of options, like Real Application Clusters (RAC), Data Guard and Flashback technology, to tackle the broad variety of causes for downtime. These options are combined in a blueprint for HA called the Maximum Availability Architecture (MAA). This isn’t only for the super large organizations.

The customer case of Provincie Zeeland shows that great improvements can be gained using a pragmatic, smart approach and focusing on “right availability”. Using Active Data Guard they implemented a fail-over system for disasters that can be used to reduce the load on the primary systems at the same time.

Read the full article →

Oracle Application Express 4.0 released

June 23, 2010

Today Oracle Application Express 4.0 has been released! It is available for download on OTN. At the moment the download is a bit slow, but good things come to those who wait . You can read all about the new features here. Update: And once installed, you are the administrator of APEX 4.0!

Read the full article →

TortoiseSVN and Oracle SQL Developer

June 16, 2010

I like Oracle SQL Developer. And I like TortoiseSVN. Oracle SQL Developer has versioning support, but some tasks are more easily done with TortoiseSVN. Maybe it’s what I’m accustomed to, but that’s the way I feel about it. Today, I ran into a problem to get the versioning support in Oracle SQL Developer (based on [...]

Read the full article →

Google Chrome for developers

June 11, 2010

Google Chrome is becoming a very popular browser and attracting more users every month as you can see on w3cschools.com. As a developer I used to work mainly with Mozilla Firefox because of the great developer extensions Web Developer Toolbar and Firebug. But Google Chrome is also for the developer and even better, it’s built [...]

Read the full article →

Cloning a Virtual Disk in Oracle VM Virtualbox

June 2, 2010

Cloning a disk is an Unix-y type way of creating a duplicate disk. We need to invoke the CloneHd command of the VBoxManage tool, supplying the disk to clone and the name of the new ‘cloned’ disk. In its simplest form, you would do something like this at the command-line: VBoxManage clonehd “DiskToClone.vdi” “ClonedDisk.vdi” The [...]

Read the full article →

dbms_xmldom: write a xml document to a file

June 1, 2010

Create a xml-file from the database is not difficult certainly not if you use the package dbms_xmldom.

First you have to create a directory object in the database. This directory object is a reference to a file-system directory. You must have the system privelege to create a directory…

Read the full article →

← Previous Entries

About Whitehorses
Company profile
Services
Technology

Whitehorses website

Home page
Whitebooks
Jobs

Follow us
Blog post RSS
Comment RSS
Twitter