| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ora-12500 on windows
Hi Paul,=20
Thanks for your reply and for the link. I am not using pga_aggregate_target any longer. It was a mess. Instead I am tweaking down sort_area_size. It's at 1MB right now.=20
The bottom line is we have all this memory, the loads want to run screaming parallel, and I need to find the right config to do so. =20
When sga_max_size is at or over 1800m, I get 12500's and failed sessions. =20
When the loads run under choose, hash joins begin and ora-4030's start happening. First_Rows takes care of this, but hashing is faster, and I do have memory to support it. I just have to config it correctly.
Choose + big sga_max_size =3D Monkey Hunting.
When I bring sga_max_size down and set first_rows, everything seems happy for the time being. However, it's going to change fast and I'll have to pursue VLM.=20
If you read note 225349.1 it states, "What the PAE switch allows you to do from the Oracle perspective is to increase the amount of memory that can be used for the Oracle Database Block Buffer Cache. It is important to note that this additional memory can ONLY be used by Oracle in the form of an increased value for DB_BLOCK_BUFFERS." This makes me wonder if it's even worth pursuing. My cache is only set around 50m or so. =20
Thoughts? I'll have to dig through the Microsoft link and links given on that page in more detail when I don't have people breathing down my neck. Hey, I may even learn something about Windows. =20
Thanks again, Paul
Lisa
-----Original Message-----
From: Paul Drake [mailto:discgolfdba_at_yahoo.com]=20
Sent: Wednesday, February 18, 2004 2:39 PM
To: oracle-l_at_freelists.org
Subject: RE: ora-12500 on windows
Lisa,
we use shared servers in 9.2 on w2k adv svr for a very specific usage condition: where a VPN only has certain ports open.
recently, a client site rebuilt a citrix server, and did not restore the old tnsnames.ora file.
as a result, instead of obtaining dedicated server processes, 1/3rd of their sessions from their citrix farm were accessing shared servers.
it was fatal (to the instance, not to me).
It will depend upon your environment, but parsing with shared servers being used is not viable. If the code is lightweight and does not parse, you have a chance.
shared servers use a longer code path, and critical resources (such as the library_cache latch or shared_pool latch) may experience greatly increased contention.
as far as large memory support,=20
http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;283037
"Large Memory Support Is Available in Windows 2000 and
Windows Server 2003"
the addition of /3GB (possibly /PAE) in the boot.ini should take care of it. you can verify that these were read properly in the registry, under boot options.
win32 does not support the use of prespawned
connections. I have not mucked with connection
pooling.
are you using pga_aggregate_target?
hth.
Pd
> -----Original Message-----
> From: Jeffrey Beckstrom
> [mailto:JBECKSTROM_at_gcrta.org]=3D20
> Sent: Wednesday, February 18, 2004 12:55 PM
> To: oracle-l_at_freelists.org; discgolfdba_at_yahoo.com
> Subject: Re: ora-12500 on windows
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20> > of mem was allocated to
> > I would suspect they should be close to each other
> > since currently mem usage is 1.1 g and vm size is
> > 1.2 g.
> > >>> tanel.poder.003_at_mail.ee 2/18/04 9:17:39 AM >>>
> >=3D20
> > > oracle.exe process was 1.4 G per task manager -
> > well under the 2 G
> > > limit.
> >=3D20
> > I've seen problems starting happen when about 1,5G
>=20> Do you Yahoo!?
> __________________________________
>=20 >=20 >=20 > ----------------------------------------------------------------
>=20
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- "The sender believes that this E-Mail and any attachments were free of = any virus, worm, Trojan horse, and/or malicious code when sent. This = message and its attachments could have been infected during = transmission. By reading the message and opening any attachments, the = recipient accepts full responsibility for taking proactive and remedial = action about viruses and other defects. The sender's business entity is = not liable for any loss or damage arising in any way from this message = or its attachments." ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Feb 18 2004 - 14:10:04 CST
 |
 |