(Michael D. Schmitz) The client has a number of plants generating energy to supply its customers. Each plant has a recommended maximum output capacity which leaves some reserve capacity in case the maximum is passed. Peak demand periods are usually somewhat predictable but do vary depending on w

(James Koopmann) It has been my observation that a lot of us lack the basic skills required to model the simplest of database objects. This article will explore some of the common mistakes and fixes to the breaking of 1NF.

(Alexander P. Pons and Hassan Aljifri) The objective of our work is to determine which mainstream object-relational database management systems (ORDMS) provide convenient facilities for the storage and manipulation of unstructured data objects. These objects, which consist of video, audio, photograp

(David Kalosi) The Vi tool, which is included in nearly every UNIX-like OS and runs on nearly 20 different platforms, is the easily the world’s most popular text editor, and Vim (or Vi iMproved), its enhanced, extended clone, is the one of the most popular text editors among Linux sysadmins. Given t

(Steve Callan) 1521. 1810. 2481. 7778. These are just a few of the port numbers Oracle uses in networking. Everyone knows 1521 is the typical port number used by a listener, but how sacrosanct is that? In other words, do other vendors know not to use 1521 for their applications because Oracle “owns”

(Paul Krill) Oracle anticipates a spur in upgrades to its grid-enabled Oracle Database 10g this June, when the first patch set will be released for the new system.

(Sudhindra Chillarige) Suppose you run a relatively long PL/SQL procedure that processes several rows, and you want to track its progress. The following procedure lets you see the total number of rows and the current row being processed, using client_info in the V$SESSION view.

(Steve Callan) This is the first of a two-part series about how you can become an Oracle DBA in today’s almost non-existent DBA job market. This article focuses on gateway jobs, which are easier to obtain and give you exposure to Oracle. The second article will focus on ways to learn Oracle and get

(Scott Stephens) In an Oracle database, DBAs often look for tablespaces that are about to run out of space and either add a new datafile or remove old data so applications don’t fail with space allocation errors. I thought it would be interesting to apply treemaps to this problem. (R)

(Wolfgang genser) Do you want to know what are the blockers and what are the waiters? This SQL script was tested on 8i and 9i but was originally test on 7.3.4. It is very helpful in determining what is holding a lock and what is waiting for it. (R)(script)