(Marco Gilbert) When you are working with UNDO (instead of ROLLBACK) there are two important things to consider: 1.) the size of the UNDO tablespace, and 2.) the UNDO_RETENTION parameter.

(Sean Hull) When it comes to Web development these days, you have a lot of options. Many of these methods involve preprocessing—that is, embedding code into HTML pages with special tags that signal to a preprocessor that they contain code, and that it should do something with it. Much like a CGI, th

This tutorial focuses on the usage and benefits of TLD Caching. TLD Caching improves the performance during Application Startup and JSP Page Translation.

(Michael Klaene) Auditing data of business applications is a common requirement. In this article, I’ll demonstrate one way to audit Oracle data that is both simple and flexible. The code is written in Oracle PL/SQL and can be applied to any modern Oracle database. The process demonstrated can be dup

(Tugdual Grall) Often portlets have to access various systems to publish personalized data into your portal. Some examples are connecting to a mail server, a third party application using J2EE Connector Architecture or proprietary APIs. In a lot of cases the application you need to connect to is not

(Steve Callan) In this second article about Oracle on Windows, we will cover several more areas of interest shared by Oracle and Windows. Using Oracle on Windows is, in many ways, much simpler than using a UNIX variant as the underlying operating system.

(Rick Cook) Typically the world of databases is divided into transactional databases, which are characterized by many access and relatively simple record structures, and analytical databases with much more complex record structures and relatively fewer accesses. Obviously the kind of database has im

(Amar Kumar Padhi) The Mutating table error is a well-known problem encountered in development; most developers have come across this error.

(Devanshi Parikh) System generated (redundant) check constraints can really drain the performance of a database. But sometimes, such as when using third party tools with Oracle, it becomes impossible to avoid them. I have developed a script, which is actually a UNIX Korn shell script, that retrives

(Daniel Liu) Remember when a 5GB database seemed huge? It wasn’t that long ago, says Daniel Liu, Senior Technical Consultant at First American Real Estate Solutions (RES). “Five years ago,” Liu recalls, “when I was talking to other Oracle professionals, I would say, ‘Well, my data warehouse is about