Report Interval

In order to configure 15 minutes reporting, use the report_configure_15m.sh script as created below :

This file should be copied into /appl along with all of the other packages.

To configure the 15 minute reporting:

1. The following script content - report_configure_15m.sh located at /appl will do the configuration 15 minutes reporting :

Note : This script is located at /appl

File Content

#!/bin/ksh

# Script to add reporting intervals as per prospect

# should be run as user virtuo before sys_init

export ORACLE_SID=vtdb

echo "UPDATE pm_product_info SET value = 96 WHERE property = 'TimeSlices';" \

| sqlplus "virtuo/<password>"

echo "UPDATE wm_system_value SET value = 5 WHERE variable_id = (SELECT id FROM

wm_system_variable WHERE name = 'MinReportPeriod');" \

| sqlplus "virtuo/<password>"

2. Run the report as following :

virtuo$ ksh report_configure_15m.sh

Note : A reporting interval shorter than 15 minutes is currently not supported