or you could look the other way and probably use information from v$sql_plan ... not sure if it will provide everything you need, but might be a bit easier than running regex on complex queries. just watch out for multiple plans for same sql_id tho' ... this may help you cut down the list of sql_ids of interest to you. Raj
