RE: ora-12500 on windows
- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Feb 2004 09:46:40 +0000
Is it possible for Informatica itself to do connection pooling (after all e=
ven ODBC can do this :( )
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805=20
> Hello Jeffrey,=3D20
>=20
> I'm feeling your pain, like you wouldn't believe.=3D20
>=20
> I think it's note 225349.1
>=20
> My problem that is resulting in ora-12500's is many, many connections
> being fired at one time. Informatica fires in the neighborhood of 300
> connections all at the same time, the exact same second. I have tried
> adding multiple listeners, adding the QUEUESIZE parameter, all to no
> avail. I had to reduce the sga size to stop the errors. =3D20
>=20
> To make this more interesting, I am guaranteed that in the=20
> future there
> will be several hundred more concurrent connections added to what I'm
> dealing with now. =3D20
>=20
> Can anyone comment - can MTS help in my situation? I've=20
> never used it.
>=20
>=20
> Any comments or suggestions are welcome.
>=20
> Lisa Monkey
> Orlando, FL, USA=3D20
>=20
> -----Original Message-----
> From: Jeffrey Beckstrom [mailto:JBECKSTROM@xxxxxxxxx]=3D20
> Sent: Wednesday, February 18, 2004 12:55 PM
> To: oracle-l@xxxxxxxxxxxxx; discgolfdba@xxxxxxxxx
> Subject: Re: ora-12500 on windows
>=20
> we are w2k AS. Do you know the metalink note for large=20
> memory support?
> >>> discgolfdba@xxxxxxxxx 2/18/04 11:11:20 AM >>>
> --- Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx> wrote:
> > mem usage
>=20
> familiar territory.
>=20
> on win32, the process memory limit is between 1.7 and
> 1.8 GB of virtual memory. what version of operating
> system is the server running?
>=20
> if it is w2k server, you're stuck. you must reduce
> either the SGA or PGA memory allocations in order to
> stay under the process limit.
> if it is w2k advanced server, you can enable large
> memory support, and carry up to a 3*10E9 (convert to
> power of 2) memory allocated to a process.
>=20
> if is is w2k3 server, you can enable large memory
> support.
> certain versions of Oracle on win32 support large
> memory, and some don't.
> 9.2.0.4 does.
> 8.1.7.3 and 8.1.7.4 do not.
>=20
> to reduce memory allocations, you might:
> - check v$sgastat for free memory, and reduce the size
> of the shared, large and java pools.
> - reduce the buffer cache
> - reduce sort_area_size, hash_area_size
>=20
> hth.
>=20
> Pd
>=20
> > 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@xxxxxxx 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
> > of mem was allocated to
> > oracle.exe... From which task manager column did you
> > check the process size,
> > from "mem usage" or from "vm size"?
> >=3D20
> > Tanel.
> >=3D20
> >=3D20
> > > Swap space is set to max of 4 G
> > > commit charge peak is 2.4 G
> > > commit charge limit is 5.8 G
> > > We should be well under the limits
> > >
> > > Jeffrey Beckstrom
> > > Database Administrator
> > > Greater Cleveland Regional Transit Authority
> > > 1240 W. 6th Street
> > > Cleveland, Ohio 44113
> > >
> > >
> >=3D20
>=20
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail SpamGuard - Read only the mail you want.
> http://antispam.yahoo.com/tools=3D20
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=3D20
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx=3D20
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/=3D20
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html=3D20
> -----------------------------------------------------------------
>=20
>=20
>=20
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>=20
> "The sender believes that this E-Mail and any attachments=20
> were free of =3D
> any virus, worm, Trojan horse, and/or malicious code when sent. This =3D
> message and its attachments could have been infected during =3D
> transmission. By reading the message and opening any=20
> attachments, the =3D
> recipient accepts full responsibility for taking proactive=20
> and remedial =3D
> action about viruses and other defects. The sender's business=20
> entity is =3D
> not liable for any loss or damage arising in any way from=20
> this message =3D
> or its attachments."
>=20
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>=20
>=20
**********************************************************************
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
