as long as we keep to shared servers, users are not
complaining.
Pd
> > > > "Koivu, Lisa " <Lisa.Koivu@(protected) >
> 2/18/04 1:12:43 PM > > >
> Hello Jeffrey,
>
> I 'm feeling your pain, like you wouldn 't believe.
>
> 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.
>
> 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.
>
> 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
>
> -- --Original Message-- --
> From: Jeffrey Beckstrom
> [mailto:JBECKSTROM@(protected)]
> 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 > > >
> >
> > > oracle.exe process was 1.4 G per task manager -
> > well under the 2 G
> > > limit.
> >
> > 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 "?
> >
> > Tanel.
> >
> >
> > > 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
> > >
> > >
> >
>
> __ ____ ____ ____ ____ ____ ______
> Do you Yahoo!?
> Yahoo! Mail SpamGuard - Read only the mail you want.
> http://antispam.yahoo.com/tools
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> 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
>
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
>
>
>
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> 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
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
__ ____ ____ ____ ____ ____ ______
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
