Tim, I see lot of child cursors in my oracle 18.104.22.168 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...