Oracle introduced plan stability in form of Outlines in version 8i. However I have always been intrigued as to how to force a hint to a query using outline. This is particularly useful for Apps DBA, a...
Comments(1) - 05/18/2007 - 100% Relevant
Many times as DBAs or sometimes developer we need to fix a performance issue and mostly the fix is adding hint/s to the sql.
There are two options to put a hint:
1. Put the hint in the sql itself and ...
Comments(2) - 12/23/2006 - 100% Relevant
It was one of those intriguing days when for almost 2-3 days users/developers/managers has been bugging me for “possible” slowness in our EPR instance. Ofcourse I checked everything: no lo...
Comments(0) - 04/24/2008 - 100% Relevant
I have been asked this questions many times. Shoud we use fnd_stats or should we use dbms_stats in 11i (or release 12). Most of the Apps DBAs you will face will say use fnd_stats. In fact Oracle also ...
Comments(0) - 04/04/2008 - 100% Relevant
Apps Users: Do you recognize this key sequence?
alt-v r enter alt-r alt-r alt-r alt-r alt-r ...
That's me waiting for concurrent requests to complete ... or worse ... to start!
Are you, your Develop...
Comments(0) - 03/12/2008 - 100% Relevant
Apps Users: Do you recognize this key sequence?
alt-v r enter alt-r alt-r alt-r alt-r alt-r ...
That's me waiting for concurrent requests to complete ... or worse ... to start!
Are you, your Develop...
Comments(0) - 03/12/2008 - 100% Relevant
Sunday 21 September 2008 at Oracle Open World, I had the opportunity to present my method "GAPP" once more (HOTSOS 2008 and Planboard may 2008). This time I also mentioned how the method can be used w...
Comments(0) - 09/29/2008 - 100% Relevant
This is the tenth of 12 posts about the principles of agile software development. Purpose is to go back to the start of the agile manifesto (http://agilemanifesto.org/principles.html) and discuss the ...
Comments(0) - 08/03/2009 - 100% Relevant
I've recently published a new Oracle whitepaper that compares combinations of browsers with JInitiator and the native Sun Java plug-in (JRE) to determine which is best for low-specification clients. ...
Comments(0) - 11/26/2007 - 61% Relevant
It's said that death and taxes are the only certainties. I beg to differ. There's at least one other for IT professionals: regardless of the amount of network bandwidth you've dedicated to E-Busine...
Comments(0) - 12/11/2007 - 61% Relevant