From oracle-l-bounce@freelists.org Tue Aug 2 14:25:43 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j72JPgXE017956 for ; Tue, 2 Aug 2005 14:25:43 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j72JPbIP017930 for ; Tue, 2 Aug 2005 14:25:37 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B001D1DBB77; Tue, 2 Aug 2005 14:25:33 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26391-07; Tue, 2 Aug 2005 14:25:33 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 372A21DBBB7; Tue, 2 Aug 2005 14:25:33 -0500 (EST) From: ryan_gaffuri@comcast.net To: "Post, Ethan" , , Subject: RE: PL/SQL memory usage? Date: Tue, 02 Aug 2005 19:23:42 +0000 Message-Id: <080220051923.29657.42EFC83D0005EDBE000073D92205886360079D9A00000E09A1020E979D@comcast.net> X-Authenticated-Sender: cnlhbl9nYWZmdXJpQGNvbWNhc3QubmV0 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="NextPart_Webmail_9m3u9jl4l_29657_1123010622_0" X-archive-position: 23207 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ryan_gaffuri@comcast.net Precedence: normal Reply-To: ryan_gaffuri@comcast.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.0 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE,MIME_BOUND_NEXTPART, MIME_HTML_NO_CHARSET,NO_REAL_NAME autolearn=no version=2.63 --NextPart_Webmail_9m3u9jl4l_29657_1123010622_0 Content-Type: text/plain Content-Transfer-Encoding: 8bit from an oracle perspective, its still unbounded. i found it interesting because all the other memory usage is bounded by oracle. You can't have more than X space usage in the buffer cache, or the library cache etc... you can set that yourself. as far as arrays go, you can keep taking as much as the OS lets you. i would be very surprised if its taken from the buffer cache as the original poster suggested. I never saw docs on this. If its taken from anywhere, that would mean that when you hit the max amount for what your settings allow it then goes out and gets more memory. I don't know how Oracle manages this. -------------- Original message -------------- Not entirely true. Some OS version/levels have limits. I saw a situation recently at which it was impossible to exceed 500MB with out ORA- error. The tricky part was trying to figure out what array was using all the memory and where in the PLSQL the array was being filled. Would be nice to have a little event that traced these objects only. --NextPart_Webmail_9m3u9jl4l_29657_1123010622_0 Content-Type: text/html Content-Transfer-Encoding: 8bit
 
from an oracle perspective, its still unbounded. i found it interesting because all the other memory usage is bounded by oracle. You can't have more than X space usage in the buffer cache, or the library cache etc... you can set that yourself.
 
as far as arrays go, you can keep taking as much as the OS lets you.
 
i would be very surprised if its taken from the buffer cache as the original poster suggested. I never saw docs on this. If its taken from anywhere, that would mean that when you hit the max amount for what your settings allow it then goes out and gets more memory. I don't know how Oracle manages this.
-------------- Original message --------------
Not entirely true. Some OS version/levels have limits. I saw a situation recently at which it was impossible to exceed 500MB with out ORA- error. The tricky part was trying to figure out what array was using all the memory and where in the PLSQL the array was being filled. Would be nice to have a little event that traced these objects only.

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