Category Archives: Architecture
Oracle VM VirtualBox If you haven't had a chance to work with it, consider visiting http://dlc.sun.com/virtualbox/vboxdownload.html It runs on windows, linux, mac os/x and solaris. I downloaded a pre-installed VM with a database, development tools, and an application server pre-installed. Though I had the minimum required config (~2 GHz processor, 2 GB RAM), I was [...]
Extend Oracle's SQL Developer to search PSOUG web pages and see how much more productive you can be! Anyone who's used SQL Developer may have noticed the search engines tucked away in the upper right corner of the screen. With a nod to Firefox, the people who created SQL Developer made it easy to look [...]
Besides changing commit intervals, noarchive, nologging, and SQL append hints can greatly aid bulk-loading data to an Oracle system.
The choices you have on implementing XML depends upon the architecture of your solution. 1) Do you plan to a) parse the XML docs and store them into multiple relational tables ? If so, what languages or techniques do you intend to use to accomplish this? b) store an XML doc in a single XMLType [...]