How to kill performance with 16MB table

If you think 16MB tables are so small that can’t be root cause of significant performance problems with SELECT queries, then read about my today’s headache – a story of 16MB table worth something like 270 seconds of response time.

Oracle database features wish list – 1

Sometimes it just happens when you want some functionality built into Oracle database. I think I’ll put on the blog my “wish list” items to not forget about them. Today’s one: I want to have an option to reduce bind variables dumping in the SQL trace based on SQL depth level. For instance, to dump [...]

SQL_TRACE is deprecated, really

Just a quick note that SQL_TRACE parameter is no longer valid – it is deprecated as of Oracle 10g Release 2 in favor of DBMS_MONITOR subprograms. I realized that after start up warning: Though SQL_TRACE is still working in 11.2.0.1, it’s a good idea to start forgetting about it.