Jonathan Lewis Compression in Oracle – part 5: Costs of Index Compression In the previous article in this series we looked at index compression, and the way in which Oracle stored index... 27 February 2013 13 min read
Jonathan Lewis Compression in Oracle – part 4: Basic Index Compression In the first three parts (Part 1: Basic Table Compression, Part 2: Read-Only Data, Part 3: OLTP Compression) of this... 13 February 2013 13 min read
Tim Gorman What makes a DBA? What skills set the database administrator (DBA) apart from other technologists? Of the many responsibilities laid upon a DBA, which... 07 February 2013 3 min read
Jonathan Lewis Compression in Oracle – Part 3: OLTP Compression In part two of this series we examined the effect of updates on compressed data when using basic compression, and... 31 January 2013 14 min read
Neil Anderson Jonathan Lewis helps to optimize Red Gate’s Oracle tools Speed, performance, optimization: time is of the essence when you’re waiting for an operation to complete. Our Oracle tools — Schema... 28 January 2013 7 min read
Jonathan Lewis Compression in Oracle – Part 2: Read-Only Data In part one of this series we saw that the mechanics of basic table compression came in to play only... 24 January 2013 13 min read
Randolf Geist HAVING Cardinality When performing aggregate GROUP BY operations an additional filter on the aggregates can be applied using the HAVING clause. Usually aggregates are one of... 21 January 2013 2 min read
Jonathan Lewis Compression in Oracle – Part 1: Basic Table Compression In this short series on compression in Oracle, we will be looking at the various types of compression used by... 15 January 2013 12 min read
Patrick Barel Custom Authentication in APEX Trust is a great force multiplier. – Tom Ridge When you build a web application you have two choices for... 09 January 2013 6 min read
Steve Harville Automating and delegating datapump imports with PL/SQL We recently bought another company and we are in the process of integrating our systems with theirs. One requirement was... 20 December 2012 2 min read
Marco Gralike Solving VMware network problems on Linux VMware guests When you use VMware Server software to move or clone VMware Linux guest machines, you are asked by the VMware... 19 December 2012 1 min read
Kellyn Pot'Vin-Gorman Enterprise Manager Command Line Interface for EM12c This video is a follow up to the webinar broadcast by Red Gate on 12 December 2012. Please leave a... 14 December 2012 2 min read
Wissem El Khlifi 11g Sql Plan Management I have recently published an article about SQL Plan Management and some of its capabilities in 11g version of the... 10 December 2012 1 min read
Jonathan Lewis Statistics in Oracle and SQL Server This video is a follow up to the webinar broadcast by Red Gate on 12 December 2012. Please leave a... 10 December 2012 2 min read
Jan Leers Code Instrumentation Whenever we execute a procedure, it’s out of our hands. We expect it to do what it was designed to... 04 December 2012 5 min read
Gert Poel Generating XML from SQL and PL/SQL – Part 2 In this second part I’ll show you how you can generate XML from table data in PL/SQL. … 29 November 2012 10 min read
Patrick Barel Edition Based Redefinition – Part 1 One of the ‘killer’ features of the Oracle Database version 11g Release 2 is probably Edition Based Redefinition. This functionality... 25 October 2012 7 min read
Jonathan Lewis Temporary Tables in Oracle and SQL Server This video is a follow up to the webinar broadcast by Red Gate on 13th September 2012. Please leave a... 15 October 2012 1 min read
Satishbabu Gunukula Manually Convert Oracle Single Instance to RAC Step-by-step guide to manually converting an Oracle single instance database to Real Application Clusters (RAC). Covers redo log creation, cluster... 10 October 2012 13 min read
Wissem El Khlifi Data Guard Physical Standby Database Best Practices – Part II In this second part we will setup the standby database and enable Fast Start Fail Over.… 27 September 2012 9 min read
