Skip Headers
Oracle® Real User Experience Insight User's Guide
Release 6.5.1 for Linux x86-64

Part Number E18053-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

Q GUI Performance Enhancements

This appendix describes how you can improve the performance of the Reporter user interface by increasing the Degree of Parallelism (DOP) setting.

Q.1 Introduction

Within the Reporter user interface, the performance of queries (such as refreshing a dashboard or retrieving data within the Data Browser) is heavily influenced by the specified Degree of Parallelism (DOP) setting. This regulates the maximum number of parallel queries that may be made to the database. By default, this is two. In the case of deployments where the Reporter system has substantially more CPUs than this default, or where a dedicated database server is being used, a considerable user interface performance improvement can be realized by increasing the DOP setting.

Q.2 Modifying the DOP Setting

The DOP is controlled by the dp_gui_dop entry within the uxs_config table. Upon installation, this entry does not exist in the database. Do the following:

  1. Logon to the Reporter system, and issue the following commands as the root user:

    # su - moniforce
    # sqlplus /@uxinsight
  2. To assign an initial value to the DOP, issue the following commands:

    SQL> INSERT INTO uxs_config (ID,CATEGORY,NAME,VALUE,OPTIONS) values(uxs_config_seq.nextval,'wi_core','db_gui_dop','N','type=bool;');

    Alternatively, to modify a previously specified value, issue the following commands:

    SQL > EXIT

    where N specifies the degree of parallelism used for queries within the Reporter interface. Note that this should be less than the number of cores within the database system.