1-855-DBA-GURU

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

How To Implement A Big Data System



Dijcks, Jean-Pierre.” How To Implement A Big Data System” Oracle Magazine. Jan 2012:n.pag, Retrieved 02/20/2013 from http://www.oracle.com/technetwork/articles/bigdata/implementing-bigdata-1502704.html How_To_Implement_A_Big_Data_System How to Implement a Big Data System by Jean-Pierre Dijcks Understanding a big data infrastructure by looking at a typical use case. Published January 2012 I often get asked about “big data,” and more often than not [...]

Preprocess External Tables



Nana, Arup.”Preprocess External Tables” Oracle Magazine. Mar/Apr.2011:n-pag, Retrieved 02/20/2013 from http://www.oracle.com/technetwork/issue-archive/2011/11-mar/o21nanda-312277.html Preprocess_External_Tables TECHNOLOGY: Oracle Exadata As Published In March/April 2011 Preprocess External Tables By Arup Nanda Use inline preprocessing on external tables to simplify extract, transform, and load operations. External tables, available since Oracle9I Database, enable you to view a text file as if it [...]

Cube Development For Beginners



Vasiliev, Yuli “Cube Development For Beginners” Oracle Magazine. Apr 2011:n-pag, Retieved 02/20/2013 from http://www.oracle.com/technetwork/articles/bi/cube-development-359587.html  Cube_Development_For_Beginners Cube Development for Beginners by Yuli Vasiliev Get the basics of data warehouse development using Oracle Warehouse Builder 11g. Published April 2011 From school, we know that although most math tasks have plain-English formulation, we still have to state an [...]

Intelligence And Identity



Rittman, Mark and Crisp, Joel” Intelligence And Identity” Oracle Magazine. Jan/Feb 2008:n.pag, Retrieved 02/20/2013 from http://www.oracle.com/technetwork/issue-archive/2008/08-jan/o18identity-087365.html Intelligence_And_Identity TECHNOLOGY: Identity Intelligence and Identity By Mark Rittman and Joel Crisp Integrating Oracle Business Intelligence and Oracle Identity Management When you are deploying Oracle Business Intelligence Enterprise Edition, how you handle identity management is as important as query [...]

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