PM
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga workarea and ora-04030
I think what you've demonstrated is
that pl/sql tables are not limited by
pga-aggregate target, and that a pl/sql
table can grow until it has taken up all
the available memory on your machine.
I'd
on HPUX?
Regards,
Jeroen
-Oorspronkelijk bericht-
Van: Jonathan Lewis
[mailto:[EMAIL PROTECTED]
Verzonden: Saturday, January 10, 2004 6:54 PM
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga workarea and ora-04030
I think what you've demonstrated
specific memory usage with these setting and how should this
be done on HPUX?
Regards,
Jeroen
-Oorspronkelijk bericht-
Van: Jonathan Lewis [mailto:[EMAIL PROTECTED]
Verzonden: Saturday, January 10, 2004 6:54 PM
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga workarea and ora
PROTECTED]
Verzonden: dinsdag 6 januari 2004 16:49
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga workarea and ora-04030
The workarea_policy stuff does not apply
to things like pl/sql tables, only to tuneable
memory. Given that you don't have the
problem when you disable
' || uitleg );
end;
end;
-Oorspronkelijk bericht-
Van: Jonathan Lewis [mailto:[EMAIL PROTECTED]
Verzonden: dinsdag 6 januari 2004 16:49
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga workarea and ora-04030
The workarea_policy stuff does not apply
to things
In the UGA, I should think (which also means the
SGA if you are running MTS). It can't be in the
PGA (ignoring the fact that the UGA is in the PGA
for non-MTS) or you couldn't have global pl/sql
tables that persist across database calls.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
I have seen people bulk collect into pl/sql tables so much data that you
cannot even connect to the server. So I'm assuming that ones the UGA fills
up, Oracle will allocate whatever unused memory is left on the server for
pl/sql tables?
- Original Message -
To: Multiple recipients of list
.
-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]
Sent: Sat 1/10/2004 4:34 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:Re: pga workarea and ora-04030
I have seen people bulk collect into pl/sql tables so much data that you
cannot even connect to the server
PROTECTED]
Verzonden: dinsdag 6 januari 2004 16:49
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga workarea and ora-04030
The workarea_policy stuff does not apply
to things like pl/sql tables, only to tuneable
memory. Given that you don't have the
problem when you disable p_a_t
;
-Oorspronkelijk bericht-
Van: Jonathan Lewis [mailto:[EMAIL PROTECTED]
Verzonden: dinsdag 6 januari 2004 16:49
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga workarea and ora-04030
The workarea_policy stuff does not apply
to things like pl/sql tables, only to tuneable
memory. Given
The workarea_policy stuff does not apply
to things like pl/sql tables, only to tuneable
memory. Given that you don't have the
problem when you disable p_a_t and w_p,
it may be that there is some buggy event
occurring where the workarea_policy code
is being infringed by an abuse of pga memory.
When I increase the pga_aggregate_target to 2Gb and the
smm_max_size also the program fails around the following numbers from
pgastat
I'm not advocating fiddling with hidden parameters here, but there is one
more parameter which limits PGA usage, it's _pga_max_size and defaults to
200M.
Title: Message
Hi
Syed
Do you have Enterprise manager installed on your machine...
What is the version. You can install Enterprise Version Client on your Desktop
and connect your database so that you can see the PGA size and
all.
Let me know if u have doubt or
difficulties
select * from v$process where addr in (select paddr from v$session where
sid='');
With Regards,
Manoj Kumar Jha
A transcendentalist engaged in auspicious activities does not meet with
Get GAJA's Book .. Oracle 101 Perf. Tunning.. U will find a Lot there ..
HTH
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
-Original Message-
C.S.Venkata Subramanian
Sent: Tuesday, April 01, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
where can one find the
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 4:03 PM
where can one find the other myths about oracle?
Venkat
--
A number of Oracle Press books ...
Cheers
Richard
--
Please see the official ORACLE-L FAQ:
http://www.quest-pipelines.com/newsletter-v3/0302_F.htm (Gaja Krishna
Vaidyanatha)
www.jlcomp.demon.co.uk/myths.html (Jonathan Lewis)
http://www.orapub.com/cgi/genesis.cgi?p1=subp2=abs119 (Cary Milsap)
-Original Message-
Foote
Sent: 01 April 2003 14:34
To: Multiple recipients of list
Arvind,
When u set the sort_area_size for a database, it will allocate that much
memory PER USER
for any sort operation being performed on the database. In practice, it
means that if u allocate
too high a value for the sort_area_size and multiple users are performing
multiple sorts, the Unix
Your PGA directly Affects the Amt memory the OS has to shell out for
Oracle Server Process so Increasing the Sort_Area_Size does not have
immd effect but if your users are going to do a sort then your PGA can
grow to a Maximum of Sort_Area_Size before being pulled down to the Temp
Segments.
Just
Oracle Myth #1745
When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database
--- SARKAR, Samir
[EMAIL PROTECTED] wrote:
Arvind,
When u set the sort_area_size for a database, it
will allocate that much
So whats the reality, Connor ?? I thought it was the reverse which was the
myth i.e. it
is often misunderstood as the total memory available to the database user as
a whole for sort
operations.I believe the reality is that the sort area size is the size
allocated by Oracle
per user process
Hello Arvind,
This is sort of an open ended question. In general this parameter
controls how much memory is allocated on a per session basis for in
memory sorts. Sorts that require more memory than this will sort on the
disk with a performance penalty. If you have the memory you should stay
If it is a myth where do we find the truth?
Allan
-Original Message-
Sent: Monday, March 31, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L
Oracle Myth #1745
When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being
:RE: PGA
If it is a myth where do we find the truth?
Allan
-Original Message-
Sent: Monday, March 31, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L
Oracle Myth #1745
When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
From the Manual:
SORT_AREA_SIZE specifies in bytes the maximum amount of memory Oracle will use
for a sort. Afterthe sort is complete, but before the rows are returned,
Oracle releases memory down to the size specified by the
SORT_AREA_RETAINED_SIZE parameter. After the
IIRC, even this release down to S_A_R_S stuff was a myth in earlier
releases. The MALLOC call never really returned the memory to the OS. Of
course, I don't have any earlier releases to prove it now! :)
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no,
Pate,
Controlling duhvelopers is not like herding cats, it's more like giving them a
bath!! Heavy body armor required!
Dick Goulet
-Original Message-
Sent: Monday, March 31, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
IIRC, even this release down to S_A_R_S stuff
Did you ever see the EDS commercial on herding cats? Damn, it was funny! I
still have it on my laptop, but I won't send it to the list (over 1 Mb is a
bit much to send).
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much harder than
S_A_R_S stuff? Please, be careful with those abbreviations.
-Original Message-
Sent: Monday, March 31, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
IIRC, even this release down to S_A_R_S stuff was a myth in earlier
releases. The MALLOC call never really returned the
Pete,
Then send it privately: [EMAIL PROTECTED] No I have not seen it, but I still
believe it's more like giving a cat a bath.
Dick Goulet
-Original Message-
Sent: Monday, March 31, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
Did you ever see the EDS commercial on
where can one find the other myths about oracle?
Venkat
--
On Mon, 31 Mar 2003 06:18:35
Connor McDonald wrote:
Oracle Myth #1745
When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database
--- SARKAR,
Presumably they affect some of the required memory
structures - shouldn't be too hard to work out I would
have thought. Just measure the pga usage via sesstat
and play with the parameters to see the impact
hth
connor
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
-
32 matches
Mail list logo
