Managing History

Gennick, Jonathan. “Managing History” Oracle Magazine.  Jul/Aug.2008:n.pag, Retrieved 02/16/2013 from http://www.oracle.com/technetwork/issue-archive/2008/08-jul/o48totalrecall-092147.html Managing_History TECHNOLOGY: Total Recall Managing History By Jonathan Gennick Oracle Total Recall enables users to find, track, and use past and present information. What did you know, and when? U.S. government regulations such as the Sarbanes-Oxley Act and the Health Insurance Portability and Accountability [...]

Using Database Advisors

Jagannath, Sushma. “Using Database Advisors” Oracle Magazine. Jul/Aug.2008:npag, Retrieved 02/16/20013 from http://www.oracle.com/technetwork/issue-archive/2008/08-jul/o48ocp-088172.html Using_Database_Advisors TECHNOLOGY: OCP Using Database Advisors By Sushma Jagannath Get advice on key management challenges and improve performance in Oracle Database 11g. Advisors are powerful tools that provide specific advice on how to address key database management challenges, covering a wide range of [...]

Scripting Oracle RMAN Commands

Nanda, Arup.  “Scripting Oracle RMAN Commands”  Oracle Magazine.  Sept./Oct. 2009: n.pag,  Retrieved 8/30/12 from http://www.oracle.com: http://www.oracle.com/technetwork/issue-archive/2009/09-sep/o59recovery-085185.html Scripting_Oracle_RMAN_Commands TECHNOLOGY: Recovery Scripting Oracle RMAN Commands By Arup Nanda Learn how to create and automate scripts to execute common recovery tasks. Many DBAs have discovered how Oracle Recovery Manager (Oracle RMAN) can reliably back up, restore, and recover [...]

Optimizing Performance by Identifying Problem SQL

Robin Schumacher. “Optimizing Performance by Identifying Problem SQL” SELECT Journal  (3rd Qtr. 2004): 31-37. Optimizing Performance by Identifying Problem SQL OVERVIEW As a DBA, you need to have the right game plan in place for finding and fixing problem SQL code in your database. Fortunately, Oracle is better than most DBMSs at providing information in [...]

Oracle Performance Tuning: A Systematic Approach

Harrison, Guy (2007).  Oracle Performance Tuning:  A Systematic Approach.  Retrieved 8/27/12, from http://guyharrison.typepad.com: http://guyharrison.typepad.com/SystematicOracletuning.pdf Oracle Performance Tuning a Systematic Approach OVERVIEW A mission critical application system is experiencing unsatisfactory performance. As an experienced Oracle performance specialist, you are called in to diagnose the problem. You’re well versed in modern wait-based performance profiling oriented performance diagnostics [...]