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 only those variables which were used in top level calls only. It could be useful in case of queries with PL/SQL function calls with SQL in it, producing enormous amount of info in the trace file which you probably don’t want to see because you are interested in the “driving” bind variables only. Or in case of globally enabled tracing – again it’s possible that you probably don’t need bind variables from all executed statements and/or want to reduce generated trace files total size.