By Cory Brooks – When asked how many transactions per second were happening on each system, I realized that a quick approximation could be derived from the number of SCN changes per second as recorded in the logs, so I wrote the following code.

By Bryan Atsatt and Debu Panda – This article looks at how class loading works, both in a standard J2SE environment and in more-complex J2EE environments such as OC4J.

by Vadim Tropashko – Description: An index range scan is routinely used when querying a name by a name prefix. It is also not unusual to query by a postfix:

Apps: compiling libraries, debugging export, check env vars. Unix prompt. Forms: format mask, ora_nls. 9iAS services for Forms and Reports.

By Gaurav Sharan Gupta – In Oracle we sometimes come across poor performance in our databases. Though there may be a number of reasons for performance degradation, we can prevent some issues by properly designing and/or diagnosing the database. Row Migration (RM) and Row Chaining (RC) are two potent

By Roger Schrag – This document will walk you through the steps of installing Oracle 8i Enterprise Edition release 3 (Oracle version 8.1.7) or release 2 (8.1.6) in a Sun Solaris SPARC environment. Everything you read in this document is hands on, roll-up-your-sleeves-and-get-busy material for Oracle

By Vance McCarthy – Perl can be one of the Oracle DBA’s most powerful tools, thanks to its power as a solution for transforming and gluing data together. That’s the premise of O’Reilly’s latest title, “Perl for Oracle DBAs — Making Life Easier for the Oracle Database Administrators”

by Christopher Chelladurai – The following script lists all the tablespace names in the database with their type (whether permanent or temporary), extent management (whether local or dictionary), sizes, and status (online, offline, read-only). This script should be run by a DBA user in SQL*Plus.

The complexity of how information is stored and where it is retrieved from is hidden from the casual user who queries a database. But if you plan on administering Oracle, you need to become familiar with how Oracle handles both resources. In this article, Joe Lax discusses two basic, but important,

By Mark Gladstone – In the wake of the botched Oracle contract, Gov. Gray Davis on Monday approved legislation cracking down on conflicts of interest in state technology purchases.