The problem with that approach is the v$sql_bin_capture does not give you the
current bind values. They get captured only approximately every 15 minutes ( my
experience ). You may be able to get the peeked values out of the sql_monitor
v$ view(s) if you have the tuning pack.
On Feb 19, 2016, at 11:34 AM, Jack Applewhite <jack.applewhite@xxxxxxxxxxxxx>
wrote:
I'm trying to craft a query using v$Session and v$SQL_Bind_Capture