Re: Find / Kill Sessions Running Duplicate SQL with Duplicate Bind Var. Values?
From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 19 Feb 2016 12:37:39 -0700
Message-Id: <C10BFF55-2918-4183-81D8-2C90C27FBAB0_at_centrexcc.com>
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.
Date: Fri, 19 Feb 2016 12:37:39 -0700
Message-Id: <C10BFF55-2918-4183-81D8-2C90C27FBAB0_at_centrexcc.com>
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_at_austinisd.org> wrote:
>
> I'm trying to craft a query using v$Session and v$SQL_Bind_Capture
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 19 2016 - 20:37:39 CET