How To find Vendor details for LINUX servers

Login as root user in to the Linux Server where you want to verify the vendor details and use following command to get the details.

# dmidecode | grep Product

Eg:
Product Name: Sun Fire X4100 Server

How to find free memory in Linux server

Following commands can be used for finding the memory usage in the server.

Display free memory size in MB:
$ free -m

Displays a line containing the totals memory in MB:
$ free -t -m

Type vmstat command at shell prompt:
$ vmstat

Type top command at shell prompt:
$ top

How to Clear the Application Server Cache Without Shutting it Down

For deleting the appserver server cache, normally we bring down the application server services and delete the contents under $PS_HOME/appserv/{DOMAIN_NAME}/CACHE directory. Following workaround can be used for this complicated process by invalidating the current cache by using the following command.

Connect to Oracle as PeopleSoft Schema user.
SQL> UPDATE PSSTATUS SET LASTREFRESHDTTM = SYSDATE;
SQL> Commit;

How to export PeopleSoft Project Compare Report Results into excel file

PeopleSoft Administration Troubleshooting Tips

1. How to export peoplesoft compare report into an excel sheet.

Execute following SQL Query in Source Database to get the peoplesoft compare report results for the specified project.

----------------------------------------------------------------------
SELECT distinct objecttype, objectvalue1, objectvalue2, sourcestatus, targetstatus, upgradeaction
FROM psprojectitem
WHERE projectname = 'Replace COMPARE_PROJECT_NAME here'
AND sourcestatus in (4,5)
ORDER BY objecttype, objectvalue1;
----------------------------------------------------------------------
Results of the above query can be exported into an excel sheet for further analysis.