(Lisa Vaas) A few months back, the travel site Orbitz was grounded for a full day due to a technology snarl that it blamed on Oracle’s RAC (Real Application Clusters) technology. Considering that RAC is a cornerstone component of Oracle’s much-heralded and almost-here Oracle Database 10g and the who
Tag: Oracle
Designing Schemas
(Cameron O’Rourke) When you build an application, do you start with a database schema that has been solidly designed and tested? Or does your application begin its lifecycle on a wobbly foundation, perched atop a machine-generated schema? In this article, I hope to convince you to view database
Finding Memory Leaks Using JDeveloper’s Debugger
(Brian Duff) Memory leaks in Java applications can sometimes be tricky to detect and diagnose. Although garbage collection in Java eliminates much of the fuss of manual deallocation needed in languages like C, it’s sometimes a double-edged sword. Cleaning up is mandatory (if somewhat tedious) in lan
A Comparison of Oracle 9i with DB2 v8.1
(Alexander Chigrik) It is very difficult to make a performance comparison between Oracle 9i Database and DB2 Universal Database v8.1. The performance of your databases depend rather upon the experience of the database developers and database administrator than from the database’s provider. You can u
Oracle 9i: Performance Tuning with OMLET
(Amjad Daoud) This book is about performance tuning techniques using OMLET (Oracle Monitoring Applet): proactive (OMLET statspack edition) and iterative (OMLET professional edition). OMLET is a lightweight, non-obtrusive, pure 100% JAVA application that runs everywhere JAVA 2 lives!. Supported pla
First Expressions (all about regular expressions)
(Jonathan Gennick) Regular expressions represent a powerful tool for describing and manipulating text data. Indeed, from humble roots in early UNIX utilities such as qed and ed, regular expressions have gone on to become almost ubiquitous, supported by a wide variety of programming and scripting lan
Back Up the Control File Image
(Faina Goldenberg) This UNIX shell script will back up a control file as the current image of controlfile for each active instance (automatically started on the server). (script)
Manipulating Oracle Files with UTL_FILE
(James Koopmann) Maintenance of the Oracle alert log file has and continually will be a pain to work with until the day that Oracle realizes they need to hook in a few more operating system utilities to manage their own trashcans. About this time last year I wrote an article called ‘That Darn Alert
Database Wars: Oracle vs. Microsoft
(Vincent Ryan) The clash between Oracle and Microsoft in the database-management system market is a case of the grass always seeming greener in the other guy’s yard. While Microsoft owns the small and mid-size market, it wants to move up to large enterprises with mission-critical database applicatio
Installation Cookbooks: Installing Oracle9i
(Steve Callan) When people talk about installing Oracle, more times than not they are referring to installing the program files for the relational database management system (RDBMS) application. Other people use the word Oracle somewhat loosely when referring to any Oracle product (e.g., Forms & Rep
