t that the difference
> for
> > pl/sql tables is that they are now implemented as
> fully allocated arrays
> in
> > memory whether they were implemented in oracle 7
> and chained linked lists.
> >
> > Obviously this takes more memory but why do these
> 2 settings p
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 ORAC
using these settings?
Can I monitor 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
Ond
ting a limit somehow.
>>>
>>> Can somebody explain which limit this is and how is it composed or
>>> influenced (temp, sga ?) ?
>>>
>>> Is this reproducible on other systems / versions ?( Metalink post
> reports
>>> This also on early 8.1.x
nstance, just the problem user.
-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
can
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
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
INDEX BY BINARY_INTEGER;
> > assarray nAllotment_tabtyp;
> > assarray2 nAllotment_tabtyp;
> > assarray3 nAllotment_tabtyp;
> > uitleg varchar2(100);
> > begin
> > uitleg := 'start loop';
> > for i in 1..psize loop
> >
uitleg := 'insert i= ' || i;
> assarray(i) := i;
> /*
> uitleg := 'insert i2= ' || i;
> assarray2(i) := i;
> */
> end loop;
> EXCEPTION
> WHEN OTHERS THEN
> dbms_output.enable(2);
> dbms_output.put_line(' Exc
dbms_output.put_line(' Exception raised ' || 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_pol
> 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.
Anywa
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.
Yo
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
destruc
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
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=sub&p2=abs119 (Cary Milsap)
-Original Message-
Foote
Sent: 01 April 2003 14:34
To: Multiple recipients of list ORA
- 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
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
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"
>
>
>
> ---
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 h
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 memory
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
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 wa
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,
>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
PROTECTED]>
cc:
Subject: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 tha
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 pe
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
wel
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 fo
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 tha
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 m
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
syst
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