-
large pool problem
I am running 9.1.0.3 using shared servers. I can't understand why there are that much bytes free in large pool since I have just 300 MB set.
???
SQL> select * from v$sgastat where pool = 'large pool' and name = 'free memory';
POOL NAME BYTES
----------- -------------------------- ------------------------------------
large pool free memory 18446744073700129912
SQL> show parameter large_pool_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
large_pool_size string 314572800
Any ideas?
F.
-
Should be the same or less than the pool size. Does anyone know of an error situation like ora-600 that can result such values in v$sgastat?
I would bounce the database and see what happens.