Re: regular expression and v$sql question
From: rjamya <rjamya_at_gmail.com>
Date: Wed, 29 Jun 2011 12:21:50 -0400
Message-ID: <BANLkTinQpOcP2ZF1tzRegkqcx1v1xPsaoQ_at_mail.gmail.com>
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.
Date: Wed, 29 Jun 2011 12:21:50 -0400
Message-ID: <BANLkTinQpOcP2ZF1tzRegkqcx1v1xPsaoQ_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 29 2011 - 11:21:50 CDT