Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Get the OS Process ID from the SID for a Database session

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    Get the OS Process ID from the SID for a Database session

    set pages 1000
    set linesize 190
    col username for a10
    select b.status,a.inst_id,a.PID "Ora PID",a.SPID "Server PID",
    a.LATCHWAIT,b.Program, b.Username,b.Osuser,b.machine,
    b.terminal,a.terminal,b.Process "Client Process"
    from gv$process a,gv$session b where a.addr=b.paddr and b.sid=&1
    /

+ Reply to Thread

Similar Threads

  1. How to trace a Database session?
    By amite.kr in forum Database Performance Management,Database Links,Materialized Views
    Replies: 2
    Last Post: 09-13-2012, 09:21 PM
  2. SQL Text for a Particular Session SID/ users current sql
    By Hemant in forum Database Scripts
    Replies: 0
    Last Post: 11-02-2011, 07:39 PM
  3. Replies: 0
    Last Post: 11-02-2011, 07:29 PM
  4. Retrieving Concurrent Request Id from the Session SID
    By Hemant in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 10-31-2011, 10:07 PM
  5. SID (Session Id) and SPID (OS Process Id) for a Concurrent Request
    By Hemant in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 10-31-2011, 08:07 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics