I wish I had thought of that when I was dealing with not being able to implement a SQL Plan (10.1 bug) to fix a bind peek problem. And the shared DDL lock for the COMMENT shouldn't be a major issue in our environment, either. Thanks! Rich > > Even a simple "COMMENT ON TABLE <tablename> IS ' ' " will suffice > to invalidate SQLs against that table and force a re-parse at the > next execution. > > See http://hemantoracledba.blogspot.com/2008/07/bind-variable-peeking.html > -- //www.freelists.org/webpage/oracle-l