Excellent investigation.
Thanks for letting us know.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 19th
"Alberto Dell'Era" <alberto.dellera_at_gmail.com> wrote in message
news:4ef2fbf5.0411121552.1aa579dc_at_posting.google.com...
>
> I think it is the case. I've artificially stressed the library cache
> by running the following code (on an otherwise idle instance, 9.2.0.5)
> in another session, just before exiting sqlplus in the main session:
>
> declare
> l_cursor integer;
> begin
> for i in 1..100000000 loop
> l_cursor := dbms_sql.open_cursor;
> dbms_sql.parse (l_cursor,
> 'select '||i||' from dual',
> dbms_sql.native);
> dbms_sql.close_cursor (l_cursor);
> end loop;
> end;
> /
>
> And the STAT line was missing - so same behaviour seen for "alter
> system flush shared pool".
>
Received on Sat Nov 13 2004 - 02:23:45 CST
