Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: statspack report shows low execute to parse%

Re: statspack report shows low execute to parse%

From: AnySQL (d.c.b.a) <anysql_at_gmail.com>
Date: 7 Sep 2005 06:03:04 -0700
Message-ID: <1126098184.635098.54470@g49g2000cwa.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US