SQL in our 11gR2 database cannot be shared due to TOP_LEVEL_RPI_CURSOR

I can easily reproduce the problem.

Pls refer to the following for details :

cursor cannot be shared due to TOP_LEVEL_RPI_CURSOR

One sql in our 11gR2 database cannot be shared due to TOP_LEVEL_RPI_CURSOR.

I can easily reproduce the problem.

---session 1:

select username from ad.t5 where user_id=0;

---session 3: child number 0 was generated by session 1

col sql_text format a90

set linesize 150

select sql_id,sql_text,child_number from v$sql where sql_text like 'select username from ad.t5 where user_id=0%';

SQL_ID        SQL_TEXT                                                                                   CHILD_NUMBER

------------- ------------------------------------------------------------------------------------------ ------------

0jgj5vmnj0kr7 select username from ad.t5 where user_id=0                                                            0