Re: sort area size

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:s9hf5vsb7lf6kui76clmppvdmke7cf1mbn_at_4ax.com...
> On Sat, 22 Feb 2003 18:37:06 +0100, "emerald" <emerald_at_net.hr> wrote:
> BUT... and here's the other thing, whilst the sort area shrinks back
> to zero,
> the memory is NOT returned to the operating system (and the bit of
> Oracle
> documentation that Chuck quoted doesn't say it will be returned to the
> O/S, either). Therefore, you could well get out of memory errors when
> no
> user has any sort area size: because it was *once* allocated.

Hi,

sometime Oracle can give the memory back. We had see it on OS/390. With Oracle 7.3.x you have only one adress-space with 2 GB memory. We had the problem that the database stand still when a lot of user are connected.
Then we look at v$statname lookinng for 'session pga/uga memory' values, compute the sum, add the amount of space from the sga and around 80-100 mb for something else. On the other side we look at the space the database needs on the machine. And with surprise we recognized that we had to compare the actual size of pga and NOT the max values from every session, even our support-man from Oracle was suprised, that the database gave back the memory to the machine and could reuse it for other sessions. The documentation tells something different.
But it seems that it doesn't on other O/S. And today with Oracle 9i and OSDI we can use several adress-spaces, so we get enough space for our users.

Kay Received on Sat Feb 22 2003 - 15:24:52 CST