Re: RE: pga_aggregate_target and a memory leak

2004-01-24 Thread Ryan
where did you hear that oracle 10g was written almost entirely outside the US? what critical problems have you had with 9i? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 23, 2004 10:19 PM On 01/23/2004 07:54:25 PM, Arnold, Sandra

Re: RE: pga_aggregate_target and a memory leak

2004-01-24 Thread Mladen Gogala
Personal communication. On 01/24/2004 06:44:24 AM, Ryan wrote: where did you hear that oracle 10g was written almost entirely outside the US? what critical problems have you had with 9i? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday,

Re: pga_aggregate_target and a memory leak

2004-01-23 Thread Ryan
what are the specs of that box? what does it cost? Ive never worked on something that big. how big is the database your working on? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:24 PM So, my intention to set P_A_T to

Re: pga_aggregate_target and a memory leak

2004-01-23 Thread Mladen Gogala
I read the paper about the adaptive memory and how it gets wasted, but with 10G SGA you can afford to be a bit wasteful. I would set workarea_size_policy to manual and then set sort_area_size to 32M and hash area size to 128M. With the memory sizes you mentioned, there shouldn't be any problems.

RE: pga_aggregate_target and a memory leak

2004-01-23 Thread Grabowy, Chris
Kirti, So is April 12th the latest date you heard for when 10g might be released?? Because it was the end of 2003, but I didn't know it had slipped all the way into April... -Original Message- Kirtikumar Deshpande Sent: Wednesday, January 21, 2004 7:24 PM To: Multiple recipients of list

RE: Re: pga_aggregate_target and a memory leak

2004-01-23 Thread Jeroen van Sluisdam
: pga_aggregate_target and a memory leak I am interested in the bug number. Currently am having memory problems that may be related to the pga. Sandra -Original Message- Sent: Thursday, January 22, 2004 5:09 PM To: Multiple recipients of list ORACLE-L Yes I have and still have a problem with pga

Re: RE: pga_aggregate_target and a memory leak

2004-01-23 Thread ryan.gaffuri
EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: pga_aggregate_target and a memory leak Kirti, So is April 12th the latest date you heard for when 10g might be released?? Because it was the end of 2003, but I didn't know it had slipped all the way into April

RE: RE: pga_aggregate_target and a memory leak

2004-01-23 Thread Arnold, Sandra
] Date: 2004/01/23 Fri PM 03:24:45 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: pga_aggregate_target and a memory leak Kirti, So is April 12th the latest date you heard for when 10g might be released?? Because it was the end of 2003, but I didn't know it had

Re: RE: pga_aggregate_target and a memory leak

2004-01-23 Thread Mladen Gogala
On 01/23/2004 07:54:25 PM, Arnold, Sandra wrote: We still have an 8.1.5 database as well as two 8.1.7.4 and one 9.2.04 databases. We are planning on upgrading our 8i databases this year. The rate we are going it probably will be two years before we get to 10g. Sandra That would be a very

Re: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Ryan
load has hit it. Paul this was on w2k server sp3, 9.2.0.4 std ed From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2004/01/21 Wed PM 02:44:31 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: pga_aggregate_target and a memory leak

Re: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Kirtikumar Deshpande
Paul, Most of my work is on HP-UX and AIX. I have yet to see any ORA-600 and memory leaks related to P_A_T. All databases that I work with are on 9.2.0.4, except just one running on 9.2.0.3. No memory leak there either. - Kirti --- Paul Drake [EMAIL PROTECTED] wrote: --- Kirtikumar

RE: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Arnold, Sandra
] Sent by: [EMAIL PROTECTED] 01/21/2004 06:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: pga_aggregate_target and a memory leak Setting P_A_T

RE: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread DENNIS WILLIAMS
: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2004/01/21 Wed PM 02:44:31 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: pga_aggregate_target and a memory leak Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti

RE: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Arnold, Sandra
: pga_aggregate_target and a memory leak Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti, you're back! Thanks. Found some slack time from routine DBA work! Must have finished the book. :) Not yet.. Its tough.. Re the PGA

RE: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Jeroen van Sluisdam
- Van: Ryan [mailto:[EMAIL PROTECTED] Verzonden: donderdag 22 januari 2004 11:05 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: Re: pga_aggregate_target and a memory leak Im not sure I see what the size of the PAT has to do with a memory leak. On metalink there is a laundry list

[oracle-l] Re: pga_aggregate_target and a memory leak

2004-01-22 Thread DENNIS WILLIAMS
: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2004/01/21 Wed PM 02:44:31 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: pga_aggregate_target and a memory leak Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti

RE: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Arnold, Sandra
2004 11:05 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: Re: pga_aggregate_target and a memory leak Im not sure I see what the size of the PAT has to do with a memory leak. On metalink there is a laundry list of PGA things that were supposedly causing memory leaks prior to 9.2.0.4. Are you

Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Tim Gorman
So, my intention to set P_A_T to 140G on a new datawarehouse is ill-advised? I'm not kidding, by the way. The Sun E15K belonging to the project I'm currently working on (purportedly) has 160G of RAM. It is still in the box, so I'm not believing anything until I type prtconf... I wasn't

RE: [oracle-l] Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Arnold, Sandra
it. Paul this was on w2k server sp3, 9.2.0.4 std ed From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2004/01/21 Wed PM 02:44:31 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: pga_aggregate_target and a memory leak Replies in line

Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Kirtikumar Deshpande
Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and 9.2.0.4 caused ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to 'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S (and S_A_R_S) worked, however, the

Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Jared . Still
ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: pga_aggregate_target and a memory leak Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and 9.2.0.4 caused ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to 'unlimited

Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Kirtikumar Deshpande
: Subject:Re: pga_aggregate_target and a memory leak Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and 9.2.0.4 caused ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to 'unlimited'. In a very limited testing, setting

Re: Re: pga_aggregate_target and a memory leak

2004-01-21 Thread ryan.gaffuri
kirti-- would you recommend avoiding pga_aggregate_target for now? From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2004/01/21 Wed PM 02:44:31 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: pga_aggregate_target and a memory leak Replies in line

Re: Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Kirtikumar Deshpande
:44:31 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: pga_aggregate_target and a memory leak Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti, you're back! Thanks. Found some slack time from routine DBA work! Must

Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Jonathan Lewis
A comment I picked up from Tom Kyte's Masterclass in Copenhagen last week was that there is an effective limit of 1GB to P_A_T - and although a single session is supposed to be allowed 5% of the P_A_T, you could get about 90MB. So there are some funny things going on in that area which still

Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Ryan
Im assuming its his wait interface book. Ill get it as soon as it comes out. Hopefully it will be as good as his other tuning book. Is the April 12th date firm? Now the bigger question: Will it be out before the 10G database?

Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Kirtikumar Deshpande
Thanks, Ryan. Yes, it is on OWI, for those who are new to OWI. Covers OWI from 8i to 10g. Co-authored with Richmond Shee and K.Gopalakrishnan. It will not be out till 10g goes production. Unfortunately, April 12th is not firm. 10g changes Regards, - Kirti --- Ryan [EMAIL PROTECTED]

Re: Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Paul Drake
: pga_aggregate_target and a memory leak Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti, you're back! Thanks. Found some slack time from routine DBA work! Must have finished the book. :) Not yet.. Its tough.. Re the PGA problems, what

pga_aggregate_target and a memory leak

2004-01-20 Thread ryan.gaffuri
One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on metalink is: 334427.995 doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know

Re: pga_aggregate_target and a memory leak

2004-01-20 Thread Stephane Faroult
[EMAIL PROTECTED] wrote: One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on metalink is: 334427.995 doesnt seem to apply to pga_aggregate_target. We

RE: pga_aggregate_target and a memory leak

2004-01-20 Thread Jeroen van Sluisdam
For further testing but will try do do so and report some more. Regards, Jeroen -Oorspronkelijk bericht- Van: Stephane Faroult [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 20 januari 2004 20:59 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: pga_aggregate_target and a memory leak