|Oracle® Real User Experience Insight User's Guide
Release 6.5.1 for Linux x86-64
Part Number E18053-01
This appendix describes how you can improve the performance of the Reporter user interface by increasing the Degree of Parallelism (DOP) setting.
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.
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:
Logon to the Reporter system, and issue the following commands as the
# su - moniforce # sqlplus /@uxinsight
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;'); SQL> EXIT
Alternatively, to modify a previously specified value, issue the following commands:
SQL> UPDATE UXS_CONFIG SET VALUE='N' WHERE NAME='db_gui_dop' SQL > EXIT
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.