Jan Leers

Author

Error Handling

Jan Leers on 06 December 2013 with 5 comments

Most programmers don’t like exceptions, but you should consider them as your closest friends. They are the ones that honestly say what is wrong with your program. We cannot foresee all possible problematic events, and even the best programmers write bugs. Exceptions There are three kinds of exceptions Internally defined: A system error, defined by Oracle, that occurs. Predefined: The… Continue Reading →

All Things Oracle Full Articles, Database Development, PL/SQL, Troubleshooting

Divide and conquer is what Oracle was thinking with this one. Table partitioning is about optimizing “medium selectivity queries”. The Oracle database has optimization techniques for high selectivity queries, with the use of indexes. If we need to process all data in a big table, we have to live with the fact it will take a while, but the engine… Continue Reading →

All Things Oracle Full Articles, Oracle Database, Performance Tuning

Code Instrumentation

Jan Leers on 04 December 2012 with 5 comments

Whenever we execute a procedure, it’s out of our hands. We expect it to do what it was designed to do, but what if it doesn’t? What if it takes a lot more time then expected? All kind of questions start to arise: Is it almost finished, should I wait just a few more minutes? Is it trapped in an… Continue Reading →

All Things Oracle Full Articles, Database Development, Performance Tuning, PL/SQL, Troubleshooting