Jonathan Lewis Oracle Heap Tables or SQL Server Clustered Indexes? Jonathan Lewis and Grant Fritchey Live Debate The following video and set of resources are from the webinar broadcast by Red Gate on 7 June 2012. Oracle... 30 April 2012 1 min read
Karen Morton How to Gather SQL Resource Consumption Metrics in Oracle The following video and set of resources are from the webinar broadcast by Red Gate on 8 May 2012. The... 26 April 2012 2 min read
Cary Millsap Real Developers DO use Tools This video is a recording from the webinar broadcast by Red Gate on 24th January 2012. You may’ve heard the... 19 April 2012 1 min read
Aman Sharma An Introduction to 11.2 RAC Server Pools Oracle RAC is designed to cater for Oracle specific applications and also non-oracle applications. These applications, both Oracle and non-Oracle,... 18 April 2012 19 min read
Syed Jaffar Hussain Migrating Oracle Single Instance to RAC This video is a recording from the webinar broadcast by Red Gate on 29th March 2012. Oracle Database administrators have... 17 April 2012 1 min read
Randolf Geist Oracle Cost-Based Optimizer Basics This video and set of resources is a follow up to the webinar broadcast by Red Gate on 11 Apr... 10 April 2012 2 min read
Martin Giffy DSouza Building Apex Plugins 101 Martin Giffy D’Souza has created some of the most popular plug-ins available on the APEX plug-in community page. He has... 28 March 2012 1 min read
Dominic Delmolino ORA-01801: Date Format is too Long for Internal Buffer Oracle 10.2.0.1 (I know, version out-of-date) on Windows 2003: The other day one of my stored procedures error’ed out with:... 27 March 2012 1 min read
Martin Giffy DSouza How APEX Processes Various Conditions and Validations I was recently teaching an Intro to APEX course and the students had some questions about what to put in... 26 March 2012 1 min read
David Njoku The 40 Most Common Oracle Errors I have been in this industry long enough to remember the bad old days, when every developer and DBA had... 12 March 2012 6 min read
Michelle Malcher Security in the Database is more than Just Granting Access Michelle Malcher (Oracle Ace Director and a representative on the Oracle Security Customer Advisor Council for the Independent Oracle User... 06 March 2012 1 min read
Syed Jaffar Hussain Upgrading to Oracle 11gR2 It has been a common practice and relatively a tough task for almost every individual Oracle DBA to decide whether... 05 March 2012 1 min read
Jerry Ireland Virtualization Overview Virtualization is a hot topic in the IT world. What is virtualization and why is it so popular? First... 02 March 2012 20 min read
Patrick Barel Caching Part 2 Never trust a computer you can’t throw out of a window. Steve Wozniak Deterministic Function Caching A function is considered... 23 February 2012 1 min read
Jonathan Lewis Session SQL From time to time a request for a query to “show the current SQL” for each session appears on the... 17 February 2012 1 min read
Dimitri Gielis E-Business Suite and APEX There is a series of posts on my blog where I focussed on getting information out of E-Business Suite and use it... 15 February 2012 1 min read
Randolf Geist Dynamic Sampling (I), an Introduction – Part 2 If you follow me on my blog you might wonder if I let you get away without an actual test... 08 February 2012 8 min read
Steve Harville Migrating databases to new storage This was a last minute request to move five databases on two servers from an old failing storage system to... 06 February 2012 2 min read
Randolf Geist Dynamic Sampling (I), an Introduction – Part 1 Welcome to my first post on AllThingsOracle.com! This is the initial part of a series highlighting different aspects of “Dynamic Sampling”.... 30 January 2012 7 min read
Alex Nuijten Comparing Schemas: Red Gate Schema Compare for Oracle This week I attended a webinar by Cary Millsap, organized by Red Gate. It was called “Real Developers DO use... 26 January 2012 2 min read
