Since DBA_HIST_SQLBIND seems to associate a bind variable with a particular sql_id of a snap_id, I am finding it hard to locate the correct query plan for a query that has multiple hash plan values. Or, if you have a better way of doing this, I am all ears. Thanks, charles schultz oracle dba aits - adsd university of illinois