Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
CHAPTER 10: PeopleTools Performance Util... > Performance Tuning the Performance M...
Performance Tuning the Performance Monitor
As the volume of data collected by Performance Monitor builds up, you may see some SQL performance problems with some parts of Performance Monitor. I have used Performance Trace on the self-monitoring Performance Monitor to resolve these issues, with the following recommendations.14
__________
Indexes
I recommend changing and adding indexes as shown in Listing 10-27, to improve the performance of some of the queries generated by the delivered analytic components.
Listing 10-27. Custom Indexes for Performance Monitor
CREATE INDEX PSDPSPMEVENTHIST ON PSPMEVENTHIST
(PM_EVENT_DEFN_SET, PM_EVENT_DEFN_ID, PM_AGENTID, PM_AGENT_DTTM)
TABLESPACE PSINDEX ... PCTFREE 1 COMPRESS 3
/
CREATE INDEX PSCPSPMTRANSHIST ON PSPMTRANSHIST
(PM_TRANS_DEFN_SET,PM_TRANS_DEFN_ID, PM_PERF_TRACE,PM_METRIC_VALUE7)
TABLESPACE PSINDEX ... PCTFREE 1 COMPRESS 4
/
CREATE INDEX PSDPSPMTRANSHIST ON PSPMTRANSHIST
(PM_TOP_INST_ID, PM_TRANS_DEFN_SET, PM_TRANS_DEFN_ID)
TABLESPACE PSINDEX ... PCTFREE 1 COMPRESS 3
/
CREATE INDEX PSPPSPMTRANSHIST ON PSPMTRANSHIST
(PM_TRANS_DEFN_SET, PM_TRANS_DEFN_ID, PM_CONTEXT_VALUE1, PM_MON_STRT_DTTM)
TABLESPACE PSINDEX … PCTFREE 0 COMPRESS 3
/