How to monitor connections to PeopleSoft Database

by Prashant on February 6, 2018

in Database, PeopleSoft Administration

Ever wondered how many users are connected to PeopleSoft database? This is different than users who login into PeopleSoft application via web.

You can find users who make direct SQL connection with your PeopleSoft database. This includes anyone using SQL client tool, PeopleSoft development tools and connections made by PeopleSoft server such as application server & process scheduler.

Below SQL is applicable for PeopleSoft Application running on Oracle DB.

— Monitor database connections to PeopleSoft
set linesize 200
select p.spid,
substr(s.osuser,1,10) osuser,
substr(s.username,1,8) username,
substr(s.program,1,24) program,
substr(s.client_info,1,60) ClientInfo
from v$session s, v$process p
where s.paddr=p.addr
and s.osuser is not null
order by s.osuser;

Following db connections will be shown by above SQL:

  • SQL Client connections such as Toad, SQL Developer etc.
  • PeopleSoft 2-tier login such as Application Designer, Data Mover etc.
  • Connections made by processes on Application Server and Process scheduler
  • Any other process/service connected to database

You can filter the results to find users who are connected to PeopleSoft application using Application Designer(2-tier). Here is how.

— Find users who are connected to PeopleSoft application using Application Designer
set linesize 200
select p.spid,
substr(s.osuser,1,10) osuser,
substr(s.username,1,8) username,
substr(s.program,1,24) program,
substr(s.client_info,1,60) ClientInfo
from v$session s, v$process p
where s.paddr=p.addr
and s.osuser is not null
and s.program=’pside.exe’
order by s.osuser;

Similarly you can modify the SQL to change ‘program‘ field to filter for other programs such as datamover, toad etc.

Also Read:  How to Install Micro Focus Net Express 5.1 Wrap Pack 11

{ 0 comments… add one now }

Leave a Comment

Previous post:

Next post: