oracle修改db_files大小

切换至oracle用户

[root@tgsdb ~]# su –oracle

在oracle用户下，以sqlplus/ as sysdba 登陆

[oracle@tgsdbdatabase]$sqlplus / as sysdba

 SQL*Plus: Release11.2.0.3.0 Production on Thu Oct 31 16:43:53 2013

Copyright (c)1982, 2011, Oracle.  All rights reserved.

 Connected to:

Oracle Database11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With thePartitioning, OLAP, Data Mining and Real Application Testing options

 SQL> showparameter db_files;

 

 NAME                                 TYPE        VALUE

----------------------------------------------- ------------------------------

db_files                             integer     200

SQL> altersystem set db_files=1024 scope=spfile;

 System altered.

SQL> shutdownimmediate;

Database closed.

Databasedismounted.

ORACLE instanceshut down.

SQL> startup

ORACLE instancestarted.

 Total SystemGlobal Area 2505338880 bytes

Fixed Size                  2230952 bytes

Variable Size             553649496 bytes

DatabaseBuffers         1929379840 bytes

Redo Buffers               20078592 bytes

Database mounted.

Database opened.

SQL> showparameter db_files;