В документации про large_pool_size написано:
Parameter type Big integer
Syntax LARGE_POOL_SIZE = integer [K | M | G]
Default value 0 if both of the following are true:
n The pool is not required by parallel execution
n DBWR_IO_SLAVES is not set
Otherwise, derived from the values of PARALLEL_MAX_
SERVERS, PARALLEL_THREADS_PER_CPU, CLUSTER_
DATABASE_INSTANCES, DISPATCHERS, and DBWR_IO_
SLAVES.
Parameter class Dynamic: ALTER SYSTEM
Range of values 300 KB to at least 2 GB (actual maximum is operating
system-specific)
LARGE_POOL_SIZE lets you specify the size (in bytes) of the large pool allocation
heap. The large pool allocation heap is used in shared server systems for session
memory, by parallel execution for message buffers, and by backup processes for
disk I/O buffers. (Parallel execution allocates buffers out of the large pool only
when PARALLEL_AUTOMATIC_TUNING is set to true.)
Параметры, упомянутые выше:
SQL> select name, value from v$parameter where name in
2 ('parallel_max_servers','parallel_threads_per_cpu','cluster_database_instances',
3 'dispatchers','dbwr_io_slaves','large_pool_size','backup_tape_io_slaves','parallel_automatic_tu
ning')
4 ;
NAME VALUE
------------------------------ ------------------------------
large_pool_size 4194304
dbwr_io_slaves 0
backup_tape_io_slaves FALSE
cluster_database_instances 1
dispatchers
parallel_max_servers 0
parallel_threads_per_cpu 0
parallel_automatic_tuning FALSE
SQL> select name, value from v$spparameter where name in
2 ('large_pool_size')
3 ;
NAME VALUE
------------------------------ ------------------------------
large_pool_size 307200
Непонятно почему по-умолчанию параметр large_pool_size равен 4Mb, в то время как все параметры от которых он зависит выставлены в 0, FALSE. И явная установка large_pool_size в spfile (300Kb) игнорируется?