Import into 11g
I will be importing Oracle 9.2.0.8 database's data into 11.2.0.1
I guess 11g takes all the memory settings since it has automatic memory management.
Does increasing PGA_AGGREGATE_TARGET value make import faster?
My OS Memory is: 32GB
Current 11g parameter values:
SGA_max_size=25 GB
memory_target= 25 GB
sort_area_size=65536
-------------------------------------------------------------------------------------------------------------------------------------------------
SHOW PARAMETER TARGET
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 0
memory_max_target big integer 27447525376
memory_target big integer 27447525376
parallel_servers_target integer 32
pga_aggregate_target big integer 0
sga_target big integer 0