workarea_size_policy being ignored

From: <tdwilsonng_at_yahoo.com>
Date: 21 Dec 2004 06:56:04 -0800
Message-ID: <1103640964.485974.301620@c13g2000cwb.googlegroups.com>

I ran a benchmark last week on an AIX server using 10g 64-bit using the following parameters:

sga_target=4000M
workarea_size_policy=manual
sort_area_size=524000
sort_area_retained_size=524000

However, according to V$PGASTAT and the OS, the PGA was using over 16GB of RAM for 2000 dedicated processes. This is the same amount that it used when I set workarea_size_policy to AUTO. So it looks like the workarea_size_policy is being ignored and Oracle is sucking up all of the memory on the server and some that's not there, too. Why can't I limit the memory usage?

Thanks,

Tom Received on Tue Dec 21 2004 - 08:56:04 CST