This past Wednesday in #oracle, I asked how one views what values are being used in a SQL statement with bind variables. hali led me to v$sql_bind_capture. We played with some joins to v$sql and v$session and all was well. I immediately recognized the blog-worthiness of the discussion and tagged the concept for later blogging.
Well hali beat me to it. From now on I'll just start blogging about things before I even have all of the information. For now you can read his post to see the usefulness of the v$ view. And leave comments about how he's a dirty Scandinavian thief!