1-855-DBA-GURU

Back Up And Recover



Jagannath, Sushma “Back Up And Recover” Oracle Magazine.May/Jun 2008,:n-pag, Retrieved 02/26/2013 from http://www.oracle.com/technetwork/issue-archive/2008/08-may/o38ocp-084389.html Back Up And Recover TECHNOLOGY: OCP Back Up And Recover By Sushma Jagannath New backup and recovery features in Oracle Database 11g save time and data. A sound database backup and recovery plan is crucial to protecting data in the event of [...]

Performing Through Changes



Nanda, Arup “Perform Through Changes” Oracle Magazine Mar/Apr 2008:n.pag, Retrieved 02/26/2013 from http://www.oracle.com/technetwork/issue-archive/2008/08-mar/o28sqlperf-101752.html Performing Through Changes TECHNOLOGY: Testing Performing Through Changes By Arup Nanda Measure the impact of changes on SQL workload with SQL performance analyzer. Here is a not-so-uncommon scenario: a query is running slowly. Upon investigation, you determine the reason to be a [...]

Encrypting Tablespaces



Nanda, Arup. “Encrypting Tablespaces”Oracle Magazine.” Jan/Feb 2009:n.pag, Retrieved 02/24/2013 from http://www.oracle.com/technetwork/issue-archive/2009/09-jan/o19tte-086996.html Encrypting_Tablespaces TECHNOLOGY: Security Encrypting Tablespaces By Arup Nanda Encrypt tablespaces transparently—without affecting performance. In an era when data security is critical in almost every type of business, databases are particularly important. This is where the organization’s crown jewels live—credit card numbers, Social Security information, [...]

More New PL/SQL Features



Jagannath, Sushma” More New PL/SQL Features” Oracle Magazine. May/Jun 2009:n-pag, Retrieved from http://www.oracle.com/technetwork/issue-archive/2009/09-may/o39ocp-087552.html More_New_PLSQL_Features More New PL/SQL Features By Sushma Jagannath Improve performance in Oracle Database 11g with new PL/SQL features. Oracle Database 11g introduced several new PL/SQL features and tools that help you improve application performance. Continuing the discussion of new PL/SQL features from [...]

Understanding Parallel Execution Part 2



Geist, Randolf.” Understanding Parallel Execution Part 2″ Oracle Magazine. Nov/Dec.2012:n.pag, Retieved 02/17/2013 from http://www.oracle.com/technetwork/articles/database-performance/geist-parallel-execution-2-1872405.html Understanding_Parallel_Execution_Part_2 Understanding Parallel Execution – Part 2 by Randolf Geist Maximizing the performance of the Parallel Execution feature in Oracle Database Enterprise Edition November 2012 Read Part 1 Read Part 2 In order to get the most out of Parallel Execution, [...]

Understanding Parallel Execution Part 1



Geist, Randolf.” Understanding Parallel Execution Part 1″ Oracle Magazine. Nov/Dec.2012:n.pag, Retieved 02/17/2013 from http://www.oracle.com/technetwork/articles/database-performance/geist-parallel-execution-1-1872400.html Understanding_Parallel_Execution_Part_1 Understanding Parallel Execution – Part 1 by Randolf Geist Maximizing the performance of the Parallel Execution feature in Oracle Database Enterprise Edition November 2012 Read Part 1 Read Part 2 Oracle Database Enterprise Edition includes the powerful Parallel Execution feature [...]

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

Building On Storage



Nanda, Arup. “Building on Storage” Oracle Magazine.  Sept./Oct. 2010: n.pag, Retrieved 02/14/2013  from http://www.oracle.com/technetwork/issue-archive/2010/10-sep/o50storage-165476.html Building_On_Storage TECHNOLOGY: Storage As Published In September/October 2010 Building on Storage By Arup Nanda Create sophisticated, feature-rich clustered file systems on Oracle Automatic Storage Management disk groups. John, the DBA at ACME Corporation, gets a unique visit from Maureen, the business lead [...]

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