Re: PLSQL CPU consumption

  • From: "David Sharples" <davidsharples@xxxxxxxxx>
  • To: ade.turner@xxxxxxxxx
  • Date: Mon, 25 Sep 2006 20:33:11 +0100

what are you biggest wait  / timed events

On 25/09/06, Adrian <ade.turner@xxxxxxxxx> wrote: 

 All,



Platform: V440, Solaris 8, 9206 Enterprise Edition.



Related parameters:

      Cursor_sharing=similar

      Cursor_space_for_time=true

      Query_rewrite_enabled=true

      Shared_pool_size=800M



I'm on a site whereby the plsql guys have won the war and the java guys
call PLSQL packages which do nothing but return open ref cursors for
fetching; however the bind variable message did not get across so
cursor_sharing is set to SIMILAR.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2006