Good point Niall.. I will investigate.=20
However, with the nature of the application, I'm guessing that will be
another bottleneck. Right now we are cpu bound. However, when we move
this db to a bigger environment, RAC or not, I think all those
connections will provide the throughput it's after. =20
If my thinking is all wrong, please say so. My head is very cloudy
right now.
Lisa
-----Original Message-----
From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk]=20
Sent: Thursday, February 19, 2004 4:47 AM
To: oracle-l_at_freelists.org
Subject: RE: ora-12500 on windows
Is it possible for Informatica itself to do connection pooling (after
all e=3D
ven ODBC can do this :( )
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805=3D20
> Hello Jeffrey,=3D3D20
>=3D20
> I'm feeling your pain, like you wouldn't believe.=3D3D20
>=3D20
> I think it's note 225349.1
>=3D20
> 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. =3D3D20
>=3D20
> To make this more interesting, I am guaranteed that in the=3D20
> future there
> will be several hundred more concurrent connections added to what I'm
> dealing with now. =3D3D20
>=3D20
> Can anyone comment - can MTS help in my situation? I've=3D20
> never used it.
>=3D20
>=3D20
> Any comments or suggestions are welcome.
>=3D20
> Lisa Monkey
> Orlando, FL, USA=3D3D20
>=3D20
> -----Original Message-----
> From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org]=3D3D20
> Sent: Wednesday, February 18, 2004 12:55 PM
> To: oracle-l_at_freelists.org; discgolfdba_at_yahoo.com
> Subject: Re: ora-12500 on windows
>=3D20
> we are w2k AS. Do you know the metalink note for large=3D20
> memory support?
> >>> discgolfdba_at_yahoo.com 2/18/04 11:11:20 AM >>>
> --- Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:
> > mem usage
>=3D20
> familiar territory.
>=3D20
> 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?
>=3D20
> 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.
>=3D20
> 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.
>=3D20
> 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
>=3D20
> hth.
>=3D20
> Pd
>=3D20
> > 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 >>>
> >=3D3D20
> > > oracle.exe process was 1.4 G per task manager -
> > well under the 2 G
> > > limit.
> >=3D3D20
> > 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"?
> >=3D3D20
> > Tanel.
> >=3D3D20
> >=3D3D20
> > > 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
> > >
> > >
> >=3D3D20
>=3D20
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail SpamGuard - Read only the mail you want.
> http://antispam.yahoo.com/tools=3D3D20
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=3D3D20
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org=3D3D20
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/=3D3D20
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html=3D3D20
> -----------------------------------------------------------------
>=3D20
>=3D20
>=3D20
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>=3D20
> "The sender believes that this E-Mail and any attachments=3D20
> were free of =3D3D
> any virus, worm, Trojan horse, and/or malicious code when sent. This
=3D3D
> message and its attachments could have been infected during =3D3D
> transmission. By reading the message and opening any=3D20
> attachments, the =3D3D
> recipient accepts full responsibility for taking proactive=3D20
> and remedial =3D3D
> action about viruses and other defects. The sender's business=3D20
> entity is =3D3D
> not liable for any loss or damage arising in any way from=3D20
> this message =3D3D
> or its attachments."
>=3D20
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>=3D20
>=3D20
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_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
-----------------------------------------------------------------
"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 Thu Feb 19 2004 - 07:50:34 CST
