Re: Oracle connections and memory usage
From: Vincent D'Antonio (dantoniov_at_GMAIL.COM)
Date: 11/10/05
- Previous message: Hunter, Mark: "Re: Oracle connections and memory usage"
- In reply to: Hunter, Mark: "Re: Oracle connections and memory usage"
- Next in thread: Hunter, Mark: "Re: Oracle connections and memory usage"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 10 Nov 2005 10:08:13 -0500 To: aix-l@Princeton.EDU
Here is the requested info:
minperm = 388872
maxperm = 777747
maxclient% = 10
SGA is set to 16GB, there are no other appl. running on this system just
oracle.
out put of svmon -U is hugh but here is the beginning of the output:
===============================================================================
User Inuse Pin Pgsp Virtual LPageCap
oracle8 5695786 89342 68764 5751820 -
...............................................................................
SYSTEM segments Inuse Pin Pgsp Virtual
65554 65541 1 65555
Vsid Esid Type Description LPage Inuse Pin Pgsp Virtual
0 0 work kernel segment (lgpg_vsid=0) Y 65536 65536 0 65536
12b8a4 - work - 11 3 1 12
2739cf - work - 7 2 0 7
...............................................................................
EXCLUSIVE segments Inuse Pin Pgsp Virtual
5621614 22340 68628 5677608
Numbers don't lie and I agree with you that I should be able to get my 1500
connections no problem but the system seems to disagree with me on this,
maybe I am missing a process that is using more memory than being reported
but I couldn't find anything.
Thanks again for you suggestions,
Vince
On 11/10/05, Hunter, Mark <Mark.Hunter@anheuser-busch.com> wrote:
>
> More information please.
> What are your vmo minperm%, maxperm%, and maxclient%? Hopefully you have
> tuned these already.
> How big is the oracle SGA? Most oracle DBA like to set these really large.
> What other application run on the box?
> What does svmon -U using your RAM?
> Based upon your numbers, 7MB * 1500 connection = 10.5GB of RAM, so you
> should have plenty.
>
*Mark Hunter*
> Anheuser-Busch Cos.
> MIS Consultant, ES&SO Server Planning and Integration
> (Office: (314) 632-6663
> ÊFax: (314) 632-6901
> ?Pager: (314) 841-4026
> *Email: Mark.Hunter@Anheuser-Busch.com
>
> The information transmitted (including attachments) is covered by the
> Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is intended
> only for the person(s) or entity/entities to which it is addressed and may
> contain confidential and/or privileged material. Any review, retransmission,
> dissemination or other use of, or taking of any action in reliance upon,
> this information by persons or entities other than the intended recipient(s)
> is prohibited. If you received this in error, please contact the sender and
> delete the material from any computer.
>
>
> ------------------------------
> *From:* IBM AIX Discussion List [mailto:aix-l@Princeton.EDU] *On Behalf Of
> *Vincent D'Antonio
> *Sent:* Thursday, November 10, 2005 8:13 AM
> *To:* aix-l@Princeton.EDU
> *Subject:* Oracle connections and memory usage
>
> AIXer's,
> I have a P570 8way with 32GB of memory running oracle 10G. Per my DBA each
> connection to the database is sucking up 7MB of memory which after a while
> we start to swap, this is about 800 connections and need we to support a lot
> more than this (1500).
> Is there anything that I can tune to improve memory usage or is there
> anything within oracle that can be tuned? I have AIX 5.3 ML2 no lpars just
> a full system.
> Any info to help this would be great.
> Thanks in advance for your comments and suggestions,
> Vince
>
- Previous message: Hunter, Mark: "Re: Oracle connections and memory usage"
- In reply to: Hunter, Mark: "Re: Oracle connections and memory usage"
- Next in thread: Hunter, Mark: "Re: Oracle connections and memory usage"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
- Re: ORA-04031 with Collections and SGA Settings
... I am working with a data warehouse using an Oracle 10g R1 database. ... SGA
MAX SIZE: 5904 MB ... The database server is also configured as a shared server. ...
Do the settings for the SGA raise any questions/comments/concerns? ... (comp.databases.oracle.server) - Re: ORA-04031 with Collections and SGA Settings
... I am working with a data warehouse using an Oracle 10g R1 database. ...
SGA MAX SIZE: 5904 MB ... Do the settings for the SGA raise any questions/comments/concerns?
... (comp.databases.oracle.server) - ORA-04031 with Collections and SGA Settings
... I am working with a data warehouse using an Oracle 10g R1 database. ...
SGA MAX SIZE: 5904 MB ... Do the settings for the SGA raise any questions/comments/concerns?
... (comp.databases.oracle.server) - Re: slow migration path
... Increase sga, to match processes, db_buffer_size, sga target ... Does not look
like it is the culprit; filling up the parent ... But the point is that inserting
... Puget Sound Oracle Users Group ... (comp.databases.oracle.server) - Re: Oracle benchmark
... But if you say SGA ... manyu reasons for the traditional Oracle database
... dollars tuning TCP benchmarks to get minute performance gains. ... you need
to study the Parallelism apabilities of Oracle very carefully. ... (comp.databases.oracle.server)