(Steven Feuerstein) Oracle has introduced significant management automation features in its flagship database product and has described the new Oracle Database 10g release as “the self-managing database.” Given that achievement and direction, I thought it would make sense to talk about how to write

(Amar Kumar Padhi) The Mutating table error is a well-known problem encountered in development; most developers have come across this error. “ORA-04091: table is mutating, trigger / function may not see it”

(Robert Westervelt) While many companies think they’re being proactive with security, too many are addressing security at the application level rather than the database level, according Oracle security expert Arup Nanda. Nanda, 32, a Norwalk, Conn.-based DBA who runs Proligence, an Oracle consultanc

(Mark Rittman) If you’ve ever had to port a Microsoft SQL Server or Access database over to Oracle, you’ve probably come across the different way joins are put together for these databases. For example,you might come across a query looking like this; SELECT pub_name, title FROM publishers INNER J

(Dave Aldridge) On a regular OLTP system, the integrity of the data is generally supported in two ways – firstly by logic embedded in the application, and secondly by constraints placed on the logical structure of the database itself. The two may be complementary, as a designer may rely on the latte

(Amar Kumar Padhi) DECODE is considered the most powerful function in Oracle. Oracle 8i release introduced the CASE expression. The CASE expression can do all that DECODE does plus lot of other things including IF-THEN analysis, use of any comparison operator and checking multiple conditions, all in

(Robert Ware) The following lists the top 10 segments by V$SEGSTAT statistic name (since the instance was started). I usually employ this method to help determine which segments are responsible for most of the Logical I/O or Buffer Busy Waits on my system. Once I have this information, then I will s

(W. Fredrick Limp) Oracle began shipping the latest release of its database software, 10g, in mid-February 2004. Although Oracle is correctly touting its new manageability and GRID capabilities, it also has some significant new spatial capabilities. The following is a combined product review (like G

(David Baum) IT outsourcing has been garnering plenty of headlines this year, but the practice of offloading IT functions to outside firms has been an important part of the computer industry since the 1960s. According to Timothy Chou, president of Oracle On Demand, first-generation outsourcing, led

(Shahid Hafeez) This functionality to support fine-grained access control is based on dynamic predicates, where security rules are not embedded in views, but are acquired at the statement parse time, when the base table or view is referenced in a DML statement. A dynamic predicate for a table or