Oracle Forecasting FAQ

Q1. Which operating systems can this service be performed?

A1. Although technically the method we have developed does not limit the type of operating systems, due to the forecasting data collection tool limitation, this service is however only currently available for Oracle running on Unix including Linux.

Q2. My system is currently experiencing a severe CPU bottleneck. Can we carry out the Oracle Forecasting service?

A2. Forecasting is not suitable for systems in which their CPU (%sys+%usr) utilization averages above 75%. It is advisable to carry out a complete performance tuning exercise to determine the root cause of the high CPU utilization. 

Q3. On the average how long does a typical Oracle Forecasting project take?

A3. Collecting the right set of data that conforms to our Oracle Forecasting methodology is extremely crucial for the success of this service. If that can be quickly achieved, a typical Oracle Forecasting project can take anywhere from 2 weeks to a month.

Q4. Beside forecasting the CPU utilization, can Oracle Memory and I/O utilization and capacity be forecasted?

A4. Yes, for Oracle Memory Forecasting we deploy a Forecasting model called Regression Analysis and for I/O Forecasting we adopt a model called Queueing Theory.

Q5. Can we perform a forecast on a system which is currently experiencing I/O and/or  Memory bottleneck?

A5. It is not advisable to forecast a system which is currently experiencing I/O and/or Memory bottleneck as the result would be extremely unreliable.  It is advisable to carry out a complete performance tuning exercise to determine the root cause of the I/O or Memory contention.