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
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
:any single serial session will never get more than 5% of pga_aggregate_target
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
For special cases like that I would switch the
session back to a manual workarea policy and
set a suitable sort area.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T.