title: How to check Oracle internal process?
body: <p>I want to know what oracle internal process is running for the below session details.</p>
  
  <p>How to check what process is being carried out by "<strong>ora_j001</strong>" ?
  Please provide me query to find out the process ?</p>
  
  <pre><code>INST_ID SID SERIAL# USERNAME    OSUSER  MACHINE PROCESS OS Process ID   VALUE   STATUS  LAST_CALL_ET    PROGRAM
  1          1303 13000    APPS   orafin  ARG-FIN1A-DC    3842124 3842124 224905256   ACTIVE  57661   oracle@ARG-FIN1A-DC (J001)
  
  
  
  $ ps -ef | grep 3842124
    orafin 3842124       1   0 18:24:54      -  2:02 ora_j001_FINPROD1
    argora 4395248 4784358   0 10:41:08  pts/6  0:00 grep 3842124
  $ hostname
  ARG-FIN1A-DC
  </code></pre>
  
  <p>In such kind of process how to check whether what kind of oracle internal process is running ?</p>