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.

About these ads

One Comment

  1. Posted March 2, 2010 at 05:00 | Permalink | Reply

    may be set different level is good idea.
    eg: record bind variables for recursive calls
    record bind variables for non-recursive calss

One Trackback

  1. [...] been too long from a previous wish for Oracle. While reading a MOS updated articles (in a new HTML interface which looks nice, much [...]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 291 other followers