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

Managing Oracle 12c CDB and PDB – Part 2 – Plugging and Unpluging PDB’s

Managing Oracle 12c CDB and PDB – Part 2 – Plugging and Unpluging PDB’s Posted by Abdul Aziz | filed in Oracle 12c   One of the main features of the Oracle Database 12c is the portable nature of the pluggable databases (PDBs). You can easily unplug a PDB from a CDB and then plug [...]

Oracle database 12c

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

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

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

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

Accelerating Data Warehouses

Vlamis, Dan” Accelerating Data Warehouses” Oracle Magazine. May/June.2008:n.pag, Retrieved 02/18/2013 from http://www.oracle.com/technetwork/issue-archive/2008/08-may/o38olap-085800.html Accelerating_Data_Warehouses TECHNOLOGY: Data Warehouse Accelerating Data Warehouses By Dan Vlamis Oracle OLAP 11g brings high-performance data warehouse features to Oracle Database 11g. An option of Oracle Database 11g Enterprise Edition, Oracle OLAP 11g is a full-featured online analytical processing engine. Because Oracle OLAP [...]

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