(Mark Brunelli) Open source software vendor EnterpriseDB Corp. kicked off the Collaborate ’06 conference today by unveiling new functionally designed to make it easier for Oracle users to switch to EnterpriseDB’s namesake PostgreSQL-based database management system. (R)

A statement executed a trigger or custom PL/SQL function. That trigger/function tried to modify or query a table that is currently being modified by the statement that fired the trigger/function.

This article discusses the performance and scaleability impact due to severe CPU and I/O bottlenecks in a very large database (over 20 terabytes). It describes the methodologies used to collect performance data in a production environment, and explains how to evaluate and analyze the memory, CPU, ne

(Mark Brunelli) The results of a new Independent Oracle Users Group (IOUG) member survey indicate that Linux will overtake Sun Microsystems’ Unix-based Solaris as the top operating system (OS) for Oracle database deployments in 2007, an IOUG official said in an interview. (R)

(Jon) Here are some quick and dirty examples for adding and subtracting days and months and finding the difference between dates in Oracle.

(Steven Chan) Earlier versions of AutoPatch (adpatch) would automatically check whether the prerequisites for the current patch were installed properly. An important change to the AutoPatch defaults was made in the Applications DBA Minipack 11i.AD.I.2 release: automatic checks for prerequisite pat

(Rick Greenwald, Robert Stackowiak and Jonathan Stern) Where do we start? One of the problems in comprehending a massive product such as the Oracle database is the difficulty of getting a good sense of how the product works without getting lost in the details of implementing specific solutions. This

A stored procedure or function can be created with no parameters, IN parameters, OUT parameters, or IN/OUT parameters. There can be many parameters per stored procedure or function.

(Tarry Singh) In part 9, we covered several topics such as Swap Space, Memory, Semaphores, File handles and Hangcheck-timer. A good thing about being familiar with all the components that make Oracle RAC work is that you, as a DBA, become more interested in the technologies involved in it, and that

(Martin Veitch) A UK security expert has called for change in Oracle’s security strategy, including the removal of the firm’s chief security officer.