cancel
Showing results for 
Search instead for 
Did you mean: 

How can I increase the parameter db_files

Former Member
0 Kudos

Hi,

When I am trying to add a new data file to Tablespace it is giving error.

1. How can I increase the parameter db_files?

Sap Version is: 4.7E and Database is: 0racle 9.2.0

Thanks&Regards,

Nani

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member603052
Contributor
0 Kudos

Hi Nani,

You should analyze first why the datafile is not getting added and it is not good to just blindly increase db_files size. First paste the error what you got when adding a datafile.

Regards,

Kalyan

Former Member
0 Kudos

You can do this by 2 ways.

1. Using SQL

2. Using BR*tools

1.Using SQL

sqlplus / as sysdba

SQL> show parameter db_files

SQL> alter system set db_files = 500 scope = spfile;

SQL> shutdown immediate

SQL> startup

SQL> show parameter db_files

SQL> exit

2. BR*Tools> Select 1.Instance management>here select Option 4. Alter DB Parameter-->Select DB_FILES & give new value & press continue

You need to take a DB restart after this change.

Also please check SAP Note 972539 - Core Dump with GATHER_FIXED_OBJECTS_STATS. It may help you.

Thanks,

Sushil

former_member603052
Contributor
0 Kudos

Hi Nani,

Post the error which is shown when you are adding a new datafile.

Regards,

Kalyan

Former Member
0 Kudos

hello nani

1. connect to database

SQL> show parameter db_files

NAME TYPE VALUE

-


-


-


db_files integer 200

SQL> alter system set db_files=350 scope=spfile;

System altered.

SQL> show parameter db_files

NAME TYPE VALUE

-


-


-


db_files integer 200

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 264241152 bytes

Fixed Size 1248476 bytes

Variable Size 176161572 bytes

Database Buffers 79691776 bytes

Redo Buffers 7139328 bytes

Database mounted.

Database opened.

SQL> create pfile from spfile;

File created.

SQL> show parameter db_files

NAME TYPE VALUE

-


-


-


db_files integer 350

SQL>

Edited by: Shishir Bajpai on Mar 3, 2009 12:38 PM