on 08-31-2010 5:53 AM
Hi,
In my IDES ERP 6.0 EHP4 system, I have noticed that the tablespace PSAPSR3 is marked 'NO' in AUTOEXTEND colume in DBACockpit.
However, each datafile of this table space is autoexend enabled, the maxsize is 10GB and extend is 20MB per step.
I have no idea why the tablespace is marked as NOT AUTOEXTEND but datafiles are.
Please suggest.
Thanks a lot.
Regards,
Alex
Hi, try to check ths size and maxsize of all datafiles are same?
However, each datafile of this table space is autoexend enabled
All datafiles? Are you check all ?
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I have noticed that the tablespace PSAPSR3 is marked 'NO' in AUTOEXTEND colume in DBACockpit.
The following could be the reason for this...
After the installation there are 14 data files for tablespace PSAPSR3
As u have 14 datafiles for the tablespace PSAPSR3, if any one of the datafiles is set to autoextend OFF, the tablespace in turn will be shown as autoextend OFF. So, u need to check whether all the datafiles are of Autoextend ON.
Hope this clarifies.
Regards,
Varadharajan M
Hi, this is my another account.
I have checked that the size and max. size of all datafiles of tablespace PSAPSR3 are same.
Tablespace name | Size(MB) | Free(MB) | Used(%) | Autoextend | Total size(MB) |
PSAPSR3 | 150.000,00 | 9.863,06 | 93 | NO | 150.000,00 |
File name | File Id | Tablespace name | Size(MB) | #Blocks | Status | Rel. file number | Autoextensible |
|D:\ORACLE\ECT\SAPDATA1\SR3_1\SR3.DATA1 |4 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|4 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_2\SR3.DATA2 |5 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|5 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_3\SR3.DATA3 |6 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|6 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_4\SR3.DATA4 |7 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|7 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_5\SR3.DATA5 |8 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|8 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_6\SR3.DATA6 |9 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|9 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_7\SR3.DATA7 |10 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|10 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_8\SR3.DATA8 |11 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|11 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_9\SR3.DATA9 |12 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|12 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_10\SR3.DATA10|13 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|13 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_11\SR3.DATA11|14 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|14 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_12\SR3.DATA12|15 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|15 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_13\SR3.DATA13|16 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|16 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_14\SR3.DATA14|17 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|17 |YES
|D:\ORACLE\ECT\SAPDATA1\SR3_15\SR3.DATA15|33 |PSAPSR3 |10.000,00 |1.280.000 |AVAILABLE|33 |YES
Please suggest.
Regards,
Alex
Edited by: QiAlexLi on Aug 31, 2010 1:39 PM
I have checked that the size and max. size of all datafiles of tablespace PSAPSR3 are same.
As i'm say before " AGAIN " if size and maxsize are same the Db02 shows for tablespace autoextend to NO ...
And rightly so, because not one of them can no longer grow
Try for example add new data file size 5 GB AND maxsize to 10GB, after in DB02 press refresh and wait until all datasets are
refreshed. After relogin in DB02 and check your tablespace autoextend will be set to YES.
Regards.
User | Count |
---|---|
83 | |
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.