Category: Oracle

Oracle PeopleSoft

PeopleCodeTools – Syntax Highlighting for Sublime Text

By hiojay | by hiojay

I’ve had a few requests from people to document how I use the  PeopleCodeTools syntax highlighter in Sublime Text. Here’s a quick overview. Firstly, the source code is freely available on github, for those that would like to contribute to it. And for those unfamiliar with installing this plugin using Sublime Text, all you need to do is first install Package Control, and then install the ‘PeopleCodeTools’ plugin from Package Control. The plugin should work for PeopleCode…

Continue reading

Oracle PeopleSoft

Extracting the call stack from a PeopleCode trace

By hiojay | by hiojay

I’ve added another tool to the PeopleCodeTools Sublime Text plugin that allows you to extract the call stack from a PeopleCode trace. You can find it on the PeopleCodeTools repository on github along with the syntax highlighters for PeopleCode and PeopleSoft trace files. For those unfamiliar with installing this plugin, please see my previous post: PeopleCodeTools – Syntax Highlighting for Sublime Text This tool only applies to PeopleSoft Trace Files that have at a minimum the following trace…

Continue reading

Oracle PeopleSoft SQL Performance Tuning

PeopleSoft Trace Settings

By hiojay | by hiojay

Update: I have changed this post based on Graham’s recent comments regarding Trace Magic since the trace settings that I recommended were not actually compatible with Trace Magic. Please see the following link for information regarding Trace Magic: https://communities.oracle.com/portal/server.pt?open=514&objID=224&mode=2&threadid=382561 However, when manually reading a trace file (e.g. in Sublime Text, Notepad++, etc.) I would recommend the following trace settings: -TRACE 135 -TOOLSTRACESQL 31 -TOOLSTRACEPC 4044 I still find these settings useful for non-performance related debugging issues.

Continue reading

Oracle PeopleSoft Windows

Identifying the cause of high CPU utilisation for process oracle.exe on a Windows environment

By hiojay | by hiojay

I was running a PeopleSoft Application Engine process that I suspected was hogging the CPU on a Windows environment. I wanted to see whether this process was in fact the cause of the CPU intensive activities on the database. Interestingly, I discovered that on a Windows environment, an Oracle instance is composed of one oracle.exe process with many different threads. Each thread represents either a background process (PMON, SMON, etc.) or a foreground user session.…

Continue reading