Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

How does one tie DBA_HIST_SQLBIND to DBA_HIST_SQL_PLAN?

Schultz, Charles

2006-05-12


How does one tie DBA_HIST_SQLBIND to DBA_HIST_SQL_PLAN?

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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.