Bind Variables vs Literals -

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?

Regards,
~ Amir Gheibi

--
http://www.freelists.org/webpage/oracle-l