How can I determine whether the general database performance can be optimized?
You can use transaction ST03 or ST03N to determine the extent to which accesses to the Oracle database are involved in the overall response time. This portion is determined by using the “Database time” column and should not exceed 40% of the overall response time. Furthermore, the value for “Time/User call” can be determined in transaction ST04. Experience indicates that values of more than 15ms show room for improvement. In individual cases, however, the value can be much higher due to the inclusion of special idle events, and this limits the relevance of this data.
Related Questions
- Under what circumstances can the Cisco WAPMS database miss network performance data, and how can I prevent this from occurring?
- Under what circumstances can the Cisco WAPMS database miss network performance data, and how can I prevent this from occurring?
- What is the impact on database performance of turning on all the new database manageability features?
- How can I determine whether the general database performance can be optimized?
- Where can I find BW-specific information about database performance?
- Where can I find BW-specific information about database performance?
