When facing high wait times, dropped sessions, and application lock-ups, the typical company response is to invest in expanded server hardware capacity and additional Oracle licenses, plus the accompanying installation and project management costs. DBAs utilizing performance management software have

(Robert Vollman) What is a number? The definition is one of the longest I’ve seen, but generally it refers to a quantity (or sum, total, count) of units. Quantities can be subjected to all sorts of calculations, such as addition, subtraction, multiplication and division.

(Doug Stuns, Tim Buterbaugh and Bob Bryla) The Oracle Recovery Manager (RMAN) is the recommended backup and recovery tool provided with the Oracle Database Server 10g software. RMAN was first introduced in Oracle 8, and Oracle has steadily made enhancements and improvements with each new release o

(Bill Cullen) At present we have five production servers, located at different locations in India. We would like to make them a centralized single server, and the process is going on. We are concentrating on connectivity issues and fall-back provisions. But being a Jr. Oracle DBA, I am curious, what

(Lewis Cunningham) I know rumors of Oracle having its own Linux distro have been floating around for a while. I even wrote about one such rumor back in June, Oracle: The biggest Linux vendor you’ve never heard of.

(Bob Watkins) In an earlier tip, I showed a way to process a table that stored multiple entities in the same table. Let’s take a step back. What should you think about when designing such a table?

(Brian Peasland) I want to know the contents of the redo logs. Do redo logs contain exact data inserted by users or instructions to redo transactions in case of failure? (R)

(Frank Zhou) This query inserts a space between characters in a string.

(Brian Keating) The Oracle shared server architecture provides a mechanism for a relatively large number of user connections to be established to a database with a relatively small amount of physical memory required. However, there are a number of potential issues with the shared server architecture

(Scott Ferguson) Oracle announced that it’s tweaking Enterprise Manager 10g’s application lifecycle management so as to allow IT professionals to monitor the entire database and pinpoint specific changes in the database environment, approve changes, and take “snapshots” of the environment.