by Jeremy Birkett – Here is a script to track archive log switching by the day and by the hour. Since most of the work on our databases take place between the 1st and 7th of the month, the script is limited by that. It shows you the number of switches by the hour and by the day. It’s very […]

By Brian Keating – This article assumes that the reader has at least a basic knowledge of the MTS architecture—how dispatchers, shared servers, request queues and response queues all interact. The primary focus of this article is to discuss a real-world case of implementing MTS on a production datab

By Louis Chua – While Oracle Corp. is committed to the open source movement and its standards, database code will remain proprietary because there will be difficulties in providing services if customers make alterations to the source code.

By Sara Cushman – Defending their new DBA certification requirement against critics who say it’s costly and unnecessary, Oracle described the move as part of a new strategy to ensure that only top-shelf candidates receive the company’s stamp of approval.

By Wylie Wong – Oracle entered a new software market Wednesday by announcing new e-mail, calendar and messaging software–a market dominated by Microsoft. The new “collaboration” software will allow businesses to manage e-mail, voice mail, schedules, as well as hold Web-based meetings, and wi

By Matt Hicks – Oracle Corp. is tackling ongoing criticism over its pricing and licensing practices by publishing a comprehensive online guide to its policies. The software maker next month will make available on its corporate Web site a Software Investment Guide that unifies its pricing and

by Eli Leiba – Microsoft Project 98 saves a network of defined activities, called a project, in an MPP file. You can save the whole project into an Oracle database and all 38 tables supporting the project definition will be created. Task_Dependencies is the table that represents all possible activit

SQLTools is a light-weight, robust tool for ORACLE database development that includes a text editor, SQL console and a couple of SQL utilities. Small enough to fit on a floppy disk and able to be used on a dial-up connection, SQLTools is a handy, portable, free program that works as fast as SQLPlus.

by Eric Doyle – Businesses will be able to search unstructured data held in anything from e-mail to Powerpoint slides, if an Oracle project achieves its aim.

This tip comes from Vijay Fernando, Oracle DBA (Data Warehousing), at Intel India Pvt. Ltd., in Bangalore, Karnataka, India.