Tim, I see lot of child cursors in my oracle 126.96.36.199 database.
SQL> select count(*)
2 from v$sql
3 where sql_id='91b43q7rdqwpd';
Here is the output of the above query ==> 207
the query has no bind variable and all values are hardcoded in the where clause. Is that the reason it caused these many
child cursors? any input? please...