1-855-DBA-GURU

Beginning Performance Tuning: Diagnose the Past



http://www.oracle.com/technetwork/issue-archive/2012/12-nov/o62dba-1741123.html Nanda, Arup. “Beginning Performance Tuning: Diagnose the Past” Oracle Magazine. Nov/Dec 2012: n.pag, Retrieved 9/18/13 from http://www.oracle.com/technetwork/issue-archive/2012/12-nov/o62dba-1741123.html TECHNOLOGY: Tuning Beginning Performance Tuning: Diagnose the Past By Arup Nanda Oracle ACE Director TECHNOLOGY: Tuning Beginning Performance Tuning: Diagnose the Past By Arup Nanda Oracle ACE Director Take the next step in diagnosing Oracle Database performance [...]

Plug into the Cloud with Oracle 12c



http://www.oracle.com/technetwork/database/plug-into-cloud-wp-12c-1896100.pdf

Oracle database 12c



The Oracle database 12c is now available for download at the Oracle web site.

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

More Ways To Flash Back



Jagannath, Sushma “More Ways To Flash Back” Oracle Magazine. Sep/Oct 2008:n.pag, Retrieved 02/25/2013 from http://www.oracle.com/technetwork/issue-archive/2008/08-sep/o58ocp-084350.html More Ways To Flash Back TECHNOLOGY: OCP More Ways to Flash Back By Sushma Jagannath Query history and recover from corruptions with Oracle Flashback technology. Oracle Flashback technology comprises a group of Oracle Database 11g features with which you can [...]

The New Master



Jagannath,Sushma and Bhandi,Narayan”Oracle Magazine”.Nov/Dec.2010:n-pag,Retieved 02/25/2013 from http://www.oracle.com/technetwork/issue-archive/2010/10-nov/o60ocp-176067.html The New Master TECHNOLOGY: Inside OCP As Published In November/December 2010 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 least three [...]

Baselines And Better Plans



Nanda, Arup.” Baselines And Better Plans” Oracle Magazine.Mar/Apr 2009:n-pag. Retrieved 02/24/2014 from http://www.oracle.com/technetwork/issue-archive/2009/09-mar/o29spm-092092.html Baselines_And_Better_Plans TECHNOLOGY: SQL Baselines and Better Plans By Arup Nanda Use SQL plan management in Oracle Database 11g to optimize execution plans. Have you ever been in a situation in which some database queries that used to behave well suddenly started performing [...]

On Deferring And Bulking Up



Kyte, Tom. “On Deferring and Bulking Up” Oracle Magazine. May/Jun 2011:n.pag, Retrieved 02/23/2013 from http://www.oracle.com/technetwork/issue-archive/2011/11-may/o31asktom-354139.html On_Defeffing_And_Bulking_Up TECHNOLOGY: Ask Tom As Published In May/June 2011 On Deferring and Bulking Up By Tom Kyte Our technologist prefers not to defer and works to increase bulk. In your column “On Constraints, Metadata, and Truth,” you wrote about how [...]

Get Your Information In Order



Caffrey, Melanie,” Get Your Information In Order” Oracle Magazine. Sept 2011:n.pag, Retrieved 02/23/2013 from http://www.oracle.com/technetwork/issue-archive/2011/11-sep/o51sql-453459.html Get_Your_In formation_In_Oorder Get Your Information in Order By Melanie Caffrey Part 1 in a series on the basics of the relational database and SQL Ask most seasoned professionals working with Oracle Database instances today what their chief complaint regarding performance [...]