Ocm Determine And Set Sizing Parameters For Database Structures Jp
初期化パラメータファイルの作成
# テンプレートinit.oraを処理し、#と空白行を削除する方法ならかなり楽 [oracle@fy ~]$ cd $ORACLE_BASE/admin/$ORACLE_SID/pfile [oracle@fy pfile]$ vi init.ora db_block_size = 4096 db_name = prod sga_target = 300M log_buffer = 2048000 control_files = (/u01/oracle/app/oradata/prod/control01.ctl, /u01/oracle/app/oradata/prod/oradata/control02.ctl) # デフォルト場所で作成 [oracle@fy pfile]$ pwd /u01/oracle/oracle/admin/pfile [oracle@fy dbs]$ vi init$ORACLE_SID.ora ifile=/u01/oracle/oracle/admin/pfile/init.ora
See Also:
OFA
インスタンス起動して、初期化パラメータを確認しサーバ初期化パラメータファイルを作成する
[oracle@fy fy]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 1 11:57:20 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount; ORACLE instance started. Total System Global Area 314572800 bytes Fixed Size 2020448 bytes Variable Size 134220704 bytes Database Buffers 176160768 bytes Redo Buffers 2170880 bytes SQL> create spfile from pfile; File created. SQL> alter system set undo_management=auto scope=spfile; System altered. SQL> alter system set undo_tablespace=undotbs scope=spfile; System altered. SQL> create pfile from spfile; File created. SQL> shutdown immediate; SQL> quit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options [oracle@fy fy]$ cd $ORACLE_HOME/dbs [oracle@fy dbs]$ cat initprod.ora *.control_files='/u01/oracle/oracle/oradata/prod/control01.ora','/u01/oracle/oracle/oradata/prod/control02.ora' *.db_block_size=4096 *.db_name='prod' *.log_buffer=2048000 *.sga_target=300m