Received: (qmail 4869 invoked from network); 11 Nov 2009 05:35:13 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 11 Nov 2009 05:35:10 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 61433CBA2ED; Wed, 11 Nov 2009 06:35:07 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id VCvuApEnze0g; Wed, 11 Nov 2009 06:35:07 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AF590CBA2BF; Wed, 11 Nov 2009 06:34:27 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 11 Nov 2009 06:33:46 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C74D1CBA281 for ; Wed, 11 Nov 2009 06:33:45 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id X-kVFaYvCnDZ for ; Wed, 11 Nov 2009 06:33:45 -0500 (EST) Received: from mail-vw0-f179.google.com (mail-vw0-f179.google.com [209.85.212.179]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 81E51CBA26E for ; Wed, 11 Nov 2009 06:33:44 -0500 (EST) Received: by vws9 with SMTP id 9so274872vws.20 for ; Wed, 11 Nov 2009 03:33:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:from:date:message-id :subject:to:content-type; bh=bUZMTKFlthu1/LpQ35l05hqY/1mk23F5wr2B964Jq40=; b=XEGl+EO273gEpiEtWPnH44iL3Z72E010HWPzXpJWdGWIJe6XFoICdBueJh2l1yrVjE nV/V0IkHfFXwLOcSFOKuMaVkqASFCYKqjRjg3WHsbbAjFE1UFpRJVjSxe5Jfdfo7BFV6 jlxVE8YqlwZyS42aiKHCJPzRIV/YGSo1hUQzQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:from:date:message-id:subject:to:content-type; b=n+VKF/dRR2OGeHoVKJ+1UN1ettW24ZM0PN/SBm/nMLAis8CQDm+8NM7IOwA77fZcAj 7R8n1AtD5AdjxewGTT4XIRtTiwUJyW3xJL99xKuum5k2h7euJYeAv/vJUgpRO22zoGjk UmGjguDYGiOaHUCNWAJ06gaGBFgV3/1ku/Eos= MIME-Version: 1.0 Received: by 10.220.126.144 with SMTP id c16mr1639940vcs.43.1257939224111; Wed, 11 Nov 2009 03:33:44 -0800 (PST) From: Amir Gheibi Date: Wed, 11 Nov 2009 19:33:24 +0800 Message-ID: Subject: Bind Variables vs Literals - To: ORACLE-L Content-Type: multipart/alternative; boundary=001636c930c89a2c4c047816cca7 X-archive-position: 22521 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: gheibia@gmail.com Precedence: normal Reply-to: gheibia@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --001636c930c89a2c4c047816cca7 Content-Type: text/plain; charset=ISO-8859-1 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? Regards, ~ Amir Gheibi --001636c930c89a2c4c047816cca7 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi Listers,

I have two questions.

- I know what using literals in SQL can do to the SGA. My question is actu= ally very simple. If literals are used in Stored Procedures, since procedur= es are loaded and compiled once when they are called, would that cause prob= lems as well?
- In the alert log, I noticed that there are lots of these messages: &= quot;Heap size 2122K exceeds notification threshold (2048K)". What doe= s that indicate?

Regards,
~ Amir Gheibi<= /div>
--001636c930c89a2c4c047816cca7-- -- http://www.freelists.org/webpage/oracle-l