数据库(SID=RMDB)
AIX下(数据库实例)initRMDB.ora存放路径:
/oracle/product/10.2.0/db_1/dbs/initRMDB.ora
-----------------------------------------------------------------
initRMDB.ora文件内容:
SPFILE='/oracle/oradata/RMDB/spfileRMDB.ora'
-----------------------------------------------------------------
initRMDB.ora文件内容:如下
AIX下(数据库实例)spfileRMDB.ora存放路径:
/oracle/oradata/RMDB/spfileRMDB.ora
-----------------------------------------------------------------
spfileRMDB.ora文件内容:如下
RMDB.__db_cache_size=67108864
RMDB.__java_pool_size=4194304
RMDB.__large_pool_size=4194304
RMDB.__shared_pool_size=125829120
RMDB.__streams_pool_size=0
*.background_dump_dest='/oracle/admin/RMDB/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/rmdata/RMDB/RMDB_control_01.ctl','/rmdata/RMDB/RMDB_control_02.ctl'
*.core_dump_dest='/oracle/admin/RMDB/cdump'
*.cursor_sharing='SIMILAR'
*.db_block_size=8192
*.db_domain=''
*.db_files=1024
*.db_name='RMDB'
*.job_queue_processes=5
*.max_dump_file_size='10240'
*.open_cursors=500
*.optimizer_mode='first_rows'
*.pga_aggregate_target=100663296
*.pre_page_sga=TRUE
*.processes=150
*.session_cached_cursors=500
*.sga_target=209715200
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/oracle/admin/RMDB/udump'
-----------------------------------------------------------------
Oracle数据库系统参数配置
目的:修改sga_max_size、sga_target、job_queue_processes参数的值
sga_max_size=1536m
sga_target=1536m
job_queue_processes = 10
执行步骤:
(1) 修改spfile文件,将RMDB的存储初始参数修改为下面的值:
sga_max_size=1536m
sga_target=1536m
job_queue_processes = 10
操作步骤如下:
① 切换到oracle用户
su - oracle
② 进入RMDB实例
export ORACLE_SID=RMDB
③ 以sysdba进入到sqlplus
sqlplus /nolog
conn /as sysdba
④ 执行下列命令修改spfile:
alter system set sga_max_size=1536m scope=spfile;
alter system set sga_target=1536m scope=spfile;
alter system set job_queue_processes=10 scope=spfile;
⑤ 修改完毕后重启数据库实例,确认sga_max_size、sga_target改动生效。调整后(以sysdba进入到sqlplus)查询sga_max_size和sga_target大小:
(2) 根据实际情况调整datafile文件(数据文件)的可扩展性,执行以下语句:
SQL>ALTER DATABASE DATAFILE '/rmdata/RMDB/RMDB_UNDOTBS1_01.dbf'
AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;
(3) 根据实际情况调整TEMP文件名(临时表空间)的大小和可扩展性,执行以下语句:
SQL>ALTER DATABASE TEMPFILE '/rmdata/RMDB/RMDB_TEMP_01.dbf' resize 6144M;
SQL>ALTER DATABASE TEMPFILE ' /rmdata/RMDB/ RMDB_TEMP_01.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;