By Marcelo Castanho – This script displays the optimal size of rollback segments created in the database.

By Dawn Kawamoto and John Borland – Oracle’s contract fiasco with California has drawn a firestorm of criticism, but some of the more controversial aspects are all too familiar to technology officials in other government agencies.

By Richard Karpinski – Oracle Corp.’s lead in the relational database market slipped a bit last year, according to new research from IDC. But unlike a recent report from Gartner Dataquest, the IDC numbers showed Oracle maintaining a large lead over IBM and Microsoft in overall market share.

by Joe Lax – SQL Server and Oracle each have very different methods for maintaining data constancy when accessed by concurrent users. Oracle maintains a snapshot of the data, which prevents queries from hanging without stooping to “dirty reads.” Find out how it works.

By James Niccolai – ORACLE RELEASED AN upgrade to its Oracle9i database product to developers, adding new XML (Extensible Markup Language) capabilities and other enhancements that it hopes will help it recover ground lost to competitors.

By Ofer Harel – Here are two simple scripts to identify an object’s locks in the database. Whenever a user complains that there’s a session locked, I use these scripts to find out if there are object locks.

By Rich Schwerin – Most trade press coverage of Oracle9i Real Application Clusters (RAC) has focused on the dramatic improvements in the “abilities”—scalability, manageability, and availability—offered by the new technology. Another benefit that users are finding, however, is the ease of migration t

The technique makes a presentable conversion of the result from substraction between dates. For example, suppose we are looking for how many days, hours, minutes, etc. we spend between two dates, say at the beginning and ending the job/project/compaign. Oracle returns the result in days (such as 2.2

By riadh amari – This script modifies the structure of a snapshot for Oracle replication without dropping and recreating the snapshot. (It’s very useful but you have to be careful–it should be done by a DBA only.)

By Jay Lyman – Both Oracle and Borland are introducing versions of their software that will allow them to be significant players in the next big revenue-producing segment: Web services.Oracle’s new Oracle 9i Developer Suite includes a new JDeveloper Java development application for building