如果你管理的SAP DB是ORACLE,看到TABLESPACE的使用率有達到99%。
我建議還是調整一下,把使用率降到85%以下吧~
雖然,SAP的DB通常有 autoextend 的機制,但一直讓DB去做autoextend,再處理資料I/O。
總是效能差了一些,不是嗎?
出處:https://forums.sme.sap.com/thread.jspa?messageID=8664551
You can consider the following Factors for measuring the FileSystem capacity planning and requirement to hold datafiles of tablespace.
1. Current Size of the Datafiles associated with Tablespace
Showing Disk Volumes with BR*Tools
Showing Tablespaces with BR*Tools
Showing Data Files with BR*Tools
2. Autoextend -If it is set to yes, the new data file is created autoextensible. In this case, maxsize and incrsize will paly an important role for the capacity planning
3.maxsize -For autoextensible data files, this parameter specifies the maximum size in MB up to which the data file can be increased.
4.incrsize - For autoextensible data files, this parameter specifies the size in MB, by which the data file is automatically increased when necessary.
補充:
https://forums.sme.sap.com/message.jspa?messageID=6120835
台股大盤表現
3 天前
沒有留言:
張貼留言