Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: statspack report shows low execute to parse%
1, Using bind variable 2, Cache statement in you application 3, set the cursor_sharing parameter and the session_caches_cursors,cursor_space_for_time parameter may help.
Statspack some time may not display the right value.
anysql from china
http://www.anysql.net/en/
Received on Wed Sep 07 2005 - 08:03:04 CDT