If you are on an 11g database, you can ignore this post and just use the new ddl_lock_timeout parameter to accomplish what this post explains. "alter session set ddl_lock_timeout=60" - will effectively allow ddl statements to all wait 60 seconds before ... Continue Reading
Oracle
How to see your Oracle text output in something other than the browser!
Updated November 8, 2013 - I have verified this on Windows 7 Enterprise Edition. Have you ever wanted to see your Oracle output or log files open in your custom text editor instead of an IE window? I use Notepad++ (FREE) for text editing. Every time I open ... Continue Reading
How to find which responsibility can run a request in Oracle Apps.
If this article doesn't help you, consider dropping me a note with your concern. I have thousands of lines of code for hundreds of Oracle problems I've faced and would publish ones that people told me would be helpful. How many times have you been told by ... Continue Reading