Oracle PeopleSoft SQL Performance Tuning

PeopleSoft Trace Settings

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

Skype Virtual Audio Cable Windows

Playing Music Through Skype Using Virtual Audio Cable

I wanted to be able to play music over Skype. I also wanted to be able to play my keyboard which is currently connected to a Komplete Audio 6 soundcard. I managed to get this working utilising the following setup with Virtual Audio Cable:                         Here are the specific steps to be performed: 1. Create two VAC lines (Line 1 and Line 2) using…

Continue reading

Wordpress

How To: Adding a PeopleSoft PeopleCode Brush to SyntaxHighlighter Evolved

Update: I now use Crayon instead of SyntaxHighlighter Evolved as my blog syntax highlighter. I managed to create a PeopleCode Brush for SyntaxHighlighter Evolved. Feel free to perform the following steps to add the brush to your own blog: 1. Create brush file “shBrushPeopleCode.js” 2. Upload brush file “shBrushPeopleCode.js“ to your WordPress “/wp-content/plugins/syntaxhighlighter/third-party-brushes” folder. 3. Log into WordPress dashboard and click on the Plugins menu link. 4. Select SyntaxHighlighter Evolved from your list of plugins. 5. Edit…

Continue reading