Ask the Experts

Ask the Experts

• SQL string functions

  SQL expert Rudy Limeback explains how to use string functions.  Continue Reading

• What's the best tape backup strategy for 10g RAC?

  An Oracle user asks for the best tape backup strategy to use to backup the database and nodes for an RAC system.  Continue Reading

• How does an INSERT/UPDATE statement behave when executed compared to a SELECT statement?

  An Oracle user asks expert Brian Peasland: How does an INSERT/UPDATE statement behave when executed compared to a SELECT statement?  Continue Reading

• Can I resize the SYSTEM tablespace?

  An Oracle user asks if they can resize the SYSTEM tablespace.  Continue Reading

• Can I add multiple datafiles and make use of all the temporary datafiles at the same time?

  An Oracle user asks: Can I add multiple datafiles and make use of all the temporary datafiles at the same time?  Continue Reading

• Why am I getting an Oracle error when issuing the RECOVER DATABASE command?

  An Oracle user asks why they are getting an error when issuing the RECOVER DATABASE command.  Continue Reading

• Checkpoint vs. commit process

  An Oracle user asks if there is a relationship between CKPT and commit in Oracle.  Continue Reading

• The USING BACKUP CONTROLFILE clause in Oracle commands

  An Oracle user asks how a command with the USING BACKUP CONTROLFILE clause works.  Continue Reading

• How to use the OPatch Utility in Oracle

  Expert Brian Peasland explains how to use the OPatch Utility to find the CPU patch level applied to the particular database.  Continue Reading

• Backup and recovery of Oracle 10g with forgotten admin password

  An Oracle user asks how to take backup and recovery of Oracle 10g after forgetting the admin password.  Continue Reading

• Backup and recoveries of Oracle RAC 10gR2

  An Oracle user asks expert Brian Peasland a few questions about taking a backup and recovery for RAC 10gR2.  Continue Reading

• How to recover a control file

  An Oracle user asks how to recover their control file in the case of media failure.  Continue Reading

• Oracle DBA interview questions

  A SearchOracle.com user asks what questions they can expect in an interview for the position of a DBA.  Continue Reading

• SQL for hourly totals for the last 48 hours

  SQL expert Rudy Limeback explains to an Oracle user how to user asks how to generate datetimes or use left outer join to get hourly totals for the last 48 hours in SQL.  Continue Reading

• Normalizing a crosstab table

  SQL expert Rudy Limeback explains how to use a UNION query to normalize a crosstab table.  Continue Reading