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

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

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

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

Smart Scans Meet Storage Indexes



Nanda, Arup.” Smart Scans Meet Storage Indexes” Oracle Magazine.May/Jun 2011:n.pag, Retrieved 02/21/2013 from http://www.oracle.com/technetwork/issue-archive/2011/11-may/o31exadata-354069.html Smart_Scans_Meet_Storage_Indexes TECHNOLOGY: Oracle Exadata As Published In May/June 2011 Smart Scans Meet Storage Indexes By Arup Nanda Understand how Oracle Exadata uses storage indexes to speed I/O. The Oracle Exadata Database Machine brings database performance to a whole new level, but [...]

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