Re: regular expression and v$sql question
- From: rjamya <rjamya@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Jun 2011 12:21:50 -0400
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
- References:
- regular expression and v$sql question
- From: Dba DBA
- Re: regular expression and v$sql question
- From: Nigel Thomas
- regular expression and v$sql question
Other related posts:
- » regular expression and v$sql question - Dba DBA
- » Re: regular expression and v$sql question - Nigel Thomas
- » Re: regular expression and v$sql question - rjamya
- » Re: regular expression and v$sql question - Martin Berger
- » Re: regular expression and v$sql question - Dba DBA
- » Re: regular expression and v$sql question - Dba DBA
- » Re: regular expression and v$sql question - Saibabu Devabhaktuni