Hi
I am trying to capture the sqls from shared pool(v$sql) which does NOT use bind variables. Please let me know how to capture those sqls from the shared pool. Basically my question is how to specify the where condition? I am using Statspack. Is there any way I can capture from Statspack reports? Is there any other method?
Thanks in advance.