Is it possible for Informatica itself to do connection pooling (after all even ODBC can do this :( )
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805
> Hello Jeffrey,=20
>
> I 'm feeling your pain, like you wouldn 't believe.=20
>
> I think it 's note 225349.1
>
> My problem that is resulting in ora-12500 (See ora-12500.ora-code.com) '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. =20
>
> To make this more interesting, I am guaranteed that in the
> future there
> will be several hundred more concurrent connections added to what I 'm
> dealing with now. =20
>
> Can anyone comment - can MTS help in my situation? I 've
> never used it.
>
>
> Any comments or suggestions are welcome.
>
> Lisa Monkey
> Orlando, FL, USA=20
>
> -- --Original Message-- --
> From: Jeffrey Beckstrom [mailto:JBECKSTROM@(protected)]=20
> Sent: Wednesday, February 18, 2004 12:55 PM
> To: oracle-l@(protected); discgolfdba@(protected)
> Subject: Re: ora-12500 (See ora-12500.ora-code.com) on windows
>
> we are w2k AS. Do you know the metalink note for large
> memory support?
> > > > discgolfdba@(protected) 2/18/04 11:11:20 AM > > >
> --- Jeffrey Beckstrom <JBECKSTROM@(protected) > wrote:
> > mem usage
>
> familiar territory.
>
> 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?
>
> 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.
>
> 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.
>
> 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
>
> hth.
>
> Pd
>
> > 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@(protected) 2/18/04 9:17:39 AM > > >
> >=20
> > > oracle.exe process was 1.4 G per task manager -
> > well under the 2 G
> > > limit.
> >=20
> > 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 "?
> >=20
> > Tanel.
> >=20
> >=20
> > > 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
> > >
> > >
> >=20
>
> __ ____ ____ ____ ____ ____ ______
> Do you Yahoo!?
> Yahoo! Mail SpamGuard - Read only the mail you want.
> http://antispam.yahoo.com/tools=20
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> To unsubscribe send email to: oracle-l-request@(protected)=20
> put 'unsubscribe ' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/=20
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html=20
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
>
>
>
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> To unsubscribe send email to: oracle-l-request@(protected)
> 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@(protected)
> 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
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
>
>
**********************************************************************
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
