From Oramosswiki
REM *************************************************************************
REM AUTHOR: Jeff Moss - essentially, a copy of a script by Christian Antognini
REM NAME: get_sql_join_filter.sql
REM
REM *************************************************************************
REM
REM Purpose:
REM This script shows information on join filter activities by active SQL.
REM The script was taken from a paper by Christian Antognini on Bloom Filters:
REM http://antognini.ch/papers/BloomFilters20080620.pdf
REM
REM Change History
REM
REM Date Author Description
REM =========== ================= ================================================
REM 28-MAR-2010 Jeff Moss Initial Version
REM
REM *************************************************************************
UNDEFINE qcsid
PROMPT
ACCEPT qcsid PROMPT 'Please enter Query Coordinator SID: '
SELECT filtered
, probed
, (probed - filtered) sent
FROM v$sql_join_Filter
WHERE qc_session_id = &qcsid
/
