large_pool_size

[swathi]

In our databaase large_pool_size is set as 52428800 in init parameter
file , but in show parameter large_pool_size it shows as

SQL> show parameter large_pool_size

NAME TYPE VALUE
------------------------------------ -----------
------------------------------
large_pool_size big integer 58720256


where did the difference of 6291456 ie 6MB bytes go??

[sampath]

You must be using SPFILE.

create pfile from spfile....
check the value...

[swathi]

Hi
spfile is not being used.

when 'create pfile from spfiles' is issued, it gives

SQL> CREATE PFILE FROM SPFILE;
CREATE PFILE FROM SPFILE
*
ERROR at line 1:
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

-swathi

[sampath]

Have you changed this parameter at instance level.Means scope=memory

or
r u using any specific pfile.

In both cases bounce the db an check the values