Requirement: We need to generate SQL Reports with color code formatting. Pre-requisites: 1) Unix Box 2) SQL Developer 3) Basic knowledge of both Shell Scripting and SQL Normally, we need to generate many SQL reports on daily basis and need to monitor them closely. So, if we can add some color code to differentiate error and successful rows. It will…
Category: Siebel Administration
UNIX Shell Script to gather Siebel Server performance data
Sample Code: while true do for pid in `cat pids` do var=`date|cut -d’ ‘ -f4` echo “$var :c” >> ps.log.$pid ps -eo pid,vsz,rss,pcpu,args | grep $pid |grep -v grep >> ps.log.$pid done sleep 30 done Deployment steps: 1.) Deploy this code as ksh file 2.) Create i/p file named as pids including all process ids 3.) The Script can be executed in the…
How To Troubleshoot Memory Leaks in Siebel Server on UNIX
I. Commands The prstat command can be used to gather basic performance data to help identify if there are any processes consuming a large amount of memory. For example, the data below is sorted by the SIZE column. SIZE is the total virtual memory size of the process: prstat -s size The data should be reviewed to see if there are any processes…
How to read FDR files
FDR File Analysis 1. Naming convention for FDR File FDR Files are generated in SIEBSRVR_ROOTbin directory. The file name includes a timestamp and the process id that crashed and is written in the format: T<YYYYMMDDHHMM>_P<process id value>.fdr For example: T200503181601_P001376.fdr 2. How to Convert Binary .fdr File into .csv Format Here are the steps to follow to post process the…