]
Subject: Re: RE: large pl/sql table sucking up all memory on a server
I think Unix Kernel parameter limit should help in this case. It can prevent
runaway process from consuming the whole machine resource.
In most unix, there is kernel parameter(or ulimit) that restrict the maximum
That works. I prefer thumb presses, they worked
for the Inquisition and they lasted 500 years...
dr
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
I think Ill get a taser and fry the next person who does it. :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
Assign the developer a profile that would do good.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an
Does he still have a job? :)
Was it one session or many of them? How many rows got bulk processed?
If it's one session that caused this, then it's either: vary badly designed,
there is memory leak, or the system is already short in memory!
Waleed
-Original Message-
Sent: Monday,
PROTECTED]
Subject: RE: large pl/sql table sucking up all memory on a server
Assign the developer a profile that would do good.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed
, Waleed [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 12:29:32 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: large pl/sql table sucking up all memory on a server
Does he still have a job? :)
Was it one session or many of them? How many rows got bulk processed?
If it's
Ryan,
First off, PL/SQL tables have nothing to do with the buffer cache. The
buffer cache is part of the SGA (shared memory) and is used to buffer
blocks of database datafiles. That's all that will ever be in the buffer
cache.
PL/SQL tables are memory constructs that are allocated from the PGA
of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: large pl/sql table sucking up all memory on a server
Ryan,
First off, PL/SQL tables have nothing to do with the buffer cache. The
buffer cache is part of the SGA (shared memory) and is used to buffer
blocks of database datafiles. That's all
developers out of the
same DBA account(not my call).
any parameter settings to limit the size of pl/sql tables?
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 12:14:24 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: large pl/sql table sucking up
: Re: RE: large pl/sql table sucking up all memory on a server
we dont have that level of granularity. everyone developers out of the
same DBA account(not my call).
any parameter settings to limit the size of pl/sql tables?
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/12
Subject: Re: RE: large pl/sql table sucking up all
memory on a server
we dont have that level of granularity. everyone
developers out of the
same DBA account(not my call).
any parameter settings to limit the size of
pl/sql tables?
From: Jamadagni, Rajendra
[EMAIL PROTECTED
This is probably old hat for you, but given it's Unix
(Sun) and it's a client process, wouldn't you be able
to use ulimit to stop memory allocation growing past a
certain size? The other thing I'd try is to limit memory
through the resource control in Oracle. But that is
highly version
PROTECTED]
Subject: RE: large pl/sql table sucking up all memory on a server
Assign the developer a profile that would do good.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed
13 matches
Mail list logo