Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: memory

RE: memory

From: Kevin Kostyszyn <kevin_at_dulcian.com>
Date: Wed, 25 Apr 2001 13:22:41 -0700
Message-ID: <F001.002F2541.20010425132048@fatcity.com>

Jeez it took all day for that to get out! No, it would just suck up 100 percent of both processors and then a gig of ram. Figured out what it was, one of the developers had sort of an infinite loop in his code. A beleive it was a procedure that kept calling itself, all fixed now. But what I don't understand is why it sucked up more memory than was allocated to the SGA?
Kev

-----Original Message-----

Sent: Wednesday, April 25, 2001 4:01 PM
To: Multiple recipients of list ORACLE-L

Kev,

What exactly do you mean by "all hell breaks loose."? Is there a specific error?

Ed Haskins
Oracle DBA
Verizon Wireless

-----Original Message-----

Sent: Wednesday, April 25, 2001 10:50 AM To: Multiple recipients of list ORACLE-L

Hi all,

        I have a developer running a procedure that is basically an insert statement. When he executes it as stand alone everything is fine, when he executes it from a package all hell breaks loose. Anyone have any ideas? Winnt/8.1.6ee... Also, why would Oracle Process suck up 950MB's of RAM when this procedure crashes? The SGA is supposed to be limited to about 550MB's? Thanks alot

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
kevin_at_dulcian.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Kostyszyn
  INET: kevin_at_dulcian.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Haskins, Ed
  INET: Ed.Haskins_at_VerizonWireless.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Kostyszyn
  INET: kevin_at_dulcian.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 25 2001 - 15:22:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US