Hi all,
I just installed Oracle version 11.1.0.6 on an older CentOS server (kernel 2.6.9-78.0.1.ELsmp). I do not have the MEMORY_TARGET set in my pfile and was wondering what the best setting would be:
df -h
3.9G 3.4M 3.9G 1% /dev/shm
SQL> show parameter max
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
license_max_sessions integer 0
license_max_users integer 0
log_archive_max_processes integer 4
max_commit_propagation_delay integer 0
max_dispatchers integer
max_dump_file_size string unlimited
max_enabled_roles integer 150
max_shared_servers integer
memory_max_target big integer 0
object_cache_max_size_percent integer 10
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_max_servers integer 0
result_cache_max_result integer 5
result_cache_max_size big integer 0
sec_max_failed_login_attempts integer 10
session_max_open_files integer 10
sga_max_size big integer 208M
SQL> show sga
Total System Global Area 217157632 bytes
Fixed Size 2142976 bytes
Variable Size 159386880 bytes
Database Buffers 50331648 bytes
Redo Buffers 5296128 bytes
I am getting some ORA-04031 errors in my alert_log when trying to run statistics.
(text from trace file: begin dbms_stats.gather_table_stats...)
PFILE:
triton.__db_cache_size=1946157056
triton.__java_pool_size=16777216
triton.__large_pool_size=16777216
triton.__oracle_base='/usr/local/oracle'#ORACLE_BASE set from environment
triton.__pga_aggregate_target=1677721600
triton.__sga_target=2499805184
triton.__shared_io_pool_size=0
triton.__shared_pool_size=503316480
triton.__streams_pool_size=0
*.audit_file_dest='/usr/local/oracle/admin/triton/adump'
*.audit_trail='db'
*.compatible='11.1.0.0.0'
*.control_files='/usr/local/oracle/oradata/triton/control01.ctl','/usr/local/ora cle/oradata/triton/control02.ctl','/usr/local/oracle/oradata/triton/control03.ct l'
*.db_block_size=8192
*.db_domain=''
*.db_name='triton'
*.db_recovery_file_dest='/usr/local/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.diagnostic_dest='/usr/local/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=tritonXDB)'
*.open_cursors=300
*.processes=150
*.undo_tablespace='UNDOTBS1'
Edited by: 964470 on Feb 19, 2013 6:10 PM