Large pool size memory

[Flyrc]

Large pool size
set in init.ora
large pool size =1M
after startup, and query large pool, why free memory is so big? (4294247976)

SQL> select * from v$sgastat
2 where pool='large pool';

POOL NAME BYTES
----------- -------------------------- ----------
large pool free memory 4294247976
large pool PX msg pool 122880
large pool session heap 596440

But when i use OEM to check, it is correct showing 1MB.

WHY?

 

[sybaseguru]

flyrc,

very interesting, according to your display you have:

select 4294247976/1024/1024 from dual;

4294247976/1024/1024
--------------------
            4095.314

That is you have more than 4GB of free large pool. If you are running Oracle 32-bit this will be more than the max shared memory you can get from O/S. Could you do a show sga and send the output please.

 

[Flyrc]

Dear Sybaseguru,

SQL> Show SGA;

Total System Global Area 202141568 bytes
Fixed Size 282496 bytes
Variable Size 125829120 bytes
Database Buffers 75497472 bytes
Redo Buffers 532480 bytes

I can not understand why v$sgastat has that result?

 

[sem]

I suppose that you view (edit) wrong init.ora file. Thus the value you see is the DEFAULT one calculated by Oracle according to your MTS_DISPATCHERS, PARALLEL_MAX_SERVERS (and probably some other) parameters. Try to issue

show parameter large

Regards, Dima

 

[Flyrc]

show parameter large;

large_pool_size string 1048576

This is the right number setting in my init.ora, also from OEM i have the same result.

Why v$sgastat gives wrong answer? (i logon / as sysdba)

Yeh, i would like to know how oracle collects the
SGA statistics.