Through structure tuning, Oracle Expert uses database user information to verify that these tablespaces have the attributes necessary for optimum performance. System Oracle Expert uses the system information and the physical characteristics of the hardware where the instance is running to evaluate optimal parameter settings. For example, Oracle Expert uses the Total Memory attribute in conjunction with the Memory Utilization attributes to assess the SGA, memory, and configuration for each instance. Logical Devices Oracle Expert uses logical device information to obtain location, performance rating, disk size, percent available, and disk type of each logical device. Workload Applications Workload data describes to Oracle Expert the nature, frequency, and importance of transactions that access the database.
Importance is the value assigned to a workload element.
Note that frequency and importance affect the recommendations given by Oracle Expert. Application You can edit the importance of an application. An application is the workload category at the top of the workload hierarchy. You can edit the frequency, importance, and cycle of the business unit. A business unit is the workload category below the Application level in the workload hierarchy.