Author Archives: arkytekture
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 [...]
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 dynamic SQL, migration, planning, rescue, reverse enginering, sequences, upgrade
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 advisor report, append hint, bulk loading, commit strategy, jdbc, noarchive, nologging, redo log, XML
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 CLOB, language, LOB Index, LOB Segment, Text, XML, XMLType, XSD
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
