Home Code Snippets Oracle Reference Oracle Functions Oracle Error Codes Forum Oracle Jobs Oracle Blogs

Category Archives: Architecture

VirtualBox

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 […]

Tagged , , , , | Leave a comment

Search PSOUG from SQL Developer !

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 […]

Also posted in Uncategorized | Leave a comment

Dear DBA ( a note from a principal developer)

Besides changing commit intervals, noarchive, nologging, and SQL append hints can greatly aid bulk-loading data to an Oracle system.

Also posted in data loading | Tagged , , , , , , , , | Leave a comment

What’s your XML strategy?

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 […]

Tagged , , , , , , , | Leave a comment