on 12-12-2011 10:34 AM
Hello,
Recently we were running low on space on /oracle/SID/sapdata1
But, we added now 300GB, and the the FS is at 75%.
In SAP I still see the DB still at the 95% usage.
After increasing the FS, should I modify anything in SAP so that the DB can be seen also at 75% usage ?
Or it is normal ? and the DB will take the needed space from /sapdata1 ?
I am a little bit confused.
Thank you
Hi Jordy,
But, we added now 300GB, and the the FS is at 75%.
In SAP I still see the DB still at the 95% usage.
After increasing the FS, should I modify anything in SAP so that the DB can be seen also at 75% usage ?
Incase your file system usage is 75% does not imply that your database usage is also 75%. By adding space in the file system you have created expansion space for your database. After the db stat report has got executed you have see the updated fill level or free space in your allocated db space.
This is a normal behaviour that unless the db statistics report is run either manuall or automatically, you may not see updated information db02 transaction code.
Hope this information is useful.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak.
>
> So, I executed RSORACOLR -> Oracle monitoring: DB02 collector.
> I also refreshed in db02old.
>
> But the size is still the same,
>
> Total number 7
> Total size/kb 936,040,272
> Total free/kb 48,045,760 5 %
> Minimum free/kb 7,616
> Max. autoextensible/kb Unlimited
>
> Not sure, if it is OK or not.
This is OK. By extending the file system you have allotted more space so that database and ultimately the tablespace can 'grow' - utilizing the 'more' free space available on file system - gradually with time/weeks/months.
Database size will grow gradually with 'work'.
Thanks
Hi Jordy,
In case you refresh using db02old, you can see updated information in the same transaction. Hope you are doing the same way.
As per your information
Total size/kb 936,040,272 - This is the current allocated space for your database and not your file system.
In case you add a datafile of 20 GB above value will change and hence the free % will also change.
Regards,
Deepak Kori
Edited by: deepakkori on Dec 12, 2011 4:41 PM
Gentlemen,
Thank you for the answers, you have calmed me down, because I was not sure.
I thought that the DB size will be the same as the FS size, of course which is ilogical. I am sorry.
The next question though, is ... starting next year there will be a much more bigger workload on the DB, so the DB will grow with aprox 100GB / month.
In this case, should I change anything ? Should I change the datafile size for extension ?
Or not needed ? and it will happen more often with the same size ?
Thanks again
Hi Jordy,
It means that you will need 100 * 12 = 1.200 Gb more storage area, in the next year. So, If you create all the datafiles at the beginning of the year, you need 1200 / 32 (Gb) = 37 datafiles. You can check the note 129439 for the maximum file sizes with the Oracle.
At this stage, I can suggest you that you create all datafiles with 10 Gb initial size and set next value 5 Gb next extend size on the newly created datafiles with 32 gb maxsize per datafile. By doing so, if you are not taking backups by using RMAN (incremental backup), backup times will not be increased at the beginning of the year. It will be at the peak value at the end of this year.
Additionally, if you choose to create datafiles with autoextend option, do not set small value. Otherwise, you may face with the performance problems, because of the fragmentation.
Many strategies can be planned about this issue, regarding your underlying technical landscape and company policy. This is my personal point of view.
Best regards,
Orkun Gedik
Edited by: Orkun Gedik on Dec 12, 2011 5:48 PM
The following sql would give you the used space
select sum(bytes)/1024/1024/1024 from dba_segments;
The following sqls would provide you total space allocated.
select sum(USER_BYTES)/1024/1024/1024 from dba_data_files;
+
select sum(USER_BYTES)/1024/1024/1024 from dba_temp_files;
The addition of filesystem space does not mean the space is allocated to the database i.e data files are not extended . You need not worry on this , as autoextend tablespace would extend the datafiles by claiming space from the filesystem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please extend the table space. Also to get the database size refreshed in GUI go to t-code db02old and give the refresh to get the size updated.
Regards
Mukunthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Did you refresh the DB stats?
Tcode DB02 -> Press F8. Wait for job to get over and recheck.
Regards,
Srikishan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.