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
Patrick Barel Invoker Rights Part 2 Kindness is the beginning of cruelty Frank Herbert Syntax If you check the syntax for the different program objects you... 25 January 2012 4 min read
Syed Jaffar Hussain An Easy Way to Obtain 10053 Trace I have just learnt a couple of new methods to obtain an Optimizer (10053) trace for any sql statement that... 23 January 2012 1 min read
