Dear Gurus,

I executed the following two queries.

SQL> sho parameter LARGE_POOL_SIZE

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
large_pool_size string 15728640

SQL> SELECT NAME, SUM(BYTES) FROM V$SGASTAT WHERE upper( POOL) ='LARGE POOL' GROUP BY ROLLUP (NAME);

NAME SUM(BYTES)
-------------------------- ---------------
free memory 4292128588
session heap 2838708
4294967296

I want to know how is it possible that the free memory is so large, considering the present large_pool_size of 15728640 bytes.

I am using Oracle 9i on W2K box.

Please help..

Regards

Deepak

Oracle LazyDBA home page