check SQL/file to see process

1. 
   

SQL

To see what PS related process is doing to the DB, check MODULE & ACTION on v$sql.

Online: 
MODULE  = Component, ACTION = Page (run under PSAPPSRV)

Process:  
MODULE  = PSAE(clientinfo=User), ACTION = PS Process (PRCSNAME) (run under PSAESRV)

Program: 
MODULE  = PSAPPSRV/Toad/psae/sqr/PSAESRV(clientinfo=PRCS)

ACTION=NULL (these log into DB directly)

To see what PS Server process is running a Process Instance:

• pidof PSAESRV
• grep 'Session ID $PID'  SCHDLR_MMDD.LOG

File

To see what file is being used by PS:

1. lsof filename: get PID

2.

• grep $PID SCHDLR_MMYY.LOG: if PRCS jobs
• /proc/$PID/fd: if server process

    to see where file is accessed at

•  /proc/$PID/fdinfo: 

1. pos:    328724480 (offset); flags:  0100000 (read)
2. pos:    10072244224        ; flags:  0100001 (write)