on 03-03-2009 6:51 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nani,
Post the error which is shown when you are adding a new datafile.
Regards,
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.