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

Author Archives: admin

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

Posted in Architecture | 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 […]

Posted in Architecture, Uncategorized | Leave a comment

How to build and maintain an Oracle shell

Using import, export, and strings command to maintain software baselines and Oracle shells for productized software development.

Posted in Uncategorized | 1 Comment

Paying attention to Oracle sequences when upgrading / migrating

it would not be feasible to use the shiny, trusted front-end tool that the DBAs had to browse and navigate to each application schema and manually click on each sequence to reverse engineer it. We needed dynamic SQL to do them all in one shot but without all those those SYS, sample and unused schemas detailed in support docs 207560.1 and 270516.1

Posted in DBA tips | Tagged , , , , , , | 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.

Posted in Architecture, 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 […]

Posted in Architecture | Tagged , , , , , , , | Leave a comment

In the Arkytekture

to share some real-world experiences (ok, maybe thinly disguised ones) that illustrate either database technology issues, software engineering practices, or some other philosophy.

Posted in Uncategorized | Leave a comment