Todd > If optimizer_secure_view_merging will only help on the parse, then I am > barking up the wrong tree and will need to find a better solution. optimizer_secure_view_merging should only avoid view merging in some specific cases where security is involved. Therefore the only impact on the execution I can imagine is related to different execution plans (because of the lack of view merging). Cheers, Chris -- //www.freelists.org/webpage/oracle-l