Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: large uga/pga and scan rates

Re: large uga/pga and scan rates

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Mon, 11 Dec 2000 01:18:22 -0800 (PST)
Message-Id: <10707.124166@fatcity.com>


Hi,

The pga memory is not fixed (I am talking if you're not using MTS).

The process will take what it needs until it reaches the OS limit. I had a similar case on Oracle 8.0.4/HP 10.20 with a function in a select. The select was bringing back more than 500 000 rows. Oracle was not releasing the memory after the function call.


Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. Received on Mon Dec 11 2000 - 03:18:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US