This week I got myself an intel SSD 750 series SSD (400 GB) for my Dell Optiplex-9010 desktop PC. A machine that is almost 3 years old now.
It has an Intel i7-3770 CPU (4 cores + hyperthreading) and 32 Gigabytes of RAM. I already had a small 128GB SSD in that machine.
To increase performance and to bypass the SATA2 bottleneck, I decided to get the 750SSD, which comes as a PCI Express Card (Gen 3 x4)
I have Windows 8.1 installed as host Operating System and use Oracle VirtualBox 5.0 for running my linux images.
The virtual machine I use most, consists of a custom Oracle 11g RDBMS on Red Hat Enterprise Linux.
In that database I installed Oracle Application Express 5.0
Additionally I installed ORDS in the linux virtual machine.
To make better use of the available resources I tweaked the database SGA to use more of the available memory (memory_max_target=3504M and memory_target=3200M).
Playing around with SGA size can be a pain in the butt, I had to go through a couple of cycles until it matched as I wanted it.
(Crazy in how many different Oracle Error messages you can run to along the way, preventing database startup.
Luckily for me I no longer work as a DBA. Also this happens at home and not on a production database.
For it to finally work I had to adjust the linux shared memory settings).
From my Windows host I can connect to the linux virtual machine using Microsoft Remote Desktop client.
My APEX development itself is then done with the google chrome browser running on the host PC.
I connect to the database with SQL Developer 4.1 also running on the host PC.
A few years ago I wrote a small systray application I call Qbit. I’m using it to control my virtual machines, do automatic pings, etc.
(Might release Qbit to the public one day, but that’s another story).
Now back to the 750 SSD, what to expect from it? For one thing it’s blazingly fast. The linux image boots in a few seconds, saving machine state to the SSD is a snap. It’s really a joy to play with. Here’s a benchmark result.
So, there you have it. That’s the equipment I use to do APEX development (in my spare time) at home.
APEX is fun, and so are SSD’s.