any single serial session will never get more than 5% of pga_aggregate

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Fri, 26 Dec 2003 13:49:26 -0800
Message-ID: <F001.005DB1B0.20031226134926@fatcity.com>

Is there any way to give say 75% of pga_aggregate_target to a single session? The reason I am asking this is - sometimes we need to build an index as soon as possible and the index creating is the only thing running and other applications are stopped waiting for the index.

Thanks,

Roger

-----Original Message-----

Bobak, Mark
Sent: Friday, December 26, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L

Jeffrey,

If you are simply looking at a conversion from 8i to 9iR2, and you're not going to be implementing a bunch of new 9i features (that could affect PGA usage), then it's probably reasonably straightforward. You can look at 'session pga memory' and 'session pga memory max' statistics in V$SESSTAT to get an idea of current PGA memory consumption in 8i. The 'max' statistic is probably more interesting in terms of total aggregate memory consumption. Also, consider that any single serial session will never get more than 5% of pga_aggregate_target. For parallel operations, total is limited to 30%. So, if you have lots of sessions, each with modest requirements, that will not be a factor. If, on the other hand, your database supports just a few connections, and each has significant PGA memory requirements, then you may need to consider that limitation.

Hope that helps,

-Mark

-----Original Message-----

From:	Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org]
Sent:	Fri 12/26/2003 2:34 PM
To:	Multiple recipients of list ORACLE-L
Cc:	
Subject:	pga_aggregate_target

Starting an upgrade project for 8i to 9i R2. How can I come up with a reasonable starting value for the pga_aggregate_target parameter?

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

For technical support please email tech_support_at_dp7uptx.com or you can call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security System.

This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Roger Xu
INET: roger_xu_at_dp7uptx.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Dec 26 2003 - 15:49:26 CST