The New Master

Jagannath, Sushma and Bhandi, Narayan. “The New Master” Oracle Magazine. Nov./Dec. 2010: n.pag, Retrieved 9/12/12 from http://www.oracle.com: http://www.oracle.com/technetwork/issue-archive/2010/10-nov/o60ocp-176067.html TECHNOLOGY: Inside OCP The_New_Master The New Master By Sushma Jagannath and Narayan Bhandi Introducing the Oracle Certified Master credential for Oracle Database 11g The Oracle Certified Master credential is designed for Oracle Certified Professionals with advanced training and at [...]

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 [...]

DBA 101

Theriault, Marlene, Carmichael, Rachel.  Date:  Unknown.  Retreived 7/19/12. This paper provides a refresher course on Database administration and specific Oracle functions. DBA 101  

Oracle Cheat Sheet

Here are some useful commands to have on hand: To start a session as sysdba: sqlplus sys@tnsname as sysdba; To start a sysdba session under Windows (9iAS): sqlplus “/as sysdba” To list all tables in current schema: SELECT table_name FROM user_tables; or, all tables current user has access to: SELECT table_name FROM all_tables; To list [...]