Bind Variables vs Literals -

From: Amir Gheibi <>
Date: Wed, 11 Nov 2009 19:33:24 +0800
Message-ID: <>

Hi Listers,

I have two questions.

  • I know what using literals in SQL can do to the SGA. My question is actually very simple. If literals are used in Stored Procedures, since procedures are loaded and compiled once when they are called, would that cause problems as well?
  • In the alert log, I noticed that there are lots of these messages: "Heap size 2122K exceeds notification threshold (2048K)". What does that indicate?

~ Amir Gheibi

Received on Wed Nov 11 2009 - 05:33:24 CST

Original text of this message