RE: Limiting Oracle Memory

Or flush the rows to a real table when you hit a certain threshold?

Scott Shafer
San Antonio, TX
210-581-6217

"I hate the country, all those animals walking around un-cooked."

> -----Original Message-----
> From: Mohan, Ross [SMTP:MohanR_at_STARS-SMI.com]
> Sent: Thursday, June 21, 2001 4:03 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Limiting Oracle Memory
>
> so....a PL/SQL table?.....can you say more
> about the code in question without violating
> the cryptic inner sanctum of Dulcian?
>
> -----Original Message-----
> Sent: Thursday, June 21, 2001 3:55 PM
> To: Multiple recipients of list ORACLE-L
>
>
> DBMS_PIPE.down('Ross');,
> Thanks for not destroying me with your mental powers:) I am
> concerned
> about the size because it is completely hosing the machine. The worst
> part
> is, it is ONE connection that is doing it. No one else is connected to
> the
> db, but once this migration begins, POW, the memory goes to town and the
> machine eats it.
> So what I was hoping to do was set a limit on Oracle, let it have
> 600 megs
> and finish the job. Yes, it would probably be slower, but at least the
> server wouldn't die. Once it dies that's it, it has to be done all over
> again. I am going to talk to the developer and see if we can do this
> whole
> thing differently, unless I can figure out how to use ora_workingsetmax!!
> Thanks again:)
> Kev
>
> -----Original Message-----
> Sent: Thursday, June 21, 2001 2:10 PM
> To: Multiple recipients of list ORACLE-L
>
>
> :)
>
> a) I *like* NT, actually.
> b) that's "DBMS_PIPE.down('Ross'); to you, Buster"
> c) oracle, as a process, should include EVERYTHING
> on the box having to do w/Oracle with the
> exception of the listener. Including user
> connects, i believe....700MBytes is not at
> all large in that context....
>
> Do this: track user sessions and memory over time.
>
> if they grow commensurately...then there is no leak.
>
> if there are monotonic jumps in the latter w/o any in
> the former, you may well have a leak, and you'll need
> to move to the thread level to find it, likely.
>
> I am sure Jared and Mladen will be glad to help you
> with deep internal NT questions. <EG>
>
> hth
>
> Ross
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

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).