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
[oracle@fy dbs]$ vi init$ORACLE_SID.ora

See Also:


[oracle@fy fy]$ sqlplus / as sysdba
SQL*Plus: Release - 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 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@fy fy]$ cd $ORACLE_HOME/dbs
[oracle@fy dbs]$ cat initprod.ora