Performance Profile Schedule Customization > Customize the Performance Profile Schedule
  
Version 10.2.01P10
Customize the Performance Profile Schedule
To customize the time period for profiling the collected performance data, take the following steps.
1. On the Portal server, go to the database procedures directory.
Windows: C:\opt\oracle\database\stored_procedures\srm
Linux: /opt/aptare/database/stored_procedures/srm
2. Edit the script: setup_srm_jobs.plb.
3. Note the parameters shown in red and modify them accordingly.
jobNo := dba_package.getDatabaseJobID('srm_array_perf_report_pkg.recalIntPerformanceProfile');
IF (jobNo IS NOT NULL AND jobNo != 0) THEN
DBMS_OUTPUT.put_line('srm_array_perf_report_pkg.recalIntPerformanceProfile exists and will first be removed before adding a new version');
DBMS_JOB.REMOVE(jobNo);
END IF;
DBMS_JOB.SUBMIT(
job => jobNo,
what => 'srm_array_perf_report_pkg.recalIntPerformanceProfile(dateRangeType(null,null,null,SYSDATE-2/24, SYSDATE, null, 0));',
next_date => SYSDATE + (3/24),
interval => 'TRUNC(SYSDATE+1,''DD'') + (10/24)');
DBMS_OUTPUT.put_line('srm_array_perf_report_pkg.recalIntPerformanceProfile set to run on daily at 10am');
COMMIT;
Three hours after a Portal Installation or Upgrade, this job runs for the first time. See the parameter: (SYSDATE + (3/24))
After the first run, this job will run at 10:00 a.m. every day. See the parameter: (TRUNC(SYSDATE+1, "DD") + (10/24)
This Performance Profiler will calculate the last two hours of statistics. See the parameter: SYSDATE-2/24
4. Execute the following command to activate your new schedule:
su - aptare
sqlplus portal/portal @setup_srm_jobs.plb