Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamic SGA and pinned
"Jack" <none_at_noe.com> wrote in message news:LNnQc.102$V16.0_at_read3.inet.fi...
> It is just showing so, but it does not use it.
And your evidence for that statement is.... ??
> There are some changes made and the meaning of those has also.
> Sadly some documentation gays are not uptotime in Oracle but some day you
> will get
> *full* wiremodel. (by that time it will already be changed again)
I have no idea what anything in that paragraph means. We'll put it down to English perhaps not being your native language, which is fine. What is not fine is making sweeping statements such as "Although it shows it, it isn't actually doing it" without *any* supporting evidence whatsoever.
I, on the other hand, can post you figures and screen captures indicating a massive amount of swapping going on for a machine where sga_max_size is set larger than physical RAM, indicating (to me at least) that Oracle is indeed trying to make use of that memory.
Stick to specifics, please. And evidence.
I have shown you a 'total SGA' allocation increasing, according to SQL*Plus' 'show sga' command. (I can also show you that via Windows' Task Manager, if you'd prefer). What is your evidence that the memory shown as being allocated to the SGA is not actually allocated, as you claim?
HJR Received on Thu Aug 05 2004 - 07:09:13 CDT