Opinionated Software

… we have opinions about everything!

Archive for the ‘Tuning’ Category

PSTREENODE Clustered Index Change —

I noticed that in PT 8.55 (well at least in .08 and later) that the PeopleTools meta-data for the Clustered Index on PSTREENODE lost the “clustered” attribute. I’m not sure why this was changed but you should be aware that this change could impact your execution plans – especially if you use row level security. […]

Weblogic Java VM Memory Parameters —

When increasing the Java VM memory parameters for a PeopleSoft system under Weblogic (either in setEnv.cmd or manually by editing the cmdline registry entry if that’s your “thing”), be very careful not to increase the -XX:MaxPermSize memory allocation too much. In fact I would leave it at 128MB or perhaps 256MB. Whatever you do, don’t […]

RC_BACKLOG_VW in PeopleSoft CRM 9.1 —

Seriously? Who thought it would be a good idea to create a view to return the DISTINCT list of BUSINESS_UNIT from RC_CASE? Talk about an O (n) performance disaster. What’s wrong with a SELECT BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_RC WHERE EXISTS (… case sub-query….). Oh look … Two index seeks … shocker! It scales too …. wow […]

_WA_Sys Stats or Hand Crafted? —

SQL Server generates histogram statistics automatically whenever a column is referenced in a predicate and it is not already the leading column in an existing histogram statistic. By design, indexes create histogram statistics automatically so any column you have that is the leading column in an index will already have histogram statistics. The autogenerated statistics […]