By Tuesday, Vince – ONE NIGHT last week, I was rushing to get home at a decent time when the head of our software support team slipped me a note suggesting that I look into an issue with data loss on one of our production database servers. I was tempted to just leave it until the next day, but I […]

By Mohsin Jamil Qureshi – Oracle 8i for Solaris is on two CDs. When you run universal installer, the first CD does not eject unless you close the installer. The following is a work-around for this problem.

By Richard Karpinski – Test vendor Mercury Interactive this week teamed with Oracle Corp. for a set of testing scripts and plans for Oracle’s enterprise applications suite. Oracle’s Test Starter Kit will help customers using Mercury Interactive’s enterprise testing software speed and improve

On June 15, 2002, Oracle sent an email to a select group of Oracle9i certification candidates that announced that all new Oracle9i certification candidates (those who have not yet taken an Oracle9i DBA exam) MUST take at least one “instructor-led class” from Oracle Education. Oracle representatives

By Guillaume HENON – Putting a database in archive log mode has a drawback: disk space usage. Moreover, the redolog switch is a costly action that causes additional disk and CPU overhead. The following script gives you in one shot the daily number of redolog switchse, archive log disk space needed,

By Margie Semilof – Oracle Corp. is a powerhouse when it comes to providing database software on Unix servers, and the Redwood Shores, Calif. company boasts a pretty good product for Microsoft Corp.’s Windows platform as well. But Microsoft’s own SQL Server can’t be counted out, particularly in smal

By Paul Krill – BMC SOFTWARE IS adding online database reorganization capabilities to the Space Expert component of its SmartDBA database management tools suite, looking to improve “business availability” for users.SmartDBA also is being integrated with BMC’s Patrol systems management platfo

This script will copy archived redo logs to a secondary standby destination for an NT implementation. This can be necessary if the standby exists on another server which is mapped.

(Krasen Paskalev) Extensive SQL parsing can become a serious problem for a heavily loaded Oracle instance. This is especially true if a SQL statement executed many times is also parsed many times. There are a number of standard techniques and guidelines, which help reduce unnecessary parsing. In som

By Alorie Gilbert – California’s doomed $95 million contract with Oracle may be officially canceled in about a week, officials said Friday, after two months of untangling the sprawling six-year deal that united scores of individual contracts under one megadeal.