Yosi, here is the output from v$parameter and
v$system_parameter. As far as I was aware, ismodified will be non-false if an
alter session or alter system command has been carried out. isadjusted will be
non-false if Oracle has dynamically adjusted the parameter.
Show SGA has the following output...
SQL> show sga
Total System Global Area
11953420 bytes
Fixed Size 70924 bytes Variable Size 9756672 bytes Database Buffers 2048000 bytes Redo Buffers 77824 bytes So the Shared pool and redo buffers are
still way higher than expected. I have read some documentation on metalink that
says the java_pool_size will be a minimum of 32k, regardless of what you
set in the init.ora, but as I have set it to 0 in the init.ora I would
expect isadjusted to show true.
Metalink also says that if you set
log_buffer too low, Oracle will increase it to 4 times the platform specific
maximum block size, but even that seems to bear no resemblence to what is going
on!!!
Anyone else shed any light on
this???
SQL> l
1 SELECT name, 2 value, 3 isdefault, 4 ismodified, 5 isadjusted 6 FROM v$system_parameter 7* WHERE name IN ('shared_pool_size','java_pool_size','log_buffer','large_pool_size') SQL> / NAME
VALUE ISDEFAULT ISMODIFI ISADJ
---------------- ---------- --------- -------- ----- shared_pool_size 4951040 FALSE FALSE FALSE large_pool_size 614400 FALSE FALSE FALSE java_pool_size 32768 FALSE FALSE FALSE log_buffer 32768 FALSE FALSE FALSE SQL> SELECT name,
2 value, 3 isdefault, 4 ismodified, 5 isadjusted 6 FROM v$parameter 7 WHERE name IN ('shared_pool_size','java_pool_size','log_buffer','large_pool_size') 8 / NAME
VALUE ISDEFAULT ISMODIFIED
ISADJ
---------------- ---------- --------- ---------- ----- shared_pool_size 4951040 FALSE FALSE FALSE large_pool_size 614400 FALSE FALSE FALSE java_pool_size 32768 FALSE FALSE FALSE log_buffer 32768 FALSE FALSE FALSE |