5 Monitor Domain Performance

The MFP Cloud Service Administrator can use various tools provided by RPASCE OAT tasks to monitor domain performance. While the environment is live, RPASCE OAT tasks provide the Administrator great flexibility to control the domain from the MFP Cloud Service application front end.

The major tasks which can be useful for the Administrator in day to day activity to check on the domain are described in this chapter.

This chapter provides the name and overview about the tasks which are useful for monitoring/optimizing domain performance. The detailed steps and descriptions for the tasks are documented in the Oracle Retail Predictive Application Server Cloud Edition Administration Guide.

System Administration tasks:

Optimize Domain: Optimize domain to improve performance and free up space.
Reindex Domain: The Reindex Domain task is used to compress, increase, or decrease the set of physical address spaces (or indexes) of the multidimensional arrays.
Scan Domain: The Scan Domain utility is a domain utility used for detecting data loss and repairing data corruption in an RPASCE database.
Fix Domain: The Fix Domain utility is to detect different types of corruption that occur within a domain.

Additional System Administration task that can be helpful in gathering domain information:

Domain Information: Provides miscellaneous details about a domain.

Service Request Administration tasks:

Start Oracle OS Watcher: Start the Oracle OS Watcher to gather OS metrics for performance analysis.
Stop Oracle OS Watcher: Stop the running of the Oracle OS Watcher.

Configured Batch task:

Clean up Task: This task is provided to clean up the processed files or unprocessed files from different cloud service locations to be run by the retailer on an on-need basis.

Optimize Domain

The Optimize Domain utility is used to improve performance and minimize the space required by the domain data.

Because the RPASCE Btree dimension arrays undergo continuous updates and changes as a result of adding and deleting existing positions, over time, measure arrays become full of stale data. This stale data is created when positions are deleted, but the associated index remains. This results in wasted space and inefficient operations. The measure arrays containing any data for these positions must be updated to reflect these deletions. Deleting positions marks the hierarchy data for the corresponding dimensions as changed, but it does not clean up the associated data from the measure arrays. The Optimize Domain utility cleans this stale data from the measure arrays. For details about the Optimize Domain online administration tasks, see the Oracle Retail Predictive Application Server Cloud Edition Administration Guide.

Reindex Domain

The Reindex Domain task is used to compress, increase, or decrease the set of physical address spaces (or indexes) of the multidimensional arrays. The process of compressing and defragmenting the physical IDs makes the domain load and run faster. The reindexing options let you reindex the entire domain, dimensions within a hierarchy, or a specified list of dimensions, and also prepend calendar dimension positions. For details about the Reindex Domain online administration tasks, see the Oracle Retail Predictive Application Server Cloud Edition Administration Guide.

Scan Domain

The Scan Domain utility is a domain utility used for detecting data loss and repairing data corruption in an RPASCE database. Data loss occurs when an RPASCE process is abnormally terminated. This can happen when an external mechanism, such as a power failure, causes a sudden termination of an RPASCE process. Data loss can also occur due to an unexpected program breakdown.

Data corruption can occur if an external program modifies the RPASCE database files or an unforeseen defect occurs in the processes using the RPASCE database (an extremely rare event).

The Scan Domain utility can detect both corruption and data loss, but it can only fix corruption. This utility can operate on global, non-partitioned, and local domains. It supports parallelization when repairing databases in a domain.

For details about the Scan Domain online administration tasks, see the Oracle Retail Predictive Application Server Cloud Edition Administration Guide.

Fix Domain

The Fix Domain online administration utility is used to detect many types of corruption that can occur within an RPASCE domain. This utility can be used to perform a number of tasks, which are described in this section. In all cases, Fix Domain can execute to perform an examination to detect problems. The following major tasks are performed by the Fix Domain task utility:

Remove Inconsistent Measure Attributes
Remove Partially Unregistered Measures
Repair Discrepancies in Hierarchy Information
Repair Unlinked Arrays

For details about the Fix Domain online administration tasks, see the Oracle Retail Predictive Application Server Cloud Edition Administration Guide.

Domain Information

The Domain Information task is used to provide miscellaneous details about a domain, including type of domain (simple, master, subdomain, or local) and the upgrade and version history of the domain.

For details about the Domain Information online administration tasks, see the Oracle Retail Predictive Application Server Cloud Edition Administration Guide.

Start Oracle OS Watcher

The Start Oracle OS Watcher task is used to collect OS performance metrics with user-specified parameters. When the task ends, the collected data is packaged in a tar file named as osw_archive_<timestamp>.tar. The collected data, along with other profile data or logs, is used to help Oracle Support diagnosis performance issues of the RPASCE applications.

For details about the Start Oracle OS Watcher online administration tasks, see the Oracle Retail Predictive Application Server Cloud Edition Administration Guide.

Stop Oracle OS Watcher

The purpose of this task is to stop the running OS Watcher before its duration ends. When the Stop Oracle OS Watcher task starts, it will immediately stop the running OS Watcher task, and package the collected data in a tar file, the same way the Start Oracle OS Watcher task does at the end of its duration.

Clean up Task

This task is provided to clean up the processed files or unprocessed files from different cloud service locations to be run by the retailer on an on-need basis. This task has three options to select the locations to clean up when this task is scheduled.

For details about the Clean Up task, see "Clean Up Task."